迫切求助!如何更新datagrid中的数据,并且数据库中的数据也能更新!我做了有三个月了,我都快疯了,请教各位!! 谢谢各位了! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 DataTable dt = new DataTable(); private void button1_Click_1(object sender, System.EventArgs e) { string str ="server = '.';user id=sa;database=TXGData"; string select = "SELECT * FROM 消费表"; System.Data.SqlClient.SqlDataAdapter dap = new System.Data.SqlClient.SqlDataAdapter(select,str); dap.Fill(dt); this.dataGrid1.DataSource=dt; } private void button2_Click_1(object sender, System.EventArgs e) { string str ="server = '.';user id=sa;database=TXGData"; string select = "SELECT * FROM 消费表 where 1=0"; System.Data.SqlClient.SqlDataAdapter dap = new System.Data.SqlClient.SqlDataAdapter(select,str); System.Data.SqlClient.SqlCommandBuilder scp = new System.Data.SqlClient.SqlCommandBuilder(dap); dap.Update(dt); int i=dap.Update(dt); MessageBox.Show(i.ToString()); } private void button2_Click(object sender, System.EventArgs e) { conn.open(); string strSql="select * from 读者类别 "; OleDbDataAdapter da=new OleDbDataAdapter(strSql,conn.dbconn); OleDbCommand aa=new OleDbCommand(); da.UpdateCommand=aa; //MessageBox.Show(dataGrid1[0,0].ToString()); for(int i=0;i<=dataGrid1.VisibleRowCount;i++) { string strup="update 读者类别 set 类别名='"+dataGrid1[i,0].ToString()+"',备注='"+dataGrid1[i,2].ToString()+"' where 类别名="+dataGrid1[i,0].ToString(); //OleDbCommand aa=new OleDbCommand(strup,conn.dbconn); aa.CommandText=strup; //da.UpdateCommand=aa; aa.ExecuteNonQuery(); } MessageBox.Show("修改成功!","修改!"); }提示ExecuteNonQuery:connecting属性未初始化 private void button2_Click_1(object sender, System.EventArgs e){ string str ="server = '.';user id=sa;database=TXGData"; string select = "SELECT * FROM 消费表 where 1=@x"; System.Data.SqlClient.SqlCommand cmd=System.Data.SqlClient.SqlCommand(str,select); SqlPrameters[] avarParms=new SqlPrameters[2]; avarParms[0].Dirtec=REturn;//返回侄 avarParms[1].value=0; System.Data.SqlClient.SqlDataAdapter dap = new System.Data.SqlClient.SqlDataAdapter(cmd); dap.Update(dt); int i=avarParms[0].value; MessageBox.Show(i.ToString()); } 3个月?夸张了吧,用try-catch把错误信息打出来看看,另外conn的connectstring有没有? 看看有没有帮助,http://blog.csdn.net/zhzuo/archive/2004/08/06/67037.aspx c#做的用户登陆界面 一个类的属性要附值时间.datetimenow 不叫附值呢。 我是新手,请高手解决一个不同窗体的值传递问题 c# 高手進來幫幫忙 數据庫复原問題 如何拦截窗体关闭事件,使得关闭对话框能弹出,并让用户再选择后再关闭? 请教数据库性能问题 关于web的文件访问权限问题,简单却奇怪,希望有经验的给予解答! 调用WebService的问题??? web form 的问题 接口的继承:不能继承 datagrid的翻页属性设置 DataTable如何实现倒序?
private void button1_Click_1(object sender, System.EventArgs e)
{
string str ="server = '.';user id=sa;database=TXGData";
string select = "SELECT * FROM 消费表";
System.Data.SqlClient.SqlDataAdapter dap = new System.Data.SqlClient.SqlDataAdapter(select,str);
dap.Fill(dt);
this.dataGrid1.DataSource=dt; } private void button2_Click_1(object sender, System.EventArgs e)
{
string str ="server = '.';user id=sa;database=TXGData";
string select = "SELECT * FROM 消费表 where 1=0";
System.Data.SqlClient.SqlDataAdapter dap = new System.Data.SqlClient.SqlDataAdapter(select,str);
System.Data.SqlClient.SqlCommandBuilder scp = new System.Data.SqlClient.SqlCommandBuilder(dap);
dap.Update(dt);
int i=dap.Update(dt);
MessageBox.Show(i.ToString()); }
{ conn.open();
string strSql="select * from 读者类别 ";
OleDbDataAdapter da=new OleDbDataAdapter(strSql,conn.dbconn);
OleDbCommand aa=new OleDbCommand();
da.UpdateCommand=aa;
//MessageBox.Show(dataGrid1[0,0].ToString());
for(int i=0;i<=dataGrid1.VisibleRowCount;i++)
{
string strup="update 读者类别 set 类别名='"+dataGrid1[i,0].ToString()+"',备注='"+dataGrid1[i,2].ToString()+"' where 类别名="+dataGrid1[i,0].ToString();
//OleDbCommand aa=new OleDbCommand(strup,conn.dbconn);
aa.CommandText=strup;
//da.UpdateCommand=aa;
aa.ExecuteNonQuery();
}
MessageBox.Show("修改成功!","修改!"); }提示ExecuteNonQuery:connecting属性未初始化
{
string str ="server = '.';user id=sa;database=TXGData";
string select = "SELECT * FROM 消费表 where 1=@x"; System.Data.SqlClient.SqlCommand cmd=System.Data.SqlClient.SqlCommand(str,select);
SqlPrameters[] avarParms=new SqlPrameters[2];
avarParms[0].Dirtec=REturn;//返回侄
avarParms[1].value=0;
System.Data.SqlClient.SqlDataAdapter dap = new System.Data.SqlClient.SqlDataAdapter(cmd);
dap.Update(dt);
int i=avarParms[0].value;
MessageBox.Show(i.ToString()); }
http://blog.csdn.net/zhzuo/archive/2004/08/06/67037.aspx