increment string value by 1 on button click? [Resolved]

Posted by Shameer.Ali87 under C# on 3/1/2013 | Points: 10 | Views : 3480 | Status : [Member] | Replies : 3
hi all,

I want to give a userid for the users who register for my site..
Here my first user will get an id like CS001, and it will be incremented on each user registration like CS002,CS003 and so on...
any help will be thankful..

shameer ali shaik


Responses

Posted by: Satyapriyanayak on: 3/2/2013 [Member] [MVP] Silver | Points: 50

Up
0
Down

Resolved
<%@ 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>


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)
{
if (!IsPostBack)
{
autogenerated();

}
}

void autogenerated()
{
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.ToString();
txt_empid.Enabled = false;
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";
txt_empname.Text = "";
txt_sal.Text = "";
autogenerated();
}
}


If this post helps you mark it as answer
Thanks

Shameer.Ali87, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Murugavelmsc on: 3/2/2013 [Member] Starter | Points: 25

Up
0
Down
Hi,

Refer:
http://www.dotnetspider.com/resources/43204-How-create-Alphanumeric-Auto-Increment.aspx

Regards,
Murugavel S
murugavel.sadagopan@gmail.com
http://murugavelmsc.blogspot.in/

Shameer.Ali87, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Shameer.Ali87 on: 3/4/2013 [Member] Starter | Points: 25

Up
0
Down
@Satyapriyanayak,

thanks for your answer,
changing your code, i cleared my requirement,
thanks for it...

shameer ali shaik

Shameer.Ali87, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response