Re: No scripts - Visual Basic Discussion Boards

Cory Kimble13-Jul-09 8:25

13-Jul-09 8:25

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.

Re: Database deployment. using VB .net

David Mujica13-Jul-09 8:53

David Mujica

13-Jul-09 8:53

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'

Re: Database deployment. using VB .net

Cory Kimble13-Jul-09 8:58

Cory Kimble

13-Jul-09 8:58

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.

No scripts

David Mujica13-Jul-09 9:17

David Mujica

13-Jul-09 9:17

Hmm, I must have misunderstood you. Confused | :confused:

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.

Re: No scripts

Cory Kimble13-Jul-09 10:40

Cory Kimble

13-Jul-09 10:40

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.

Re: No experience with SQL Express

David Mujica13-Jul-09 10:44

David Mujica

13-Jul-09 10:44

Sorry, I've never worked with SQL Express, just SQL 2000, 2005 and Oracle. Frown | :(

Re: No experience with SQL Express

Christian Graus13-Jul-09 10:59

Christian Graus

13-Jul-09 10:59

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.

Re: No scripts

Henry Minute13-Jul-09 11:34

Henry Minute

13-Jul-09 11:34

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.”

how to convert any VB.NET code into C++.net

samvaidy13-Jul-09 7:41

samvaidy

13-Jul-09 7:41

I have some code and I need that to be converted into c++.net
Can anybody suggest me how to do that.?

Thanks.

Re: how to convert any VB.NET code into C++.net

Christian Graus13-Jul-09 7:43

Christian Graus

13-Jul-09 7:43

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.

Re: how to convert any VB.NET code into C++.net

samvaidy13-Jul-09 10:00

samvaidy

13-Jul-09 10:00

Thanks

Re: how to convert any VB.NET code into C++.net

Luc Pattyn13-Jul-09 8:10

Luc Pattyn

13-Jul-09 8:10

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.

Smile | :)

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.

Re: how to convert any VB.NET code into C++.net

0x3c013-Jul-09 9:13

0x3c0

13-Jul-09 9:13

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

Re: how to convert any VB.NET code into C++.net

samvaidy13-Jul-09 9:59

samvaidy

13-Jul-09 9:59

Thanks guys...I will try to work out onn that.

Re: how to convert any VB.NET code into C++.net

Dave Doknjas13-Jul-09 14:13

Dave Doknjas

13-Jul-09 14:13

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

How to use special symbols in VBA?

Ton C13-Jul-09 6:10

Ton C

13-Jul-09 6:10

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.

Re: How to use special symbols in VBA?

helelark12313-Jul-09 18:50

helelark123

13-Jul-09 18:50

I think that you have to install Polish font in your PC and change your control (Label, Textbox,...) font to this installed one.
You can download Polish font from:
http://www.kwintessential.co.uk/fonts/polish/download.html[^]

Shay Noy

Re: How to use special symbols in VBA?

Ton C14-Jul-09 22:58

Ton C

14-Jul-09 22:58

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

Print Dialog

No-e13-Jul-09 5:08

No-e

13-Jul-09 5:08

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

Re: Print Dialog

Henry Minute13-Jul-09 5:18

Henry Minute

13-Jul-09 5:18

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.

Re: Print Dialog

No-e13-Jul-09 5:33

No-e

13-Jul-09 5:33

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

Re: Print Dialog

Henry Minute13-Jul-09 5:54

Henry Minute

13-Jul-09 5:54

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.

Re: Print Dialog

Luc Pattyn13-Jul-09 6:14

Luc Pattyn

13-Jul-09 6:14

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.

Smile | :)

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.

Re: Print Dialog

No-e13-Jul-09 11:57

No-e

13-Jul-09 11:57

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 Smile | :)

Thanks to CP for your help to date

no-e

Re: Print Dialog

Luc Pattyn13-Jul-09 12:31

Luc Pattyn

13-Jul-09 12:31

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.

Smile | :)

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.

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