to get a only date from date time picker...

[jaimin4829]

we r trying to insert date from datetime picker into mssqlserver 2005 but it also enter defult time(00:00) with it in database.
using we want only date...

& xyzdtp.value.date &

[M.Waqas Aslam]

you can do like this

datetimepicker.value.date.tostring()
'or you can set format property according to your requirement .

Regards

[M.Waqas Aslam]

and if you have datatype datetime in your db , then auto time will be added in your records , this will not effect any thing , and you can perform any task.

Regads

[jaimin4829]

and if you have datatype datetime in your db , then auto time will be added in your records , this will not effect any thing , and you can perform any task.

Regads

'ya in mssql2005 datatype is datetime so...but it affect while comparing....
'also using formate property it enter time in database..

[M.Waqas Aslam]

no it will not effect your result can you please write your query here , so that i can better ans you.

[Nguyen_4]

dateTimePicker1.DataBindings.Add("text", dataGridView1.DataSource, "Ngaysinh");
I try get dd/mm/yyyy from datagridview but datagirdview show mysql: ex: 12/02/1990 12:00:00.
how to show datetimepicker when i click datagridview row

[altjen]

I use it simple way. just: datetimepicker.text

but you have to change the format from LONG to CUSTOM

and at CostumFormat use any format you want
dddd-MM-yyyy = 11-4-2015

[violetasmith]

You can use:

Dim startDate as String
startDate = DateTimePicker1.Value.ToString("yyyy/MM/dd")

Or:

Dim startDate as String
startDate = DateTimePicker1.Value.Date

[bamun]

dim date as string=format(datetimepicker1.value,"dd-MM-yyyy")

[JerrimePatient]

change the datatype of startDate from datetime to date in your sql server

This will solve the problem.

[venkateshwaran]

//orcon is oracle connection
orcon.Open();
OracleCommand c = new OracleCommand();
c.Connection = orcon;
c.CommandText = "insert into xx values('"+dateTimePicker1.Value.ToString()+"')
c.ExecuteNonQuery();

        //in c# im getting error please i need help to insert date in oracle10g

[Rabiya_1]

Thanks everyone for your response and support.

[uzma_2]

while reading data from sql
DateTime dt = Convert.ToDateTime(dr["LastDateBidSub"]);
TextBox1.Text = (dt.ToString("dd/MM/yyyy").ToString());