Dynamically creating autogenerated id in textbox

By Satyapriya Nayak Sep 28, 2011
In this blog we will create autogenerated id in textbox at runtime dynamically. So that user does not required to fill this.
Download Files: Dynamically creating

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

Satyapriya Nayak

Satyapriya Nayak is a software developer from Bhubaneswar, India. He holds a Bachelor's degree in Electronics and telecommunication and is an active member of C# Corner. 

COMMENT USING

PREMIUM SPONSORS

Hire Mobile & Web Developer on demand. 100% satisfaction. Try for 1 week or Money Back. Local and remote developers available all over USA.

Latest Blogs