While I have insert value in databas table , New id should b

Question

While I have insert value in databas table , New id should be generate (009412001)009412 is emp id and 001 is TA id same is display in javascript popup.

indradeo kumar · Answer

i have share my code. .aspx "C#" AutoEventWireup= "true" Codefile= "ITBanner.aspx.cs" Inherits= "TAClaim.ITBanner" %> "http://www.w3.org/1999/xhtml" > "server" > "text/css" > .auto-style1 { width: 100%; } .auto-style4 { color: #FFFFCC; } .auto-style5 { height: 24px; } .auto-style6 { text-align: right; } .auto-style7 { width: 146px; } .auto-style8 { height: 347px; } .auto-style9 { height: 26px; } "#B7FFC9" class = "auto-style8" > "form1" runat= "server" > "label1" runat= "server" Text= "Label" > "TextBox12" runat= "server" > class = "auto-style1" > class = "auto-style6" >Emp.ID "2" > "TextBox1" runat= "server" > First Name "TextBox2" runat= "server" > "2" >Last Name "TextBox3" runat= "server" > class = "auto-style5" > "Label9" runat= "server" Text= "Designation" > class = "auto-style5" > "TextBox4" runat= "server" > class = "auto-style5" colspan= "2" >Basic Pay class = "auto-style5" > "TextBox5" runat= "server" > "Label10" runat= "server" Text= "Department" > "TextBox6" runat= "server" > "2" >Tour Comm Dt "TextBox7" runat= "server" > class = "auto-style9" > "Label11" runat= "server" Text= "Mobile No." > class = "auto-style9" > "TextBox8" runat= "server" > "2" class = "auto-style9" >Tour No class = "auto-style9" > "TextBox9" runat= "server" > "Label12" runat= "server" Text= "Level" > "TextBox10" runat= "server" > "2" >Advance from Proj "TextBox11" runat= "server" > "Button1" runat= "server" Text= "Retrive data" onclick= "Button1_Click" /> "2" class = "auto-style7" > "lbl1" runat= "server" BackColor= "white" Font-Bold= "True" ForeColor= "Red" CssClass= "auto-style4" > "2" > "Label13" runat= "server" > "Button2" runat= "server" OnClick= "btnSave_Click" Text= "Button" /> "lblUserID" runat= "server" BackColor= "white" Font-Bold= "True" ForeColor= "Red" CssClass= "auto-style4" > "Literal1" runat= "server" > .cs 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; namespace TAClaim { public partial class ITBanner : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings[ "constr" ].ConnectionString; SqlCommand com; string str; SqlConnection con = new SqlConnection(@ "Data Source=(localdb)\Projects;Initial Catalog=Employee;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;" ); protected void Page_Load( object sender, EventArgs e) { } protected void Button1_Click( object sender, EventArgs e) { clear(); idcheck(); SqlConnection con = new SqlConnection(connStr); con.Open(); str = "select * from emp_mast1 where empid='" + TextBox1.Text.Trim() + "'" ; com = new SqlCommand(str, con); SqlDataReader reader = com.ExecuteReader(); if (reader.Read()) { TextBox2.Text = reader[ "firstname" ].ToString(); TextBox3.Text = reader[ "lastname" ].ToString(); TextBox4.Text = reader[ "designation" ].ToString(); TextBox6.Text = reader[ "department" ].ToString(); TextBox8.Text = reader[ "mobile" ].ToString(); TextBox10.Text = reader[ "level" ].ToString(); reader.Close(); con.Close(); } } public void idcheck() { SqlConnection con = new SqlConnection(connStr); con.Open(); str = "select count(*)from emp_mast1 where empid='" + TextBox1.Text + "'" ; com = new SqlCommand(str, con); int count = Convert.ToInt32(com.ExecuteScalar()); if (count > 0) { lbl1.Text = "Id Does Exist" ; } else { lbl1.Text = "Id Does not Exist" ; } } void clear() { TextBox2.Text = "" ; TextBox3.Text = "" ; TextBox4.Text = "" ; TextBox5.Text = "" ; TextBox6.Text = "" ; TextBox7.Text = "" ; TextBox8.Text = "" ; TextBox9.Text = "" ; TextBox10.Text = "" ; TextBox11.Text = "" ; } protected void btnSave_Click( object sender, EventArgs e) { SqlCommand cmd = new SqlCommand( "insert into registration(empid,firstname,lastname,designation,department,mobile,Basic_Pay,Tour_Comm_Dt,Tour_No,Level,Advance_from_Proj,) values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox6.Text + "','" + TextBox8.Text + "','" + TextBox7.Text + "','" + TextBox5.Text + "','" + TextBox9.Text + "','" + TextBox10.Text + "','" + TextBox11.Text + "')" , con); cmd.CommandType = CommandType.Text; SqlDataAdapter sda = new SqlDataAdapter( "Select * from registration" , con); DataTable dt = new DataTable(); sda.Fill(dt); int i = dt.Rows.Count; string cnt = Convert.ToString(i + 1); try { con.Open(); cmd.ExecuteNonQuery(); Literal1.Text = "Generate successfully" ; con.Close(); clear(); } catch (Exception ex) { Literal1.Text = ex.Message; } } } tabale structure:- CREATE TABLE [dbo].[TA] ( [TAId] INT IDENTITY (1, 1) NOT NULL , [empid] NCHAR (10) NULL , [firstname] VARCHAR (50) NULL , [lastname] VARCHAR (50) NULL , [designation] VARCHAR (50) NULL , [department] VARCHAR (50) NULL , [mobile] NCHAR (10) NULL , [ level ] NCHAR (10) NULL , [ Basic_Pay] NCHAR (10) NULL , [ Tour_Comm_Dt] NCHAR (10) NULL , [ Tour_No] NCHAR (10) NULL , [Advance_from_Proj] NCHAR (10) NULL , PRIMARY KEY CLUSTERED ([Id] ASC ) ); }

Ramachandran M · Answer

Hi, Create trigger and update perticular table column after insert the record Example : CREATE TRIGGER AutoincTourID ON TABLENAME AFTER INSERT AS BEGIN SET NOCOUNT ON; DECLARE @USERID INT DECLARE @INSERTEDID INT DECLARE @TAID INT SELECT @USERID =I.USERID ,@TAID=FORMAT(CAST(TAID AS INT),'000','en-US'), @INSERTEDID =I.PRIMARYID FROM inserted i UPDATE TABLENAME SET COLUMNAME = USERID+@TAID WHERE ID =@INSERTEDID

indradeo kumar · Answer

TA is Tour claim id. which is I have one project Tour and claim. here , While user insert details from taxt box then id should be generate. generate (009412001)009412 is emp id and 001.emp id and TA id both is table column name. like user insert empid-009412 then TA should be generate autoincreament 00941200 1 ,009412002,009412003 etc.

Rupesh Kahane · Answer

Do you have used Primary key? if yes then Is it auto incemental? What TA? Let us know what you are going to achieve so we can guide you

Ramachandran M · Answer

Hi Kumar, Please elabrate the requirement clearly..