Asp.net Modal DataGridView

See more:

ASP.NET

DataGridView

, +

<%@ Page Title="" Language="C#" MasterPageFile="~/Principal.Master" AutoEventWireup="true" CodeBehind="PesquisarUnidade.aspx.cs" Inherits="AgendamentoOnLine.PesquisarUnidade" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">

<form id="frmPesquisarUnidade" runat="server">
<link href="css/StyleSheet.css" rel="stylesheet" />
<script src="Scripts/jquery-1.3.2.min.js"></script>
<script src="Scripts/jquery.blockUI.js"></script>

<script type = "text/javascript">
function BlockUI(elementID) {
var prm = Sys.WebForms.PageRequestManager.getInstance();
prm.add_beginRequest(function () {
$("#" + elementID).block({
message: '

' + '<img src="imagens/loadingAnim.gif"/>

',
css: {},
overlayCSS: {
backgroundColor: '#000000', opacity: 0.8
}
});
});
prm.add_endRequest(function () {
$("#" + elementID).unblock();
});
}
$(document).ready(function () {

BlockUI("<%=pnlAddEdit.ID %>");
$.blockUI.defaults.css = {};
});
function Hidepopup() {
$find("popup").hide();
return false;
}
</script>


</form>


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;
using System.Data.SqlClient;
using System.Text;

namespace AgendamentoOnLine
{
public partial class PesquisarUnidade : System.Web.UI.Page
{
private String strConnString = ConfigurationManager.ConnectionStrings["AgendamentoOnLine.Properties.Settings.Setting"].ConnectionString;

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Bind();
}
}

protected void Bind()
{
string strQuery = "select ID,UnidadeName,Logradouro,Numero,Complemento,Bairro,Cidade,Estado from tb_unidade";
SqlCommand cmd = new SqlCommand(strQuery);
GridViewUnidade.DataSource = GetData(cmd);
GridViewUnidade.DataBind();
}

private DataTable GetData(SqlCommand cmd)
{
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection(strConnString))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
con.Open();
sda.SelectCommand = cmd;
sda.Fill(dt);
return dt;
}
}
}

protected void GridViewData_RowCommand(object sender, GridViewCommandEventArgs e)
{

}


protected void Add(object sender, EventArgs e)
{


}

protected void Editar(object sender, EventArgs e)
{
using (GridViewRow row = (GridViewRow)((LinkButton)sender).Parent.Parent)
{
txtID.ReadOnly = true;
txtID.Text = row.Cells[0].Text;
txtUnidadeName.Text = row.Cells[1].Text;
txtLogradouro.Text = row.Cells[2].Text;
txtNumero.Text = row.Cells[3].Text;
txtComplemento.Text = row.Cells[4].Text;
txtBairro.Text = row.Cells[5].Text;
txtCidade.Text = row.Cells[6].Text;
txtEstado.Text = row.Cells[7].Text;
popup.Show();
}
}
protected void Save(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(strConnString);
conn.Open();

SqlCommand cmd = new SqlCommand("update tb_unidade set NameUnidade=@NameUnidade,Logradouro=@Logradouro"+
"Numero=@Numero,Complemento=@Complemento,Bairro=@Bairro,Cidade=@Cidade,Estado=@Estado where ID=@ID", conn);

cmd.Parameters.AddWithValue("@NameUnidade", txtUnidadeName.Text);
cmd.Parameters.AddWithValue("@Logradouro", txtLogradouro.Text);
cmd.Parameters.AddWithValue("@Numero", txtNumero.Text);
cmd.Parameters.AddWithValue("@Complemento", txtComplemento.Text);
cmd.Parameters.AddWithValue("@Bairro", txtBairro.Text);
cmd.Parameters.AddWithValue("@Cidade", txtCidade.Text);
cmd.Parameters.AddWithValue("@Estado", txtEstado.Text);

cmd.ExecuteNonQuery();
conn.Close();
Response.Write(string.Format("<script>alert('Registro atualizado.');</script>"));

Bind();
}
}
}