No rows at position 0

Question

0.00/5 (No votes)

See more:

Well im tying to populate a text box on a list box selection and i keep getting the error
No rows at position 0

This is the code im using

    myConnection.GetConnection();
    DataSet sds = new DataSet();
    MySqlCommand sql = new MySqlCommand("SELECT * FROM users", myConnection.GetConnection());
    MySqlDataAdapter mydap = new MySqlDataAdapter(sql);
    mydap.Fill(sds, "users");
    this.UserList.DataSource = sds.Tables["users"];
    this.UserList.DisplayMember = "name";

}

private void UserList_SelectedIndexChanged(object sender, EventArgs e)
{
    //int cid = Int32.Parse(this.UserList.SelectedValue.ToString());
    MySqlCommand sql1 = new MySqlCommand("SELECT * FROM users WHERE name = '" + this.UserList.SelectedValue.ToString() + "'", myConnection.GetConnection());
    MySqlDataAdapter DA = new MySqlDataAdapter(sql1);
    DataSet DS = new DataSet();
    DA.Fill(DS, "users");

    this.Usernametxtbox.Text = DS.Tables["users"].Rows[0]["name"].ToString();
}

But no matter what number i put in the Rows[0] section i keep getting the same error
Any help would be appreciated

Posted 22-Oct-10 8:22am

Tunacha

Add a Solution

Comments

Pawan Kiran 23-Oct-10 5:29am

Try By Changing UserList.SelectedItem near "Select Condition"
Or
add this line in your code
this.UserList.ValueMember="name";

5 solutions

Solution 3

If all that you are trying to do is to pull out the information in the first row in a single column, I would look into the ExecuteScalar function (SqlCommand.ExecuteScalar Method[^]). Also, all you're doing is checking if the value is in the database. So, I would do something more like:

C#

MySqlCommand sql1 = new MySqlCommand("SELECT name FROM users WHERE name = '" + this.UserList.SelectedValue.ToString() + "'", myConnection.GetConnection());

if(sql1.ExecuteScalar()==null)
{
  this.Usernametxtbox.Text="Not Found";
}
else
{
  this.Usernametxtbox.Text = this.UserList.SelectedValue.ToString();
}

Posted 22-Oct-10 9:16am

William Winner

Comments

Bikash Shrestha From Nepal 23-Oct-10 1:10am

you are right.

Solution 4

C#

You better Check whether the execution of the sql command returned any rows or not. 
in this way you can avoid errors. check the code below

private void UserList_SelectedIndexChanged(object sender, EventArgs e)
        {
            //int cid = Int32.Parse(this.UserList.SelectedValue.ToString());
            MySqlCommand sql1 = new MySqlCommand("SELECT * FROM users WHERE name = '" + this.UserList.SelectedValue.ToString() + "'", myConnection.GetConnection());
            MySqlDataAdapter DA = new MySqlDataAdapter(sql1);
            DataSet DS = new DataSet();
            DA.Fill(DS, "users");

if(DS.Tables["users"].Rows.Count>0)
{
    this.Usernametxtbox.Text =   DS.Tables["users"].Rows[0]["name"].ToString();
}

Posted 22-Oct-10 19:28pm

Bikash Shrestha From Nepal

Comments

Bikash Shrestha From Nepal 23-Oct-10 11:15am

If this helped you then please Vote

Solution 5

Try like this:
private void UserList_SelectedIndexChanged(object sender, EventArgs e)
{
       if(!string.IsnullOrEmpty(this.userlist.selectedvalue.tostring())
        {
            MySqlCommand sql1 = new MySqlCommand("SELECT * FROM users WHERE name = '" + this.UserList.SelectedValue.ToString() + "'", myConnection.GetConnection());
            MySqlDataAdapter DA = new MySqlDataAdapter(sql1);
            DataSet DS = new DataSet();
            DA.Fill(DS, "users");
            if(DS.Tables["users"].Rows.Count > 0)
            {
            this.Usernametxtbox.Text = DS.Tables["users"].Rows[0] ["name"].ToString();
            }
            else
            {
               //blah blah
            }
        }
        else
        {
         // blah blah blah
        } 
}

Posted 22-Oct-10 21:10pm

Pawan Kiran

Updated 22-Oct-10 23:21pm

v2

Solution 2

Check these out -

http://www.velocityreviews.com/forums/t95369-there-is-no-row-at-position-0-a.html[^]

http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/2aa4298f-2d0b-4c43-a31b-dbd8c0e7207b[^]

Posted 22-Oct-10 8:32am

Abhinav S

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)

Sandeep Mewara · Accepted Answer · 2010-10-22T08:26:00

Well, it's simple means that the dataset does not contain any rows!

A simple use of DEBUGGER can show you that, DS.Tables["users"].Rows.Count is ZERO....

Check the query formed that is getting executed. Try the same query in SQL directly and see if you get back anything. It looks like there is some issue and you are getting no data from DB and thus the error as you blindly use first row value (you should put a check if there is any data returned or not before using it... i.e. row count>0)

No rows at position 0

5 solutions

Solution 1

Solution 3

Solution 4

Solution 5

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us