in form load i hve
select p.id , p.pname ,0 as QTY, p.RATE, AMOUNT, p.dtfrm as From_DT,p.dtto as To_DT from PRDT left join M_customer C On C.Cid = t.cust_id left join M_prdt P On P.id = t.id where t.cust_id = " & dropdown1.SelectedValue & "
grid_trans.DataSource = ds1.Tables("trans")
grid_trans.AllowUserToAddRows = False
grid_trans.Columns(0).Visible = False
It has been a while since I have done this, but there are two things to consider, 1) if your dataset is not strongly typed, you may need to use the itemdatabound event on the data grid to format the particular columns to be ShortDate. 2) or if it isn't strongly typed you can make a strongly typed dataset and use that, which would mean your current code should work.
My gut is telling me that if you look into your dataset, you will see the type is of string because it isn't a strongly typed dataset. Otherwise, I don't see an obvious reason why your code isn't working.
still not able to do it.
i jst want to bind a grid which has date column
& the user shld be able to add date in each row of the date column
if no date is added the default date of 01/01/1900 shld be saved in db