Hello...!!!
help me if u can..Thanks in advance!!!
database table=issue_details in which columns are issue_id is identity,book_tag_id,member_id,book_issue_on.due_date
database table=return_details colums are return_id identity,issue_id,book_returned_on,fine_per_day
database=membership_details columns are membership_id,membership_desc(gold,silver,platinum)
as u see in return databasetable return_id is identity but issue_id is int
Now my return form is:book_tag_id=textbox1
member_id=textbox2
Issue_date=textbox3
returndate=textbox4
fine=textbox5
in the form the member_id,issue_date is fetched from book_tag_id so these textbox2&3 are readonly.
return_date is date of system.
see my code...this all is working fine.....
but problem is with issue_id in return table...as this is fetched from tag_id or from issue_database
da.InsertCommand = new SqlCommand("Insert` into book_return_details Values(@book_issue_id,@book_returned_on,@late_fine)", cs);
da.InsertCommand.Parameters.Add("@book_issue_id", SqlDbType.Int).Value =???????
what i should add in ??? so that issue_id automatically saved in database!!!!!!!!!!!!