where to open connection in c# .net windows form application I am new to c# .net

Question

0.00/5 (No votes)

See more:

I am new to c#

Is it possible in c# like vb to open connection one time in module and use through out application in windows form application.

Where to open connection in c# windows form application.

Please help me.

Thanks in Advance.

Posted 6-Jun-11 18:34pm

surabhikalra

Updated 6-Jun-11 21:56pm

v3

Add a Solution

Comments

Sergey Alexandrovich Kryukov 7-Jun-11 0:44am

There is not such language as C#.NET.
--SA

Wild-Programmer 7-Jun-11 1:20am

I am also sometimes confused with that. Please correct me if I am wrong, .NET is a framework and VB, C#, F# etc are languages. Right?

Sergey Alexandrovich Kryukov 7-Jun-11 0:45am

What do you mean by connection?
--SA

7 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wild-Programmer · Answer 1 · 2011-06-06T18:40:00

Solution 1

Yes it is possible. The closest equivalent to a VB module is a static class in C# 2.0 (or a sealed C# class with static members prior to 2.0).

Posted 6-Jun-11 18:40pm

Wild-Programmer

Abhinav S · Answer 2 · 2011-06-06T18:46:00

Solution 2

Just like in VB, you can place the Connection.Open string somewhere in a global class in the data access layer.
You can make this class a singleton, if you want only one instance of this class to exist.

Posted 6-Jun-11 18:46pm

Abhinav S

Ramalinga Koushik · Answer 3 · 2011-06-06T18:50:00

Solution 3

Hope link1[^] and Link2[^]might help you.

Posted 6-Jun-11 18:50pm

Ramalinga Koushik

RakeshMeena · Answer 4 · 2011-06-06T19:15:00

Solution 4

Why you want to keep connection open?

Posted 6-Jun-11 19:15pm

RakeshMeena

anvas kuttan · Answer 5 · 2011-06-06T21:30:00

hi

SqlConnection cs1 = new SqlConnection("Data Source=nemesisfc; Initial Catalog=FreezerTemps; Integrated Security=TRUE");
            SqlCommand cmd1 = new SqlCommand();
            cs1.Open();
            cmd1.CommandText = "write ur sql select query here";
            DataSet dtst = new DataSet();
            SqlDataAdapter dp = new SqlDataAdapter(cmd1);
            dp.Fill(dtst);// for select query

            cs1.Close();

this will help

anvas kuttan · Answer 6 · 2011-06-06T21:30:00

hi

SqlConnection cs1 = new SqlConnection("Data Source=nemesisfc; Initial Catalog=FreezerTemps; Integrated Security=TRUE");
            SqlCommand cmd1 = new SqlCommand();
            cs1.Open();
            cmd1.CommandText = "write ur sql select query here";
            DataSet dtst = new DataSet();
            SqlDataAdapter dp = new SqlDataAdapter(cmd1);
            dp.Fill(dtst);// for select query

            cs1.Close();

this will help

Sridhar Patnayak · Answer 7 · 2011-06-06T21:52:00

Solution 7

Use App.Config file for connection open. So that you can use this connection where ever you want (the connection is available for entire application)

Posted 6-Jun-11 21:52pm

Sridhar Patnayak

Updated 6-Jun-11 21:53pm

v2