C#

datastruct wrote:

I am currently building a window application and i want the system to use a single database connection for all its queries. So, i want to created a global connection object on login and use this very same object throughout my application when a database connection is required. Can you please help me on this?

public static Dal
{
    private static SqlConnection theConnection;
 
    public static ConnectionString
    {
        set
        {
            theConnection = new SqlConnection(value)
        }
    }
 
    public static DataSet SomeQuery(int id)
    {
        // Write the code to perform the query here.
    }
}

Christian Graus wrote:

You forgot to make somequery static

Manoj Kumar Rai wrote:

This class should have a member function to return the object of type "OdbcConnection".

Life as a Coder wrote:

But somehow it missed some characters.

Ramu.M wrote:

Is it possible to enable controls on the form from a class

class MyForm : Form
{
    ...
 
    // The form class needs a mechanism to receive the request to
    // disable the controls.
    public void DisableControls()
    {
        // Code to disable the controls goes here
    }
}
 
class MyOtherClass
{
    // The other class needs to store the form
    private MyForm myForm;
 
    // In this example the other class gets told about the form at
    // the time it is instantiated. It could also set up a property
    // to receive that information.
    public MyOtherClass(MyForm myForm)
    {
        this.myForm = myForm;
    }
 
    // The class has some code somewhere that needs to disable the
    // controls on the form.
    public SomeMethodThatNeedsToDisableTheControls()
    {
        ...
        myForm.DisableControls();
        ...
    }
}

<br />
public class ControlForm<br />
{<br />
     public static void EnableTextBox()<br />
     {<br />
          FrmTest frmTest = new frmTest();<br />
          frmTest.txtName.Enable = true;<br />
     }<br />
}<br />

Manoj Kumar Rai wrote:

The Delegate will remove the requirement to declare control objects (Text etc) public.