问题描述
usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceWindowsApplication1{publicpartialclassForm1:Form{publicForm1(){InitializeComponent();}DataSetds=newDataSet();SqlDataAdaptersda=newSqlDataAdapter();privatevoidForm1_Load(objectsender,EventArgse){load();}//窗体加载显示数据publicvoidload(){stringcnt="datasource=.;initialcatalog=ly;userid=sa;pwd=123";SqlConnectionconn=newSqlConnection(cnt);stringsql="select*fromtable1";conn.Open();SqlDataAdaptersda=newSqlDataAdapter(sql,conn);sda.Fill(ds);this.dataGridView1.DataSource=ds.Tables[0];}//点击按钮更新privatevoidbutton1_Click(objectsender,EventArgse){DialogResultresult=MessageBox.Show("确认修改吗？","友情提示",MessageBoxButtons.YesNo,MessageBoxIcon.Information);if(result==DialogResult.Yes){SqlCommandBuilderscb=newSqlCommandBuilder(sda);sda.Update(ds,"table1");//MessageBox.Show("修改成功啥的");}}}}
解决方案
解决方案二：
问题是什么？
解决方案三：
这是神马意思
解决方案四：
抱歉哦，忘记说了，datagridview显示出来了数据，单元格是可编辑的！我修改了数据，然后点按钮保存修改，有错误！！错误提示是：Update无法找到TableMapping['table']或DataTable"table1"
解决方案五：
大神帮忙看看是哪里出问题了，学习中~~~
解决方案六：
引用3楼的回复:
抱歉哦，忘记说了，datagridview显示出来了数据，单元格是可编辑的！我修改了数据，然后点按钮保存修改，有错误！！错误提示是：Update无法找到TableMapping['table']或DataTable"table1"
内存中并不存在table1，所以之前你得指定一下。usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceWindowsApplication1{publicpartialclassForm1:Form{publicForm1(){InitializeComponent();}DataSetds=newDataSet();SqlDataAdaptersda=newSqlDataAdapter();privatevoidForm1_Load(objectsender,EventArgse){load();}//窗体加载显示数据publicvoidload(){stringcnt="datasource=.;initialcatalog=ly;userid=sa;pwd=123";SqlConnectionconn=newSqlConnection(cnt);stringsql="select*fromtable1";conn.Open();SqlDataAdaptersda=newSqlDataAdapter(sql,conn);sda.Fill(ds,"table1");//指定一个别名table1this.dataGridView1.DataSource=ds.Tables[0];}//点击按钮更新privatevoidbutton1_Click(objectsender,EventArgse){DialogResultresult=MessageBox.Show("确认修改吗？","友情提示",MessageBoxButtons.YesNo,MessageBoxIcon.Information);if(result==DialogResult.Yes){SqlCommandBuilderscb=newSqlCommandBuilder(sda);sda.Update(ds,"table1");//这里才可以找到的//MessageBox.Show("修改成功啥的");}}}}
解决方案七：
绑定时指定table名字，试试this.dataGridView1.DataSource=ds.Tables["table1"];
解决方案八：
引用6楼的回复:
绑定时指定table名字，试试this.dataGridView1.DataSource=ds.Tables["table1"];
好点的写法sda.Fill(ds,"table1");//以下更改DataTabe中的数据DataTabledt=ds.Tables["table1"];this.dataGridView1.DataSource=dt;
解决方案九：
usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceWindowsApplication1{publicpartialclassForm1:Form{publicForm1(){InitializeComponent();}DataSetds=newDataSet();SqlDataAdaptersda=newSqlDataAdapter();privatevoidForm1_Load(objectsender,EventArgse){load();}//窗体加载显示数据publicvoidload(){stringcnt="datasource=.;initialcatalog=ly;userid=sa;pwd=123";SqlConnectionconn=newSqlConnection(cnt);stringsql="select*fromtable1";conn.Open();SqlDataAdaptersda=newSqlDataAdapter(sql,conn);sda.Fill(ds,"table1");//需要指定一下别名this.dataGridView1.DataSource=ds.Tables[0];}//点击按钮更新privatevoidbutton1_Click(objectsender,EventArgse){DialogResultresult=MessageBox.Show("确认修改吗？","友情提示",MessageBoxButtons.YesNo,MessageBoxIcon.Information);if(result==DialogResult.Yes){SqlCommandBuilderscb=newSqlCommandBuilder(sda);sda.Update(ds,"table1");//MessageBox.Show("修改成功啥的");}}}}
解决方案十：
奇怪，我5楼的回答哪去了？？