Invalid object name from SQL Server database?

Question

I'm getting this error:

Invalid object name 'Members'

on this line:

int MemberExist = (int)check_Member.ExecuteScalar();

With my current DB which looks like this: http://imgur.com/6fyKGn3 Why wouldn't this be executing?

Code:

// Get the connection 
SqlConnection DBConnection = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=""E:\DS\Prac5\Part1\App_Data\MyDatabase.mdf"";Integrated Security=True");

SqlDataReader Reader = null;

DBConnection.Open();
SqlCommand check_Member = new SqlCommand("SELECT * FROM Members WHERE MembershipID = FirstName AND LastName = @Txtnput", DBConnection);
check_Member.Parameters.AddWithValue("@Txtnput", txtMembershipid.Text);

int MemberExist = (int)check_Member.ExecuteScalar();

change Mydatabase.mdf to Database.mdf and remove " in between check my answer below — Sachu
– Sachu, Commented May 13, 2015 at 6:07

sudhansu63 · Accepted Answer · 2015-05-13 05:53:11Z

1

seems some error in your connection string.

Data Source=(LocalDb)\v11.0;Initial Catalog=Database;Integrated Security=SSPI;AttachDBFilename='E:\DS\Prac5\Part1\App_Data\MyDatabase.mdf'

You can also use

"SELECT TOP 1 MembershipID  FROM Members WHERE MembershipID = FirstName AND LastName = @Txtnput"

Make Sure your Table name is Members. You can check that in the Model or Database.

bool IsMemberExist;
object MembershipId = check_Member.ExecuteScalar();

if(MembershipId  != null )
 {
   IsMemberExist = true;
  //Do other things here.  //Convert.ToInt32(MembershipId) 
 }

edited May 13, 2015 at 5:53

answered May 13, 2015 at 5:47

sudhansu63

6,2204 gold badges41 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user4814432 Over a year ago

Unfortunately my table is most definitely the correct name as you can see by my imgur link I posted.

user4814432 Over a year ago

Ahh yes thank you my connection string was incorrect.

NCA · Accepted Answer · 2015-05-13 06:10:24Z

1

Please make sure that whether you database MyDatabase.mdf contain the table named Members. Please test with following.

SqlCommand check_table= "select case when exists((select * from information_schema.tables where table_name = '" + tableName + "')) then 1 else 0 end");
int IsTableExists = (int)check_table.ExecuteScalar();
if(IsTableExists ==1)
{
        SqlCommand check_Member = new SqlCommand("SELECT * FROM Members WHERE MembershipID = FirstName AND LastName = @Txtnput", DBConnection);
        check_Member.Parameters.AddWithValue("@Txtnput", txtMembershipid.Text);
        int MemberExist = (int)check_Member.ExecuteScalar();
}

UPDATE: can you please update the query with schema name along with table name.

eg: SqlCommand check_Member = new SqlCommand("SELECT * FROM dbo.Members WHERE MembershipID = FirstName AND LastName = @Txtnput", DBConnection);

Or more specifically MyDatabase.dbo.Members

edited May 13, 2015 at 6:10

answered May 13, 2015 at 5:48

NCA

8201 gold badge8 silver badges20 bronze badges

1 Comment

user4814432 Over a year ago

it does as far as i'm aware :/

martinlabs · Accepted Answer · 2015-05-13 05:32:49Z

0

It looks like you have to change the queries to become

"SELECT count(*) FROM Members WHERE MembershipID = FirstName AND LastName = @Txtnput"

Because ExecutesScalar expects a single value return from a query.

answered May 13, 2015 at 5:32

martinlabs

1,0422 gold badges13 silver badges26 bronze badges

1 Comment

user4814432 Over a year ago

Hmm I just tried that but it's still giving me same exception. "Invalid object name 'Members'."

Sachu · Accepted Answer · 2015-05-13 05:54:09Z

0

Try this connection string and check

    SqlConnection DBConnection = new SqlConnection(@"Data Source=(LocalDB)\v11.0;
AttachDbFilename=E:\DS\Prac5\Part1\App_Data\Database.mdf;Integrated Security=True")

remove the " in between no need because start with @ also change MyDatabase.mdf to Database.mdf because in picture it is Database.mdf

answered May 13, 2015 at 5:54

Sachu

7,7549 gold badges59 silver badges101 bronze badges

1 Comment

Sachu Over a year ago

@user4814432 check this

Collectives™ on Stack Overflow

Invalid object name from SQL Server database?

4 Answers 4

2 Comments

1 Comment

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related