数据库异常,弄了一天了,帮忙解决一下!谢了
Tekiy 2006-02-02 11:11:41 using System;
using System.Data;
using System.Data.SqlClient;
namespace ConsoleApplication1
{
class Class1
{
static void Main(string[] args)
{
SqlConnection thisConn = new SqlConnection("server=CHINA-P82LHZ9IM;database=bank;uid=sa;pwd=hotechong");
SqlDataAdapter thisAdapter = new SqlDataAdapter("SELECT * FROM bank",thisConn);
SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);
DataSet thisDataSet = new DataSet();
thisAdapter.Fill(thisDataSet,"Bank");
foreach(DataRow theRow in thisDataSet.Tables["Bank"].Rows)
Console.WriteLine(theRow["client"]+""+theRow["gold"]);
Console.WriteLine();
thisDataSet.Tables["Bank"].Rows[4]["client"] = "冯陈良";
Console.WriteLine(thisDataSet.Tables["Bank"].Rows[4]["client"]);
thisAdapter.Update(thisDataSet,"Bank");
}
}
}
运行后为什么出现异常:
System.InvalidOperationException:对于不返回任何键列信息的SelectCommand不支持UpdateCommand 的动态SQL生成。