|
|
nope the watcher will get the message in the message box then save it to a log file
thanks for the links, will check later
|
|
|
|
|
Is there a way that vb .net can help deploying a SQL database. I want a way I can create an install disc and have the user run the install disc and have the sql database with mdf files install.
Does anyone know a way to do this? I know I can run the sql database installer from the setup, but how do I get the mdf files to automatically attach and be usable?
I can't think of anything cool and nerdy to say.
|
|
|
|
|
You could write some TSQL to automate the creation of a database, logi, user, tables, views, indexes, etc, and have you clients execute the script.
Commands to research:
CREATE DATABASE 'MYNEWDATABASE'
CREATE LOGIN
CREATE USER
sp_addrolemember 'db_owner','MYNEWDATABASE'
|
|
|
|
|
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.
|
|
|
|