从数据库里取出数据,显示相应控件里
从数据库里取出数据,显示相应控件里,并插入到另一张数据表,请知道的指点一下,最好举个例子,小妹不盛感激,谢谢语言c# 数据库sql sever 2000 --------------------编程问答-------------------- using (SqlConnection conn = DBHelper.GetConn())
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
textbox1.Text= (int)dr["Id"];
}
dr.Close();
conn.Close();
}
--------------------编程问答-------------------- SqlConnection conn = new SqlConnection(""));
SqlDataAdapter myAdapter = new SqlDataAdapter();
SqlCommand myCommand = new SqlCommand("",conn);
myAdapter.SelectCommand = "";
SqlCommandBuilder myCommandBuilder = new SqlCommandBuilder(myAdapter);
myAdapter.Update(ds);
--------------------编程问答-------------------- 那不就是分2步走的?
1读取数据绑定显示控件
2数据写入另外一个表内
补充:.NET技术 , ASP.NET