adding date to grid - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


adding date to grid

svibuksvibuk Posts: 10Member
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
using in windows application

currently wht i have fr binding the grid is

in form load i hve
select , 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 = where t.cust_id = " & dropdown1.SelectedValue & "
grid_trans.DataSource = ds1.Tables("trans")
grid_trans.AllowUserToAddRows = False
grid_trans.Columns(0).Visible = False

grid_trans.Columns(5).DefaultCellStyle.Format = DateFormat.ShortDate
grid_trans.Columns(6).DefaultCellStyle.Format = DateFormat.ShortDate

Sign In or Register to comment.