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 WindowsApplication10
{
public partial class Form2 : Form
{
BindingSource bs;
DataSet ds;
SqlDataAdapter da;
public Form2()
{
InitializeComponent();
}
private void Form2_Load(object sender, EventArgs e)
{
ds = new DataSet();
da = new SqlDataAdapter("select * from stu", SQL.conSTR);
da.Fill(ds, "stu");
bs = new BindingSource();
bs.DataSource = ds.Tables[0];
textBox1.DataBindings.Add("text", bs, "uid");
textBox2.DataBindings.Add("text", bs, "pwd");
comboBox1.DataBindings.Add("text", bs, "Gender");
}
private void button1_Click(object sender, EventArgs e)
{
if(bs.Position-1>=0)
bs.MovePrevious();
}
private void button2_Click(object sender, EventArgs e)
{
if(bs.Position+1<bs.Count)
bs.MoveNext();
}
private void button3_Click(object sender, EventArgs e)
{
//bs.EndEdit();
SqlCommandBuilder sc = new SqlCommandBuilder(da);
sc.GetInsertCommand();
sc.GetUpdateCommand();
sc.GetDeleteCommand();
da.Update(ds.Tables[0]);
}
private void button4_Click(object sender, EventArgs e)
{
bs.AddNew();
}
}
}
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 WindowsApplication10
{
public partial class Form2 : Form
{
BindingSource bs;
DataSet ds;
SqlDataAdapter da;
public Form2()
{
InitializeComponent();
}
private void Form2_Load(object sender, EventArgs e)
{
ds = new DataSet();
da = new SqlDataAdapter("select * from stu", SQL.conSTR);
da.Fill(ds, "stu");
bs = new BindingSource();
bs.DataSource = ds.Tables[0];
textBox1.DataBindings.Add("text", bs, "uid");
textBox2.DataBindings.Add("text", bs, "pwd");
comboBox1.DataBindings.Add("text", bs, "Gender");
}
private void button1_Click(object sender, EventArgs e)
{
if(bs.Position-1>=0)
bs.MovePrevious();
}
private void button2_Click(object sender, EventArgs e)
{
if(bs.Position+1<bs.Count)
bs.MoveNext();
}
private void button3_Click(object sender, EventArgs e)
{
//bs.EndEdit();
SqlCommandBuilder sc = new SqlCommandBuilder(da);
sc.GetInsertCommand();
sc.GetUpdateCommand();
sc.GetDeleteCommand();
da.Update(ds.Tables[0]);
}
private void button4_Click(object sender, EventArgs e)
{
bs.AddNew();
}
}
}