How to Use DateTime Picker and Save in Database in Window Form

Here i will explain how to DateTime Picker and how to save its value in database.

Step 1: Form

Drag and down a Datetime Picker from ToolBox. and go its property and set "Custom Format" as"yyyy-mm-dd", and other property "Format" as "custom".



Step 2: Code

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace First_Csharp_app
{
      public partial class Form1 : Form
      {
            public Form1()
            {
                  InitializeComponent();
            }
            String gender; //we have to define this
            private void button1_Click(object sender, EventArgs e)
            {
                  SqlConnection con = new SqlConnection(str);
                  String str = "server=MUNESH-PC;database=windowapp;UID=sa;password=123";
                  String query = "insert into data (E.id,name,surname,age,gender,DOB) values ('"+this.eid_txt.tex                  t+"','"+this.nametxt.text+"','"+this.surname_txt.text+"','"+this.age_txt.text+"' , '"+this.gend                  er+"' , '"+this.DateTimePicker1.Text+"')";
                  SqlCommand cmd = new sqComamnd(query,con); SqlDataReader dbr;

                  try{con.open();
                  {
                        dbr = cmd.ExecuteReader();MessageBox.Show("saved");while(dbr.read()){}
                  }
                  catch (Exception es)
                  {
                        MessageBox.Show(es.Message);
                  }
            }

            private void rediobutton1.checked(object sender, EventArgs e)
            {
                  gender = "male";
            }
            private void rediobutton1.checked(object sender, EventArgs e)
            {
                  gender = "female";
            }
      }
}

Step 3: Output

Run your application:



you can go on my Blog_Munesh