Forms Data Controls :: Using AND / OR Parameter From A DropDownList In A SqlDataSource
Jan 29, 2010
I am facing a small issue in using a DropDownList that has only two values (AND and OR) which i want to use to configure a SQL Query in a SqlDataSource. How can i use this thing by passing the value in a SqlDataSource Select Query in such a way to Bind the Result to a GridView. I want something like this -
SELECT [somefields] FROM instinvoice WHERE Namen = @Namen @Option InvoiceNo = @invoiceno where @Namen is from a DropDownList and InvoiceNo is from a TextBox
I m having a problem in specifying this @Option parameter from a DropDownList which contains only two list items - AND and OR. On the Basis of the Selected Value from this DropDownList i want to execute query like
SELECT [somefields] FROM instinvoice WHERE Namen = @Namen AND InvoiceNo = @invoiceno
or
SELECT [somefields] FROM instinvoice WHERE Namen = @Namen OR InvoiceNo = @invoiceno
Using the Query with @Option gives me a Parsing Error. Why is that so. How can I implement this scenario.
I use SqlDataSource control to list out search result when user choose a date, but if the date is null, then it will list out all record. How to do the sql command? Â SELECT Ref_No as name, Job_Order_ID as value FROM Job_Order WHERE (Status <> 'JO_Completed') AND (Delivery_Date = @jaDate) OR (Status <> 'JO_Completed') ORDER BY Ref_NoÂ
I have a Stored Proc which uses a field in the database. that ends up being the user.identity.name. So, when the page loads, it grabs that name and uses it in the stored proc, which I'm which I'm wanting to designate in the sql datasource. But it only gives me choices of querystring, cookie, session, control, etc. My question is how to reference that variable as the parameter in the datasource?
I have a Detailsview grid with an SqlDatasource, this DVG is only going to be used to insert records. The primary purpose of the DS is to populate a DDL control in the insertItem Template that I created my code is this:
[Code]....
The DDL control populates correctly, but when I try to modify the INSERTCommand property in my DS, I try to assign the value to my parameters "TesterID" and "TesterDate" but the only options for controls to pick from, is the DGV but not the DDL in it. I assume it has to do with the InsertItem template but even if I reset it I still cannot pick the textbox as a control that would give the value to my parameters.
I did find a workaroun by build a public method and calling it in the onclick event of the insert button but looks like I have to create another connection to the database which to me seems unnecessary since I already have a DS and everything. how can I do this without having to use my method. here is my method just in case.
I need to pass a user selected value from a databound DropDownList into a GridView SQLDataSource select statement so the correct records will be selected. I have found lots of documentation on DropDownLists and sqldatasources but nothing that connect the two.
I am trying to use a DropDownList in a DetailsView for the ItemTemplate, InsertItemTemplate, and EditItemTemplate. I must bind this DropDownList to a SQL-Server support table using a function that returns a DataTable. I am not allowed to use a SQLDataSource in my backwards IT department. So, not only do I need to load the DropDownList, I also need to make the SelectedValue equal to the current record that I am viewing, editing.
I have a dropdownlist that's being populated from a SQL datasource. I would also like to have a tooltip for each dropdownlist list item on mouse over. I found the example below which adds a title attribute for each list item using the listitem text as a tooltip but I want to make the title/tooltip value another field in the database. In other words,
I have ASPxDataView and ASPxRadioButtonList within item template. i also have two SQLDataSource's (first fill ASPxDataView, second ASPxRadioButtonList). They are using other database tables connected with the foreign key. Is there any way to pass parameter to my second sqlDataSource (id) to fill RadioButtonList property ? i mean select * from TABLE2 where id = @id ; (@id is a value from TABLE1 which is a value of column returned by first sqlDataSource)
in my asp.net+access web code in vb. There is three labels named (tata.text,tvs.text,msu.text) is there any option on clicking on the label named tata.text the data pertaining to tata be displayed in a gridview in another page or a popup display in same page.
I have a catalog function whereby user can filter their selection by clicking radiobutton. For example, by selecting the Dining radiobutton, all packages related to dining would appear.And i using DataList1.Items. Count method to count the number search result. I had implement this method in the page_load, however the value of the number of datalist keep displaying previously loaded datalist. Here is my code :
Two ddl inside gridview. on selecting first ddl1 fill next ddl2 by passing selected value as parameter by executing the sqldatasource select command in codebehind.code:
GridViewRow gr = (GridViewRow)((DataControlFieldCell)((DropDownList)sender).Parent).Parent; //find the control in that DropDownList d1 = (DropDownList)gr.FindControl(ddl1); DropDownList d2 = (DropDownList)gr.FindControl(ddl2); SqliaDataSource.SelectParameters.Add("@name", d1.SelectedItem.Text.ToString()); dataView dv=(dataview) SqliaDataSource.select(DataSourceSelectArguments .Empty); Error: There is no source code available for the current location. and Returns null value
I have a series of dropdownlists on webform in ASP 4.0. The first drop down is filled upon load, and then when a user selects a value from that list, it populates the second dropdown. To accomplish this, I have a SQLdatasource with a parametersource of the first drop-down list control. This works great, except when a user changes their selection from the first drop down. It performs the query, but then adds the list of items to the ones that were already there from the previous selection, instead of replacing it with the new data. Here is the code:
[Code]....
Do I need to do something on selectedindexchanged to somehow "clear out" the previous datasource? I can't find anything about this online, although one person seemed to suggest it was related to using a master page. (which I am using).
I am trying to select a value, automatically, out of ddlCounsellorNameb by selecting a value in ddlCounsellorID. I've been getting a databinding error whenever the first dropdownlist posts back. How do I do about this without getting an error?
I have a gridview with some text-box columns and one dropdownlist-column (Templatefield).
With the dropdownlist i wan't to be able to edit a cell in a row. I have read a lot on the web and i have folowing code. I only get a parameter error now, before i added the dropdownlist everything was ok.
This is my html:
[Code]....
This is my update-command in the class "TransactiesDAO"
[Code]....
Look at the line:
[Code]....
in the aspx code. I don't now what to type in the "Bind(...)" text.
With above i get error: Message=DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'Subrubriek'. when trying to update the row.
When i delete the line "SelectedValue=" then i get folowing error:
It gives me folowing error:
ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'UpdateTransactie' that has parameters: Rekening, Omschrijving1, Omschrijving2, Boekdatum, BedragBij, BedragAf, Subrubriek, @ID_SR, ID
I've been struggling with trying to figure out how to do this for about 2 weeks now. I have a DetailsView with several template fields in it. The first field (Unit_Code) is a dropdownlist item where the user would select a Unit based off the Unit_Code's Unit Name. Further down I have a field named (System), system needs to get it's value from the selectedvalue or selectedindex that the user selected in the (Unit_Code) dropdownlist. I have another dropdownlist item (Component) that will need to get the selected value from System to sort on, so once I have the first Unit_Code to System figured out I should be able to figure out the System to Component part seeing as it will basically be doing the same thing.
Singles and suppers are money fields for the price of same item. A bit like the price of a Small, Medium or Large item. What I would like to do is display the 'Singles' price and 'Suppers' price in seperate listitems so the user can choose 1 of them.
GridView: Traditional Name__________Size Chicken-------------------[DROPDOWNLIST]
DropDownList: Price of Single is: £1.50 Price of Supper is: £2.50
My page loads up with the correct items in TraditionalName colum but the DropDownList is completely empty. I'm aware I don't have anything in for DataValueField and DataTextField but I have tried putting things in these attributes, like Suppers and Singles, but nothing works, so I have taken them out below.
during edit mode i populate the drop down in question with data based on a value selected in another drop down also in the gridview, all works find, but the paramater is not being updated with the selected value, i think this is because i do not call any Bind in the aspx side.
I have 2 dropdownlist(ddlCategoryFooter and ddlItemCodeFooter)inside my gridview. I want to set ddlItemCodeFooter 's datasource to my getItemList(decimal categoryID) method. The selecteditem of ddlCategoryFooter will serve as the paramter which will be passed to my getItemList Method. Basically,ddlItemCodeFooter is dependent on ddlCategoryFooter's selectedItem.
I know it can be done in code behind approach but i prefer to place it in my asp page.
I have an SqlDataSource query that should use an input parameter for multiple integer values, like:
select * from table1 where TableID IN (1,2,3,4,5)
->
select * from table1 where TableID IN (@IDValues)
How do I do that ? Default parameter settings won't work, returning "invalid integer value" . I suppose that parameter should be passed as some kind of array that SQL recognizes as multiple integer values , but what's the correct way of setting this ?
