how to save date as this format dd/MM/yyyyy using c#

Question

hello guys I have a certain problem in this case when i save date like 04/05/2019 is saved but when i select big date like 30/04/2019 does not save , PLS see the photos

Amit Gupta · Answer

Hey If you are using string in DateTime field then you are losing many properties of datetime, try pass the date value like cmd.Parameters.Add("@ReceivedDate", SqlDbType.Date).Value = DateTime.Now or use the global format yyyy/MM/dd cmd.Parameters.Add("@ReceivedDate", SqlDbType.Date).Value = Convert.ToDateTime(datetimepicker1.Text.Trim()).ToString("yyyy/MM/dd");

Abdalla Elawad · Answer

Using Sql server 2008 - column datatype is date - also using datetimepicker javascript javascript $(function () { $('#datetimepicker1').datetimepicker({ format: 'DD/MM/YYYY' }); }); _____________________________________ using c# code SqlCommand cmd = new SqlCommand("Item_Insert", Conn); cmd.Parameters.Add("@ItemDesc", SqlDbType.VarChar).Value = txtitemdesc.Text.Trim(); cmd.Parameters.Add("@Model", SqlDbType.VarChar).Value = txtItemodel.Text.Trim(); cmd.Parameters.Add("@PartNo", SqlDbType.NVarChar).Value = txtpartno.Text.Trim(); cmd.Parameters.Add("@ReceivedDate", SqlDbType.Date).Value = datetimepicker1.Text.Trim(); ___________________________ Thanks

Rajanikant Hawaldar · Answer

While inserting, format in query and insert https://stackoverflow.com/questions/34329852/how-to-insert-date-values-into-table https://www.codeproject.com/Questions/720841/insert-date-in-sql-server-as-dd-mm-yyyy-format

Rajanikant Hawaldar · Answer

which database your using? what is the column type? date or datetime?

Abdalla Elawad · Answer

Hi Rajanikant Hawaldar yes excatly, this is a problem .

Rajanikant Hawaldar · Answer

Hi Abdalla, When save 2/9/2019 it saves here 2 is less than are equal to 12 so only that means 2 is saving to database as month,9 is saving as date, when you select 25 its error beacuse months only 12 please check it, correct me if i understand wrong