|
Make a nested query. Example:
select Cnt, sum(Value)
from (
select count(*) as Cnt, Value
from SomeTable
group by Value
) as x
group by Cnt
---
single minded; short sighted; long gone;
|
|
|
|
|
OK, I see that an SQL query is good.
But I have a local datatable -- it doesn't have or need an SQL connection or dataadapter.
Should I make one to do this selection? (seems like a lot of overhead?)
Or is there a better alternative - perhaps a loop is faster?
Thanks
|
|
|
|
|
cstrader232 wrote: But I have a local datatable -- it doesn't have or need an SQL connection or dataadapter.
Should I make one to do this selection? (seems like a lot of overhead?)
Using a DataTable when the data doesn't come from a database seem like a lot of overhead in the first place...
cstrader232 wrote: Or is there a better alternative - perhaps a loop is faster?
Yes. There are dictionaries and sorted lists that you can use to easily group and sort the data.
---
single minded; short sighted; long gone;
|
|
|
|
|
Well I thought that sorted lists were not very efficient. I don't know what a dictionary refers to
in this context. Can you direct me?
ty
|
|
|
|
|
cstrader232 wrote: I don't know what a dictionary refers to in this context. Can you direct me?
MSDN Library: Dictionary[^]
---
single minded; short sighted; long gone;
|
|
|
|
|
greetings to all... i really appreciate your help it gives me new ideas and gives me more closer to what i wanted to do...
now again i need your help on how to enable to allow sorting on a gridview in which the column header not came from the controls design, but instead from run time...
start a new beginning in every ending; thats what life for......
|
|
|
|
|
try this one
datagridview1.sort(columnindex)
hope this helps
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
this helps although its a little bit closer of what i wanted but i appreciate this code sir... its a great help..
but i need this one:
whenever you click the header of the gridview it will sort to descending and ascending manner....
this is easy if i use a bind gridview, but if i use run time or unbound data to the gridview then its the time i have difficulties in sorting columns by its column header...
Thank you sir...
start a new beginning in every ending; thats what life for......
|
|
|
|
|
use following code
Private Sub dgv1_ColumnHeaderMouseClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellMouseEventArgs) Handles dgv1.ColumnHeaderMouseClick
dgv1.Sort(dgv1.Columns(e.ColumnIndex), ComponentModel.ListSortDirection.Ascending)
End Sub
where dgv1 is datagridview object
hope this helps
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
Please don't cross post.
Please try to write a subject line that is relevant.
---
single minded; short sighted; long gone;
|
|
|
|
|
did i not ask for an apology at the last part of my post?
that i mistakenly post my question on this forum VB.NET
that is supposedly for ASP.NET
before you judge, pls read or understand what is written on the post...
Thank You...
start a new beginning in every ending; thats what life for......
|
|
|
|
|
If you ever cross post you have the ability to delete your post before there are replies.
CleaKO
"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)
|
|
|
|
|
Hi,
can anyone tell me how to reduce the size of png file through vb.net?
its actual size is 623 bytes and size on disk is 8kb so i want to
reduce the size on disk up to 1 kb only.
Is there any way to do it?
Thanks with anticipation.
vandana
|
|
|
|
|
What do you mean by "actual" size?
Is it an 8 bit or 24 bit png?
---
single minded; short sighted; long gone;
|
|
|
|
|
Hi,
I made a bitmap image using graphics in vb.net and its format is Imaging.PixelFormat.Format32bppArgb and then save it as .png file
when i right click on it , it shows that its size on disk is 8kb.
So i want to reduce it up to only 1 kb.
thanks for your response
vandana
|
|
|
|
|
There's a difference between the actual "file size" and the "size on disk" size. This is something you can do nothing about. The reason is because NTFS only allocates disk space in "blocks", not bytes. An allocation block on that disk is 8096 bytes long. So, on disk, even if the file was only a single bye in length, it's sitting in a block that's 8K in size. There's NOTHING you can do about this.
|
|
|
|
|
hi
how do i capture windows shutdown/Logoff event in vb.net application.
Thanks in advance
regards
ravi
|
|
|
|
|
For Shutdown
System.Diagnistic.Process.start("shutdown","/s")
For Logout
System.Diagnistic.Process.start("shutdown","/l")
I am not sure about this
|
|
|
|
|
Hi
Thank for prompt reply, this will shutdown my mechine, actualy i wanted to capture shutdown/logoff events in my vb.net application. I am running an application for capturing user status. if user shutdown the mechine then application should update current datetime before shutdown
regards
ravi
|
|
|
|
|
|
Hi,
I am a newbie to .NET. I have just begun working on .NET 1.1. I want to build a Windows Application (thru VB.NET) that would get connected to a Web site. The Web site creates certain text files at regular intervals which need to be downloaded.
How will my application come to know whether a new text file has been created. Will the Web browser control help me in this context?
The only place where SUCCESS comes before WORK is in a dictionary.
|
|
|
|
|
If the webstie only supplies a single link, and no data on the file creation or update time, then no. There's no way to tell if the file has been updated without downloading it and comparing it to the last version that was downloaded.
If so, then you'll just have to parse out and store this data somewhere so you can use it in the next iteration to determine if the file has changed or not. How you get the information out of the page depends on how it's exposed by the site in question. But, if this data changes you can proceed to download the file.
Is the WebBrowser class useful in this situation?? Probably not, for two reasons. One, it doesn't exist in the .NET Framework 1.1, only 2.0 and above. And second, it's main use is for a user-inteeractive web session, not automation. HttpWebRequest[^] would be a better choice for getting web pages and parsing them.
|
|
|
|
|
|
Hey
If a file on a network drive is already opened by another user is there a way in VBA to determine the name of the user and report this back?
If so any help would be much appreciated.
Thanks
Dan
|
|
|
|
|
Using purely VBA, no, it's not. You'd have to convert the C++ code in this[^] article to get this kind of functionality.
Standard Question #1 when confronted with a situation like this: Is this "feature" worth the cost in development? I doubt it.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
