SQl Queries

See more:

C#

this is my query

SqlDataAdapter da = new SqlDataAdapter("select LD_LDate as Date, LD_Lno as Particular,LD_DCharge as Credit,LD_Amt as Debit from Loandetails where Loandetails.LD_LDate='" + TB_Datetxt.Text + "' union select Dep_Date as Date, Dep_id as Particular,Dep_Amt as Credit,Dep_Mnly_int as Debit from Depositor", con_str);

MY Output should be like this

Date Particulars Credit Debit
1/12/2010 Interest Paid to Lno1 should be empty 500
1/12/2010 Amount Deposited from Dno1 1000 should be empty


How to display this text in Datagrid of Paricular Column and Credit Column should be empty.. Here I've used union for fetching from two table..