Confusion of sql helper class

Question

I want to display list of names and roll no of students who are studying in nursery stored in my database......But there seems to be an error in following code which i can't figure out

 protected void NurseryButton_Click(object sender, EventArgs e)
{

    SQLHelper sqhlpr = new SQLHelper();
    sqhlpr.SqlText = "Select StudentName,RollNo from tblStudentInfo where Class=@Class";
    sqhlpr.AddParameter("Class", sender.ToString());
    sqhlpr.ExecuteScalar(false);
    DataTable dt = sqhlpr.getDataTable(false);
    Label1.Text = dt.Rows[0]["StudentName"].ToString();
}

The error goes like this"There is no row at position 0" in my last line of text i.e.in label1.text. Can anybody help me??

Are you sure there are any rows in tblStudentInfo that match your query? — Dutts, Mar 12 '13 at 09:36

Alex · Accepted Answer · 2013-03-12T09:24:59.823

2

You have to use SqlHelper.ExecuteDataSet so get the result set of your query. ExecuteScalar resutns a single value from row. Example

DataTable dt = SqlHelper.ExecuteDataSet(ConnString,
                                 CommandType.Text,
                                 "Select StudentName,RollNo from tblStudentInfo where Class=@Class",
                                 parameter).Tables[0];

edited Mar 12 '13 at 09:24

answered Mar 12 '13 at 09:19

Alex

8,827
3
42
58

Confusion of sql helper class

1 Answers1