2个回答
展开全部
using (SqlConnection connection = new SqlConnection("连接字符串"))
{
using (SqlCommand command = new SqlCommand("UPDATE [表名] SET [列名] = 值", connection))
{
connection.Open();
command.ExecuteNonQuery();
}
}
改数据库里的,很危险,不要轻易用
{
using (SqlCommand command = new SqlCommand("UPDATE [表名] SET [列名] = 值", connection))
{
connection.Open();
command.ExecuteNonQuery();
}
}
改数据库里的,很危险,不要轻易用
追问
列里面的值要循环输出呢!
追答
using (SqlConnection connection = new SqlConnection("连接字符串"))
{
using (SqlCommand command = new SqlCommand("SELECT [列名] FROM [表名]", connection))
{
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Console.WriteLine("{0}", reader.GetValue(0));
}
}
}
}
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询