Insert data problem

 Subscribe in a reader

 

I have some doubts.

 

I am doing windows application.

 

In that one label field has 3 text boxes

 

How to create table for above field?

 

How to insert data into this label which has multiple textboxes?

 

How to get row details in a pop up window when you selected a particular column in Datagrid column?

 

How to write a stored procedure to insert data from multiple(two) tables based on condition which is two tables data can be inserted into database only when one of the two radiobuttons is checked from the front end?

 

How can you modify and update a row in datagridview ?What is the code for this?

 

Thanks & Regards,

 

 

I'd say you have to provide a little more information about the nature of your application/ process. What does one label and three textBoxes stands for?

 

It sounds like you have master/detail relationship here. For instance you have a customer (master) record and 3 (order) detail records for this customer.

 

In such a case what I would have done is created Foreign key Customer ID in the Order table. This way you'll be able to query all 3 records for the same customer by the following query...

 

select OrderID, OrderDesc, Unit Price

from Orders o inner Join Customers c

on o.CustomerID = c.CustomerID

where customerID = 1002

 

When you insert such records, then besides information pertaining to orders you also need to supply the customer ID of the current customer that is on the screen.

 

Again, if you will provide more details about your specific situation I probably could give you more precise advice.