how to run execute reader
Revision 3
i have following code
OdbcCommand Command = MainClass.Conn.CreateCommand();
Command.Connection = MainClass.Conn;
using (OdbcTransaction transaction = MainClass.Conn.BeginTransaction())
{
Command.Transaction = transaction;
try
{
string saveStOpen = "Insert Statement.. "; \\ This This Is SQL Statement
Command.CommandText = saveStOpen;
Command.ExecuteNonQuery();
string saveGRNSub = "Insert Statement.."; \\ This This Is SQL
Command.CommandText = saveGRNSub;
Command.ExecuteNonQuery();
OdbcCommand OpenTemp = new OdbcCommand("SELECT * FROM GRN_TEMP WHERE (UserName = '" + MainClass.GetComputerName() + "')", MainClass.Conn);
OdbcDataAdapter da = new OdbcDataAdapter(OpenTemp);
DataTable dt = new DataTable();
da.Fill(dt); \\ This Point Genarate An Error
if (dt.Rows.Count >0)
{
MessageBox.Show(dt.Rows.Count.ToString());
}
transaction.Commit();
at da.Fill(dt);
Generate Error (executereader requires the command to have a transaction )
how to avoid this error
I highly appreciate in advance
Posted 12-Nov-12 21:47pm
by
anushikaroshan.