C#与数据库问题 这段代码怎么不能为数据库添加记录啊...............:( MyAdapter.Fill(MyDataTable);------>MyAdapter.Fill(MyDataSet,"test"); 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 MyAdapter.Fill(MyDataTable);------ >MyAdapter.Fill(MyDataSet, "test "); 试过了,没用啊.................. 不看了,看看我这个吧!sqlCon.Open(); string sql_string="select * from t_renshxx";System.Data.SqlClient.SqlCommand command=new SqlCommand(sql_string,sqlCon);System.Data.SqlClient.SqlDataAdapter ad=new SqlDataAdapter();ad.SelectCommand=command;System.Data.SqlClient.SqlCommandBuilder combder=new SqlCommandBuilder(ad);System.Data.DataSet ds=new DataSet();ad.Fill(ds,"t_renshxx");DataRow dr=ds.Tables["t_renshxx"].NewRow();dr["yhbm"]=this.txtYhbm.Text.Trim();....................ds.Tables["t_renshxx"].Rows.Add(dr); ad.Update(ds,"t_renshxx"); 加一句System.Data.SqlClient.SqlCommandBuilder 对象名=new SqlCommandBuilder(MyAdapter);就行了,这是DataSet与数据表之间的桥梁,没这句,当然没用。 string connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\C#\NOTEPAD ANGELL\TestAddData\NA.MDB";string StrSQL = "SELECT ID, Name FROM test";OleDbConnection Myconn = new OleDbConnection();OleDbDataAdapter MyAdapter = new OleDbDataAdapter();DataSet MyDataSet = new DataSet();DataTable MyDataTable = new DataTable();Myconn.ConnectionString = connString;MyAdapter = new OleDbDataAdapter(StrSQL,Myconn);Myconn.Open();MyAdapter.Fill(MyDataTable);MyDataTable = MyDataSet.Tables["test"];DataRow dtRow = MyDataTable.NewRow();dtRow["ID"] = this.textBox1.Text;dtRow["Name"] = this.textBox2.Text;MyDataTable.Rows.Add(dtRow);MyAdapter.Update(MyDataTable);Myconn.Close();MyDataTable.AcceptChanges(); MyAdapter.Fill(MyDataTable);--->MyAdapter.Fill(YourDataSet,MyDataTable); MyAdapter.Update(MyDataTable);改为Add 在c#中class前面加一个public具体是什么意思 大家好,想找本C# 2005的教程书,电子版,入门方面的 关于c#开发pda的问题!! 请教各位大侠:如何把C#当中的一系列chart类图表输出到Excel当中? C#的继承 如何销毁自己动态创建picturebox控件 @@@@@@高手进!!!!!!!!! ▲-C#中数据库连接字符串的问题~?-★ 自定义属性 高手赶紧来帮忙! 如何遍历一个对象的所有属性? 谁有C#收手机短信的源码呀? 点击DataGrid的单元格,单元格里面就变成文本框,修改里面的数据,点击别的单元格里面的刚才的数据被修改
试过了,没用啊..................
sqlCon.Open();
string sql_string="select * from t_renshxx";
System.Data.SqlClient.SqlCommand command=new SqlCommand(sql_string,sqlCon);
System.Data.SqlClient.SqlDataAdapter ad=new SqlDataAdapter();
ad.SelectCommand=command;
System.Data.SqlClient.SqlCommandBuilder combder=new SqlCommandBuilder(ad);
System.Data.DataSet ds=new DataSet();
ad.Fill(ds,"t_renshxx");
DataRow dr=ds.Tables["t_renshxx"].NewRow();
dr["yhbm"]=this.txtYhbm.Text.Trim();
....................
ds.Tables["t_renshxx"].Rows.Add(dr);
ad.Update(ds,"t_renshxx");
string StrSQL = "SELECT ID, Name FROM test";
OleDbConnection Myconn = new OleDbConnection();
OleDbDataAdapter MyAdapter = new OleDbDataAdapter();
DataSet MyDataSet = new DataSet();
DataTable MyDataTable = new DataTable();
Myconn.ConnectionString = connString;
MyAdapter = new OleDbDataAdapter(StrSQL,Myconn);
Myconn.Open();
MyAdapter.Fill(MyDataTable);
MyDataTable = MyDataSet.Tables["test"];
DataRow dtRow = MyDataTable.NewRow();
dtRow["ID"] = this.textBox1.Text;
dtRow["Name"] = this.textBox2.Text;
MyDataTable.Rows.Add(dtRow);MyAdapter.Update(MyDataTable);
Myconn.Close();
MyDataTable.AcceptChanges();