can anyone tell me how to store the datetime value in dd/mm/yyyy format to the sqlserver database,,,,,this is mycode
connection.Open()
cmd = New SqlCommand("insert into datecheck(id,fromdate,todate)values(@id,@fromdate,@todate)", connection)
cmd.Parameters.Add("id", SqlDbType.Int).Value = TextBox1.Text
cmd.Parameters.Add("fromdate", SqlDbType.DateTime).Value = DateTime.Parse(txtdob.Text)
cmd.Parameters.Add("todate", SqlDbType.DateTime).Value = DateTime.Parse(txtdoj.Text)
cmd.ExecuteNonQuery()
Response.Write("ok")
End Sub