mahan206
شنبه 30 خرداد 1394, 15:47 عصر
SqlConnection connectSW = new SqlConnection(ConfigurationManager.ConnectionStrin gs["conectweb"].ToString());
SqlCommand cmdSW = new SqlCommand("select * from users", connectSW);
connectSW.Open();
SqlDataReader drw = cmdSW.ExecuteReader();
drw.Read();
//////////////حالا اطلاعاتی که از هاست برداشتم رو باید اینسرت کنم مشکلم اینجاست؟؟
SqlConnection connectI = new SqlConnection(ConfigurationManager.ConnectionStrin gs["conectapp"].ToString());
//SqlCommand cmd3 = new SqlCommand("INSERT INTO users (nam,usr,pass,shahrestan,mantaghe,vaziat,admin_use r) VALUES (" + drw["nam"] + "," + drw["usr"] + "," + drw["pass"] + "," + drw["shahrestan"] + "," + drw["mantaghe"] + "," + drw["vaziat"] + "," + drw["admin_user"] + ")", connectI);
SqlCommand cmd3 = new SqlCommand("INSERT INTO tb20_newscat VALUES (" + drw["nam"] + "," + drw["usr"] + "," + drw["pass"] + "," + drw["shahrestan"] + "," + drw["mantaghe"] + "," + drw["vaziat"] + "," + drw["admin_user"] + ")", connectI);
connectI.Open();
cmd3.ExecuteNonQuery();
connectI.Close();
دوستان ممنون میشم راهنمایی کنید
SqlCommand cmdSW = new SqlCommand("select * from users", connectSW);
connectSW.Open();
SqlDataReader drw = cmdSW.ExecuteReader();
drw.Read();
//////////////حالا اطلاعاتی که از هاست برداشتم رو باید اینسرت کنم مشکلم اینجاست؟؟
SqlConnection connectI = new SqlConnection(ConfigurationManager.ConnectionStrin gs["conectapp"].ToString());
//SqlCommand cmd3 = new SqlCommand("INSERT INTO users (nam,usr,pass,shahrestan,mantaghe,vaziat,admin_use r) VALUES (" + drw["nam"] + "," + drw["usr"] + "," + drw["pass"] + "," + drw["shahrestan"] + "," + drw["mantaghe"] + "," + drw["vaziat"] + "," + drw["admin_user"] + ")", connectI);
SqlCommand cmd3 = new SqlCommand("INSERT INTO tb20_newscat VALUES (" + drw["nam"] + "," + drw["usr"] + "," + drw["pass"] + "," + drw["shahrestan"] + "," + drw["mantaghe"] + "," + drw["vaziat"] + "," + drw["admin_user"] + ")", connectI);
connectI.Open();
cmd3.ExecuteNonQuery();
connectI.Close();
دوستان ممنون میشم راهنمایی کنید