I have designed one form as client in this form i take ADD, UPDATE etc button to insert , update databse. In client database table client id is primary key and in my user interface i have take one textbox for client id to enter the primary key value.
But my question is i want to generate the value of the primary key or client id is automatically generated i dont want that user enter the primary key value when i click ADD button.
Hope that you get my question.
Thanks for your time and consideration. I look forward to receive reply. Thanks & Regards
Farukh
Satyapriya NayakPosted Dec 30, 2011, 2:51 AM
Try this...
Table Creation
Create table employee(empid varchar(50) primary key identity,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 Pagetitle>
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
If this post helps you mark it as answer
AartiPosted Dec 30, 2011, 2:43 AM
to generate clientid automatically
Define Client id as IDENTITY at the time of Table creation.
For example :
create table AddTable (id int identity ,name varchar(50),addr varchar(50));
insert into AddTable(name,addr) values('raj','pune'),('rohit','mumbai'),('diya','pune')
select * from AddTable;