Dataset BindingContext problem
hi,
i have problem with dataset. I create a form that has two textboxes, 1 datagrid and 4 buttons. textboxes are binding to dateset's columns.
my problem is when i want to add a new record to dataset with "BindingContext[dataSet11, "deneme"].AddNew()" it adds a new row at the end of dataset with null values. And updates current row with values that i want to add to the last row of dataset.
thanks for helps.
Here Is My Code
----------------
//Fill's dataset
private void button1_Click(object sender, System.EventArgs e)
{
dataSet11.Clear();
sqlDataAdapter1.Fill(dataSet11);
dataGrid1.DataSource=dataSet11.Tables["deneme"];
}
private void dataGrid1_Click(object sender, System.EventArgs e)
{
this.BindingContext[dataSet11,"deneme"].Position=dataGrid1.CurrentRowIndex;
}
//delete current row
private void button4_Click(object sender, System.EventArgs e)
{
this.BindingContext[dataSet11, "deneme"].RemoveAt(this.BindingContext[dataSet11, "deneme"].Position);
}
//add new record to dataset
private void button2_Click(object sender, System.EventArgs e)
{
BindingContext[dataSet11, "deneme"].AddNew();
BindingContext[dataSet11, "deneme"].EndCurrentEdit();
}
//update current row
private void button3_Click(object sender, System.EventArgs e)
{
//this.textBox1.DataBindings["Text"].BindingManagerBase.EndCurrentEdit();
BindingContext[dataSet11, "deneme"].EndCurrentEdit();
}
//update database
private void button5_Click(object sender, System.EventArgs e)
{
sqlDataAdapter1.Update(dataSet11);
}