static void testAdapter()
{
TemplateConnection conn = new TemplateConnection();
TemplateDataAdapter adapter = new TemplateDataAdapter();
adapter.SelectCommand = new TemplateCommand("select * from customers", conn);
adapter.UpdateCommand = new TemplateCommand("update name, orderid values(@name, @orderid) where id = @id", conn);
adapter.UpdateCommand.Parameters.Add("@name", DbType.String);
adapter.UpdateCommand.Parameters.Add("@orderid", DbType.Int32);
adapter.UpdateCommand.Parameters.Add("@id", DbType.Int32);
DataSet ds = new DataSet();
adapter.Fill(ds, "Customers");
Console.WriteLine("------------------------");
Console.WriteLine("Results of adapter.Fill");
printDataSet(ds);
Console.WriteLine("------------------------");
ds.Tables["Customers"].Rows[2]["orderid"] = 4199;
adapter.Update(ds, "Customers");
Console.WriteLine("------------------------");
Console.WriteLine("Results of adapter.Update");
printDataSet(ds);
Console.WriteLine("------------------------");
}
static void testReader()
{
TemplateConnection conn = new TemplateConnection();
conn.Open();
TemplateCommand cmd = new TemplateCommand("select * from customers", conn);
IDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.Write(reader.GetInt32(0) + "\t");
Console.Write(reader.GetString(1) + "\t");
Console.Write(reader.GetInt32(2));
Console.WriteLine();
}
reader.Close();
conn.Close();
}
public TemplateCommand(string cmdText, TemplateConnection connection, TemplateTransaction txn)
{
_cmdText = cmdText;
_connection = connection;
_txn = txn;
}
public TemplateCommand(string cmdText, TemplateConnection connection)
{
_cmdText = cmdText;
_connection = connection;
}
internal TemplateDataReader(SampleDbResultSet resultset, TemplateConnection connection)
{
_resultset = resultset;
_connection = connection;
}
internal TemplateDataReader(SampleDb.SampleDbResultSet resultset, TemplateConnection connection)
{
m_resultset = resultset;
m_connection = connection;
}
public TemplateCommand(string cmdText, TemplateConnection connection, TemplateTransaction txn)
{
m_sCmdText = cmdText;
m_connection = connection;
m_txn = txn;
}
public TemplateCommand(string cmdText, TemplateConnection connection) : this(cmdText, connection, null)
{
}