C#

bluewavestrider wrote:

For example, I made an XML file containing all the countries in the world. I use this in my applications to populate a Countries ComboBox or DropDownList

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?