|
OleDbConnection clsConnection;
clsConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\.one.mdb;");
clsConnection.Open();
WTest1.oneDataSet f_table = new WTest1.oneDataSet();
OleDbDataAdapter dAdapter = new OleDbDataAdapter("select * from first", clsConnection);
dAdapter.Fill(f_table, "first");
clsConnection.Close();I've used this code in a previous application and it worked fine, however in this application, it's giving me this error about FROM syntax.
Can someone please tell me what's wrong??
Star
|
|
|
|
|
are you sure there is table called 'first' and also do you have 2 spaces between 'from' and 'first'. Im sure queries don't like double spaces
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
Star09 wrote: Data Source=C:\\.one.mdb
do you need the first period?
|
|
|
|
|
I have removed the path because it was so long, but I do have it in my application, lol.
As for the double spaces, didn't notice them, thanks, but still even though I removed the double spaces, still same runtime error
|
|
|
|
|
Star09 wrote: As for the double spaces, didn't notice them, thanks, but still even though I removed the double spaces, still same runtime error
you should reply that message to me....
What is the error message you are getting?
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
the message doesn't make sense, Syntax error in FROM clause.
|
|
|
|
|
Okay when I commented my other connections, it worked.
|
|
|
|
|
Hi,
In my application, i used a theme.
and when i carry one form over another form, this process is too slow.
how can i solve this problem?
|
|
|
|
|
|
yes it is...because windows do not use Graphic card acceleration. Either develope full screen app or do not use heavy images those hurts the performance.
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia> -----------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
Exploring some MS assembly using reflector I found something odd: a class declared internal in one assembly that was being used in a different one.
That does not make sense to me. As far as you know, there is some (legal) way to achieve that, or Microsoft is using some C# and/or IL "magic" to make that possible?
|
|
|
|
|
|
Wow, I'd never tought that something like that existed!
Tank you
|
|
|
|
|
Yeah! Like he said.
Yet another .NET feature I've not encountered before, good to know.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
I am trying to use the rendered output of a video player in my C# code. The program (which is the VLC media player) is written in plain C and is wrapped in a DLL.
I should pass pointers to two callback functions (dolock and unlock ) as string arguments (argv ) to the player when it is instantiated through a DLL call. here is the function signatures in C:
void *dolock (void *struct)
void unlock(void * struct)
(the struct arguments are not used in my case).
they appear in my C# code as:
public static IntPtr dolock(IntPtr ctx)
public static void unlock(IntPtr ctx)
I use delegates and Marshal.GetFunctionPointerForDelegate to obtain the function pointers.
This works perfect and I can see in the debugger that the player successfully invokes my dolock function. But, an exception is raised after the function invocation, when the dolock function returns with a pointer to a buffer. I can not understand if it is because the player is not allowed to write in the memory which is allocated in my program or I am returning a wrong pointer. The error is a famous one:
The instruction at ... referenced memory at "0x000000". The memory could not be "written" .
I have tried different ways to allocate the memory buffer (which I should return its pointer in dolock), all failed with the same error.
* Allocating space in the unmanaged section of the program memory using AllocHGlobal.
* using stackalloc to allocate the buffer in stack (unmovable by GC).
* using Bitmap and BitmapData GDI+ classes and returning the bitmapdata.scan0 pointer after locking the bitmap.
Any idea what might be the cause?
|
|
|
|
|
Is ctx, actually a struct? It might be that vlc is attempting to write to the struct it was expecting. If you are passing IntPtr.Zero it will try to write to memory location 0x000000.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
No, as I said, dolock and unlock are callback functions and it is the vlc which is actually passing these arguments to my program.
|
|
|
|
|
The problem is fixed.
I should use [UnmanagedFunctionPointer(CallingConvention.Cdecl)] attribute before my dolock/unlock functions.
|
|
|
|
|
i am using windows media player control axWindowsMediaPlayer1
i want to be able to adjust the balance for channel a and b volume in a stereo audio
pleas help
|
|
|
|
|
Have you Googled for this?
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
public void OnDocumentComplete(object pDisp, ref object URL)
{
// second time control goes upto here but doesnot go into if statements
if (URL.ToString().EndsWith(".pdf")&& (!URL.ToString().StartsWith("file:///")))
{
object obj = System.Reflection.Missing.Value;
webBrowser.Navigate("C:\\BHO.pdf", ref obj, ref obj, ref obj, ref obj);
}
}
open Internet Explorer which has PDF links.
click a PDF link such that the corresponding PDF file is opened in new window
Instead of original PDF file, C:\BHO.pdf is opened on new window
close that new window in which C:\BHO.pdf is opened.
Again click on same link, event gets fired but instead of C:\BHO.pdf, original pdf is opened on browser.
Why does if condition statements doesn't execute when I do the same thing second time.
In Navigate("C:\\BHO.pdf", ref obj, ref obj, ref obj, ref obj) why we are passing
System.Reflection.Missing.Value
Is my problem is due to this or due to some other thing?
|
|
|
|
|
Wrong forum for a start.. but have you stepped through the code? What are you trying to achieve here? It looks like you want BHO.PDF to open no matter what PDF file is clicked on?!
|
|
|
|
|
Hi,
I have a question about UI design in NET.
I am creating a scientific application with C# and VS2008. Currently I am using a tab conrol were till now I have 3 level tab depth (eg tab inside tab etc) which is not very convenient, nor user friendly.
I am thinking to switch to an outlook UI style were the general tabs will be moved to left panel with the form of buttons. While the right panel will have the detail form again with tabs but lesser depth.
So my question is what is the best approach of doing this?
Should I move to a MDI where in the right panel will load detail form's in full mode?
Or should I search for some specific tab component?
|
|
|
|
|
We use Infragistics Listbar, one of the few controls of theirs I like. It gives an excellent outlook style listbar, relatively easy to use which is a huge bonus from them.
The only trouble with the ui design like you are proposing (I use it also) is when there is a large amount of detail to be displayed. I have a standard toolbar somewhere with alphabet buttons for filtering large sets. Use a DGV for detail, it's faster than a listview and easier to format.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
In my situation, I don't have large amount of detail to be displayed, rather data grouped in distinct way...
I saw (don't remember where) an approach where instead of MDI the SDI is used with custom controls. A custom control in my situation would be a detail form which could show or hide depended on which button is clicked.
Not quite sure if this approach is best.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
