VS 2008 / Gridview Control - Update Error - ORA-01008 - Not All Variables Bound
Jul 29, 2011
I have a simple gridview control. It has edit and cancel buttons for each row. User's can click on edit column and edit a row and click on save to save the record.
When the user clicks on save we get the error: ORA-01008: not all variables bound
User is allowed to edit only 3 fields and rest of the fields are only readonly. For those editable three fields, I am using EditItemTemplate. ASP.net doesn't throw any errors for the first two edititemtemplates. The problem comes only with the third field which is "BSIS Type". I tried to figure out almost 5 hours and don't know what to do.
This the code I have:
HTML Code:
<asp:GridView ID="GridViewActualsMapping" runat="server"
HeaderStyle-BackColor="#444444"
HeaderStyle-ForeColor="White"
Font-Size="10pt" Cellpadding="4"
AutoGenerateColumns="False"
[code]....
Error is:
HTML Code:
ORA-01008: not all variables bound
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.Data.OracleClient.OracleException: ORA-01008: not all variables bound
I have a gridview control on a .aspx page. It is a bound control. So basically I didn't have to write any code to pull the data from database and show it on the grid.
So far so good. But where is no data is not returned from the database, I want to display something on the page saying "No data returned". But I don't know which gridview control event gets fired so that I can write some code in it to check if the records returned are zero.
I'm hacking my way through ASP.Net WebForms, coming from VB.Net WinForms. I was hoping the transition would've been more seamless... it is not.
I have a GridView (Paging enabled) bound to a DataTable, filled with Joined tables from an Access 2000 DataBase.
The GridView and DetailsView are bound to the same DataTable.
In the GridView's SelectedIndexChanged Event I have the following:
vb.net Code:
' dtvSelected is the DetailsView' dgvJobTOF is the GridView Me.dtvSelected.PageIndex = Me.dgvJobTOF.SelectedIndex
When the page loads the first item in the GridView is also displayed in the DetailsView.
I've added a "Select" button in the GridView and when it is clicked the Data in the DetailsView remains the same regardless of the selected GridView row.
I am trying to create a bound column and bind the data with the below piece of code . And the column has two files Name and Fee but the code binds only the Fees column and Name column become empty..
Code: using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls;
I've been working on this error all day! I have a dataview created from a sqldatasource control and I'm trying to assign it to a gridview but I get Object reference not set to an instance of an object. Code: Try Session("dsCustomer") = "Y" [code]......
Can't I assign a dataview as a datasource? Or not?
I am having a hard time updating from my gridview based the value that I am setting in the datakeynames it is the Ucc field I keep getting and index out of range exception on the e.keys[0]. I have done this before so I am confused what I am missing here.
Bug: UPDATE command Does NOT Work as Expected on a DataBound GridView This was tested in VS2005 and VS2008
Took a while to figure this out - A simple recurse thru Page Controls Makes UPDATE Not Work as expected.
To Recreate this bug:
A simple Gridview bound to an Objectdatasource on a page with ALLOWEDIT ALLOWDELETE
If one inserts some code (a function call in my example) that just recurses the PAGE controls in either the PAGE_PREINIT, PAGE_INIT, PAGE_INITCOMPLETE events,
Then the UPDATE does not FIRE! and After Pressing UPDATE the GRID does not BIND! You Get A Blank Page - Funny thing tought it's only the UPDATE Functionality that gets affected by this - Everything else works fine including EDIT & DELETE.
If the same function call (recurse thru page controls) is added in the PAGE_PRELOAD, PAGE_LOAD -- Then the UPDATE starts working again as expected.
BELOW Is SAMPLE Code using the NORTHWIND DB Products Table and a Typed DATASET.XSD - You can use your own datasource for the ObjectDatasource - (Note I took out the Foreingkey constraint in products table from Nortwind for delete to work)
NOTE: One should be able to just cut and paste the function PAGECONTROLS_RECURSETEST on any working form that has a bound Gridview with Update functionality and you should be able recreate the bug that way by calling the function from the different page_events
I've been working on a webform to pull data from an oracle database v10. I can create a gridview1 with Selection enabled and it will populate with data without a problem. However when I create a second gridview and bind with a control to the first gridview, I get the following error at runtime when I click on one of the Selects.
I have an Objectdatasource configured with Select, Insert, Update & Delete queries in a Dataset. This datasource is linked to my Gridview. I do not require all fields in the table to be displayed or updated in my grid so i have turned off the Visible property on several.
However, when i go into Edit mode and trigger the UPDATE to the database table, i get NULL values updated in the columns i set False for the Visible property.
How can i remove these columns from the GridView and the Edit mode and still have them UPDATE with their current values instead of being overwritten with NULL's?
The first page show up just fine, when i try to go to the second page of the GV i get this errorThe GridView 'GVCreditMemos' fired event PageIndexChanging which wasn't handled.
I have designed a gridview one of the fields of which I want to send the user to an URL onclick. After browsing the net for a while, I opted for converting the BoundField to a TemplateField. The same OLAP metric ([Measures].[GP]) works fine in the bound field yet produces an error in the Template:
I have the absolutely most simple setup imaginable. A single table defined in an Entity model in ASP.net v4, the model is bound directly to a GridView with AutoGenerateEditButton enabled.However, each time I hit edit, then save, the page throws the error "Update is disabled for this control" for which I cannot find a solution.What is causing this error? What can do to resolve it?
I have a 3 level deep nested gridview. The expansion/contraction of each record was originally done with javascript. There were html <div> tags around each gridview. Since these were HTML div tags I could give them IDs that were dynamically bound to record ID value within the database. I then had onclick buttons that passed in a bound record ID value that coresponded to the appropriate div tag that needed to be expanded (e.g. display: inline (show it) or if it is already inline then display: none).
This worked beautifuly. Unfortunatley I wanted to be able to do in-girdview editing of the child records. When expands a parent record and clicks to edit a child record the OnRowEdit event fires which automatically generates a postback and resets the variables within the JavaScript. THEREFORE THE ENTIRE GRIDVIEW STATE BECOMES CONTRACTED.
So finally I decided to change the div tags to <asp: Panel> and the onclick images to .net clickable images (all .net objects no framework). This works because the state is remembered within each postback. However, the problem I'm having is I can't dynamically bind ID's for panel since this is not allowed. HOW CAN I GIVE THE PANEL <% Bind("id") %>. THAT I CAN REFER TO SO I CAN OPEN THE APPROPRIATE PANEL.
I have a gridview on a tab panel in my form. Once a user edits a field I write a record to a history table. So I do a save using a Page Method once a user clicks Save. After this save I want to refresh my gridview to show the new record. How can I do this using Jquery maybe?
I have a situation where my session variables seem to get corrupted. I Page_Load I am calling 2 subs. Each of them fills a GridView with data from a table. I am saving the content of each Data.DataTable into Session Variables:
After I call the 1st sub and I debug the session variable "mySqlDataTable1" contains all the data from the table. After I call the 2nd sub and I debug the session variable "mySqlDataTable1" has been changed and contains a mix of data from the 2 tables.
as we do in desktop app, can we use global variables in a web app. it must be client side.
i hv created a class to handle global variables, but the issue is with it. if other user login on another pc at d same time, the variable got re-initialized. i want they must be client/ user specific.
I use the sqldatasource control a lot with stored procedures. But this time I'm using some code I found online where I am defining the new sqldatasource in the code and using it. You can see this below. I am getting a NullReferenceException on the first SelectParameters line and not sure why. Do I need to add the parameters different?
Code: Dim SqlDataSource As New System.Web.UI.WebControls.SqlDataSource() SqlDataSource.ConnectionString = ConnectionString SqlDataSource.SelectCommand = "MySprocName" SqlDataSource.SelectCommandType = SqlDataSourceCommandType.StoredProcedure SqlDataSource.SelectParameters("Distance").DefaultValue = 25 SqlDataSource.SelectParameters("ZipCode").DefaultValue = "31410" Dim arg As New DataSourceSelectArguments() Dim dv As System.Data.DataView = DirectCast(SqlDataSource.[Select](arg), System.Data.DataView)
I would like to put a value in web.config file in my project and read it programatically from .aspx page.Under which section of web.config file should I save the value. This is not a connectionstring. It is path of a file. And I how can programmatically read the value in the code?I am using C#.
I have a Sql string something like this.string sqlstring = "Select field1, field2 from table1 where field1 = 1 and field2 = 'xxx' group by field1, field2 order by field1 asc" Question: During runtime, based on the user selection, I have to replace 1 and xxx in the sql string.What is the best way to do this?
I want to show the data either in Chart control or Gridview control. When the user selects an option to see the data either in chart control or grid view control, that specific control has to show up and other control has to become invisible.
So far, I am able to populate data successfully in the chart control. If the user chooses "Grid view" option, how can I show the data in grid view control in the same location. I don't want the gridview control to be shown in a pop up window or any other window.
I typically don't use the sqldatasource control but trying it out and can't seem to get the delete function working. It doesn't seem to be passing a parameter to my stored procedure. The error I get is: Procedure or function 'sp_DeleteCraigsListEntry' expects parameter '@craigslist_search_id', which was not supplied. Any thoughts?
I have a TextBox in a nested FormView that I want to use for entering a date. I have added a calender extender to the TextBox and I want to set TextBox to read only so that the date can only be entered by using the calender extender. This way I can avoid improper date formats.
The problem is that when I enter a new date and click the Update button, the new date is not saved to the database. I have done some searching on the WEB for a solution, and I found that "Page.Form.SubmitDisabledControls = True" is used in the Page_Load event to solve this problem. I have tried this and it does not work.
Another solution that I have seen is to set the control to readonly at runtime in the FormView "ItemCreated" event. I have been unable to access the "ItemCreated" for this FormView because it is nested.
Usually using Visual Studio's debugger is a breeze. Scanning through Locals quickly shows the values of variables, etc. However, I'm at a loss how to find out the values contained in session state variables? Can anyone give me a hand?Lets say I put a breakpoint right after:
Session("first_name") = "Rob Roy"
How do I view the value contained in Session("first_name") from locals?
I am getting "ASP.NET Session Expired" error when viewing SQL Server 2008 reports using the Microsoft ReportViewer web control. I found this article http://balanagaraj.wordpress.com/2009/09/25/session-has-expired-in-asp-net/ which suggests to use one worker process in IIS application pool, but that may affect performance, is there any other solution for this? I tried setting "AsyncRendering" to false already and that didn't work.
i am looking for a easy & elegant way to change my appsettings in web.config based on the different environment and i have (dev/qa/test/stage/prod) and i am manually changing the appsettings and its very tedious and time consuming and i have about dozens of settings.... what is the best approach for this kinda situation? i know one solution using Environment variables but wants to hear the best practice?