How to possible in Sql server 2008R2 in windows application

Jyoti Jodha

S_no = IDENTITY PRIMARY Key

Bill_no= Bill number

Row_no= temporarily grid vied records

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
Accepted answer
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
Nitin Sontakke9y ago
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.
Jyoti Jodha9y ago
like this
Jyoti Jodha9y ago
ohk Sir

I am try
Nitin Sontakke9y ago
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.
Nitin Sontakke9y ago
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