Update requires a valid InsertCommand when passed DataRow collection with new rows

I am trying to add a new row to my database . Here is my code :

ds1 is my Dataset , da1 is my data adapter

        dRow = ds1.Tables["localitati"].NewRow();
        dRow[1] = aux1.Replace(" ", "").Replace("-", "").ToLower();
        dRow[2] = aux2.ToLower().Replace(" ", "");
        dRow[3] = aux1;
        dRow[4] = e.X;
        dRow[5] = e.Y;
        ds1.Tables["localitati"].Rows.Add(dRow);

        da1.Update(ds1, "localitati");

at the da1.update(ds1,"localitati"); the program stops and gives me the error : "Update requires a valid InsertCommand when passed DataRow collection with new rows."

The connection to the database works ( i have retrieved info from the db )

Any ideas ?

11
задан Alex 5 November 2010 в 11:25
поделиться