本文整理汇总了C#中System.Data.Odbc.OdbcDataAdapter.FillSchema方法的典型用法代码示例。如果您正苦于以下问题:C# OdbcDataAdapter.FillSchema方法的具体用法?C# OdbcDataAdapter.FillSchema怎么用?C# OdbcDataAdapter.FillSchema使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Odbc.OdbcDataAdapter
的用法示例。
在下文中一共展示了OdbcDataAdapter.FillSchema方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: ActualizarUsuarios
//Metodo para actualizar los usuarios
public static void ActualizarUsuarios()
{
//Cadena para hacer las consultas
string CADENA;
//Metodos de conexiones
string sConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
OdbcConnection conexSql = new OdbcConnection(sConnectionString);
//metodo para abrir las cadenas de conexiones
OdbcConnection objcon = new OdbcConnection(sConnectionString);
objcon.Open();
//Cadena de string
CADENA = "SELECT usuario.usuacodi, usuario.usuapass, emplead.emplnomb FROM emplead emplead, usuario usuario WHERE emplead.emplterc = usuario.usuaterc";
//DataAdapter que se llena
OdbcDataAdapter daUsuariofox = new OdbcDataAdapter(CADENA, objcon);
//creamos un dataset
DataSet dsUsuariofox = new DataSet();
//llenamos el esquema
daUsuariofox.FillSchema(dsUsuariofox, SchemaType.Source, "usuario_FOX");
daUsuariofox.Fill(dsUsuariofox, "usuario_FOX");
//creamos un datatable
DataTable tbUsuariofox = new DataTable();
tbUsuariofox = dsUsuariofox.Tables["usuario_FOX"];
//////////////////////// sql
string sConnectionStringsql;
sConnectionStringsql = ("Server=servidor2sp;Database= CONTROL_ALMACEN;User Id=sa;Password=Qwer1234;");
SqlConnection objConnsql = new SqlConnection(sConnectionStringsql);
objConnsql.Open();
SqlDataAdapter dausuariosql = new SqlDataAdapter("Select * From Usuarios", objConnsql);
DataSet dsusuariosql = new DataSet();
dausuariosql.FillSchema(dsusuariosql, SchemaType.Source, "usuario_sql");
dausuariosql.Fill(dsusuariosql, "usuario_sql");
DataTable dtusuariosql = new DataTable();
dtusuariosql = dsusuariosql.Tables["usuario_sql"];
/////////////
compararUsuarios(tbUsuariofox, dtusuariosql, objConnsql);
//cerramos la conexion
objConnsql.Close();
objcon.Close();
}
示例2: Test_Command_ColumnProperties
/// <summary>
/// Test CUBRIDCommand column properties
/// </summary>
public static void Test_Command_ColumnProperties()
{
using (OdbcConnection conn = new OdbcConnection())
{
conn.ConnectionString = TestCases.connString;
conn.Open();
String sql = "select * from nation";
OdbcCommand cmd = new OdbcCommand(sql, conn);
OdbcDataAdapter da = new OdbcDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable("");
da.FillSchema(dt, SchemaType.Source);//To retrieve all the column properties you have to use the FillSchema() method
Assert.IsTrue(dt.Columns[0].ColumnName == "code");
}
}
示例3: Read
public static DataSet Read(string filePath, string fileName, string newDSName, string newTableName)
{
//TODO: Filter for invalid filepath and filename?
// Driver={Microsoft Text Driver (*.txt; *.csv)}
string ConnectionString = null;
ConnectionString = "Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=" + filePath;
fileName = "`" + fileName + "`";
OdbcConnection connection = new OdbcConnection(ConnectionString);
connection.Open(); //TODO: necessary?
OdbcDataAdapter da;
da = new OdbcDataAdapter("Select * FROM " + fileName, connection);
DataSet ds = new DataSet(newDSName);
da.FillSchema(ds, SchemaType.Source, newTableName);
da.Fill(ds, newTableName);
return ds;
}
示例4: LoadFirstRecord
/// <summary>
/// Loads all address records</summary>
private void LoadFirstRecord()
{
OdbcCommand m_cmdCaoSelect = new OdbcCommand("select ADRESSEN.* FROM ADRESSEN WHERE KUNDENGRUPPE=1 ORDER BY REC_ID;", m_cnCaoConnection);
//von Silvio:
//OdbcDataReader rd = cmd.ExecuteReader();
//List<string> values = new List<string>(10);
//while (rd.Read())
//{
// values.Add(rd.GetValue(0).ToString());
//}
#region temp
//m_daCao = new OleDbDataAdapter("SELECT * FROM adressen", m_cnCaoConnection);
//OleDbCommand myUpdateCommand = new OleDbCommand("UPDATE qryNotenStudent SET fldStudentNr = ?, fldName = ?, fldVorname = ?, fldKlassenNr = ?, fldKlassenBez = ?, fldNotenNr = ?, fldNote = ?, fldFachNr = ?, fldBezeichnung = ? WHERE fldStudentNr = ?", myConnection);
//OleDbCommand myUpdateCommand = new OleDbCommand("UPDATE ADRESSEN SET NAME1 ='Hans Müller' where REC_ID=3", m_cnCaoConnection);
//myUpdateCommand.Parameters.Add("@fldStudentNr", OleDbType.Integer, 2, "fldStudentNr");
//myUpdateCommand.Parameters.Add("@fldName", OleDbType.VarChar, 255, "fldName");
//myUpdateCommand.Parameters.Add("@fldVorname", OleDbType.VarChar, 255, "fldVorname");
//myUpdateCommand.Parameters.Add("@fldKlassenNr", OleDbType.Integer, 2, "fldKlassenNr");
//myUpdateCommand.Parameters.Add("@fldKlassenBez", OleDbType.VarChar, 255, "fldKlassenBez");
//myUpdateCommand.Parameters.Add("@fldNotenNr", OleDbType.Integer, 2, "fldNotenNr");
//myUpdateCommand.Parameters.Add("@fldNote", OleDbType.Single, 2, "fldNote");
//myUpdateCommand.Parameters.Add("@fldFachNr", OleDbType.Integer, 2, "fldFachNr");
//myUpdateCommand.Parameters.Add("@fldBezeichnung", OleDbType.VarChar, 255, "fldBezeichnung");
//m_daCao.UpdateCommand = myUpdateCommand;
//delete
// OleDbCommand myDeleteCommand = new OleDbCommand("delete from ADRESSEN_LIEF Where ADDR_ID=3;delete from ADRESSEN_TO_MERK Where ADDR_ID=3;DELETE FROM ADRESSEN WHERE REC_ID=3.DeleteCommand = myDeleteCommand;", myConnection);
//myDeleteCommand.Parameters.Add("@fldStudentNr", OleDbType.Integer, 2, "fldStudentNr");
//m_daCaodelete from ADRESSEN_ASP Where ADDR_ID=3
//delete from ADRESSEN_LIEF Where ADDR_ID=3
//delete from ADRESSEN_TO_MERK Where ADDR_ID=3
//DELETE FROM ADRESSEN WHERE REC_ID=3.DeleteCommand = myDeleteCommand;
#endregion
m_daCao = new OdbcDataAdapter(m_cmdCaoSelect);
m_daCao.FillSchema(m_dsCao, SchemaType.Source, "tblAdressen");
m_daCao.Fill(m_dsCao, "tblAdressen");
m_dvCao = m_dsCao.Tables["tblAdressen"].DefaultView;
}
示例5: generate_dv_human
/// <summary>
///Searches the table adressen and returns a DataView with a selection of columns.</summary>
/// <param name="searchstring">the search string</param>
public DataView generate_dv_human(string searchstring)
{
StringBuilder m_strCommand = new StringBuilder();
//SELECT `REC_ID`, `MATCHCODE`, `KUNDENGRUPPE`, `SPRACH_ID`, `GESCHLECHT`, `KUNNUM1`, `KUNNUM2`, `NAME1`, `PLZ`, `ORT`, `LAND`, `NAME2`, `NAME3`, `ABTEILUNG`, `ANREDE`, `STRASSE`, `POSTFACH`, `PF_PLZ`, `DEFAULT_LIEFANSCHRIFT_ID`, `GRUPPE`, `TELE1`, `TELE2`, `FAX`, `FUNK`, `EMAIL`, `EMAIL2`, `INTERNET`, `DIVERSES`, `BRIEFANREDE`, `BLZ`, `KTO`, `BANK`, `IBAN`, `SWIFT`, `KTO_INHABER`, `DEB_NUM`, `KRD_NUM`, `STATUS`, `NET_SKONTO`, `NET_TAGE`, `BRT_TAGE`, `WAEHRUNG`, `UST_NUM`, `VERTRETER_ID`, `PROVIS_PROZ`, LEFT(`INFO`, 256), `GRABATT`, `KUN_KRDLIMIT`, `KUN_LIEFART`, `KUN_ZAHLART`, `KUN_PRLISTE`, `KUN_LIEFSPERRE`, `LIEF_LIEFART`, `LIEF_ZAHLART`, `LIEF_PRLISTE`, `LIEF_TKOSTEN`, `LIEF_MBWERT`, `PR_EBENE`, `BRUTTO_FLAG`, `MWST_FREI_FLAG`, `KUNPREIS_AUTO`, `KUN_SEIT`, `KUN_GEBDATUM`, `ENTFERNUNG`, `ERSTELLT`, `ERST_NAME`, `GEAEND`, `GEAEND_NAME`, `SHOP_KUNDE`, `SHOP_ID`, `SHOP_NEWSLETTER`, `SHOP_KUNDE_ID`, `SHOP_CHANGE_FLAG`, `SHOP_DEL_FLAG`, `SHOP_PASSWORD`, `USERFELD_01`, `USERFELD_02`, `USERFELD_03`, `USERFELD_04`, `USERFELD_05`, `USERFELD_06`, `USERFELD_07`, `USERFELD_08`, `USERFELD_09`, `USERFELD_10` FROM `caofaktura`.`adressen` LIMIT 0, 1000;
m_strCommand.Append(@"select ANREDE as Anrede, NAME1 as Name, STRASSE as Strasse, PLZ as PLZ, ORT as Ort, TELE1 as Telefon, FUNK as Mobile, EMAIL as Email from adressen where NAME1 like ");
m_strCommand.Append(@"'%");
m_strCommand.Append(searchstring);
m_strCommand.Append(@"%'");
//m_strCommand.Append(@"select * from adressen where NAME1 like 'Meier'");
OdbcCommand m_cmdSearchCommand = new OdbcCommand(m_strCommand.ToString());
OdbcDataAdapter m_daSearchCao = new OdbcDataAdapter(m_cmdSearchCommand.CommandText, m_cnCaoConnection);
m_daSearchCao.FillSchema(m_dsSearchCao, SchemaType.Source, "tblCaoSuche");
m_daSearchCao.Fill(m_dsSearchCao, "tblCaoSuche");
m_dvSearchCao = m_dsSearchCao.Tables["tblCaoSuche"].DefaultView;
return m_dvSearchCao;
//m_daCao.Update();
}
示例6: generate_dv_all
/// <summary>
///Searches the table adressen and returns a DataView with all columns</summary>
/// <param name="searchstring">the search string</param>
public DataView generate_dv_all(string searchstring)
{
StringBuilder m_strCommand = new StringBuilder();
m_strCommand.Append(@"select * from adressen where NAME1 like ");
m_strCommand.Append(@"'%");
m_strCommand.Append(searchstring);
m_strCommand.Append(@"%'");
//m_strCommand.Append(@"select * from adressen where NAME1 like 'Meier'");
OdbcCommand m_cmdSearchCommand = new OdbcCommand(m_strCommand.ToString());
OdbcDataAdapter m_daSearchCao = new OdbcDataAdapter(m_cmdSearchCommand.CommandText, m_cnCaoConnection);
m_daSearchCao.FillSchema(m_dsSearchCao, SchemaType.Source, "tblCaoSuche");
m_daSearchCao.Fill(m_dsSearchCao, "tblCaoSuche");
m_dvSearchCao = m_dsSearchCao.Tables["tblCaoSuche"].DefaultView;
return m_dvSearchCao;
}
示例7: GetAdapterForTable
} // RemoveTable
/// <summary>
/// Obtain a data adapter for the specified Table
/// </summary>
/// <param name="tableName">Name of the table to obtain the
/// adapter for</param>
/// <returns>Adapter object for the specified table</returns>
/// <remarks>An adapter serves as a bridge between a DataSet (in memory
/// representation of table) and the data source</remarks>
internal OdbcDataAdapter GetAdapterForTable(string tableName)
{
OdbcDataAdapter da = null;
AccessDBPSDriveInfo di = this.PSDriveInfo as AccessDBPSDriveInfo;
if (di == null || !TableNameIsValid(tableName) || !TableIsPresent(tableName))
{
return null;
}
OdbcConnection connection = di.Connection;
try
{
// Create a odbc data adpater. This can be sued to update the
// data source with the records that will be created here
// using data sets
string sql = "Select * from " + tableName;
da = new OdbcDataAdapter(new OdbcCommand(sql, connection));
// Create a odbc command builder object. This will create sql
// commands automatically for a single table, thus
// eliminating the need to create new sql statements for
// every operation to be done.
OdbcCommandBuilder cmd = new OdbcCommandBuilder(da);
// Set the delete cmd for the table here
sql = "Delete from " + tableName + " where ID = ?";
da.DeleteCommand = new OdbcCommand(sql, connection);
// Specify a DeleteCommand parameter based on the "ID"
// column
da.DeleteCommand.Parameters.Add(new OdbcParameter());
da.DeleteCommand.Parameters[0].SourceColumn = "ID";
// Create an InsertCommand based on the sql string
// Insert into "tablename" values (?,?,?)" where
// ? represents a column in the table. Note that
// the number of ? will be equal to the number of
// columnds
DataSet ds = new DataSet();
ds.Locale = CultureInfo.InvariantCulture;
da.FillSchema(ds, SchemaType.Source);
sql = "Insert into " + tableName + " values ( ";
for (int i = 0; i < ds.Tables["Table"].Columns.Count; i++)
{
sql += "?, ";
}
sql = sql.Substring(0, sql.Length - 2);
sql += ")";
da.InsertCommand = new OdbcCommand(sql, connection);
// Create parameters for the InsertCommand based on the
// captions of each column
for (int i = 0; i < ds.Tables["Table"].Columns.Count; i++)
{
da.InsertCommand.Parameters.Add(new OdbcParameter());
da.InsertCommand.Parameters[i].SourceColumn =
ds.Tables["Table"].Columns[i].Caption;
}
// Open the connection if its not already open
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
}
catch (Exception e)
{
WriteError(new ErrorRecord(e, "CannotAccessSpecifiedTable",
ErrorCategory.InvalidOperation, tableName));
}
return da;
} // GetAdapterForTable
示例8: FillSchema
public void FillSchema( string sqlQuery,DataSet dataSet,string tableName)
{
if (Connection.State == ConnectionState.Closed)
{
Connection.Open();
}
command.CommandText = sqlQuery;
OdbcDataAdapter oraDA = new OdbcDataAdapter();
oraDA.SelectCommand = command;
oraDA.FillSchema(dataSet, SchemaType.Mapped, tableName);
Connection.Close();
}
示例9: SearchContactsBySteet
/// <summary>
/// Searches for Contacts by Street.
/// Table: tblCaoSearchAllPrivate</summary>
/// <param name="searchstring">the search string</param>
public void SearchContactsBySteet(string searchstring)
{
StringBuilder m_strCommand = new StringBuilder();
m_strCommand.Append(@"select * from adressen where STRASSE like ");
m_strCommand.Append(@"'%");
m_strCommand.Append(searchstring);
m_strCommand.Append(@"%'");
m_strCommand.Append(" AND KUNDENGRUPPE=1;");
//m_strCommand.Append(@"select * from adressen where NAME1 like 'Meier'");
OdbcCommand m_cmdSearchCommand = new OdbcCommand(m_strCommand.ToString());
m_daCao = new OdbcDataAdapter(m_cmdSearchCommand.CommandText, m_cnCao);
m_daCao.FillSchema(m_dsCao, SchemaType.Source, m_const_strCaoTableSearchAllPrivate);
m_daCao.Fill(m_dsCao, m_const_strCaoTableSearchAllPrivate);
}
示例10: SearchCompanyByPhone
/// <summary>
/// Searches for Companies by Mainphone.
/// Table: tblCaoSearchAllPrivate</summary>
/// <param name="searchstring">the searchstring</param>
public void SearchCompanyByPhone(string searchstring)
{
StringBuilder m_strCommand = new StringBuilder();
m_strCommand.Append(@"select * from adressen where TELE1 like ");
m_strCommand.Append(@"'%");
m_strCommand.Append(searchstring);
m_strCommand.Append(@"%'");
m_strCommand.Append(" AND KUNDENGRUPPE=2;");
OdbcCommand m_cmdSearchCommand = new OdbcCommand(m_strCommand.ToString());
m_daCao = new OdbcDataAdapter(m_cmdSearchCommand.CommandText, m_cnCao);
m_daCao.FillSchema(m_dsCao, SchemaType.Source, m_const_strCaoTableSearchAllCompanies);
m_daCao.Fill(m_dsCao, m_const_strCaoTableSearchAllCompanies);
}
示例11: ConsultPagosFox
//Retorna la lista de Proyectos Multi-Fox
public List<PagosFox> ConsultPagosFox(string refe)
{
try
{
List<PagosFox> litP = new List<PagosFox>();
ConectionString = GetConnectionString();
OdbcConnection objcon = new OdbcConnection(ConectionString);
objcon.Open();
cadena = "SELECT LEFT(democuot,9) AS 'referencia1', movidet.demosucu AS 'obra', movimie.moviterc AS 'codterc',"
+ " tercero.tercnitc AS 'cc/nit', movidet.demomovi AS 'recibo',"
+ " movidet.demonota AS '#recibo', IIF(movimie.moviesta='A','Anulado','Vigente') AS 'estado',"
+ " movimie.movifech AS 'fecharecibo', movimie.moviconc AS 'concepto', movimie.movivalo AS 'vlrdelrecibo',"
+ " movimie.movinuco AS '#consignacion', movimie.movifeco AS 'fechaconsignacion', movidet.demogira AS 'vlrcuotaaplicado',"
+ " movidet.democuot AS 'detalledelacuota', movimie.moviusua AS 'usuario', movimie.movidate AS 'fechaelaboración', "
+ " movimie.movicheq AS '#cheque', movimie.movidoc1 AS 'notaqueanulo'"
+ " FROM movidet movidet, movimie movimie, obradet obradet, obraspr obraspr, tercero tercero"
+ " WHERE movidet.demonota = movimie.movicodi AND movidet.demomovi = movimie.movimovi AND movidet.demopres = movimie.movipres"
+ " AND LEFT(democuot,9) = '"+ refe +"'"
+ " AND movidet.demosucu = movimie.movisucu AND movimie.moviterc = tercero.terccodi"
+ " AND movidet.demosucu = obradet.obrdcodi AND movidet.demopres = obradet.obrdpres AND obradet.obrdcodi = obraspr.obracodi AND ((movidet.democuot<>''))"
+ " ORDER BY movidet.democuot";
OdbcDataAdapter daProyectofox = new OdbcDataAdapter(cadena, objcon);
DataSet dsproyectofox = new DataSet("Pubs");
daProyectofox.FillSchema(dsproyectofox, SchemaType.Source, "PAGOS_FOX");
daProyectofox.Fill(dsproyectofox, "PAGOS_FOX");
DataTable tbproyectosfox = new DataTable();
tbproyectosfox = dsproyectofox.Tables["PAGOS_FOX"];
if (tbproyectosfox.Columns.Count.Equals(0))
{
return null;
}
else
{
foreach (DataRow row2 in tbproyectosfox.Rows)
{
PagosFox Pfx = new PagosFox();
Pfx.Referencia1 = row2["referencia1"].ToString();
Pfx.Obra = row2["obra"].ToString();
Pfx.Codterc = row2["codterc"].ToString();
Pfx.Nit = row2["cc/nit"].ToString();
Pfx.Recibo = row2["recibo"].ToString();
Pfx.Nrecibo = row2["#recibo"].ToString();
Pfx.Estado = row2["estado"].ToString();
Pfx.Fecharecibo = row2["fecharecibo"].ToString();
Pfx.Concepto = row2["concepto"].ToString();
Pfx.Vlrrecibo = row2["vlrdelrecibo"].ToString();
Pfx.Nconsignacion = row2["#consignacion"].ToString();
Pfx.Fechaconsignacion = row2["fechaconsignacion"].ToString();
Pfx.Vlrcuotaaplicado = row2["vlrcuotaaplicado"].ToString();
Pfx.Detallecuota = row2["detalledelacuota"].ToString();
Pfx.Usuario = row2["usuario"].ToString();
Pfx.Fechaelaboracion = row2["fechaelaboración"].ToString();
Pfx.Ncheque = row2["#cheque"].ToString();
Pfx.Nota = row2["notaqueanulo"].ToString();
litP.Add(Pfx);
}
return litP;
}
}
catch (OdbcException)
{
throw;
}
catch (NullReferenceException)
{
throw;
}
catch (Exception)
{
throw;
}
}
示例12: ConsulProyec
//Retorna la lista de Proyectos Multi-Fox
public List<ProyecFox> ConsulProyec()
{
try
{
List<ProyecFox> litP = new List<ProyecFox>();
ConectionString = GetConnectionString();
OdbcConnection objcon = new OdbcConnection(ConectionString);
objcon.Open();
cadena = "SELECT obraspr.obracodi, obraspr.obranomb FROM obraspr obraspr " +
"where (obraspr.obracodi NOT IN('999','101','128','131','132','CLH','CAS','AME','134','135')) order by obraspr.obranomb ASC";
OdbcDataAdapter daProyectofox = new OdbcDataAdapter(cadena, objcon);
DataSet dsproyectofox = new DataSet("Pubs");
daProyectofox.FillSchema(dsproyectofox, SchemaType.Source, "OBRAS_FOX");
daProyectofox.Fill(dsproyectofox, "OBRAS_FOX");
DataTable tbproyectosfox = new DataTable();
tbproyectosfox = dsproyectofox.Tables["OBRAS_FOX"];
if (tbproyectosfox.Columns.Count.Equals(0))
{
return null;
}
else
{
foreach (DataRow row2 in tbproyectosfox.Rows)
{
ProyecFox Pfx = new ProyecFox();
Pfx.ID_PROYEC = row2["obracodi"].ToString();
Pfx.NOMBRE_PROYEC = row2["obranomb"].ToString();
litP.Add(Pfx);
}
return litP;
}
}
catch (OdbcException)
{
throw;
}
catch (NullReferenceException)
{
throw;
}
catch (Exception)
{
throw;
}
}
示例13: ConsulInmuebles2
public List<Inmuebles2Fox> ConsulInmuebles2()
{
try
{
List<Inmuebles2Fox> linmf = new List<Inmuebles2Fox>();
ConectionString = GetConnectionString();
OdbcConnection objcon = new OdbcConnection(ConectionString);
objcon.Open();
cadena = "SELECT inmubloq+inmucodi AS 'referencia', inmuebl.inmuobra,inmuebl.inmudesc,left(inmuebl.inmuobra,3) AS 'suc', right(inmuebl.inmuobra,3) AS 'ppto', bloques.bloqcodi AS 'mza', inmuebl.inmucodi AS 'inmueble',inmuebl.inmuarea AS 'area', inmuebl.inmuvent AS 'vlr inmueble', IIF(inmuebl.inmuesta=1,1,0)*inmuebl.inmuvent AS 'vlr vendido', IIF(inmuebl.inmuesta<>1,1,0)*inmuebl.inmuvent AS 'vlr x vender', inmuebl.inmuesta AS 'estado',inmuebl.inmubano, inmuebl.inmualco FROM bloques bloques, inmuebl inmuebl WHERE inmuebl.inmuobra = bloques.bloqobra AND ((bloques.bloqcodi=right(inmuebl.inmubloq,2))) order by inmueble ASC";
OdbcDataAdapter daProyectofox = new OdbcDataAdapter(cadena, objcon);
DataSet dsproyectofox = new DataSet("Pubs");
daProyectofox.FillSchema(dsproyectofox, SchemaType.Source, "BLOQUE_FOX");
daProyectofox.Fill(dsproyectofox, "BLOQUE_FOX");
DataTable tbproyectosfox = new DataTable();
tbproyectosfox = dsproyectofox.Tables["BLOQUE_FOX"];
if (tbproyectosfox.Columns.Count.Equals(0))
{
return null;
}
else
{
foreach (DataRow row2 in tbproyectosfox.Rows)
{
Inmuebles2Fox Ifx = new Inmuebles2Fox();
Ifx.REFERENCIA = row2["referencia"].ToString();
Ifx.INMUOBRA = row2["inmuobra"].ToString();
Ifx.INMUDECS = row2["inmudesc"].ToString();
Ifx.SUC = row2["suc"].ToString();
Ifx.PPTO = row2["ppto"].ToString();
Ifx.MZA = row2["mza"].ToString();
Ifx.INMUEBLE = row2["inmueble"].ToString();
Ifx.AREA = row2["area"].ToString();
Ifx.VAL_INMUEBLE = Convert.ToDecimal(row2["vlr inmueble"]);
Ifx.INMUESTADO = row2["estado"].ToString();
Ifx.BANO = row2["inmubano"].ToString();
Ifx.HABITACIONES = row2["inmualco"].ToString();
linmf.Add(Ifx);
}
return linmf;
}
}
catch (OdbcException)
{
throw;
}
catch (NullReferenceException)
{
throw;
}
catch (Exception)
{
throw;
}
}
示例14: ConsulBoques
public List<BloquesFox> ConsulBoques(string p)
{
try
{
List<BloquesFox> litB = new List<BloquesFox>();
ConectionString = GetConnectionString();
OdbcConnection objcon = new OdbcConnection(ConectionString);
objcon.Open();
cadena = "SELECT bloques.bloqobra,bloques.bloqcodi,bloques.bloqdesc FROM bloques bloques WHERE LEFT(bloques.bloqobra,3)='" + p + "'";
OdbcDataAdapter daProyectofox = new OdbcDataAdapter(cadena, objcon);
DataSet dsproyectofox = new DataSet("Pubs");
daProyectofox.FillSchema(dsproyectofox, SchemaType.Source, "BLOQUE_FOX");
daProyectofox.Fill(dsproyectofox, "BLOQUE_FOX");
DataTable tbproyectosfox = new DataTable();
tbproyectosfox = dsproyectofox.Tables["BLOQUE_FOX"];
if (tbproyectosfox.Columns.Count.Equals(0))
{
return null;
}
else
{
foreach (DataRow row2 in tbproyectosfox.Rows)
{
BloquesFox Bfx = new BloquesFox();
Bfx.ID_BLOQUE = row2["bloqobra"].ToString();
Bfx.PROYECTO_SET = row2["bloqcodi"].ToString();
Bfx.NOMBRE_SET = row2["bloqdesc"].ToString();
litB.Add(Bfx);
}
return litB;
}
}
catch (OdbcException)
{
throw;
}
catch (NullReferenceException)
{
throw;
}
catch (Exception)
{
throw;
}
}
示例15: ExecuteTable
public DataTable ExecuteTable(string tableName, string query, OdbcTransaction transaction)
{
try
{
OdbcCommand dbCommand = transaction.Connection.CreateCommand();
dbCommand.Transaction = transaction;
dbCommand.CommandText = query;
OdbcDataAdapter dbDataAdapter = new OdbcDataAdapter(dbCommand);
DataTable dataTable = new DataTable(tableName);
dbDataAdapter.MissingSchemaAction = MissingSchemaAction.Add;
dbDataAdapter.FillSchema(dataTable, SchemaType.Source);
dbDataAdapter.Fill(dataTable);
return dataTable;
}
catch (Exception)
{
transaction.Rollback();
var trace = new System.Diagnostics.StackTrace(true);
var frame = trace.GetFrame(0);
var method = frame.GetMethod();
return null;
}
}