asp.net - Problems with Formview showing details of Gridview selected row -


i trying have user select row in grid view , have set of details entry display in formview. currently, getting error "invalid column name 's.sprayid' ". have encountered several issues , out of ideas. have posted code below. ideas on how fix or better way it? thanks. 

<asp:gridview id="gvhistory" runat="server" datasourceid="dshistory" allowpaging="true" allowsorting="true" cellpadding="4" forecolor="#333333" gridlines="none" datakeynames="sprayid">     <alternatingrowstyle backcolor="white" forecolor="#284775"></alternatingrowstyle>     <columns>         <asp:commandfield showselectbutton="true"></asp:commandfield>     </columns>     <editrowstyle backcolor="#999999"></editrowstyle>      <footerstyle backcolor="#5d7b9d" font-bold="true" forecolor="white"></footerstyle>      <headerstyle backcolor="#5d7b9d" font-bold="true" forecolor="white"></headerstyle>      <pagerstyle horizontalalign="center" backcolor="#284775" forecolor="white"></pagerstyle>      <rowstyle backcolor="#f7f6f3" forecolor="#333333"></rowstyle>      <selectedrowstyle backcolor="#e2ded6" font-bold="true" forecolor="#333333"></selectedrowstyle>      <sortedascendingcellstyle backcolor="#e9e7e2"></sortedascendingcellstyle>      <sortedascendingheaderstyle backcolor="#506c8c"></sortedascendingheaderstyle>      <sorteddescendingcellstyle backcolor="#fffdf8"></sorteddescendingcellstyle>      <sorteddescendingheaderstyle backcolor="#6f8dae"></sorteddescendingheaderstyle> </asp:gridview> <asp:sqldatasource id="dshistory" runat="server" connectionstring='<%$ connectionstrings:wsfconnectionstring %>' selectcommand="select [sprayid], [date], [timestart] [spray] ([date] >= (getdate() - 7)) order [date] desc, [timestart] desc"></asp:sqldatasource> <asp:formview id="fvhistorydetail" runat="server" cellpadding="4" forecolor="#333333" datasourceid="dshistorydetail" datakeynames="sprayid">     <edititemtemplate>         sprayid:         <asp:label text='<%# eval("sprayid") %>' runat="server" id="sprayidlabel1" /><br />         <asp:linkbutton runat="server" text="update" commandname="update" id="updatebutton" causesvalidation="true" />&nbsp;<asp:linkbutton runat="server" text="cancel" commandname="cancel" id="updatecancelbutton" causesvalidation="false" />     </edititemtemplate>      <editrowstyle backcolor="#999999"></editrowstyle>      <footerstyle backcolor="#5d7b9d" font-bold="true" forecolor="white"></footerstyle>      <headerstyle backcolor="#5d7b9d" font-bold="true" forecolor="white"></headerstyle>      <insertitemtemplate>         <asp:linkbutton runat="server" text="insert" commandname="insert" id="insertbutton" causesvalidation="true" />&nbsp;<asp:linkbutton runat="server" text="cancel" commandname="cancel" id="insertcancelbutton" causesvalidation="false" />     </insertitemtemplate>     <itemtemplate>         sprayid:         <asp:label text='<%# eval("sprayid") %>' runat="server" id="sprayidlabel" /><br />      </itemtemplate>      <pagerstyle horizontalalign="center" backcolor="#284775" forecolor="white"></pagerstyle>      <rowstyle backcolor="#f7f6f3" forecolor="#333333"></rowstyle> </asp:formview> <asp:sqldatasource id="dshistorydetail" runat="server" connectionstring='<%$ connectionstrings:wsfconnectionstring %>' selectcommand="select s.sprayid 'id', [date], timestart 'time start', startlocationdescription 'start', endlocationdescription 'end', v.vehiclenumber, (a.firstname + a.lastname) 'applicator', c.tradename 'chemical' spray s join vehicle v on s.vehicleid = v.vehicleid join applicator on s.applicator1id = a.applicatorid join spraychemicalsused scu on scu.sprayid = s.sprayid join chemicalsused cu on scu.chemusedid = cu.chemusedid join chemical c on cu.chemid = c.chemid ([s.sprayid] = @sprayid)">     <selectparameters>         <asp:controlparameter controlid="gvhistory" propertyname="selectedvalue" defaultvalue="1" name="sprayid" type="int32"></asp:controlparameter>     </selectparameters> </asp:sqldatasource>

the issue select command query:

select s.sprayid 'id', [date], timestart 'time start', startlocationdescription 'start', endlocationdescription 'end', v.vehiclenumber, (a.firstname + a.lastname) 'applicator', c.tradename 'chemical' spray s join vehicle v on s.vehicleid = v.vehicleid join applicator on s.applicator1id = a.applicatorid join spraychemicalsused scu on scu.sprayid = s.sprayid join chemicalsused cu on scu.chemusedid = cu.chemusedid join chemical c on cu.chemid = c.chemid ([s.sprayid] = @sprayid)

does column exist , name correct first thing check.

i open in sql management query or whatever database tool using , working in there first. should quite apparent issue gui highlight errors in sql syntax.


Comments

Post a Comment

Popular posts from this blog

jOOQ update returning clause with Oracle -

according http://www.jooq.org/doc/3.8/manual/sql-building/sql-statements/update-statement/ jooq doesn't support returning clause in update statements databases except firebird , postgres. does know, still correct oracle jooq? according oracle's documentation, oracle db supports returning clase delete, insert, or update statements. incorrect manual you're right - manual wrong , should fixed: https://github.com/jooq/jooq/issues/5470 single row update returning jooq 3.8 added support single row update .. returning statements. internally, uses callablestatement , pl/sql block of form: begin update "my_table" set "my_table"."column" = 'xyz' "my_table"."id" = 1 returning "my_table"."id", "my_table"."column" ?, ?; ? := sql%rowcount; end; the relevant issue is: https://github.com/jooq/jooq/issues/5190 multi row update returning a...
Read more

java - Warning equals/hashCode on @Data annotation lombok with inheritance -

i have entity inherits other. on other hand, i'm using lombok project reduce boilerplate code, put @data annotation. annotation @data inheritance produces next warning: generating equals/hashcode implementation without call superclass, though class not extend java.lang.object. if intentional, add '@equalsandhashcode(callsuper=false)' type. is advisable add annotation @equalsandhashcode (callsuper = true) or @equalsandhashcode (callsuper = false) ? if not added, 1 callsuper=false or callsuper=true ? the default value false . 1 if don't specify , ignore warning. yes, recommended add @equalsandhashcode annotation on @data annotated classes extend else object. cannot tell if need true or false , depends on class hierarchy, , need examined on case-by-case basis. however, project or package, can configure in lombok.config call super methods if not direct subclass of object. lombok.equalsandhashcode.callsuper = call for configuration system ...
Read more

java - BasicPathUsageException: Cannot join to attribute of basic type -

i using java 8 jpa (hibernate 5.2.1). have clause works perfectly, until introduce clause make use foreign key table values too. i getting following error: basicpathusageexception: cannot join attribute of basic type i think problem related fact have join table, , not sure how create join using join table. employee - employee_category - category model (employee.java): @manytomany(cascade = cascadetype.all, fetch=fetchtype.eager) @jointable ( name="employee_category", joincolumns={ @joincolumn(name="emp_id", referencedcolumnname="id") }, inversejoincolumns={ @joincolumn(name="cat_id", referencedcolumnname="id") } ) private set<category> categories; model (category.java): @id private string id; jpa when introduce following code, fails error above (i think problem new piece of code): join<t, category> category = from.join("id"); predicates.add(criteriabuilder.like(category....
Read more