dear fellas im having a problem in binding my datai have textbox txtboxmaker to input makerbut then i want to list down all my maker in drop down list ddlmakeri try ltaspSqlDataSource ID34SqlBindMaker34 runat34server34 ConnectionString34lt ConnectionStringsESConnectionString gt34 SelectCommand34SELECT veqID veqMaker FROM ISVesselEquipment WHERE veqIsDeleted is NULL Order by veqMaker34gt ltaspSqlDataSo

In your Query you have columns veqID veqMakerSo you need to use that while binding DropDown ddlmakerDataSource SqlBindModel ddlmakerDataTextField 34veqMaker34 ddlmakerDataValueField 34veqID34 ddlmakerDataBind ddlmakerItemsInsert0 New ListItem34 Choose 34 34134

ASP.Net DropDownList Error :System.Data.DataRowView does not contain a property with the name itemMaker

ayuninai

SOLVED CLOSED ACTIVE ANSWERED
User: ayuninai
Posted: on Oct 31, 2013 02:50 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 5229

dear fellas,

im having a problem in binding my data.

i have textbox txtbox_maker to input maker.

but then i want to list down all my "maker" in drop down list (ddl_maker)

i try.

<asp:SqlDataSource ID="SqlBindMaker" runat="server" ConnectionString="<%$ ConnectionStrings:ESConnectionString %>" 
                    SelectCommand="SELECT veq_ID, veq_Maker FROM IS_VesselEquipment WHERE veq_IsDeleted is NULL Order by veq_Maker">
                </asp:SqlDataSource>

and for vb

Protected Sub LoadMaker()
        ddl_maker.DataSource = SqlBindModel()
        ddl_maker.DataTextField = ("item_Maker")
        ddl_maker.DataValueField = ("item_ID")
        ddl_maker.DataBind()

        ddl_maker.Items.Insert(0, New ListItem("-- Choose --", "-1"))

    End Sub

but i got error "System.Data.DataRowView' does not contain a property with the name 'item_Maker'."

can anyone help me where am i wrong?

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on Oct 31, 2013 02:51 AM
Report

In your Query you have columns veq_ID, veq_Maker

So you need to use that while binding DropDown

 ddl_maker.DataSource = SqlBindModel()
        ddl_maker.DataTextField = ("veq_Maker")
        ddl_maker.DataValueField = ("veq_ID")
        ddl_maker.DataBind()
 
        ddl_maker.Items.Insert(0, New ListItem("-- Choose --", "-1"))

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

ASP.Net DropDownList Error :System.Data.DataRowView does not contain a property with the name itemMaker

Company

Explore

Follow us

Contact Us