asp.net - Add gridview nested dropdown.selectedValue to database -


i have 2 tables relevant question...

tblcelltechnology   celltechnologyid, pk   description   cellname  tblactionschedule   actionid, pk   actionphase   actionperiod   celltechnology, fk

i have bulk edit grid view text boxes displaying actionid, phase, period , dropdownlist linked directly celltechnologyid tblcelltechnology (as per image). have textbox displaying cell name based on value in tblscheduleaction.celltechnologyid (actiondescription pulled table).

how can selected value ddl , write tblscheduleaction.celltechnologyid? when hard add celltechnologyid tblscheduleactionid, cellname textbox displays correct value. need able store ddl.selectedvalue tblscheduleaction.celltechnologyid. using masterpages , sqldatasources handle inserting/updating/deleting of records.

i want celltechnologyid column in bottom gridview display list of potential celltechnologyid, directly linked column top grid view, selected value should stored in tblscheduleaction.celltechnologyid. cellname column should display respective cellname. say, picture worth thousand words... http://imgur.com/21fjozh

by nested gridviews, assume referring child gridview inside each parent gridview row. getting values of child gridview controls pretty easy.

how can selected value ddl , write tblscheduleaction.celltechnologyid?

  1. you use findcontrol find childgridview in foreach loop on save records
  2. you use find control find dropdownlists & save database

check working example (aspx)

    <%@ page language="c#" autoeventwireup="true" codebehind="nestedgridviews.aspx.cs" inherits="webapplication1.nestedgridviews" %> <!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">     <div>          <asp:gridview id="gvparent" runat="server" autogeneratecolumns="false"              datakeynames="categoryid" datasourceid="sdsparentgrid"              onrowdatabound="gridview1_rowdatabound">             <columns>                 <asp:boundfield datafield="categoryid" headertext="categoryid"                      insertvisible="false" readonly="true" sortexpression="categoryid" />                 <asp:boundfield datafield="categoryname" headertext="categoryname"                      sortexpression="categoryname" />                 <asp:boundfield datafield="description" headertext="description"                      sortexpression="description" />                 <asp:templatefield>                     <itemtemplate>                         <asp:gridview id="gvchildgrid" runat="server" autogeneratecolumns="false"                              datakeynames="productid" datasourceid="sdschildgrid">                             <columns>                                 <asp:boundfield datafield="productid" headertext="productid"                                      insertvisible="false" readonly="true" sortexpression="productid" />                                 <asp:boundfield datafield="productname" headertext="productname"                                      sortexpression="productname" />                                 <asp:boundfield datafield="supplierid" headertext="supplierid"                                      sortexpression="supplierid" />                                 <asp:boundfield datafield="categoryid" headertext="categoryid"                                      sortexpression="categoryid" />                                 <asp:checkboxfield datafield="discontinued" headertext="discontinued"                                      sortexpression="discontinued" />                                 <asp:templatefield headertext="my dropdown column">                                     <itemtemplate>                                         <asp:dropdownlist id="ddltest" runat="server">                                             <asp:listitem>potatoes</asp:listitem>                                             <asp:listitem>tomatoes</asp:listitem>                                             <asp:listitem>mangoes</asp:listitem>                                         </asp:dropdownlist>                                     </itemtemplate>                                 </asp:templatefield>                             </columns>                         </asp:gridview>                         <asp:sqldatasource id="sdschildgrid" runat="server"                              connectionstring="<%$ connectionstrings:northwindconnectionstring %>"                              selectcommand="select [productid], [productname], [supplierid], [categoryid], [discontinued] [alphabetical list of products] ([categoryid] = @categoryid)">                             <selectparameters>                                 <asp:parameter name="categoryid" type="int32" />                             </selectparameters>                         </asp:sqldatasource>                     </itemtemplate>                 </asp:templatefield>             </columns>         </asp:gridview>         <asp:sqldatasource id="sdsparentgrid" runat="server"              connectionstring="<%$ connectionstrings:northwindconnectionstring %>"              selectcommand="select [categoryid], [categoryname], [description] [categories] order [categoryname]">         </asp:sqldatasource>      </div>     <asp:button id="btnsave" runat="server" onclick="btnsave_click"          text="save database" />     </form> </body> </html>

codebehind

    using system; using system.collections.generic; using system.linq; using system.web; using system.web.ui; using system.web.ui.webcontrols;  namespace webapplication1 {     public partial class nestedgridviews : system.web.ui.page     {         protected void page_load(object sender, eventargs e)         {          }          protected void gridview1_rowdatabound(object sender, gridviewroweventargs e)         {             if (e.row.rowtype == datacontrolrowtype.datarow)             {                 gridview gvchild = e.row.findcontrol("gvchildgrid") gridview;                 sqldatasource sdstemp = e.row.findcontrol("sdschildgrid") sqldatasource;                 if (sdstemp!=null)                 {                     sdstemp.selectparameters[0].defaultvalue = gvparent.datakeys[e.row.rowindex]["categoryid"].tostring();                     if (gvchild != null)                     {                         gvchild.databind();                     }                 }             }         }          protected void btnsave_click(object sender, eventargs e)         {             foreach (gridviewrow growparent in gvparent.rows)             {                 // find child gridview each row                 gridview gvchild = growparent.findcontrol("gvchildgrid") gridview;                 if (gvchild != null)                 {                     // use foreach loop find control                     foreach (gridviewrow growchild in gvchild.rows)                     {                         dropdownlist ddltemp = growchild.findcontrol("ddltest") dropdownlist;                         if (ddltemp != null)                         {                             response.write(ddltemp.selectedvalue.tostring());                         }                     }                 }             }         }     } }

enter image description here


Comments

Post a Comment

Popular posts from this blog

Why does Ruby on Rails generate add a blank line to the end of a file? -

running rails generate controller foo home results in: class foocontroller < application controller def home end end (there's nothing on line in actual file, blank line) is there purpose blank line? it's common use newline indicate end of line, last line. many editors (like vi, use) add in newline silently. consensus text files (especially in unix world) should end in newline, , there have been problems historically if wasn't present. why should text files end newline? the tool used count lines in file "wc" counts newlines in file, without trailing newline show 3 instead of 4. it improves readability of templates used in generator. consider: https://github.com/rails/rails/blob/master/railties/lib/rails/generators/rails/controller/templates/controller.rb to remove trailing newline, template have last line of: end<% end -%> instead of: end <% end -%> that seems less readable me. the discussion below refers
Read more

keyboard - Smiles and long press feature in Android -

i've created android keyboard. how add features inserting smilies, , using long keypresses display symbols? to create long-press behavior allows select several options pop-up menu, follow guide (specifically pop-up menu section): http://developer.android.com/guide/topics/ui/menus.html smileys (also known emoticons) combination of keys, understood programs , parsed same way. have do, when clicks smiley face on keyboard, simulate pressing of key combination matching emoticon. example, when clicks smiley, should simulate key presses ':' , ')' :). here's list of emoticons: http://en.wikipedia.org/wiki/list_of_emoticons
Read more

node.js - Bad Request - node js ajax post -

i'm using express 3.0 , node v0.11.0. have button submits form , i'm using ajax post data json object node server. client code is: $('#contact').submit(function(e) { console.log('submit called'); var formdata = json.stringify($('form').serializeobject()); console.log(formdata); $.ajax({ url: "http://localhost:3000/savedata/", type: "post", datatype: 'json', data: {objectdata: formdata}, contenttype: "application/json", complete: function() { console.log('process complete'); }, success: function(data) { console.log('process sucess'); }, error: function() { console.log('process error'); }, }); return false; }); then on server: var express = require('express'); var app = express(); app.set('views', __dirname + '/views'); app.set('view engine', 'jade'); app.use(express.bodyparser());
Read more