|
the only way I could think of is to get the system time just before running the query and the system time just after running the query. Get the difference of it, store it in a variable and just check it out.
Tarakeshwar
CCIE Q(Routing and Switching), MCSE Security
|
|
|
|
|
A good rule of thumb is that a single (indexed) query will take between 10 and 50ms. Average is usually < 30ms. I usually assume 30ms and base my calculations on that. If actual results differ, then I look into it more closely.
You can use the SQL profiler tool that comes with SQL Server to monitor queries and how long they are taking. You can use Query Analyzer to view the query plans of queries that are performing badly.
|
|
|
|
|
Hello to all..
This time I need your help with the windows registry...
After a series of operations, if all went to good end, I should introduce a key in the registry...
How do I create it? I saw some keys that inside have like value some numbers, for example 50, 75....what does they mean?
How do I be able therefore to write in it???
These operations I should not do them manually from the registry but with some code in vb....
Thanks early to all..
|
|
|
|
|
It doesn't sound like you've any experience with the registry. I would HIGHLY recommend that you get to know the registry BY HAND before you start poking around it with code. If you don't know what your doing and what the registry value types are, you really can't write code for it without risking irreversable damage to the registry and possibly the ability to even boot Windows.
But, for an idea on how to write your own functions to create keys and values and read them, see this[^] article on MSDN. Also, there is this[^] article on here CodeProject.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi there !
Here's the question. My application is finished and is compiling very well. However, when I'm trying to do the setup, it tells me that I'm missing a dependency for ADODB (mscorlib version 1.0.3300.0 and that should be in framework 1.0, I think)
The only version that I found on my pc was mscorlib 1.5 (framework 1.1). Wherever I looked on the Internet, I couldn't find the right version.
Is there anybody who could tell me where I could find it, or is there a mean to make my application work with version 1.5 ?
Any help would be Grrrrreatly appreciated !!
Thanks !
Mart
|
|
|
|
|
Try installing MDAC 2.7 first. Then, if your app was developed on the .NET Framework 1.1, make sure that is installed. If your app was developed on .NET 1.0 install that. Then you can probably install your app.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hello Everyone
I want to create a browser ike interface in Windows Forms using VB.Net. I want to make a UI something like MS Money 2003.
I have read an article on MSDN : "Web-Application Interface" http://msdn.microsoft.com/library/en-us/dnwue/html/ch10e.asp?frame=true
I have understood the concept. But just a bit confused on how would I render dynamic data (like datagrid) on the screen.
Can anyone please provide me with some guidance.
Thanks
Paras Shah
|
|
|
|
|
Also check out this page : http://msdn.microsoft.com/library/en-us/dnwui/html/iuiguidelines.asp?frame=true
But this does not have any information about how to program with components.
|
|
|
|
|
I want to run send data from one form to another.
How to run two form at the sam time ?
Thanks.
Go forward and never Stop....
|
|
|
|
|
This is the fourth time you've asked this question!
You've already got your answer in your previous posts. You simply add a Public class variable to your second form and set that variable from your main form.
Now, to show a second form with the data you want to pass:
' Code in Form1
Dim form2 As New Form2
form2.myClassVariable = "something"
form2.Show()
' Code in Form2
Public Class Form2
Public myClassVariable As String
.
.
.
End Class
You might want to TRY this and if it fails, post a couple of code snippets so we can tell you want your doing wrong.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I added an icon to a button in my form. At this time, i could see it(the icon) in the button when it runned. Then, i run it again, the icon undisplayed, half month ago. Please help me to solve my problem. Please send your reply at find_down_ms@yahoo.com. Thanks.
sang
|
|
|
|
|
Can somebody point me on an info, how to integrate smart tags into a visual studio editor?
Thanks,
Boni
|
|
|
|
|
I have no idea how to do it, but I have to ask why you would to do such a thing? I can't think of any reason to do it. What kind of functionality did you have in mind?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi,
For example if you point on a build in variable in debug mode you can see the small field with its value. It is a smart tag(I beleave).This seems to work just for build in types. I would like to extend this functionality. And also other fun features would be possible.
With best regards,
Bonio
|
|
|
|
|
It's not done using SmartTags because the IDE doesn't currently support them. SmartTags will show up in the IDE in Visual Studio 2005. Currently, it's just a simple tool tip that that appears when the IDE is in debug mode and it detects that your hovering over a variable that is in scope. The ToolTip shows value types and simple reference types, like String. Beyond that...
Actually, what your thinking of doing is already being done in Visual Studio 2005. It's called a DataTip. You'll be able to create you own Viewer Helper classes that can display objects however you want. See this[^] for the full story.
Wanna peek at 2005? http://msdn.microsoft.com/vstudio/productinfo/roadmap.aspx[^]
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi Dave,
Thanks for this clarification. Can I set a value of this tooltip in the current verson?
I can't wait to get VS2005
Kindly yours,
Bonio
|
|
|
|
|
No. You can't touch it. You would have to make your own from scratch, but I odn't know where to start. The object model for the Visual Studio IDE is quite large.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi Dave, hi all
but the class member advice of VS seems to be a smart tag. (When you write myclass and then press dot a list of members open). So VS seems to support smart tags. Any help would be very appreciated. Best regards, Boni
|
|
|
|
|
That's Intellisense doing that. Smart Tag support will show up in VS.NET 2005...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I have a script which inserts a new record into a sqlserver database.
I have ListID as the primary key (autonumber). I need to find a way of returning this number once I have saved the first part of the record, as on the next page I save some other fields of the same record.
Does anyone have any ideas?
Cheers, V
|
|
|
|
|
Insert the record into DB using a Stored Procecure with one Out parameter. This will have the value @@Identity set in the stored procedure as follows.
SET @OutParam = @@Identity
Bhaskara
|
|
|
|
|
Thanks I have it returning my value now,
Cheers, V
|
|
|
|
|
|
I'm using VB.NET, I wonder...
1. How can I capture a specified area of screen ? User must be able to select the area they want to capture by mouse.
2. How can I set "Compressed" or "Encrypted" attribute to a file ?
3. How can I get the Icon List in an EXE or a DLL file ?
Thank you for helping!
|
|
|
|
|
I wonder how we can shutdown / restart / sleep down / suspend our computer using VB.NET?
Please don't tell me to use SHUTDOWN.EXE, it doestn't support sleep computer!
Thank you!
|
|
|
|