110,566
社区成员
发帖
与我相关
我的任务
分享
private void button6_Click(object sender, EventArgs e)
{
OleDbConnection mycon = null;
try
{
string strcon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\1.mdb;";
mycon = new OleDbConnection(strcon);
mycon.Open();
string sql1 = "Update temp SET 单据编号 = REPLACE(单据编号, 'SAR00', '')";
OleDbDataAdapter ad1 = new OleDbDataAdapter(sql1, strcon);
DataTable dt = new DataTable();
ad1.Fill(dt);
textBox3.Text = "导入完成";
}
finally
{
mycon.Close();
}
}