|
Hi,
System.Core 3.5.0.0 is part of .NET 3.5 which seems to be a prerequisite of your app.
There are two ways to go now:
- maybe you don't really need .NET features beyond .NET 2.0 and could rebuild your app for .NET 2.0, giving it a much bigger probability of running on modern PCs (you can choose the target .NET version in your project settings);
- or you keep the app as is, and make sure .NET 3.5 is installed; creating an installer would allow you to check for that automatically.
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
Local announcement (Antwerp region): Lange Wapper? 59.24% waren verstandig genoeg om NEEN te stemmen; bye bye viaduct.
|
|
|
|
|
Thank you very much i think that helps.
|
|
|
|
|
Hi Everyone,
I have created one button in VB .net which on click creates a backup/copy of my sql database file, i.e. client.mdf file, into a separate folder. The code is like this:
Private Sub Button_Click()
Dim dbdlg As New FolderBrowserDialog()
con.Close()
CurrentDatabasePath = "F:\..\client.mdf"
If dbdlg.ShowDialog() = Windows.Forms.DialogResult.OK Then
Dim pathtobackup As String
pathtobackup = dbdlg.SelectedPath.ToString()
File.Copy(CurrentDatabasePath, pathtobackup, True)
End If
End Sub
The error I am getting while executing File.Copy statement.It shows :
The process cannot access the file 'F:\...\client.mdf' because it is being used by another process.
Can someone tell me how to resolve this error? I think I have to detach the database, if yes, how?
Thanks
R.S
|
|
|
|
|
You can't make a copy of the .mdf file while SQL server is running. Instead of trying to copy live database file, why not try running a TSQL query to backup the database to a separate file and then copying or moving that?
The SQL required looks something like this:
BACKUP DATABASE MyDatabase TO DISK = 'C:\Temp\MyDatabase.BAK' WITH INIT;
Now you can just write some VB code to shift the newly created .bak file.
Hope that helps!
|
|
|
|
|
Hi,
Can you pls elaborate how to do this?
|
|
|
|
|
jeshra279 wrote: Can you pls elaborate how to do this?
1) Run the TSQL backup query on the database that you want to back up
2) MSSQL will create the backup (.bak file) in the location you specified in the query
3) Run your VB.net routine to copy or move the .bak file to the location of your choice
|
|
|
|
|
Hi
I have a function that returns the connection to DBASE server.
I use this function to connect to the server.
When I use for testing with the .mdb database, the connection is set and application worksd fine.
When I use the server address in Data Source to connect, the application is exited.
I dont understand why this happens.
Any help on this will be very much helpful.
Thanks in Advance.
modified 28-Nov-12 7:53am.
|
|
|
|
|
Are you getting an error message? If so, it would be helpful if you could include it.
So you're saying that is works when you use the bottom connection string, but not when you use the top one? The top one doesn't have the .mdb extention, is it supposed to? Does the user have access to that network path? Is that database protected by a username/password that you forgot to include?
Hope these suggestions will help you find your answer.
|
|
|
|
|
Yes, works fine for .mdb file.
There should'nt be a extension for DBASE database.
User has access to that path.
there is no username/password for that drive.
|
|
|
|
|
How about an error message? Perhaps if you debug the program you can get a more detailed error message?
My only other thought is to use the User ID and Password portions of the connection string, even if your database doesn't have one?
|
|
|
|
|
There's no error msg produced. I tried debugging, but no use.
Have also used User ID and Password portions, but no progress.
|
|
|
|
|
Well, then perhaps it's not the connection string that is causing the problem. How about posting more of your code, like where the connection string gets used or looking through some of the first bits of code that get run when your program launches.
|
|
|
|
|
I have not used DBase for years, have you checked out connectionstrings.com for the right syntax.
DBase IV came in a number of flavours and not all drivers (Jet) work with all flavours. I know I'm using a foxpro driver to get at some of our files so you may be running into a compatibility problem. Sorry I have no idea how to get around it other than testing each driver till one works.
|
|
|
|
|
I know that the below line will delete the file,but it puts it in Recycle Bin.
I want to delete the file completely from the PC.
File.Delete("C:\l\A.txt")
Any suggestion will be helpful.
Thanks in Advance.
modified on Monday, October 19, 2009 9:01 AM
modified 28-Nov-12 7:54am.
|
|
|
|
|
vijay2482 wrote: but it puts it in Recycle Bin
Not on my end
system.io.file.delete()
permently deletes the file
|
|
|
|
|
|
vijay2482 wrote: it puts it in Recycle Bin
I don't think so. IFAIK putting deleted files in the recycle bin is part of Windows Explorer functionality, not of the file system; and File.Delete is a file system operation. You can easily verify. What is your OS?
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
Local announcement (Antwerp region): Lange Wapper? 59.24% waren verstandig genoeg om NEEN te stemmen; bye bye viaduct.
|
|
|
|
|
The code you posted does exactly what you want. It does not put files in the Recycle Bin.
|
|
|
|
|
I have a messagebox created during run time, I want to set the color of the messagebox to White.
Code:
Private Function AddNonSuffixToSheet(ByVal cd As DataLine) As Boolean
'non suffix cao
Dim response As DialogResult
Dim backcolor As Color = Color.White
Dim title As String = "AVERTISSEMENT - Non Suffixe CAO"
Dim msg As String = ""
msg = msg & "Group-Unit/Assy : " & cd.parent & vbCrLf
msg = msg & "Nombre de composant: " & cd.enfant & vbCrLf
msg = msg & "Non Suffixe CAO" & vbCrLf
msg = msg & "Pour créer et ajouter à la feuille de calcul cliquez sur Oui" & vbCrLf
response = MessageBox.Show(msg, title, MessageBoxButtons.YesNo, MessageBoxIcon.Warning)
Return (response = DialogResult.Yes)
End Function
I'm not sure where to use backcolor
Dim backcolor As Color = Color.White
in
MessageBox.Show(msg, title, MessageBoxButtons.YesNo, MessageBoxIcon.Warning)
Any suggestions please.
Thanks in Advance.
|
|
|
|
|
|
Thanks.
Will checkout the link.
|
|
|
|
|
Hi,
Iam using Vb.Net 2008. I want to copy a table and its contents from microsoft woord to clipboard.
Any better ideas?
My Codings:
Dim mf As New Microsoft.Office.Interop.Word.Application
mf.Documents.Open("C:\yanyee\myfile.doc")
mf.ActiveDocument.Tables(1).Select()
Clipboard.SetText(??????????)
richtextbox5.paste()
Thanks 
|
|
|
|
|
It's not just text, tho. If you're pasting into a rich text box, don't you want to convert to rtf ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Copy to richtextbox is enough at this moment.
Converting to RTF also like to learn.
Thanks
|
|
|
|
|
I think you missed the point; SetText sets text, unformatted text, so it no longer would be a table.
RTF is a document representation that can hold content and formatting, it is the base on which RichTextBox and WordPad work; and other programs understand it too, such as MS Word.
The clipboard can hold many representations; one of them is called "Rich Text Format". However you can't set that using just SetText. I suggest you read up on Clipboard and perform some experiments.
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
Local announcement (Antwerp region): Lange Wapper? 59.24% waren verstandig genoeg om NEEN te stemmen; bye bye viaduct.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
