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".

ToolBox

Step 2: Code

code
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Text;
  7. using System.Windows.Forms;
  8. using System.Data.SqlClient;
  9. namespace First_Csharp_app
  10. {
  11. public partial class Form1 : Form
  12. {
  13. public Form1()
  14. {
  15. InitializeComponent();
  16. }
  17. String gender; //we have to define this
  18. private void button1_Click(object sender, EventArgs e)
  19. {
  20. SqlConnection con = new SqlConnection(str);
  21. String str = "server=MUNESH-PC;database=windowapp;UID=sa;password=123";
  22. 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+"')";
  23. SqlCommand cmd = new sqComamnd(query,con); SqlDataReader dbr;

  25. try{con.open();
  26. {
  27. dbr = cmd.ExecuteReader();MessageBox.Show("saved");while(dbr.read()){}
  28. }
  29. catch (Exception es)
  30. {
  31. MessageBox.Show(es.Message);
  32. }
  33. }

  35. private void rediobutton1.checked(object sender, EventArgs e)
  36. {
  37. gender = "male";
  38. }
  39. private void rediobutton1.checked(object sender, EventArgs e)
  40. {
  41. gender = "female";
  42. }
  43. }
  44. }
Step 3: Output

Run your application:

saved

you can go on my Blog_Munesh