Forms Data Controls :: How To Load DropDown On The Basis Of UserProfile

Mar 4, 2010

I required to load dropdown with the section name on the basis of UserProfile when the page load anytime.

The dropdown is bounded by sqldatasource configured to TblSections.

TblSections with datafields sectionId(numeric) and Description.

There is another table Users with field sectionId and UProfile.

There is a gridview grvResult bounded by objecdatasource configured to TblFltReg.

TblFltReg has field Owner(numeric).

Actually Owner and SectionId are same.

I don't know how to do this task.

View 5 Replies


Similar Messages:

Forms Data Controls :: 1st Dropdown To Be Loaded On The Basis Of Selection Of 2nd Dropdown?

Oct 14, 2010

I have two dropdown linked with sqldatasources.When I select item in ddl1 then on the basis of selection ddl2 is being loaded.Is there any possiblity that if I select ddl2 then ddl1 will also load on the basis of selection?

View 3 Replies

Forms Data Controls :: How To Bind Dropdown On The Basis Of User Login (Session Variable)

Feb 16, 2010

I have dropdown and I have to bind that dropdown on the basis of user login so that when the page load the drop down should show only one item on the basis of user login and i may have use that dropdown item as a search parameter.I have a objectdatasource named TblFltReg having one of the fields named "Owner" which is the SectionId.

There is a table named TblSections having "SectionId" and "Description".User can be selected in a Session variable.I have another table "Users" having "UserName", "UProfile", "SectionId".Actually I dont know how can I get SectionId from Users table into Session variable.So I have two tasks: one to get SectionId into Session Variable and another is to show dropdown item on the basis of User login.Hope you understand.
How can I perform that task?

View 4 Replies

Forms Data Controls :: Populate Dropdown Items On The Basis Of Session ("UserLogin")?

Feb 26, 2010

I have a dropdown menu with too many items bounded by sqldatasource.

I want to show only those records which matches the Session("UserName) so that if user login to the webpage he may be able to see only those records that are related to him and further if he selects it then data should populate to gridview.

View 7 Replies

Forms Data Controls :: Load Values Into DropDown

Feb 1, 2011

I have two Dropdownlist on my webform(DDWO,DDLI) on Page_load I am retreiving WONumber values into DDWO when i select WONumber and click on Button corresponding values of selected WONumber will be loaded into DDLI but i dont want button here, instead when i select value in DDWO(WONumber) corresponding values of selected WOnumber should be loaded into DDLI.On which event i have to write insted of button to load values on select of DDWO value. Following code to retreive values to DDWO,DDLI

[Code]....

View 10 Replies

Forms Data Controls :: Load Dropdown With Null Value?

Sep 27, 2010

For insertion, I have dropdown inside a form.

The dropdown is linked with sqldatasource which is retreiving distinct records from table.

In table there is no NULL value.

What I want to do that when user will access Insert page to insert record then like all textboxes, dropdown should also load with NULL value.

View 9 Replies

Forms Data Controls :: How To Load The Dropdown List In The Gridview

May 18, 2010

i would like to know how to load the dropdown list in the Gridview edit with the dropdown list values from the database

View 3 Replies

Forms Data Controls :: Load Dropdown Menus On Runtime With Values?

Sep 29, 2010

I am designing my own Customize Calendar for my webproject.Using Calendar Control of asp.net2.0 I want to add three dropdowns at the top to collect Hour, Minutes and Seconds.What I required to load dropdown menus on runtime with values:

View 1 Replies

Forms Data Controls :: Dropdown Doesn't Load With The Relevant Data When Select A Value From The First

Jun 10, 2010

I am experimenting with 3 dropdowns bound to 3 different datasources. I want the contents in each dropdown depending on what is selected from the above dropdown and the datasource queries reflect this.

<asp:DropDownList ID="DropDownList_CostCentres" runat="server" Height="16px"
Width="138px" DataSourceID="CostCentreDataSource" DataTextField="CostCentre"
DataValueField="CostCentreID">
</asp:DropDownList>
<asp:SqlDataSource ID="CostCentreDataSource" runat="server"
ConnectionString="<%&#36; ConnectionStrings:corkABCConnectionString %>"
SelectCommand="SELECT [CostCentreID], [CostCentre] FROM [CostCentres]">
</asp:SqlDataSource>
<br />
<br />
<asp:Label ID="Label2" runat="server" Text="Manager:" Font-Bold="True"></asp:Label>
<br />
<asp:DropDownList ID="DropDownList_Managers" runat="server" Height="16px"
Width="138px" DataSourceID="ManagerDataSource" DataTextField="EmployeeName"
DataValueField="EmployeeID">
</asp:DropDownList>
<asp:SqlDataSource ID="ManagerDataSource" runat="server"
ConnectionString="<%&#36; ConnectionStrings:corkABCConnectionString %>"
SelectCommand="SELECT [EmployeeID], [EmployeeName] FROM [Employees] WHERE ([CostCentre] = @CostCentre)">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList_CostCentres" Name="CostCentre"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>

However, the second dropdown does not load with the relevant data when I select a value from the first dropdown (stays blank). Must I still provide an event handler and how do I combine this with the sqldatasource?

View 6 Replies

Forms Data Controls :: Load Data From Sql Server To A Dropdown List?

Dec 6, 2010

i want my dropdown list or my list box, load data from my database .i use visual studio 2008 and sql server 2005.

View 3 Replies

Forms Data Controls :: Load Values From Database To Dropdown Before AddQuotenumber Button?

Mar 11, 2010

I have Dropdown for Quotenumber(auto increment ).i have created a function to retreive the data from database.data loading into dropdown. when i click on Addquotenumer button the new quotenumber generated and same loading into dropdown but 2 set of Quotenumbers are displaying rather than singleset, i debudded the code the reason was i have called this function twice one is form load and another one in AddQuotenumber button event,both should manadetory as per my requirement. how can un load this dropdown before AddQuotenumber button

Function to retreive data to dropdown
Public Sub retriveDataToDropDown()
Try
Dim connectionString As String = "Database=fabdb;" & "Data Source=localhost;" & "User Id=root;Password=pacvision"
Dim query As String = "SELECT QuoteNumber FROM quotes"
Dim connection As New MySqlConnection(connectionString)
Dim da As New MySqlDataAdapter(query, connection)
Dim ds As New DataSet()
If da.Fill(ds) Then
DDQuote.DataSource = ds.Tables(0)
DDQuote.DataTextField = "QuoteNumber"
DDQuote.DataBind()
'DDQuote.Items.Insert(0, New ListItem("Select", "Default value"))
End If
connection.Close()
Catch ex As Exception
'Console.WriteLine(ex.Message)
End Try
End Sub
AddquoteNumber button code
Protected Sub btnAQ_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnAQ.Click
Dim connectionString As String = "Database=fabdb;" & "Data Source=localhost;" & "User Id=root;Password=pacvision"
Dim rowsEffected As Integer = 0
Dim Query As String = ""
Dim connection As New MySqlConnection(connectionString)
'Dim cmd As New MySqlCommand(Query, connection)
connection.Open()
Query = "insert into Quotes(query follows...................)
retriveDataToDropDown()
retriveDataToDataGrid()
connection.Close()
End Sub

View 8 Replies

Forms Data Controls :: Delete Row Per Row Basis In Grid View?

Oct 2, 2010

I found this code and tried to implement it in my project. But before running, I got few question. What I want to do is able to delete 1 row each time I click on a button or link.

1. Where is the firing event comes from?

2. Do I need to add a button or link each row (another column)?

3. How does the following code works?

[Code]....

View 2 Replies

Forms Data Controls :: Adding A DropdownList To A GridView On A Per Cell Basis

Apr 1, 2011

I am looking for a way to set certain cells in a GridView to have DropdownLists instead of the bound fields I currently use. I understand how people are able to do this on a whole column, but need to do this based on which cell it. Let me explain why. A fellow programmer who is as I am newer to ASP, built a GridView that only shows one record. This Record being the current ticket if you will. He builds a Data Table like this.

[Code]....

[Code]....

View 2 Replies

Web Forms :: Populating A Text Box With Data From DropDown List On Page Load?

Mar 9, 2011

I have a dropdown control that has a list of names in it called PlayerNameDropDownList_Insert and a textBox called PlayerName.

When I select a name from the dropdown it populates the textbox correctly.However, when the page opens the first name is selected in the dropdown but nothing in the textbox. How can I get the textbox to populate with the value of the dropdown at pageload?

[Code]....

View 4 Replies

Forms Data Controls :: Dropdown That Inserts Data Vis Procedure If The Gridview Doesn't Have Value For The Dropdown Selection

Sep 3, 2010

i have a dropdown with month names if the user has data for the month tht is selected then gridview displays the rows with day nos as per the month but if the gridview has no data for the same the dropdown or gridview via some event should call a insert procedure to insert data into the table for tht month with daynos ad rebind the gridview witht the rows just created

View 6 Replies

Forms Data Controls :: Gridview Populate Dropdown Based On Another Dropdown?

Mar 4, 2011

I have a gridview where i have two fields. one is product and second is sub category.

I need to do 2 things.

1. I need to populate the two combos from the database. But depending what is selected in dropdown 1 this will determine what needs to be populated in drop down 2?

how can i achieve this?

View 2 Replies

MVC :: Load Dropdown Based On Selection Of Other Dropdown?

Jan 9, 2011

I am new to MVC, I have a form in which selection of one dropdown should reload another dropdown. On selection of the dropdown, I use a jquery post to get the data and my viewstate is reloaded with new data, but I am not sure how to set the newly loaded viewdata to load the dropdown again.

View 5 Replies

Forms Data Controls :: Populating Dropdown Box With XML Data Filtered From Another Dropdown Box?

Jul 29, 2010

I've currently got a form with two dropdown boxes on, and an XML file sitting on the site.

My two drop down boxes are Location and Date and what i'm trying to do it get the Location box to filter the XML and put the dates in the Date dropdown box.

I'm using C#.

Unfortunatly, its not working.

My code is:

[Code]....

and my XML is like this:

[Code]....

why my dropdown boxes are not being populated?

View 3 Replies

Web Forms :: How To Load Web Control Names Into Dropdown Box

Mar 29, 2010

Does any one knows how i can load all the control names in my web application into a drop down box?

{
i++;
ControlName = while(ControlNum >=i)string ControlName =
this.form1.Controls[i].ID.ToString().ToString();
this.cboControls.Items.Add(ControlName.ToString());"";
}

View 5 Replies

Forms Data Controls :: 2 Dropdown List / "Displaying A Dropdown List Of Categories With A --None -- Option?

Oct 10, 2010

I am stuck at this point "Displaying a dropdown list of Categories with a --None -- Option. I want the gridview control to display 2 dropdown list one in read-only mode and the other in edit mode. When a record is in read-only mode, the dropdownlist's enabled property will be set to false."When it's on a read-only mode, it doesn't display the selected Category. it shows but the "No Category". When i click on edit to edit or change category, it doesn't display the selected category.

The example is given below( I am reading the book Sams Teach yourself ASP.NET 2.0 by Scott Mitchell. page 628)

<asp:Label ID="UserIdValue" runat="server" Visible="False"></asp:Label>
<asp:SqlDataSource ID="picturesDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [Pictures] WHERE ([UserId] = @UserId) ORDER BY [UploadedOn] DESC"
DeleteCommand="DELETE FROM [Pictures] WHERE [PictureID] = @PictureID"
InsertCommand="INSERT INTO [Pictures] ([UserId], [CategoryID], [Title], [Description], [UploadedOn]) VALUES (@UserId, @CategoryID, @Title, @Description, @UploadedOn)"
UpdateCommand="UPDATE [Pictures] SET [UserId] = @UserId, [CategoryID] = @CategoryID, [Title] = @Title, [Description] = @Description, [UploadedOn] = @UploadedOn WHERE [PictureID] = @PictureID">
<DeleteParameters>
<asp:Parameter Name="PictureID" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="UserId" />
<asp:Parameter Name="CategoryID" Type="Int32" />
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter Name="Description" Type="String" />
<asp:Parameter Name="UploadedOn" Type="DateTime" />
</InsertParameters>
<SelectParameters>
<asp:ControlParameter ControlID="UserIdValue" Name="UserId" PropertyName="Text"/>
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="UserId"/>
<asp:Parameter Name="CategoryID" Type="Int32" />
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter Name="Description" Type="String" />
<asp:Parameter Name="UploadedOn" Type="DateTime" />
<asp:Parameter Name="PictureID" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
<br />
<asp:SqlDataSource ID="categoriesDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [CategoryID], [Name] FROM [Categories] WHERE ([UserId] = @UserId)">
<SelectParameters>
<asp:ControlParameter ControlID="UserIdValue" Name="UserId" PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
<br />
<asp:SqlDataSource ID="maxPictureIDDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT MAX(PictureID)
FROM Pictures
WHERE UserId = @UserId">
<SelectParameters>
<asp:ControlParameter ControlID="UserIdValue" Name="UserId"
PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
<br />
<asp:Label ID="cannotUploadImageMessage" runat="server"
Text="The photo could not be added to your album either because you did not specify a file to upload or the file specified was not a JPEG image with the file extension .JPG"></asp:Label>
<br />
<asp:DetailsView ID="dvPictureInsert" runat="server"
DataSourceID="PicturesDataSource" Height="50px" Width="125px"
AutoGenerateRows="False" CellPadding="4" DataKeyNames="PictureID"
DefaultMode="Insert" ForeColor="#333333" GridLines="None">
<AlternatingRowStyle BackColor="White" />
<CommandRowStyle BackColor="#D1DDF1" Font-Bold="True" />
<EditRowStyle BackColor="#2461BF" />
<FieldHeaderStyle BackColor="#DEE8F5" Font-Bold="True" />
<Fields>
<asp:TemplateField HeaderText="Picture">
<InsertItemTemplate>
<asp:FileUpload ID="imageUpload" runat="server" />
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"
ControlToValidate="imageUpload" Display="Dynamic"
ErrorMessage="There was no file selected" ValidationGroup="PictureAdd"></asp:RequiredFieldValidator>
</InsertItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Category" SortExpression="CategoryID">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("CategoryID") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="pictureCategory" DataSourceID="categoriesDataSource"
runat="server" DataTextField="Name" DataValueField="CategoryID"
SelectedValue='<%# Bind("CategoryID") %>'
Visible='<%# Bind("CategoryID") %>' AppendDataBoundItems="True">
<asp:ListItem Selected="True" Value="">-- Select Category --</asp:ListItem>
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("CategoryID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Title" SortExpression="Title">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Title") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Title") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ControlToValidate="TextBox1" Display="Dynamic"
ErrorMessage="you must provide a name for the title"
ValidationGroup="PictureAdd"></asp:RequiredFieldValidator>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("Title") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Description" SortExpression="Description">
<EditItemTemplate>
<asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("Description") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Description") %>'

View 2 Replies

Web Forms :: Load The QuoteNumber Database Column Values Into Dropdown?

Mar 2, 2010

How can i load the QuoteNumber database column values into dropdown list which is autogenerated column.I am able to generate the QuoteNumber value and same inserting into database simultaniously all the Quotenumber values should load into dropdown, these two should happen in one click button event.My QuoteNumber dropdown name is "DDQuote" Code for generating Quotenumer and same inserting into database.

Protected Sub btnAQ_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnAQ.Click
Console.WriteLine(updateRecord("insert into quotes (PartNumber) values ('" + txtPart.Text + "')"))
retriveDataToDataGrid()
End Sub
Function updateRecord(ByVal query As String) As Integer
Try
Dim connectionString As String = "Database=fabdb;" & "Data Source=localhost;" & "User Id=root;Password=pacvision"
Dim rowsEffected As Integer = 0
Dim connection As New MySqlConnection(connectionString)
Dim cmd As New MySqlCommand(query, connection)
connection.Open()
rowsEffected = cmd.ExecuteNonQuery()
connection.Close()
Return rowsEffected
Catch ex As Exception
Console.WriteLine(ex.Message)
End Try
End Function

View 5 Replies

Web Forms :: Dropdown Selected Value Of User Control On Page Load?

Jul 15, 2010

I have a function on page load which will work based on dropdown selected value. and I am using this dropdown in a user control. So getting problem because the dropdown value is not loaded yet before Page Load. How Can I do that using those control still.

Here is my code below.

public partial class GradeEntry : System.Web.UI.Page
{
StudentManager studentManager = null;
CourseManager courseManagerObj = null;
GradeManager gradeManager = null;

[Code]....

View 7 Replies

Web Forms :: Strange Dropdown List Behavior On Page Load?

Apr 3, 2010

I have a page with 14 dropdown lists. In the first page load (ie. not isPostback) I set the selectedIndex of the dropdownlists individually but I find that they are all set to the value I use for the last dropdownlist set. Here is the code

comboFirstJudge1.SelectedIndex = 0
comboFirstJudge2.SelectedIndex = 0
<so on for all the dropdown lists until the last one>
comboFirstJudge14.SelectedIndex = 4

The result is that all dropdown lists have SelectedIndex = 4. If I run the same code on a postback it works just fine (the first lists have SelectedIndex = 0 and the last one = 4).

View 6 Replies

Web Forms :: Load Time Vs # Items Graph For Dropdown List Boxes?

Jan 20, 2011

I've noticed that page load time increases dramatically as you load up a ddlistbox with items. 10,000 or so results in a pretty much unacceptable wait time for my setup. The dropdown I'm trying to load is Airports - like all of them. What are some alternative UI solutions that give the user the ability to easily select any (literally) airport, but without a ginormous page loading time? (Currently the dd is keyed to the airport's 3 letter code, so it's convenient for the prepared user to just type the 3-letter code and have the right airport selected. The display is then set to code, city, country.)

View 7 Replies

Data Controls :: Get Value In Dropdown From Database / Show Other Value Which Is There In Dropdown

May 7, 2015

I 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.

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved