[ Marko Medojević @ 09.04.2009. 13:59 ] @
Ćao! 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); } Znači kad kliknem na button1 fizički se izvrši update u bazi, ali recimo autoincrement vrednost dobijam tek kada resetujem program! |