|
A datareader is connected and forward only, so it won't contain info like rowcount, etc ...
Try use a dataset instead or loop through the datareader to see how many "reads" you can do.
Depending on the scenario, you might be able to use ExceuteScalar instead.
Cheers,
Simon
"Sign up for a chance to be among the first to experience the wrath of the gods.", Microsoft's home page (24/06/2002)
|
|
|
|
|
Thank you for reply. 
SimonS wrote:
t won't contain info like rowcount
But it HAS this property!!!! 
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
It has that property, but that data isn't available until you've gone through all of the results returned.
If you run the SELECT command through query analyzer you will see the rowcount is returned as the last item.
This is done for performance reasons, so it can begin passing the data on to the next process that needs it; whether that be a parent query or a client such as the DataReader.
Otherwise it would have to load all of the results into memory, then count the number of rows before starting to send data; or perform the query twice: once to count the rows and again to send them.
This doesn't seem like much until you have a table with a million-plus rows and your query results in half of them being returned. 
James
|
|
|
|
|
Hi all,
Is there someone who know how make these 2 things
1: make a tooltip over over the cursor when someone enter a function name like in VStudio ?
2: how make a listbox appear when someone enter a "." at the end of a variable name like in VStudio ?
Thanks a lot
BLaZeX
|
|
|
|
|
BLaZiNiX wrote:
2: how make a listbox appear when someone enter a "." at the end of a variable name like in VStudio ?
You could handle events like TextChanged and according to waht was typed, pop up menus.
Jared
jparsons@jparsons.org
www.prism.gatech.edu/~gte477n
|
|
|
|
|
and how exactly I can find that the string I typed is the name of a variable and after I wrote a "." pop the list at the current cursor position ?
|
|
|
|
|
|
To add
Generally the System.Reflection namespace should provide most of the answers you need.
MYrc : A .NET IRC client with C# Plugin Capabilities. See
http://sourceforge.net/projects/myrc for more info. 
|
|
|
|
|
I am making a custom control and I want to handle the event that happens when ANYTHING off the control is clicked, including especialy just the form that the control is placed on. The Lost_Focus Event does not fire when I click off the control on the form. I think that I may need to access a WM message from the WinApi.
mbp
|
|
|
|
|
I'm told .NET has a mechanism to make my controls resize nicely when I resize the dialog, can anyone illucidate ?
Thanks
Christian
We're just observing the seasonal migration from VB to VC. Most of these birds will be killed by predators or will die of hunger. Only the best will survive - Tomasz Sowinski 29-07-2002 ( on the number of newbie posters in the VC forum )
|
|
|
|
|
Guess I should look THEN ask - looks like anchor points will do what I want.
Christian
We're just observing the seasonal migration from VB to VC. Most of these birds will be killed by predators or will die of hunger. Only the best will survive - Tomasz Sowinski 29-07-2002 ( on the number of newbie posters in the VC forum )
|
|
|
|
|
Does any one know off any examples that will teach me how to convert a char* to a unsigned short* and vis versa? The code muse be pure #C code so it will complie on different platforms than microsoft windows.
-Thanks, Carl.
|
|
|
|
|
I have a control, that when double clicked, will create a text box, that wil afterwards be removed.
btw - the temporary control is added to the parent forms Controls collection.
i need it to be ontop of the control that made it, any help.
 Email: theeclypse@hotmail.com URL: http://www.onyeyiri.co.uk
"All programmers are playwrights and all computers are lousy actors."
|
|
|
|
|
i didnt realise that the listbox had its own controls collection, i added the textbox there, and it showed up ontop of the listbox.
Email: theeclypse@hotmail.com URL: http://www.onyeyiri.co.uk
"All programmers are playwrights and all computers are lousy actors."
|
|
|
|
|
Nnamdi Onyeyiri wrote:
didnt realise that the listbox had its own controls collection, i added the textbox there, and it showed up ontop of the listbox.
Yup, that's what you should have been doing. I didn't realize that you hadnt done that when you told me on sonork
Nish
p.s. Didn't feel sleepy, so worked on and finished that article. Had forgotten to mail the latest version home, but I recoded the extra stuff [article was mostly ready since yesterday]. Anyway after I finish the article I was delighted to find CP up again
Author of the romantic comedy
Summer Love and Some more Cricket [New Win]
Review by Shog9
Click here for review[NW]
|
|
|
|
|
Is there a special function in .Net framework (or in C#) to shut down/restart the computer form C# app?
|
|
|
|
|
Import the Shell32 Reference and call Shell32.ShutdownPC
or something like that
Just Add Reference and in COM section select The Shell class
|
|
|
|
|
|
In your case NO. There is some issues between with NT4 and below as well as Win9x, but its ussually related to Unicode issues (I think) . The only suggestion is that they mite be running a pre RTM version of the framework. That would explain compiling and running on their machine and not running on yours. Your exe works fine on my machine with XP and RTM .Net SDK.
MYrc : A .NET IRC client with C# Plugin Capabilities. See
http://sourceforge.net/projects/myrc for more info.
|
|
|
|
|
|
Can I compile C# code in a DLL file and call the code from other code file? this will make it easier for me whenever I want to make any update update.
Jassim Rahma
|
|
|
|
|
if you mean running code from a dll, its easy, simply add it as a reference, and your away. that is - if its a c# coded dll.
Email: theeclypse@hotmail.com URL: http://www.onyeyiri.co.uk
"All programmers are playwrights and all computers are lousy actors."
|
|
|
|
|
Hi there.
I would like to be able to draw simple 3d objects such as cubes etc using (x,y,z) coordinates. Of course, on a form we only have 2D to work with. After some book crunching in a bookshop, I have come to realise that my maths skills are somewhat depleted with age, and also that the books attempt to give you a complete understanding of 3d coordinate geometry along with matrix maths required. Its all too academic for me at the moment.....
What they don't do is tell you with simple examples in c# is how to use matrix transforms to convert a set of 3d coordinates into a 2d plane.
That's what I am after. By my understanding, this is a reasonably complex problem involving viewing angles and perspective or parallel representation etc.
Any takers? Of course, I will settle for c# examples of using DirectX or OpenGl as I then can compare different approaches etc.
Thanks groovers
|
|
|
|
|
I'm havent looked into this yet, but the following class mite be of interest:
System.Drawing.Drawing2D.Matrix
as well the System.Drawing namespace mite answer some questions.
MYrc : A .NET IRC client with C# Plugin Capabilities. See
http://sourceforge.net/projects/myrc for more info.
|
|
|
|
|
Thanks Leppie,
Yeah, I've looked at that stuff, unfortunately its not that helpful. I figure that the classes needed may need to be written by scratch - the matrix class is useful for 2d transforms, rotation and scaling etc, but defaults to a 3x3 matrix, so I reckon the more complex matrices may need to be written by hand.
Thanks for the advice though, and do get in touch if you make any progress on this.
Bye now.
Jase
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
.