C#

...



namespace Keystore

{

public partial class FindKey : Form

{

public FindKey()

{

InitializeComponent();

}



DataSet ds;

System.Data.SqlClient.SqlDataAdapter da;

DatabaseHelper dataHelper = new DatabaseHelper();

DataRow dRow;



private void FindKey_Load(object sender, EventArgs e)

{

string sql = "SELECT * FROM Key";

string name = "AllKeys";

da = dataHelper.getAdapter(sql, name);

ds = dataHelper.getDataSet();



refreshList(1);

fillcboProvider();

fillcboProduct();



}



...



...



namespace Keystore

{



class DatabaseHelper

{

System.Data.SqlClient.SqlConnection con;

DataSet ds;

System.Data.SqlClient.SqlDataAdapter da;



public DatabaseHelper()

{

con = new System.Data.SqlClient.SqlConnection();

con.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\KeyStore.mdf;Integrated Security=True;User Instance=True";

ds = new DataSet();

}



public System.Data.SqlClient.SqlDataAdapter getAdapter(String sql, String name)

{

da = new System.Data.SqlClient.SqlDataAdapter(sql, con);

da.Fill(ds, name); *** Code 'finishes' the load after here ***

return da;

}



...

public void cycleThroughList()<br />
        {<br />
            for (int x = 0; x < GridDimention; x++)<br />
            {<br />
                for (int y = 0; y < GridDimention; y++)<br />
                {<br />
                    foreach (Microbe i in theWorld[x, y])<br />
                    {<br />
                        i.Talk();<br />
                        Update_Position(i);<br />
                        <br />
                    }<br />
                }<br />
            }<br />
        }<br />
<br />
public void Update_Position (Microbe m)<br />
{<br />
    if (m.sX != 0 & m.sY != 0)<br />
    { <br />
    theWorld[m.positionX, m.positionY].Remove (m);<br />
    theWorld[m.positionX + m.sX, m.positionY + m.sY].Add (m);    <br />
    }<br />
<br />
    m.Talk();<br />
}