My web applicatin has three web forms using Master Page that access data tables in SqlServer database:
1 - Autoridade.aspx that shows data and search
2 - Autoridade_Add.aspx that inserts data in table lideranca
3- Autoridade_Atualizar.aspx that updates data in table lideranca
Autoridade.aspx has a GridView that show data and uses asp:HyperLinkField to redirect to Autoridade_Atualizar.aspx:
<asp:Panel runat="server" ID="pnlShowData" Visible="true">
<h1>Todas as Autoridades Cadastradas</h1>
<asp:GridView ID="gwDados" runat="server" AutoGenerateColumns="False" EmptyDataText="Não Existem Autoridades Cadastradas...">
<Columns>
<asp:BoundField DataField="id" HeaderText="ID" />
<asp:BoundField DataField="nome" HeaderText="Nome" />
<asp:BoundField DataField="partido" HeaderText="Partido" />
<asp:BoundField DataField="aliado" HeaderText="Aliado" />
<asp:BoundField DataField="cargo" HeaderText="Cargo" />
<asp:BoundField DataField="lotacao" HeaderText="Lotação" />
<asp:BoundField DataField="atuacao" HeaderText="Atuação" />
<asp:HyperLinkField DataNavigateUrlFormatString="Autoridade_Atualizar.aspx?id={0}" Text="Editar" DataNavigateUrlFields="id" />
</Columns>
</asp:GridView>
</asp:Panel>
<asp:Panel runat="server" ID="pnlSearch" Visible="true">
<ul>
<li>
<asp:Label Text="Nome" ID="label9" runat="server"></asp:Label>
<asp:TextBox ID="tbPesqNome" Text="" CssClass="radiusInput" runat="server"></asp:TextBox>
</li>
<li>
<asp:Label ID="Cargo" runat="server" Text="Cargo"></asp:Label>
<asp:DropDownList ID="ddlcargo" DataTextField="carg_cargo" DataValueField="carg_cd_cargo" CssClass="radiusInput" runat="server" Width="454px"></asp:DropDownList>
</li>
<li>
<asp:Label ID="Partido" runat="server" Text="Partido"></asp:Label>
<asp:DropDownList ID="ddlpartido" DataTextField="part_sigla" DataValueField="part_cd_partido" CssClass="radiusInput" runat="server" Width="254px"></asp:DropDownList>
</li>
<li>
<asp:Label ID="Municipio" runat="server" Text="Município Atuação"></asp:Label>
<asp:DropDownList ID="ddlmunicipio" DataTextField="municipios" DataValueField="id_municipios" CssClass="radiusInput" runat="server" Width="454px"></asp:DropDownList>
</li>
<li>
<asp:Label ID="Base" runat="server" Text="Base Aliada"></asp:Label>
<asp:DropDownList ID="ddlbasealiada" DataTextField="bas_base" DataValueField="bas_cd_base" CssClass="radiusInput" runat="server" Width="154px"></asp:DropDownList>
</li>
<li>
<asp:Label ID="Orgao" runat="server" Text="Orgão de Lotação"></asp:Label>
<asp:DropDownList ID="ddlorgao" DataTextField="orgao" DataValueField="codorgao" CssClass="radiusInput" runat="server" Width="454px"></asp:DropDownList>
</li>
<li>
<asp:Button ID="btnSearch" CssClass="btn btnSearch" runat="server" Text="Pesquisar" />
</li>
</ul>
</asp:Panel>
The first problem occurs here when I click on hyperlink the data are showed in web form Autoridade_Atualizar.aspx but the datafields (Cargo,Partido,Municipio,Base,Orgao) that use DropDownList control in this web form show integer values instead text values:
<asp:Panel runat="server" ID="pnlUpdate" Visible="true">
<h1>Atualizar Autoridade</h1>
<ul>
<li>
<asp:Label ID="CodAutoridade" runat="server" Text="Cód. Autoridade"></asp:Label>
<asp:TextBox ID="tbCodAutoridade" Text="2013" Enabled="false" CssClass="radiusInput disable" runat="server" Width="546px"></asp:TextBox>
</li>
<li>
<asp:Label Text="Nome" ID="label1" runat="server" Width="88px"></asp:Label>
<asp:TextBox ID="tbNome" Text="" CssClass="radiusInput" runat="server" Width="654px" Height="16px"></asp:TextBox>
</li>
<li>
<asp:Label ID="Cargo" runat="server" Text="Cargo"></asp:Label>
<asp:DropDownList ID="ddlcargo" DataTextField="carg_cargo" DataValueField="carg_cd_cargo" CssClass="radiusInput" runat="server" Width="454px"></asp:DropDownList>
</li>
<li>
<asp:Label ID="Partido" runat="server" Text="Partido"></asp:Label>
<asp:DropDownList ID="ddlpartido" DataTextField="part_sigla" DataValueField="part_cd_partido" CssClass="radiusInput" runat="server" Width="254px"></asp:DropDownList>
</li>
<li>
<asp:Label ID="Descricao" runat="server" Text="Descrição"></asp:Label>
<asp:TextBox ID="tbDescricao" runat="server" CssClass="radiusInput" Width="651px"></asp:TextBox>
</li>
<li>
<asp:Label ID="Email" runat="server" Text="Email"></asp:Label>
<asp:TextBox ID="tbemail" runat="server" CssClass="radiusInput" Width="651px"></asp:TextBox>
</li>
<li>
<asp:Label ID="Facebook" runat="server" Text="Facebook"></asp:Label>
<asp:TextBox ID="tbfacebook" runat="server" CssClass="radiusInput" Width="651px"></asp:TextBox>
</li>
<li>
<asp:Label ID="Twitter" runat="server" Text="Twitter"></asp:Label>
<asp:TextBox ID="tbtwitter" runat="server" CssClass="radiusInput" Width="651px"></asp:TextBox>
</li>
<li>
<asp:Label ID="EndComercial" runat="server" Text="Endereço Comercial"></asp:Label>
<asp:TextBox ID="tbendercomercial" runat="server" CssClass="radiusInput" Width="651px"></asp:TextBox>
</li>
<li>
<asp:Label ID="EndResidencial" runat="server" Text="Endereço Residencial"></asp:Label>
<asp:TextBox ID="tbenderesidencial" runat="server" CssClass="radiusInput" Width="651px"></asp:TextBox>
</li>
<li>
<asp:Label ID="TelCelular" runat="server" Text="Telefone Celular"></asp:Label>
<asp:TextBox ID="tbfonecelular" runat="server" CssClass="radiusInput" Width="651px"></asp:TextBox>
</li>
<li>
<asp:Label ID="TelResidencial" runat="server" Text="Telefone Residencial"></asp:Label>
<asp:TextBox ID="tbfoneresidencial" runat="server" CssClass="radiusInput" Width="651px"></asp:TextBox>
</li>
<li>
<asp:Label ID="TelComercial" runat="server" Text="Telefone Comercial"></asp:Label>
<asp:TextBox ID="tbfonecomercial" runat="server" CssClass="radiusInput" Width="651px"></asp:TextBox>
</li>
<li>
<asp:Label ID="Municipio" runat="server" Text="Município Atuação"></asp:Label>
<asp:DropDownList ID="ddlmunicipio" DataTextField="municipios" DataValueField="id_municipios" CssClass="radiusInput" runat="server" Width="454px"></asp:DropDownList>
</li>
<li>
<asp:Label ID="Base" runat="server" Text="Base Aliada"></asp:Label>
<asp:DropDownList ID="ddlbasealiada" DataTextField="bas_base" DataValueField="bas_cd_base" CssClass="radiusInput" runat="server" Width="154px"></asp:DropDownList>
</li>
<li>
<asp:Label ID="Orgao" runat="server" Text="Orgão de Lotação"></asp:Label>
<asp:DropDownList ID="ddlorgao" DataTextField="orgao" DataValueField="codorgao" CssClass="radiusInput" runat="server" Width="454px"></asp:DropDownList>
</li>
<li>
<li>
<asp:Button ID="bntAtualizar" CssClass="btn btnEdit" runat="server" Text="Atualizar" OnClick="bntAtualizar_Click"/>
</li>
</ul>
</asp:Panel>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
using Model;
namespace SchoolSystem
{
public partial class Autoridade_Atualizar : System.Web.UI.Page
{
private ModelDataContext mdc;
protected void Page_Load(object sender, EventArgs e)
{
PopulateCargo();
PopulatePartido();
PopulateMunicipio();
PopulateBase();
PopulateOrgao();
if (!IsPostBack)
{
try
{
this.PopulateFields(int.Parse(Request.QueryString["id"]));
}
catch (Exception)
{
this.PopulateFields();
}
}
}
public void PopulateCargo()
{
if (!IsPostBack)
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("SELECT carg_cargo,carg_cd_cargo FROM lid_cargo", con);
con.Open();
ddlcargo.DataSource = cmd.ExecuteReader();
ddlcargo.DataBind();
}
}
}
public void PopulatePartido()
{
if (!IsPostBack)
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("SELECT part_sigla,part_cd_partido FROM lid_partido", con);
con.Open();
ddlpartido.DataSource = cmd.ExecuteReader();
ddlpartido.DataBind();
}
}
}
public void PopulateMunicipio()
{
if (!IsPostBack)
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("SELECT municipios,id_municipios FROM redat_municipio", con);
con.Open();
ddlmunicipio.DataSource = cmd.ExecuteReader();
ddlmunicipio.DataBind();
}
}
}
public void PopulateBase()
{
if (!IsPostBack)
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("SELECT bas_base,bas_cd_base FROM lid_base", con);
con.Open();
ddlbasealiada.DataSource = cmd.ExecuteReader();
ddlbasealiada.DataBind();
}
}
}
public void PopulateOrgao()
{
if (!IsPostBack)
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("SELECT orgao,codorgao FROM redat_orgaos", con);
con.Open();
ddlorgao.DataSource = cmd.ExecuteReader();
ddlorgao.DataBind();
}
}
}
protected void bntAtualizar_Click(object sender, EventArgs e)
{
this.OnUpdate();
}
private void OnUpdate()
{
mdc = new ModelDataContext();
try
{
lid_lideranca lideranca = mdc.lid_liderancas.First(aut => aut.lid_cd_lideranca == int.Parse(tbCodAutoridade.Text.Trim()));
tbNome.Text = lideranca.lid_nome;
ddlcargo.SelectedItem.Text = lideranca.lid_cargo.ToString();
ddlpartido.SelectedItem.Text = lideranca.lid_cd_partido.ToString();
tbDescricao.Text = lideranca.lid_cargo2;
tbemail.Text = lideranca.lid_email;
tbfacebook.Text = lideranca.lid_facebook;
tbtwitter.Text = lideranca.lid_twitter;
tbendercomercial.Text = lideranca.lid_endereco_comercial;
tbenderesidencial.Text = lideranca.lid_endereco_residencial;
tbfonecelular.Text = lideranca.lid_fone_celular;
tbfoneresidencial.Text = lideranca.lid_fone_residencial;
tbfonecomercial.Text = lideranca.lid_fone_comercial;
ddlmunicipio.SelectedItem.Text = lideranca.lid_cd_cidade_atuacao.ToString();
ddlbasealiada.SelectedItem.Text = lideranca.lid_cd_base_aliada.ToString();
ddlorgao.SelectedItem.Text = lideranca.lid_cd_orgao.ToString();
mdc.SubmitChanges();
Response.Redirect("Autoridade.aspx");
}
catch (Exception)
{
}
finally
{
mdc.Dispose();
}
}
private void PopulateFields(int pGetID = 0)
{
mdc = new ModelDataContext();
try
{
if (pGetID > 0)
{
lid_lideranca lideranca = mdc.lid_liderancas.First(aut => aut.lid_cd_lideranca == pGetID);
tbCodAutoridade.Text = pGetID.ToString();
tbNome.Text = lideranca.lid_nome;
ddlcargo.SelectedItem.Text = lideranca.lid_cargo.ToString();
ddlpartido.SelectedItem.Text = lideranca.lid_cd_partido.ToString();
tbDescricao.Text = lideranca.lid_cargo2;
tbemail.Text = lideranca.lid_email;
tbfacebook.Text = lideranca.lid_facebook;
tbtwitter.Text = lideranca.lid_twitter;
tbendercomercial.Text = lideranca.lid_endereco_comercial;
tbenderesidencial.Text = lideranca.lid_endereco_residencial;
tbfonecelular.Text = lideranca.lid_fone_celular;
tbfoneresidencial.Text = lideranca.lid_fone_residencial;
tbfonecomercial.Text = lideranca.lid_fone_comercial;
ddlmunicipio.SelectedItem.Text = lideranca.lid_cd_cidade_atuacao.ToString();
ddlbasealiada.SelectedItem.Text = lideranca.lid_cd_base_aliada.ToString();
ddlorgao.SelectedItem.Text = lideranca.lid_cd_orgao.ToString();
}
else
{
Response.Redirect("Autoridade.aspx");
}
}
catch (Exception)
{
}
finally
{
mdc.Dispose();
}
}
}
}
The DropDownLists show text values in tables lid_cargo, lid_partido, redat_municipio, lid_base and redat_orgaos. Where I am missing? Maybe my implementation in Autoridade_Atualizar.aspx.cs is forgetting something.