shining friends中文:c#修改数据库

来源:百度文库 编辑:高考问答 时间:2024/05/08 10:10:42
static void Main(string[] args)
{
string sql = "server=(local);database=tree;uid=cms;pwd=cms";
SqlConnection sqlcon = new SqlConnection(sql);
sqlcon.Open();

SqlDataAdapter sqldata = new SqlDataAdapter("select id, age from name", sqlcon);

SqlCommandBuilder sqlcom = new SqlCommandBuilder(sqldata);
sqldata.UpdateCommand = new SqlCommand();

DataSet data = new DataSet();

sqldata.Fill(data, "name");

DataRow thisRow = data.Tables["name"].Rows[1];
Console.WriteLine("{0}", thisRow["id"]);
thisRow["id"] = "005";
Console.WriteLine("{0}", thisRow["id"]);
sqldata.UpdateCommand.CommandText = "";
sqldata.Update(data, "name");
Console.WriteLine("{0}", thisRow["id"]);
sqlcon.Close();
Console.ReadLine();
}

还是报错,能帮忙看看吗
ExecuteReader: CommandText 属性尚未初始化

我这里编译是通过的..

有时候VS是有这样的问题,你重新把这些代码敲一边或许就好了.这个是没有理由的办法.