Insert Datetimepicker text in SQL Database

how to Insert Datetimepicker text in SQL Database as datetime data开发者_开发知识库type

---

In order to parse the datetime from datetime picker you can do the following:

string dt = dateTimePicker.Value.ToString("yyyy-MM-dd hh:mm:ss");

And then in order to insert it in your database you can do:

Insert into table (id, mytime) 
values("5",  CONVERT(datetime, CONVERT( varchar(11), dt, 101))

If you need information on how to access your database you can read the following article in CodeProject

---

Parse the text in C#, and insert the parsed DateTime. Example:

var date = new DateTime(dateTimePickerText);
InsertIntoSqlDatabase(date); // Code for inserting here.

---

You can insert date as DateTime directly (without converting into string) by using DataRow. For example:

  using (SqlConnection sqlconn = new SqlConnection())
        {
            sqlconn.ConnectionString = @"Data Source = #your_serwer\instance#; Initial Catalog = #db_name#; User Id = #user#; Password = #pwd#;";
            sqlconn.Open();

            // select your date and a key index field on a table (e.g. "id")
            string sql = "select id, some_date from table_1 where id = 1 ";

            using (SqlDataAdapter adapter = new SqlDataAdapter(sql, sqlconn))
            {
                using (DataTable table = new DataTable())
                {
                    adapter.Fill(table);                       

                    DataRow r = null;
                    if (table.Rows.Count == 1)
                        r = table.Rows[0];   // case, when there is an row for update
                    else
                        r = table.NewRow();  // case, when there is no row, and you would like to insert one

                    r.BeginEdit();
                    // here you assign your value
                    r["some_date"] = dateTimePicker.Value;
                    r.EndEdit();

                    if (table.Rows.Count == 0)
                    {
                        // in case of insert, provide here some other values for other non null columns like
                        r["id"] = 2;
                        // also you have to add this row into DataTable
                        table.Rows.Add(r);
                    }

                    // this will update the database
                    SqlCommandBuilder mySqlCommandBuilder = new SqlCommandBuilder(adapter);
                    adapter.Update(table);
                }
            }
        }

Hope, this helps.