|
How we can used sql command such as :
select max(debit), max (credit) from entries group by accountno
Im using sqldataadapter as bridge to database. When retrieve this statement from query builder (sqldataadapter1.fill) sure cant be placed into the dataset later because they are not same table design or schema.
How i can make used of that max(debit) or max(credit) value which have been grouped by accountno.
I have idea to select all data and put it into dataset and from dataset i put:
Dim dataTab As DataTable = DataSet11.Tables("Entries")
Dim deb As Double= dataTab.Compute("sum(debit)", "")
but the compute sum is not grouped summary, how can i solve all above problem and , "") sign is actually to filter, how to make use of that?
Thanks in advance.
|
|
|
|
|
LordLothar wrote:
How i can make used of that max(debit) or max(credit) value which have been grouped by accountno.
Use a numeric index to access your columns, or do this:
LordLothar wrote:
select max(debit) as maxDebit, max (credit) as maxCredit from entries group by accountno
Then you can access them by name.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Hi
I would just like to know how to print a simple text file from VBA. In VB6 I use this method:
Open FileName For Input As x
Do While Not EOF(x)
Line Input #x, s
Printer.Print s
Loop
Printer.EndDoc
But in VBA this is not possible. Any suggestion on how to print from VBA?
Regards
Gunnar
|
|
|
|
|
how do you create a webpage using vb.net inclusive of security like passwords and also how to link to the database created in ms access or
|
|
|
|
|
Hope this article[^] could help you.
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
My project is on vb.net windows application which brings data through remoting when i run .net application first time it takes time to load my forms and forms moves up and down and jerks.Please help me to cache the copy of compile version on client side with code or give me the solution to load the forms fast like VB6.
Please Reply
Regards
Prashant
Prashant Pawar
|
|
|
|
|
Well Prashant I wont be able to help you. But I guess you are in a position to help me out. I have the same scenrio. but some how when I fetches the dataset it does not work. but when I fetch string array or boolean or integer it works fine.
can you guide me in this regard ?
thanks for your support in advance 
|
|
|
|
|
First of all VB6 apps has really an advantage over .Net apps because the overhead of loading the framework is not there. Then normally when a .Net app starts up the jit has much to do which slows down the startup time. At least the second can be reduced. Search for NGen on google. Its a tool coming with the SDK which lets you precompile assemblies which can reduce start up time greatly (depending on what exactly happens on your start up).
|
|
|
|
|
hi friends,
i have a knowledge of vb.net. i would like to do a simple project on vb.net. so that i can get an idea of how it works in actual sinario.
i have no idea of how to start that?. if you send any project that you have done.it will be a model to me.it will be very helpfulto me.
please kindly guide me how to start?
shalini
|
|
|
|
|
Anonymous wrote:
so that i can get an idea of how it works in actual sinario.
how what works ????
you can see lot of projects with source codes on every aspect of programming at codeproject. so exactly you have in your mind ?
|
|
|
|
|
hi
thanks for your reply.
where can i get that "source code". how to browse? in codeproject.com where it is there.
|
|
|
|
|
Anonymous wrote:
i have a knowledge of vb.net
so what ? how and where do you write your code ? with notepad ?
if you write with visual studio, so you certainly write into vb files into a project registered into the solution...
what is your problem actually ?
TOXCCT >>> GEII power
[toxcct][VisualCalc]
|
|
|
|
|
Anonymous wrote:
i have no idea of how to start that?.
Try to read the evaluation lesson from this website[^].
Anonymous wrote:
i would like to do a simple project on vb.net. so that i can get an idea of how it works in actual sinario.
Try to look at the source code library from here[^].
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
Hi all, I am a new vb.net programmer wanna be and I gotten most of the basics on vb.net. But I am having a hard time trying to grasp database programming.. when I mean database programming, i mean trying to make my vb.net access a MS access file (*.mdb) and do editing and updating and displaying the data on a text box and all..
Wondering whether anyone out there with this knowledge can help me out, or better yet, have some kind of ebook that can go step by step with nice little DIY samples on this subject.
Thanz for your time..
|
|
|
|
|
One of the first things to pick up on is the connection string. A good reference is www.connnectionstrings.com to get you started.
A decent reference for selecting, inserting, updating and deleting records in a database is msdn.microsoft.com.
You can also stop by a book store and pick up a book on database's. I have codeing websites and windows forms to database's for 5yrs and still need to reference something, but that just might be my memory.....
ps - I also found www.asp101.net a good starting point.
|
|
|
|
|
Will do, thanz for the suggestion... As to go to a book store and get a good book, I wish I could. Where I lived in, have the world's crappiest book collection in the whole world, not to mentioned outdated. Only way is either go to West Malaysia or Singapore and visit their amazingly huge book stores there but air plane tickets ain't exactly cheap.. haha..
Anyway, thanz for your help... Ur the man...!!
|
|
|
|
|
icowa wrote:
I am a new vb.net programmer wanna be and I gotten most of the basics on vb.net. But I am having a hard time trying to grasp database programming.. when I mean database programming, i mean trying to make my vb.net access a MS access file (*.mdb) and do editing and updating and displaying the data on a text box and all..
Wondering whether anyone out there with this knowledge can help me out, or better yet, have some kind of ebook that can go step by step with nice little DIY samples on this subject.
Look at here[^], s/he has the same problem simillar to you too. Hope the solution could help you too.
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
Hey, not bad, two replies in a day... You guys and gals are great. Thanz for being so helpful... Will take a look at that thread you sent me...
|
|
|
|
|
hi
i work hard, but not find out if a program that programming by vb can run in LAN area? yes or no
if yes how?
|
|
|
|
|
http://giuciao.atspace.org/books/oreilly.htm
download
ADO.Net In A Nutshell
and
O'Reilly's Programming Visual Basic NET
and work on it .
|
|
|
|
|
What do you mean by "in LAN area"?
If your asking if a VB program can access network resources, then yes, it can. But that all depends on what your talking about.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
daneshmand wrote:
i work hard, but not find out if a program that programming by vb can run in LAN area?
In my opinion, if it is possible, try to buy this book[^]. I think it could help you to work in LAN from your VB.NET application.
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
Ok guys,
I really had about enough!
I need to be able to add bookmarks to the report after exporting it to pdf..
I instantiated Interop.Acrobat.DLL..so i can access the Acrobat library
what i do is that i search for a specified text that i want to book, then i bookmark it...the code works fine when i'm in the debug mode and step into each line, but when i run the code..it gives me Untitled bookmark that points to the 1st page in the document!..
the other thing is that i don't know how to create child or sibling bookmarks to the parent one!
and is it possible to call an application such as Acrobat in the background so whom ever runs the this VB.Net application won't be having the Adobe application screen flashing in their face and then disappearing after doing the bookmarks?
I really need help on that
not so many resources available online about Acrobat & VB.Net
|
|
|
|
|
I am using Directoryinfo object to move a directory on c:\ to d:\. But it's not possiable as destination cannot be another disk volume.
Is there a way that I can move or copy a folder to another volume.
|
|
|
|
|
File.Move[^]
Christian Graus - Microsoft MVP - C++
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
