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()); } //} //readTemp.Dispose(); transaction.Commit(); at da.Fill(dt);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)