retrieve value from database and assign it in to string variable C#

c# sql .net windows-mobile-6
Nick picture Nick · Nov 21, 2012 · Viewed 51.5k times · Source

I want to retrieve value from table. Please guys help me. The thing is I want to get that value and check it with a string value.

this code is not working:

SqlCeCommand cmd1 = new SqlCeCommand("SELECT username FROM tmpusername WHERE _id=1", connection);

SqlCeDataReader usernameRdr = null;

usernameRdr = cmd1.ExecuteReader();

while (usernameRdr.Read()){
    string username11 = usernameRdr["username11"].ToString(); 
}

Answer

Habib picture Habib · Nov 21, 2012

use username for accessing column. 

string username11 = usernameRdr["username"].ToString();

Your select command is specifying Select username and later you are accessing it using username11. That is why you are not getting the value, instead you should be getting an exception.

Related questions

What is the syntax for an inner join in LINQ to SQL?

I'm writing a LINQ to SQL statement, and I'm after the standard syntax for a normal inner join with an ON clause in C#. How do you represent the following in LINQ to SQL: select DealerContact.* from Dealer inner join …

Read More
Read SQL Table into C# DataTable

I've read a lot of posts about inserting a DataTable into a SQL table, but is there an easy way to pull a SQL table into a .NET DataTable?

Read More
Get affected rows on ExecuteNonQuery

I am currently working on a C# project and I am running an insert query which also does a select at the same time, e.g.: INSERT INTO table (SELECT * FROM table WHERE column=date) Is there a way I …

Read More