Issue with Data Reader Binding for ASP.net ComboBox & Listbox cont

[Sachin Kuchinad]

Hi All

I am using .NET Framework version 1.0.3705 to build a website.
Now i have made a webform and on that i have added a dropdown to the page

I bind this listbox to a datareader .
This does not happenm , i have no clue what the problem is
I am attaching the error

<font color='red' >
System.Web.Http Exception: DataBinder.Eval : 'System.Data.Co mmon.DbDataReco rd' does not contain a property with the name Davolio. at System.Web.UI.D ataBinder.GetPr opertyValue(Obj ect container, String propName) at System.Web.UI.D ataBinder.GetPr opertyValue(Obj ect container, String propName, String format) at System.Web.UI.W ebControls.List Control.OnDataB inding(EventArg s e) at System.Web.UI.C ontrol.DataBind () at TestApp.WebForm 1.getEmpDetails () in c:\inetpub\wwwr oot\testapp\web form1.aspx.cs:l ine 67

</font>

I am attaching the code too!
I have made the connection to the Northwind database , this is easilt available
Please advise what is going wrong if there is a KB article for the same?

<code>

private int getEmpDetails()
{
SqlConnection oSQLConn = new SqlConnection(" Password=New123 4;Persist Security Info=True;User ID=sa;Initial Catalog=Northwi nd;Data Source=IND-SPZ4D2K0319");
SqlCommand oSQLCmd;
SqlDataReader oSQLDataRead;
try
{ oSQLConn.Open() ;
oSQLCmd = new SqlCommand("sel ect * from employees",oSQL Conn);
oSQLCmd.Command Type = CommandType.Tex t;

oSQLDataRead = oSQLCmd.Execute Reader(CommandB ehavior.CloseCo nnection);
if(oSQLDataRead .Read())
{
//string strName = oSQLDataRead.Ge tValue(1).ToStr ing() + " " + oSQLDataRead.Ge tValue(2).ToStr ing();
//ddl01.Items.Add (strName);
ddl01.DataTextF ield = oSQLDataRead.Ge tValue(1).ToStr ing();
//ddl01.DataValue Field = oSQLDataRead.Ge tValue(1).ToStr ing();
ddl01.DataSourc e = oSQLDataRead;
ddl01.DataBind( );
}
return 1;
}
catch(Exception ex)
{
Response.Write( ex.ToString());
return -1;
}
}

</code>

Please note when I tried to bind the datareader to a datagrid control it worked perfectly fine. However, it throws up an exception on binding the same to a dataList and combo-box [asp.net] controls.

Any Clue why this happens???
Thanks,

[Sachin Kuchinad]

Got it guys!!!

The mistake is with my coding... sorry. The way to bind the thing was to assign the DataFieldValue and DataFieldText properties of a combo box or a Listbox to the column names and not to the value as I was doing it.

This solved the problem. So there is not issue with binding as the subject heading says!!!

Thanks,

"Sachin Kuchinad" wrote:

Hi All

I am using .NET Framework version 1.0.3705 to build a website.
Now i have made a webform and on that i have added a dropdown to the page

I bind this listbox to a datareader .
This does not happenm , i have no clue what the problem is
I am attaching the error

<font color='red' >
System.Web.Http Exception: DataBinder.Eval : 'System.Data.Co mmon.DbDataReco rd' does not contain a property with the name Davolio. at System.Web.UI.D ataBinder.GetPr opertyValue(Obj ect container, String propName) at System.Web.UI.D ataBinder.GetPr opertyValue(Obj ect container, String propName, String format) at System.Web.UI.W ebControls.List Control.OnDataB inding(EventArg s e) at System.Web.UI.C ontrol.DataBind () at TestApp.WebForm 1.getEmpDetails () in c:\inetpub\wwwr oot\testapp\web form1.aspx.cs:l ine 67

</font>

I am attaching the code too!
I have made the connection to the Northwind database , this is easilt available
Please advise what is going wrong if there is a KB article for the same?

<code>

private int getEmpDetails()
{
SqlConnection oSQLConn = new SqlConnection(" Password=New123 4;Persist Security Info=True;User ID=sa;Initial Catalog=Northwi nd;Data Source=IND-SPZ4D2K0319");
SqlCommand oSQLCmd;
SqlDataReader oSQLDataRead;
try
{ oSQLConn.Open() ;
oSQLCmd = new SqlCommand("sel ect * from employees",oSQL Conn);
oSQLCmd.Command Type = CommandType.Tex t;

oSQLDataRead = oSQLCmd.Execute Reader(CommandB ehavior.CloseCo nnection);
if(oSQLDataRead .Read())
{
//string strName = oSQLDataRead.Ge tValue(1).ToStr ing() + " " + oSQLDataRead.Ge tValue(2).ToStr ing();
//ddl01.Items.Add (strName);
ddl01.DataTextF ield = oSQLDataRead.Ge tValue(1).ToStr ing();
//ddl01.DataValue Field = oSQLDataRead.Ge tValue(1).ToStr ing();
ddl01.DataSourc e = oSQLDataRead;
ddl01.DataBind( );
}
return 1;
}
catch(Exception ex)
{
Response.Write( ex.ToString());
return -1;
}
}

</code>

Please note when I tried to bind the datareader to a datagrid control it worked perfectly fine. However, it throws up an exception on binding the same to a dataList and combo-box [asp.net] controls.

Any Clue why this happens???
Thanks,