HI,
I have a DropDownList populated from database
I use the following code
OracleDataAdapt er ad2 = new OracleDataAdapt er(cmd2, connection);
DataSet ds2 = new DataSet();
ad2.Fill(ds2);
DataView dw2 = new DataView(ds2.Ta bles[0]);
DropDownList2.V isible=true;
DropDownList2.D ataSource = dw2;
DropDownList2.D ataBind();
for (int j = 0; j < DropDownList2.I tems.Count; j++)
{
DropDownList2.I tems[j].Text = iname[j];
DropDownList2.I tems[j].Selected = false;
}
but I get this error :
Exception Details: System.Data.Ora cleClient.Oracl eException: ORA-01008: not all variables bound
Source Error:
Line 136: DataSet ds2 = new DataSet();
Line 137:
Line 138: ad2.Fill(ds2);
Line 139:
Line 140: DataView dw2 = new DataView(ds2.Ta bles[0]);
Source File: C:\Moj\Moi resenija\aplika cija\pmedit0.as px.cs Line: 138
Stack Trace:
[OracleException (0x80131938): ORA-01008: not all variables bound
]
System.Data.Ora cleClient.Oracl eConnection.Che ckError(OciErro rHandle errorHandle, Int32 rc) +203
System.Data.Ora cleClient.Oracl eCommand.Execut e(OciStatementH andle statementHandle , CommandBehavior behavior, Boolean needRowid, OciRowidDescrip tor& rowidDescriptor , ArrayList& resultParameter Ordinals) +1018
System.Data.Ora cleClient.Oracl eCommand.Execut e(OciStatementH andle statementHandle , CommandBehavior behavior, ArrayList& resultParameter Ordinals) +25
System.Data.Ora cleClient.Oracl eCommand.Execut eReader(Command Behavior behavior) +142
System.Data.Ora cleClient.Oracl eCommand.Execut eDbDataReader(C ommandBehavior behavior) +4
System.Data.Com mon.DbCommand.S ystem.Data.IDbC ommand.ExecuteR eader(CommandBe havior behavior) +7
System.Data.Com mon.DbDataAdapt er.FillInternal (DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +141
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet) +86
aplikacija.pmed it0.project(Obj ect sender, EventArgs e) in C:\Moj\Moi resenija\aplika cija\pmedit0.as px.cs:138
System.Web.UI.W ebControls.List Control.OnSelec tedIndexChanged (EventArgs e) +105
System.Web.UI.W ebControls.Drop DownList.RaiseP ostDataChangedE vent() +134
System.Web.UI.W ebControls.Drop DownList.System .Web.UI.IPostBa ckDataHandler.R aisePostDataCha ngedEvent() +7
System.Web.UI.P age.RaiseChange dEvents() +137
System.Web.UI.P age.ProcessRequ estMain(Boolean includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint) +4778
can someone tell me what is wrong?
1 2580
Where is the PL/SQL that's being used by your program?
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Vaap |
last post by:
I am trying to get dataset working through IDbDataAdapter interface as
my solution need to work with Sql Server and Oracle ODP. I am using
different data provider factories and the code here only shows SQL
Server.
My code snippets are
// Build the interface in provider factory (_pf in code below)
public IDbDataAdapter CreateDataAdapter()
{
|
by: Joerg M. Colberg |
last post by:
Hi all,
I have a problem when using a DataSet. I am using it to query a
SQLServer database as follows. In my code it looks like
SqlDataAdapter eDA = new SqlDataAdapter(sqlcmd);
// where sqlcmd is a SQL String
DataSet ds = new DataSet();
eDA.fill(ds);
|
by: Jason |
last post by:
I am having problems understanding how to access a datasource only
once, fill a single dataset, and then reference that dataset multiple
times through different user controls(ascx) found on the same page.
My main page(aspx) contains multiple user controls. The main page also
contains a publicly declared dataset. At the first instance of needing
data I call (from an ascx) a function that fills the dataset and then
returns it to the...
|
by: Bishoy George |
last post by:
I have a dataset called ds1 filled with 2 tables Employees and Customers
from Northwind database.
I have dropdownList called ddLastName with the following properties:
ddLastName.DataSource = ds1;
ddLastName.DataMember = "Employees";
ddLastName.DataTextField = "LastName";
ddLastName.DataBind();
ddLastName.Items.Insert(0,"Select:");
|
by: Stanav |
last post by:
Hello all,
I'm developing a web application using VB.Net 2003 and Framework 1.1. This
application queries an AS/400 database. I'm using the IBM OleDb provider
that came with IBM Client Access for Windows (V5R3). Everything works fine
on my development PC, but when I move the application to a Windows Server
2003, it crashes when trying to fill a dataset. I've double-checked that the
Win 2k3 server does have Client Access installed, that it...
| |
by: Elena |
last post by:
I am trying to get a number from the last row in a table.
When I get to the line of code to get the count, I get an
error:
An Unhandled exception of
type 'System.IndexOutOfRangeException' occured in
system.data.dll
Additional Information: Cannot find table 0
The code is below:
|
by: Dave Edwards |
last post by:
I understand that I can fill a datagrid with multiple queries, but I cannot
figure out how to fill a dataset with the same query but run against
multiple SQL servers, the query , table structure and username, password etc
will be exactly the same for each server, the only thing that will change is
the server name. Idealy I would like to get the server names from a seperate
dataset so there could be any number of servers, allthough in...
|
by: jaYPee |
last post by:
I have a function that call a stored procedure which performs an
insert command. now i want to refresh the dataset so that the newly
inserted data will be available to my datagrid
I have tried to call
DsStudentCourse1.Tables("SchYrSemCourseJoin").Clear()
SqlDataAdapter3.Fill(DsStudentCourse1)
However, the fill method causes a lot of time to process.
|
by: dauphian |
last post by:
Hello,
I am new to .net and am trying to build a report application that
queries 4 different tables based on a id, and I need to return them in
the same table for easy viewing.
Basically, I have one querie that grabs all of the id's I need for the
other 4 queries, but I am not sure how to get them into a DataTable or
DataSet, or if that is the best way to do this. Seperately the queries
all work with no problems.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |