Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Error about Store Procedure

Author  Topic 

yvette
Yak Posting Veteran

74 Posts
Posted - 2010-09-14 : 04:34:50
HI,
i'm doing registration page with asp.net c# and sql server 2008.

this is my c# code behind (it state the error that could not found store procedure)


public string GetConnectionString()
{
return System.Configuration.ConfigurationManager.ConnectionStrings["cwConnectionString1"].ConnectionString;
}

protected void btnRegister_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(GetConnectionString());

string sql = "INSERT INTO Employee (LastName, FirstName, [Identity], Gender, Race, Marital, Religion, DOB, Address, PostalCode, State, Nationality, HomeTel, MobileNo, LicenseNo, LicenseExpiry, Position) VALUES " + " (@LastName, @FirstName, @Identity, @Gender, @Race, @Marital, @Religion, @DOB, @Address, @PostalCode, @State, @Nationality, @HomeTel, @MobileNo, @LicenseNo, @LicenseExpiry, @Position)";

try
{
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.CommandType = CommandType.StoredProcedure;

string LastName = txtLastName.Text;
string FirstName = txtLastName.Text;
string Identity = txtIdentity.Text;
//string strGender = "";
//{
// if (rdbMale.Checked == true)
// strGender = rdbMale.Text;
// else
// strGender = rdbFemale.Text;
//}
string Gender = ddlGender.SelectedItem.Value;
string Race = ddlRace.SelectedItem.Value;
string Marital = ddlMarital.SelectedItem.Value;
string Religion = ddlReligion.SelectedItem.Value;
string DOB = txtDOB.Text;
string Address = txtAddress.Text;
string PostalCode = txtPoscode.Text;
string State = ddlState.SelectedItem.Value;
string Nationality = txtNationality.Text;
string HomeTel = txtHomeTel.Text;
string MobileNo = txtHPTel.Text;
string LicenseNo = txtLicenseNo.Text;
string LicenseExpiry = txtLicenseExpiry.Text;
string Position = ddlPosition.SelectedItem.Value;



cmd.Parameters.AddWithValue("@LastName", txtLastName.Text);
cmd.Parameters.AddWithValue("@FirstName", txtFirstName.Text);
cmd.Parameters.AddWithValue("@Identity", txtIdentity.Text);
//cmd.Parameters.AddWithValue("@Gender", strGender);
cmd.Parameters.AddWithValue("@Gender", ddlGender.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Race", ddlRace.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Marital", ddlMarital.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Religion", ddlReligion.SelectedItem.Value);
cmd.Parameters.AddWithValue("@DOB", txtDOB.Text);
cmd.Parameters.AddWithValue("@Address", txtAddress.Text);
cmd.Parameters.AddWithValue("@PostalCode", txtPoscode.Text);
cmd.Parameters.AddWithValue("@State", ddlState.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Nationality", txtNationality.Text);
cmd.Parameters.AddWithValue("@HomeTel", txtHomeTel.Text);
cmd.Parameters.AddWithValue("@MobileNo", txtHPTel.Text);
cmd.Parameters.AddWithValue("@LicenseNo", txtLicenseNo.Text);
cmd.Parameters.AddWithValue("@LicenseExpiry", txtLicenseExpiry.Text);
cmd.Parameters.AddWithValue("@Position", ddlPosition.SelectedItem.Value);
cmd.ExecuteNonQuery();
}
catch (System.Data.SqlClient.SqlException ex_msg)
{
//Here will be catch elements
string msg = "Error occured while inserting";
msg += ex_msg.Message;
throw new Exception(msg);
}
finally
{
//Here will be fially elements
con.Close();
}
con.Close();

}
}

Can anyone help me check where i does the mistake??? Thanks...

Sachin.Nand

2937 Posts
Posted - 2010-09-14 : 04:42:39
quote:
Originally posted by yvette

HI,
i'm doing registration page with asp.net c# and sql server 2008.

this is my c# code behind (it state the error that could not found store procedure)


public string GetConnectionString()
{
return System.Configuration.ConfigurationManager.ConnectionStrings["cwConnectionString1"].ConnectionString;
}

protected void btnRegister_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(GetConnectionString());

string sql = "INSERT INTO Employee (LastName, FirstName, [Identity], Gender, Race, Marital, Religion, DOB, Address, PostalCode, State, Nationality, HomeTel, MobileNo, LicenseNo, LicenseExpiry, Position) VALUES " + " (@LastName, @FirstName, @Identity, @Gender, @Race, @Marital, @Religion, @DOB, @Address, @PostalCode, @State, @Nationality, @HomeTel, @MobileNo, @LicenseNo, @LicenseExpiry, @Position)";

try
{
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.CommandType = CommandType.Text;

string LastName = txtLastName.Text;
string FirstName = txtLastName.Text;
string Identity = txtIdentity.Text;
//string strGender = "";
//{
// if (rdbMale.Checked == true)
// strGender = rdbMale.Text;
// else
// strGender = rdbFemale.Text;
//}
string Gender = ddlGender.SelectedItem.Value;
string Race = ddlRace.SelectedItem.Value;
string Marital = ddlMarital.SelectedItem.Value;
string Religion = ddlReligion.SelectedItem.Value;
string DOB = txtDOB.Text;
string Address = txtAddress.Text;
string PostalCode = txtPoscode.Text;
string State = ddlState.SelectedItem.Value;
string Nationality = txtNationality.Text;
string HomeTel = txtHomeTel.Text;
string MobileNo = txtHPTel.Text;
string LicenseNo = txtLicenseNo.Text;
string LicenseExpiry = txtLicenseExpiry.Text;
string Position = ddlPosition.SelectedItem.Value;



cmd.Parameters.AddWithValue("@LastName", txtLastName.Text);
cmd.Parameters.AddWithValue("@FirstName", txtFirstName.Text);
cmd.Parameters.AddWithValue("@Identity", txtIdentity.Text);
//cmd.Parameters.AddWithValue("@Gender", strGender);
cmd.Parameters.AddWithValue("@Gender", ddlGender.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Race", ddlRace.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Marital", ddlMarital.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Religion", ddlReligion.SelectedItem.Value);
cmd.Parameters.AddWithValue("@DOB", txtDOB.Text);
cmd.Parameters.AddWithValue("@Address", txtAddress.Text);
cmd.Parameters.AddWithValue("@PostalCode", txtPoscode.Text);
cmd.Parameters.AddWithValue("@State", ddlState.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Nationality", txtNationality.Text);
cmd.Parameters.AddWithValue("@HomeTel", txtHomeTel.Text);
cmd.Parameters.AddWithValue("@MobileNo", txtHPTel.Text);
cmd.Parameters.AddWithValue("@LicenseNo", txtLicenseNo.Text);
cmd.Parameters.AddWithValue("@LicenseExpiry", txtLicenseExpiry.Text);
cmd.Parameters.AddWithValue("@Position", ddlPosition.SelectedItem.Value);
cmd.ExecuteNonQuery();
}
catch (System.Data.SqlClient.SqlException ex_msg)
{
//Here will be catch elements
string msg = "Error occured while inserting";
msg += ex_msg.Message;
throw new Exception(msg);
}
finally
{
//Here will be fially elements
con.Close();
}
con.Close();

}
}

Can anyone help me check where i does the mistake??? Thanks...


Check the red part marked above.


Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless.

PBUH
Go to Top of Page

rohitvishwakarma
Posting Yak Master

232 Posts
Posted - 2010-09-14 : 04:44:37
Hi,

Since you are using :

string sql = "INSERT INTO Employee (LastName, FirstName, [Identity], Gender, Race, Marital, Religion, DOB, Address, PostalCode, State, Nationality, HomeTel, MobileNo, LicenseNo, LicenseExpiry, Position) VALUES " + " (@LastName, @FirstName, @Identity, @Gender, @Race, @Marital, @Religion, @DOB, @Address, @PostalCode, @State, @Nationality, @HomeTel, @MobileNo, @LicenseNo, @LicenseExpiry, @Position)";

And this is not a stored procedure but a SQL INSERT statement, you are getting the error.

Do the following:

In Sql:

CREATE PROCEDURE stp_Registration_SaveData
(
(@LastName VARCHAR(150), -- Modify the datatypes as per your requirement
@FirstName VARCHAR(150),
@Identity VARCHAR(150),
@Gender VARCHAR(150),
@Race VARCHAR(150),
@Marital VARCHAR(150),
@Religion VARCHAR(150),
@DOB VARCHAR(150),
@Address VARCHAR(150),
@PostalCode VARCHAR(150),
@State VARCHAR(150),
@Nationality VARCHAR(150),
@HomeTel VARCHAR(150),
@MobileNo VARCHAR(150),
@LicenseNo VARCHAR(150),
@LicenseExpiry VARCHAR(150),
@Position VARCHAR(150)
)
AS
BEGIN

INSERT INTO Employee (LastName, FirstName, [Identity], Gender, Race, Marital, Religion, DOB, Address, PostalCode, State, Nationality, HomeTel, MobileNo, LicenseNo, LicenseExpiry, Position) VALUES (@LastName, @FirstName, @Identity, @Gender, @Race, @Marital, @Religion, @DOB, @Address, @PostalCode, @State, @Nationality, @HomeTel, @MobileNo, @LicenseNo, @LicenseExpiry, @Position)

END


AND IN THE CODE:

string sql="stp_Registration_SaveData ";


Thanks
Rohit
Go to Top of Page

yvette
Yak Posting Veteran

74 Posts
Posted - 2010-09-14 : 05:03:40
Thanks for reply...
But it still have the same error..maybe i do some mistake again...i'll keep trying...
Thanks...
Go to Top of Page

rohitvishwakarma
Posting Yak Master

232 Posts
Posted - 2010-09-14 : 05:09:08
which method did you implemented? There were two ways suggested to you:

1) Just change cmd.CommandType = CommandType.Text;
2) Create a procedure and change the statement string sql= ="stp_Registration_SaveData ";


If you are using method 1 then you have to remove the cmd.Parameters.AddWithValue("@LastName", txtLastName.Text); statements also.
Go to Top of Page

jafrywilson
Constraint Violating Yak Guru

379 Posts
Posted - 2010-09-14 : 05:15:11
Send me what Error msg u got
Go to Top of Page

yvette
Yak Posting Veteran

74 Posts
Posted - 2010-09-14 : 05:19:59
quote:
Originally posted by Idera

quote:
Originally posted by yvette

HI,
i'm doing registration page with asp.net c# and sql server 2008.

this is my c# code behind (it state the error that could not found store procedure)


public string GetConnectionString()
{
return System.Configuration.ConfigurationManager.ConnectionStrings["cwConnectionString1"].ConnectionString;
}

protected void btnRegister_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(GetConnectionString());

string sql = "INSERT INTO Employee (LastName, FirstName, [Identity], Gender, Race, Marital, Religion, DOB, Address, PostalCode, State, Nationality, HomeTel, MobileNo, LicenseNo, LicenseExpiry, Position) VALUES " + " (@LastName, @FirstName, @Identity, @Gender, @Race, @Marital, @Religion, @DOB, @Address, @PostalCode, @State, @Nationality, @HomeTel, @MobileNo, @LicenseNo, @LicenseExpiry, @Position)";

try
{
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.CommandType = CommandType.Text;

string LastName = txtLastName.Text;
string FirstName = txtLastName.Text;
string Identity = txtIdentity.Text;
//string strGender = "";
//{
// if (rdbMale.Checked == true)
// strGender = rdbMale.Text;
// else
// strGender = rdbFemale.Text;
//}
string Gender = ddlGender.SelectedItem.Value;
string Race = ddlRace.SelectedItem.Value;
string Marital = ddlMarital.SelectedItem.Value;
string Religion = ddlReligion.SelectedItem.Value;
string DOB = txtDOB.Text;
string Address = txtAddress.Text;
string PostalCode = txtPoscode.Text;
string State = ddlState.SelectedItem.Value;
string Nationality = txtNationality.Text;
string HomeTel = txtHomeTel.Text;
string MobileNo = txtHPTel.Text;
string LicenseNo = txtLicenseNo.Text;
string LicenseExpiry = txtLicenseExpiry.Text;
string Position = ddlPosition.SelectedItem.Value;



cmd.Parameters.AddWithValue("@LastName", txtLastName.Text);
cmd.Parameters.AddWithValue("@FirstName", txtFirstName.Text);
cmd.Parameters.AddWithValue("@Identity", txtIdentity.Text);
//cmd.Parameters.AddWithValue("@Gender", strGender);
cmd.Parameters.AddWithValue("@Gender", ddlGender.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Race", ddlRace.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Marital", ddlMarital.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Religion", ddlReligion.SelectedItem.Value);
cmd.Parameters.AddWithValue("@DOB", txtDOB.Text);
cmd.Parameters.AddWithValue("@Address", txtAddress.Text);
cmd.Parameters.AddWithValue("@PostalCode", txtPoscode.Text);
cmd.Parameters.AddWithValue("@State", ddlState.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Nationality", txtNationality.Text);
cmd.Parameters.AddWithValue("@HomeTel", txtHomeTel.Text);
cmd.Parameters.AddWithValue("@MobileNo", txtHPTel.Text);
cmd.Parameters.AddWithValue("@LicenseNo", txtLicenseNo.Text);
cmd.Parameters.AddWithValue("@LicenseExpiry", txtLicenseExpiry.Text);
cmd.Parameters.AddWithValue("@Position", ddlPosition.SelectedItem.Value);
cmd.ExecuteNonQuery();
}
catch (System.Data.SqlClient.SqlException ex_msg)
{
//Here will be catch elements
string msg = "Error occured while inserting";
msg += ex_msg.Message;
throw new Exception(msg);
}
finally
{
//Here will be fially elements
con.Close();
}
con.Close();

}
}

Can anyone help me check where i does the mistake??? Thanks...


Check the red part marked above.


Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless.

PBUH


Thanks for reply.
But After i run, it show another problem.
Error occured while insertingConversion failed when converting date and/or time from character string.

Thanks
Go to Top of Page

rohitvishwakarma
Posting Yak Master

232 Posts
Posted - 2010-09-14 : 05:21:09
1) Copy the code:
public string GetConnectionString()
{
return System.Configuration.ConfigurationManager.ConnectionStrings["cwConnectionString1"].ConnectionString;
}

protected void btnRegister_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(GetConnectionString());



try
{
con.Open();
string sql = "stp_Registration_SaveData ";

SqlCommand cmd = new SqlCommand(sql, con);
cmd.CommandType = CommandType.StoredProcedure;

string LastName = txtLastName.Text;
string FirstName = txtLastName.Text;
string Identity = txtIdentity.Text;
string Gender = ddlGender.SelectedItem.Value;
string Race = ddlRace.SelectedItem.Value;
string Marital = ddlMarital.SelectedItem.Value;
string Religion = ddlReligion.SelectedItem.Value;
string DOB = txtDOB.Text;
string Address = txtAddress.Text;
string PostalCode = txtPoscode.Text;
string State = ddlState.SelectedItem.Value;
string Nationality = txtNationality.Text;
string HomeTel = txtHomeTel.Text;
string MobileNo = txtHPTel.Text;
string LicenseNo = txtLicenseNo.Text;
string LicenseExpiry = txtLicenseExpiry.Text;
string Position = ddlPosition.SelectedItem.Value;


cmd.Parameters.AddWithValue("@LastName", txtLastName.Text);
cmd.Parameters.AddWithValue("@FirstName", txtFirstName.Text);
cmd.Parameters.AddWithValue("@Identity", txtIdentity.Text);
cmd.Parameters.AddWithValue("@Gender", ddlGender.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Race", ddlRace.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Marital", ddlMarital.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Religion", ddlReligion.SelectedItem.Value);
cmd.Parameters.AddWithValue("@DOB", txtDOB.Text);
cmd.Parameters.AddWithValue("@Address", txtAddress.Text);
cmd.Parameters.AddWithValue("@PostalCode", txtPoscode.Text);
cmd.Parameters.AddWithValue("@State", ddlState.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Nationality", txtNationality.Text);
cmd.Parameters.AddWithValue("@HomeTel", txtHomeTel.Text);
cmd.Parameters.AddWithValue("@MobileNo", txtHPTel.Text);
cmd.Parameters.AddWithValue("@LicenseNo", txtLicenseNo.Text);
cmd.Parameters.AddWithValue("@LicenseExpiry", txtLicenseExpiry.Text);
cmd.Parameters.AddWithValue("@Position", ddlPosition.SelectedItem.Value);


cmd.ExecuteNonQuery();
}
catch (System.Data.SqlClient.SqlException ex_msg)
{
//Here will be catch elements
string msg = "Error occured while inserting";
msg += ex_msg.Message;
throw new Exception(msg);
}
finally
{
//Here will be fially elements
con.Close();
}
// con.Close(); // not reqd. will be executed in Finally itself

}
}


2) Create the following stored procedure in database

CREATE PROCEDURE stp_Registration_SaveData
(
(@LastName VARCHAR(150), -- Modify the datatypes as per your requirement
@FirstName VARCHAR(150),
@Identity VARCHAR(150),
@Gender VARCHAR(150),
@Race VARCHAR(150),
@Marital VARCHAR(150),
@Religion VARCHAR(150),
@DOB VARCHAR(150),
@Address VARCHAR(150),
@PostalCode VARCHAR(150),
@State VARCHAR(150),
@Nationality VARCHAR(150),
@HomeTel VARCHAR(150),
@MobileNo VARCHAR(150),
@LicenseNo VARCHAR(150),
@LicenseExpiry VARCHAR(150),
@Position VARCHAR(150)
)
AS
BEGIN

INSERT INTO Employee (LastName, FirstName, [Identity], Gender, Race, Marital, Religion, DOB, Address, PostalCode, State, Nationality, HomeTel, MobileNo, LicenseNo, LicenseExpiry, Position) VALUES (@LastName, @FirstName, @Identity, @Gender, @Race, @Marital, @Religion, @DOB, @Address, @PostalCode, @State, @Nationality, @HomeTel, @MobileNo, @LicenseNo, @LicenseExpiry, @Position)

END
Go to Top of Page

yvette
Yak Posting Veteran

74 Posts
Posted - 2010-09-14 : 05:22:17
quote:
Originally posted by rohitvishwakarma

which method did you implemented? There were two ways suggested to you:

1) Just change cmd.CommandType = CommandType.Text;
2) Create a procedure and change the statement string sql= ="stp_Registration_SaveData ";


If you are using method 1 then you have to remove the cmd.Parameters.AddWithValue("@LastName", txtLastName.Text); statements also.







Thanks..i use the method 1, but still have error.
Error occured while insertingConversion failed when converting date and/or time from character string.
Go to Top of Page

rohitvishwakarma
Posting Yak Master

232 Posts
Posted - 2010-09-14 : 05:24:44
Assuming that DOB field in database is of DATETIME
change the code
cmd.Parameters.AddWithValue("@DOB",txtDOB.Text);
TO
cmd.Parameters.AddWithValue("@DOB",Convert.ToDateTime(txtDOB.Text));
Go to Top of Page

jafrywilson
Constraint Violating Yak Guru

379 Posts
Posted - 2010-09-14 : 05:29:25
string DOB = txtDOB.Text.ToString();
Try this...
Go to Top of Page

jafrywilson
Constraint Violating Yak Guru

379 Posts
Posted - 2010-09-14 : 05:31:03
DOB is like this 05-05-10 When u are using this value you must convert to string value....
Go to Top of Page

rohitvishwakarma
Posting Yak Master

232 Posts
Posted - 2010-09-14 : 05:35:21
quote:
Originally posted by jafrywilson

string DOB = txtDOB.Text.ToString();
Try this...


As far as I know txtDOB.Text will give a string only. So, what is the point in doing txtDOB.Text.ToString()??
Go to Top of Page

yvette
Yak Posting Veteran

74 Posts
Posted - 2010-09-14 : 05:36:57
quote:
Originally posted by jafrywilson

DOB is like this 05-05-10 When u are using this value you must convert to string value....


Thanks...i got it...
Go to Top of Page

yvette
Yak Posting Veteran

74 Posts
Posted - 2010-09-14 : 05:38:25
quote:
Originally posted by rohitvishwakarma

quote:
Originally posted by jafrywilson

string DOB = txtDOB.Text.ToString();
Try this...


As far as I know txtDOB.Text will give a string only. So, what is the point in doing txtDOB.Text.ToString()??


if using txtDOB.Text will have error, but txtDOB.Text.ToString() not error and i success get what i want.
Thanks...
Go to Top of Page

jafrywilson
Constraint Violating Yak Guru

379 Posts
Posted - 2010-09-14 : 05:38:42
Textbox only accepts strings date is a object ..So it must convert to string to use it
Go to Top of Page

jafrywilson
Constraint Violating Yak Guru

379 Posts
Posted - 2010-09-14 : 05:39:46
quote:
Originally posted by yvette

quote:
Originally posted by jafrywilson

DOB is like this 05-05-10 When u are using this value you must convert to string value....


Thanks...i got it...



You are welcome
Go to Top of Page

yvette
Yak Posting Veteran

74 Posts
Posted - 2010-09-14 : 09:35:16
Hi, if i want to let user know successful register and redirect to login page,izzit possible here???
Go to Top of Page

rohitvishwakarma
Posting Yak Master

232 Posts
Posted - 2010-09-14 : 09:49:47
quote:
Originally posted by yvette

Hi, if i want to let user know successful register and redirect to login page,izzit possible here???


int result = cmd.ExecuteNonQuery();

a non-zero value indicated the number of rows affected. If the insert is done successfully, result will be 1 which you can return back and then:

If(result==1)
{
// Display message regarding successfull registration
Response.Redirect("login.aspx"); // you login page path
}
else
{
//some error message
}
Go to Top of Page

yvette
Yak Posting Veteran

74 Posts
Posted - 2010-09-14 : 10:19:39
protected void btnRegister_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(GetConnectionString());

string sql = "INSERT INTO Employee (LastName, FirstName, [Identity], Gender, Race, MaritalStatus, Religion, DOB, Address, PostalCode, State, Nationality, HomeTel, MobileNo, DriverLicenseNo, DriverLicenseExpiry, Position) VALUES " + " (@LastName, @FirstName, @Identity, @Gender, @Race, @MaritalStatus, @Religion, @DOB, @Address, @PostalCode, @State, @Nationality, @HomeTel, @MobileNo, @DriverLicenseNo, @DriverLicenseExpiry, @Position)";

try
{
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.CommandType = CommandType.Text;

string LastName = txtLastName.Text;
string FirstName = txtLastName.Text;
string Identity = txtIdentity.Text;
//string strGender = "";
//{
// if (rdbMale.Checked == true)
// strGender = rdbMale.Text;
// else
// strGender = rdbFemale.Text;
//}
string Gender = ddlGender.SelectedItem.Value;
string Race = ddlRace.SelectedItem.Value;
string MaritalStatus = ddlMarital.SelectedItem.Value;
string Religion = ddlReligion.SelectedItem.Value;
string DOB = txtDOB.Text.ToString();
string Address = txtAddress.Text;
string PostalCode = txtPoscode.Text;
string State = ddlState.SelectedItem.Value;
string Nationality = txtNationality.Text;
string HomeTel = txtHomeTel.Text;
string MobileNo = txtHPTel.Text;
string DriverLicenseNo = txtLicenseNo.Text;
string DriverLicenseExpiry = txtLicenseExpiry.Text.ToString();
string Position = ddlPosition.SelectedItem.Value;



cmd.Parameters.AddWithValue("@LastName", txtLastName.Text);
cmd.Parameters.AddWithValue("@FirstName", txtFirstName.Text);
cmd.Parameters.AddWithValue("@Identity", txtIdentity.Text);
//cmd.Parameters.AddWithValue("@Gender", strGender);
cmd.Parameters.AddWithValue("@Gender", ddlGender.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Race", ddlRace.SelectedItem.Value);
cmd.Parameters.AddWithValue("@MaritalStatus", ddlMarital.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Religion", ddlReligion.SelectedItem.Value);
//cmd.Parameters.AddWithValue("@DOB", txtDOB.Text);
cmd.Parameters.AddWithValue("@DOB", Convert.ToDateTime(txtDOB.Text));
cmd.Parameters.AddWithValue("@Address", txtAddress.Text);
cmd.Parameters.AddWithValue("@PostalCode", txtPoscode.Text);
cmd.Parameters.AddWithValue("@State", ddlState.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Nationality", txtNationality.Text);
cmd.Parameters.AddWithValue("@HomeTel", txtHomeTel.Text);
cmd.Parameters.AddWithValue("@MobileNo", txtHPTel.Text);
cmd.Parameters.AddWithValue("@DriverLicenseNo", txtLicenseNo.Text);
cmd.Parameters.AddWithValue("@DriverLicenseExpiry", Convert.ToDateTime(txtLicenseExpiry.Text));
//cmd.Parameters.AddWithValue("@DriverLicenseExpiry", txtLicenseExpiry.Text);
cmd.Parameters.AddWithValue("@Position", ddlPosition.SelectedItem.Value);
cmd.ExecuteNonQuery();
}
catch (System.Data.SqlClient.SqlException ex_msg)
{
//Here will be catch elements
string msg = "Error occured while inserting";
msg += ex_msg.Message;
throw new Exception(msg);
}
finally
{
//Here will be fially elements
con.Close();
}
con.Close();

btnRegister.Attributes.Add("onClick", "javascript:alert('Your Register Successful!');");
Response.Redirect("Login.aspx");

}

Above is my code, it can't work...
Can anyone help???
Thanks...
Go to Top of Page

yvette
Yak Posting Veteran

74 Posts
Posted - 2010-09-14 : 10:28:50
quote:
Originally posted by yvette

protected void btnRegister_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(GetConnectionString());

string sql = "INSERT INTO Employee (LastName, FirstName, [Identity], Gender, Race, MaritalStatus, Religion, DOB, Address, PostalCode, State, Nationality, HomeTel, MobileNo, DriverLicenseNo, DriverLicenseExpiry, Position) VALUES " + " (@LastName, @FirstName, @Identity, @Gender, @Race, @MaritalStatus, @Religion, @DOB, @Address, @PostalCode, @State, @Nationality, @HomeTel, @MobileNo, @DriverLicenseNo, @DriverLicenseExpiry, @Position)";

try
{
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.CommandType = CommandType.Text;

string LastName = txtLastName.Text;
string FirstName = txtLastName.Text;
string Identity = txtIdentity.Text;
//string strGender = "";
//{
// if (rdbMale.Checked == true)
// strGender = rdbMale.Text;
// else
// strGender = rdbFemale.Text;
//}
string Gender = ddlGender.SelectedItem.Value;
string Race = ddlRace.SelectedItem.Value;
string MaritalStatus = ddlMarital.SelectedItem.Value;
string Religion = ddlReligion.SelectedItem.Value;
string DOB = txtDOB.Text.ToString();
string Address = txtAddress.Text;
string PostalCode = txtPoscode.Text;
string State = ddlState.SelectedItem.Value;
string Nationality = txtNationality.Text;
string HomeTel = txtHomeTel.Text;
string MobileNo = txtHPTel.Text;
string DriverLicenseNo = txtLicenseNo.Text;
string DriverLicenseExpiry = txtLicenseExpiry.Text.ToString();
string Position = ddlPosition.SelectedItem.Value;



cmd.Parameters.AddWithValue("@LastName", txtLastName.Text);
cmd.Parameters.AddWithValue("@FirstName", txtFirstName.Text);
cmd.Parameters.AddWithValue("@Identity", txtIdentity.Text);
//cmd.Parameters.AddWithValue("@Gender", strGender);
cmd.Parameters.AddWithValue("@Gender", ddlGender.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Race", ddlRace.SelectedItem.Value);
cmd.Parameters.AddWithValue("@MaritalStatus", ddlMarital.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Religion", ddlReligion.SelectedItem.Value);
//cmd.Parameters.AddWithValue("@DOB", txtDOB.Text);
cmd.Parameters.AddWithValue("@DOB", Convert.ToDateTime(txtDOB.Text));
cmd.Parameters.AddWithValue("@Address", txtAddress.Text);
cmd.Parameters.AddWithValue("@PostalCode", txtPoscode.Text);
cmd.Parameters.AddWithValue("@State", ddlState.SelectedItem.Value);
cmd.Parameters.AddWithValue("@Nationality", txtNationality.Text);
cmd.Parameters.AddWithValue("@HomeTel", txtHomeTel.Text);
cmd.Parameters.AddWithValue("@MobileNo", txtHPTel.Text);
cmd.Parameters.AddWithValue("@DriverLicenseNo", txtLicenseNo.Text);
cmd.Parameters.AddWithValue("@DriverLicenseExpiry", Convert.ToDateTime(txtLicenseExpiry.Text));
//cmd.Parameters.AddWithValue("@DriverLicenseExpiry", txtLicenseExpiry.Text);
cmd.Parameters.AddWithValue("@Position", ddlPosition.SelectedItem.Value);
cmd.ExecuteNonQuery();
}
catch (System.Data.SqlClient.SqlException ex_msg)
{
//Here will be catch elements
string msg = "Error occured while inserting";
msg += ex_msg.Message;
throw new Exception(msg);
}
finally
{
//Here will be fially elements
con.Close();
}
con.Close();

btnRegister.Attributes.Add("onClick", "javascript:alert('Your Register Successful!');");
Response.Redirect("Login.aspx");

}

Above is my code, it can't work...
the pink color is extra, i delete already.
Can anyone help???
my idea just like when click register button will show a message or pop up box to let user know successful register den will redirect to login page.
And one problem is if use this just redirect to login page without the message.
Thanks...
Go to Top of Page
    Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site