มีวิธีนำคิวรี่ Insert , Select มาใช้กับ button เพื่อส่งไปยัง base ยังไงครับ

            Connecsql.connnectsql();
            SqlConnection conA = new SqlConnection(Connecsql.strcon);
            {
                using (SqlCommand command1 = new SqlCommand())
                {
                    command1.Connection = conA;
                    command1.CommandText = "insert into process_daily ( process_date , mem_id , order_no , shr_sum_amt , shr_count , contact_no , capital_bal , type_id , sub_id ) ( select '2017-10-25' , T1.mem_id , T2.row_id , (case when T2.row_id = 1 then T2.shr_sum_amt else 0 end ) , (case when T2.row_id = 1 then T2.shr_count else 0 end ) , T2.contact_no , T2.capital_bal , T2.type_id , T2.sub_id from mem_member T1 , ( select row_number() over(partition by m.mem_id order by m.mem_id ) as row_id , m.mem_id , s.shr_sum_amt , s.shr_count , l.contact_no , l.capital_bal , l.type_id , l.sub_id from mem_member m left join shr_member s on m.mem_id = s.mem_id and s.shr_sum_amt > 0 left join loan_contact l on m.mem_id = l.mem_id and l.capital_bal > 0 ) T2 where T1.mem_id = T2.mem_id )";
                    conA.Open();
                    command1.ExecuteNonQuery();
                    conA.Close();