I have a string that contains comma separated values that I want to get into a DropDownList on a View.
Expample:
"Valve, Body, Handle, Cover, None" I'd like each value in that string to appear as a selection choice in a DropDownList, with the KeyValue 1, 2, 3, 4, 5 etc (corresponding the the index location within the string.
Valve = 1
Body = 2
Handle=3
Cover = 4
None = 5
I am trying to get the values selected by the user from the dropdownlist into a string..but its only getting the fist value of the dropdownlist,
does anyone knows what i am doing wrong?
string trade = DropDownList1.SelectedValue;
string adress = DropDownList2.SelectedValue;
string code = DropDownList3.SelectedValue.ToString();
Using dropdown in gridview and bind the values in dropdown then based on dropdown display the value in another column.
View 1 RepliesI am using Asp.net 3.5 listview control. In item_updating event I am using this code...
dim country as string = Dim country As String = e.NewValues("country_name").ToString.Replace(" ", "")
It's updating record correctly. for example if I update USA to USA 1 1 then it's updating like as it. But I want it to be USA11
I want to split a string that taking both string and integer values like (Cmp_12). I want to use them in Separately.
View 4 RepliesI have a SQL query I'm running in an ASP.NET page. The final parsed SQL needs to contain a list of string values in the WHERE [columnname] IN [values] format. For example, the final query might look something like this:
SELECT PRODUCTNAME FROM PRODUCT WHERE PRODUCTCODE IN ('ABC','DEF','GHI','JKL', /* etc */);
However, the string values in the WHERE clause need to be dynamic. Normally I use parametrized queries to make my code convenient and safe, so conceptually I'd like to do something like this:
String[] productCodes = { "ABC", "DEF", "GHI", "JKL" };
SqlCommand cmd = "SELECT PRODUCTNAME FROM PRODUCT WHERE PRODUCTCODE IN (@ProductCodes)";
cmd.Parameters.Add("@ProductCodes", productCodes);
However, this sort of functionality doesn't appear to exist in .NET. How should I go about implementing this? I could use a foreach loop on the array and run a query with a single value as a parameter for each value, but there could potentially be a hundred or so different values in the array and it seems like querying them separately would be very inefficient.
I've read another question where someone suggested a solution for strongly-typed int parameters, but that method would make me nervous about SQL injection when used with String values, especially since the client may very well be able to influence the input values.
How would you implement this query functionality?
EDIT with DB Details:
The database is SQL Server 2005.
i have added one textbox as a template in my gridview.i want to get the values of textbox to a string when i enter values to the textbox.
View 1 RepliesHow to get the error number and error description from this string
s = "ERR: 100, out of credit";
error should equal "100"
error description should equal "out of credit"
I'm trying to extract the selected value from a a DropDownList as a string as follows:
if ((ASPxComboBox1.SelectedItem.Value).ToString = "Selection")
This is not working. if there is a away of getting each selected string extracted?
binding values with dropdownlist.i have one dropdownlist name,dropdowndiagnosticcategory..i have made one function bind_category() for binding the category values.The code for binding the values with dropdownlist is as under,here
private void bind_category()
{
string s = "Data Source=LAB1-40;Initial Catalog=MNSDaignosticCenter;Integrated Security=True";
SqlConnection con = new SqlConnection(s);
con.Open();
SqlCommand cmd = new SqlCommand
[code]...
I'm using asp.net MVC 2.0, my controller coding is,
[code]...
i need to bind this value to the drpdown list in the aspx page.
[code]...
I have List items = new List();
and UI i have a textbox I am entring and ListItem..
when I enter the value in textbox I need to add values to the listitem..?
I have one Calendar, and two DropDownLists. I want to get the selected date from the calendar, the time chosen from the first DropDownList and combine them to one smallDateTime to insert into my database and then do the same with the same date and the time chosen from the second DropDownList. I want the smallDateTime to look like this for example: '2010-12-01 14:00:00'. My code below doesn't work but I think it can give you an idea of what I want to accomplish. I get an error message on this line of code:
[Code]....
i have a dropdownlist for a class named person and person properties are PersonID, Name, Age.
public class Person
{
public string PersonID { get; set; } [code]....
can i list Age in same dropdownlist?
i have a string of format ( 3.7 cm - 5.4 cm ) now i want to get the to numbers in the string into two variables for comparision
View 8 Repliesi have a sql connection string being stored in the web.config.
how can i pull items liek server name, username, password... insode of c# asp.net code?
Iam using a dropdown list ,in that am having 4 values ,the following are my values
Uk-L1
Us-L1B
Aus-BUssness
Uk-HSMP
and here i need to choose the a particular value as a selected index ,and i did that for a exact value and in my requirement i will pass only the values after that '-' .so that i need get the value to be selected and here am using the following code to select it is not working can any one help for this.
Code:
DropList.SelectedIndex = DropList.Items.IndexOf(DropList.Items.FindByValue("L1"));
I really have a big problem(stuck) with two dropdownlists inside a detailsview.I have 4 detailsview : DdlRt,DdlRt2,ddlMobv1,ddlMobv2. Basically what happens here is that DdlRt2 gets populated when DdlRt is selected and ddlMobv2 gets populated when a specific value from ddlMobv1 is selected.
In code posted above the detailsview has a "Update" command and the problem is when the update command is executed the data is successfully posted to the db BUT! THE VALUES from DdlRt2 and ddlMobv2 dissapear! And I can't insert any more Items. The only Item that stays in these two dropdownlists is the default "Select Department" item which is't set in codebehind but is set in .aspx.....I can't figure what I'm doing wrong here It must be something with databinding & events.
So my question is "Why can't I insert any more items to these two dropdownlists after the "Update" command on the DetailsView is set or how can I preserve the values that are already in"?
<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="odsRegister"
DefaultMode="Edit" Height="50px" Width="125px" > [code]....
In my code I have 2 ComboBox DropDownLists, created by the code below. The problem is that when the value of the DropDownlist get changed, the other one value also changes.
public class Translate
{
public string CountryName { get; set; }
public string CountryCode { get; set; }
}
IList<Translate> languages = new List<Translate>();
languages.Add(new Translate("Select", ""));
languages.Add(new Translate("English", "en"));
languages.Add(new Translate("French", "fr"));
languages.Add(new Translate("Spain", "es"));
ddlFrom.DataSource = languages;
ddlFrom.DisplayMember = "CountryName";
ddlFrom.ValueMember = "CountryCode";
ddlTo.DataSource = languages;
ddlTo.DisplayMember = "CountryName";
ddlTo.ValueMember = "CountryCode";
i'm binding data to ddl from database.i'm selecting one column from database table to bind.In that column there may be items with same name.but when selecting in ddl there must be no same values.
View 4 RepliesHow to swap ddl's selected value on buton click.E.g User has Selected One from ddl1 and three from ddl2 then when the user clicks the Button the values should be swapped.
User Selected
DD1 DD2
One Three
After Swap button click
DD1 DD2
Three One
<asp:DropDownList ID="ddl1" runat="server">
<asp:ListItem>One</asp:ListItem>
<asp:ListItem>Two</asp:ListItem>
<asp:ListItem>Three</asp:ListItem>
</asp:DropDownList>
[code]...
I am developing a Webpage that gives the user selection criterial before running a report. There is a asp.net ListBox that I need to get the selected values from. It is obviously a multi select listbox.
I need to pass the selected values as a comma separated string to a parameter used in an SQL query of the ObjectDataSource for the report. I was hoping some how to get the selected items, and load their value into a string array and then use the join( stringArray , "," ) to get the selected values into a string to send as a parameter to my objectdatasource but I cant seem to figure this out.. Ideally if code worked my way I would want to do something like this: Declare StringArray for each selected item in Mylistbox Add selected value to StringArray Set parameter = join( StringArray , "," ) Obviously this is what I need syntax for.. I pretty much just need to know how to get a string array or all selected values.
I am trying to set up a page that has two behaviors. I'm seperating them by URL: One behavior is accessed via /some-controller/some-action, the other is via /some-controller/some-action?customize. It doesn't look like the Request.QueryString object contains anything, though, when I visit the second URL...I mean, the keys collection has one element in it, but it's null, not 'customize'. Anyone have any ideas about this or how to enable this. I'd like to avoid manually parsing the query string at all costs :).
View 2 Replies For some time I have been desperately meddling with an Autocompleted textbox. After trying several snippets found around, I now have something that works in my solution.
A function, LoadData returns a list of streetnames, used to feed the autocompleted textbox. It works perfectly when using a teststring (see code below)
My problem is now to somehow read all the values in the field 'Gade' from the database and whip them into a string, seperated by spaces. I have been fiddling with datareaders and some more or less optimistic stuff, but not found anything that works Its probably quite simple but I am totally stuck.
[Code]....
how can i dissect or retrieve string values
Here's the sample code that im working on now
private void SplitStrings()
{
List<string> listvalues = new List<string>();
listvalues = (List<string>)Session["mylist"];[code]....
now that i'am able to retrieve List values in my session, how can i separately get the values of each list using foreach or for statement? what i want to happen is to programmatically split the values of the strings depending on how many is in the list.
