Ado.net and mdi form

[JFB]

Hi,
Can I define just one connection string in the MDI form and use it in all
the forms?
Or Do I need to create a connection for each form?
Tks
JFB
Private connectionString As String = "Data Source=SQLServer;Initial
Catalog=DBName;user=sa;password=pass"

[Armin Zingler]

"JFB" <jf*****@directvinternet.com> schrieb

Hi,
Can I define just one connection string in the MDI form and use it in
all the forms?
Or Do I need to create a connection for each form?
Tks
JFB
Private connectionString As String = "Data
Source=SQLServer;Initial Catalog=DBName;user=sa;password=pass"

You can pass the connection or only the connectionstring.
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[JFB]

Tks for reply Armin,
How can I pass the the connectionstring?
Sorry but I'm new....
JFB
"Armin Zingler" <az*******@freenet.de> wrote in message
news:#4**************@TK2MSFTNGP11.phx.gbl...

"JFB" <jf*****@directvinternet.com> schrieb

Hi,
Can I define just one connection string in the MDI form and use it in
all the forms?
Or Do I need to create a connection for each form?
Tks
JFB
Private connectionString As String = "Data
Source=SQLServer;Initial Catalog=DBName;user=sa;password=pass"

You can pass the connection or only the connectionstring.
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[EricJ]

in addition
if you declare the string in your parent form as public shared you can
access it from the other forms 2
"JFB" <jf*****@directvinternet.com> wrote in message
news:u9**************@TK2MSFTNGP12.phx.gbl...

Tks for reply Armin,
How can I pass the the connectionstring?
Sorry but I'm new....
JFB
"Armin Zingler" <az*******@freenet.de> wrote in message
news:#4**************@TK2MSFTNGP11.phx.gbl...

"JFB" <jf*****@directvinternet.com> schrieb

Hi,
Can I define just one connection string in the MDI form and use it in
all the forms?
Or Do I need to create a connection for each form?
Tks
JFB
Private connectionString As String = "Data
Source=SQLServer;Initial Catalog=DBName;user=sa;password=pass"

You can pass the connection or only the connectionstring.
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[Armin Zingler]

"JFB" <jf*****@directvinternet.com> schrieb

Tks for reply Armin,
How can I pass the the connectionstring?
Sorry but I'm new....
JFB

You can write a procedure. A procedure can have arguments. An argument is
something you pass to the procedure. In this case it is the connection
string.

http://msdn.microsoft.com/library/en...nArguments.asp

Alternatively, you can add a property to the object that needs the string.
By setting the property the object also gets the string.

http://msdn.microsoft.com/library/en...Properties.asp

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

--
Armin

[JFB]

Tks for reply Eric,
I just declare my connection like below but looks like is not declare in my
child form. Do I need to do something special in my child form?
JFB
Public Shared connectionString As String = "DataSource=SQLServer;Initial
Catalog=DBName;user=sa;password=pass"

"EricJ" <ericRéMo**@ThiSomnipack.be> wrote in message
news:3f***********************@reader0.news.skynet .be...

in addition
if you declare the string in your parent form as public shared you can
access it from the other forms 2
"JFB" <jf*****@directvinternet.com> wrote in message
news:u9**************@TK2MSFTNGP12.phx.gbl...

Tks for reply Armin,
How can I pass the the connectionstring?
Sorry but I'm new....
JFB
"Armin Zingler" <az*******@freenet.de> wrote in message
news:#4**************@TK2MSFTNGP11.phx.gbl...

"JFB" <jf*****@directvinternet.com> schrieb
> Hi,
> Can I define just one connection string in the MDI form and use it in > all the forms?
> Or Do I need to create a connection for each form?
> Tks
> JFB
> Private connectionString As String = "Data
> Source=SQLServer;Initial Catalog=DBName;user=sa;password=pass"

You can pass the connection or only the connectionstring.
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[Armin Zingler]

"JFB" <jf*****@directvinternet.com> schrieb

Tks for reply Eric,
I just declare my connection like below but looks like is not declare
in my child form. Do I need to do something special in my child
form? JFB
Public Shared connectionString As String =
"DataSource=SQLServer;Initial
Catalog=DBName;user=sa;password=pass"

http://msdn.microsoft.com/library/en...redMembers.asp
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[EricJ]

i normally put my public vars in a module (dous the share automaticly)

"JFB" <jf*****@directvinternet.com> wrote in message
news:uO**************@TK2MSFTNGP10.phx.gbl...

Tks for reply Eric,
I just declare my connection like below but looks like is not declare in my child form. Do I need to do something special in my child form?
JFB
Public Shared connectionString As String = "DataSource=SQLServer;Initial
Catalog=DBName;user=sa;password=pass"

"EricJ" <ericRéMo**@ThiSomnipack.be> wrote in message
news:3f***********************@reader0.news.skynet .be...

in addition
if you declare the string in your parent form as public shared you can
access it from the other forms 2
"JFB" <jf*****@directvinternet.com> wrote in message
news:u9**************@TK2MSFTNGP12.phx.gbl...

Tks for reply Armin,
How can I pass the the connectionstring?
Sorry but I'm new....
JFB
"Armin Zingler" <az*******@freenet.de> wrote in message
news:#4**************@TK2MSFTNGP11.phx.gbl...
> "JFB" <jf*****@directvinternet.com> schrieb
> > Hi,
> > Can I define just one connection string in the MDI form and use it in > > all the forms?
> > Or Do I need to create a connection for each form?
> > Tks
> > JFB
> > Private connectionString As String = "Data
> > Source=SQLServer;Initial Catalog=DBName;user=sa;password=pass"
>
> You can pass the connection or only the connectionstring.
>
>
> --
> Armin
>
> http://www.plig.net/nnq/nquote.html
> http://www.netmeister.org/news/learn2quote.html
>

[JFB]

Cool.. tks for the info folks
JFB

"JFB" <jf*****@directvinternet.com> wrote in message
news:uO**************@TK2MSFTNGP10.phx.gbl...

Tks for reply Eric,
I just declare my connection like below but looks like is not declare in my child form. Do I need to do something special in my child form?
JFB
Public Shared connectionString As String = "DataSource=SQLServer;Initial
Catalog=DBName;user=sa;password=pass"

"EricJ" <ericRéMo**@ThiSomnipack.be> wrote in message
news:3f***********************@reader0.news.skynet .be...

in addition
if you declare the string in your parent form as public shared you can
access it from the other forms 2
"JFB" <jf*****@directvinternet.com> wrote in message
news:u9**************@TK2MSFTNGP12.phx.gbl...

Tks for reply Armin,
How can I pass the the connectionstring?
Sorry but I'm new....
JFB
"Armin Zingler" <az*******@freenet.de> wrote in message
news:#4**************@TK2MSFTNGP11.phx.gbl...
> "JFB" <jf*****@directvinternet.com> schrieb
> > Hi,
> > Can I define just one connection string in the MDI form and use it in > > all the forms?
> > Or Do I need to create a connection for each form?
> > Tks
> > JFB
> > Private connectionString As String = "Data
> > Source=SQLServer;Initial Catalog=DBName;user=sa;password=pass"
>
> You can pass the connection or only the connectionstring.
>
>
> --
> Armin
>
> http://www.plig.net/nnq/nquote.html
> http://www.netmeister.org/news/learn2quote.html
>