I'm creating a user control that enables users to search AD and add the selected names to a list (which is used to send mail lateron).
The problem is that the search results end up in the Listbox but all as the string "System.DirectoryServices.ResultPropertyValueCollection" in stead of the actual values.
I have no idea why.
This is my code:
[Code]....
[Code]....
1. textbox (Search for staff)
2. Dropdownlist( Search for department)
3. Listbox( Populate staff name based on textbox or dropdownlist)
I am able to populate the staffs indenpendantly according to what is written in textbox or dropdownlist. Whar i wanted to do is mix the population of staffnames from textbox and dropdownlist. In other words, when i search "sandra' in textbox and select a Department A , the listbox will show all the sandra from Department A only.
[Code]....
I have a textbox for City field and a drop down list box for office location which has to be filled up based on the City value.
How to populate the values of drop down list box from an xml file keeping the above consideration.
I am doing this in a asp.net user control and C# code behind
In future i need not change the code every time. Its only the xml file i change and the corresponding city related office locations get listed in the drop down list box.
I am referring to
[URL]
I'm trying to auto-populate a listbox of zip codes from a database table state_zipcode_plans based on the state a user selects from the previous listbox. I'm getting the error: Must declare the scalar variable @state_code.
[code]....
custom self populating listbox
[Code]....
I am "trying" to switch my form from SqlDataSources to ADO.NET data sources. So I have a DAL setup, and ObjectDataSources in my form referencing these DALs. These data sources are bound to the form's objects. So far so good. In the InsertItem Template of one of the form's FormViews I have a list box that I am trying to populate with a value pair (ID, TechName) from a database table and I get the following error:
"Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control." Apparently, one of the two workarounds involves programmatically loading the listbox. The code below shows one of my attempts, resulting in the above mentioned error:
Code:
Protected Sub TestFillDefaultValueInFormView()
Dim vInspectorList As DropDownList
If (FormViewHydInspection.CurrentMode = FormViewMode.Insert) And Not IsPostBack Then
vInspectorList = DirectCast(FormViewHydInspection.FindControl("DDlstInspBy"), DropDownList)
vInspectorList.Items.Clear()
Dim vInspectorDA As New DataSetHydrantsTableAdapters.TechnicianTableAdapter()
Dim vInspectors As DataSetHydrants.TechnicianDataTable = vInspectorDA.GetTechnician()
Dim vInspRow As DataSetHydrants.TechnicianRow
Dim vInspectorHT As New Hashtable
vInspectorHT.Add("0", "Select Technician")
For Each vInspRow In vInspectors
If vInspRow.TechID <> 0 Then
vInspectorHT.Add(vInspRow.TechID.ToString, vInspRow.TechName)
End If
Next
vInspectorList.DataSource = vInspectorHT
vInspectorList.DataTextField = "value"
vInspectorList.DataValueField = "key"
vInspectorList.DataBind()
End If
End Sub
I tried populating the listbox directly using the Listbox.Items.add() method (which is the way I have it now so I could continue solving other problems, and it works!) but I could not find a way to add a value pair. I did try:
vInspectorList.DataTextField = "Select Technician"
vInspectorList.DataValueField = "0"
but that left a listbox without any data.
Is it possible to populate a listbox from a textbox on another form? Ive tried searching google but have had no luck.
View 6 RepliesI have a SQL Datasource populating a Drop Down List with Company Names. The Select Statement the Datasource uses selects Company ID and Company Name.When a company is selected from the list, there is a button on the page to continue processing with the selected company. On the press of the button, I want to set a session variable for the Company ID of the Company selected. This Company ID is obviously held in the Datasouce. Any idea how I get at the Company ID.My code will look like the following:Session.AddsessCompanyID", ????????????)where ?????????? represents the source of the Company ID.
View 5 RepliesI am getting an error "Unable to cast object of type 'System.Int32' to type 'System.String'."when attempting to loading data from a stored proc. My database code is
[Code]....
[Code]....
I need to populate a text box from a stored porcedure call that does not have any parameters. I've made the database connection and am executing the stored procedure, but I cannot figure out how to set a text box value to the return value of the stored procedure. BTW, the stored procedure only returns one value.
View 2 RepliesHere is what I have tried:
txtCost.Text = string.Format("{o:c}", dr["Cost"]);
Here is the error I receive. How can I format the data that is coming from the data reader into currency format??? Also, is there a way to format it into currency without the dollar sign?
Input string was not in a correct format. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.FormatException: Input string was not in a correct format.
I'm looking for a steer on how to go about running stored procs efficiently.
I have a current requirement to populate a control, so I have all the specific data i.e the parameter value I need to pass and the control I want to populate, plus generic data such as SqlConnection etc.
I'd like to be able to call, say, "MyStoredProc". MyStoredProc would contain all the necessary information to run the proc, but then pass onto a method, say, GetSpData, which contained all the generic stuff about running stored procs.
Then when setting up MyStoredProc2 I could do without repeating a lot of the original function
Im I barking up the wrong tree or is there an efficient way of managing this kind of situation.
I am trying to populate table column names into a dropdown list . how can I query using Linq to SQL to just get the list of few Column names ? in a method in DAL which I can use to load in my UI page !!
View 2 RepliesI need to populate a listbox with queries from 2 sql tables, but I can only see how to populate it with 1 datasource.
Do I need to do some hand coding? If so, where should I put it?
I'd also like to add some text items to the listbox so I could say populate the listbox with a query, plus an "other" option, so that if "other" is selected, a textbox will appear that will let the user specify a new item.
(ie.)C-Chennai
B-Bombay
-Hydrabad
A-Andhra
K-Karnataka
It may comes any order but (cbhak) is constant. i need to bring this in query, i dont want to use any funtionHow can i acheive this result
Tag TableName FieldNameabc wc s_namelbl wc s_deslb2 wc s_prodin above fieldname(s_name,s_des,s_prod) column represent field in wc table.How can i bring this result. is this possible without using cursor. i was struggling past two days. i cant able to bring result for above.
View 17 RepliesHow can I get the result with decimal place? The following will return 33.00, but how can I get the result of 33.33?
[Code]....
Table: ITMLED
Recsno itmcod opeqty inwqty isuqty
6200 001 500 NULL NULL
442 001 NULL NULL 100
22 001 NULL 700 NULL
23 001 NULL 500 NULL
443 001 NULL NULL 400
How do I get itmcod wise result in 1 row like
ITMCOD, OPNQTY, INWQTY, ISUQTY, ((OPNQTY+ INWQT) - ISUQTY) AS CLOSINGQTY
001 500 1200 500 1200
From above data in ITMLED.
How can I do this? I want to display result even if one value is just present. I've tried messing with the logical operators but still can't get it. Here is my SelectCommand.
[Code]....
I have the following code which writes to a Gridview:
[Code]....
Using the same methods of connecting to the database, how can I amend this code to write the result of a second query (which only returns a number) to a label?
I have one sproc with Dynamic Temp Table. Sproc returns dynamic temp table rows and when I drag and drop the sporc on to Linq to Sql Designer I am not getting Return Type as "(Auto-generated Type).
how can I get Return Type as Auto-generated Type.
I have a table that contains a date column along with others. I need to extract two sets of data from this table for two different time periods. Call them Current and Previous, so that I can compare them line for line. There are exactly the same number of days in both time periods.
The problem is that I need to return the data like this:
CurrentDate, Count(CurrentItems), Sum(Amt), Count(PreviousItems), Sum(PrevAmt)
JOIN puts the data into the result vertically, so that doesn't work. So far, I have not found a method that will arrange the data correctly.
how to wrote stored procedure for check two queries result this result is same return true value its not same return false value
View 2 RepliesI'm programming a webpage in ASP.NET which displays a list of students not listed as participants in something, and upon clicking a student name shows you a brief summary of their details, so the user can ensure they're selecting the right person. Each student is identified by a unique ID.
My code currently correctly obtains their ID, adds it as a parameter to my stored procedure and executes the procedure;
[Code]....
However, when I try to access the results, with say dv.Table.Rows[0], I get the following error:
[Code]....
Upon debugging, there don't seem to be any results returned... when running just the stored procedure in SQL Server with the same data, it does return a single row, as expected.
I am bulding a dvd catalog and have a table called DVD which holds all my details about each dvd except Genre, Director and Actor as I want more than 1 Genre, Director, Actor per DVD so put these in seperate tables to avoid repeating the data and used a joining tabe to join the tables so the tables I have are
DVD, Genre, Director, Actor, DVDGenre, DVDDirector and DVDActor
I have now written a stored procedure to pull the info about 1 DVD out of all the tables to display on the webpage I have now got the info I want out of the tables but as the data is now in 1 table I have repeating data is there a way to stop the data repeating the stored procedure i have written is
[code]....