在asp.net中处理多个SQL查询 [英] handling multiple sql queries in asp.net

问题描述

嗨

我试图在我的Web表单页面中执行两个sql语句.第一个语句正在执行而第二个语句正在执行.在这种情况下，有人可以帮助我吗?代码在这里

Hi

I tried executing two sql statements in my web form page .First statement is executing leaving the second . Can anybody help me in this case. code goes here

<pre lang="cs">protected void Button1_Click(object sender,EventArgs e)
   {
       con.Open();
       cmd = new SqlCommand("insert into user_events(user_id) select MAX(R_id)+1 from users", con);
       cmd.ExecuteNonQuery();
       cmd = new SqlCommand("update user_events set Event_id=1", con);
       cmd = new SqlCommand("insert into marriage_info(u_e_id) select MAX(id)+1 from user_events", con);
       

       Response.Redirect("Default2.aspx");
   }

推荐答案

protected void Button1_Click(object sender,EventArgs e)
   {
       con.Open();
       cmd = new SqlCommand("insert into user_events(user_id) select MAX(R_id)+1 from users", con);
       cmd.ExecuteNonQuery();
       cmd = new SqlCommand("update user_events set Event_id=1", con);
cmd.ExecuteNonQuery();
       cmd = new SqlCommand("insert into marriage_info(u_e_id) select MAX(id)+1 from 
user_events", con);
cmd.ExecuteNonQuery();       
 
       Response.Redirect("Default2.aspx");
   }

try like this

Hope It will help you

这篇关于在asp.net中处理多个SQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！