代码不太整齐,重新贴一下!未处理的"System.NullReferenceException"类型的异常出现在DataBaseTest.exe中
其他信息:未将对象引用设置到对象的实例.
private void button1_Click(object sender, System.EventArgs e)
{
string runpath=System.Environment.CurrentDirectory;
string strCon = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source=D:\\printaccount.mdb";//数据库连接串
//创建一个新的OleDbConnection
OleDbConnection prnConn=new OleDbConnection();
prnConn.Open();
OleDbDataAdapter prnAda=new OleDbDataAdapter("Select * from 客户资料1 order by 客户编号",prnConn);
DataSet myds=new DataSet();
prnAda.Fill(myds,"myID");
dataGrid1.SetDataBinding(myds,"myID");
prnAda.InsertCommand.CommandText="Insert into 客户资料1(客户资料,客户全称,法人代表) Values('003','电灯厂','小林')";
prnAda.InsertCommand.Connection=prnAda.SelectCommand.Connection;
prnConn.Close();
prnAda.Dispose();
}
其他信息:未将对象引用设置到对象的实例.
private void button1_Click(object sender, System.EventArgs e)
{
string runpath=System.Environment.CurrentDirectory;
string strCon = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source=D:\\printaccount.mdb";//数据库连接串
//创建一个新的OleDbConnection
OleDbConnection prnConn=new OleDbConnection();
prnConn.Open();
OleDbDataAdapter prnAda=new OleDbDataAdapter("Select * from 客户资料1 order by 客户编号",prnConn);
DataSet myds=new DataSet();
prnAda.Fill(myds,"myID");
dataGrid1.SetDataBinding(myds,"myID");
prnAda.InsertCommand.CommandText="Insert into 客户资料1(客户资料,客户全称,法人代表) Values('003','电灯厂','小林')";
prnAda.InsertCommand.Connection=prnAda.SelectCommand.Connection;
prnConn.Close();
prnAda.Dispose();
}
prnAda.InsertCommand没有被实例化就被使用了.添加一句 prnAda.InsertCommand = new OleDbCommand();在下面的前面.prnAda.InsertCommand.CommandText="Insert into 客户资料1(客户资料,客户全称,法人代表) Values('003','电灯厂','小林')";BTW,你写这个程序好奇怪啊,产生了有一个InsertCommand,却不update.
楼上大哥,是不是一定要InsertCommand后面update一下,我现在确实没有加入到数据库中,你能告诉我如何做吗?
QQ:51129127
myds.AcceptChanges();