Forms Data Controls :: Reload Datasource And Dropdownlist?
Jun 10, 2010
i think i can't see the forrest for the trees.......there HAS to be a simple way to do this. so i created a web page and on that page i have two dropdown lists. the first is STATE and the second is COUNTY. the STATE is a static list. but the COUNTY is generated whenever the STATE changes. now....when i set up the COUNTY dropdown list, it prompted me for a datasource. i have a store procedure which takes the 2-letter STATE code and returns all the counties for that state. so i set up the datasource for the COUNTY drop down list by just following the prompts from visual studio. i gave it a default state of Alabama (AL). and all is fine. so here's my question: how can i reload the datasource and subsequently the COUNTY dropdown list? i see no way to access the datasource that the environment generated for me.
well.....i thought.......i'll just do it the old fashioned way and set up a command.......connectionstring.......and sql statement and load the results into a datareader (do i REALLY have to do all that?)
but it still doesn't work. what's the simplest way for me to just re-fire my stored procedure and pass it the STATE parameter and reload the datasource and dropdown list?
View 3 Replies
Similar Messages:
Jun 22, 2010
i have dropdownlist. After i loaded data from javascript to dropdownlist,i used dropdownlist.item.count but counter always null. how to refresh dropdownlist?
View 5 Replies
Jan 28, 2011
I have a drop downlist,and next to it there is an MS bar chart.i want to change the datate of the MS chart ,once the user selects another year from the dropdownlist.
When the page loads ,the chart displays the default year(2011) and it works.The problem is that is does not change the data when you select another year from the dropdownlist.
View 1 Replies
May 19, 2010
I have a cascading dropdownlist. The first drop down is for Departments and is databound on PageLoad from the database. The user then selects a department and the second dropdown is populated with the appropriate sub departments via JQuery/JSON which calls an httphandler. The problem is as follows: I select a department and the subdepartments are filled.
I finish what I'm doing on that screen and everything is fine. But then if I go to a different screen and add an additional subdepartment then come back to original screen, the new sub department won't appear in the cascading dropdown. I have to close the browser and restart the session in order for any new sub departments to appear even though they are in the database. I put a breakpoint in the httphandler and noticed that it is only called once per session per each department in the first dropdown. I don't know why this is happening. I want it to call the httphander EVERY time the index of the department dropdown is changed.
[Code]...
View 3 Replies
May 14, 2010
I removed some items from a dropdownlist, and now I want to re-initialze the items which I have on aspx file.
<asp:DropDownList ID="s1" runat="server">
<asp:ListItem Value="0.00">Select</asp:ListItem>
<asp:ListItem Value="0.25">0.25</asp:ListItem>
<asp:ListItem Value="0.50">0.50</asp:ListItem>
<asp:ListItem Value="0.75">0.75</asp:ListItem>
<asp:ListItem Value="1.00">1.00</asp:ListItem>
<asp:ListItem Value="1.25">1.25</asp:ListItem>
<asp:ListItem Value="1.50">1.50</asp:ListItem>
<asp:ListItem Value="1.75">1.75</asp:ListItem>
</asp:DropDownList>
Such as I removed "1.50" and "1.75", and when a button clicked, the dropdownlist will initialze again with these 8 items. How do I do that?
View 5 Replies
Sep 17, 2010
I have a dropdown which shows filesnames and when the index is changed, the slected file is offered for download. I also have a button which creates new files ... now after a new file was created, the new filename should also be shown in the dropdown. It works fine, when I refresh the page, but this is not what I want. I tried putting the dropdown in an updatepanel and giving it the file create button id, it failed ... is this the correct apporach or is there an easier way?
View 5 Replies
Jul 13, 2010
I have a problem with connecting a DropDownList to a DataSource.
The scenario: When I add am item to the database (I do this using a GridView/ObjectDataSource / SPROC) I want to update a DropDownList that lists this items as well.This DropDownList is linked with another ObjectDataSource. Now, I listen to the RowCommand event of the GridView and in a certain case I refresh the DataSource of the DrpoDownList and do a DataBind to the DropDownList afterwards.
The strange thing is, that when I take a look at the DropDownList's Items-Collection during the Page's OnPreRender event handling, the items collection contains the new entry but the new entry is not rendered, i.e. when I take a look at the rendered HTML the <option></option> entry for the new value is missing.
After another postback to the page the entry appears in the DropDownList?
View 3 Replies
Jun 10, 2010
I am trying to use a datasource with a dropdownlist. Eventually, my data source method to call a stored procedure and load the datatable is returns, but for now, I am just creating the datatable manually. I need each item to have two attributes, the text, whixh the user will see in the DDL, and the value that the program will retrieve from and store back to the file.
It is partly working in that the DDL has 3 items, however the text for each item reads "System.Data.DataRowView"
I have to be close, but I can't figure out what I am doing wrong.
[Code]....
View 8 Replies
Sep 8, 2010
I have a Dropdownlist in an itemTemplate in a gridview. My gridView binds to dataTable1 (from which the selected value for dropdown comes from) and dropDown binds to dataTable2 (i need to get DataValueField and DataTextField from here).
[Code]....
View 3 Replies
Sep 8, 2010
I am using a DataGridView and have a master table which contains values which different tables related to the master data, i.e. StatusID =1 in master table = TrailerStatus (1, 2, 3, 4 and their descriptions) are in a related table. I am able to retrieve the values from Table B 1 = Empty, 2 = Rejected, 3 = Onsite, etc. However, I don't know how to relate the master table StatusID = 1 to default my dropdown list from the relational table 1, 2, 3, 4.
I have been fighting with this for quite some time and just have not found a solid example of how to do this. I actually have two dropdownlists which will need to be correctly wired in order for my application to work.
This will also be an editable dataGridView but I will tackle that challenge once I get this first hair plucked from my butt.
There is some code-behind which doesn't work at all pertaining to a ;; gvSCACDetail_RowDataBound ;;
but I dont' think I can even get the code to compoile when this is not commented out.
Here are some of the details:
<td style="width: 700px; height: 20px">
<asp:GridView ID="gvSCACDetail" runat="server" AutoGenerateColumns="False" AutoGenerateEditButton="True" DataKeyNames="trailerid,locationid,scacid,statusid,capacityid" AutoGenerateDeleteButton="True" DataSourceID="SCACDetailView" Visible="False" Width="698px">
<PagerStyle CssClass="centerh" HorizontalAlign="Center" />
[Code]....
View 2 Replies
May 9, 2010
Stuck trying to populate a dropdownlist with an ObjectDataSource using the wizard.
using the wizard i can successfully configure the datasource, then I can choose the datasource. The next step you should be able to select your display value and the selected value. However, these boxes are not populated within the wizard. I added a gridview to test the datasource and it displays fine.
[Code]....
View 4 Replies
Mar 2, 2011
I have two embedded dropdown lists in Gridview control. One gives you business channel options and the other represents products depending on the business channel selected.I am trying to use different data sources for product dropdown list depeding on what the user selected from the business channel drop down list. How could I do this. Here is my current code:
[Code]....
View 2 Replies
Feb 23, 2010
I am trying to bind the datasource of a ddl which is located inside the EditTemplate of a TemplateField.When is the best time to bind this datasource (after loading grid, before editing, ? (Note: I must do this in code behind).I am currently trying to bind it on the edit command:
[Code]....
The issue is that the list retrieved from the LoadLists method is null when passing to the LoadList method where the datasource is bound.
View 5 Replies
Mar 31, 2010
I have 2 dropdownlist(ddlCategoryFooter and ddlItemCodeFooter)inside my gridview. I want to set ddlItemCodeFooter 's datasource to my getItemList(decimal categoryID) method. The selecteditem of ddlCategoryFooter will serve as the paramter which will be passed to my getItemList Method. Basically,ddlItemCodeFooter is dependent on ddlCategoryFooter's selectedItem.
I know it can be done in code behind approach but i prefer to place it in my asp page.
This i what i want to acheive:
DataSource ='<%# getItemList(Convert.ToDecimcal(ddlCategoryFooter.seletectItem))%>'/>
Source code for my Gridview:
[Code]....
View 8 Replies
Feb 1, 2010
I have a user control with a datalist loaded on my web page and also a web form to add another entry to the datalist when the button to submit the new entry I need to reload the user contol to show the new entry
<h1>Admin</h1>
<h2>News</h2>
<asp:label ID="lblSearch" Text="Select News: " runat="server" />
<asp:DropDownList ID="NewsList" runat="server" CssClass="DropDownMenu" />
<asp:Button ID="btnSearch" Text="Search" runat="server" OnClick="btnSearch_Click" />
<br />
<br />
<asp:Label ID="dbErrorMessage" ForeColor="Red" runat="server" />
<asp:Label ID="Successfulmessage" runat="server" />
<br />
<asp:Label ID="lblTitle" runat="server" Text="Title" CssClass="TextBoxLabel" />
<br />
<asp:TextBox ID="txtTitle" runat="server" CssClass="TextBox" />
<br />
<br />
<asp:Label ID="lblNews" runat="server" Text="News" CssClass="TextBoxLabel" />
<br />
<asp:TextBox ID="txtNews" runat="server" TextMode="MultiLine" Width="500px" Rows="10" CssClass="TextBox" />
<br />
<asp:Button ID="btnSubmit" Text="Submit" runat="server" Onclick="btnSubmit_Click" />
<asp:Button ID="btnUpdate" Text="Update" runat="server" OnClick="btnUpdate_Click" />
<asp:Button ID="btnDelete" Text="Delete" runat="server" OnClick="btnDelete_Click" />
<br />
<br />
<uc1:NewsList ID="NewsList1" runat="server" />
<br />
protected void btnSubmit_Click(object sender, EventArgs e)
{
// Define data objects
SqlConnection conn;
SqlCommand comm;
// Read the connection string from Web.Config
string connectionString = ConfigurationManager.ConnectionStrings["platiummindproductions"].ConnectionString;
// Initialise connection
conn = new SqlConnection(connectionString);
// Create Command
comm = new SqlCommand("INSERT INTO News (Title, Date, News) VALUES (@Title, @Date, @News)", conn);
// Add command parameters
comm.Parameters.Add("@Title", System.Data.SqlDbType.NVarChar, 50);
comm.Parameters["@Title"].Value = txtTitle.Text;
comm.Parameters.Add("@Date", System.Data.SqlDbType.DateTime);
comm.Parameters["@Date"].Value = DateTime.Now;
comm.Parameters.Add("@News", System.Data.SqlDbType.NVarChar, 4000);
comm.Parameters["@News"].Value = txtNews.Text;
// Enclose database in try-catch-finally
try
{
// Clear message labels
Successfulmessage.Text = "";
dbErrorMessage.Text = "";
// Open the connection
conn.Open();
// Execute the command
comm.ExecuteNonQuery();
DataBind();
// Display sussessful message
Successfulmessage.Text = "News Updated successfully!";
}
catch
{
// Display error message
dbErrorMessage.Text = "Error updating the News details! Please try again later!";
}
finally
{
// Close the connection
conn.Close();
}
}
View 1 Replies
Apr 8, 2010
I have a FormView at the very bottom of the page in insert/edit mode. When I click insert/update button, the whole page reload and the pointer does not keep within the Formview but go to the very top of the page far away from the desired FormView.
What can I do here to prevent cursor going outside the Formview ? Is it I can use update panel ? What and where I should use the tags ? Or there are other better way ?
View 2 Replies
Jan 5, 2010
I'm using a SP to fill the drop down list and when I look at the values in the drop down list the first row of the dataset is missing.Here's the code I'm using, I've left out the database connection info and the link to the SP
StaffListRS = cmdStaff.ExecuteReader()
If StaffListRS.Read() Then
ddlStaffList.Datasource = StaffListRS
ddlStaffList.DataTextField = "StaffName"
ddlStaffList.DataValueField = "NewStaffID"
ddlStaffList.DataBind()
ddlStaffList.Items.Insert(0, New ListItem("All", 0)
If
View 3 Replies
Apr 19, 2012
I have 5 dropdown list (sector-country-year-project code-project title) so what i need is when i select specific sector for example education , the rest of the label should show me the only data related to the sector education in dropdown list. the same with other if i select year 2011 should show me in other dropdown list just the data related to year 2011.
View 1 Replies
Nov 15, 2010
i use 2 dropdownlist with 2 object data source first dropdownlist to display departments name using object datasource (field to display DeptName , value of field DeptID)
second dropdownlist to display Employee name but depend on departments (field to display EmpName , value of field EmpID)
how to display employee name in dropdownlist depend on departments name in the other dropdownlist
2 tables
1 table deprtments with column (DeptID , DeptName , DeptDescription)
2 table Employee with column (EmpID , DeptID , EmpName)
View 3 Replies
Jan 8, 2010
I have several dropdownlists which are databound to a SQL DB but I am also needing to add 2 items to them. I am using the code below.
With the code in the Calendar1_SelectionChanged sub (Which is when I want it to fire) It loads the data from the sql but not the static content
If I move the code to the Page_Load sub and add "If Page.IsPostBack Then" then it loads the static content but not the SQL.
[Code]....
View 5 Replies
Oct 27, 2010
i am a new user of asp.net and i am a learner so i just want to connect two dropdownlist to data souce and i want that the list item of second dropdown is changed according to change of selected item of first dropdown.
i have connect it to data source successfully it getting chaged items but it happance only when its load then if i select the next item of first one it would not work properly.
View 3 Replies
Jun 2, 2010
I have confusion, how can i retrieve value from database and show it in dropdownlist because valuse is store in various field with some are blank means null value, I want to display only fields with some have data . i am doing like this but what to mention in "valuefield and textfield" and how to implement.
con.Open();
OleDbCommand cmd1 = new OleDbCommand("select Restaurant,Parking,Facilities_for_Disabled,Room_Service,Bar_Pub,Fitness_Center_Gym,Swimming_Pool,Spa,Conferen
[code]...
View 3 Replies
Jun 3, 2010
I want to retrieve data from various column,which may some have blank value, so my problem is i want to retrieve only filled column(not any blank column) from multiple column.. I am doing this (given below) but it didn't return anything...
Column Name Value
Restaurant Restaurant
Spa Spa
Parking
Bar_Pub
Fitness_Center_Gym Fitness_Center_Gym
OleDbCommand cmd1 = new OleDbCommand("select nID Restaurant+''+Spa+''+Parking+''+Bar_Pub+''+Fitness_Center_Gym AS Facility from add_property where ncity='" + DropDownList1.SelectedItem.Text + "'", con);
DropDownList2.DataValueField = "nID";
DropDownList2.DataTextField = "Facility";
DropDownList2.DataBind();
con.Close();
--------------------------------------
View 9 Replies
Jan 7, 2014
I have a gridview on which i have kept some search criteria and when i search something and edit it the page refreshes and edit is start from record 1
I am editing directly in gridview ....
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
