I am having trouble populating a database that is shown in a list box. The user uses a text box to enter an ID and the ID will bring up information. The problem I am having is in the highlighted area. It says The expression contains an invalid string constant: '1010. where 1010 is what i entered in the text box to test it.
[Code]....
I'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]....
I am just learning ASP.NET c# and trying to incorporate best practices into my applications. Everything that I read says to layer my applications into DAL, BLL, UI, etc based on separation of concerns. Instead of passing datatables around, I am thinking about using custom objects so that I am loosely coupled to my data layer and can take advantage of intellisense in VS. I assume these objects would be considered DTOs?
First, where do these objects reside in my layers? BLL, DAL, other?
Second, when populating from SQL, should I loop through a data reader to populate the list or first fill a data table, then loop through the table to populate the list? I know you should close the database connection as soon as possible, but it seems like even more overhead to populate the data table and then loop through that for the list.
Third, everything I see these days says use Linq2SQL. I am planning to learn Linq2SQL, but at this time I am working with a legacy database that doesn't have foreign keys setup and I do not have the ability to fix it atm. Also, I want to learn more about c# before I start getting into ORM solutions like nHibernate. At the same time I don't want to type out all the connection and SQL plumbing for every query. Is it ok to use the Enterprise DAAB for now?
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 been banging my head against this problem for a bit and I think I am stuck. I would like to pull data from a Database to populate a list of possible "clients" to select from on one side. Then using what has been clicked load the client specific data into a tab container on the opposite side. I plan on doing lazy tab loading so I am not sure if that matters. I am really stuck and any help or guidance anyone could give would be greatly appreciated! I understand the basics of data loading and of tab containers, but i am unsure of what to do. I am coding this in C#. Example Mock Interface This is where the data list would be and I want to be able to select something here And update the Tab Panel control here based on the selection from the left side via querying the database.
View 3 RepliesI have 5 radiobutton list in the form . i want to populate from it from the database.I have one table which has 5 Coloumn ( productname,group,id ,value,decscription) .Accrodindg to grouto i want to popluate all radiobutton list which display the product name.after populate all radiobutton list user select whatever list items i want to save using session in to new table.and which r the columns i make it for new table so i can save it user selction in databse..
my table veiw is like this
productname group id value decription
abcd g1 1 1 XXXX
bcdef g1 2 2 XXXXX
efgh g1 3 3 XXXXX
ghi g2 4 1 XXXX
dgjks g2 5 2 XXXX
ghidsg g3 6 1 XXXX
ghi g3 7 2 XXXX
fsdfghi g4 8 1 XXXX
so on upto g5 ..... my first raiobutton just populate group= g1 productname only for second raidobutton list just populate group=g2 productname only soon.
I would like to alter the query that is run, depending on the selection made by the user in a drop down list on the same page. Would this best be done using a partial page update (AJAX)? Ideally it would be great to have the textbox result change quickly once the drop-down list value has changed, without a full page postback. I would like to change the SQL query to a completely different query if the user selects an option different to the default (page_load value) in the drop-down list. I would then like the newly retrieved result to be displayed in the textbox as before.
My current VB function looks like this:
[Code]....
I have string which came from the database,now i want to compare each charater of the string with the radiobuttonlist value and check box list value and select both radiobutton list and checkboxlist.
Here i write down some code but its just select 2 item of the each radiobuttonlist and checked all checkboxlist.
[Code]....
I'm designing my own custom control that contains a .NET dropdownlist. What I'm wondering is if it is possible to populate my dropdownlist with listitems placed in a placeholder? For example:
<asp:DropDownList ID="ddlFilter" runat="server" >
<asp:PlaceHolder ID="ListItemPlaceholder" runat="server"/>
</asp:DropDownList>
This doesn't work because the DropDownList control only allows ListItems as child controls. But, I want to do something similar to this so when the user includes my control on a page, they can do something like this:
<mytag:MyControl Mode="DropDown" runat="server">
<ListItemTemplate>
<asp:ListItem Text="C" Value="c"></asp:ListItem>
<asp:ListItem Text="E" Value="e"></asp:ListItem>
<asp:ListItem Text="B" Value="b"></asp:ListItem>
</ListItemTemplate>
</myTag:MyControl>
I know I can do this by dynamically adding the ListItems in the page code behind, but I'd like to avoid that if possible.
I'm trying to populate a dropdown list from a list of existing SQL tables in a database. Does anyone have a code sample for doing this?
View 10 RepliesI need to populate a listbox, however, the value on the second box needs to derive from the first one, such as when I click on North America, USA and Canada would show up. the tricky part is that I need to be able to select North America and Europe in the same time and 2nd list box needs to show USA, Canada, UK, Italy, German accordingly.
A1: North America
A2: Europe
A3: Asia
B1: USA
B2: Canada
C1: UK
C2: Italy
C3: German
D1: China
D2: India
I've spent a lot of time trying to figure out how to do a drop down for filters. Right now I have two filters as a textbox but I want a dropdown list instead as I would be adding few more filters. This is my index page:
Task List
<ul>
<% using (Html.BeginForm("Index", "Task"))
{%>
<fieldset>
<legend>Filters</legend> [code].....
This is the change I made in my Model:
public class FilterViewModel
{
public PapClientProfile Client { get; set; }
public PapStaff Physician { get; set; }
[code]...
But I'm not able to populate any dropdown values.
I am trying to get two cascading dropdownlist to work but cannot get either to populate. How do I de-bug this? I'm not getting any errors, just blank dropdowns.
I've been trying to fill in webservice from SQL Server. But in-case this was the problem. I found an example on this site to fill with test values, but this still does not work. Since I cannot even get first to populate, to simplify I'm just giving code for first dropdown and its function(s)
[code]....
I have a DropDownList and I want to populate using a DataTable.
[Code]....
But when appear the DropDownList show System.Data.DataRow why this don't show the real result of the DataTable ?
I have a list on the page & I'm trying to add it a dropdown list to narrow down the results
(that I'm not sure is the best way to do so (any suggestion is welcome)
In my class the Query look like this:
[Code]....
In my controller my this is what I have tried :
[Code]....
( I think I have tried every thing that make sense for me )
and the view look like this :
[Code]....
& so on ...
[Code]....
i am trying to run this code, but even if it has somes results, it gives an exception saying that there are no Rows at positions 0.
DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection();
conn.ConnectionString = (ConfigurationManager.AppSettings["Gulfcoast"]);
conn.Open();
SqlCommand cmd = new SqlCommand("SP_GetSavedInvestigation", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@rlname", SqlDbType.NVarChar).Value = ddsavedsearch.SelectedValue.ToString();
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
if(ds!=null)
{
Criteria.Text = ds.Tables[0].Rows[0]["rl_criteria1"].ToString();
}
I am saving the username and password in cookies and I am able to retreive the username when they come back to Login page. But How do I need to populate the password field?
.CS Code:
[Code]....
If I am uncommenting this line
Login1.Password = Request.Cookies["password"].Value.ToString();
I am getting this error: CS0200: Property or indexer 'System.Web.UI.WebControls.Login.Password' cannot be assigned to -- it is read only
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
[Code]....
I have a list of Categories which I need to bind to a TreeView control in WPF and I can't find a working tutorial or get it working.My Category class consist of (ID, Title, ParentID). If the Category is a top level category the parentID is null.Can anyone sow me how to bind this to a treeview?
View 3 RepliesI'm trying to populate a drop down list from a datatable. Is this correct way of doing it?
public ViewResult Index()
{
ViewData["CampaignList"] = List;
return View();
}
public IEnumerable<SelectListItem> List
{
get
{
DataTable dt = CampaignRow.GetList(DB, 100, true);
List<SelectListItem> list = new List<SelectListItem>();
foreach (DataRow row in dt.Rows)
{
list.Add(new SelectListItem
{
Text = Convert.ToString(row["CampaignName"]),
Value = Convert.ToString(row["CampaignId"]),
});
}
return list;
}
}
how can i stylize drop down list? how can i add an empty first value ie "select campaign"
How will I populate a ASP.NET MVC List box? Make it non selectable?
how will i remove the selected items from the listbox
I have a DropDownList.
I need populate it with item collected in a List<ListItem>.
In my script, collector has been populated properly.
But I cannot populate the DropDownList. I receive an error:
DataBinding: 'System.Web.UI.WebControls.ListItem' does not contain a property with the name 'UserName'."}
<asp:DropDownList ID="uxListUsers" runat="server" DataTextField="UserName"
DataValueField="UserId">
List<ListItem> myListUsersInRoles = new List<ListItem>();
foreach (aspnet_Users myUser in context.aspnet_Users)
{
// Use of navigation Property EntitySet
if (myUser.aspnet_Roles.Any(r => r.RoleName == "CMS-AUTHOR" || r.RoleName == "CMS-EDITOR"))
myListUsersInRoles.Add(new ListItem(myUser.UserName.ToString(), myUser.UserId.ToString()));
}
uxListUsers.DataSource = myListUsersInRoles; // MAYBE PROBLEM HERE????
uxListUsers.DataBind();
i've run into small problem, here's the thing: i've got a dropdown list (ddlist1) that i am populating from a database, that works fine. However, depending on the option selected here, i need to populate another dropdown list (ddlist2). for example, if on ddlist1 i select option 1, on ddlist 2 i should get a list of options related to option 1 from ddlist1. If i select option 2, on ddlist 2 i should get a list of options related to option 2 from ddlist 1. and so forth. this information with which ddlist needs to be filled, comed from another database. o how can i go about this? m not sure yet how to code the second ddlist.
View 4 RepliesIs it possible to populate the values of a drop down list inside a repeater when the user chooses to activate the drop down list? I have a page that has 2300 rows of data generated by a repeater. The users have the option of showing a drop down list or not. If the drop down list is shown, right now I bind the values in the drop down list at the time the repeater is generated so they are available immediately.However, this adds an additional 2mb of data to the page, which increases the amount if time that it takes to render the page. I am being asked to decrease the page size. The idea they have is that if I only load the first value of the drop down list into the repeater, the amount of data on the page would drop significantly (which it does).
The problem becomes, how do I then load the remaining items into the drop down list when the user SELECTS the drop down list? These aren't static values, they are completely dependent on the data row key, so I have to go out to the DB and get the values for that individual row.I thought maybe AJAX and jquery, but can that be done inside the repeater?Ayone have any ideas as to if/how this could be done? Personally, I think the users should be educated that it is going to take an additional 5 seconds for the page to load if they choose to display the dropdowns, but the business is hesitant to go that route.
I am developing an MVC application. As part of the functionality I am using jQuery to invoke a server side Action method. This method returns an array of strings. I would like to display the list of strings in a select list using jQuery. e.g. I would like to see the following html:
<select name="CompleteAddress" onchange="Run()" id="CompleteAddress">
<option>22, Random Address</option>
<option>24, Random Address</option>
<option>26, Random Address</option>
</select>
The values "22 Random Address" etc... come from the Action method.
Currently, I am invoking the action method as follows:
[Code]....
i have 3 dropdown list box 3rd dropdown populate depending on 2nd drop down and 2nd drop down populate depnding on 1st value of drop down in asp .NET C#
View 9 Replies