Exception:There is no row at position 0.

Question

0.00/5 (No votes)

See more:

This Is My code:"Plz Provide Me Solution"

C#

protected void btnsubmit_Click(object sender, EventArgs e)
{
 try
   {
   //Retrieving user id.
cmd = new SqlCommand("select nuser_id from tbl_User_Info where suser_login = '"+ListBox1.SelectedValue+"'", con);
   DataSet ds10 = new DataSet();
   DataTable dt10 = new DataTable();
   SqlDataAdapter da10 = new SqlDataAdapter(cmd);
   da10.Fill(ds10);
   string uId = ds10.Tables[0].Rows[0]["nuser_id"].ToString();
   int userId = Convert.ToInt32(uId);
   }
  catch (Exception ex)
  {
  }       
}

Posted 18-Aug-15 20:40pm

Prashant Malav

Updated 18-Aug-15 20:50pm

DamithSL

v3

Add a Solution

2 solutions

Solution 2

Try this...

C#

protected void btnsubmit_Click(object sender, EventArgs e)
{
 try
   {
   //Retrieving user id.
cmd = new SqlCommand("select nuser_id from tbl_User_Info where suser_login = '"+ListBox1.SelectedValue+"'", con);
   DataSet ds10 = new DataSet();
   DataTable dt10 = new DataTable();
   SqlDataAdapter da10 = new SqlDataAdapter(cmd);
   da10.Fill(ds10);
   if(ds10.Tables[0].Rows.Count >0)
   {
   string uId = ds10.Tables[0].Rows[0]["nuser_id"].ToString();
   int userId = Convert.ToInt32(uId);
   }
   }
  catch (Exception ex)
  {
  }       
}

Posted 19-Aug-15 0:38am

aarif moh shaikh

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DamithSL · Accepted Answer · 2015-08-18T20:56:00

Solution 1

use parameter and ExecuteScalar

C#

cmd = new SqlCommand("select nuser_id from tbl_User_Info where suser_login =@Para1", con);
cmd.Parameters.AddWithValue("@Para1", ListBox1.SelectedValue);
int? id = (int?)cmd.ExecuteScalar();
if(id.HasValue)
{
  // there is value for ID, use id.Value to get the value 
}

Posted 18-Aug-15 20:56pm

DamithSL

Comments

Sanket Saxena 19-Aug-15 6:50am

simple and perfect +5

DamithSL 19-Aug-15 10:55am

Thank you

Exception:There is no row at position 0.

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Exception:There is no row at position 0.

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us