數據庫裡寫了一個存儲過程``
create proc dt_select
as
begin
select * from base1
where not exists(
SELECT * FROM base2 where
isnull(base1.實際完工,'')=isnull(base2.實際完工,'')
and isnull(base1.實際完工,'')=isnull(base2.實際完工,'')
and isnull(base1.訂單品號,'')=isnull(base2.訂單品號,'')
and isnull(base1.產品品號,'')=isnull(base2.產品品號,'')
and isnull(base1.訂單單號,'')=isnull(base2.訂單單號,'')
and isnull(base1.訂單數量,'')=isnull(base2.訂單數量,'')
and isnull(base1.贈品量,'')=isnull(base2.贈品量,''))
endc#語句是這樣的``
private void button5_Click(object sender, System.EventArgs e)
{
SqlConnection myConn=new SqlConnection();
try
{string str=System.Configuration.ConfigurationSettings.AppSettings["strConnection"].Trim();
myConn.ConnectionString=str;
string strCmd="exec dt_select";
myConn.Open();
DataTable dt = new DataTable();
SqlDataAdapter da=new SqlDataAdapter(strCmd,myConn);
da.Fill(dt);
da.Update(dt);
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
myConn.Close();
}
}我要想把在~存儲過程~裡select到的數據從新更新到數據表裡```
上面的做法怎么沒效果啊``運行後數據表的數據還是沒有變???
大蟲幫幫我啊`~!!!!
create proc dt_select
as
begin
select * from base1
where not exists(
SELECT * FROM base2 where
isnull(base1.實際完工,'')=isnull(base2.實際完工,'')
and isnull(base1.實際完工,'')=isnull(base2.實際完工,'')
and isnull(base1.訂單品號,'')=isnull(base2.訂單品號,'')
and isnull(base1.產品品號,'')=isnull(base2.產品品號,'')
and isnull(base1.訂單單號,'')=isnull(base2.訂單單號,'')
and isnull(base1.訂單數量,'')=isnull(base2.訂單數量,'')
and isnull(base1.贈品量,'')=isnull(base2.贈品量,''))
endc#語句是這樣的``
private void button5_Click(object sender, System.EventArgs e)
{
SqlConnection myConn=new SqlConnection();
try
{string str=System.Configuration.ConfigurationSettings.AppSettings["strConnection"].Trim();
myConn.ConnectionString=str;
string strCmd="exec dt_select";
myConn.Open();
DataTable dt = new DataTable();
SqlDataAdapter da=new SqlDataAdapter(strCmd,myConn);
da.Fill(dt);
da.Update(dt);
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
myConn.Close();
}
}我要想把在~存儲過程~裡select到的數據從新更新到數據表裡```
上面的做法怎么沒效果啊``運行後數據表的數據還是沒有變???
大蟲幫幫我啊`~!!!!
解决方案 »
- C# SOCKET通信
- 反射动态创建List<T>
- 关于Excel导入数据库出错,半天没解决,跪求高手
- MDI窗体的问题??
- 数学问题,用程序解决。100分!
- 关于接口多态问题,请进。
- 窗口关闭之疑惑
- 如何提取010-22222222-1001这样的字符串?急用!
- win2008 x64 下安装oracle 10g 32位。vs2008 无法连接上数据库?
- 刚刚在书店看到一本清华(翻译的)C#书,今年1月出的128元,不知如何?
- 请问如何去掉label上的tooltip?
- C#邮件发送程序提示错误“551, delivery not allowed to non-local recipient”
原來衹要這樣改下就行了
create proc dt_select
as
begin
delete from base1
where exists(
SELECT * FROM base2 where
當時怎么沒有想到```真的是夠笨的