比如说下面这个SQL语句: select distinct cu.Name1,sk1.dt,sk1.orderID,ar.Name,pt.Name,sk2.cb,sk2.name,sk2.ProdCity,sk2.sl,bt.dw,sk2.kg from Stock1 sk1 inner join Stock2 sk2 on sk1.ID=sk2.ID inner join Customer cu on cu.CustID=sk1.CustID inner join BatNo bt on bt.CB=sk2.CB inner join dbo.Area ar on ar.AreaID=bt.AreaID inner join Enum eu on eu.value=type inner join dbo.ProdType pt on pt.ProdID=sk2.ProdID我把数据加到放到DataGridView中,我再DataGridView中进行各种操作,修改,删除,添加 然后如何实现导航条上保存按纽来实现这些表的更新?
如果是多个表查询组合成的DataGridView数据源,就自己根据条件写代码
把那表数据分开来更新
SqlConnection con=null;
public Dbo()
{
conn=new SqlConnection(
"server=.;uid=sa;pwd=sa;database=xxxxxx");
} public bool Update(string sql)
{
SqlCommand cmd=con.CreateCommand();
cmd.CommandText=sql; try
{
conn.Open();
return cmd.ExecuteNonQuery()>0;
}
catch
{
return false;
}
finally
{
conn.Close();
}
}
select distinct cu.Name1,sk1.dt,sk1.orderID,ar.Name,pt.Name,sk2.cb,sk2.name,sk2.ProdCity,sk2.sl,bt.dw,sk2.kg
from Stock1 sk1
inner join Stock2 sk2
on sk1.ID=sk2.ID
inner join Customer cu
on cu.CustID=sk1.CustID
inner join BatNo bt
on bt.CB=sk2.CB
inner join dbo.Area ar
on ar.AreaID=bt.AreaID
inner join Enum eu
on eu.value=type
inner join dbo.ProdType pt
on pt.ProdID=sk2.ProdID我把数据加到放到DataGridView中,我再DataGridView中进行各种操作,修改,删除,添加
然后如何实现导航条上保存按纽来实现这些表的更新?
cmd.CommandText=sql;try
{
conn.Open();
return cmd.ExecuteNonQuery()>0;
}
catch
{
return false;
}
finally
{
conn.Close();
}
用sql语句存储到dataset以后怎么显示?!