<!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 id="Head1" runat="server">
<title>Sample Registration Page</title>
<style type="text/css">
.style1
{
width: 100%;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<table class="style1">
<tr>
<td>
Full Name:</td>
<td>
<asp:TextBox ID="TxtName" runat="server"><asp:TextBox>
</td>
</tr>
<tr>
<td>
Username:</td>
<td>
<asp:TextBox ID="TxtUserName" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Password:</td>
<td>
<asp:TextBox ID="TxtPassword" runat="server" TextMode="Password"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Re Password:</td>
<td>
<asp:TextBox ID="TxtRePassword" runat="server" TextMode="Password"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Address:</td>
<td>
<asp:TextBox ID="TxtAddress" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Age:</td>
<td>
<asp:TextBox ID="TxtAge" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Gender:</td>
<td>
<asp:DropDownList ID="DropDownList1" runat="server" AppendDataBoundItems="true">
<asp:ListItem Value="-1">Select</asp:ListItem>
<asp:ListItem>Male</asp:ListItem>
<asp:ListItem>Female</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
</table>
</div>
<asp:Button ID="Button1" runat="server" Text="Save" onclick="Button1_Click" />
</form>
</body>
</html>
As you can see, the UI is very simple. Now let’s set up the connection string.
STEP3: Setting up the Connection String
In your web.config file set up the connection string there as shown below:
<connectionStrings>
<add name="MyConsString" connectionString="Data Source=WPHVD185022-9O0;Initial Catalog=MyDatabase;Integrated Security=SSPI;"
providerName="System.Data.SqlClient" />
</connectionStrings>
Note: MyConsString is the name of the Connection String that we can use as a reference in our codes for setting the connection string later.
STEP4: Calling up the ConnectionString in our codes
Here’s the method for calling the connection string that was set up in the web.config file.
public string GetConnectionString()
{
//sets the connection string from your web config file "ConnString" is the name of your Connection String
return System.Configuration.ConfigurationManager.ConnectionStrings["MyConsString"].ConnectionString;
}
STEP5: Writing the method for inserting the data from the registration page to the database.
In this demo, we are using the ADO.NET objects for manipulating the data from the page to the database. If you are not familiar with ADO.NET then I would suggest you to refer the following link below to get started:
ADO.NET Tutorial
Here’s the code block for inserting the data to the database.
private void ExecuteInsert(string name, string username, string password, string gender, string age, string address)
{
SqlConnection conn = new SqlConnection(GetConnectionString());
string sql = "INSERT INTO tblRegistration (Name, UserName, Password, Gender, Age, Address) VALUES "
+ " (@Name,@UserName,@Password,@Gender,@Age,@Address)";
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlParameter[] param = new SqlParameter[6];
//param[0] = new SqlParameter("@id", SqlDbType.Int, 20);
param[0] = new SqlParameter("@Name", SqlDbType.VarChar, 50);
param[1] = new SqlParameter("@UserName", SqlDbType.VarChar, 50);
param[2] = new SqlParameter("@Password", SqlDbType.VarChar, 50);
param[3] = new SqlParameter("@Gender", SqlDbType.Char, 10);
param[4] = new SqlParameter("@Age", SqlDbType.Int, 100);
param[5] = new SqlParameter("@Address", SqlDbType.VarChar, 50);
param[0].Value = name;
param[1].Value = username;
param[2].Value = password;
param[3].Value = gender;
param[4].Value = age;
param[5].Value = address;
for (int i = 0; i < param.Length; i++)
{
cmd.Parameters.Add(param[i]);
}
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
catch (System.Data.SqlClient.SqlException ex)
{
string msg = "Insert Error:";
msg += ex.Message;
throw new Exception(msg);
}
finally
{
conn.Close();
}
}
STEP6: Calling the method ExecuteInsert()
You can call the method above at Button_Click event for saving the data to the database. Here’s the code block below:
protected void Button1_Click(object sender, EventArgs e)
{
if (TxtPassword.Text == TxtRePassword.Text)
{
//call the method to execute insert to the database
ExecuteInsert(TxtName.Text, TxtUserName.Text, TxtPassword.Text, DropDownList1.SelectedItem.Text, TxtAge.Text, TxtAddress.Text);
Response.Write("Record was successfully added!");
ClearControls(Page);
}
else
{
Response.Write("Password did not match");
TxtPassword.Focus();
}
}
As you can see from the above code block, we check the value of the TxtPassword and TxtRePassword to see if match. If it match then call the method ExecuteInsert else display the error message stating that the “Password did not match”.
You also noticed that we call the method ClearControls for clearing the Text fields in the page. See the code block below for the ClearControls method:
public static void ClearControls(Control Parent)
{
if (Parent is TextBox)
{ (Parent as TextBox).Text = string.Empty; }
else
{
foreach (Control c in Parent.Controls)
ClearControls(c);
}
}
That’s it! Hope you will find this example useful!
You can also create procedure and do the same thing in this way : Example
string project = ((TextBox)taskinsert.FooterRow.FindControl("addproject")).Text;
string task = ((TextBox)taskinsert.FooterRow.FindControl("addTask")).Text;
string des = ((TextBox)taskinsert.FooterRow.FindControl("addDescrip")).Text;
string empcode = ((TextBox)taskinsert.FooterRow.FindControl("addMember")).Text;
string status = "0";
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Enigma"].ToString().Trim());
SqlCommand cmd = new SqlCommand("addtask", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@empcode", SqlDbType.NVarChar).Value = empcode;
cmd.Parameters.Add("@project", SqlDbType.NVarChar).Value = project;
cmd.Parameters.Add("@task", SqlDbType.VarChar).Value = task;
cmd.Parameters.Add("@description", SqlDbType.VarChar).Value = des;
cmd.Parameters.Add("@stat", SqlDbType.VarChar).Value = status;
con.Open();
int j = cmd.ExecuteNonQuery();
if (j > 0)
{
lblgridmsg.Text = "Task Inserted successfully";
project = "";
task= "";
des = "";
empcode = "";
}
No comments:
Post a Comment