Re: Problem in ConnectionString - Visual Basic Discussion Boards

First Prev Next

Re: Attach/Detach SQL Server database !

jeshra27919-Oct-09 5:19

jeshra279

19-Oct-09 5:19

Hi,
Can you pls elaborate how to do this?

Re: Attach/Detach SQL Server database !

Russ-T19-Oct-09 13:46

Russ-T

19-Oct-09 13:46

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

Problem in ConnectionString

vijay248219-Oct-09 3:14

vijay2482

19-Oct-09 3:14

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.

Re: Problem in ConnectionString

Kschuler19-Oct-09 4:32

Kschuler

19-Oct-09 4:32

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.

Re: Problem in ConnectionString

vijay248219-Oct-09 4:39

vijay2482

19-Oct-09 4:39

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.

Re: Problem in ConnectionString

Kschuler19-Oct-09 5:03

Kschuler

19-Oct-09 5:03

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?

Re: Problem in ConnectionString

vijay248219-Oct-09 5:18

vijay2482

19-Oct-09 5:18

There's no error msg produced. I tried debugging, but no use.
Have also used User ID and Password portions, but no progress.

Re: Problem in ConnectionString

Kschuler19-Oct-09 5:22

Kschuler

19-Oct-09 5:22

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.

Re: Problem in ConnectionString

Mycroft Holmes19-Oct-09 14:46

Mycroft Holmes

19-Oct-09 14:46

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.

Delete file Completely from PC [SOLVED]

vijay248219-Oct-09 2:39

vijay2482

19-Oct-09 2:39

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.

Re: Delete file Completely from PC

Tom Deketelaere19-Oct-09 2:50

Tom Deketelaere

19-Oct-09 2:50

vijay2482 wrote:
but it puts it in Recycle Bin

Not on my end

system.io.file.delete()

permently deletes the file

Re: Delete file Completely from PC

vijay248219-Oct-09 3:01

vijay2482

19-Oct-09 3:01

Thanks, it worked.

Re: Delete file Completely from PC

Luc Pattyn19-Oct-09 2:51

Luc Pattyn

19-Oct-09 2:51

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?

Smile | :)

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.

Re: Delete file Completely from PC [SOLVED]

Dave Kreskowiak19-Oct-09 5:29

Dave Kreskowiak

19-Oct-09 5:29

The code you posted does exactly what you want. It does not put files in the Recycle Bin.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Setting Back Color to a MessageBox

vijay248219-Oct-09 2:37

vijay2482

19-Oct-09 2:37

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

MessageBox.Show(msg, title, MessageBoxButtons.YesNo, MessageBoxIcon.Warning)

Any suggestions please.
Thanks in Advance.

Re: Setting Back Color to a MessageBox

Tom Deketelaere19-Oct-09 2:43

Tom Deketelaere

19-Oct-09 2:43

Best way would be to roll your own messagebox

Or go this way: http://msdn.microsoft.com/en-us/magazine/cc188920.aspx[^]

but looks like it will get complicated very fast.

Re: Setting Back Color to a MessageBox

vijay248219-Oct-09 3:15

vijay2482

19-Oct-09 3:15

Thanks.
Will checkout the link.

How to copy a Msword Document table into Clipboard.?

Paramu197319-Oct-09 1:00

Paramu1973

19-Oct-09 1:00

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(??????????) Confused | :confused:

richtextbox5.paste()

Thanks Thumbs Up | :thumbsup:

Re: How to copy a Msword Document table into Clipboard.?

Christian Graus19-Oct-09 1:09

Christian Graus

19-Oct-09 1:09

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.

Re: How to copy a Msword Document table into Clipboard.?

Paramu197319-Oct-09 1:41

Paramu1973

19-Oct-09 1:41

Copy to richtextbox is enough at this moment.
Converting to RTF also like to learn.

Thanks Cool | :cool:

Re: How to copy a Msword Document table into Clipboard.?

Luc Pattyn19-Oct-09 2:57

Luc Pattyn

19-Oct-09 2:57

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.

Smile | :)

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.

Re: How to copy a Msword Document table into Clipboard.?

Dave Kreskowiak19-Oct-09 5:25

Dave Kreskowiak

19-Oct-09 5:25

Tell Word to copy the selection Range to the clipboard using its Copy method.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

what's the regular expression for values and names

arabicwind19-Oct-09 0:55

arabicwind

19-Oct-09 0:55

hi guys

does anyone know the regular expressions for catching names and values in input?

I'm using this one input.*value=(?:""(?<1>[^""]*)"") but it only gives me the values.

I need to get the values and names for any kind of HTML components.

thank you

Re: what's the regular expression for values and names

Dave Kreskowiak19-Oct-09 5:19

Dave Kreskowiak

19-Oct-09 5:19

Google for "Expresso". Its a great little utility you can use to build Regular Expressions and test with with any sample data you want. Doing RegEx without it is just silly.

We really can't tell you what the expression is without knowing the details of what is legal to make a valid name/value pair.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Re: what's the regular expression for values and names

arabicwind19-Oct-09 16:48

arabicwind

19-Oct-09 16:48

thank you so much Dave Kreskowiak. The Expresso program helps me alot.

Last Visit: 31-Dec-99 18:00 Last Update: 15-May-24 10:48

Refresh

ᐊ Prev 1...863 864 865 866867868 869 870 871 872 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.