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]....
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.
I have two tables. t1 and t2
t1 is related to t2 through Order Numbers
these order numbers in table t2 have many part numbers(and hence the need for a second table t2)
I can display t1 using gridview just fine
In that same gridview iI have added a template column containing a dropdownlist(to show partnumbers)
now how can I bind this dropdownlist to the order number so that when the page is loaded the user can click on the dropdownlist to see all the partnumbers associated with that order number.
Two ddl inside gridview. on selecting first ddl1 fill next ddl2 by passing selected value as parameter by executing the sqldatasource select command in codebehind.code:
GridViewRow gr = (GridViewRow)((DataControlFieldCell)((DropDownList)sender).Parent).Parent; //find the control in that DropDownList d1 = (DropDownList)gr.FindControl(ddl1); DropDownList d2 = (DropDownList)gr.FindControl(ddl2); SqliaDataSource.SelectParameters.Add("@name", d1.SelectedItem.Text.ToString()); dataView dv=(dataview) SqliaDataSource.select(DataSourceSelectArguments .Empty);
Error: There is no source code available for the current location. and Returns null value
I have a datasource (quite heavy to run) and a Gridview on the page.
By default when the page is loaded the datasource and Gridview bind and display. However since the datasource is heavy I want on page load these 2 will not bind.
I want them to bind only on a button click. How to stop the datasource and Gridview from binding on 1st page load ?
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'."
I m new in asp.net. I want to use gridview with a custom business object.
Should i have property in my custom object.is there a way to access object fields.
i hav a gridview ... now i need to add certain number of rows... say 5 rows .... which would b blank .. the rows consist of itemtemplate of textboxes.. here is the grid ...
[Code]....
now i am binding this gridview with certain data say :
[Code]....
now the problem is if the row contains 2 data originally ... then it alwz shows up with only two rows with binded data... but what i want is 2 (databinded rows ) + 5 (empty rows with textbox ) = 7 grid view rows .... now how to do it ... after i hav binded the textbox with data already....with some empty columns corresponding to the above code ?
i have two tables in my database, product(productid as pk) and productdetails(productid as fk), in a relationship.i have dropdownlist which on pageload displays data from my product table, showing all product name. AutoPostBack enabled. Its working fine.i have a gridview which should display the productdetails data when i select a value from my dropdown list.i have written the code for the gridview on the selected_index_change event of the drop down list, please correct me this is wrong;here is the code;
Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles
DropDownList1.SelectedIndexChanged
Dim ConString As String [code]...
so when i select the value in the dropdownlist i get this error .Must declare the scalar variable "@ProductID".
I have few textboxes and I want to search the text (partial search is also required) in the database and then show the result in a telerik grid. The grid has to be hidden initially and when I click the search button it should show up and display the results.
View 2 RepliesI 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]....
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]....
private void AddDBDataToControl(DataSet app_Support,int count) {
int i = 0; while (count != 0) {
DateTime dt = Convert.ToDateTime(app_Support.Tables[0].Rows[i]["FromDate"].ToString());
//dt=23/08/2010 10:04:00 AM
DropDownList h1 = (DropDownList)GVDate.Rows[i].Cells[1].FindControl("txthour");
h1.SelectedValue = dt.Hour.ToString();
DropDownList m1 = (DropDownList)GVDate.Rows[i].Cells[2].FindControl("txtmin");
m1.SelectedValue = dt.Minute.ToString();
DropDownList h2 = (DropDownList)GVDate.Rows[i].Cells[5].FindControl("txthourto");
DateTime dt2 = Convert.ToDateTime(app_Support.Tables[0].Rows[i]["ToDate"].ToString());
//dt2=28/08/2010 14:25:00 PM
h2.SelectedValue = dt2.Hour.ToString();
DropDownList m2 = (DropDownList)GVDate.Rows[i].Cells[6].FindControl("txtminto");
m2.SelectedValue = dt2.Minute.ToString();
count--; i++; } }
When the function executes
h1.SelectedValue = "10";
and
m1.SelectedValue ="04";
but when it reaches to
count--
h1.SelectedValue takes the value "14"; rather than h1.SelectedValue = "10"; and
h2.SelectedValue = "14";
and
m1.SelectedValue ="25"; rather than m1.SelectedValue ="04"; and
m2.SelectedValue = "25"
[Code]....
My Default Page
[Code]....
when it goes to databind it gives me error asDropDownList1 do not contain binding with ID
I have an array in my code behind page. say:
int[] Hour = new int[24];
I also have a dropdownlist on my aspx page. say:
<asp:dropdownlist id="ddlHour" runat="server">
I want to bind the value of array to the dropdownlist such that when I dropdown the list, I get to see the values from 0 to 24.
I have a gridview where I can browse an user's information. Through the gridview I'm also able to edit some of this information. A recent change in my client's needs demands that one of these fields is now a DropDownList. This field represents a user's "schedule" (not literally a schedule but works like one), and the different schedule options to be assigned to a user are shown in the drop down list.
Problem: In the drop down list I want to show list items like "9-12 15-17", "10-14 15-18" so that it is easy for the administrator to tell which schedule he's assigning to an user. However, that shouldn't be their actual value. I need "9-12 15-17" to actually be '1' since this is the schedule ID that I'm trying to pass on to the DB.
Here's what I have so far:
[Code]....
And with this last method I change the selected item's value to the Index. Meaning that if I select "9-12 15-17" which has an Index of 1 in the dropDownList, the actual value is now 1. Again, this is the behavior I expect. My experience with ASP is quite little as I'm new on this, but as far as I know, this only actually updates the string array. How would I go about modifying this to reflect my updates on the database? All input is taken into account.
I'm having trouble binding my textbox to my dropdownlist. I got it to work but I don't think it is the correct way of doing it. I have my DDL bound to a datasource and populating everything correctly. However, I couldn't find a better way of binding my textbox to it besides using the FormView control and its counterpart, Templates (edit,insert,etc) It looks messy and i was hoping there was a better way of doing it. I've researched it online for awhile now but I couldn't understand how to implement for my situation.
My DDL has company names in it and the datasource has all the information from the table including what I'm trying to have my textbox pull (Address).
I'm trying to bind a value to a dropdownlist. Here how the code looks like in the aspx page...Bind the textboxes below is not a problem...but its not working with the dropdownlist..
So basically, what i want is the value selected from the dropdownlist to be remembered after i press next button and back button..
[Code]....
Scenario:
I am creating a custom gridview control which has a custom CheckBoxTemplateField column (deriving from TemplateField class). This template field column has custom Checkboxheadertemplate (implementing ITemplate) and CheckboxItemTemplate (also implementing ITemplate). In InstantiateIn method of both templates (header as well as Item template), I am adding a checkbox control which has Autopostback = true.
My requirement is:
I want to mark all the values in the binding column of datasource if checkbox in headertemplate is checked. I dont want to mark only rows visible on grid. I WANT TO MARK ALL ROWS IN DATASOURCE. I want to do this in _CheckedChanged event of checkbox in header template.
Problem I am facing: When I check/uncheck the checkbox in header, it postbacks. so in OnCheckedChanged event, gridview's datasource is null. Secondly, in any event of gridview, I could access only those rows of datasource for which corresponding rows are visible in gridview through Gridviewrow.DataItem property. But I want to set it for all rows in datasource.
How do I bind a DropDownList inside a DeatilsView?
I have something like that... but I'm unable to bind it.
[Code]....
I select a item from gridView and trying to show/update/delete in From view. In Form View I am using the dropdownlist filling it in Code behind. Then i bound the list. But the problem is it is not showing the slected value. Here is the code
asp code <asp:GridView ID="grdVRegion" runat="server" AllowPaging="True"
AutoGenerateColumns="False"
Width="525px" PageSize="20" DataKeyNames="intPKCountry_DetailID" [code]....
Plz go through my code-
<asp:ScriptManager runat="server"/>
<cc1:ModalPopupExtender ID="mpe_AddState" runat="server" PopupControlID="PanelAddState" TargetControlID="btnAddNew" BackgroundCssClass="ModalPopupBG" OkControlID="btnOk"
CancelControlID="btnCancel" BehaviorID="ModelPopUp_AddState">
</cc1:ModalPopupExtender>
<!-- Begin of Content table -->
<table width="100%" border="0" cellspacing="2" cellpadding="2" align="left">
<tr> <td>
<!-- Begin of Search Country Panel -->
<asp:Panel runat="server" DefaultButton="btnSearch">
<table border="0" cellspacing="3" cellpadding="3" align="left">
<tr> <td width="15%" >Search</td> <td width="30%">
<asp:TextBox runat="server" CssClass="textBox" ></asp:TextBox>
<asp:RequiredFieldValidator ID="rfv_txtSearch" runat="server" ErrorMessage="Field can't be left Blank" SetFocusOnError="true" ControlToValidate="txtSearch" Display="None" ValidationGroup="search"> </asp:RequiredFieldValidator>
<cc1:ValidatorCalloutExtender runat="server" TargetControlID="rfv_txtSearch">
</cc1:ValidatorCalloutExtender> </td> <td width="25%">
<asp:Button runat="server" Text="Search" ValidationGroup="search" />
</td> </tr> <tr> <td width="15%">Country</td> <td width="30%">
<asp:DropDownList id="ddlCountry" runat="server" AutoPostBack="true" Height="30px" Width="76px">
</asp:DropDownList> </td> <td width="15 %">
<asp:Button runat="server" Text="AddNew" /> </td>
<td width="25%"></td> </tr> <tr> <td> </td> </tr>
</table> </asp:Panel>
<!-- End of Search Country Panel -->
<!-- Begin of Add State Panel -->
<asp:Panel runat="server" CssClass="formTextBold"
style="width:390px; height:500px; cursor: move;" Height="278px" Width="335px">
<div> <table border="0" > <tr><td></td></tr> <tr bgcolor="skyblue">
<td colspan ="3" style ="font-weight :bold "> Enter The State Details
</td> <td align ="center"><a href="#" onclick ="HidePopup();">
<font color="red" size="+1">X</font> </a> </td> </tr> <tr> <td> </td> </tr> <tr>
<td> </td> <td> State Code </td> <td>
<asp:TextBox id="txtStateCode" runat="server"></asp:TextBox>
</td> </tr> <tr> <td> </td> <td >State Name</td> <td>
<asp:TextBox id="txtStateName" runat="server"></asp:TextBox>
</td> </tr> <tr> <td> </td> </tr>
<tr> <td> </td> </tr> <tr> <td> </td>
<td >Country Name</td> <td>
<asp:DropDownList id="ddlSelectCountry" runat="server">
</asp:DropDownList></td> <tr> <td> </td> </tr>
<tr> <td> </td> </tr> <tr>
<td width="28%" colspan="2"></td> <td >
<asp:Button runat="server" Text="Ok" Width="50px" />
<asp:Button runat="server" Text="Cancel" /> </td>
</tr> </tr> </table> </div> </asp:Panel>
<!-- End of Add Country Panel -->
.cs code is-
protected void Page_Load(object sender, EventArgs e) {
if(!IsPostBack) {
ddlSelectCountry.DataSource = Obj_BLogic.Country_List();
ddlSelectCountry.DataTextField = "Country_Name";
ddlSelectCountry.DataValueField = "Country_Id";
ddlSelectCountry.DataBind(); }
ddlCountry.DataSource = Obj_BLogic.Country_List();
ddlCountry.DataTextField = "Country_Name";
ddlCountry.DataValueField = "Country_Id"; ddlCountry.DataBind();
ddlCountry.Items.Insert(0, new ListItem("Select"));
grdState.Columns[0].Visible = false; }
I want list of countries exactly once in both the dropdownlist (ddlCountry & ddlSelectCountry). But is giving the list of countries twice.
I have a gridview that displays query results on a reporting page for a "home-grown" CRM application. From the gridview, a link can be clicked which opens a modal window that contains an iframe linked to a "details" page where record specific info can be viewed/altered. On the details page there are 10 or so dropdownlists (ddls) that are bound every time the page is called. The ddls are bound using a method similar to the example below. I am looking for a way top speed things up a bit. The details page could be called 10-20 times in one session and every time the page loads these ddls have to be bound from the same methods but for different records. What are some options for speeding up the load time for this page??
[Code]....
[Code]....
I am having problem to do a 2 way binding with DropDownList inside DetailsView, my markup declaration is:
[Code]....
But I am getting the following error messages on the line ddlCategoryId.DataBind(): ArgumentOutOfRangeException: 'ddlCategoryId' has a SelectedValue which is invalid because it does not exist in the list of items.sometimes I get different error: InvalidOperationException: Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control.]
<asp:TemplateField HeaderText="Location">
View 1 Replies