pozabavio sam se malo problemom i napravio jedan primer .
primer je za access Northwind bazu i tablu Categories , zbog jednostavnosti
Konekcija , Adapter i dataset su generisani a povezivanje ListBox-a je preko designera .
Ovde ti refresh i ne treba , sve radi i bez toga
U initializecomponents metodi forme ide sledeci kod ( inace genrisan u dizajneru )
Code:
this.listBox1.DataSource = this.dataSet11.Categories;
this.listBox1.DisplayMember = "CategoryName";
this.listBox1.Location = new System.Drawing.Point(36, 24);
this.listBox1.Name = "listBox1";
this.listBox1.Size = new System.Drawing.Size(268, 160);
this.listBox1.TabIndex = 0;
this.listBox1.ValueMember = "CategoryID";
Glavni deo koda za brisanje i dodavanje je
Code:
static void Main()
{
Application.Run(new Form1());
}
private void Form1_Load(object sender, System.EventArgs e)
{
this.oleDbDataAdapter1.Fill(this.dataSet11);
}
private void buttonAdd_Click(object sender, System.EventArgs e)
{
//Add new Category
DataSet1.CategoriesRow r;
r = this.dataSet11.Categories.AddCategoriesRow("New Cat","NEw CAT DES");
this.oleDbDataAdapter1.Update(dataSet11);
this.dataSet11.AcceptChanges();
}
private void buttonRemove_Click(object sender, System.EventArgs e)
{
int index ;
index = this.listBox1.SelectedIndex;
this.dataSet11.Categories.Rows[index].Delete();
this.oleDbDataAdapter1.Update(this.dataSet11);
this.dataSet11.AcceptChanges();
}
}
}