M
Mullin Yu
Hi,
I'm using DataAdapter, and want to know how to release the database
connection/resource.
if not, i think it may crash my application and system.
my coding is as follow:
OleDbDataAdapter DataAdapter =
new OleDbDataAdapter(
commandString, connectionString);
DataSet DataSet = new DataSet( );
DataAdapter.Fill(DataSet,"OutboundQueueItem");
// Get the one table from the DataSet
DataTable dataTable = DataSet.Tables[0];
DataRow dataRow = dataTable.Rows[0];
lngJobID = (long) dataRow["JobID"];
I'm using DataAdapter, and want to know how to release the database
connection/resource.
if not, i think it may crash my application and system.
my coding is as follow:
OleDbDataAdapter DataAdapter =
new OleDbDataAdapter(
commandString, connectionString);
DataSet DataSet = new DataSet( );
DataAdapter.Fill(DataSet,"OutboundQueueItem");
// Get the one table from the DataSet
DataTable dataTable = DataSet.Tables[0];
DataRow dataRow = dataTable.Rows[0];
lngJobID = (long) dataRow["JobID"];