My SqlDataAdapter Update method is not working

Joined
May 19, 2006
Messages
1
Reaction score
0
The following was my code :
public void update2(DataSet myDS)
{

SqlDataAdapter mySqlDataAdapter=new SqlDataAdapter("select * from picfile",myCon);
SqlCommandBuilder objCommand=new SqlCommandBuilder(mySqlDataAdapter);
mySqlDataAdapter.DeleteCommand=objCommand.GetDeleteCommand();
mySqlDataAdapter.InsertCommand=objCommand.GetInsertCommand();
mySqlDataAdapter.UpdateCommand=objCommand.GetUpdateCommand();

myCon.Open();
mySqlDataAdapter.Fill(myDS,"picfile");
SqlTransaction objTransaction=myCon.BeginTransaction();
mySqlDataAdapter.SelectCommand.Transaction=objTransaction;
mySqlDataAdapter.InsertCommand.Transaction=objTransaction;
mySqlDataAdapter.DeleteCommand.Transaction=objTransaction;
mySqlDataAdapter.UpdateCommand.Transaction=objTransaction;
mySqlDataAdapter.TableMappings.Add("picfile","picfile");
mySqlDataAdapter.TableMappings.Add("NodeInfo","nodeinfo");

mySqlDataAdapter.RowUpdating +=new SqlRowUpdatingEventHandler(mySqlDataAdapter_RowUpdating);
mySqlDataAdapter.RowUpdated +=new SqlRowUpdatedEventHandler(mySqlDataAdapter_RowUpdated);



int ttmy=mySqlDataAdapter.Update(myDS,"picfile");
MessageBox.Show(ttmy.ToString());

objTransaction.Commit();
myCon.Close();
}

even the rowUpdating event is not active , I wrote so much ,but I just lost
;-)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top