Column 'RegistrationID' does not belong to table Table.

Question

0.00/5 (No votes)

See more:

C#

C#

Column 'RegistrationID' does not belong to table Table. what is this error?

Posted 1-Aug-13 2:42am

santoshroyal

Add a Solution

Comments

Syed Shabeer 1-Aug-13 8:45am

"Table" is a physical table or data table? Check whther the column exists in that table

santoshroyal 1-Aug-13 9:06am

It is exists

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)

Member 8622273 · Accepted Answer · 2013-08-01T02:45:00

Solution 1

the column name is not available in the table which you have fetched from database.run the query in databese and check for the column name

Posted 1-Aug-13 2:45am

Member 8622273

Adarsh chauhan · Accepted Answer · 2013-08-01T02:49:00

Solution 2

seems like column with this name does not exist in your table..
check for spelling of your ColumnName in table and ColumnName in your query, both should match.

and we can exactly tell the prob. if you can share your table structure and your query/peice of code

Posted 1-Aug-13 2:49am

Adarsh chauhan

Updated 1-Aug-13 2:50am

v2

Comments

santoshroyal 1-Aug-13 8:52am

it is same as in database table

santoshroyal 1-Aug-13 8:57am

still am getting that error

Adarsh chauhan 1-Aug-13 9:06am

share your table structure and your query.. only then I can help you out.

santoshroyal 1-Aug-13 9:11am

ALTER PROCEDURE [dbo].[usp_Request_SELECT_ALL]
@AppCategory INT =0,
@Thought NVARCHAR(50)=''
AS

IF(@AppCategory>0)
BEGIN
SELECT Re.RequestID,A.Name AppCategory,O.Name Os,Re.Thought,Re.[Status],R.Name,R.RegistrationID
FROM Request Re,AppCategory A,Os O,Registration R
WHERE R.RegistrationID = Re.UserID AND A.AppCategoryID = Re.AppCategory AND O.OSID = Re.Os AND Re.AppCategory=@AppCategory AND Re.Thought LIKE '%'+@Thought+'%'
END
ELSE IF(@AppCategory=0)
BEGIN
SELECT Re.RequestID,A.Name AppCategory,O.Name Os,Re.Thought,Re.[Status],R.Name,R.RegistrationID
FROM Request Re,AppCategory A,Os O,Registration R
WHERE R.RegistrationID = Re.UserID AND A.AppCategoryID = Re.AppCategory AND O.OSID = Re.Os AND Re.Thought LIKE '%'+@Thought+'%'
END

santoshroyal 1-Aug-13 9:09am

CREATE TABLE [dbo].[Registration](
[RegistrationID] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NULL,
[DOB] [nvarchar](50) NULL,
[EmailID] [nvarchar](50) NULL,
[Password] [nvarchar](50) NULL,
[Pic] [nvarchar](50) NULL,
[IsActive] [bit] NULL

santoshroyal 1-Aug-13 9:10am

ALTER PROCEDURE [dbo].[usp_Request_SELECT_ALL]
@AppCategory INT =0,
@Thought NVARCHAR(50)=''
AS

IF(@AppCategory>0)
BEGIN
SELECT Re.RequestID,A.Name AppCategory,O.Name Os,Re.Thought,Re.[Status],R.Name,R.RegistrationID
FROM Request Re,AppCategory A,Os O,Registration R
WHERE R.RegistrationID = Re.UserID AND A.AppCategoryID = Re.AppCategory AND O.OSID = Re.Os AND Re.AppCategory=@AppCategory AND Re.Thought LIKE '%'+@Thought+'%'
END
ELSE IF(@AppCategory=0)
BEGIN
SELECT Re.RequestID,A.Name AppCategory,O.Name Os,Re.Thought,Re.[Status],R.Name,R.RegistrationID
FROM Request Re,AppCategory A,Os O,Registration R
WHERE R.RegistrationID = Re.UserID AND A.AppCategoryID = Re.AppCategory AND O.OSID = Re.Os AND Re.Thought LIKE '%'+@Thought+'%'
END

Adarsh chauhan 1-Aug-13 9:20am

nothing seems wrong as such..it should work..

venkateshCST 2-Aug-13 2:09am

Just display your code so that it can be sorted soon