.aspx Page
<asp:TextBox ID="txtReg_No" runat="server" CssClass="form-control" Placeholder="Reg. No"
ReadOnly="true"></asp:TextBox>
<asp:TextBox ID="txtName" runat="server" CssClass="form-control" Placeholder="Name"></asp:TextBox>
<asp:TextBox ID="txtAge" runat="server" CssClass="form-control" Placeholder="Age"></asp:TextBox>
<asp:TextBox ID="txtEmail_Id" runat="server" CssClass="form-control" Placeholder="Email_Id"></asp:TextBox>
<asp:TextBox ID="txtMobile_No" runat="server" CssClass="form-control" Placeholder="Mobile_No"></asp:TextBox>
<asp:TextBox ID="txtAddress" runat="server" CssClass="form-control" Placeholder="Address"></asp:TextBox>
<asp:TextBox ID="txtRemarks" runat="server" CssClass="form-control" Placeholder="Remarks"></asp:TextBox>
<asp:Button ID="btnSave" runat="server" Text="Save" CssClass="btn btn-primary btn-lg"
OnClick="btnSave_Click" />
Web.config
<connectionStrings>
<add name="conStringsql" connectionString="user id=sa;password=admin;initial catalog=DatabaseName;data source=.\SQLEXPRESS; Integrated Security=false;"/>
</connectionStrings>
.aspx.cs
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
public static SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conStringsql"].ConnectionString.ToString());
// Auto Registration No Generate
int count;
void autogeneratedReg()
{
con.Open();
SqlCommand cmd = new SqlCommand("select count(*) from Simple_Registration_Form", con);
count = Convert.ToInt16(cmd.ExecuteScalar()) + 1;
string RegNo = "R" + count.ToString();
txtReg_No.Text = RegNo.ToString();
con.Close();
}
protected void btnSave_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = new SqlCommand("insert into Simple_Registration_Form values ('"+txtReg_No.Text+"','"+txtName.Text+"','"+txtAge.Text+"','"+txtEmail_Id.Text+"','"+txtMobile_No.Text+"','"+txtAddress.Text+"','"+txtRemarks.Text+"')", con);
cmd.ExecuteNonQuery();
con.Close();
}
<asp:TextBox ID="txtReg_No" runat="server" CssClass="form-control" Placeholder="Reg. No"
ReadOnly="true"></asp:TextBox>
<asp:TextBox ID="txtName" runat="server" CssClass="form-control" Placeholder="Name"></asp:TextBox>
<asp:TextBox ID="txtAge" runat="server" CssClass="form-control" Placeholder="Age"></asp:TextBox>
<asp:TextBox ID="txtEmail_Id" runat="server" CssClass="form-control" Placeholder="Email_Id"></asp:TextBox>
<asp:TextBox ID="txtMobile_No" runat="server" CssClass="form-control" Placeholder="Mobile_No"></asp:TextBox>
<asp:TextBox ID="txtAddress" runat="server" CssClass="form-control" Placeholder="Address"></asp:TextBox>
<asp:TextBox ID="txtRemarks" runat="server" CssClass="form-control" Placeholder="Remarks"></asp:TextBox>
<asp:Button ID="btnSave" runat="server" Text="Save" CssClass="btn btn-primary btn-lg"
OnClick="btnSave_Click" />
Web.config
<connectionStrings>
<add name="conStringsql" connectionString="user id=sa;password=admin;initial catalog=DatabaseName;data source=.\SQLEXPRESS; Integrated Security=false;"/>
</connectionStrings>
.aspx.cs
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
public static SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conStringsql"].ConnectionString.ToString());
// Auto Registration No Generate
int count;
void autogeneratedReg()
{
con.Open();
SqlCommand cmd = new SqlCommand("select count(*) from Simple_Registration_Form", con);
count = Convert.ToInt16(cmd.ExecuteScalar()) + 1;
string RegNo = "R" + count.ToString();
txtReg_No.Text = RegNo.ToString();
con.Close();
}
protected void btnSave_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = new SqlCommand("insert into Simple_Registration_Form values ('"+txtReg_No.Text+"','"+txtName.Text+"','"+txtAge.Text+"','"+txtEmail_Id.Text+"','"+txtMobile_No.Text+"','"+txtAddress.Text+"','"+txtRemarks.Text+"')", con);
cmd.ExecuteNonQuery();
con.Close();
}
No comments:
Post a Comment