کپی و درج در دو بانک متفاوت از یکدیگر(روی هاست و روی سیستم در برنامه)

[mahan206]

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();
دوستان ممنون میشم راهنمایی کنید

[mahan206]

این تیکه اخرشم اینجور نوشتم بازم ارور دارم اما خب درج میشه چندتا رکوردش ولی همه نه
SqlConnection connectI = new SqlConnection(ConfigurationManager.ConnectionStrin gs["conectapp"].ToString());
while (drw.Read()) {
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 users VALUES (" + drw["nam"] + "," + drw["usr"] + "," + drw["pass"] + "," + drw["shahrestan"] + "," + drw["mantaghe"] + "," + drw["vaziat"] + "," + drw["admin_user"] + ")", connectI);
connectI.Open();
cmd3.ExecuteNonQuery();
}
connectI.Close();
دوستان درج میشه همش ولی اخرش این ارور رو دارمcmd3.ExecuteNonQuery();

[mahan206]

مشکل حل شد تشکر
" + drw["nam"] + "
این قسمت ها باید اینجور باشن
'" + drw["nam"] + "'