Hi sagarnayak
Here is an example of saving textbox value to database with datatype datetime
I have use AjaxControlToolKit
HTML :
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
body
{
font-family: Arial;
font-size: 10pt;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<cc1:ToolkitScriptManager ID="ScriptManager1" runat="server">
</cc1:ToolkitScriptManager>
<div>
<table border="0" cellpadding="0" cellspacing="0" width="30%">
<tr>
<td>
Name:
</td>
<td>
<asp:TextBox ID="txtName" runat="server" />
</td>
</tr>
<tr>
<td>
In Date:
</td>
<td>
<asp:TextBox ID="txtDate" runat="server" />
<asp:Image ID="imgCalendar" ImageUrl="~/Images/Calendar.png" runat="server" />
<cc1:CalendarExtender ID="ceDate" runat="server" TargetControlID="txtDate" BehaviorID="ceDate"
PopupButtonID="imgCalendar">
</cc1:CalendarExtender>
</td>
</tr>
<tr>
<td>
</td>
<td>
<asp:Button ID="btnSubmit" Text="Submit" OnClick="Submit" runat="server" />
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
C# :
protected void Submit(object sender, EventArgs e)
{
string name = txtName.Text.Trim();
DateTime date = Convert.ToDateTime(txtDate.Text.Trim());
string conString = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
string query = "INSERT INTO LogDate(Name, InDate) VALUES (@Name, @InDate)";
using (SqlCommand cmd = new SqlCommand(query, con))
{
cmd.Parameters.AddWithValue("@Name", name);
cmd.Parameters.AddWithValue("@InDate", date);
cmd.ExecuteNonQuery();
}
}
}
Namespace :
using System.Data.SqlClient;
TABLE :
CREATE TABLE [dbo].[LogDate](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](50) NULL,
[InDate] [date] NULL
) ON [PRIMARY]
GO
Regards
Sajid Dhukka