I want to create multiple listboxes when you select the first it does a database query which gets a list for the second list box and it carries on for the third and so on. Beside each list box is a form to insert an entry for that list is there an article or video on how to do this. Some ajax might be needed to do what I want Im not really sure what to do I can't find an article on this.
View 1 RepliesI have a table in SQL Server which gives me a list of products (PRODUCT), and the products category (CAT). Right now I am putting all the products in the same ListBox:
foreach (DataRow row in ds.Tables["ProductsTbl"].Rows)
{
string str = string.Format("{0}", row["PRODUCT"]);
ListBox1.Items.Add(new ListItem(str));
}
But I need to create as many listboxes as there are categories, and distribute those products according to the category. Categories might be added or removed so I need to create them dynamically. So lets say the table has 5 products in category 1, 4 products in category 2 and 7 products in category 3, I would need 3 Listboxes created. The first with 5 items, the second with 4 and the last one with 7 items
I have three ListBoxes each representing a single field database table. They are presented side by side on the ASP.NET page. Is there any way to group them so that only a single item from any of the boxes can be selected at a time?edit - ie, if item 3 in box 1 is selected, selecting any item in box 2 must unselect it
View 1 RepliesI am populating a form trough a query so it will return multiple values, sometimes 5 or 6 or even more.Now when I press submit I need to save each form row in a database.table as a new entry. Other question is I have 3 check-boxes when the submit button is pressed it need to insert the value corresponding to the selected one, how to do that?
Code:
@{
var db = Database.Open("quality");
var selectQueryString = "SELECT * FROM perguntas WHERE chklst_id=@0 ORDER BY id"
var id = UrlData[0];
[code]....
New at SQL and ASP.NET C#, bear with me. I have a form to insert into mulitple tables of a sql db. The form includes two listbox's, categoryIDlistbox and subcategoryIDlistbox, both with the ability to select multiple choices. Idea is that there is one record for the user created (Table1) and then that user can have multiple categories and subcategories assign to him/her in Table2
Table1:
userID
fname
lname
etc...
Table2
userID
categoryID
subcategoryID
If I understand correctly I need to use an array to take the multiple listbox items and save them to the tables. Not sure where the array goes in my code behind page to process the listbox and loop for muliplte selections. Here's my current code behind, where do I place the listbox array?
[Code]....
I'd like to build an Asp.Net website using the .net 3.5 framework. I have a SQL Database called "Database.mdf"
View 1 RepliesI need to create a Master Detail detail form to insert data into Access. The form i have to create is very similar to the typical Order/Detail form.
View 3 RepliesIt's a multi-model view, and I'm achieving this through an IList<Book>. Each Book has a Title and an Author
So for example if I wanted to make 3 Books:
[code]....
However, I want to be able to generate such a form for any number of Books. I've done this before in Ruby on Rails through JavaScript and rendering partials, but I don't think I can render a partial in this case because the form changes (the index of the book has to increment for it to work)
EDIT: I'm looking for a way to do this in the Create view in particular. So in this case I don't have a list of books, but I'm building it.
A user should be able to click on a link that says "Add another item" and a form for another book should be appended to the bottom.
We have a number of projects and across projects cerrtain forms are duplicated.
Is there a way that I can create one form and reuse it across multiple projects?
i need to insert multiple rows at a time into database table(sqlserver) from datatable or gridview. Actually iam looping through the rows of gridview and inserting each row. Is there any method to insert entire table of rows at a time into database table. Both datatable columns and database table coulmns are similar.
View 2 RepliesI have grid view in ASP.Net 3.5. I need to add multiple blank rows in a gridview and then have to save them in database. How can I do that in most simplest way?
View 7 RepliesI have a Winform that has fields need to be filled by a user. All the fields doesn't belong to one table, the data will go to Customer table and CustomerPhone table, so i decided to do multiple inserts. I will insert appropriate data to CustomerPhone first then Insert the rest data to Customer table.
View 3 RepliesI am trying to insert data into two table at the same time , but i'm successding in inserting data into only one table at a time on button click .
[Code]....
When i run the code, data gets inserted into table "implantDetails" only. Are multiple INSERT statments allowed?
I am listing about 20 rows, each row represents an Order.Each row needs to have 3 buttons, each button click will perform a different action.I have 3 actions to handle each button post request, I am just unsure how to setup the Html forms for each button.
<tr>
<td>
<form method="post" action="/orders/do1"><input type=button ... /></form>
<form method="post" action="/orders/do2"><input type=button ... /></form> [code]....
Should I create 3 forms for each button, per row in my listing?(that would mean 20 rows x 3 forms = 60 forms on a page)Is that 'ok' to do? (i.e. or is there a better way to do this?)
i have created loing form and create user form. then how to apply login rights..? i have 2 types of user. admin and normal user admin can move and use all pages while normal user can acces limited pages.
View 4 Repliesi need to create a dynamic form that switches the contents of the page without reloading or refreshing the page.
View 10 RepliesIm using Microsoft Expression Web 3 and am in the process of making a page for my Cab Company that basically calculates the price from an area in London (In listbox A) and an airport (In listbox B) along with the type of car used (Saloon, Estate, MPV) in a checkbox list.
If I were to set a value for each and every item in Listboxes A, B and Cars, is there some sort of autosum code I can use which calculates the price. The feature is only going to be a pricequote system for now untill we get some sort of booking system up and running so it is preferred that all calculations are done & displayed on the same page.
Is is possible to build a form, accept parameters and from THAT construct a new .ascx page AND the code behind for that page? What I'm proposing is having some code snippets that just need parameters added and can then be used to create a web user control that can be added to existing pages. This .ascx file would be a real file after creation, not dynamic every time.
View 1 RepliesI have 2 listboxes, when i add a item retrieved from database to Listbox1, i need to select the item and bring it to listbox2. But i do not want to have same records added again. In my case, i cannot use the codes below
[Code]....
because the text displayed on listbox1 and after transferring to listbox2 are different. So i come out with a logic which is "if listbox2 does not contain the item value in listbox1 then populate listbox2". So i tried the codes below, but it is not working as there are errors
[Code]....
I am developing an mvc 2 application.In my form i have a listbox. Based on selecting the items in the listbox a vertical tab is created.the tabs in the vertical tabs are created corresponding to each item selected in the listbox.after the creation of the vetical tabs each vertical tab will be containing a listbox.here the user can select the list items.now my problem is that i want to know which all items in each listbox in each tab is been selected .some code:
[Code]....
I have a web app that has two listboxes on the page. The first listbox has selection items that can be chosen and moved over with back and forward buttons to the destination listbox.
I can't figure out how to validate the destination listbox for empty items on a postback. I have tried to use a custom validator, but I can't get the validator to fire unless I actually select one of the items with the mouse.
I am trying to design my logic to do this but I want to create a dataSet which will have records from several databases, The records all have the same layout.
I am reagin the connection string paths from a table in a database.
I am asking for your help in trying figure out my logic.
Should I use the connectionString builder in conjunction with a loop to Connect, read a record into a dataset Until therer are no more records to be read from my databse table with the database name/paths tables ?
Here is my beginning code which deals with one database:
[Code]....
I have a form which inserts data in DB on Submit button click but the problem is when client click the button multiple times its sends multiple create requests means multiple button click events for the same time of same data, which must not be.
I tried to disable the button when client click the Submit button first time but after this it does not call server click event handler or not fire the server click event once it got disabled.
How to handle this multiple click problem..
I used the following code to disable the button
[code]....
All of my listboxes seem to work right in all browzers but Safari. Any trick to getting them to work with Safari?
View 3 RepliesI have two drop down listboxes in a GridView control. I want to populate the second drop down listbox based upon the value that was selected in the first drop down listbox. Currently I have not been able to populate the second drop down listbox. I am attempting to do this in the C# code file. See line 26 below.
// Here is some of my Aspx code:
this first item template populates the first drop down listbox:
<ItemTemplate>
<asp:DropDownList ID="ddlFirstDropDown" runat="server"
DataSourceID="SqlDataSourceBodyBuild"
DataTextField="BodyPart" DataValueField="EmployeeId" AppendDataBoundItems="True"
Width="110px" AutoPostBack="True"
onselectedindexchanged="ddlFirstDropDown_SelectedIndexChanged">
[Code]...