I have:

command.CommandText = “SELECT UserName from Users WHERE UserID = “ = userID

Executing this command returns one table with one column with one row. What is the syntax for getting that value into a variable? I can get the information into a dataSet but I can’t get it out. Should I be using a dataSet for this operation?

The rest of the code so far:

SqlDataAdapter dataAdapter = new SqlDataAdapter();
            dataAdapter.SelectCommand = command;
            dataAdapter.TableMappings.Add("Table", "Users");

            dataSet = new DataSet();
            dataAdapter.Fill(dataSet);

Something like this:

dataSet.Tables(0).Rows(0).Columns(0)

-Peter

dataset.Tables(0).Rows(0).Columns(0)

i need this coding in C# Language.........

In C#:

dataSet.Tables[0].Rows[0][0]