i am created a user control(.ascx)
<span><asp:DropDownList ID="Drop_DocType" runat="server" DataTextField="DOCTYPE"DataValueField="DOCTYPE"/></span>
how to fill it rom database and where i put soure code
how to create dropdownlist user control(acsx) and fill from database
View 2 RepliesI have a database where a user inputs data to multiple databound drop down listboxes. That's saved to my aspnet database. Then when the page loads again, I want to select the ddls items that the user selected as stored in the database to these databound ddls. But it doesn't work, because on pageload, they haven't been databound yet.
What's the best way to do this? Do I need to run a SELECT statement for each and every ddl on it's databound event?
I wish to fill a dropdown list with data from a database table.
The table has ID column and a Text column.
I want the dropdown to display the Text column and return the corresponding ID.
What control do I use? What methods can I use to retrieve the data and fill the dropdown.
I am making a login page in asp.net. when am trying to fill the data into the database it can give the error..."Incorrect syntax near 'Password'." my code is
SqlConnection sqlConnection = new SqlConnection("Data Source = DELLVOSTRO; Initial Catalog = ALPHA; User Id= sa; Password= intransit");
string queryString = ("INSERT INTO LOGIN(User_Id, Password, Confirm Password, E_Mail, Security_Question, Security_Answer) VALUES ('" + CreateUserWizard1.UserName + "','" + CreateUserWizard1.Password + "','" + CreateUserWizard1.ConfirmPassword + "','"
+ CreateUserWizard1.RequireEmail + "','" + CreateUserWizard1.Question + "','" + CreateUserWizard1.Answer + "')");
sqlConnection.Open();
SqlCommand cmd = new SqlCommand(queryString, sqlConnection);
cmd.ExecuteNonQuery();
On my website, registered users can make a profile about themselves suchas name, Favoirite color, hobbies, etcI have a DataTable called User which hold this information.also there are other datatables for Hobbies and Colors which list all possible options.To let the user update their choices I have a FormView in Edit mode on the aspx page whichis binded to the UserTable with a GetProfileByUserId Method and objectdatasource.
Within the formview, i have added drop down lists that are binded to the hobbies and Colors tables so they can edit their previous selection.On clicking Uodate update formview calls an Update Method that adds new selections to the User databaseNow I have two questionsIs it possible to show in the dropdown list the selected value that the User has already made?If the user only changes hobbies and not colors when they click update will a null value be passed into the data table for colors that replaces their previous selection?
Populating CheckBoxList from a column of a table.
View 1 RepliesI have a page called main.apsx and on that page I have a multiview with a couple of view panes. In main.aspx I also have an have a buttons.ascx file with a few link buttons. When these buttons are clicked I want them to show the the selected view panels in multiview in main.aspx.
I cant seem to figure out where to put the action code for the link buttons. Do I put it into my buttons.ascx.cs file or into main.aspx.cs? I presume in buttons.ascx.cs, but if I do that, how will the buttons find the multiview control?
This is the code for on of my buttons in buttons.ascx.cs
[Code]....
When I run it like this is gives an error
The name 'MultiView1' does not exist in the current
The name 'View1' does not exist in the current
I have a dropdown list on my form which should filter out or display my tag cloud for an entire project or for a specific iteration. At the moment, I don't get any errors, but the ASCX control doesn't seem to update.
<asp:DropDownList ID="filteroptions" runat="server" onselectedindexchanged="filteroptions_SelectedIndexChanged" AutoPostBack="true"></asp:DropDownList>
<asp:UpdatePanel ID="UpdateIteration" runat="server">
<ContentTemplate>
[Code]....
I have .ascx web user control in my web site. Now I want to make dll for that .ascx file. let me know steps how can I make .dll file for that .ascx web user control.
View 2 RepliesI have menu list like this
and I want to fill it's Items from my SQL database, is that possible ?
I'm developing an ASP.NET application with C# and Ajax.I have a page that holds user controls loaded dynamically. I need to pass some data (integer values and some strings) to the user control that has been loaded dynamically.Now I use Session to pass these values, but I think I can use another way; something like VIEWSTATE or hidden input.What do you recommend me?The fact that I load the controls dynamically is important because controls are loaded on every postback, and I can't store any value on controls.
View 9 RepliesI'm new with programming. I have a GridView that have the specific user data. When the user log in I retrieve the data for that specific user. All I need is; How do I make the gridview get the data of the logged user using a datatable that has a query. Just bind it with the datatable.This is some code that other programmer made, I continue his work.
[Code]....
How to fill the value in drop down box according to value selected in another drop down box?
View 1 RepliesI have a form in aASP User Control (.ascx) file. Maxlength does not work for the multiline textboxe hence it is generated as a textarea, which has no support for this attribute. I could maybe use some asp validation, to prevent submission of too much text, but I want to prevent it to be possible to even enter too many characters, just like is possible for single line textboxes... I don't know if the control has any onload event that I could use to add attributes to the textbox from code behind and and combined with javascript fix this or anything..
View 1 RepliesI want to display the selected value from gridview in a dropdownlist.Here I am not getting the Dropdown from Database as it contains two values.After getting the data user can modify the DDL and change the selection.The data type where the values are saved is declared as Bit.
<asp:Label ID="lblQuery" CssClass="labelbold" runat="server" Text="Query"></asp:Label>
<asp:TextBox ID="txtQuery" runat="server"></asp:TextBox>
<asp:Label ID="lblStatus" CssClass="labelbold" runat="server" Text="Active Status"></asp:Label>
<asp:DropDownList ID="ddlStatus" runat="server">
<asp:ListItem>--Select--</asp:ListItem>
[code]....
Till here it works fine how do I fill the dropdown from database.Eg Active text is coming from Database,so DDL should show Active along with Inactive value.
Here's the source of a blank .acsx file I created called LogOnBox.
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="LogOnBox.ascx.cs" Inherits="ECommerce.Views.Shared.LogOnBox" %>
I want to drag some labels, and textboxes etc and give them style using a CSS file. How can I associate a CSS to an acsx file?
I'm trying to reference a string from the web.config file from a ASCX user control, but I get the error message: [b]Compiler Error Message: BC30203: Identifier expected.
My code in the user control file is as follows:
<div id="header">
<h1><%= Server.HtmlEncode(Convert.ToString(ConfigurationSettings.AppSettings["Web_Title"])) %></h1>
</div>
Do I need to import any namespaces?
I've got an ASP.NET 3.5 Web Forms application in which a large chunk of code needs to be duplicated between a few different pages. Sounds like the ideal candidate for a user-control right? Problem is, this cannot be contained within a <form runat="server"> because it contains a client-side form of it's own. There are no runat=server controls or postbacks or anything that really need that webform - think of it just as a chunk of HTML with a few basic <% %> tags. I'd just want to set a property on the control when it's loaded, so that it knows what to output. This is purely an exercise to make the code easier to maintain.Before I resort to using an oldskool <!--#include-->, is there some better way of doing this?
View 5 RepliesI am currently displaying the date via the Eval method in an ASCX file:
Code:
<%#Eval("BirthDate") %>
However this appears as mm/dd/yyyy when I would like it to appear as dd/mm/yyyy. Is there a global setting where I can change the default date format or is there another way to change it directly in the user control ASCX file?
I want to populate data from database and display it to dropdownlist.
View 3 RepliesI wrote a one aspx page that include 4 ascx pages.
Among of them, two ascx pages are have to share a integer value.
A page can count a value, and I want it to be a part of other ascx page.
These pages have no button of link and neither user events.
I am having difficulties how to construct my question, but if I have to put it simply the situation is that I have categories of products. I have an aspx with a repeater on the left that lists the categories. And I want the products to be listed on the right. Category number is variable so I made an ascx with a DataList in it. When I try to do foreach category, ascx = new ascx(); then the DataList within this ascx control is null.
ps: what I want to do is to preload all the products (thre is not much) and hide the divs and fadein fadeout them using jQuery when a category div is clicked.
rightnow it is using jQuery.load(); and I don't like how the images load, cuz they download from top to bottom. Progressive gifs alsdo not an option. site demo is here [URL]
I have a user control where is a textbox and button with PostBackUrl="two.aspx". This user control I have on a page one.aspx. When I click that button, on two.aspx I want to have access to the textbox from ascx control. PreviousPage.FindControl doesn't work. How to do that?
View 3 RepliesI have managed to place a dropdown control iniside a gridview control. The dropdown does indeed populate in each row... Question: How is it possible for the system to correctly select the text in the dropdown based on the value of the field which is driven from the database? Is it to do with the selectedvalue?
View 7 Replies