|
hi,
I am using sqlDataAdapter select command based on multiple tables using INNER JOIN to populate DataSet . I wanted to update only one table data by using UpdateCommand Property. plz help me to write Update Command. SelectCommand is as
sql = "SELECT a.prepaidID,a.revAccountNo,a.AccountNo AS origAccountNo," & _
"a.totalAmount, .description, .distAmount,b.fromDate,b.toDate,b.vtCode,
b.voucherNo,b.voucherDate" & _
" FROM prepaidDistribution a,prepaidDistributionDetail b" & _
" WHERE a.prepaidID = b.prepaidID and a.companyCode='" & compCode & _
"' and b.fromDate>='" & startDate & "' and b.toDate<='" & endDate & _
"' and b.vtcode IS NULL and a.accountNo like '" & accountNo & "%'"
plz help immediately
|
|
|
|
|
I am looking for some direction on how to export a datagrid or Stored Procedure to Excel while in a VB.net application. I don't want to have to publish as a Report (Crystal or Reporting Services) first and then export it to Excel. I want to export the data either from a datagrid or SQL Stored Procedure and put it into Excel.
I see, from The Code Project forum - that exporting a datagrid from C+ and ASP.net has already been done and looks straight forward if my app was written in either of these languages. Both my skills and my app, at this point, are based in VB.net.
Any suggestions or leads would be helpful.
Thanks
Pat
|
|
|
|
|
|
|
Hi everybody..I hope you can solve this little problem:
you know when you log into windows 2000/xp as a guest you may sometimes need to run an application as the administrator.To do so,you press the right mouse button holding at the same time the shift key,then it appears a menu called "Run as...",or something like that,and when you finally click on it,it shows a window asking you to insert the username you want to run as(in our case the administrator)and the password.Well,to get to the point:i want to create a program in vb 6 or .net that sends to the textbox titled "Password:" the password text without passing through the clipboard.To do this,i think i can use windows APIs,and it seems the function SetWindowText is enough,isn't it?But my trouble is the SetWindowText function requires the handle of the object to send the text to.So the question becomes:how can i first of all get the handle of the textbox object(and not of the window that contains it nor using the function GetForegroundWindow)?
Can someone please help?
Many Many Thanks
Luke
|
|
|
|
|
|
Or you could skip that garbage and just shell launch your application using the RunAs command line utility, where you can supply it with the username and password of the account you want it to use.
Or you could just use the Win32 API to do the exact same thing as that RunAs shortcut menu. See CreateProcessAsUser[^], CreateProcessWithLogonW[^], CreateProcessWithTokenW[^].
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thank you very much indeed
It works,each method suggested
Thanks again
|
|
|
|
|
I, want to know which s/w are installed in my o.s. and how can i uninstall the loaded s/w in vb6 at win9x,nt,xp,2000
|
|
|
|
|
In VB6, you can't do this unless you use WMI. There are problems with using it to uninstall applications though. The call will fail every single time, so the app may be uninstalling, but you'll never know if it completed successfuly or not. Also, you can't use this method on Windows 9x or NT4 SP3 and below.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
|
I want to make the code of putting a text message exactly in center of form
|
|
|
|
|
|
I want it without using any api
|
|
|
|
|
In VB6, you don't have a choice.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hey guys, I know how to run code during system startup
by putting it in startup folder and in registy at currentversion/run ,but is there any other way to run code during system startup
|
|
|
|
|
Only if you write your app as a service. There are no other ways...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I , don't understand what you mean.please suggest some better idea.
|
|
|
|
|
You've never heard of Windows Services??? Click on Start/Settings/Control Panel/Administrative Tools/Services??
Like I said, there is no other way...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
How can I prevent opening the cdrom drive or floppy drive.
using vb only
|
|
|
|
|
CD Drives can be locked shut, floppy drives can't.
Check out this[^] example.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
How can I know whether cd is in cdrom or not and whether floppy is in floppy drive or not. Please tell me using vbcode
|
|
|
|
|
Just try and get the list of files from the root of the drive. If it fails, then there's nothing in the drive.
There is nothing that will tell you a disk is mounted in the drive without actually trying to access the disk.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
How can I know whether cd is in cdrom or not and whether floppy is in floppy drive or not
|
|
|
|
|
Can any one can tell me how can i know whic O.S. is running. ie,windows xp/2000/95/98/nt in visual basic not in vb.net
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
