dataAdapter.Update(Dataset) & insert to multiple Tables RRS feed

  • Question

  • hello all,

    our application(in c#) has a dataset which has 5 related dataTables, and we want to insert our data to these tables via a single stored procedure, is it supported in .Net to do it at all?


    however for this purpose we coded like this:

    DbDataAdapter myAdp = GenericFactory.DataAdapter; // return a dataAdapter

    myAdp.InsertCommand = GetInsertCommand(conn); // this function return insert command

    myAdp.Update(ds); // ds : the name of dataset


    but this isn't work at all! 


    does anyone know what should we do??




    Monday, May 19, 2008 9:17 AM