|
Or implement some paging functionality. On the first population run
SELECT TOP 50 *
FROM tTable
ORDER BY UniqueKey ASC
on each "NextPage" command run
SELECT TOP 50 *
FROM tTable
WHERE UniqueKey > (last result set's MAX(UniqueKey))
ORDER BY UniqueKey ASC
Try not to do this as it is painful for the DB
SELECT TOP 50 *
FROM tTable
WHERE UniqueKey NOT IN (SELECT TOP [PageCount*50] *
FROM tTable
ORDER BY UniqueKey ASC
)
ORDER BY UniqueKey ASC
|
|
|
|
|
Yep. Maybe the OP will take your suggestions, which are very good 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
I have created a startup service project in vb.net..When i log off the computer the form comes..when i Close the form..The exe is Killing but again comes in the task manager..I cant kill the exe..Again it comes..
pla any one give solution
|
|
|
|
|
Is the project a Windows service or just a regular Windows Forms program? Are you trying to kill the process in code or by using the Task Manager?
|
|
|
|
|
Iam Usingwindows project and it is startup windows Prject.
I registered in registry key of the program and set the value to set the program to come in start up..
..Iam using code to kill the project but it is coming again in task manager..
Thro task manager also i killed ,it is coming again
|
|
|
|
|
If you added it to the registry to run, it's going to run.
|
|
|
|
|
Thank u for ur Reply..Is ther any way to kill the process..yes i have registred in startup in local machine..
|
|
|
|
|
Hi,
please i need to create conectors between two items just like the one in
the SQL Server diagram. I am using Vb.Net 2008 thanks
Mohammad Al Hoss
|
|
|
|
|
Hello Friends,
How to develop project. so that it occupy less memory.
I am using vb.net 2005.
Thanks in advance.
Adarsh
|
|
|
|
|
Write less code?
(Sorry, but its such a stupid question)
I expect what yuo are really looking for are best practices. Try google.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Thanks
But i am asking what to use and when.
for example If condition is better to use than Loop.
or
Use global object or local to procedure.
Please help me.
Thanks
Adarsh
|
|
|
|
|
Get a profiling tool that will help you understand what parts of your code consume the most resources. There are several that are available as 30 day trialware
|
|
|
|
|
Thanks for your help.
If you have any software name, please forward it to me.
Thanks
Adarsh
|
|
|
|
|
Google for ".NET Profiling tool". Pick some. I have tried some of the open source ones within the past year and was really confused (poor docs, not intuitive), so you may want to try one of the commercial products to get started.
|
|
|
|
|
Thanks for your reply.
I will look into the matter.
Adarsh
|
|
|
|
|
I want to genarate bar code for my project assigned to me. I don't have any idea about it, I have searched for the hints on google but didn't get any thing. Can anybody give any hint?
|
|
|
|
|
Get it
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
|
Always Welcome.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
|
sorry, my english is bad(i'm form mexico)
you need download a FONT called "BARCODE" or "3 of 9 Barcode". After that you go to
"C:/Windows/FONTS" and paste the FONT that you download previously.
After you can use the example of this page
<a href="http://www.neodynamic.com/ND/FaqsTipsTricks.aspx?tabid=66&prodid=1&sid=58">http://www.neodynamic.com/ND/FaqsTipsTricks.aspx?tabid=66&prodid=1&sid=58</a>[<a href="http://www.neodynamic.com/ND/FaqsTipsTricks.aspx?tabid=66&prodid=1&sid=58" target="_blank" title="New Window">^</a>]
or only drawing
e.Graphics.DrawString("*" & text & "*", New Font("3 of 9 BARCODE", 20), Brushes.Black, 100, 100)
no forget "*" (asterisc) because if you forget that The scanner can't read the CODE....ok?
orlando_back@hotmail.com
|
|
|
|
|
|
I am using Visual Studio 2005
I have created Flash movie in Flash 8 for help.
I copy it at bin/Debug Folder.
I used the code at Help Topics Menu item click event:
System.Diagnostics.Process.Start (System.Environment.CurrentDirectory & "\Help.swf")
It works Fine.
But When I create setup using Setup Project.
It is picking path of my project folder, not installed folder.
Same case of connection string of mdf file of my project.
Please guide me how do i resolve it.
Thanks
|
|
|
|
|
nishugaurav wrote: System.Diagnostics.Process.Start (System.Environment.CurrentDirectory & "\Help.swf")
use application.startuppath for the flash movie
System.Diagnostics.Process.Start (application.startuppath & "\Help.swf")
Note this is not recommended for files (like mdb,txt,xml,...) wich the programme has to write to
You need administrator rights for that so users on XP who don't have those will not be able to write to it and you'r programme will crash
On vista everything the user does (write to those files) will end up in the user's personal virtual filesystem, and will NOT be accesible for other users
|
|
|
|
|
Path.Combine(application.startuppath, "Help.swf") if you're like me and can't remember when trailing slashes are there and when they aren't.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
