|
I wanted to avoid scripts. Is there a way to attach a database using vb .net code?
I can't think of anything cool and nerdy to say.
|
|
|
|
|
Hmm, I must have misunderstood you.  I thought you were looking for a solution to "deploy" a database. To me "deploying" a database at a client site means that they have a server waiting for you and a database needs to be created, schema created and populated, then your application can run.
If all you need to do is "attach", then why can't you just have your connection string stored in a configuration file and have it load at run time.
I must be missing something. "deploy" and "attach" have different meanings for us.
Maybe someone else can chime in a provide a soltion for you.
|
|
|
|
|
Can you help me with this? I can create database (mdf) now I need to attach it to the sql instance. How can I do that in vb .net?
I can't think of anything cool and nerdy to say.
|
|
|
|
|
Sorry, I've never worked with SQL Express, just SQL 2000, 2005 and Oracle. 
|
|
|
|
|
SQL Express is SQL 2005 with some limitations on the number of connections
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.
|
|
|
|
|
If you haven't already done so, download the SqlServer samples (theyr'e on CodePlex now not MS Download) here[^], select the *.zip file if you want to select where to put them, or the *.msi file if you want them installed to your SQLServer Directory.
There's a shedload of useful routines, mini applications and utilities in there.
The one you want isn't, from memory, but it is here on MSDN - Server.AttachDatabase Method[^]
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
I have some code and I need that to be converted into c++.net
Can anybody suggest me how to do that.?
Thanks.
|
|
|
|
|
By hand, basically. C++/CLI is a bastard stepchild of .NET and C++, so I doubt there's tools to do it, like there is for C# and VB. However, if you can build your VB into a dll and call it from C++/CLI, that would work fine.
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.
|
|
|
|
|
|
or, for a small app, you might consider using Reflector to peek into the VB.NET class(es) and copy the MC++ equivalent code from there. This would loose local variable names and comments of course, but it does allow you to avoid a separate dll file.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
I think there's also a plugin somewhere which allows you to do that with every file. I've used it before, but can't remember the name
Between the idea
And the reality
Between the motion
And the act
Falls the Shadow
|
|
|
|
|
Thanks guys...I will try to work out onn that.
|
|
|
|
|
We produce a product for this (Instant C++ VB Edition). It has a free demo edition which will convert 100 lines at a time.
David Anton
http://www.tangiblesoftwaresolutions.com
Convert VB to C#, C++, or Java
Convert C# to VB, C++, or Java
Convert C++ to C#, VB, or Java
Convert Java to C#, C++, or VB
|
|
|
|
|
I want to use Polish letters like ż, ł, ą, ę, ś, ć, and of course the capitals. VBA doesn't accept the normal "ALT GR +"-combination. Copy/Paste also doesn't work.
Please can somebody advice?
With kind regards,
Ton C.
|
|
|
|
|
|
Dear Shay Noy,
I downloaded and installed the Polish fonts, as you advised. But it doesn't work. When I use ALT+GR+ I get completely different characters. Maybe you have an other suggestion?
Thanks for your efforts anyway.
Greetings,
Ton C
|
|
|
|
|
I must be missing something.
I tested this in a small stand alone application and it works fine (sample project I downloaded)
Protected Sub PrintFile_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles PrintFile.Click
printDialog1.Document = ThePrintDocument 'ThePrintDocument is dfined as System.Drawing.Printing.PrintDocument
If printDialog1.ShowDialog() = DialogResult.OK Then
Me.ThePrintDocument.Print()
End If
End Sub 'PrintFile_Click
I have a sub routine that does the printing as follows:
Protected Sub ThePrintDocument_PrintPage(ByVal sender As Object, ByVal ev As System.Drawing.Printing.PrintPageEventArgs) Handles ThePrintDocument.PrintPage
...
...
...
End Sub 'ThePrintDocument_PrintPage
In my small test app this works perfectly, print dialog shows up, select destination and it calls the print page routine. I then incorporated this into the application I am upgrading and I get the print dialog but when I click OK on the dialog it does not return to call the print event. Any idea what I may have missed?
I did notice that if I search the sample project for ThePrintDocument in the sample project I see definitions in a resx file, but I do not understand the resx file or how to use it.
I defined by simply entering the definition, should I have dragged something from the toolbox perhaps?
Friend WithEvents ThePrintDocument As System.Drawing.Printing.PrintDocument
Thanks in advance
No-e
|
|
|
|
|
No-e wrote: should I have dragged something from the toolbox perhaps
In your stand alone application, if you open the Form in the designer and can see a PrintDocument component in the Component Tray (at the bottom of the screen), then that was how it was done by the writer of that application.
Adding it manually, as you have done, should still work though. If it were me I would delete the manual declaration and use the component from the Printing tab of the toolbox, assuming that that's how the stand alone application did it. Also ensure that the properties are all set the same too.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Thanks, I deleted and added them from the toolbox, still a no go. It just does not seem to want to come back from the dialog box. Is there a way to chase down what may be happening after I close the box?
No-e
|
|
|
|
|
Firstly ensure that all of the properties and events of the PrintDocument are the same as in the stand alone application. Do the Same for the PrintDialog. It is distinctly possible that in the stand alone application the PrintDocument.PrintPage event was being handled, but not in your new application. Without handling PrintPage, you won't get any output.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Hi,
if anything, we should see the code related to ThePrintDocument.
Are you sure the variable isn't Nothing?
You need to debug, i.e. for one make sure ThePrintDocument_PrintPage gets called at all.
Are you using any other PrintDocument events? Not that you should, but you could test for PrintDocument.BeginPrint being fired.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
I checked the ThePrintDocument_PrintPage is called. Thanks for your help, it turns out that a timer in the background fires perfectly every time in the studio and holds me up. Once I run the compiled version it behaves differently. I have got a nice work around. Interesting, being used to VB6 (from which I am converting) I did not see this type of behavior.
The app I am converting used the MScomm32 control quite a bit (serial comms) and I would like to better know how VB6 changes relative to .net as I see these differences in the debugger. (does .net have a better control?) If anyone can point me in a good direction, I am glad to learn it. I am not sure what to google. I see this difference in behavior (the timer I reference) in the debugger, I am not sure how timing and such works in .net., and or what my best bets are for debugging. A good reference or something to search on would be helpful
(converting code written years ago by someone else, but I am getting close
Thanks to CP for your help to date
no-e
|
|
|
|
|
Hi,
three comments:
1.
for serial communications .NET offers the SerialPort class (starting .NET 2.0). It works fine for me. Warning: its DataReceived event fires on a ThreadPool thread (see #3 below).
2.
There are several timer classes in .NET; which one you use best depends on what it needs to do.
Example: for Control manipulations (say displaying real time, updating every second) you best use System.Windows.Forms.Timer which ticks on the GUI thread.
3.
only the main aka GUI thread is allowed to touch Controls; if you violate this rule strange things are bound to happen.
Since you only now told about serial ports and timers, I now suspect it is #3 that is biting you.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Dear all,
I would like to make a narrow width combo box on the toolstrip control.
It seems to limit me to 75px and greater.
I would like to make a FontSize drop down which includes numbers from 1 to 7.
Or should I use drop down images? but then it doesn't look "windowsy"
Thank you
Andrew
|
|
|
|
|
Set the Autosize property of ToolStripDropDownButton to false and then set width as you want.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
