asp.net - display field in gridview from another sqldatasource -


i trying implement gridview field data table, 1 of fields in table called "locationid" foreign key locations table. don't want display number on gridview want see address field locations table , edit value using dropdownlist control.

this main table in use gridview , sqldatasource

net-items   [id],[name] ,[model] ,[serialnumber] ,[company] ,[purchasedate] ,[purchaseprice] ,[monthprice] ,[commitmentprice] ,[status] ,[commitmentdate] ,[free] ,[tilldate] ,[locationid]

and secondary table

net-locations  [id] ,[contactname] ,[address] ,[city]

thanks

please try below code.

    <%@ page language="c#" autoeventwireup="true"  codefile="default.aspx.cs" inherits="_default" %>      <!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd">      <html xmlns="http://www.w3.org/1999/xhtml">     <head runat="server">     <title></title>     </head>     <body>     <form id="form1" runat="server">     <h3>items details</h3>     <div>         <asp:sqldatasource id="sds_items" runat="server"              connectionstring="<%$ connectionstrings:local %>"              providername="<%$ connectionstrings:local.providername %>"              selectcommand="select * items"></asp:sqldatasource>         <asp:sqldatasource id="sds_location" runat="server"              selectcommand="select * location"              connectionstring="<%$ connectionstrings:local %>"              providername="<%$ connectionstrings:local.providername %>"></asp:sqldatasource>         <asp:gridview id="gridview1" runat="server" autogeneratecolumns="false"              datasourceid="sds_items" autogenerateeditbutton="true" showfooter="true">             <columns>             <asp:templatefield headertext="id" >                 <itemtemplate>                     <asp:label id="id" runat="server" text='<%# bind("id") %>'></asp:label>                 </itemtemplate>                 <edititemtemplate>                     <asp:textbox id="txtid" runat="server" text='<%# bind("id") %>' width="98%" maxlength="6"></asp:textbox>                 </edititemtemplate>                 <footertemplate>                    <asp:textbox id="txtnewid" runat="server" text='<%# bind("id") %>' width="98%" maxlength="6"></asp:textbox>                 </footertemplate>                 <itemstyle width="80px" />              </asp:templatefield>             <asp:templatefield headertext="location" >                 <itemtemplate>                     <asp:label id="lbllocation" runat="server" text='<%# lookuplocation(databinder.eval(container.dataitem, "locationid")) %>'></asp:label>                  </itemtemplate>                 <edititemtemplate>                     <asp:dropdownlist id="ddllocation" runat="server" datasourceid="sds_location" datatextfield="id" datavaluefield="id" selectedvalue='<%#bind("locationid")%>' width="98%">                     </asp:dropdownlist>                  </edititemtemplate>                 <footertemplate>                     <asp:dropdownlist id="ddlnewlocation" runat="server" datasourceid="sds_location" datatextfield="address" datavaluefield="id" selectedvalue='<%#bind("locationid")%>' width="95%">                     </asp:dropdownlist>                  </footertemplate>                <itemstyle width="25%" />             </asp:templatefield>              </columns>         </asp:gridview>     </div>     </form>     </body>     </html>      using system; using system.collections.generic; using system.web; using system.web.ui; using system.web.ui.webcontrols; using system.collections; using system.data;  public partial class _default : system.web.ui.page  {     protected void page_load(object sender, eventargs e)     {      }     protected string lookuplocation(object idobj)     {         if (string.isnullorempty(idobj.tostring()))             return null;          // store permissionid passed input parameter         string locationid = idobj.tostring();          // find corresponding name         ienumerator enumos = sds_location.select(new datasourceselectarguments()).getenumerator();         while (enumos.movenext())         {             datarowview row = enumos.current datarowview;              if ((string)row["id"].tostring() == locationid)                 return string.concat(row["address"].tostring());         }          return locationid;     } }

Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more