//---------------------------------------------------------------
public Sdt Query(String sql)
{
Sdt dt = new Sdt();
cmd.CommandText = sql;
if (dbType == DbType.MySQL)
{
MySqlDataAdapter da = new MySqlDataAdapter((MySqlCommand)cmd);
da.Fill(dt);
dt.SecoundConstructor();
}
else if (dbType == DbType.Oracle)
{
OracleDataAdapter da = new OracleDataAdapter((OracleCommand)cmd);
da.Fill(dt);
dt.SecoundConstructor();
}
else if (dbType == DbType.OleDb)
{
OleDbDataAdapter da = new OleDbDataAdapter((OleDbCommand)cmd);
da.Fill(dt);
dt.SecoundConstructor();
}
else
{
return(null);
}
return(dt);
}
public Sdt ExecuteProcedure(String procedureName)
{
Sdt dt = new Sdt();
if (dbType == DbType.Oracle)
{
cmdOra.CommandText = procedureName;
cmdOra.CommandType = CommandType.StoredProcedure;
System.Data.OracleClient.OracleDataAdapter da = new System.Data.OracleClient.OracleDataAdapter(cmdOra);
da.Fill(dt);
dt.SecoundConstructor();
}
if (dbType == DbType.MySQL)
{
cmd.CommandText = procedureName;
cmd.CommandType = CommandType.StoredProcedure;
MySqlDataAdapter da = new MySqlDataAdapter((MySqlCommand)cmd);
da.Fill(dt);
dt.SecoundConstructor();
}
return(dt);
}
