using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;namespace Shili1
{
public partial class employeeForm : Form
{
DataSet ds = new DataSet("employee");
SqlDataAdapter sda;
public employeeForm()
{
InitializeComponent();
} private void employeeForm_Load(object sender, EventArgs e)
{ string sql = "select * from employee";
sda = new SqlDataAdapter(sql, DBConnection.con);
sda.Fill(ds, "employee");
dgvEmployee.DataSource = ds.Tables["employee"];
} private void btnClose_Click(object sender, EventArgs e)
{
this.Close();
} private void btnUpdate_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("你确定要将修改的信息保存到数据库", "验证", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
SqlCommandBuilder scb = new SqlCommandBuilder(sda);
sda.Update(ds, "employee");
}
}
}
}
sda.Update(ds, "employee");这句代码引出的异常
对于不返回任何键列信息的 SelectCommand,不支持 UpdateCommand 的动态 SQL 生成。
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;namespace Shili1
{
public partial class employeeForm : Form
{
DataSet ds = new DataSet("employee");
SqlDataAdapter sda;
public employeeForm()
{
InitializeComponent();
} private void employeeForm_Load(object sender, EventArgs e)
{ string sql = "select * from employee";
sda = new SqlDataAdapter(sql, DBConnection.con);
sda.Fill(ds, "employee");
dgvEmployee.DataSource = ds.Tables["employee"];
} private void btnClose_Click(object sender, EventArgs e)
{
this.Close();
} private void btnUpdate_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("你确定要将修改的信息保存到数据库", "验证", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
SqlCommandBuilder scb = new SqlCommandBuilder(sda);
sda.Update(ds, "employee");
}
}
}
}
sda.Update(ds, "employee");这句代码引出的异常
对于不返回任何键列信息的 SelectCommand,不支持 UpdateCommand 的动态 SQL 生成。
解决方案 »
- C#中如何实现单击按钮就可以运行该swf文件,但编译后该swf文件在包含在软件中,和软件是一体的?
- 投票系统的数字签名问题
- 怪事,winxp的机器上运行正常,但是win7就报错,内详
- An existing connection was forcibly closed by the remote host
- private void Form1_MouseDown(object sender, MouseEventArgs e)
- 一个socket问题,csdn一个疑问
- 要实现多文挡界面(MDI)的子窗体页面之间跳转,怎么实现?有人做过吗?
- ViewState的问题,我在同一个页面的usercontrol里引用该页面的另一个usercontrol里的ViewState,怎么得不到值?
- XmlDocument.Load出现新问题了
- 大家看看吧,支持一下.NET的发展
- 。net中有没有函数可以得到某个时区ID对应的时区呀(如ID为:Asia/Singapore或 EST 等) ---急呀
- Owc导出Excel?
sda = new SqlDataAdapter(sql, DBConnection.con);
sda.Fill(ds, "employee");
dgvEmployee.DataSource = ds.Tables["employee"];
你要和这个select的一样用