C# - FORM: DataAdapter.Upd ate() doesn't work :(

[Pietro Ova]

Hello,

I wrote a little program to understand the ADO.NET's mechanism. It's a common program with a datagrid, textboxes and a toolstripbar with usually buttons. The problem is that meanwhile i add rows to dataset the save button works when i remove some of them the update method doesn't work.

Please see the following code:

public Popola()
{
InitializeCompo nent();
string connstring = "Data Source = .\\SQLEXPRESS; Initial Catalog = scuola; Integrated Security = True";
conn = new SqlConnection(c onnstring);

myset = new DataSet("Classe ");

myadapter = new SqlDataAdapter( "SELECT * FROM Classe ORDER BY IDClasse ASC", conn);
myadapter.Table Mappings.Add("T able", "Classe");
myadapter.Fill( myset);

da2 = new SqlDataAdapter( "SELECT * FROM Studente ORDER BY Cognome ASC", conn);
da2.TableMappin gs.Add("Table", "Studente") ;
da2.Fill(myset) ;

DataColumn colMaster1;
DataColumn colDetail1;
colMaster1 = myset.Tables["Classe"].Columns["IDClasse"];
colDetail1 = myset.Tables["Studente"].Columns["IDClasse"];
relClasStud = new DataRelation("R elClasStud", colMaster1, colDetail1);
myset.Relations .Add(relClasStu d);
myset.EndInit() ;

dsView = myset.DefaultVi ewManager;
.......
cm_clas = (CurrencyManage r)this.BindingC ontext[dsView, "Classe"];
cm = (CurrencyManage r)this.BindingC ontext[dsView, "Classe.RelClas Stud"];
}

//Remove and Save buttons code:
private void Remove_Click(ob ject sender, EventArgs e)
{

DataRowView rw_ = (DataRowView)cm .Current;
DataRow rw = rw_.Row;
myset.Tables["Studente"].Rows.Remove(rw );
cm.EndCurrentEd it();
//myset.AcceptCha nges();
cm.Position = 0;
textBoxPosition .Text = String.Format(" Record {0} of {1}", (cm.Position + 1), cm.Count);
}

private void btnSalva_Click( object sender, EventArgs e)
{
conn.Open();

SqlCommandBuild er sqlcmd = new SqlCommandBuild er(da2);
SqlCommandBuild er sqlcmd1 = new SqlCommandBuild er(myadapter);
da2.Update(myse t.Tables["Studente"]);
myadapter.Updat e(myset.Tables["Classe"]);
conn.Close();

}

Can you help me? T.T
Regards.
Pietro.

[Pietro Ova]

Ok.. I resolve it!

Just replace the lines:

    myset.Tables["Studente"].Rows.Remove(rw);
   cm.EndCurrentEdit(); 
 

with:

      rw.Delete();
 

Thanks anyway.
Pietro.