|
:(i want a suitable code for importing a excel file into access database using vb.net
|
|
|
|
|
Why not just import it using Access, then you don't have to write any code!
What have you written so far? We'll help you with your code, but we won't write it for you.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
i have written an editor in vb.net. now i want to put the functionality of 'save' and 'save as'. the functionality must b in such a way that if a user has once saved the data, he may not b asked for the path of the file to be stored. can some one tell me how can i do that?
regards
sAqIb
"Our scientific power has outrun our spiritual power. We have guided missiles and misguided men."
Dr. Martin Luther King Jr.
|
|
|
|
|
Just save the file path in a variable and when you click your Save button, have it read the whether or not the file path is set. Like so:
If FilePath <> "" Then
SaveFunction(FilePath)
Else
SaveAs()
End If
Hope this helps you out.
Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.
|
|
|
|
|
how to set an image size as the screen resolution size?
Happy Holidays
Regards
Ramy
|
|
|
|
|
What? Are you asking how to change the magnification of the image? You would normally just use one of the DrawImage overloads that let you specify the size of the drawn image. It'll be scaled automatically to that size on the target drawing surface.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
seems that i wasnt clear
when you get the resolution size from windows control pannel
ex:800*600
i want when i run the solution,the image size will be the same size as the resolution size
Note : i m using the software : at my pcs,,thus many resolution size.
so how can i manage?
Regards
Ramy
|
|
|
|
|
charchabil03 wrote: seems that i wasnt clear
You're still not.
charchabil03 wrote: i want when i run the solution,the image size will be the same size as the resolution size
So, what's stopping you from drawing the image, or whatever your app is doing, using one of the DrawImage overloads?
You have to spell out what your app is doing and how this image is being displayed. Is it in a PictureBox? Is it the background image of a control or form? ...?
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi there,
Is there a way to update a certain dll's components in a ComPlus application via InstallShield or VB code?
Any help or hint on this will be appreciated.
Regards, Werries
A programmer's life is good... or is it?? Ek dink nie so nie!
|
|
|
|
|
If I understand the question, no you can't edit the .DLL. You have to change the code, compile it, then replace the .DLL file with the new one.
With InstallShield, you can make a patch installation that will make the necessary changes to the .DLL file, but it needs the original .DLL file and the new one to build the edit patch because the edit will only work on the version of the .DLL file.
It's a heck of a lot easier to just unregister and replace the old .DLL file with the new one and re-register.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi,
Right-clicking on a file and selecting Properties will always change
the access date, because Explorer is accessing the file to retrieve
several items of information. In Explorer, you can add "Date Accessed"
to be displayed in the "Details" view to see the "real" access date.
Also, using cmd.exe's "dir /TA" or the VBScript below shows me
different (real) access dates, so I would think it is the File class
in .Net that have the problem. I suggest you post in some of the .Net
developer newsgroups.
'--------------------8<----------------------
Set oShell = CreateObject("WScript.Shell")
Set oFSO = CreateObject("Scripting.FileSystemObject")
sDesktopPath = oShell.SpecialFolders("Desktop")
Set oFolder = oFSO.GetFolder(sDesktopPath)
For Each oFile In oFolder.Files
sFileInfo = sFileInfo & oFile.DateLastAccessed & ", " & oFile.Name & vbCrLf
Next
WScript.Echo sFileInfo
'--------------------8<----------------------
--
Regards
Bibin
|
|
|
|
|
The LastAccess date in the last time the file was read/written to. If you get Properties on a file in Explorer, the file is opened and read to fill in some of the informaiton in the Properties dialog box, like the Version of Summary tabs. This is something that we all know about. Just about noone ever uses the LastAccessed date/time either because it's too easy to change it. The LastModified date/time is far more commonly used.
You're not telling anyone anything we didn't already know. Besides, posting something like this in the forums is pointless because it'll just drop out of sight in the next week and noone ever searches the forums before they post a question anyway.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Ya..
Actually i wanted to know when the File is last opened or executed.
The requrement is like that.
I want to trace the date and time of my software's last run.
Just Understand that..This is to track the events going on in our client place.
I know that what u are telling is making the sense.
But you must know what i want..
Thanx 4 ur reply..
Any suggestions from you??
Regards
Bibin
|
|
|
|
|
you create date field in the data base update the same whenever you modify/add the data with current date that will be the last run
regards
chandru
|
|
|
|
|
Your applicaiton should log this somewhere. Depending on the security requirements, you could even log this to an encrypted XML file hidden somewhere or to the systems own event log. But, depending on the LastAccess time is not reliable at all, considering you can screw it up just by getting properties on it or if backup software runs and backs it up to tape or something.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi all ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
If we are using more then one table in my code for saving the data. If both table contain different data then what I want
I want to delete data from first table, if I get error when I am saving then data in the second table.
any property we have directly 
Nothing is Impossible in Life Need Is Try for It
Think Big Get Big
Don’t Forget To Rank Best Post
|
|
|
|
|
Is that in English?!
Please check your questions again before posting it...
|
|
|
|
|
If my english is weak then do not laugh on it...
Nothing is Impossible in Life Need Is Try for It
Think Big Get Big
Don’t Forget To Rank Best Post
|
|
|
|
|
shakti5385 wrote: If my english is weak then do not laugh on it...
Well, could you try and rephrase what you asked, because I am having difficulty understanding it also.
|
|
|
|
|
How to use connection.begintransaction in the vb.net
Nothing is Impossible in Life Need Is Try for It
Think Big Get Big
Don’t Forget To Rank Best Post
|
|
|
|
|
shakti5385 wrote: How to use connection.begintransaction in the vb.net
You put the BeginTransaction at the start of your queries. If you have an error then use RollbackTransaction to undo the changes you've made on the database. If everything works then put CommitTransaction at the end and close the connection.
A note of caution: While a transaction is in progress parts of the database will get locked out from other processes that are trying to access it. This is to ensure the safety of the transaction and other processes that are accessing the database. When you start a transaction perform the queries you need quickly so that the locks don't last long. And do not wait for user input inside a transaction.
|
|
|
|
|
can you have any code so please send me
Nothing is Impossible in Life Need Is Try for It
Think Big Get Big
Don’t Forget To Rank Best Post
|
|
|
|
|
myConnection.BeginTransaction()
If someErrorHappened Then
myConnection.RollbackTransaction()
Return
End If
myConnection.CommitTransaction()
|
|
|
|
|
Thanks Friend
Nothing is Impossible in Life Need Is Try for It
Think Big Get Big
Don’t Forget To Rank Best Post
|
|
|
|
|
Hi.
Can anyone offer some assistance with creating an invoice in vb express 2005. perhaps some code examples etc.
i looked around and can find example like richtextbox printing etc.
Thanks.
Robbo
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
