下面是我查询出来的数据,我怎么在查询出来的数据编辑,然后更新 到数据库,,还有我查询后,如果没有符合的记录,我就增加,也不能实现,
string strConString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=tax.mdb";
DataTable dt = new DataTable("Test");
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(strConString);
System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter("SELECT ID as 序号,shangbinid as 商品编号 ,name as 商品名称,guige as 规格,danwei as 单位,danjia as 单价 FROM shangbin where name like '%" +textBox1.Text.Trim ()+ "%'", conn);
try
{
conn.Open();
da.Fill(dt); }
catch
{
}
finally
{
if (conn.State == ConnectionState.Open)
conn.Close();
conn.Dispose();
da.Dispose();
}
dataGrid1.DataSource=dt;
谢谢高人解答!!,更新和增加的问题
string strConString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=tax.mdb";
DataTable dt = new DataTable("Test");
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(strConString);
System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter("SELECT ID as 序号,shangbinid as 商品编号 ,name as 商品名称,guige as 规格,danwei as 单位,danjia as 单价 FROM shangbin where name like '%" +textBox1.Text.Trim ()+ "%'", conn);
try
{
conn.Open();
da.Fill(dt); }
catch
{
}
finally
{
if (conn.State == ConnectionState.Open)
conn.Close();
conn.Dispose();
da.Dispose();
}
dataGrid1.DataSource=dt;
谢谢高人解答!!,更新和增加的问题
MessageBox.Show("保存成功");至于更新,删除,无非取道当前需要修改的行,然后删除,再更新一下数据集就行了。====CSDN 小助手 V2.5 2005年11月05日发布====
CSDN小助手是一款脱离浏览器也可以访问Csdn论坛的软件
界面:http://blog.csdn.net/Qqwwee_Com/archive/2005/11/05/523395.aspx
下载:http://szlawbook.com/csdnv2