There is no row at position 0.

Question

1.00/5 (1 vote)

See more:

Hi All,

I got a Problem, when i set the debug = true in the web.config the projects works fine,but when i set debug = false in the web.config then i got a server error that

There is no row at position 0.

here is the code lines

C#

InternalLinkBL bl = new InternalLinkBL(SessionContext.SystemUser);
               RowId = URLMessage.GetParam(PageCode, 0);
               bl.Fetch(ds, RowId);
               if (ds.Tables[bl.SqlEntityX].Rows.Count > 0)
               {

                   Response.Redirect("~/Login/Login.aspx?" + "ReturnURL=" + Request.Url.ToString());
               }

I checked procedure it's working fine, table got the content, parameters are passed, data fetches but still it shows this error.

thanks

Posted 24-Apr-11 20:41pm

eber yusuf

Updated 8-Mar-21 7:04am

thatraja

v3

Add a Solution

Comments

Prasanta_Prince 25-Apr-11 3:09am

Normally this error occurs when datatable is empty.

Pravin Patil, Mumbai 25-Apr-11 4:12am

and it has got nothing to do with Debug value in Web.config.

koolprasad2003 25-Apr-11 6:44am

This error has nothing to do with Web.config. Actually when you have try to fecth value from empty dataset this error thrown

1 solution

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)

thatraja · Accepted Answer · 2011-04-24T22:06:00

Solution 1

You will get this error normally if your datasource doesn't contains any records. Check the data of the dataset ds in your code while tracing. Always check the dataset before comparison like below.

C#

bl.Fetch(ds, RowId);
if (ds!= null)//Check if the dataset is null
{
 if (ds.Tables.Count > 0)//Check if the dataset contains Table
 {
  if (ds.Tables[bl.SqlEntityX].Rows.Count > 0)
  {
      Response.Redirect("~/Login/Login.aspx?" + "ReturnURL=" + Request.Url.ToString());
  }
 }
}
else
{
     Response.Redirect("No data");//Give appropriate message here
}

BTW Check that can you get values for RowId & also the Fetch() too.

Posted 24-Apr-11 22:06pm

thatraja

Comments

Sandeep Mewara 25-Apr-11 8:29am

My 5!

Member 9962877 11-Apr-13 0:36am

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{

SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=admin;database=projeval");
SqlCommand cmd = new SqlCommand();
SqlCommand cmd1 = new SqlCommand();
SqlCommand cmd2 = new SqlCommand();
SqlCommand cmd3 = new SqlCommand();
SqlDataAdapter ada = new SqlDataAdapter();
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
SqlDataAdapter ada3 = new SqlDataAdapter();
DataTable dt3 = new DataTable();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{

cmd.Connection = con;
cmd.CommandText = "select *from logindate";
ada.SelectCommand = cmd;
ada.Fill(dt);
if (dt.Rows[0][0].ToString() == DateTime.Now.ToShortDateString())
{
Literal1.Visible = true;
}
else
{
Literal1.Visible = false;
}

}
}
protected void Button1_Click(object sender, EventArgs e)
{
cmd.Connection = con;
cmd.CommandText = "sp_login";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@uname", TextBox1.Text);
cmd.Parameters.AddWithValue("@pwd", TextBox2.Text);
SqlParameter p = new SqlParameter("@val", SqlDbType.Int);
p.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(p);
SqlParameter p1 = new SqlParameter("@uid", SqlDbType.Int);
p1.Direction = ParameterDirection.Output;
cmd.Parameters.Add(p1);
SqlParameter p2 = new SqlParameter("@type", SqlDbType.VarChar ,90);
p2.Direction = ParameterDirection.Output;
cmd.Parameters.Add(p2);
con.Open();
cmd.ExecuteNonQuery();
con.Close();

if(p.Value.ToString()=="1")
{
Session["uid"]=p1.Value.ToString();
Session["type"] = p2.Value.ToString();
switch(p2.Value.ToString())
{
case "student":
dt.Clear();
cmd1.Connection = con;
cmd1.CommandText = "select * from login where uid=" + p1.Value.ToString();
ada.SelectCommand = cmd1;
ada.Fill(dt);
if (dt.Rows[0][4].ToString() == "yes")
{
cmd2.Connection = con;
cmd2.CommandText = "select grpname from grouplogin where uid=" + p1.Value.ToString();
ada.SelectCommand = cmd2;
ada.Fill(dt1);
Session["studentgpname"] = dt1.Rows[0][0].ToString();

Response.Redirect("studenthome.aspx");
}
else
{
Label5.Text = "Not approved";
}
con.Open();
cmd1.ExecuteNonQuery();
con.Close();
break;
case "admin":
Response.Redirect("adminhome.aspx");
break;

case "HOD":
Response.Redirect("HodAssignStaff.aspx");
break;
case "Staff":
dt.Clear();
cmd1.Connection = con;
cmd1.CommandText = "select * from login where uid=" + p1.Value.ToString();
ada.SelectCommand = cmd1;
ada.Fill(dt);
if (dt.Rows[0][4].ToString() == "yes")
{
String staff = dt.Rows[0][1].