Stored Proceedure Query

Question

0.00/5 (No votes)

See more:

Hello friends,

I have used stored procedure to insert values in two tables

1.register
2.login

It is displaying errors...

Msg 207, Level 16, State 1, Procedure str_insert_register, Line 22<br />
Invalid column name 'adtsite'.<br />
Msg 207, Level 16, State 1, Procedure str_insert_register, Line 24<br />
Invalid column name 'emailid'.<br />

The Code Is:

SQL

CREATE PROCEDURE str_insert_register 
@username nvarchar(50),
@firstname nvarchar(50),
@lastname nvarchar(50),
@fullname nvarchar(50),
@city nvarchar(50),
@street nvarchar(50),
@postcode nvarchar(50),
@telephone nvarchar(50), 
@dob nvarchar(50),
@occupation nvarchar(50),
@emailid nvarchar(50),
@pwd nvarchar(50),
@abtsite nvarchar(50),
@entrydate datetime,
@activestatus int
AS
BEGIN
SET NOCOUNT ON 
declare @id as int
SET @username=@firstname+right('0'+convert(varchar,datepart(dd,getdate())) ,2)
insert into register(id,username,firstname,lastname,fullname,city,street,postcode,telephone,dob,occupation,emailid,pwd,adtsite,entrydate,activestatus)values(@id,@username,@firstname,@lastname,@fullname,@city,@street,@postcode,@telephone,@dob,@occupation,@emailid,@pwd,@abtsite,@entrydate,@activestatus)
declare @stid as int
insert into login(stid,username,emailid,pwd)values(@stid,@username,@emailid,@pwd)
END 
GO

Please check.
How can I resolve this error ?

Posted 26-Feb-13 21:02pm

Ankit_Sharma1987

Updated 26-Feb-13 22:00pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v2

Add a Solution

Comments

willington.d 27-Feb-13 3:18am

Check whether those columns are there in that Table...

send me the Table structure of register table....

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Goutam Patra · Accepted Answer · 2013-02-26T21:30:00

Solution 1

As the error suggest there is no column named "adtsite" and in "emailid" in your "register" table

Posted 26-Feb-13 21:30pm

Goutam Patra

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-Feb-13 3:58am

[Comments By OP]

Thanks...I got IT, really thankxxx!!

Ankit_Sharma1987 27-Feb-13 7:55am

Hello,
i have used this code , to execute this stored proceedure...But it is giving an exeption,
please help...

protected void btn_submit_Click(object sender, EventArgs e)
{
try
{
cnn.ConnectionString = ConfigurationManager.ConnectionStrings["jin"].ConnectionString;
SqlCommand cm = new SqlCommand("register",cnn);
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "str_insert_register";
cm.Parameters.Add("title",SqlDbType.NVarChar,50).Value = ddl_title.SelectedItem.ToString();
cm.Parameters.Add("firstname", SqlDbType.NVarChar, 50).Value=txt_fname.Text;
cm.Parameters.Add("lastname", SqlDbType.NVarChar, 50).Value=txt_lname.Text;
cm.Parameters.Add("fullname", SqlDbType.NVarChar, 50).Value=txt_fname.Text +" "+txt_lname.Text;
cm.Parameters.Add("city", SqlDbType.NVarChar, 50).Value=txt_city.Text;
cm.Parameters.Add("street", SqlDbType.NVarChar, 50).Value=txt_street.Text;
cm.Parameters.Add("postcode", SqlDbType.NVarChar, 50).Value=txt_postcode.Text;
cm.Parameters.Add("telephone", SqlDbType.NVarChar, 50).Value=txt_telephone.Text;
cm.Parameters.Add("dob", SqlDbType.NVarChar, 50).Value=txt_dob.Text;
cm.Parameters.Add("occupation", SqlDbType.NVarChar, 50).Value=ddl_occup.SelectedItem.ToString();
cm.Parameters.Add("emailid", SqlDbType.NVarChar, 50).Value = txt_email.Text;
cm.Parameters.Add("pwd",SqlDbType.NVarChar,50).Value=txt_pwd.Text;
cm.Parameters.Add("abtsite", SqlDbType.NVarChar, 50).Value = ddl_abtsite.SelectedItem.ToString();
SqlDataReader dr;
cnn.Open();
dr = cm.ExecuteReader();
cnn.Close();

lbl_msg.Text = "Registration is Done Successfully!!";
}
catch(Exception ex)
{
lbl_msg.Text = "There is some Error!!";
}
}