How to keep data available for whole project access?
<p>Well. I have done a small project. </p>

<p>But the problem is some of my required data is not available across whole project. </p>

<p>I mean, every time I go form to form I need to open the database and fill the same data from the same SqlDataAdapter. </p>

<p>Instead is it possible to keep the data somewhere globally for all the project forms?</p>

<p>With my project I have a class for the queries and tables and wherever I need data in the forms, there I use to call the Subs for filling the table like the below...</p>

<pre><code>Class1.cs
=========
public void MyTableFill()
       {
            Con.ConnectionString = Con_1;
            Con.Open();
            SQLDAp = new SqlDataAdapter(MyQry, Con);
            SQLDAp.Fill(MyTable);
            Con.Close();
        }

Form1.cs
========
Class1 MyDatas = new Class1();

Form1_Load()
        {
            MyDatas.MyTableFill();
        }

Form2.cs
========
Class1 AccDatas=new Class1();

Form2_Load()
        {
            AccDatas.MyTableFill();
        }
</code></pre>

<p>Thanks</p>
