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

Abdalla Elawad

6y833Visual Basic .NET

hi Programmer !

thank you to support me as beginner in C#

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

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abdalla Elawad6y ago
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 ?
0
Mageshwaran R6y ago
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();
0
Salman Beg6y ago
Hi.
You can use varchar datatype to save date in database.
Thanks.
0
Dinesh Gabhane6y ago
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();
0
Vrushali Ghodke6y ago
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.
0
Abdalla Elawad6y ago
Or any other correct method ? by using date with specific format
0
Abdalla Elawad6y ago
Hi MR Dinesh

yes , i want to save date as NVARCHAR
0
Dinesh Gabhane6y ago
You want to save date as a text in Database through C#?
0