In this blog we will create autogenerated id in textbox at
runtime dynamically. So that user does not required to fill this.
Table Creation
Create table employee(empid varchar(50),empname
varchar(50),sal int)
Default.aspx code
<%@ Page Language="C#" AutoEventWireup="true"
CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!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>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" runat="server" Text="EmpId" Font-Bold="True"
Width="100px"></asp:Label>
<asp:TextBox ID="txt_empid" runat="server"></asp:TextBox><br />
<asp:Label ID="Label2" runat="server" Text="EmpName" Font-Bold="True" Width="100px"></asp:Label>
<asp:TextBox ID="txt_empname" runat="server"></asp:TextBox><br />
<asp:Label ID="Label3" runat="server" Text="Salary" Font-Bold="True" Width="100px"></asp:Label>
<asp:TextBox ID="txt_sal" runat="server"></asp:TextBox><br />
</div>
<asp:Button ID="btn_insert" runat="server" onclick="btn_insert_Click"
Text="Insert
Data" /><br />
<asp:Label ID="Label4" runat="server"></asp:Label>
</form>
</body>
</html>
Default.aspx.cs code
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class _Default
: System.Web.UI.Page
{
string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
string str;
SqlCommand com;
int count;
protected void Page_Load(object
sender, EventArgs e)
{
SqlConnection con = new SqlConnection(strConnString);
str = "select count(*)
from employee";
com = new SqlCommand(str, con);
con.Open();
count = Convert.ToInt16(com.ExecuteScalar())
+ 1;
txt_empid.Text = "E00"
+ count;
con.Close();
}
protected void btn_insert_Click(object
sender, EventArgs e)
{
SqlConnection con = new SqlConnection(strConnString);
con.Open();
str = "insert into
employee values('" + txt_empid.Text.Trim() + "','" + txt_empname.Text.Trim() + "'," + txt_sal.Text.Trim() + ")";
com = new SqlCommand(str, con);
com.ExecuteNonQuery();
con.Close();
Label4.Text = "Records
successfully Inserted";
}
}
Thanks for reading