|
OK, I have managed to run this again and avoid the error from the the Al.exe.
|
|
|
|
|
I'm trying to fill a dataset with a DataAdapter.
OracleCommand cmd = new OracleCommand(cmdStr, conn);<br />
OracleDataAdapter oda = new OracleDataAdapter(cmdStr, conn);<br />
DataSet ds = new DataSet();<br />
oda.SelectCommand = cmd;<br />
oda.Fill(ds);
For whatever reason, it gives me this error:
Oracle.DataAccess.Client.OracleException: ORA-00903: invalid table name
Can someone help me?
Stack Trace:
<br />
Line 104: DataSet ds = new DataSet();<br />
Line 105: oda.SelectCommand = cmd;<br />
<big>Line 106: oda.Fill(ds);</big><br />
Line 107: dgWHR.DataSource = ds;<br />
Line 108: dgWHR.DataBind();<br />
[OracleException: ORA-00903: invalid table name]<br />
Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)<br />
Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src)<br />
Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)<br />
Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br />
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)<br />
WhoHasRoutes.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\ferrellgas\whohasroutes\default.aspx.cs:106<br />
System.Web.UI.Control.OnLoad(EventArgs e)<br />
System.Web.UI.Control.LoadRecursive()<br />
System.Web.UI.Page.ProcessRequestMain()
Thanks in Advance
Scott
|
|
|
|
|
Hello,
It is nothing to do with DataAdapter. It seems that the db query contains invalid table name.
According to ora-codes.com
ORA-00903: invalid table name
Cause: A table or cluster name is invalid or does not exist. This message is also issued if an invalid cluster name or no cluster name is specified in an ALTER CLUSTER or DROP CLUSTER statement.
Action: Check spelling. A valid table name or cluster name must begin with a letter and may contain only alphanumeric characters and the special characters $, _, and #. The name must be less than or equal to 30 characters and cannot be a reserved word.
Maqsood Ahmed - MCAD.net
Kolachi Advanced Technologies
http://www.kolachi.net
|
|
|
|
|
My query is a query with a bunch of nested Select statements.
When i run the query in PL/SQL developer it returns results fine. Direct copy / paste.
|
|
|
|
|
Try simplifying the SELECT statement to use fewer nested queries. I don't know for sure, but you might be limited to a single SELECT keyword when using a DataAdapter...? Anyone, feel free to correct me here!
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-- modified at 12:03 Thursday 22nd December, 2005
|
|
|
|
|
Hello,
Can you paste the db query here. There might be something related to string manipulation in C# or .net related issue.
Cheers.
Maqsood Ahmed - MCAD.net
Kolachi Advanced Technologies
http://www.kolachi.net
|
|
|
|
|
My registration page contains fields,register submit button and also a user control inside this page. i have username, password fields and Login submit button in this user control. in both user control and registration page i have used RequiredFieldValidator. so, when i try to login to my application by providing userid and password it is not entering into the application because it is validating registration page required fields and also if i fill all required fields in registration page and when i click on register submit button the records are not saving it is validating login screen required fields. how do i correct this problem? since i cannot validate fields in javascript because it is a multilingual application. pls. help me out.
|
|
|
|
|
Try implementing the validation controls in the user login control itself.
|
|
|
|
|
How can i send and Receive Messages from one application to another or passing a varaible from one application to another
Amit Grover
CDAC R&D
|
|
|
|
|
|
i would like to use winAPI instead of Inter-Process Communication in .NET Using Named Pipes,. plz send me e.g if possible
Amit Grover
CDAC R&D
|
|
|
|
|
A.,
I don't think anyone on this board will give a shrink-wrapped solution to your problem. Interprocess communication can get messy depending on how you implement it. If you don't already understand what you're doing, then you need to get some education regarding the matter.
However, you have a lucky star over your head because I found two articles right here on CodeProject that you can read. You will then know for what you ask and two methods for doing it in the Win32 API.- Interprocess communication tutorial, by Alex Fr
- Interprocess Communication using Shared Memory, by Zoran M. Todorovic
Now that I've helped you find articles, you need to help yourself by reading them.
I gather that you don't know how to make calls to the Win32 API from C#. I will start you in the right direction: search this site or the Internet for "p/invoke". You will find what you need.
Sincerely,
Curtis Schlak.
"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty
|
|
|
|
|
|
i am looking for win32 api functions for send and recieve messages
Amit Grover
CDAC R&D
|
|
|
|
|
|
you have send me the way i can send message to another application. than how can another application receive that message.
Amit Grover
CDAC R&D
|
|
|
|
|
.Net Remoting is the answer if both the applications are written in .Net(which i assume so).
Here is the link for a basic over view of .net remoting Click Here
|
|
|
|
|
i would like to use winAPI instead of remoting and socket programming. plz send me e.g if possible
Amit Grover
CDAC R&D
|
|
|
|
|
I keep hearing people say to use Remoting to send data/messages between two processes/programs/whatever yet everything I've seen talks about running a routine in the server. Nobody talks about how to get the server to respond to a message.
In other words - you have an app that wants to send a message to another app saying 'There's new data available for you.' With remoting you can call a routine on the server but then how does the server know that there's been a change? It seems to me like the only thing you are doing is calling a remote routine but it doesn't provide communication with the host; the routine is segregated from the host.
Am I reading this wrong?
|
|
|
|
|
Hi.
I need a code sample that can mute the sound of windows in my applioation, please.
Best wishes
|
|
|
|
|
|
The following code works just fine on my "test" form, but when i put the code in the REAL application i get a selection rectangle, rather than the nice text color change i get with this code:
richTextBox1.AppendText("This" + System.Environment.NewLine);
richTextBox1.AppendText("seems" + System.Environment.NewLine);
richTextBox1.AppendText("to" + System.Environment.NewLine);
richTextBox1.AppendText("work." + System.Environment.NewLine);
string mySearchLetters = textBox1.Text;
int index = richTextBox1.Find(mySearchLetters);
label1.Text = mySearchLetters + " was found in pos " + index.ToString();
if (index >= 0)
richTextBox1.SelectionColor = System.Drawing.Color.Orange;
I'm thinking that maybe there is a "property" set on the real application that prevents this code from working but i can not find it. i compare the control properties, line-for-line and they seem to be identical.
Any ideas?
|
|
|
|
|
I take it your trying to highlight the position and length of the string you typed in?
This code won't work because your not changing the .SelectStart and .SelectionLength properties to actually select the string you want to change with .SelectionColor.
richTextBox1.SelectionStart = pos;
richTextBox1.SelectionLength = mySearchLetters.Length;
richTextBox1.SelectionColor = Color.Orange;
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
It turns out the solution was even simpler .. there WAS a property that was messing things up. All i had to do was set HideSelection to true !!!
The pretty orange text was hidden under the selection rectangle ... go figure ... lol.
Thanks for responding, Dave.
|
|
|
|
|
anyone can help me how to create a multicoloumn combobox?
|
|
|
|