Database connectivity in ASP.net

Sakshi Kaul

I have to do coding on register button but I am not able to undestand on which page do I have to do coding for register button?

My code is starting from this below line....Please help

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Registration.aspx.cs" Inherits="RegistrationForm.Registration" %>

14 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sakshi Kaul7y ago
Following is the code for registration.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Data.Sql;
using System.Configuration;
namespace RegistrationForm
{
public partial class Registration : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["RegiConnectionString"].ConnectionString);
conn.Open();
string checkuser = "select count(*) from registrationForm where EmpId='" + EmpIdTxt.Text + "'";
SqlCommand cmd = new SqlCommand(checkuser, conn);
int temp = Convert.ToInt32(cmd.ExecuteScalar().ToString());
if (temp == 1)
{
Response.Write("Employee Already Exist");
}
conn.Close();
}
}
protected void Save_Click(object sender, EventArgs e)
{
try
{

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["RegiConnectionString"].ConnectionString);
conn.Open();
string insertQuery = "insert into RegisterationForm(EmpId,Religion,Nationality,Gender,Residential asddress)values (@EmpId,@Religion,@Nationality,@Gender,@Residential Address)";
SqlCommand cmd = new SqlCommand(insertQuery, conn);
cmd.Parameters.AddWithValue("@EmpId", EmpIdTxt.Text);
cmd.Parameters.AddWithValue("@Religion", ReligionTxt.Text);
cmd.Parameters.AddWithValue("@Nationality", NationalityTxt.Text);
cmd.Parameters.AddWithValue("@Gender", GenderTxt.Text);
cmd.Parameters.AddWithValue("@Residentail Address",ResidentaiolAddressTxt.Text);
cmd.ExecuteNonQuery();

Response.Write("Employee registeration Successfully!!!thank you");

conn.Close();

}
catch (Exception ex)
{
Response.Write("error" + ex.ToString());
}
}
protected void ReligionTxt_TextChanged(object sender, EventArgs e)
{
}
protected void Edit_Click(object sender, EventArgs e)
{
}
}
}
Sakshi Kaul7y ago
I am doing the same but still not working
Sanwar Ranwa7y ago
copy the id from aspx and paste in the following query your textbox id is not match
Sakshi Kaul7y ago
the name emptxt does not contain in the current context
Sanwar Ranwa7y ago
What is error message
Sakshi Kaul7y ago
Here EMPIDTxt is also giving error
Sanwar Ranwa7y ago
1. string checkuser = "select count(*) from RegistrationForm where EmpId='" + EmpIdTxt.Text + "'";
Check this you write empid as emp id

Sakshi Kaul7y ago

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Registration.aspx.cs" Inherits="RegistrationForm.Registration" %>

Employee ID
Relogion
Nationality
Gender		Female Male
Residential Address
City
Pin Code
Personal Email-ID
Hobbies
Qualification
Emergency Contact No 1 Name 1
Mobile 1
Relation 1
Emergency Contact No 2 Name 2
Mobile 2
Relation 2
Marital Status		Married Unmarried
Anniversary Date
Spouse Name
DOB
Age
Child1 Name1
DOB1
Age1
Child 2 Name2
DOB2
Age2
Child 3 Name3
DOB3
Age3
Child 4 Name 4
DOB4
Age 4
Father(Name/DOB/Age)
Father(Name/DOB/Age)
Mother(Name/DOB/Age)
Mother(Name/DOB/Age)