As i suggested in the comments to your
past question[
^], you have to write proper data structure.
Credit and debit should be stored in the same column! If user chooses
Dr.
, save negative numeric value. That's all!
A sql command might look like:
INSERT INTO TableName (Credit_Debit) VALUES(@creditDebit)
Follow this link to find out how to call this query:
SqlParameterCollection.AddWithValue Method[
^]