asp.net - a field or property with the name was not found on the selected data source x -

i've come across before don't recall how handled it.

building website asp/vb.net 4.0, accessing mssql v.2005 database, populating gridview. webpage worked fine until added code process parameters in url: .../etl_s_export_mm002.aspx?ven=74&all=y

the page showed * view before, insists vendor_name_1 doesn't exist. if comment references out, insists vendor_name_2 doesn't exist. @ wits' end, please save me...

sql data source:

<asp:sqldatasource id="sqldatasource1" runat="server"      connectionstring="<%$ connectionstrings:erpconnectionstring %>"      selectcommand="select vendor_number                         , vendor_name_1                         , vendor_name_2                         , etlid                         , remits_seq                       [dbo].[...]" > </asp:sqldatasource> 

gridview:

<asp:gridview id="gridview1"      runat="server"      allowpaging="true"      pagesize="200"     allowsorting="true"      autogeneratecolumns="false"      gridlines="vertical"     datasourceid="sqldatasource1"      cellpadding="4"     cssclass="gridviewpagegrid">     <alternatingrowstyle cssclass="gridviewalternatingrowstylegrid"/>     <columns>         <asp:templatefield headertext="vendor number"  sortexpression="vendor_number">             <itemtemplate>                 <div style="width:120px; text-align:center;">                     <asp:label id="l2" runat="server" text='<%# eval("vendor_number")%>'/>                 </div>             </itemtemplate>         </asp:templatefield>         <asp:hyperlinkfield              datatextfield="remits_seq"             headertext="remit sequence"             sortexpression="remits_seq"             itemstyle-horizontalalign="center"             datanavigateurlfields="remits_seq, vendor_number"              datanavigateurlformatstring ="etl_s_export_mm002_one.aspx?rs={0}&vn={1}">             <itemstyle horizontalalign="center"></itemstyle>         </asp:hyperlinkfield>         <asp:boundfield datafield="vendor_name_1"   headertext="vendor name 1" sortexpression="vendor_name_1" />         <asp:boundfield datafield="vendor_name_2"   headertext="vendor name 2" sortexpression="vendor_name_2" />     </columns> </asp:gridview> 

code behind add "where" statements query, if needed (db object takes care of building statement):

dim flag string = request.querystring("all") dim db new classdashboard db.objectkey = "mm002" db.parmvna = request.querystring("vna") db.parmven = request.querystring("ven") db.selectfilterparm() if flag = "n"     if db.filter = ""         if db.parmvna <> "" db.filter = "vendor_name_1 '%" & db.parmvna & "%'"     else         if db.parmvna <> "" db.filter &= " or vendor_name_1 '%" & db.parmvna & "%'"     end if     if db.filter = ""         if db.parmven <> "" db.filter = "vendor_number '%" & db.parmven & "%'"     else         if db.parmven <> "" db.filter &= " or vendor_number '%" & db.parmven & "%'"     end if elseif flag = "y"     if db.filter = ""         if db.parmvna <> "" db.filter = "vendor_name_1 '%" & db.parmvna & "%'"     else         if db.parmvna <> "" db.filter &= " , vendor_name_1 '%" & db.parmvna & "%'"     end if     if db.filter = ""         if db.parmven <> "" db.filter = "vendor_number '%" & db.parmven & "%'"     else         if db.parmven <> "" db.filter &= " , vendor_number '%" & db.parmven & "%'"     end if   end if db.countallrecords() db.countsomerecords() db.buildcountsheader() db.buildcountssql() '   ---------------------- '   add header page '   ---------------------- panel1.controls.add(new literalcontrol(db.counts_header)) '   ------------------------------------- '   adjust sql according parms '   ------------------------------------- me.sqldatasource1.selectcommand = db.counts_sql 

the view:

select coalesce (m.vendor_number, '') vendor_number      , coalesce (m.vendor_name_1, '') vendor_name_1      , coalesce (m.vendor_name_2, '') vendor_name_2      , coalesce (m.remits_seq   , '') remits_seq      , coalesce (m.etlid        , '') etlid   from.... 

as can see, rows exist in view.

thank time. let me know of questions can answer.

3-31-2014 can help?