private void lLenarDesdeUnSpOTablaToolStripMenuItem_Click(object sender, EventArgs e) { Formularios.FormBuscarTabla dlg = new FormBuscarTabla(DB, Visor_sql_2015.Controladores_DB.TIPOOBJETO.STOREPROCERURE); if (dlg.ShowDialog() == DialogResult.Cancel) { return; } Objetos.CSysObject obj = dlg.DameObjeto(); int j, k; System.Data.SqlClient.SqlCommand SqlCommand1; SqlCommand1 = new System.Data.SqlClient.SqlCommand(); SqlCommand1.CommandText = obj.Nombre; SqlCommand1.CommandType = System.Data.CommandType.StoredProcedure; SqlCommand1.Connection = new System.Data.SqlClient.SqlConnection(DB.ConnectionString); SqlCommand1.Connection.Open(); System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand1); System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1; sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter(); sqlDataAdapter1.SelectCommand = SqlCommand1; DataSet ds = new DataSet("aaa"); try { sqlDataAdapter1.GetFillParameters(); sqlDataAdapter1.FillSchema(ds, SchemaType.Source, "aaa"); k = ds.Tables.Count; for (j = 0; j < k; j++) { System.Data.DataTable t = ds.Tables[j]; int i, n; n = t.Columns.Count; Objetos.CConvertidor cv = new Objetos.CConvertidor(); for (i = 0; i < n; i++) { System.Data.DataColumn c = t.Columns[i]; Objetos.CParametro parametro = new Objetos.CParametro(); parametro.tipo = c.Caption; parametro.nombre = c.Caption; parametro.Logitud = c.MaxLength; this.Campos.Add(parametro); ListaCampos.Items.Add(parametro.tipo); //string TipoNet = cv.DameTipo(c.DataType.ToString()); //OnDatoManual(c.Caption, TipoNet); } } } catch (Exception ex) { SqlCommand1.Connection.Close(); throw new Exception(ex.Message); } SqlCommand1.Connection.Close(); MuestraDataGrid(); }
private void MuestraCampos() { int j, k; System.Data.SqlClient.SqlCommand SqlCommand1; SqlCommand1 = new System.Data.SqlClient.SqlCommand(); SqlCommand1.CommandText = Nombre; SqlCommand1.CommandType = System.Data.CommandType.StoredProcedure; SqlCommand1.Connection = new System.Data.SqlClient.SqlConnection(DB.ConnectionString); SqlCommand1.Connection.Open(); System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand1); System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1; sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter(); sqlDataAdapter1.SelectCommand = SqlCommand1; DataSet ds = new DataSet("aaa"); try { sqlDataAdapter1.GetFillParameters(); sqlDataAdapter1.FillSchema(ds, SchemaType.Source, "aaa"); k = ds.Tables.Count; for (j = 0; j < k; j++) { System.Data.DataTable t = ds.Tables[j]; int i, n; n = t.Columns.Count; Objetos.CConvertidor cv = new Objetos.CConvertidor(); for (i = 0; i < n; i++) { System.Data.DataColumn c = t.Columns[i]; string TipoNet = cv.DameTipo(c.DataType.ToString()); OnDatoManual(c.Caption, TipoNet); } } } catch (Exception ex) { SqlCommand1.Connection.Close(); throw new Exception(ex.Message); } SqlCommand1.Connection.Close(); }