steps:
1) Create Simple web application (asp.net with C#).
2) create below table in the database. here i made table (table_1 in test database).
DataBase Name :Test
Table Name : Table_1
ColumnName ColumnDataType
id int (Auto Increment & Primary Key)
code varchar(50) (Allow Null True)
date datetime (Allow Null True)
3) put the below control on the form.
3.1) Calendar (id --> Calendar1)
3.2) Button (id --> btnInsert)
3.3) Button (id --> btnGet)
3.4) Label (id --> lblDataValue)
4) put the below code in to C# page.
Add below name space first :
Thanks.
1) Create Simple web application (asp.net with C#).
2) create below table in the database. here i made table (table_1 in test database).
DataBase Name :Test
Table Name : Table_1
ColumnName ColumnDataType
id int (Auto Increment & Primary Key)
code varchar(50) (Allow Null True)
date datetime (Allow Null True)
3) put the below control on the form.
3.1) Calendar (id --> Calendar1)
3.2) Button (id --> btnInsert)
3.3) Button (id --> btnGet)
3.4) Label (id --> lblDataValue)
4) put the below code in to C# page.
Add below name space first :
using System.Data.SqlClient; copy the below code and check.
//connection string
//please change as per your server and database
string constr = @"Data Source=(local);Initial Catalog=test;Integrated Security=True";
public int insertedId
{
get { return Convert.ToInt32(ViewState["inserttedid"]); }
set { ViewState["inserttedid"] = value; }
}
protected void btnInsert_Click(object sender, EventArgs e)
{
//if user is not selected any value from calendar at that time null is inserted
//otherwise selected date is inserted
string datetime = Calendar1.SelectedDate.Date.Equals(DateTime.MinValue) == true ? "Null" : "'" + Calendar1.SelectedDate + "'";
string strins = "insert into table_1 values " +
"('amit'," + datetime + ");select scope_identity();";
SqlConnection sqlcon = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand(strins, sqlcon);
sqlcon.Open();
//get the id of inserted row using Scope_Identity function
insertedId = Convert.ToInt32(cmd.ExecuteScalar());
sqlcon.Close();
}
protected void btnGet_Click(object sender, EventArgs e)
{
//get the inserted record
string strSelect = "Select * from table_1 where id =" + insertedId;
SqlConnection sqlcon = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand(strSelect, sqlcon);
sqlcon.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
//set the value in the label for display purpose
lblDataValue.Text = dr["date"] == System.DBNull.Value ? DateTime.MinValue.ToShortDateString() : Convert.ToString(dr["date"]);
}
sqlcon.Close();
}
Thanks.
Comments