ghameshloe
چهارشنبه 17 شهریور 1389, 12:36 عصر
با سلام به همهی دوستان
مشکل این کد چیه
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrin gs["smsdb13890617con"].ConnectionString);
SqlCommand cmd = new SqlCommand("SELECT MAX([idrolswg]+1) FROM [rolworkgroup]", con);
con.Open();
int result =(int) cmd.ExecuteScalar();
con.Close();
Label1.Text = result.ToString();
SqlCommand cmd1 = new SqlCommand("SELECT [namepage] FROM [rolpageworkgroup]", con);
SqlDataReader datareader;
con.Open();
datareader = cmd1.ExecuteReader();
while (datareader.Read())
{
string page = datareader["namepage"].ToString();
SqlCommand cmd2 = new SqlCommand("insert into [rolpageworkgroup] (idrolswg,namepage,state) values (@idrolswg,@namepage,False)", con);
cmd2.Parameters.AddWithValue("@idrolswg", result);
cmd2.Parameters.AddWithValue("@namepage", page);
cmd2.ExecuteNonQuery();
}
con.Close();
}
مشکل این کد چیه
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrin gs["smsdb13890617con"].ConnectionString);
SqlCommand cmd = new SqlCommand("SELECT MAX([idrolswg]+1) FROM [rolworkgroup]", con);
con.Open();
int result =(int) cmd.ExecuteScalar();
con.Close();
Label1.Text = result.ToString();
SqlCommand cmd1 = new SqlCommand("SELECT [namepage] FROM [rolpageworkgroup]", con);
SqlDataReader datareader;
con.Open();
datareader = cmd1.ExecuteReader();
while (datareader.Read())
{
string page = datareader["namepage"].ToString();
SqlCommand cmd2 = new SqlCommand("insert into [rolpageworkgroup] (idrolswg,namepage,state) values (@idrolswg,@namepage,False)", con);
cmd2.Parameters.AddWithValue("@idrolswg", result);
cmd2.Parameters.AddWithValue("@namepage", page);
cmd2.ExecuteNonQuery();
}
con.Close();
}