Hello experts, Good day. I want to create a Master detail form using Visual Studio 2008 windows application with c#. In Parent Key table I want to input via Text Box, Combo box etc. and in Child Key table I want to Input data from datagrid. Now How can I Insert, Edit, delete, fetch data by grid. I don't want to use DataAdaptar. Have any alternative process. If have pls help me asap. I want to use Stored Procedure to Insert, Edit, Delete, fetch data into database.
Create relationship between master and details tables in a DataSet. The “master” control bindingsource is dataset, datamember is the master table. The details control bindingSource should be the master control’s bindingsource, datamember is the relationship name.
->How can I Insert, Edit, delete, fetch data by grid. I don't want to use DataAdaptar. ………I want to use Stored Procedure to Insert, Edit, Delete, fetch data into database.
It’s the same as update a single datatable. Set command.CommandType to CommandType.StoredProcedure. Set command.commandText to stored procedure name. Then execute the command.
This is an example shows calling Stored Procedure:
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.