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
Similar Messages:
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
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
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
Nov 18, 2010
[Code]....
Forms Data Controls :: Failed to convert parameter value from a DataControlFieldCell to a String - GridView Error?
View 6 Replies
Jan 6, 2010
I have create a grid view with a dropdownlist for one of the columns. This works fine, but when I click edit and then update I get an error saying it cant update due to null value. I'm sure it because the parameter in the update of SqlDataSource1 is not referring to the value select in the edit item template, but I cant figure out how to do this.
My code is below.
<asp:SqlDataSource
ID="SqlDataSource1"
runat="server"
ConnectionString="<%$
ConnectionStrings:BlazeBillzConnectionString %>"
SelectCommand="SELECT
[Prod_Sold_ID], [Order_Date], [Billing_Period] FROM [ProductsSoldTable] where Prod_Sold_ID < 130"
DeleteCommand="DELETE
FROM [ProductsSoldTable] WHERE [Prod_Sold_ID] = @Prod_Sold_ID"
InsertCommand="INSERT
INTO [ProductsSoldTable] ([Order_Date], [Billing_Period]) VALUES (@Order_Date, @Billing_Period)"
UpdateCommand="UPDATE
[ProductsSoldTable] SET [Order_Date] = @Order_Date, [Billing_Period] = @Billing_Period WHERE [Prod_Sold_ID] = @Prod_Sold_ID">
<DeleteParameters>
<asp:Parameter
Name="Prod_Sold_ID"
Type="Int32"
/>
</DeleteParameters>
<InsertParameters>
<asp:Parameter
Name="Order_Date"
Type="DateTime"
/>
<asp:Parameter
Name="Billing_Period"
Type="Int32"
/>
</InsertParameters>
<UpdateParameters>
<asp:Parameter
Name="Order_Date"
Type="DateTime"
/>
<asp:Parameter
Name="Billing_Period"
Type="Int32"
/>
<asp:Parameter
Name="Prod_Sold_ID"
Type="Int32"
/>
</UpdateParameters>
</asp:SqlDataSource>
</div>
<asp:GridView
ID="GridView1"
runat="server"
AutoGenerateColumns="False"
DataKeyNames="Prod_Sold_ID"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField
DataField="Prod_Sold_ID"
HeaderText="Prod_Sold_ID"
InsertVisible="False"
ReadOnly="True"
SortExpression="Prod_Sold_ID"
/>
<asp:BoundField
DataField="Order_Date"
HeaderText="Order_Date"
SortExpression="Order_Date"
/>
<asp:TemplateField
HeaderText="Billing_Period"
SortExpression="Billing_Period">
<EditItemTemplate>
<asp:DropDownList
ID="DropDownList2"
runat="server"
DataSourceID="SqlDataSource5"
DataTextField="Discription"
DataValueField="Bill_Per_Id"
Height="17px"
Width="134px">
</asp:DropDownList>
<asp:SqlDataSource
ID="SqlDataSource5"
runat="server"
ConnectionString="<%$
ConnectionStrings:BlazeBillzConnectionString %>"
SelectCommand="SELECT
[Bill_Per_Id], [Discription] FROM [Billing_Periods]">
</asp:SqlDataSource>
</EditItemTemplate>
<ItemTemplate>
<asp:DropDownList
ID="DropDownList1"
runat="server"
DataSourceID="SqlDataSource2"
DataTextField="Discription"
DataValueField="Bill_Per_Id"
Height="19px"
SelectedValue='<%#
Bind("Billing_Period") %>'
Width="171px">
</asp:DropDownList>
<asp:SqlDataSource
ID="SqlDataSource2"
runat="server"
ConnectionString="<%$
ConnectionStrings:BlazeBillzConnectionString %>"
SelectCommand="SELECT
[Bill_Per_Id], [Discription] FROM [Billing_Periods]">
</asp:SqlDataSource>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField
ShowEditButton="True"
/>
</Columns>
</asp:GridView>
View 1 Replies
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
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
Nov 25, 2010
how to passing dropdownlist value as parameter to another page?
View 3 Replies
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
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
May 25, 2010
i have two tables in my database, product(productid as pk) and productdetails(productid as fk), in a relationship.i have dropdownlist which on pageload displays data from my product table, showing all product name. AutoPostBack enabled. Its working fine.i have a gridview which should display the productdetails data when i select a value from my dropdown list.i have written the code for the gridview on the selected_index_change event of the drop down list, please correct me this is wrong;here is the code;
Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles
DropDownList1.SelectedIndexChanged
Dim ConString As String [code]...
so when i select the value in the dropdownlist i get this error .Must declare the scalar variable "@ProductID".
View 7 Replies
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
Aug 2, 2010
I have an user control placed on a content page. The content correctly receives the session variables. In the user control I have the following
1. The pageload fires and the text box is correctly set.
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
if (Session["app_id"] != null)
{
txtAppId.Text = Session["app_id"].ToString();
}
</script>
2. I have datagrid in the usercontrol which has a binding variable tied to a control parameters as follows
<asp:SqlDataSource ID="SqlDataSourceMain" runat="server"
ConnectionString="Myconnectionstring"
ProviderName="MyProvider" SelectCommand="select
last_name,first_name
from applications
where (id = to_number(:pAppId))">
<SelectParameters>
<asp:controlparameter name="pAppId" controlid="txtAppId" propertyname="Text" />
</SelectParameters>
<SelectParameters>
<asp:controlparameter name="pAppId" controlID="txtAppId" propertyname="Text"
Direction="InputOutput" Type="Int32" ConvertEmptyStringToNull="True" />
I tried the following, same error
</SelectParameters>
<asp:SessionParameter
ConvertEmptyStringToNull="True"
DefaultValue="0"
Direction=" InputOutput "
Name="pAppId"
SessionField="app_id"
Size="integer"
Type="String" />
</asp:SqlDataSource>
For some reason the select parameter pAddId is getting set to null and get the following error when the content page is loaded If I hard code the value it works RA-01036: illegal variable name/number 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: Oracle.DataAccess.Client.OracleException: ORA-01036: illegal variable name/number
View 1 Replies
Jan 7, 2011
I am trying to pass a URL parameter to a web page that contains a Gridview to make that query dynamic
The URL is http://localhost:3036/people2.aspx?ArvDate=01/03/2011
I would like to add that parameter to the Select statement below (bolded)
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:sqlConnection %>"
SelectCommand="SELECT NumPeople, Date1,Time1,Venue FROM People_Count WHERE Date1=XXXXXXXXXX and c
I already have this code to capture from the URL
Dim strPar As String
strPar = Request.QueryString.Item("ArvDate")
If strPar = "" Then strPar = DateTime.Now.ToString("d") [code]....
I just don't know the syntax to get it in that SQL Select statement
View 2 Replies
Sep 3, 2010
I have grid view and i want to pass parameter value for it from where clause...
my parameter value is not control, or session or cookie.its a variable ...how can i pass this variable to grid view parameter?
View 6 Replies
Mar 22, 2011
I have a [Code]....
with showing all A table C column.
[Code]....
My A table has two column.
B-->Primary Key
C--> Every C has a unique B.
I have an SQL like this for my Gridview Source;
[Code]....
Something like that. My SQL syntax isn't very well. I hope i can tell what i want..
What REALLY want is, When i click a button, showing in Gridview with second SQL , BUT only i selected in CheckBoxList.
Is there any way adding to parameter in SQL? How can i do that?
View 8 Replies
Jun 7, 2010
When a gridview is rendered, its RowCreated event is called. When it is called, what is contained in the second parameter which is of type System.Web.UI.WebControls.GridViewRowEventArgs ?Means, which type of information can we get from that ?
View 2 Replies
Jun 1, 2010
here's my url: http://nathan/mail/incomingmail.aspx?dc=8250&bg=-617370170
gridview code:
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
BackColor="White" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px"
CellPadding="4" DataSourceID="SqlDataSource1" [code]...
View 1 Replies
Nov 21, 2010
In my application i need to filter a gridview using four or five parameter.
View 3 Replies
Feb 23, 2010
I have a cell where I will display an url with an xml as parameter. Currently this shops of the Gridview dispaly, the html table that is generated can not correctly be read by the browser.
Do I have to encode my string, the HTML encode mehtod? Or do some other action?
View 1 Replies
Sep 7, 2010
My issue is similar to [URL] how-to-use-the-value-of-a-selected-value-from-a-dropdownlist-populated-with-ajax but I am using ASP.NET, not PHP. I have a dropdownlist that is populated by another dropdownlist's current value through ajax. So if DDL A is 'NY', DDL B is populated with different data relating to 'NY'. I need that data to be posted back to the server because this affects an SQLDataSource parameter. However, as far as I can tell, the value is always null after postback resulting in the gridview to be empty.
View 1 Replies
Sep 20, 2015
I am binding a control which is inside Gridview, using SqlDataSource control as below.
<asp:ComboBox ID="ddlCompany" runat="server" Height="200" Width="240"
DropDownWidth="310" EmptyMessage="- Select Product -" HighlightTemplatedItems="true" CausesValidation="false"
Filter="Contains" AppendDataBoundItems="true" AllowCustomText="true" AutoPostBack="true"
DataTextField="Title" DataValueField="Code" OnSelectedIndexChanged="ddlCompany_SelectedIndexChanged">
</asp:ComboBox>
[code]....
In above SqlDataSource control, I had to pass the SelectParameter (whose value is coming from a ComboBox i.e., whatever comboBox value I selcect from ComboBox, its SelectedValue I had to pass it to the SqlDataSource SelectParameter. I am first time using "SqlDataSource". How to pass the SelectedValue of ComboBox into SlecteParameter of SqlDataSource control ?
View 1 Replies
Jul 27, 2010
I am defininging all my sqldatasource select parameters upfront in the .aspx file. Then based on user filter choices, I modify the Select Command to include those parameters. Works fine, but when I add one of these parameters, the bound grid doesn't pull back any results. No error message is given.
If I remove the ToteID control parameter line below, everything works fine. But with it in, the SQLDataSource.Selecting event doesn't even fire.
[Code]....
[Code]....
View 7 Replies
Feb 7, 2011
i have been learning asp.net 3.5 and i have ? if someone could help me out
i have a datagridview using a sql database and using textbox lastname
i have been trying to setup a second textbox for first name
what im trying to acomplish is being able to populate the gridview if only one textbox has a name in it
it works fine if i put in a first name in textbox1 and a lastname in texbox2 if i leave one textbox empty it want populate nothing.
View 5 Replies
