DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ProductID'

Friends i have properly bind the dropdown with dataset but it is giving this error:
my codes are:

To Bind-Data Set

 DataSet ds = new ViewAction().GetAllProductInfoData();
            ddlprdctname.DataSource = ds;
            ddlprdctname.DataTextField = "ProductName";
            ddlprdctname.DataValueField ="ProductID";
            ddlprdctname.DataBind();

and GetAllProductInfoData() function is

 public DataSet GetAllProductInfoData()
        {
            SqlCommand cmd = DataConnection.GetConnection().CreateCommand();
            cmd.CommandText = "Select ProductID ProductName,SubCategory2ID,CompanyID,Price,Quantity,Description from ProductInfo";
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds);
            cmd.Dispose();
            DataConnection.CloseConnection();
            return ds;
        }

What is the error please hellp me to solve

Contents hide

Answers:

Method 1

Method 2

Method 3

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

You are missing a comma in your query after ProductID. As written, it is understanding ProductName to be the returned column name alias for ProductID, and not a separate column as you most likely intended.

Your query as written is equivalent to:

Select ProductID AS ProductName, SubCategory2ID, ...

Method 2

You’re missing a comma in your query:

cmd.CommandText = "Select ProductID, ProductName, ...

Without the comma, the query selects the ProductID column using the alias ProductName.

Method 3

If you are working with gridview and got this error you can simply remove unneccessary data from of template.

 <asp:CheckBox runat="server"  />

as shown above remove this error.

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

0 0 votes

Article Rating