As I kept my fetched datatables into session and accessing it on another page there I am
wroking on datatable to fetch only distinct values of particular column to assign to dropdown list.
I have one table(tableName is getDetails and having three column ID, Name, City)
View 6 RepliesI have a Detailsview grid with an SqlDatasource, this DVG is only going to be used to insert records. The primary purpose of the DS is to populate a DDL control in the insertItem Template that I created my code is this:
[Code]....
The DDL control populates correctly, but when I try to modify the INSERTCommand property in my DS, I try to assign the value to my parameters "TesterID" and "TesterDate" but the only options for controls to pick from, is the DGV but not the DDL in it. I assume it has to do with the InsertItem template but even if I reset it I still cannot pick the textbox as a control that would give the value to my parameters.
I did find a workaroun by build a public method and calling it in the onclick event of the insert button but looks like I have to create another connection to the database which to me seems unnecessary since I already have a DS and everything. how can I do this without having to use my method. here is my method just in case.
[Code]....
Is it possible to display two column values from a SQL database in to one DDL? I have been trying to write a SQL query, where in I select two fields to be displayed in the DDL but when I run the application it only displays one. Not sure why. Here is my code below:
<asp:DropDownList ID="DropDownList8" runat="server"
DataTextField="LATA"
DataValueField="LATA"
onselectedindexchanged="DropDownList8_SelectedIndexChanged"
DataSourceID="SqlDataSource1">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:Inventory_DBConnectionString %>"
SelectCommand="SELECT DISTINCT [LATA], [LATA Name] AS LATA_Name FROM [CA] WHERE ([SWITCH ID] = @SWITCH_ID)">
<SelectParameters>
<asp:QueryStringParameter Name="SWITCH_ID" QueryStringField="ddl1"
Type="String" />
</SelectParameters>
</asp:SqlDataSource>
I have a datatable dt with 4 columns. I want to retrieve only distinct values from column1 of datatable.
How can I achieve this using c# code?
I would like to know if there is a way that I can use DISTINCT on one column's values but need to show other columns where the value of the DISTINCT column is equal to another table's column
View 7 RepliesFirst, a user select a country from a dropdown list. The selected item & its value are store in a seesion. Then the user leaves this page.
<asp:DropDownList ID="ddl1" runat="server">
<asp:ListItem Value="US" Selected="True">USA</asp:ListItem>
<asp:ListItem Value="AF">Afghanistan</asp:ListItem>
<asp:ListItem Value="AL">Albania</asp:ListItem>
</asp:DropDownList>
Dim arr(1) as string
arr(0) = ddl1.SelectedItem.ToString
arr(1) = ddl1.SelectedValue
Session("arr") = arr
Later on, the user may come back to the page and change the selection of the country. However, I want the dropdown list to remember the previously selected item and value. The item name and its value are now stored in an array. How do you assign it to the dropdown list as pre-selected.
I Have the gridview control with 2 dropdown list and 2 text boxes,When the textbox chnaged event happen 1 row will create and the dropdown back to initial values( its not retaining the selected values),I am binding the control after text changed method,Is there any properties needs to be set or any other way we can retain the values in postbacks?
View 4 Repliesafter the user login , i need to assign this use name as a global varliable, and then i want to select from a table in the sql server that have select first_name,last_name from dependincies where user id = global_value and then to add the first name and last name , to a list will should have different values according to the global varible values. how i can do this for my mvc project.
View 3 Repliesi have to combobox which default selected value is "select all" and other values USA GERMANY vs.
and i have countries table.how can i query all country names when "select all" value is selected.My stored procedure is look like this
select * from countries where countryname=@prmcountryname
I have a sample xml as;
<?xml version="1.0" encoding="iso-8859-9"?>
<DropDownControl id="dd1" name="ShowValues" choices="choice1,choice2,choice3,choice4">
</DropDownControl >
I need to create a UI representation of this XML using XSL. I want to fill the drop down list with values specified in choices attribute.
I have 3 drop down list boxes - One for month, day and year. I'm trying to get the value of what the user selects on those drop down list boxes. I have dynamically populated my drop down list boxes and I'm trying to output the end value on a label
private int month;
private int day;
private int year;
protected void Page_Load(object sender, EventArgs e)
{
for (month = 0; month <= 12; month++)
{
DropDownList2.Items.Add(month.ToString());
}
for (day = 0; day <= 31; day++)
{
DropDownList3.Items.Add(day.ToString());
}
for (year = DateTime.Now.Year; year <= DateTime.Now.Year + 75; year++)
{
DropDownList4.Items.Add(year.ToString());
}
}
protected void Button4_Click(object sender, EventArgs e)
{
month = ?
day = ?
year = ?
Label7.Text = month + "/" + day + "/" + year;
The problem right now is I can't figure out how to actually retrieve the value the user uses
I want to add the below values from Enum to drop down list
<option value="0">-- Select --</option>
<option value="AC">Active</option>
<option value="IN">InActive</option>
<option value="PC">Pending Closure</option>
I would like someone to explain how I can pass a drop down list from the presentation layer to the controller using the Model View Controller Design Pattern from Microsoft in order to bind enum values to it?
View 2 RepliesHow do I create an array of values from a drop down list?
View 2 RepliesI'm stuck with a problem to populate a DropDownList control with values from the database using item field template in read only mode. since I'm new to ASP.NET. Below is the code and the error I'm getting:
'PictureReadOnlyCategories' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentOutOfRangeException: 'PictureReadOnlyCategories' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value
The code for this is :
<asp:SqlDataSource ID="categoriesDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand ="SELECT [CategoryID], [Name] FROM [Categories] WHERE ([UserId] = @UserId)">
<SelectParameters>
[Code]....
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
populating the dropdownlist with column name. I have a gridview that has 7 columns . I want to have a textbox search and dropdownfield where user can select column name and type a word in search box and click search so that text for that column name is being search and displayed in grid. how I can fetch just column names from DB and search ?
View 1 Repliesi am using a list view to view, insert, update and delete my data for the admin page this admin page made for the news and we have categories for that so i need to use a drop down list for these categories and when the admin choose on of these categories records its value as an ID to the database.
[Code]....
I have googled a lot to find any solution to pass the selected dropdownlist item to another page.
In my controller view, I have a got list of of items:
List<SelectListItem> PackagingService = new List<SelectListItem>();
I have an application as: SelectCommand="SELECT [CategoryID], [Name], [UserId] FROM [Categories] WHERE ([UserId] = @UserId) ORDER BY [Name]">
</asp:SqlDataSource>
Pick a category: <asp:DropDownList ID="categories" runat="server" AutoPostBack="True"
DataSourceID="categoriesDataSource" DataTextField="Name" [code]...
When i take away the <SelectParameters>
<asp:QueryStringParameter Name="CategoryID" QueryStringField="ID" />
</SelectParameters> and ([UserId] = @UserId), the dropdown list control will populate values from the database but when i live those 2, it won't populate any value from the database. When i remove the <asp:QueryStringParameter Name="CategoryID" QueryStringField="ID" />
</SelectParameters>,and live ([UserId] = @UserId), i get the error : Must declare the scalar variable "@UserId".
I have a dropdown list with hard coded values:
<asp:ListItem Text="One Day Shoots" Value="1" />
<asp:ListItem Text="Multi-day Shoots" Value="2" />
I want to use this to insert and edit values from a db. For example when adding a record the user selects 'One Day Shoots' and 1 gets inserted into the database. Then if the user goes to edit the page since the value in the db is 1 then the 'One Day Shoots' is selected.
One way I considered accomplishing this was by using a hidden feild - when the user selects something in the dropdown list the field is updated with the value, then when the user actually adds the record the value in the feild is submitted. I'm pretty sure this would work but is there a better way?
I have created a dynamic dropdownlist. I need to get the selected values from the dynamic list and store it my sql database.
View 5 RepliesI'm using objectDataSource and Formview. Currently I'm using a Text-Box to put the CategoryID.
I want to display the Category-Name instead of Category ID in Drop Down list.
I want to have a default value/item of "---Select One---" and then list all of the values from the SQL statement. Currently I am having trouble doing this. I tried to add it to the List Item but it doesn't show on the page.
View 25 Replies