problem: bad design but this is what they want.I have a datasource which binds to a dropdownlist. This is fine. this displays companies (with companyID as the DataValueField)they then, underneath, want a seperator and then after that, a list of "groups".of course, DDL cannot have multiple Datasources. So how can I bind from 2 sources into 1 DDL? I cannot seem to think of a way. Even adding the items at the end of the databinding will not help as the GroupID maybe the same as a CompanyID for the DataValue.
I have one grid in which i use one datasource to get several data . Now i want to ad a column in my grid and bind that column with a column from another datasource.
I am not able to find the projects related to working with excel sheets by using ClosedXML to refer. I have an excel book which contains two sheets.
In sheet 01: In column A: In B: In C:
Student name01 Student's phone number blabla
Student name02 Student's phone number blabla
Student name03 Student's phone number blabla
In sheet 02: In column A: In B: In C:
course name01 computerscience blabla
course name02 dhfsthshbstgs blabla
course name03 garsfghsefrgs blabla
now, I would like to see in two comboboxes (all the words/text presented in the column A) from two sheets, the student name and course name and then I want select any student name and course name of my choice. Afterwards, when I click on a button, my program should display the students phone number and the course name (from column B from both sheets) and related things present in the Column C D E.. of the selected things in combobox in a label or a in a textbox.
PS: I solved the following problem: I can select student name in one combobox and print the the corresponding data from the only one column B (but I worked only with one sheet). It is bit complicated for me to continue with two sheets.
As you can see there is a ControlParameter bound to a TextBox on the aspx page. So the content of this TextBox is a parameter for my SelectMethod. But there is a special button on the page: When this button is clicked and a postback occurs I don't want that the DataSource extracts the content of the TextBox to control the selection, instead I want to set a specific hard value "x" as the selection parameter.
How can I do that? Can I "disable" in some way the ControlParameter when this specific button is clicked and set my special value instead? Or is there any other way?
How do you control database server access when you use datasources in VB 2010?How do you access multiple tables from a store procedure using datasources?
Explanation:My experience is with VB.NET for the most part. I've written a lot of apps drawing data through dataadapters into datasets and processing them to provide reports in aspx.
I'm starting to work in VB 2010 and those elements are no longer available. What appears to be the weapon of choice is the datasource.What I'm not seeing: 2 important things that I can't work without:
1. Control over when the database server is hit with a connection request; daMyQuery.Fill (MyDataSet) was an explicit command that I could use to collect my data on demand. From that point on, I could use the dataset as I wished to populate whatever controls or structures I wished - the database server was no longer needed and wasn't hit by my apps until another pageload.
2. Multiple Tables in a query result; This must be there, I just can't find the method by which to reference different tables in my SQL output. Previous, I would have a dataadapter which would use a stored procedure to deliver a dataset of multiple - sometimes many - tables for use in the application. I can't find the equivalent on a datasource.
So my two big-ticket needs - requests for assistance, really - are listed above: How do you get at multiple tables returned from a stored procedure;and;How do you keep datasources for hitting the dbserver whenever you use it if there is no equivalent to a 'fill' method?
I guess another - how would you walk through the rows of a dataset?
i saw this post on[URL] so the problem is .... if there is a datasource in some editeitem template in grid view .... it won't be accessible from out of the edit-item field.....
here's my code...
[Code]....
that i have here is ID-column which contains a linqdatasource taking a where parameter from a dropdownlist and they are both in the same edit-template field.
and i have in another column (CourseTypeID-column ... edit-item template) a dropdownlist ..... now this dropdownlist i want to bind it to the linqdatasource exists in the ID-column (edit-item template)..... is that possible in the designer (or from) not code behind ..... and how ????
I've been filtering my gridviews with the FilterExpression of the underlying ObjectDataSource etc. I am wondering how I can implement filtering on my GridViews if I just directly databind it to a datatable etc?
I have created a web application will will eventually be the holding place for several reports. Rather than creating a new webform for each report, I want to use the same report viewer for all of the reports. I have created an AccountSummary dataset (AccountSummaryDS.xsd) that has two tables, one for the header information and one for the details. I have two webforms in the app, a Default.aspx that captures the necessary employee information for the query and the ReportForm.aspx that has the reportviewer control.
I came up with the code below for a Windows form application but am having issues translating it to be used in a webform.
i have a mysql database and a sql server database.there is a link between these two tables via a foreign key.is it possible to connect two datasources together in my datamodel? if so please can someone tell me how i can do this? i have them both present in the data model, i just want to be able to link the two databases together.i am using asp.net mvc, c# and entity framework - all in visual studio 2008
I would like a site that offers the users the possibility to search over 2 datasources but as i tried to indicate in the subject title the searches are one after another where the result of search 1 is used as a parameter for searching the second datasource. The order of the search would depend for what you search (ideally). Some "fields" or "data" of course appear in both datasources.
To get more specific: datasource 1 contains chemical structures and the associated "id" for this structure + additonal properties. You can search for chemical structures here. (chemically intelligent system). datasource 2 contains documents which are indexed (full text) and have metadata fields one of them beeing above id. No chemical search possible.
The idea is now that i perform a search by chemical structure on datasource 1. As as a result I get a list of id's. These id's are then past into datasource 2 as parameter + also all additionaly parameters entered. There are API's available to perform above searches on the 2 datasources. Is this a reasonable approach? Would it be better to create somekind of a simple datawarehouse, eg a table with all numbers linked to all documents they appear in? (would't know how to achievie this actually since it's the 2 datasoruces are not the same rdbms).
Is it possible to bind two separated datasources to one dropdown list such that they are both alphabetically sorted and seprated by some sort of line. I know there is a way to insert elemets manually, but I'm not sure of the 2 separate datasources. I've serached this forum and while there were several posts none of them offered any workable solution.
Cannot have multiple items selected in a DropDownList.
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.Web.HttpException: Cannot have multiple items selected in a DropDownList.
Source Error: [Code]....
Line 85: function openPopup2(did) Line 86: { Line 87: var hdnClm1 = document.getElementById('<%=hdnCliamid.ClientID%>').value; Line 88: window.location="Form.aspx?DeleteRSPid=" + did + "&Editid="+ hdnClm1; Line 89: }
[HttpException (0x80004005): Cannot have multiple items selected in a DropDownList.] System.Web.UI.WebControls.DropDownList.VerifyMultiSelect() +106 System.Web.UI.WebControls.ListControl.RenderContents(HtmlTextWriter writer) +124
I have an AJAX UpdatePanel that contains multiple dropdownlists, a button, and an ASP Panel (which contains dropdownlists and textboxes). On button_click I want to enable the ASP panel, but it is not enabling. The ddls all work fine, I just can't enable/disable any controls within the update panel or the asp panel itself.I tried UpdateMode = Always I tried UpdateMode = Conditional where ddls and button were triggers I tried adding UpdatePanel.Update() to the button_click I tried using visible instead of enabled (ASP Panel) Nothing is working. Side Note: this is all within a step on the ASP Wizard
I want to create multiple dropdownlist for each item I get from Database- the dropdownlist is common for all the list...I have the follwoing code for checkbox
Dim guest As user = Session("user") Dim items As ArrayList = items.getitems(guest) If items Is Nothing Then
[code]...
Just like the repeatLyout.flow in the cblitem.. I need the same for the dropdownlist...(I need it to repeat for each item I get from database)
In databse i have a column called Region.I have multiple occurence of region say india.India is repeated 5 times in region column.But in dropdownlist i should display only once.Is it possible.How?
I have two ListBox in my ascx file, I fill them with some data (no problem here), I make them multiple and increase the size, below is my code.
[Code]....
I use some jQuery code to exchange element between them (Here too, no problem). My problem begin when I post my form, I'm unable to get the data from the DropDownList with attribute multiple or size. I tried in my controler to add a FormCollection parameter, I can see every element in my form except those select tag with more options than id and name. I tested to put a manual select tag in my code with only an id and a name then add size and multiple attribute, when there is only id and name I can get the value but when there are more I can't get my select tag in the FormCollection
Also I need to get all the value in the ListBoxand not only the ones who were selected. I have been searching answer for 2 fays now... Without success, I only find resource on how to show ListBoxbut not how to get values from them in mvc web site and I don't find any resources who talk about multiple selection ListBox, I think I'm a bad searcher but....
Now my datasource has where clause depends on the selection of a dropdownlist that contains selection of one of the items plsu and option ALL.
This only caters for all or, one item
I need to make it
All, or, 2,3, or 4.. selection and the datasource is then refreshed. What control I should use and it seems the SQL need to modified into "IN" statement, am I wrong ?
I have a footer template in gridview with 4 dropdownlist in a row. Based on the selection of first dropdown i need to load data in the other dropdownlists and similarly for the rest.. How to write events for this?
System.Web.HttpException: Cannot have multiple items selected in a DropDownList. 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.Web.HttpException: Cannot have multiple items selected in a DropDownList.
I have a nested gridview and inisde a child grid there are several columns having dropdown and one add button. when add button is click a new row inside a child grid is created with an empty dataand previous row data have been saved in viewstate so that it can be bind wen add button is click to create new rows.My code is working fine when i dont select any dropdown list item and new row is also created but wen i select items from dropdown and click on add more button i get above error.
When add button is click
protected void ButtonAdd_Click(object sender, EventArgs e) { Button gv = ((sender) as Button); string[] ParentIdArray = gv.ClientID.ToString().Split('_'); int ParentId = int.Parse(ParentIdArray[1].ToString().Replace("ctl", "").Trim()) - 2; int RecordCount = ((GridView)GVMain.Rows[ParentId].FindControl("grdAddHotel")).Rows.Count;
DataTable dtAddHotel = new DataTable(); dtAddHotel.Columns.Add("CostSheetId");
i used the following technique to Select multiple items from DropDownList into TextBox with No duplicates, however i dont think it is the most proper way, any ideas. pressing again with same value selected choose another value from DDL and press button
Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click If TextBox2.Text.Contains(DropDownList1.SelectedItem.Text) Then Dim m As New Label m.Text = "duplicate !" Me.form1.Controls.Add(m) Exit Sub End If If TextBox2.Text = "" Then TextBox2.Text = DropDownList1.SelectedItem.Text Else TextBox2.Text = TextBox2.Text + " , " + DropDownList1.SelectedItem.Text End If End Sub
