namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
SqlConnection sqlconstr = new SqlConnection(oa.sqlstrcon);
string sqlstr;
DataSet data1 = new DataSet(); SqlDataAdapter datasql;
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
this.BindingContext[data1.Tables[0]].RemoveAt(0);
//this.BindingContext[data1.Tables[0]].EndCurrentEdit();
//this.BindingContext[data1.Tables[0]].AddNew();
datasql.Update(data1.Tables[0]);
// data1.AcceptChanges();
}
private void Form1_Load(object sender, EventArgs e)
{
sqlstr = "select * from sysuser";
sqlconstr.Open();
SqlCommand cmdsql = new SqlCommand(sqlstr, sqlconstr);
datasql = new SqlDataAdapter(cmdsql);
SqlCommandBuilder datasql1 = new SqlCommandBuilder(datasql);
datasql.SelectCommand = cmdsql;
datasql.Fill(data1);
user_no.DataBindings.Add("Text", data1.Tables[0], "user_no");
name.DataBindings.Add("text", data1.Tables[0], "name");
sysuser.DataBindings.Add("text", data1.Tables[0], "sysuser");
dept.DataBindings.Add("text", data1.Tables[0], "dept");
}
}
}
阅读(624) | 评论(0) | 转发(0) |