Is there a logic if i saved date as text on database / c# ?

Question

hi Programmer ! thank you to support me as beginner in C# Is there a logic if i saved date as text on database ?

Dinesh Gabhane · Answer

You can try something like below code SqlConnection con = new SqlConnection( "Data Source=localhost;initial catalog= LocalTest;Integrated Security=True;" ); con.Open(); SqlCommand command = new SqlCommand( "SP_TimeOnlyTest" , con); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add( new SqlParameter( "@timeonly" , SqlDbType.NVarChar, 0, "timeonly" )); DateTime thisTime = DateTime.Now; command.Parameters[0].Value = thisTime.Hour.ToString() + ":" + thisTime.Minute.ToString() + ":" + thisTime.Second.ToString(); int i = command.ExecuteNonQuery(); con.Close();

Dinesh Gabhane · Answer

You want to save date as a text in Database through C#?

Abdalla Elawad · Answer

I want to save date as correct way , because i select data type on sql as date when i save this date only save small date like 02/02/209 but i can not save big date like 29/02/2019 Why ?

Mageshwaran R · Answer

Hi, Try this code: CREATE TABLE TABLE_NAME(DATE_FORAMT NVARCHAR(50)) SqlConnection sqlCon = new SqlConnection( "ConnectionString" ); SqlCommand sqlCmnd = new SqlCommand( "INSERT INTO TABLE_NAME DATE_FORAMT VALUES(@DATE_FORAMT) " , sqlCon); sqlCmnd.Parameters.AddWithValue( "@DATE_FORAMT" , txtdate.text); sqlCmnd.ExecuteNonQuery();

Salman Beg · Answer

Hi. You can use varchar datatype to save date in database. Thanks.

Vrushali Ghodke · Answer

Hi, Abdalla elawad, can you please clear your question what do you want to do save date as text on the database means in words format or just want to save as nvarchar data type? If you want to save the date as text in the database so just select the datatype nvarchar of that column in which you want to save the date.

Abdalla Elawad · Answer

Or any other correct method ? by using date with specific format

Abdalla Elawad · Answer

Hi MR Dinesh yes , i want to save date as NVARCHAR