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"

"JFB" <(E-Mail Removed)> 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

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


"Armin Zingler" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> "JFB" <(E-Mail Removed)> 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
>

in addition
if you declare the string in your parent form as public shared you can
access it from the other forms 2


"JFB" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Tks for reply Armin,
> How can I pass the the connectionstring?
> Sorry but I'm new....
> JFB
>
>
> "Armin Zingler" <(E-Mail Removed)> wrote in message
> news:#(E-Mail Removed)...
> > "JFB" <(E-Mail Removed)> 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" <(E-Mail Removed)> 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

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é(E-Mail Removed)> wrote in message
news:3fd6d245$0$27220$(E-Mail Removed)...
> in addition
> if you declare the string in your parent form as public shared you can
> access it from the other forms 2
>
>
> "JFB" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Tks for reply Armin,
> > How can I pass the the connectionstring?
> > Sorry but I'm new....
> > JFB
> >
> >
> > "Armin Zingler" <(E-Mail Removed)> wrote in message
> > news:#(E-Mail Removed)...
> > > "JFB" <(E-Mail Removed)> 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" <(E-Mail Removed)> 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

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

"JFB" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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é(E-Mail Removed)> wrote in message
> news:3fd6d245$0$27220$(E-Mail Removed)...
> > in addition
> > if you declare the string in your parent form as public shared you can
> > access it from the other forms 2
> >
> >
> > "JFB" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > Tks for reply Armin,
> > > How can I pass the the connectionstring?
> > > Sorry but I'm new....
> > > JFB
> > >
> > >
> > > "Armin Zingler" <(E-Mail Removed)> wrote in message
> > > news:#(E-Mail Removed)...
> > > > "JFB" <(E-Mail Removed)> 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
> > > >
> > >
> > >
> >
> >
>
>

Cool.. tks for the info folks
JFB

"JFB" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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é(E-Mail Removed)> wrote in message
> news:3fd6d245$0$27220$(E-Mail Removed)...
> > in addition
> > if you declare the string in your parent form as public shared you can
> > access it from the other forms 2
> >
> >
> > "JFB" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > Tks for reply Armin,
> > > How can I pass the the connectionstring?
> > > Sorry but I'm new....
> > > JFB
> > >
> > >
> > > "Armin Zingler" <(E-Mail Removed)> wrote in message
> > > news:#(E-Mail Removed)...
> > > > "JFB" <(E-Mail Removed)> 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
> > > >
> > >
> > >
> >
> >
>
>