Kod kreiranja tipiziranog DataSet-a(add new item) postoji opcija da adapter automatski osvežava tabelu u DataSet-u. Kako se to kontroliše kod programski kreiranog DataSet/Adapter objekta?
Code:
private void Form1_Load(object sender, EventArgs e)
{
SqlConnection connection = new SqlConnection(@"Data Source=SUN\SQLEXPRESS;Initial Catalog=estrada;Integrated Security=True");
adapter = new SqlDataAdapter("SELECT * FROM autori", connection);
SqlCommandBuilder cbuilder = new SqlCommandBuilder(adapter);
dset = new DataSet();
adapter.Fill(dset);
dataGridView1.DataSource = dset.Tables[0];
}
private void button1_Click(object sender, EventArgs e)
{
adapter.Update(dset);
}
private void Form1_Load(object sender, EventArgs e)
{
SqlConnection connection = new SqlConnection(@"Data Source=SUN\SQLEXPRESS;Initial Catalog=estrada;Integrated Security=True");
adapter = new SqlDataAdapter("SELECT * FROM autori", connection);
SqlCommandBuilder cbuilder = new SqlCommandBuilder(adapter);
dset = new DataSet();
adapter.Fill(dset);
dataGridView1.DataSource = dset.Tables[0];
}
private void button1_Click(object sender, EventArgs e)
{
adapter.Update(dset);
}
Znači kad kliknem na button1 fizički se izvrši update u bazi, ali recimo autoincrement vrednost dobijam tek kada resetujem program!