string myconn = "Data Source=localhost;Integrated Security=SSPI;Initial Catalog=nangang";
m_connection = new SqlConnection(myconn);
string mysql = "Select A.*,B.username,B.userID,C.carlicense ,C.carbrand ";
mysql+= "From cardinfo a ";
mysql += "Inner join userinfo B ON A.UserID=B.UserID ";
mysql += "Inner Join carinfo C On B.UserID=C.UserID ";
try
{
m_dataadapter = new SqlDataAdapter(mysql, m_connection); if (m_connection.State != ConnectionState.Open)
{
m_connection.Close();
m_connection.Open();
}
m_ds = new DataSet();
m_dataadapter.Fill(m_ds, "AA"); gridControl1.DataSource = m_ds;
gridControl1.DataMember = "AA";
我知道要更新多个表单单一个
using (SqlCommandBuilder m_cb = new SqlCommandBuilder(m_dataadapter))
{
m_dataadapter.Update(m_ds, "AA");
}
是不够,那像我这样一句select 怎么更新多个表,我是新手 给简单易行的代码 谢谢
看不懂…………
请不要简单说用存储过程或者触发器 请写出详细点的代码
设置m_dataadapter的UpdateCommand属性
MSDN查一下
因为界面上显示的是一个联合查询的结果 ,而我只好用
string mysql = "Select A.*,B.username,B.userID,C.carlicense ,C.carbrand ";
mysql+= "From cardinfo a ";
mysql += "Inner join userinfo B ON A.UserID=B.UserID ";
mysql += "Inner Join carinfo C On B.UserID=C.UserID ";
来显示,关键是我只用到了1个adapter,而更新的时候是需要多个adapter,那后面多个adapter怎么出来
http://blog.csdn.net/zhzuo/archive/2004/08/06/67037.aspx