private void ingresar_Click(object sender, EventArgs e)
{
string ids = "";
string values = "";
for (int i = 0; i < id.Count; i++)
{
if (i < (id.Count - 1))
{
ids += id [i].Text + ",";
values += "'" + id_caja [i].Text + "',";
}
else
{
ids += id [i].Text;
values += "'" + id_caja [i].Text + "'";
}
}
string query = "INSERT INTO " + arbol_conexiones.SelectedNode.Text + " (" + ids + ") VALUES (" + values + ");";
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol_conexiones.SelectedNode.Parent.Parent.Text);
try {
connection.Open();
DB2Command cmd = new DB2Command(query, connection);
cmd.ExecuteNonQuery();
MessageBox.Show("Registro insertado correctamente");
} catch (DB2Exception ex) {
MessageBox.Show("Ha ocurrido un error al insertar\n" + ex.Message);
}
connection.Close();
}
private void ModificarPrimaryKey_Load(object sender, EventArgs e)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Parent.Parent.Text);
try {
connection.Open();
DB2Command cmd = new DB2Command(@"select tab.tabname from syscat.tables tab inner join syscat.tabconst const on const.tabschema = tab.tabschema and const.tabname = tab.tabname and const.type = 'P' join syscat.keycoluse key on const.tabschema = key.tabschema and const.tabname = key.tabname and const.constname = '" + arbol.SelectedNode.Text + "' where tab.type = 'T' and tab.tabschema like 'DB2ADMIN' group by tab.tabschema, const.constname, tab.tabname order by tab.tabschema, const.constname;", connection);
DB2DataReader buffer = cmd.ExecuteReader();
while (buffer.Read())
{
var nombre_tabla = buffer ["TABNAME"].ToString();
buffer.Close();
richTextBox1.Text = "ALTER TABLE " + nombre_tabla + " DROP PRIMARY KEY;";
break;
}
} catch (DB2Exception ex) {
MessageBox.Show("Error \n" + ex.Message);
}
connection.Close();
TreeNodeCollection cl = arbol.SelectedNode.Parent.Parent.Parent.Nodes [0].Nodes;
foreach (TreeNode tabla in cl)
{
comboBox1.Items.Add(tabla.Text);
}
}
private void button3_Click(object sender, EventArgs e)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Parent.Text);
try {
connection.Open();
if (checkBox2.Checked)
{
DB2Command cmd = new DB2Command("ALTER TABLE " + arbol.SelectedNode.Text + " ALTER COLUMN " + nombre_campo + " DROP NOT NULL;", connection);
cmd.ExecuteNonQuery();
}
else
{
DB2Command cmd = new DB2Command("ALTER TABLE " + arbol.SelectedNode.Text + " ALTER COLUMN " + nombre_campo + " SET NOT NULL;", connection);
cmd.ExecuteNonQuery();
}
MessageBox.Show("Campo modificado");
} catch (DB2Exception ex) {
MessageBox.Show("Error al modificar\n" + ex.Message);
}
connection.Close();
}
private void caja_SelectedIndexChanged(object sender, EventArgs e)
{
data_set.Rows.Clear();
Expresion.Items.Clear();
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Text);
try {
connection.Open();
int posicion = caja.SelectedIndex;
string nombre_tabla = caja.Items [posicion].ToString();
DB2Command cmd = new DB2Command(@"SELECT NAME FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = '" + nombre_tabla + "';", connection);
DB2DataReader buffer = cmd.ExecuteReader();
while (buffer.Read())
{
var nombre_campo = buffer ["NAME"].ToString();
Expresion.Items.Add(nombre_campo);
}
buffer.Close();
} catch (DB2Exception ex) {
MessageBox.Show("Ha ocurrido un error\n" + ex.Message);
}
connection.Close();
}
private void ModificarForeignKey_Load(object sender, EventArgs e)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Parent.Parent.Text); try {
connection.Open();
DB2Command cmd = new DB2Command(@"select tabname from syscat.references where constname = '" + arbol.SelectedNode.Text + "';", connection);
DB2DataReader buffer = cmd.ExecuteReader();
while (buffer.Read())
{
var nombre_tabla = buffer ["TABNAME"].ToString();
buffer.Close();
richTextBox1.Text = "ALTER TABLE " + nombre_tabla + " DROP FOREIGN KEY " + arbol.SelectedNode.Text + ";";
break;
}
} catch (DB2Exception ex) {
MessageBox.Show("Error\n" + ex.Message);
}
connection.Close();
TreeNodeCollection cl = arbol.SelectedNode.Parent.Parent.Parent.Nodes [0].Nodes;
foreach (TreeNode tabla in cl)
{
comboBox1.Items.Add(tabla.Text);
}
}
private void ModificarVista_Load(object sender, EventArgs e)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Parent.Text);
try {
connection.Open();
DB2Command cmd = new DB2Command(@"select NAME, TEXT from SYSIBM.SYSVIEWS WHERE CREATOR='DB2ADMIN' and NAME='" + arbol.SelectedNode.Text + "';", connection);
DB2DataReader buffer = cmd.ExecuteReader();
while (buffer.Read())
{
var function = buffer ["TEXT"].ToString().ToUpper();
valor = buffer ["NAME"].ToString();
int pl = function.IndexOf("SELECT");
function = function.Substring(pl);
richTextBox1.Text = function;
textBox1.Text = valor;
break;
}
buffer.Close();
} catch (DB2Exception ex) {
MessageBox.Show("Error al mostrar Vista\n" + ex.Message);
}
connection.Close();
}
private void button1_Click(object sender, EventArgs e)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Parent.Parent.Text);
try {
connection.Open();
DB2Command cmd = new DB2Command(richTextBox1.Text, connection);
cmd.ExecuteNonQuery();
MessageBox.Show("Ejecutado correctamente");
} catch (DB2Exception ex) {
MessageBox.Show("Ha ocurrido un error\n" + ex.Message);
}
connection.Close();
}
public void comprobarSintaxis()
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Text);
try {
connection.Open();
DB2Command cmd = new DB2Command(richTextBox1.Text, connection);
cmd.ExecuteNonQuery();
MessageBox.Show("No se ha encontrado ningun error en SQL");
} catch (DB2Exception ex) {
MessageBox.Show("Revise la sintaxis\n" + ex.Message);
}
connection.Close();
}
private void Crear_Click(object sender, EventArgs e)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Text);
try {
connection.Open();
DB2Command cmd = new DB2Command(richTextBox1.Text, connection);
cmd.ExecuteNonQuery();
MessageBox.Show("Check creado correctamente");
this.Hide();
} catch (DB2Exception ex) {
MessageBox.Show("Error al crear check\n" + ex.Message);
} catch (Exception ex2) { }
connection.Close();
}
private void button1_Click(object sender, EventArgs e)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Parent.Text);
try {
connection.Open();
DB2Command cmd = new DB2Command(richTextBox1.Text, connection);
cmd.ExecuteNonQuery();
MessageBox.Show("Modificacion correcta!");
this.Hide();
} catch (DB2Exception ex) {
MessageBox.Show("Error al modificar Trigger\n" + ex.Message);
} catch (Exception ex2) { }
connection.Close();
}
private void button2_Click(object sender, EventArgs e)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Parent.Text);
try {
connection.Open();
DB2Command cmd = new DB2Command("RENAME TABLE " + nombre_Tabla + " TO " + textBox1.Text + ";", connection);
cmd.ExecuteNonQuery();
nombre_Tabla = textBox1.Text;
MessageBox.Show("Tabla modificada correctamente");
} catch (DB2Exception ex) {
MessageBox.Show("Error al modificar tabla\n" + ex.Message);
}
connection.Close();
}
private void MostrarDatosTabla_Load(object sender, EventArgs e)
{
try {
tabla_name.Text = "DATOS DE TABLA : " + arbol_conexiones.SelectedNode.Text;
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol_conexiones.SelectedNode.Parent.Parent.Text);
connection.Open();
DB2Command cmd = new DB2Command(@"SELECT * FROM " + arbol_conexiones.SelectedNode.Text + "; ", connection);
adapter = new DB2DataAdapter(cmd);
ds = new DataTable();
adapter.Fill(ds);
data_tablas.DataSource = ds;
connection.Close();
} catch (DB2Exception ex) { } catch { }
}
private void button1_Click(object sender, EventArgs e)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Text);
try {
connection.Open();
DB2Command cmd = new DB2Command(richTextBox1.Text, connection);
cmd.ExecuteNonQuery();
MessageBox.Show("Procedimiento creado satisfactoriamente!");
this.Hide();
} catch (DB2Exception ex) {
MessageBox.Show("Error al crear procedimiento\n" + ex.Message);
}
connection.Close();
}
private void button3_Click(object sender, EventArgs e)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Parent.Text);
try {
connection.Open();
DB2Command cmd = new DB2Command("ALTER TABLE " + nombre_Tabla + " DROP COLUMN " + data_tablas.CurrentRow.Cells["NAME"].Value.ToString() + ";", connection);
cmd.ExecuteNonQuery();
nombre_Tabla = textBox1.Text;
data_tablas.Rows.Remove(data_tablas.CurrentRow);
MessageBox.Show("Campo Borradp correctamente");
} catch (DB2Exception ex) {
MessageBox.Show("Error al borrar campo\n" + ex.Message);
}
connection.Close();
}
private void button6_Click(object sender, EventArgs e)
{
if (nombre_campo != nombre.Text)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Parent.Text);
try {
connection.Open();
DB2Command cmd = new DB2Command("ALTER TABLE " + arbol.SelectedNode.Text + " RENAME COLUMN " + nombre_campo + " TO " + nombre.Text + ";", connection);
cmd.ExecuteNonQuery();
MessageBox.Show("Campo modificado");
} catch (DB2Exception ex) {
MessageBox.Show("Error al modificar\n" + ex.Message);
}
connection.Close();
nombre_campo = nombre.Text;
}
}
private void ModificarTabla_Load(object sender, EventArgs e)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Parent.Text);
try {
connection.Open();
DB2Command cmd = new DB2Command("SELECT NAME, COLTYPE, LENGTH, SCALE, NULLS FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = '" + arbol.SelectedNode.Text + "';", connection);
DB2DataAdapter data = new DB2DataAdapter(cmd);
DataTable tabla = new DataTable();
data.Fill(tabla);
data_tablas.DataSource = tabla;
textBox1.Text = arbol.SelectedNode.Text;
nombre_Tabla = textBox1.Text;
} catch (DB2Exception ex) {
}
connection.Close();
}
public void ingresar2(string q)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol_conexiones.SelectedNode.Parent.Parent.Text);
try
{
connection.Open();
DB2Command cmd = new DB2Command(q, connection);
cmd.ExecuteNonQuery();
//MessageBox.Show("Registro insertado correctamente");
}
catch (DB2Exception ex)
{
//MessageBox.Show("Ha ocurrido un error al insertar\n" + ex.Message);
}
connection.Close();
}
private void ModificarCampos_Load_1(object sender, EventArgs e)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Parent.Text);
try {
connection.Open();
DB2Command cmd = new DB2Command("select NAME from SYSIBM.SYSCOLUMNS where tbname = '" + arbol.SelectedNode.Text + "' AND NAME ='" + data_tablas.Cells ["NAME"].Value.ToString() + "' and keyseq > 0 order by keyseq", connection);
DB2DataReader buffer = cmd.ExecuteReader();
if (buffer.Read())
{
checkBox1.Checked = true;
}
buffer.Close();
} catch (DB2Exception ex) {
}
connection.Close();
}
//hace un truncate de la tabla, elimina todos los valores que se quiera
public void LimpiarTabla_SinMensaje()
{
PantallaPrincipal pn1 = new PantallaPrincipal();
using (DB2Connection connection = pn1.obtenerConexion(arbol_conexiones.SelectedNode.Parent.Parent.Text))
{
try
{
connection.Open();
DB2Command cmd = new DB2Command("TRUNCATE TABLE " + arbol_conexiones.SelectedNode.Text + " IMMEDIATE;", connection);
cmd.ExecuteNonQuery();
}
catch (DB2Exception ex)
{
MessageBox.Show("Ha ocurrido un error al limpiar tabla\n" + ex.Message);
}
connection.Close();
}
}
private void MostrarProcedimiento_Load(object sender, EventArgs e)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Parent.Text);
try {
connection.Open();
DB2Command cmd = new DB2Command("SELECT ROUTINE_DEFINITION FROM SYSIBM.ROUTINES WHERE SPECIFIC_SCHEMA = 'DB2ADMIN' AND ROUTINE_NAME ='" + arbol.SelectedNode.Text.ToUpper() + "';", connection);
DB2DataReader buffer = cmd.ExecuteReader();
while (buffer.Read())
{
var texto = buffer ["ROUTINE_DEFINITION"].ToString();
richTextBox1.Text = texto;
}
buffer.Close();
} catch (DB2Exception ex) {
}
connection.Close();
}
private void button1_Click(object sender, EventArgs e)
{
string expresiones = obtenerQuery();
string query = "";
int posicion = caja.SelectedIndex;
int posicion2 = caja2.SelectedIndex;
if (posicion == -1 || posicion2 == -1)
{
MessageBox.Show("Te falta seleccionar correctamente el tipo de indice\n");
return;
}
string nombre_tabla = caja.Items [posicion].ToString();
string tipo_indice = caja2.Items [posicion2].ToString();
if (tipo_indice == "NO UNICO")
{
query = "CREATE INDEX " + nombre_indice.Text + " ON " + nombre_tabla + " " + expresiones + ";";
}
else
{
query = "CREATE UNIQUE INDEX " + nombre_indice.Text + " ON " + nombre_tabla + " " + expresiones + ";";
}
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Text);
try {
connection.Open();
DB2Command cmd = new DB2Command(query, connection);
cmd.ExecuteNonQuery();
MessageBox.Show("Indice creado correctamente");
TreeNode nodo = arbol.SelectedNode.Nodes.Add(nombre_indice.Text);
nodo.ImageIndex = 3;
nodo.SelectedImageIndex = 3;
nodo.ContextMenuStrip = subMenus [4];
connection.Close();
this.Hide();
} catch (DB2Exception ex) {
MessageBox.Show("Error al crear el indice\n" + ex.Message);
}
connection.Close();
}
private void ModificarTrigger_Load(object sender, EventArgs e)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Parent.Text);
try {
connection.Open();
DB2Command cmd = new DB2Command(@"SELECT TEXT FROM SYSCAT.TRIGGERS WHERE TRIGSCHEMA ='DB2ADMIN' AND TRIGNAME= '" + arbol.SelectedNode.Text + "';", connection);//OBTENER TABLAS DE LA BASE DE DATOS
DB2DataReader buffer = cmd.ExecuteReader();
while (buffer.Read())
{
var function = buffer ["TEXT"].ToString();
richTextBox1.Text = function;
break;
}
} catch (DB2Exception ex) {
MessageBox.Show("Error al mostrar Vista\n" + ex.Message);
} catch (Exception ex2) { }
connection.Close();
}
private void MostrarTriggers_Load(object sender, EventArgs e)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Parent.Text);
try {
connection.Open();
DB2Command cmd = new DB2Command(@"SELECT TEXT FROM SYSCAT.TRIGGERS WHERE TRIGSCHEMA ='DB2ADMIN' AND TRIGNAME= '" + arbol.SelectedNode.Text + "';", connection);//OBTENER TABLAS DE LA BASE DE DATOS
DB2DataReader bff = cmd.ExecuteReader();
while (bff.Read())
{
var Names = bff ["TEXT"].ToString();
richTextBox1.Text = Names;
break;
}
bff.Close();
} catch (DB2Exception ex) {
}
connection.Close();
}
public string obtenerTabla()
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Parent.Text);
try {
connection.Open();
DB2Command cmd = new DB2Command(@"SELECT TBNAME FROM SYSIBM.SYSCHECKS WHERE TBCREATOR='DB2ADMIN' AND NAME ='" + arbol.SelectedNode.Text + "';", connection);
DB2DataReader buffer = cmd.ExecuteReader();
while (buffer.Read())
{
var function = buffer ["TBNAME"].ToString();
return(function);
}
} catch (DB2Exception ex) {
MessageBox.Show("Error \n" + ex.Message);
}
connection.Close();
return("");
}
private void MostrarCheck_Load(object sender, EventArgs e)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Parent.Text);
try {
connection.Open();
DB2Command cmd = new DB2Command(@"SELECT TEXT FROM SYSIBM.SYSCHECKS WHERE TBCREATOR='DB2ADMIN' AND NAME ='" + arbol.SelectedNode.Text + "';", connection);
DB2DataReader buffer = cmd.ExecuteReader();
while (buffer.Read())
{
var function = buffer ["TEXT"].ToString();
richTextBox1.Text = function;
break;
}
buffer.Close();
} catch (DB2Exception ex) {
MessageBox.Show("Error al mostrar Check\n" + ex.Message);
}
connection.Close();
}
private void ModificarFuncion_Load(object sender, EventArgs e)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Parent.Text);
try {
connection.Open();
DB2Command cmd = new DB2Command(@"select text from syscat.routines where routineschema not like 'SYS%'and routineschema='DB2ADMIN' and text not like '%PROCEDURE%' and ROUTINENAME ='" + arbol.SelectedNode.Text + "';", connection);
DB2DataReader buffer = cmd.ExecuteReader();
while (buffer.Read())
{
var function = buffer ["TEXT"].ToString();
richTextBox1.Text = function;
break;
}
buffer.Close();
} catch (DB2Exception ex) {
MessageBox.Show("Error al mostrar funcion\n" + ex.Message);
}
connection.Close();
}
private void button5_Click(object sender, EventArgs e)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Parent.Text);
try {
connection.Open();
string query = "ALTER TABLE " + tabla + " ADD COLUMN " + nombre.Text + " ";
string nullo = "";
if (checkBox2.Checked)
{
nullo += "NULL";
}
else
{
nullo += "NOT NULL DEFAULT";
}
if (dato.Text == "VARCHAR")
{
query += dato.Text + "(" + tamano.Text + ") " + nullo;
}
if (dato.Text == "INT")
{
query += dato.Text + " " + nullo;
}
if (dato.Text.Equals("DECIMAL") || dato.Text.Equals("NUMERIC"))
{
query += dato.Text + "(" + tamano.Text + "," + escala.Text + ") " + nullo;
}
DB2Command cmd = new DB2Command(query, connection);
cmd.ExecuteNonQuery();
MessageBox.Show("Campo Anadido correctamente");
this.Hide();
} catch (DB2Exception ex) {
MessageBox.Show("Error al borrar campo\n" + ex.Message);
}
connection.Close();
}
private void button5_Click(object sender, EventArgs e)
{
PantallaPrincipal pn = new PantallaPrincipal();
DB2Connection connection = pn.obtenerConexion(arbol.SelectedNode.Parent.Parent.Text);
try {
connection.Open();
if (escala.Enabled)
{
DB2Command cmd = new DB2Command("ALTER TABLE " + arbol.SelectedNode.Text + " ALTER COLUMN " + nombre_campo + " SET DATA TYPE " + dato.SelectedItem.ToString() + " (" + tamano.Text + "," + escala.Text + ");", connection);
cmd.ExecuteNonQuery();
}
else
{
DB2Command cmd = new DB2Command("ALTER TABLE " + arbol.SelectedNode.Text + " ALTER COLUMN " + nombre_campo + " SET DATA TYPE " + dato.SelectedItem.ToString() + " (" + tamano.Text + ");", connection);
cmd.ExecuteNonQuery();
}
MessageBox.Show("Campo modificado");
} catch (DB2Exception ex) {
MessageBox.Show("Error al modificar\n" + ex.Message);
}
connection.Close();
}
private void LlenarTabla_Load(object sender, EventArgs e)
{
//Sacar los ids
DataTable tabla1 = new DataTable();
PantallaPrincipal pn1 = new PantallaPrincipal();
using (DB2Connection connection = pn1.obtenerConexion(arbol_conexiones.SelectedNode.Parent.Parent.Text))
{
try
{
connection.Open();
DB2Command cmd = new DB2Command("SELECT NAME FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = '" + arbol_conexiones.SelectedNode.Text + "';", connection);
DB2DataAdapter data = new DB2DataAdapter(cmd);
data.Fill(tabla1);
dataGridView2.DataSource = tabla1;
}
catch (DB2Exception ex)
{ }
connection.Close();
}
// Agregando valores a la lista de los IDS
foreach (DataRow row in tabla1.Rows)
{
foreach (DataColumn column in tabla1.Columns)
{
string name = (row[column]).ToString();
id.Add(name);
}
}
//Sacar tipo de dato
DataTable tabla = new DataTable();
PantallaPrincipal pn = new PantallaPrincipal();
using (DB2Connection connection = pn.obtenerConexion(arbol_conexiones.SelectedNode.Parent.Parent.Text))
{
try
{
connection.Open();
DB2Command cmd = new DB2Command("SELECT COLTYPE FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = '" + arbol_conexiones.SelectedNode.Text + "';", connection);
DB2DataAdapter data = new DB2DataAdapter(cmd);
data.Fill(tabla);
dataGridView1.DataSource = tabla;
}
catch (DB2Exception ex)
{}
connection.Close();
}
// Agregando tipos de datos a la lista
foreach (DataRow row in tabla.Rows)
{
foreach (DataColumn column in tabla.Columns)
{
string tipo = (row[column]).ToString();
tipoDato.Add(tipo);
}
}
}
