C#

avanwieren wrote:

You don't have to close your connection when you are done as this will do it for you.

using (SqlConnection connection = new SqlConnection(connectionString))
{
    Do some thing with the database here!
}//This provides the dispose method for you!

connection.open();
connection.close();

avanwieren wrote:

when you hit the final end bracket of the using statement

DataTable dbsDataTable_= new DataTable("DT_Teams");
string strQuery = "SELECT * FROM t_DT_Teams;
string connectionstring = "YourConnectionString";

using(OleDbConnection connection = new OleDbConnection(connectionString)
{
     OleDbCommand dbsCommand = connection.CreateCommand();
     dbsCommand.CommandText = strQuery;

     OleDbDataAdapter dbsAdapter = new OleDbDataAdapter(dbsCommand);
     dbsAdapter.Fill(dbsDataTable);
}

DataRow[] result;
//Expresion similar to where clause
string expression= "column (= > <)value)";
result = dbsDataTable.Select(expression);

deanpugh wrote:

I was originally using a datareader but because i look at the team table and then search the players table, it wouldnt let me open more than one datareader at a time and wanted me to close any existing ones, which I couldnt do because I needed to go back to it.

deanpugh wrote:

when you do a select on a datatable, can you specify which column you want to search in? Are the expressions the same as sqlquerys?

ArrayList al = new ArrayList();<br />
for( int i = 0; i< 10; i++)<br />
al.Add(new Label());<br />
// now I have two objects in the array...<br />
((Label)al[0]).Location = new Point(100,100);<br />
((Label)al[1]).Location = new Point(100,200);<br />
...<br />
((Label)al[9]).Location = new Point(100,200);

ArrayList al = new ArrayList();<br />
for( int i = 0; i< 10; i++)<br />
{<br />
  Label oLabel = new Label();<br />
  al.Add(new Label());<br />
  this.Controls.Add(oLabel);<br />
}<br />
// now I have two objects in the array...<br />
((Label)al[0]).Location = new Point(100,100);<br />
((Label)al[1]).Location = new Point(100,200);<br />
...<br />
((Label)al[9]).Location = new Point(100,200);