public static String getTableRegion2() { int contador = 0; RegionDao regDao = new RegionDao(); //Populating a DataTable from database. DataTable dt = regDao.getTableRegion(); //Building an HTML string. StringBuilder html2 = new StringBuilder(); //Table start. html2.Append("<table class='table table-bordered'"); //Building the Header row. html2.Append("<tr>"); html2.Append("<th>"); html2.Append("Id Región"); html2.Append("</th>"); html2.Append("</tr>"); //Table end. html2.Append("</table>"); //Append the HTML string to Placeholder. //PlaceHolder1.Controls.Add(new Literal { Text = html.ToString() }); //PlaceHolderPrueba.Controls.Add(new Literal { Text = html2.ToString() }); return html2.ToString(); }
protected void btnGuardarReg_Click(object sender, EventArgs e) { int orderId = Convert.ToInt32(lbl_IdRegionN.Text); RegionDao regDao = new RegionDao(); if (regDao.updateRegion(orderId, vigencia) == "Ok") { Alerta.Text = "Datos Modificados en forma Correcta"; Response.Redirect("MantenedorRegion"); } else { Alerta.Text = regDao.updateRegion(orderId, vigencia); } }
protected void btnGuardarRegion_Click(object sender, EventArgs e) { Alerta.Enabled = true; String strManRegionDescripcion = txtManRegion.Text; String strManRegionNomCorto = txtManRegionNombreCorto.Text; RegionDao regDao = new RegionDao(); if (regDao.insertRegion(strManRegionDescripcion, strManRegionNomCorto) == "Ok") { Alerta.Text = "Se ha guardado correctamente"; } else { Alerta.Text = "No Se ha guardado correctamente"; } }
private void LoadEditData(int orderId) { lblIdRegion.Text = Convert.ToString(orderId); RegionDao regDao = new RegionDao(); DataSet ds = new DataSet(); da = regDao.getRegionId(orderId); DataTable dt = new DataTable(); dt = regDao.getTableRegionId(); foreach (DataRow row in dt.Rows) { lbl_IdRegionN.Text = row[0].ToString(); txt_DescripcionRegion.Text = row[1].ToString(); txt_NombreCortoRegion.Text = row[2].ToString(); txt_VigenciaRegion.Text = row[3].ToString(); } }
void getTableRegion() { RegionDao regDao = new RegionDao(); DataSet ds = new DataSet(); da = regDao.getRegion(); da.Fill(ds); this.GV_regiones.DataSource = ds; this.GV_regiones.DataBind(); }
void getTableRegion() { int contador = 0; RegionDao regDao = new RegionDao(); //Populating a DataTable from database. DataTable dt = regDao.getTableRegion(); //Building an HTML string. StringBuilder html = new StringBuilder(); //Table start. html.Append("<table class='table table-bordered'"); //Building the Header row. html.Append("<tr>"); html.Append("<th>"); html.Append("Id Región"); html.Append("</th>"); html.Append("<th>"); html.Append("Nombre De Región"); html.Append("</th>"); html.Append("<th>"); html.Append("Nombre Corto de Región"); html.Append("</th>"); html.Append("<th>"); html.Append("Modificar"); html.Append("</th>"); html.Append("<th>"); html.Append("Eliminar"); html.Append("</th>"); html.Append("</tr>"); //Building the Data rows. foreach (DataRow row in dt.Rows) { contador++; html.Append("<tr class='table-title'>"); DataColumn dc = new DataColumn(); foreach (DataColumn column in dt.Columns) { html.Append("<td>"); html.Append("<div>"+row[column.ColumnName]+"</div>"); html.Append("</td>"); } html.Append("<td><a href='#' id='btnModificar" + contador + "' onClick='getDate(" + row[0] + ")'>Modificar<a></td>"); html.Append("<td><a href='#' id='btnEliminar"+contador+"' onClick='getDate()'>Eliminar<a></td>"); html.Append("</tr>"); } //Table end. html.Append("</table>"); //Append the HTML string to Placeholder. PlaceHolder1.Controls.Add(new Literal { Text = html.ToString() }); //PlaceHolderPrueba.Controls.Add(new Literal { Text = html.ToString() }); }