Fetch calendar date in text box using Asp webfrom

<asp:Calendar ID="Calendar1" runat="server" BackColor="#FFFFCC" BorderColor="#FFCC66" BorderWidth="1px" DayNameFormat="Shortest" Font-Names="Verdana" Font-Size="8pt" ForeColor="#663399" Height="200px" OnSelectionChanged="Calendar1_SelectionChanged" ShowGridLines="True" Width="220px">

<DayHeaderStyle BackColor="#FFCC66" Font-Bold="True" Height="1px" />

<NextPrevStyle Font-Size="9pt" ForeColor="#FFFFCC" />

<OtherMonthDayStyle ForeColor="#CC9966" />

<SelectedDayStyle BackColor="#CCCCFF" Font-Bold="True" />

<SelectorStyle BackColor="#FFCC66" />

<TitleStyle BackColor="#990000" Font-Bold="True" Font-Size="9pt" ForeColor="#FFFFCC" />

<TodayDayStyle BackColor="#FFCC66" ForeColor="White" />

</asp:Calendar>

<br />

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

protected void Calendar1_SelectionChanged(object sender, EventArgs e)

{

TextBox1.Text = Calendar1.SelectedDate.Date.ToString("dd/MM/yyyy");

}

CRUD operation using ADO .NET ,WEB FROM

In design Page

<tr>

<td style="width: 30%; text-align: left">Name</td>

<td style="width: 70%; text-align: left">

<asp:TextBox ID="txtName" runat="server" Width="80%"></asp:TextBox>

</td>

</tr>

<tr>

<td style="width: 30%; text-align: left">Roll</td>

<td style="width: 70%; text-align: left">

<asp:TextBox ID="txtRoll" runat="server" Width="80%"></asp:TextBox> </td>

</tr>

<tr>

<td >

<asp:Button ID="btnInsert" runat="server" OnClick="btnInsert_Click" Text="Insert" />

</td>

</tr>

</tr>

<tr>

<td >

<asp:Button ID="btnInsert" runat="server" OnClick="btnInsert_Click" Text="Insert" />

</td>

</tr>

Add connection string

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnStudent_db"].ConnectionString);

<configuration>

<connectionStrings>

<add name="ConnStudent_db" connectionString="Data Source=.; Initial catalog=Student_db; Uid=sa; Pwd=anita" providerName="System.Data.SqlClient"/>

</connectionStrings>

Or

SqlConnection con = new SqlConnection("Data Source=.; Initial catalog=Student_db; Uid=sa; Pwd=anita");

To insert data

protected void btnInsert_Click(object sender, EventArgs e)

{

int roll = Convert.ToInt32(txtRoll.Text);

string name = txtName.Text;

SqlDataAdapter adp = new SqlDataAdapter("INSERT INTO STUD(ROLL,NAME) VALUES("+roll+",'"+name+"')",con);

DataTable dt = new DataTable();

adp.Fill(dt);

Clear();

}

void Clear()

{

txtRoll.Text = "";

txtName.Text = "";           

txtRoll.Focus();

}

To update data

protected void btnEdit_Click(object sender, EventArgs e)

{

GridViewRow row = (sender as Button).Parent.Parent as GridViewRow;

HiddenField hdf = (HiddenField)row.FindControl("hdnStdid");

hdnStdid1.Value = hdf.Value;

txtRoll.Text = row.Cells[0].Text;

txtName.Text = row.Cells[1].Text;

}

protected void btnUpdate_Click(object sender, EventArgs e)

{

int roll = Convert.ToInt32(txtRoll.Text);

string name = txtName.Text;

SqlDataAdapter adp = new SqlDataAdapter("UPDATE STUD SET ROLL=" + roll + ",NAME='" + name + "' WHERE STDID=" + hdnStdid1.Value + "", con);

DataTable dt = new DataTable();

adp.Fill(dt);

Clear();

ShowGrid();

}

To Delete Data

SqlDataAdapter adp = new SqlDataAdapter("DELETE FROM STUD WHERE STDID=" + hdnStdid1.Value + "", con);

DataTable dt = new DataTable();

adp.Fill(dt);

Clear();

ShowGrid();

To Show data on grid 

         

void ShowGrid()

{

SqlDataAdapter adp = new SqlDataAdapter("SELECT * FROM STUD", con);

DataTable dt = new DataTable();

adp.Fill(dt);

GridView1.DataSource = dt;

GridView1.DataBind();

}