public DataSet SelectOleDbSrvRows(DataSet dataset,string connection,string query) { OleDbConnection conn = new OleDbConnection(connection); OleDbDataAdapter adapter = new OleDbDataAdapter(); adapter.SelectCommand = new OleDbCommand(query, conn); adapter.Fill(dataset); return dataset; }
Dim conn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("shujuku")) Dim cmd As SqlDataAdapter = New SqlDataAdapter("select * from test_fs", conn) Dim ds As DataSet = New DataSet cmd.Fill(ds, "test") cmd.InsertCommand = New SqlCommand("insert test_fs(fenshu) values('60,70,80')", conn) Dim dt As DataTable = ds.Tables("test") Dim dr As DataRow = dt.NewRow dr("fenshu") = "60,70,80" dt.Rows.Add(dr) cmd.Update(ds, "test") binddatagrid()这是添加的简单的例子,你修改下成更新的就可以了
用 SqlCommandBuilder 自动生成insert,update,delete语句SqlCommandBuilder sc = new SqlCommandBuilder(dataAdapter); dataAdapter.Update(Dateset.GetChanges());
这个问题很严重哦..我也是这样..为什么就没有人贴一个全代码出来救救我们. String ConnectionString = "Data Source=.;uid=chuwanghui;pwd=5439abcd3158;database=testDb;"; SqlConnection myConnection = new SqlConnection(ConnectionString); String cmdText = "SELECT * FROM [user]"; SqlDataAdapter da = new SqlDataAdapter(cmdText,myConnection); try { myConnection.Open(); //Response.Write("成功"); DataSet ds = new DataSet();
da.Fill(ds,"user"); DataTable table=ds.Tables["user"]; //DataRow dr = ds.Tables["user"].NewRow(); DataRow dr=table.NewRow(); dr[1]=TextBox1.Text.ToString(); dr[2]=TextBox2.Text.ToString(); dr[3]=TextBox4.Text.ToString(); dr[4]=TextBox5.Text.ToString(); table.Rows.Add(dr); da.InsertCommand=new SqlCommand("insert into user(UserName,Password,QQ,email) values('"+dr[0]+"','"+dr[1]+"','"+dr[2]+"','"+dr[3]+"')",myConnection);
{
OleDbConnection conn = new OleDbConnection(connection);
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.SelectCommand = new OleDbCommand(query, conn);
adapter.Fill(dataset);
return dataset;
}
Dim cmd As SqlDataAdapter = New SqlDataAdapter("select * from test_fs", conn)
Dim ds As DataSet = New DataSet cmd.Fill(ds, "test")
cmd.InsertCommand = New SqlCommand("insert test_fs(fenshu) values('60,70,80')", conn)
Dim dt As DataTable = ds.Tables("test")
Dim dr As DataRow = dt.NewRow
dr("fenshu") = "60,70,80"
dt.Rows.Add(dr)
cmd.Update(ds, "test")
binddatagrid()这是添加的简单的例子,你修改下成更新的就可以了
dataAdapter.Update(Dateset.GetChanges());
String ConnectionString = "Data Source=.;uid=chuwanghui;pwd=5439abcd3158;database=testDb;";
SqlConnection myConnection = new SqlConnection(ConnectionString);
String cmdText = "SELECT * FROM [user]";
SqlDataAdapter da = new SqlDataAdapter(cmdText,myConnection);
try
{
myConnection.Open();
//Response.Write("成功");
DataSet ds = new DataSet();
da.Fill(ds,"user"); DataTable table=ds.Tables["user"];
//DataRow dr = ds.Tables["user"].NewRow();
DataRow dr=table.NewRow(); dr[1]=TextBox1.Text.ToString();
dr[2]=TextBox2.Text.ToString();
dr[3]=TextBox4.Text.ToString();
dr[4]=TextBox5.Text.ToString();
table.Rows.Add(dr);
da.InsertCommand=new SqlCommand("insert into user(UserName,Password,QQ,email) values('"+dr[0]+"','"+dr[1]+"','"+dr[2]+"','"+dr[3]+"')",myConnection);
SqlCommandBuilder objCommandBuilder = new SqlCommandBuilder(da); da.Update(ds,table.TableName.ToString());
DataGrid1.DataSource= ds;
DataGrid1.DataBind();
myConnection.Close();
}
catch(System.Exception ex){Response.Write("出错:"+ex.Message);}
错误提示信息是
出错:在关键字 'user' 附近有语法错误。 改了很多次都有错误
把表的名字换一个就好了
如:table_user
可以把你的表名,列名换一下
因为sql的关键字很多,你接触的很少
所以在这方面要注意