how to get gridview text box values within button in c#

Question

How to get grid view textbox value within submit button .. Button should be outside from gridview..... Can anyone help with code...

Answer 1

here you cannot make S_no as primary key. if you want like this esult that add new column and make that as primary key

Answer 2

Sort of....

 

The top portion goes in one table and the grid data goes in another table. And you will need to maintain the relation.

 

Answer 3

When you say S_no = Identity primary key, it cannot be 1, 1, 1, 2, 3, 3. It has to be 1, 2, 3, 4, 5, 6, etc.

 

Answer 4

I suggest two tables here. You may not think about it today, but tomorrow you will need them. See carefully.

 

table 1  : tblBill

 

BillNo - this is the primary key. Try NOT TO have two separate columns as sr no as pk and bill no as a separate column.

BillDate, Custoer Id, Tax amount, etc. You will have several columns which will go in header table.

 

BillNo BillDate, etc... 

1

2

3

  

table 2 : tblBillDetail

 

BillDetailId - PK running id, 

BillNo - FK to above table

BillDetailId 1 2 3 for a single bill. If i implement, I will NOT have it. Not required.

then you will have quantity, price, etc. 

 

BillDetailId,  BillNo, BillDetailId

1 1 1

2 1 2

3 1 3

4 2 1

5 2 2

6 2 3

7 3 1

 

 

 

 

Answer 5

like this

Answer 6

ohk Sir

 

 I am try