Forms Data Controls :: Getting Dropdownlist Value On Update?
Jul 8, 2010
using vb.net/asp.net 2005:
I have a dropdownlist inside a gridview and when the user changes that value and then clicks the update button I want to get the value that was selected in the dropdownlist. I put the code below that I'm trying and the RowUpdating code that I am trying is throwing an exception when I try to get the "myDDL.SelectedValue" saying that the object is not set so I also tried the RowCommand but it looks like that sub is not being called.
how I can get the selectedvalue of the dropdownlist when updating?
[Code]....
View 3 Replies
Similar Messages:
May 10, 2010
I searched a lot of threads but still couldn't get my problem fixed. I have to update the "regform" table with two fields: session_ and session2. These two fields are inside the detailview edititem template which bounded to dropdown list drpsession1, drpsession2 separately. I wanted to pass the update parameters to the update sql UPDATE dbo.regform SET session_=@session_, session2=@session2 where id=@id
the @session_ is bounded to a drpsession1 and @session2 is bounded to drpsession2. I used
ControlID="ctl00$ContentPlaceHolder1$DetailsView1$drpsession1" to access the dropdown list within the detailview, but still couldn't do the updates. What's wrong with my code? Do I have to use the code behind to specify the update parameters? and How to do it? TIA.
<
"
asp:DetailsView
ID="DetailsView1"
runat="server"
AutoGenerateRows="False"
DataSourceID="SqlDataSource2"
Height="50px"
Width="544px"
DataKeyNames="id"
ondatabound="DetailsView1_DataBound">
<Fields>
<
asp:TemplateField
HeaderText="Session -Part I"
SortExpression="session_">
<
EditItemTemplate>
<asp:DropDownList
ID="drpsession1"
runat="server"
DataSourceID="SqlDataSource3"
DataTextField="session_time"
DataValueField="session_id"
SelectedValue='<%# Bind("session_") %>'
AppendDataBoundItems="True"
Width="229px">
<asp:ListItem
Text="Please select"
Value="-1"
/>
</asp:DropDownList>
<asp:SqlDataSource
ID="SqlDataSource3"
runat="server"
ConnectionString="<%$ ConnectionStrings:Connstr %>"
SelectCommand="SELECT dbo.sessions.* FROM dbo.sessions"></asp:SqlDataSource>
</EditItemTemplate>
<
asp:TemplateField
HeaderText="Session - Part II"
SortExpression="session2">
<EditItemTemplate>
<asp:DropDownList
ID="drpsession2"
runat="server"
DataSourceID="SqlDataSource4"
DataTextField="session_time"
DataValueField="session_id"
SelectedValue='<%# Bind("session2") %>'
AppendDataBoundItems="True"
Width="234px">
<asp:ListItem
Text="Please select"
Value="-1"
/>
</asp:DropDownList>
<asp:SqlDataSource
ID="SqlDataSource4"
runat="server"
ConnectionString="<%$ ConnectionStrings:Connstr %>"
SelectCommand="SELECT dbo.sessions2.* FROM dbo.sessions2">
</asp:SqlDataSource>
</EditItemTemplate>
</Fields>
</asp:DetailsView>
<
asp:SqlDataSource
ID="SqlDataSource2"
runat="server"
ConnectionString="<%$ ConnectionStrings:Connstr %>"
UpdateCommand
where regform.id=@id">
="UPDATE dbo.regform SET session_=@session_, session2=@session2 where id=@id">
<UpdateParameters>
<asp:ControlParameter
ControlID="ctl00$ContentPlaceHolder1$DetailsView1$drpsession1"
Name="session_"
PropertyName="SelectedValue"
Type="String"
/>
<asp:ControlParameter
ControlID="ctl00$ContentPlaceHolder1$DetailsView1$drpsession2"
Name="session2"
PropertyName="SelectedValue"
Type="String"
/>
<asp:ControlParameter
ControlID="DetailsView1"
Name="id"
PropertyName="SelectedValue"
/>
</UpdateParameters>
</asp:SqlDataSource>
View 2 Replies
Oct 26, 2010
I am a newbie in Asp.net, I can't update my database by using dropdownlist and click Update Button in the GridView,This is the picture of my GridView:
[URL=http://img15.imageshack.us/i/gridview.jpg/][IMG]http://img15.imageshack.us/img15/6593/gridview.jpg[/IMG][/URL]
Here is my codes:
<asp:TemplateField HeaderText="Status">
<EditItemTemplate>
<asp:SqlDataSource ID="SqlDropdownStatus" runat="server"
ConnectionString="<%$ ConnectionStrings:fypnewDBConnectionString %>"
[code]...
View 19 Replies
Dec 1, 2010
update database using data from dropdownlist on gridview C#
<asp:GridView ID="GridView" runat="server" AutoGenerateColumns="False"
View 7 Replies
Aug 13, 2010
I am trying to pass the value of a dropdownlist to the Update section of a listview. The dropdownlist is bound to one datasource which needs to then pass its selected value to the UpdateCommand sql for another datasource. Here is my code:
[code]....
View 5 Replies
Apr 19, 2010
See what happens when you answer my questions! I come back! No good deed goes unpunished. I've built an Update form where my visitor can update data in dbase. I have a formview with several dropdown lists; none of which will update the table (all the textboxes, checkboxes and even Ajax enabled calendar work just fine). In the form below, visitor selects a CareerCluster from the ddl. Upon postback, the next ddl (pathwayListBox) populates with related data using the CareerCluster.selectedvalue in a query. At the same time, tsaOrgsDropDownList is also populated based upon the first ddl (CareerCluster).
When user selects from the tsaOrgsDropDownList the final ddl (tsaDropDownList) is populated. All this various selecting/populating works just fine on the form. The problem is: Nothing is updated to the table upon clicking the Update button. All other form fields do post as their supposed to except, I have other ddls on the page that are not related to the above series and they won't post either. My thought is that somehow, this is related to the postbacking going on. That posting back is overwriting the selectedValues with null or something.
<asp:FormView ID="courseUpdateFormView" runat="server" BackColor="White" BorderColor="White" BorderStyle="Ridge" BorderWidth="2px" CellPadding="3" CellSpacing="1" DataKeyNames="CTECourseID" DataSourceID="formviewSqlDataSource" Width="715px">
<FooterStyle BackColor="#C6C3C6" ForeColor="Black" />
<RowStyle BackColor="#DEDFDE" ForeColor="Black" />
<EditItemTemplate>
<table align="center" width="700" border="1" cellpadding="10" cellspacing="2" bgcolor="White">
<%--A whole bunch of textboxes goes here--%>
<tr>
<td bgcolor="#dadada">
<strong>Number of HS Credits:</strong> <span>(Standards-based districts use the <em>Other</em> form field.)</span>
</td>
<td bgcolor="#FCCCCC">
<span><font color="red">Note: you must reselect HS Credits from the list or enter Other credits in the form field provided.</font></span><br />
<asp:DropDownList ID="numHSCreditsDropDownList" runat="server" TabIndex="3" ToolTip="Standards Based districts us the Other form field." ValidationGroup="HSCredits" AppendDataBoundItems="True" OnSelectedIndexChanged="numHSCreditsDropDownList_SelectedIndexChanged">
<asp:ListItem Selected="True" Value="0">--Choose One--</asp:ListItem>
<asp:ListItem>0.5</asp:ListItem>
<asp:ListItem>1.0</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td bgcolor="#dadada">
<strong>Career Cluster:</strong>
</td>
<td bgcolor="#FCCCCC">
<span><font color="red">Note: you must reselect Career Cluster from the list.</font></span><br />
<asp:DropDownList ID="careerCluster" runat="server" AutoPostBack="True" TabIndex="4">
<asp:ListItem Selected="True" Value="0">--Choose One--</asp:ListItem>
<asp:ListItem Value="1">Agriculture, Food & Natural Resources</asp:ListItem>
<asp:ListItem Value="2">Architecture & Construction</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td bgcolor="#dadada">
<strong>Pathways:</strong> <span>(Pathway as defined in the Cluster/Pathway model.)</span>
</td>
<td bgcolor="#FCCCCC">
<span><font color="red">Note: you must reselect Course Pathway from the list or enter Other Pathway in the form field provided.</font></span><br />
<asp:ListBox ID="pathwayListBox" runat="server" DataSourceID="CTECourses" DataTextField="ClusterPathway" DataValueField="ClusterPathway" SelectionMode="Multiple" Style="margin-left: 0px" TabIndex="5" Rows="3">
<asp:ListItem Selected="True" Value="0">--Choose One--</asp:ListItem>
</asp:ListBox>
<asp:SqlDataSource ID="CTECourses" runat="server" ConnectionString="<%$ ConnectionStrings:CareerTechEducationConnectionString %>" SelectCommand="SELECT [ClusterName], [ClusterPathwayID], [ClusterPathway], [ClusterCode] FROM [lkClustersPathways]
WHERE ([ClusterCode] = @ClusterCode)">
<SelectParameters>
<asp:ControlParameter ControlID="careerCluster" Name="ClusterCode" PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
</td>
</tr>
<tr>
<td align="center" bgcolor="#4A3C8C" colspan="2">
<asp:Label ID="occupationalStandardsLabel" runat="server" Font-Bold="True" ForeColor="White" Text="Occupational Standards"></asp:Label>
</td>
</tr>
<tr>
<td bgcolor="#dadada">
<strong>Source of Occupational Standards:</strong>
</td>
<td bgcolor="#FCCCCC">
<span><font color="red">Note: you must reselect Source of Occupational Standards from the list or enter Other Source of Occupational Standards in the form field provided.</font></span><br />
<asp:DropDownList ID="tsaOrgsDropDownList" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource3" DataTextField="TSAOrganization" DataValueField="TSAOrgID">
<asp:ListItem Selected="True">--Choose One--</asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:CareerTechEducationConnectionString %>" SelectCommand="SELECT [TSAOrgID], [TSAOrganization] FROM [lkTSAOrgs] WHERE ([TSAClusterID] = @TSAClusterID)">
<SelectParameters>
<asp:ControlParameter ControlID="careerCluster" Name="TSAClusterID" PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
</td>
</tr>
<%--A whole bunch of textboxes, checkboxes and other stuff goes here--%>
<tr>
<td bgcolor="#dadada">
<strong>What is the Summative Assessment (Technical Skills Assessment) for this course:?</strong>
</td>
<td bgcolor="#FCCCCC">
<span><font color="red">Note: you must reselect Summative Assessment from the list or enter Other Summative Assessment in the form field provided.</font></span><br />
<asp:DropDownList ID="tsaDropDownList" runat="server" AutoPostBack="false" DataSourceID="TSAs" DataTextField="TSA" DataValueField="TSAID" Width="300">
</asp:DropDownList>
<asp:SqlDataSource ID="TSAs" runat="server" ConnectionString="<%$ ConnectionStrings:CareerTechEducationConnectionString %>" SelectCommand="SELECT [TSAID], [TSA] FROM [lkTSAs] WHERE ([TSAOrgID] = @TSAOrgID)">
<SelectParameters>
<asp:ControlParameter ControlID="tsaOrgsDropDownList" Name="TSAOrgID" PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
</td>
</tr>
<%--A whole bunch of textboxes goes here--%>
<tr>
<td align="center" bgcolor="#dadada">
<asp:Button ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update" />
<br />
<span><font color="maroon">* All fields except the Tech Prep Information are required.</font></span></div>
</td>
<td align="center" bgcolor="#dadada">
<asp:Button ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" />
</td>
</tr>
</tr>
</table>
</EditItemTemplate>
</asp:FormView>
<asp:SqlDataSource ID="formviewSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:CareerTechEducationConnectionString %>" SelectCommand="SELECT * FROM tblCTECourses WHERE (CTECourseID = @CTECourseID)" UpdateCommand="UPDATE tblCTECourses
SET HSCredits = @HSCredits, CareerCluster = @CareerCluster, Pathways = @Pathways, TSAOrgs = @TSAOrgs, TSA = @TSA, LastUpdate = GETDATE() WHERE (CTECourseID = @CTECourseID)">
<SelectParameters>
<asp:SessionParameter Name="CTECourseID" SessionField="CTECourseID" Type="Int32" />
</SelectParameters>
<UpdateParameters>
<asp:FormParameter FormField="numHSCreditsDropDownList" Name="HSCredits" Type="String" />
<asp:FormParameter FormField="HSCreditsOtherTextBox" Name="HSCreditsOther" Type="String" />
<asp:FormParameter FormField="careerCluster" Name="CareerCluster" Type="Int32" />
<asp:FormParameter FormField="pathwayListBox" Name="Pathways" Type="String" />
<asp:FormParameter FormField="tsaOrgsDropDownList" Name="TSAOrgs" Type="Int32" />
<asp:FormParameter FormField="tsaDropDownList" Name="TSA" Type="String" />
<asp:FormParameter FormField="TSAOtherTextBox" Name="TSAOther" Type="String" />
</UpdateParameters>
</asp:SqlDataSource>
In the codebehind I've tried to set selectedvalue to session variable upon selected index changed like this:
Protected Sub numHSCreditsDropDownList_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
Session("HSCredit") = DirectCast(courseUpdateFormView.FindControl("numHSCreditsDropDownList"), DropDownList).SelectedValue
End Sub
View 5 Replies
Nov 20, 2010
I am new to asp.net (I may use some incorrect termology while I explain my issue...) and need some help with DropDownList in Gridview. Currently I have a GridView set up with three Columns bound to a database: Column1 - some kinda of index, Column2 - string, Column3 - DropDownList(called Active). So far when I build the page, all the columns show up and the DropDownList appears and the values are bound correctly. I want to change a value in the DropDownList and automatically update that value in my database.
I have set AutoPostBack = true and I made a DataObject (called UpdateActive) to update the database (it takes 2 inputs, the Column1 index and Column3 DropDownList value).However, I don't know how to find the row that I am changing, is there a way to figure out what row it is (like finding the Column 1 index?). Also, I don't want to have to click a button to update the data.
[Code]....
View 5 Replies
Nov 5, 2010
during edit mode i populate the drop down in question with data based on a value selected in another drop down also in the gridview, all works find, but the paramater is not being updated with the selected value, i think this is because i do not call any Bind in the aspx side.
<asp:TemplateField HeaderText="Build Types">
<ItemTemplate>
<asp:Label ID="lblBuildTypes runat="server" Text='<%# Bind("BuildType") %>'></asp:Label>
</ItemTemplate>
[Code]....
View 2 Replies
Oct 20, 2010
I have a GridView with a DropDownList in it bound to the [Applicants] table in SQL Server 2005.
The DropDownList Items Text and Value come from SqlDataSource3, "SELECT VoucherType, VoucherNumber FROM [Vouchers]"
I need to send the DDLs selected Text to [Applicants].[VoucherTypeIssued] and the Value to [Applicants]. VoucherNumber]
I already have a "dlVoucherTypeIssued_SelectedIndexChanged" event in the code behind to put "Voucher Issued" into [dbo].[Vouchers].[VoucherStatus]. I'm having trouble getting all three values written to the database at the same time.
View 3 Replies
Dec 9, 2010
Girdview has dropdownlist TemplateField called ddlSate, how to bind state field value in sql table to selected value of ddlState dropdownlist control? For example the sql table has AL value for state field, (Note by default ddlState lists all states options with sqldatasource), how AL is selected in ddlState when binding to ddlState?
Secondly, when user selects different state like GA, how below update stored precedure works? that means how to find ddl selected value in update procedure as shown below question mark line:
Here is part code:
<asp:GridView ID="gvOrder" runat="server" DataSourceID="ods1" AutoGenerateColumns="False"
style="margin-top: 11px" CssClass="pnlOrdercss" ScrollBars="Both"
BorderColor="Black" BorderWidth="1px">
<Columns>
[Code]....
View 2 Replies
Feb 22, 2013
I created 3 category table. categry1,categry2,categry3. product table.
And then use of gried view add ,edit ,update ,delete product . in product table.
In gridview retrive data from product table . i select categry from dropdownlist in gridview categry1, categry2, categry3 and save update dropdown list category value dynamically in product table. not define value static in source code.
When select category 1 change on selected index change categary 2 or 3.
In my code I used text box to ediit update delete. but here i will use dropdownlist.
View 1 Replies
Jun 16, 2015
I have one dropdown list and two textbox. I am developing a small application for my par tics in which currency name populate from the data base which are in drop down it will working now.
Now I want when I select currency name from dropdown list the code the and the country name show in the other textbox value .for example when I select Currency name like UK pound the value show .one show currency code 2 and other country name United state. All text box value change on changing vale in droupdownlist dynamically means all value dependent on the dropdown list .
All value from the data base
I bind three value with the currency name ,id,currency code and country name. because when I change the dropdown list so change value in text box .but I fail to do that.
How to value change in textbox to changing value in dropdown list. I know code show be on the DropDownList1_SelectedIndexChanged but I have no exact code
My data base.table
Id (primary key)Currency NameCurreny codecountyname
1 Bangla Taka3 Bangldash
2 Chines Yan5China
Code
private String strConnection = "Data Source=.SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|Database1.mdf;User Instance=true";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
[Code] .....
View 1 Replies
Mar 11, 2014
How to update each data in gridview from template field textbox?
if select reason is adjust-In then update plus the qty else adjust -Out minus the qty.
<asp:GridView ID="GridView1" HeaderStyle-BackColor="#3A64F2" HeaderStyle-ForeColor="White" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField= "RowNumber" HeaderText="RowNumber" />
<asp:BoundField DataField= "INV_ID" HeaderText="INV_ID" ItemStyle-Width="150" />
<asp:BoundField DataField= "INV_TYPE" HeaderText="INV_TYPE" ItemStyle-Width="150" />
<asp:BoundField DataField= "INV_SHORTDESC" HeaderText="INV_SHORTDESC" ItemStyle-Width="150" />
<asp:BoundField DataField= "INV_LOCATION" HeaderText="INV_LOCATION" ItemStyle-Width="150" />
<asp:BoundField DataField= "INV_QTY" HeaderText="INV_QTY" ItemStyle-Width="100" />
[CODE]....
View 1 Replies
Feb 26, 2013
Am having one gridview. In that there is some details and one hyperlink (for Mail) and one Label (Mail Status).
The Mail status label have default value Not Sent for all fields. If i click the Mail link and send mail to the corresponding person, then the Default label value will be automatically changed its text to Sent.
View 1 Replies
Feb 19, 2013
I want three fields in dropdown list in gridview . Pending , Solved , Escalate.
When I first submit the record it should show pending, then from dropdown I want to update it to solved or escalate , and it will be update with dropdown in database. How can I do this process....
View 1 Replies
Feb 21, 2013
in griedview how to save dropdown list value save in sql server .
View 1 Replies
Mar 10, 2013
[URL]
but i wanted know,how to update the country of any customer by just choosing it from the dropdownlist and updating it in the databse.
i wanted to add a common update below that updated the country of customers.
View 1 Replies
Feb 23, 2013
i have three saved values in database
1,2,3
i want to showing status in label for 1 , Pending
<asp:Label ID="lblLeaveStatus" Visible = "true" runat="server" Text='<%# Eval("Rec_Status").ToString() == "1" ? "Pending": Eval("Rec_Status") %>'>></asp:Label>
how can i show it with all 1,2,3?
View 1 Replies
Jul 17, 2015
How do i change the name column text the current row when the selected index of drop down is changed? ex:first row is mudassar khan and belgium, when i change belgium i want mudassar to be replaced to a name which i fetch from database....
View 1 Replies
Mar 29, 2011
I have a table and 7 column name.
I bind the 7 column name in one dropdownlist.
Now the problem is,how do I extract the data value in a dropdownlist?
For example,
Dropdownlist contain 7 column name
-subject_name
-subject_code
-venue
-time
-seat_no
-admission_no
-subject_id
when I click the subject_name,I want it to appear in a gridview
Example
Math|9.00-10.00|Hall|18|09090J|...
Below is my current codes which I have a problem.
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source= EN\SQLEXPRESS;" + "Initial Catalog=ms;Integrated Security=SSPI");
SqlDataAdapter adapSel;
string mySQL = "SELECT '" + dd_list.SelectedValue+ "' FROM examtimetable ";
adapSel = new SqlDataAdapter(mySQL, conn);
conn.Open();
DataSet dsSel = new DataSet();
adapSel.Fill(dsSel);
GridView1.DataSource = dsSel;
GridView1.DataBind();
conn.Close();
}
Previously I have bind 7 column name in my dropdownlist
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
SqlConnection conn = new SqlConnection("Data Source= EN\SQLEXPRESS;" + "Initial Catalog=ms;Integrated Security=SSPI");
SqlCommand sqlCmd = new SqlCommand("select column_name from information_schema.columns where table_name='examtimetable' and COLUMN_NAME not like '%ID'", conn);
conn.Open();
SqlDataReader ds;
ds = sqlCmd.ExecuteReader();
dd_list.Items.Clear();
dd_list.DataSource = ds;
dd_list.DataTextField = "Column_Name";
dd_list.DataValueField = "Column_Name";
dd_list.DataBind();
dd_list.Items.Insert(0, "Select Option");
ds.Close();
conn.Close();
}
}
View 10 Replies
Mar 28, 2011
Currently,below is my code.
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source= E\SQLEXPRESS;" + "Initial Catalog=k;Integrated Security=SSPI");
SqlDataAdapter adapSel;
string mySQL = "select column_name from information_schema.columns where table_name='examtimetable' '" + dd_list + "'";....
I receive an error "Incorrect syntax near 'System.Web.UI.WebControls.DropDownList'."
View 3 Replies
Mar 8, 2010
I want to making another dropdownlist visible=false when clicking in dropdownlist on the same detailsview?
View 4 Replies
Feb 4, 2011
I have a gridview and when i click on the edit button i will get the modalpopup window which is having a popup window i want to update the data in that details view and refresh the data into gridview also.
View 2 Replies
Jan 26, 2011
I get all hotels with my datalist. a label shows hotel names and a texbox gets order. I want to update values without clicking Submit.
I placed scriptmanager and update panel. I dont know next step
[Code]....
View 4 Replies
Jan 17, 2010
i want to build a datagrid bound to a datatable with several columns. One column has only a dropdownlist with the number of the rows in the datatable.
Here a samplescreenshot:
[URL]
I know how to bind the columns to a grid and its no problem to create such a dropdown list with the content for me, too. But i dont know how to sort the complete datatabl after changing one value of one dropdown listbox.
So, how can i resort the values of a datatable column based on a given value and the datarow id?
View 8 Replies
