Could not find a column in database

Question

0.00/5 (No votes)

See more:

I created webform in which i have written insert query which was executing correctly. Now i have added one more field to my previous table i.e image.and i have added image column in my webform too. Before modifying this table and webform my insert query was working correctly.But after adding this it is giving me exception as "could not find column in databse", even though my table is showing that new column "image".and my insert query fails. What is the problem?please help.
this is my code-

C#

 SqlConnection conn = new SqlConnection("Data Source=SNEHAL-PC\\SNEHAL1;Initial Catalog=TEMPRUJU;Integrated Security=True");
       SqlCommand cmd;
cmd = new SqlCommand("insert into login(name,midname,surname,username,password,contact,dob,email,address,occupation,ltype,image) values('" + txtfirst.Text + "','" + txtmid.Text + "','" + txtsur.Text + "','" + txtname.Text + "','" + txtpass.Text + "','" + txtcontact.Text + "','" + txtdob.Text + "','" + txtemail.Text + "','" + txtaddr.Text + "','" + txtocc.Text + "','" + typeButtonList1.SelectedValue + "','"+image1.ImageUrl+"')", conn);
                        cmd.ExecuteNonQuery();
                       Response.Redirect("WebForm1.aspx");

Posted 14-Feb-14 17:44pm

Member 10523130

Updated 14-Feb-14 17:56pm

Snehasish_Nandy

v2

Add a Solution

Comments

[no name] 14-Feb-14 23:58pm

share your table..

Member 10523130 15-Feb-14 0:05am

CREATE TABLE [dbo].[login] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[name] NCHAR (10) NULL,
[midname] NCHAR (10) NULL,
[surname] NCHAR (10) NULL,
[username] NCHAR (15) NULL,
[password] NCHAR (16) NULL,
[contact] NUMERIC (18) NULL,
[dob] VARCHAR (50) NULL,
[email] NVARCHAR (50) NULL,
[address] NVARCHAR (50) NULL,
[occupation] NCHAR (10) NULL,
[ltype] NCHAR (10) NULL,
[status] INT DEFAULT ((1)) NOT NULL,
[image] VARCHAR (50) NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
this is my table

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 15-Feb-14 0:04am

I guess you have not saved the table after adding new Column.

Member 10523130 15-Feb-14 0:06am

i have saved my table.and i can see that column in my table

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 15-Feb-14 0:15am

Are you in debugging mode right now in visual studio?
If yes, then stop debugging and run again.

JoCodes 15-Feb-14 1:12am

Have you created table in the same DB you are using in the Connectionstring?

2 solutions

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)

Hareesh Malli · Answer 1 · 2014-02-15T00:05:00

Solution 2

You did a mistake in image column data type. you should declare image column with image data type or binary data type. And you should convert the uploaded file to specific data type means image or binary.

Posted 15-Feb-14 0:05am

Hareesh Malli

R-a-v-i-k-u-m-a-r · Answer 2 · 2014-02-14T18:38:00

You missed a column 'status' in insert query.

cmd = new SqlCommand("insert into login(name,midname,surname,username,password,contact,dob,email,address,occupation,ltype,status,image) values('" + txtfirst.Text + "','" + txtmid.Text + "','" + txtsur.Text + "','" + txtname.Text + "','" + txtpass.Text + "','" + txtcontact.Text + "','" + txtdob.Text + "','" + txtemail.Text + "','" + txtaddr.Text + "','" + txtocc.Text + "','" + typeButtonList1.SelectedValue + "','"+image1.ImageUrl+"')", conn);