Web Forms :: Load 30k Record Dropdownlist?
Jan 25, 2010
I know this sounds like a dumb requirement but the company I work for needs to be able to load a rather large list of employees. I am using a listview to select the FK_ID of the employee and then display their name. Once the user clicks edit, I then allow them to select the list by using a Button and load the user control of the massive dropdownlist. The problem is that it lags the program really bad. I will show code soon. Is there an easier way to achieve a fast loading page with large volume controls?
View 5 Replies
Similar Messages:
Mar 12, 2010
I have a dropdownlist bound to a table and the selection filters the detailsview. After a new record is inserted using the detailsview, the new record is displayed in the detailsview and the initial record is displayed in the dropdownlist. After the insert, how can I get the dropdownlist to display the new record?
View 4 Replies
Jun 29, 2010
I have a dynamic dropdown that is populated from sql. The user is supposed to select an option from the dropdown, then click a search button on the form to return some results based on that selection. It works fine if the dropdown gets populated with more than one record. However, if only one record is returned, that one record can't be selected. Whether you select it or just leave it alone since it's the only one, when you click the form button (search button), no results are returned b/c the dropdown selection must not be actually selected.
I've included the relevant code below. First the DDL, then the datasource, and finally the C# code in the if (!Page.IsPostBack)
[Code]....
View 14 Replies
Mar 12, 2011
A few questions regarding detailsview and gridview:
1) when page load, how can I default the detailsview to show the first record from the gridview? SelectedIndex does not have any effect to my detailsview.
[Code]....
2) how can I select a record in the gridview if my table has 2 key fields using below syntax?
[Code]....
View 2 Replies
Aug 25, 2010
its possible to use a DropDownList within the PagerTemplate to navigate to a specific record? I have been able to place the DropDownList outside of the FormView and PagerTemplate and make it work, however, I can't get it to work inside the PagerTemplate.
View 2 Replies
Oct 26, 2010
how to get the default value from a dropdownlist when the form load.
View 13 Replies
Jan 23, 2011
i want when pages load the gridview displays the all records from table1 and also ...i i wanna search record for firstname by typing sumit in textbox1 and click on button1 then in gridview the record of sumit will be shown ..by default gridview display alll records from table1
SELECT a1_admins.EmployeeId, a1_admins.Firstname, a1_admins.Lastname, a1_admins.Email
, a1_admins.City, a1_admins.State, a1_admins.Country, aspnet_Membership.LastLoginDate
, aspnet_Membership.CreateDate, a1_admins.Password, a1_admins.pan_no, a1_admins.Contactno
, a1_admins.Address
FROM a1_admins
INNER JOIN aspnet_Membership
ON a1_admins.UserId = aspnet_Membership.UserId
WHERE (a1_admins.EmployeeId LIKE N'%' + @EmployeeId + N'%')
[code]...
View 1 Replies
Feb 4, 2012
I have a drop down box , it has value that is retrieve from datasqlsource, however i want to get the count value on page load but it seem that it did not count
'Dim adapter As New SqlDataAdapter
'Dim ds As New DataSet
'Dim connectionString = ConfigurationManager.ConnectionStrings("myProject").ConnectionString
'Dim myConn As New SqlConnection(connectionString)
[Code] ....
View 1 Replies
Jun 14, 2012
I need to load xml from following [URL] .... and bind that xml contents to dropdownlist .... How can i do that ....
View 1 Replies
Sep 20, 2010
I have a dropdownlist that is populated with a staffID number depending on the staff members name that is selected from a second dropdownlist. The value from this dropdownlist is then inserted into a new record when the page is submit using the InsertQuery of an sqlDataSource.
View 2 Replies
Mar 21, 2012
I'm trying to put together a drop down list in asp.net from a query, I just wondered if I could go about it this way ( see code below). At the moment, ive got it to display the first record of the table in the drop down list. I would like to fill the drop down list with the whole of the recordset:
Code:
<%
Dim cnnSimple ' ADO connection
Dim rstSimple ' ADO recordset
Set cnnSimple = Server.CreateObject("ADODB.Connection")
[code]....
Do you think I could put a loop inside the option value = i bit?
View 1 Replies
Oct 11, 2010
I have a webForm which host a gridview and a formview. The formview is used for showing/editing a record which the user Select from the gridview.
In the formview Edit template I used DropDownList controls with
SelectedValue='<% bind("datafield")%>'
for enabling the user easier interface. A few of the DropDownList controls need to have a list of 100 items and I want to load the items from code behind and not from the aspx.
I tried to update the DDL's from FormView.Load, FormView.ModeChanging, FormView.PreRender but
nothing I am getting an error like this:
[code]....
How do I load the DropDownList controls with items BEFORE the form databinding occurs.
View 2 Replies
Jan 29, 2011
I have no problem when paging my FormView, the dropdownlist does not read the next record and keep the value of the first loaded record? All other textbox control behave normally and move from record to record excepted the ddl??Here the code.
Public Sub DoData()
Dim myConn As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("LocalSqlServer").ConnectionString)
Dim myCommand As SqlCommand = New SqlCommand("SelectSupplier", myConn)
myCommand.CommandText = "SelectSupplier"
[Code]....
View 3 Replies
Sep 19, 2010
I want to have a dropdownlist in the footer row of a gridview. The dropdownlist must be populated with an stored procedure that receives a parameter and has a select. Is that posible?? I think yes but I having problems with the parameters.
[Code]....
The exception says incorrect sintax... but I've changed the procedure for something very simple to solve the problem like select 'hello' or select 1, 'hello' and I'm getting the same problem...
View 3 Replies
Oct 26, 2012
How to display value in another textbox after selecting from dropdownlist menu..
For Example
If i select Ecode(Employee Code) from drop down list it should automatically diplay his Firstname/LastName/Age etc to the textbox specified.
View 1 Replies
May 7, 2015
I my website i have 2 dopdownlost i want when i change the value of one.. The other one loads data depending on the first one value
the both of the dropdownlists is in ajax update panal and i do have script manager
i used this code but not working
protected void floor_ddl0_SelectedIndexChanged(object sender, EventArgs e)
{
floor_ddl1.DataBind();
}
View 1 Replies
Oct 14, 2010
I'm not sure how to load a dropdownlist for the HTML.DropDrownList.
In controller:
List<SelectListItem> _itemList = new List<SelectListItem>();
SelectListItem _item = new SelectListItem();
_item.Text = "First"; [code]....
Results :my dropdown displays "System.Web.Mvc.SelectListItem" ...where I'm expecting the "First" (the _item.Text).
View 5 Replies
Mar 12, 2010
I have a UserControl, containing a FormView, containing a DropDownList. The FormView is bound to a data control. Like so:
<asp:FormView ID="frmEdit" DataKeyNames="MetricCode" runat="server"
DefaultMode="Edit" DataSourceID="llbDataSource" Cellpadding="0" >
<EditItemTemplate>
<asp:DropDownList ID="ParentMetricCode" runat="server" SelectedValue='<%# Bind("ParentMetricCode") %>' />
I am trying to populate the DropDownList from the codebehind. If this was not contained in a FormView, I would normally just do it in the Page_Load event. However, that does not work within a FormView, as as soon as I try to do it, accessing the dropdownlist in code, ie: theListcontrol = CType(formView.FindControl(listControlName), System.Web.UI.WebControls.ListControl)
the data binding mechansim of the FormView is invoked, which, of course, tries to bind the DropDownList to the underlying datasource, causing a *'ParentMetricCode' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value * error, since the DropDownList has not yet been populated. I tried performing the load in the DataBinding() event of the FormView, but then:
theListcontrol = CType(formView.FindControl(listControlName), System.Web.UI.WebControls.ListControl) fails, as the FormView.Controls.Count = 0 at that point. Is this impossible? (I do not want to have to use a secondary ObjectDataSource to bind the dropdownlist to)
View 2 Replies
Jan 21, 2011
Assuming i have two dropdownlists namely: dropdownlistA and dropdownlistB. at page load, i bind values to dropdownlistA. however, depending on the value selected or displayed in dropdownlistA, i want to bind data to dropdownlistB.
Currently, i can bind data to dropdownlistA alright and i already have the required dataset and datatable bind data to dropdownlist. However, dropdownlistB does not bind at page load since the criteria for filling the dataset to bind dropdownlistB (which is the value of dropdownlistA) is not selected. how can i make this wwork.
I am currently considered if this might work. If i were to call the databind for dropdownlistA in a different declared method besides its binding in page load, and select the value from bind in the declared method, would any value be selected?
For example:
In during page load, i call the a method that returns dataset values which i bind to dropdownlistA(caseIDDropDownList). then i call another method (CreateexhibitDataSet()) which contains the dataset values for binding dropdownlistB(exhibitDropDownList). however, i need to define a criteria in the CreateExhibitDataset() method which i will use to generate the dataset values to bind dropdownlistB. if i were to call for the data bind of dropdownlistA(caseIDDropdownList) again in the CreateExhibitDataset() method and pick the value in the dropdown list, would i get any values?
How can i work around this to bind both dropdownlists on page load?
[Code]....
View 4 Replies
Jul 22, 2010
I posted a similar question previously, but none of the answers worked and I've been scouring all over the web trying to find a solution. My situation, I have a Edit Window webform with a dropdownlist (Note: to avoid confusion, I'm using Telerik extensions only to decorate the webform):
<%@ Page Language="VB" CodeFile="EditFormVB.aspx.vb" Inherits="EditFormVB" %>
<%@ Register Namespace="CustomBoundField" TagPrefix="custom" %>
<!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>Edit Pop-up</title>
</head>
<body class="">
<form id="form1" runat="server">
<div>
<script type="text/javascript">
function CloseAndRebind(args) {
GetRadWindow().BrowserWindow.refreshGrid(args);
GetRadWindow().close();
}
function GetRadWindow() {
var oWindow = null;
if (window.radWindow) oWindow = window.radWindow; //Will work in Moz in all cases, including clasic dialog
else if (window.frameElement.radWindow) oWindow = window.frameElement.radWindow; //IE (and Moz as well)
return oWindow;
}
function CancelEdit() {
GetRadWindow().close();
}
</script>
<asp:ScriptManager ID="ScriptManager2" runat="server" />
<telerik:RadFormDecorator ID="RadFormDecorator1" runat="server" Skin="Vista" DecoratedControls="All" />
<br />
<br />
<asp:DetailsView ID="DetailsView1" DataKeyNames="ID" runat="server" AutoGenerateRows="False"
GridLines="None" DataSourceID="detailsSqlDataSource" Height="50px" Width="125px"
BorderWidth="0" CellPadding="0" CellSpacing="7">
<Fields>
<asp:BoundField DataField="TS_DESCRIPTION" HeaderText="TS_DESCRIPTION" SortExpression="TS_DESCRIPTION" />
<asp:BoundField DataField="TS_TITLE" HeaderText="TS_TITLE" SortExpression="TS_TITLE" />
<asp:CommandField ShowEditButton="True" />
<asp:CommandField ShowInsertButton="True" />
</Fields>
</asp:DetailsView>--%>
<telerik:RadScriptManager ID="RadScriptManager1" runat="server" />
<telerik:RadFormDecorator ID="RadFormDecorator1" runat="server" Skin="Vista" />
<br />
<br />
<asp:DetailsView ID="DetailsView1" runat="server" Height="400px" Width="745px"
AutoGenerateRows="False" DataKeyNames="TS_ID" DataSourceID="SqlDataSource2"
EnableModelValidation="True">
<Fields>
<asp:TemplateField HeaderText="Category">
<EditItemTemplate>
<%--<asp:DropDownList ID="TTCategory" runat="server" DataSourceID="ReqCategoryData" SelectedValue='<%# Bind("TS_NAME") %>' />--%>
<asp:DropDownList DataSourceID="ReqCategoryData" DataTextField="ReqCategory" DataValueField="ReqCategory"
ID="reqCategoryDropDown" runat="server" AppendDataBoundItems="true" AutoPostBack="true" >
</asp:DropDownList>
</EditItemTemplate>
</asp:TemplateField>
<asp:CommandField ButtonType="Button" EditText="Update" ShowEditButton="True"
ShowCancelButton="True">
<ItemStyle HorizontalAlign="Center" />
</asp:CommandField>
</Fields>
</asp:DetailsView>
</div>
</form>
</body>
</html>
And in the code behind, I'm setting the datasource for the dropdownlist and using a function to query the DB for the name of the value I want to set as the selected value when the page loads initially: Partial Class EditFormVB Inherits System.Web.UI.Page
Public Shared category_Name As String = ""
Dim ddlDataSource As New SqlDataSource
Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init
DetailsView1.DefaultMode = DetailsViewMode.Edit
End Sub
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Me.Page.Title = "Editing record"
''Setup DropDownList SqlDataSource
ddlDataSource.ID = "ReqCategoryData"
Page.Controls.Add(ddlDataSource)
ddlDataSource.ConnectionString = ConfigurationManager.ConnectionStrings("TTPRODReportsQuery").ConnectionString
ddlDataSource.SelectCommand = "SELECT TS_NAME AS ReqCategory FROM dbo.TS_SELECTIONS WHERE (TS_FLDID = 5299 AND TS_STATUS = 0) ORDER BY TS_NAME"
Dim args As New DataSourceSelectArguments
ddlDataSource.Select(args)
''Set max length of Title field to 70 characters
Dim dvrTest As DetailsViewRowCollection = DetailsView1.Rows
Dim TitleTB As TextBox = dvrTest.Item(0).Cells(1).Controls(0)
TitleTB.Attributes.Add("onkeydown", "isMaxLen(this)")
TitleTB.Attributes.Add("maxlength", "70")
Dim myDDL As DropDownList = DetailsView1.FindControl("reqCategoryDropDown")
''Perform dropdown list population operations
If Page.IsPostBack = False Then
Dim ticket_ID As String = getDataKey(DetailsView1)
''Fetch Category ID
Dim sqlText As String = "SELECT TS_REQCATEGORY FROM USR_ITFAC WHERE (TS_ID = " + ticket_ID + ") "
Dim reqDataReader As SqlDataReader = GetDataReader(sqlText)
reqDataReader.Read()
Dim category_ID As String = reqDataReader(0)
''Fetch Category name using the categoryID and set as selected value in dropdown list
sqlText = "SELECT TS_NAME FROM TS_SELECTIONS WHERE (TS_ID = " + category_ID + ") "
reqDataReader = GetDataReader(sqlText)
reqDataReader.Read()
category_Name = reqDataReader(0)
myDDL.DataBind()
myDDL.Selectedvalue = category_Name //<--this value gets set only when debugging,
End If
End Sub
Private Function GetDataReader(ByVal sqlText As String) As SqlDataReader
Dim dr As SqlDataReader
Dim sqlConn As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("TTPRODReportsQuery").ConnectionString)
sqlConn.Open()
Dim sqlCmd As SqlCommand = New SqlCommand(sqlText, sqlConn)
dr = sqlCmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
Return dr
End Function
End Class
The dropdownlist does get populated appropriately, however when I attempt to set the value, it doesn't reflect when the page loads; the dropdownlist just gets populated and no value is set to selected in the markup, so the first value is shown by default. The odd thing is that when I'm debugging, the value appears to get set when I step through the function, it's as if the selectedvalue is getting reset as soon as the function exits and proceeds to load the page.
SOLUTION: Had to add a separate function that is called onLoad from the DropDownList after the after Page_Load is done executing. Still unresolved is why the the DropDownList rebinds after the Page_Load.
IN HTML:
<asp:DropDownList DataSourceID="ReqCategoryData" DataTextField="ReqCategory" DataValueField="ReqCategory"
ID="reqCategoryDropDown" runat="server" AutoPostBack="true" OnLoad="DDL_DataBound">
IN CODE-BEHIND
Public Shared category_Name As String = ""
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Me.Page.Title = "Editing record"
''Setup DropDownList SqlDataSource
ddlDataSource.ID = "ReqCategoryData"
Page.Controls.Add(ddlDataSource)
ddlDataSource.ConnectionString = ConfigurationManager.ConnectionStrings("TTPRODReportsQuery").ConnectionString
ddlDataSource.SelectCommand = "SELECT TS_NAME AS ReqCategory FROM dbo.TS_SELECTIONS WHERE (TS_FLDID = 5299 AND TS_STATUS = 0) ORDER BY TS_NAME"
Dim args As New DataSourceSelectArguments
ddlDataSource.Select(args)
''Set max length of Title field to 70 characters
Dim dvrTest As DetailsViewRowCollection = DetailsView1.Rows
Dim TitleTB As TextBox = dvrTest.Item(0).Cells(1).Controls(0)
TitleTB.Attributes.Add("onkeydown", "isMaxLen(this)")
TitleTB.Attributes.Add("maxlength", "70")
Dim myDDL As DropDownList = DetailsView1.FindControl("reqCategoryDropDown")
''Perform dropdown list population operations
If Page.IsPostBack = False Then
Dim ticket_ID As String = getDataKey(DetailsView1)
''Fetch Category ID
Dim sqlText As String = "SELECT TS_REQCATEGORY FROM USR_ITFAC WHERE (TS_ID = " + ticket_ID + ") "
Dim reqDataReader As SqlDataReader = GetDataReader(sqlText)
reqDataReader.Read()
Dim category_ID As String = reqDataReader(0)
''Fetch Category name using the categoryID and set as selected value in dropdown list
sqlText = "SELECT TS_NAME FROM TS_SELECTIONS WHERE (TS_ID = " + category_ID + ") "
reqDataReader = GetDataReader(sqlText)
reqDataReader.Read()
category_Name = reqDataReader(0)
myDDL.DataBind()
End If
End Sub
Protected Sub DDL_DataBound(ByVal sender As Object, ByVal e As System.EventArgs)
If Page.IsPostBack = False Then
Dim myDDL As DropDownList = DetailsView1.FindControl("reqCategoryDropDown")
myDDL.Items.FindByValue(category_Name).Selected = True
End If
End Sub
View 1 Replies
Sep 29, 2010
I can't get the following to set on page load. I want the month selected be the current month, on page load. What needs to change here?
[Code]....
View 6 Replies
Aug 20, 2010
first i'll describe my problem:
I have payment form with a clients dropdownlist that is populated from a database on form load with:
value field = clientIdtext field = nameId
<asp:DropDownList ID="selClients" runat="server">
</asp:DropDownList>
When user makes a payment, it's necessary to chose a client from selClients, and so i get the clientsId value and build my insert SQL query.
Until here, no problems.
The problem with my UI has started since i had a lot of clients been registered: My dropdownlist became huge and it's taking too much time to load it's contents on page load. Also the dropdownlist area is taking a large area from page screen.
So i tryied a solution with jquery autocomplete plug in. I put a textbox with autocomplete for client name and another hiddenfield to receive the clientId when user select a item.
That solves both problems:
No more large amout of data loaded on page loadThe dropdownlist doesn't take a large area from page screen
But it gave me another problem!
With a textbox, there is a possibility for wrong input client name. So if i don't have a valid clientId in hiddenfield, it will generate a database INSERT exception because it doesn't respect the client table constraint:
payment table REFERS client table
I'm trying to find kind of dropdownlist where the user can type text with autocomplete. Like this, the user will be able to select only data within the possibilities of the dropdownlist and i always will have a valid clientId.
View 3 Replies
Feb 9, 2010
I am trying to load all the roles into my dropdownlist but I keep getting an error saying IDatasource is not listed, I have the following code:
Roles.datasource = Roles.GetAllRoles()
Roles.databind()
What Else do I have to do?
View 3 Replies
Nov 16, 2010
I am using paging to my gridview (pagesize=4) . now i am in (X) page and i want to get (X+1) page top record or (X-1)page bottom record , how i can get .
View 2 Replies
Mar 21, 2011
I have a delete button bellow my gridview and I want a pop up to show when no record is selected and tell the user to first select a record. The button click event would show the pop up, but my gridview data blanks out.
Here is my code:
[Code]....
View 1 Replies
