|
you can using the Excel reference: Microsoft Excel 10.0(version number) Object Library.
I suggest you learning this from MS msdn web site.
There are some samples for help.
|
|
|
|
|
HI All,
I am basically passing URL parameters for the user to edit or delete pictures e.g
delete_images.aspx?id=1123
that means if anyone knows the id they can delete other users details so my question is how to avoid from this to happen. I also dont want to get any sql injection so please tell me whats the best way to achieve it with or without passing url values.
thanks
Robin
|
|
|
|
|
|
Hello all,
Im a newbie to .net and have been teaching myself. I have created a data migration tool for my company using vb and also microsofts USMT. The way it is now i have one exe file and a folder with the USMT files in it. Is there anyway to add those files to the exe file so i just have one single file instead of the exe and folder?. This may be a stupid question but It would help me out greatly. THanks a lot.
Bob
-- modified at 22:24 Monday 13th March, 2006
I should exlain a little more
I dont need any reg edits or anything i just need to run the exe which calls robocopy and the USMT files with the appropriate info. Its a lot easier sending end users one exe file instead of the exe and USMT folder. Thanks again
|
|
|
|
|
Normally, you could include the files as resources in your .EXE. The problem is that you can't treat these as actual files in some file system. If you're using Robocopy to copy these files to some other location, then no, you can't put them into your .EXE.
BTW, what is USMT??
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thanks for the response. I am shelling out to robocopy to copy the users data such as my documents etc... The USMT is Microsofts User State Migration Tool it includes scanstate and loadstate, inf files, dll files and some other files. USMT will migrate desktop and OS settings all depending on how you customize your inf files. Its nice to transfer that stuff over for our executives, and they are happy when thier new laptop looks like the old one. The Migration Wizard i created is customized to my company, but if you would like me to send you my source code too look at id be more then willing. I tried adding the files as reference but unfortunatley i cannot add the .inf files so that isnt going to work.
I really wish there was a way to just have the one exe file.
|
|
|
|
|
No, you're not going to get away with putting all this in one file. It's just alot more hassel than it's worth, and it complicates maintainability. If you have to change any of these files, you'll have to recompile the entire app.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
That is very true.. Good call on that one that could of ended up being a pain. Thanks for your help.
|
|
|
|
|
Why not compress the EXE and the 'USMT' files into a self-extracting ZIP file? WinZIP and others will do the job.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once 
(Translation: I'll show you the way, but not write the code for you.)
|
|
|
|
|
im trying to retreave an information from a database after the person have logged in.but i can insert the data to a specific place that im intent to put it.Im using session to do that by passing the parameter to campare it.
this is the code i used:
Dim MyConn As SqlConnection<br />
Dim cmdSelect As SqlCommand<br />
<br />
userName = Session("userName")<br />
<br />
If userName <> "" Then<br />
<br />
<br />
MyConn = New SqlConnection(ConfigurationManager.AppSettings("psmConnectionString"))<br />
cmdSelect = New SqlCommand("sp_GetUser", MyConn)<br />
<br />
cmdSelect.CommandType = CommandType.StoredProcedure<br />
<br />
Dim parameternoPekerja As New SqlParameter("@noPekerja", SqlDbType.VarChar)<br />
parameternoPekerja.Value = userName<br />
cmdSelect.Parameters.Add(parameternoPekerja)<br />
<br />
MyConn.Open()<br />
Dim dr As SqlDataReader = cmdSelect.ExecuteReader(CommandBehavior.CloseConnection)<br />
<br />
If dr.HasRows = False Then<br />
' error mesej<br />
Else<br />
txtnama.Text = CInt(dr("nama"))<br />
txtjawatan.Text = CInt(dr("jawatan"))<br />
txtjabatan.Text = CInt(dr("jabatan"))<br />
txtbidang.Text = CInt(dr("jabatan"))<br />
txtjabatan.Text = CInt(dr("jabatan"))<br />
End If<br />
Else<br />
'error
Is it wrong
|
|
|
|
|
pandapatin wrote: txtnama.Text = CInt(dr("nama"))
txtjawatan.Text = CInt(dr("jawatan"))
txtjabatan.Text = CInt(dr("jabatan"))
txtbidang.Text = CInt(dr("jabatan"))
txtjabatan.Text = CInt(dr("jabatan"))
must call dr.Read() first...
|
|
|
|
|
Hi
Does anyone know if there is some sort of button code which can close all instances of your application?
I want to be able to close all forms and all instances of an application with the click of one button.
Sometimes, when I use the Me.Visible = False code , instances of my application are still running unseen. I want to be able to avoid this.
Regards
ensuvari
|
|
|
|
|
You can use either End or Application.Exit()
chatura
|
|
|
|
|
ensuvari wrote: when I use the Me.Visible = False code , instances of my application are still running unseen
Ummmmm....who told you that Visble=False will clsoe an application???  That just hides the window you set it on, nothing more. So, yeah, the app is still running...
You'll have to use the Process[^] class, and it's GetProcessesByName method, to get an array of Process objects. Then you can call Close on each of those objects to close every instance of your app.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I'm beginning a new VB.NET WinForms app for my company. They have chosen to use VS 2005 for this project. I've been programming in 1.x for a while now, but I haven't really kept up on the changes/additions to 2.0.
Does anyone have any suggestions for books/websites/etc. where I can get up-to-speed on 2.0? I would prefer a book, but I don't really need a "VS 2005/.NET 2.0 for Dummies" book (or do I?) A website (or combination of sites) would be fine as well, though I don't really want to try and wade through MSDN to find what I need if I don't have to...
Anyway, any suggestions would be greatly appreciated. Thanks!
P.S. From what research I have done, having VS.NET 2003 and VS 2005 installed side-by-side on my machine will not be a problem. I don't have drive-partitioning software, so they will literally be side-by-side. Is that really the case?
Scott McChesney
|
|
|
|
|
|
Scott McChesney wrote: From what research I have done, having VS.NET 2003 and VS 2005 installed side-by-side on my machine will not be a problem. I don't have drive-partitioning software, so they will literally be side-by-side. Is that really the case?
Yes, that is really the case. I have 2003 and 2005 installed side by side, and both work great. Only problem (not so much a problem, as a minor annoyance) comes from the OS. When I double click on a file, Windows doesn't know if it's 2003 or 2005. It opens VS 2005 by default. So what I do is right click on the file, and choose "Open with - Microsoft Visual Studio 2003" if I need it. (Of course, if most of your work is done in VS2003, you could set that as your default)
Asside from that, no problems.
Roy.
|
|
|
|
|
How to run other exe from my project e.g. how to run calculator(windows) from my project??..
Nilay M Shah
|
|
|
|
|
You need to call the Win32 function ShellExecute.
First add this line to the top of your source file.
Private Declare Function ShellExecute Lib "shell32.dll" Alias _
"ShellExecuteA" (ByVal hWnd As Long, ByVal lpOperation As String, _
ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, _
ByVal nShowCmd As Long) As Long
You can now launch the calculator program by doing this...
ShellExecute vbNull, "open", "calc.exe", "", "", 1
Another neat thing here is that you can also launch URLs and open documents like TXT, DOC, PDF, etc. with this. ShellExecute is the equivalent to double clicking a file in Windows Explorer.
|
|
|
|
|
i have this error when i try to move my image into the panel ...even when i drag the textbox inside i cant change anything with it..?
An unhandled exception of type 'System.NullReferenceException' occurred in SnL1.exe
Additional information: Object reference not set to an instance of an object
|
|
|
|
|
You'll have to run this code in the debugger to find out on what line the exception is being thrown. But, you're trying to do something with an instance of an object that doesn't exist, or is Nothing. Without seeing the section of code that is having the problem, that's pretty much all we can tell you.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I'm having trouble passing parameters to a COM+ service. The only code I could find to do so uses XML (see below). This works, but only certain characters are allowed. Unfortunately I am passing a stream of text that includes chr(12) formfeeds and XML of course does not like this.
Any suggestions?
'<remarks>
<system.web.services.protocols.soapdocumentmethodattribute("http: tempuri.org="" maintws="" service1="" sendlist",="" requestnamespace:="http://tempuri.org/MaintWS/Service1" ,="" responsenamespace:="http://tempuri.org/MaintWS/Service1" use:="System.Web.Services.Description.SoapBindingUse.Literal," parameterstyle:="System.Web.Services.Protocols.SoapParameterStyle.Wrapped)">
Public Function SendList(ByVal filedata As String, ByVal filename As String, ByVal clientlist As String, ByVal filetype As String, ByVal directory As String, ByVal subdirectory As String, ByVal batch As String, ByVal offline As Boolean, ByVal dir2file As String, ByVal db1 As String, ByVal db2 As String, ByVal db3 As String) As String
Dim results() As Object = Me.Invoke("SendList", New Object() {filedata, filename,
clientlist, filetype, directory, subdirectory, batch, offline, dir2file, db1, db2, db3})
Return CType(results(0),String)
End Function
|
|
|
|
|
Hi,
Using the Exception Management Application Block I can create new logs in the Event Viewer by placing the following in my app.config file:
<exceptionManagement mode="on">
<publisher
assembly="MyAppBlockTest"
type="MyAppBlockTest.ExceptionPublisher"
logname="My Test Log"
applicationname="Exception Management Application Block Test"
fileName="c:\errors.txt">
</publisher>
</exceptionManagement>
I am now trying to use the Enterprise Library and I don't know how to create a new log. I can only write to the default Application log. Can anyone tell me how I can do this?
Thanks very much,
dlarkin77
|
|
|
|
|
Please, I need a simple example of as working with Crystal Reports in Visual Basic. Net 2005, taking the data of a database made in microsoft access
Thank you
|
|
|
|
|
Hello!
My aim is to adjust (Birghtness, contrast, gamma, HZ, red, green,blue) values of video. I am able to get the pictures from a web cam but I want to be able to adjust these values also.
If you have an sample or any link, please let me know.
Thanks
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
