Firstly: remove the quotation marks from the field names list: it won't help.
Secondly: Check you have a column called paymentdate in your paymentdetails table, and that it is a date format column.
Thirdly: Check you have data in the column.
If all the above are OK, we need to see the code fragment where you use the SELECT statement.
We also need any error messages, etc., that you get.
"i removed quotation, had column in table and is a Date DataType third one is i had more than 30 columns but it won't work my code is:
MySqlDataAdapter da = new MySqlDataAdapter("select p.sno as RecieptNo,p.feesamount,p.totalpaid,p.dueamount,p.paymentdate,p.paymode,p.bank,p.checkno,p.status from paymentdetails p,studentdetails s where p.sid=s.sid and s.class='" + DropDownList2.SelectedValue + "' and s.division='" + DropDownList3.SelectedValue + "' and s.rollno='" + DropDownList4.SelectedValue + "' order by p.sno", con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
remaining all columns coming into gridview except paymentdate
no error message while showing output
thank you"
Odd. Try cutting the select statement down to the minimum:
select p.sno, p.paymentdate from paymentdetails p
and see what happens (this is just trying to work out where the problem is, not fix it yet - so comment out you existing SELECT, you will need it again!)
If this works, try re-inserting elements a few at a time until it goes wrong.
"if i use this query(select p.sno, p.paymentdate from paymentdetails p) then i get only sno date column not coming"
Take out "p.sno":
select paymentdate from paymentdetails
Get any columns?