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.

View 3 Replies


Similar Messages:

Data Controls :: SqlDataSource Populate Dropdownlist With Or Without Parameter?

Aug 14, 2013

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 

[Code].....

View 1 Replies

Forms Data Controls :: Sqldatasource Using Variable As The Parameter (username)

Jan 19, 2011

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?

View 3 Replies

Forms Data Controls :: Use Control Parameter With SQLDataSource When FindControl Is Required?

Nov 21, 2010

How to use Control Parameter with SQLDataSource When FindControl is required?

[Code]....

View 1 Replies

Forms Data Controls :: Add Detailsview Old Values As A Sqldatasource Update Parameter?

Jan 9, 2010

I have a details view that is bound to a sqldatasource. The datasource has some extra parameters besides the updated data on the screen, they are;

[Code]....

I am want to take the old values of the details view from the detailsview1_itemupdating event and add them as a parameter to my sqldatasource.

[Code]....

So how can I then add this as a parameter to my sqldatasource?

View 2 Replies

Forms Data Controls :: Getting Data From Control In FormView InsertTemplate To Parameter In SQLDataSource

Jun 14, 2010

I Have an InsertTemplat in FormView that has a DD List.

I also have an Insert Parameter in a SQLDataSource that tries to reference it but can't.

Is my only solution to use event code to move the data to the SQL Parameters?

[Code]....

View 1 Replies

Forms Data Controls :: Assign Values To SqlDataSource Parameter From Dropdown List In InsertItemTemplate

Oct 29, 2010

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.

[Code]....

View 3 Replies

Forms Data Controls :: Passing DropDownList Value Into SQLDataSource?

Feb 11, 2011

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.

View 5 Replies

Forms Data Controls :: DropDownList In DetailsView Without SQLDataSource?

Nov 2, 2010

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.

View 4 Replies

Forms Data Controls :: How To Put Tooltip In Dropdownlist Bind With Sqldatasource

Mar 4, 2010

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,

item.Attributes.Add("title", someotherdatabasefield);

The end result would be something like this where the text for 'title' comes from the database

<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True">
<asp:ListItem Text="CompanyName1" Value="1" title="a really great company" />
<asp:ListItem Text="CompanyName2" Value="2" title="a really bad company" />
</asp:DropDownList>

[Code]....

View 3 Replies

Forms Data Controls :: ASPxRadioButtonList Inside ASPxDataView Within Item Template - Pass Parameter To Second SqlDataSource (id) To Fill RadioButtonList Property

Aug 29, 2010

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)

View 3 Replies

Forms Data Controls :: Calling Stored Procedure Sqldatasource Dropdownlist?

Mar 5, 2010

i try to fill datatextfield and datavaluefield through sqldatasource throuh calling soterd procedure,

but i don't get any value after running the application, here my code

[code]....

View 2 Replies

Data Controls :: Display Data In GridView Using SqlDataSource Filtered Using QueryString Parameter?

May 19, 2013

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.

View 1 Replies

Data Controls :: SQLDataSource Session Parameter Not Filtering Data In DataList

Jul 24, 2012

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 :

protected void Page_Load(object sender, EventArgs e)
{
DataList1.DataSourceID = "SqlDataSource3";
Label1.Text = DataList1.Items.Count.ToString();

[code]....

View 1 Replies

Forms Data Controls :: Binding DropDownList Inside GridView Using Sqldatasource Select Command

Jan 5, 2010

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

View 3 Replies

Forms Data Controls :: Dropdownlist Bound To Sqldatasource Adds Items Instead Of Replacing On Change?

Aug 26, 2010

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).

View 3 Replies

Forms Data Controls :: Pass Parameter Value Of One Databound Dropdownlist To Another

May 24, 2010

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?

[Code]....

View 2 Replies

Forms Data Controls :: How To Passing Dropdownlist Value As Parameter To Another Page

Nov 25, 2010

how to passing dropdownlist value as parameter to another page?

View 3 Replies

Forms Data Controls :: Dropdownlist In Gridview Gives Parameter Error?

Jan 23, 2011

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

View 4 Replies

Forms Data Controls :: Get Dropdownlist Parameter Value From Different Template Field In Detailsview

Mar 22, 2010

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.

My aspx page code is below:

[Code]....

View 4 Replies

Forms Data Controls :: Dropdownlist Won't Display Values In Gridview With Use Of Parameter

Jan 31, 2010

My database has 4 colums;

TraditionalID-------------TraditionalName------------Singles-----------Suppers

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.

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="TraditionalID" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="TraditionalID" HeaderText="TraditionalID" InsertVisible="False" ReadOnly="True" SortExpression="TraditionalID" Visible="False" />
<asp:BoundField DataField="TraditionalName" HeaderText="Meal" SortExpression="TraditionalName" />
<asp:templateField HeaderText="Size">
<ItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2">
</asp:DropDownList>
<asp:HiddenField ID="RowTraditionalName" runat="server" Visible="false" Value='<%# Eval("TraditionalName") %>' />
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:The CodfatherConnectionString %>"
SelectCommand="SELECT Suppers AS Suppers, Singles AS Singles FROM [Traditional] WHERE TraditionalName = @TraditionalName">
<SelectParameters>
ControlParameter Name="TraditionalName" Type="String" ControlID="RowTraditionalName" PropertyName="Value" />
</SelectParameters>
</asp:SqlDataSource>
</ItemTemplate>
</asp:templateField>
</Columns>
</asp:GridView>

View 1 Replies

Forms Data Controls :: Dropdownlist In Gridview Not Populating The Update Parameter?

Nov 5, 2010

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.

<asp:TemplateField HeaderText="Build Types">
<ItemTemplate>
<asp:Label ID="lblBuildTypes runat="server" Text='<%# Bind("BuildType") %>'></asp:Label>
</ItemTemplate>

[Code]....

View 2 Replies

Forms Data Controls :: Pass A Parameter In DropdownList's Datasource Inside The Gridview?

Mar 31, 2010

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.

This i what i want to acheive:

DataSource ='<%# getItemList(Convert.ToDecimcal(ddlCategoryFooter.seletectItem))%>'/>

Source code for my Gridview:

[Code]....

View 8 Replies

Forms Data Controls :: Set Querystring Parameter In Hyperlink From Selected.item.text In Dropdownlist

Jul 9, 2010

I have a HyperLink control in a ListView, and I need to pass a couple of querystring parameters.

[Code]....

The first parameter is based on the current DataItem value in the LV.

Suppose I want to set a second parameter with a value from Selected.Item.Text in a DropDownList on the same page, how would the HyperLink look?

View 4 Replies

DataSource Controls :: SqlDataSource - Parameter For IN() Clause

Apr 30, 2010

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 ?

View 4 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved