µ±Ç°Î»Ö㺱à³ÌÎĵµ >> C# >> DataGridViewͬ²½¸üе½Êý¾Ý¿â

ËùÊôÀà±ð£ºC#
ÍƼöÖ¸Êý£º¡ï¡ï¡î
ÎĵµÈËÆø£º33
±¾ÖÜÈËÆø£º17
·¢²¼ÈÕÆÚ£º2008-8-2

Ò»¡£°ó¶¨Êý¾Ý 


SqlConnection con = null;

SqlDataAdapter sa = null;

SqlCommandBuilder sb = null;

DataTable dt = null;

BindingSource bs = null;

´°Ìåʱ°ó¶¨Êý¾Ý

private void DataBingding_Load(object sender, EventArgs e)

{



con = new SqlConnection("server=.;uid=sa;pwd=sa;database=pubs;");

try

{

con.Open();

sa = new SqlDataAdapter("select * from jobs", con);

sb = new SqlCommandBuilder(sa);//°ó¶¨SqlDataAdapter



dt = new DataTable();

sa.Fill(dt);

this.dataGridView1.DataSource = dt;

bs = new BindingSource();

bs.DataSource = dt;//°ó¶¨BindingSource

con.Close();

}

catch (Exception ex)

{

con.Close();

throw ex;

}

}

SqlConnection con = null;

SqlDataAdapter sa = null;

SqlCommandBuilder sb = null;

DataTable dt = null;

BindingSource bs = null;

//¼ÓÔØ´°Ìåʱ°ó¶¨Êý¾Ý

private void DataBingding_Load(object sender, EventArgs e)

{



con = new SqlConnection("server=.;uid=sa;pwd=sa;database=pubs;");

try

{

con.Open();

sa = new SqlDataAdapter("select * from jobs", con);

sb = new SqlCommandBuilder(sa);//°ó¶¨SqlDataAdapter



dt = new DataTable();

sa.Fill(dt);

this.dataGridView1.DataSource = dt;

bs = new BindingSource();

bs.DataSource = dt;//°ó¶¨BindingSource

con.Close();

}

catch (Exception ex)

{

con.Close();

throw ex;

}

}

¶þ.ͬ²½DataGridViewÊý¾Ýµ½Êý¾Ý¿â

<PRE class=csharp name="code">//¸üР°´Å¥µ¥»÷ʼþ

private void button1_Click(object sender, EventArgs e)

{

sa.Update((DataTable)bs.DataSource);

}</PRE>