How save data in database using insert statement with auto generated number
Introduction: Here I will explain you how to Simple save data in database using insert statement with auto generated number
Description: First i create a simple web form and take five fields id,name,address,phone,email and also take two buttons to save and new, when user click on save button your textbox data save in database using select statement and auto generate id when click on save button
Database Description:
First create table "demo1"
CREATE TABLE [dbo].[demo1](
[id] [int],
[name] [nvarchar](20) ,
[address] [nvarchar](30) ,
[phone] [nvarchar](10) ,
[email] [nvarchar](50)
) ON [PRIMARY]
aspx Page:
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
<style type="text/css">
.style1
{
width: 100%;
}
.style2
{
font-size: x-large;
font-weight: bold;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<table cellpadding="0" cellspacing="0" class="style1">
<tr>
<td>
<b></b>
</td>
<td class="style2">
Simple save data in database using insert statement with auto generated number</td>
<td>
<b></b>
</td>
</tr>
<tr>
<td align="right">
<b>Id </b>
</td>
<td>
<asp:TextBox ID="TxtId" runat="server" Enabled="False"></asp:TextBox>
</td>
</tr>
<tr>
<td align="right">
<b>Name</b></td>
<td>
<asp:TextBox ID="TxtName" runat="server"></asp:TextBox>
</td>
<td>
</td>
</tr>
<tr>
<td align="right">
<b>Address</b></td>
<td>
<asp:TextBox ID="TxtAddress" runat="server"></asp:TextBox>
</td>
<td>
</td>
</tr>
<tr>
<td align="right">
<b>Phone</b></td>
<td>
<asp:TextBox ID="TxtPhone" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td align="right">
<b>Email</b></td>
<td>
<asp:TextBox ID="TxtEmail" runat="server" Width="200px"></asp:TextBox>
</td>
<td>
</td>
</tr>
<tr>
<td>
</td>
<td>
<asp:Button ID="BtnSave" runat="server" onclick="BtnSave_Click" Text="Save" />
<asp:Button ID="BtnNew" runat="server" onclick="BtnNew_Click" Text="New" />
</td>
</tr>
<tr>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
Code Behind:
use namespace
using System.Data.SqlClient;
public partial class InseDataInDatabs : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("server=server name; database=dem123;uid=sa;pwd=sss123");
protected void Page_Load(object sender, EventArgs e)
{
}
public void GetMax()
{
string GetMax = "select isnull(max(id),0)+1 from demo1";
con.Open();
SqlCommand cmd = new SqlCommand(GetMax,con);
string result =Convert.ToString( cmd.ExecuteScalar());
TxtId.Text = result.ToString();
con.Close();
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
if (TxtId.Text == string.Empty)
{
GetMax();
con.Open();
string Query = "insert into demo1 (id,name,address,phone,email)values ('" + TxtId.Text + "','" + TxtName.Text + "','" + TxtAddress.Text + "','" + TxtPhone.Text + "','" + TxtEmail.Text + "')";
SqlCommand cmd = new SqlCommand(Query, con);
int res = cmd.ExecuteNonQuery();
con.Close();
if (res > 0)
{
RegisterStartupScript("MyAlert", "<script>alert('Record inserted Successfully')</script>");
}
}
}
catch (Exception Ex)
{
RegisterStartupScript("MyAlert", "<script>alert('"+Ex+"')</script>");
}
}
protected void BtnNew_Click(object sender, EventArgs e)
{
TxtId.Text = string.Empty;
TxtName.Text = string.Empty;
TxtAddress.Text = string.Empty;
TxtPhone.Text = string.Empty;
TxtEmail.Text = string.Empty;
}
}
Demo:
0 comments:
Post a Comment