Dear Dharmendr
I need popup window (js or jquery)
add button click popup window open then save record bind gridview.
cancel mean popup window hide.
ASPX:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="jquerygrid.aspx.cs" Inherits="FormsAuth.jquerygrid" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns ="False"
AllowPaging="True" AllowSorting="True" ShowFooter ="True"
DataKeyNames ="studentid" OnPageIndexChanging ="pageindexchange"
OnRowCancelingEdit ="cancelledit" OnRowDeleting ="rowdeleting"
OnRowEditing ="rowediting" OnRowUpdating ="rowupdating" BackColor="White"
BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3"
GridLines="Horizontal" >
<AlternatingRowStyle BackColor="#F7F7F7" />
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:Button ID="Button1" runat="server" Text="EDIT" CommandName="EDIT" ToolTip ="EDIT" />
<asp:Button ID="Button2" runat="server" Text="DELETE" CommandName="DELETE" ToolTip ="DELETE" />
</ItemTemplate>
<EditItemTemplate>
<asp:Button ID="Button3" runat="server" Text="UPDATE" CommandName="UPDATE" ToolTip ="UPDATE" />
<asp:Button ID="Button4" runat="server" Text="CANCEL" CommandName="CANCEL" ToolTip ="CANCEL" />
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText ="STUDENTNAME" HeaderStyle-HorizontalAlign ="Center">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%#Eval("STUDENTNAME") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text ='<%#Eval ("STUDENTNAME") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText = "ADDRESS" HeaderStyle-HorizontalAlign ="Center">
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%#Eval("ADDRESS") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text = '<%#Eval("ADDRESS") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText = "MOBILENO" HeaderStyle-HorizontalAlign ="Center">
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%#Eval("MOBILENO") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox3" runat="server" Text = '<%#Eval("MOBILENO") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText = "EMAIL" HeaderStyle-HorizontalAlign ="Center">
<ItemTemplate>
<asp:Label ID="Label4" runat="server" Text='<%#Eval("EMAIL") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox4" runat="server" Text = '<%#Eval("EMAIL") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
<PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
<RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
<SortedAscendingCellStyle BackColor="#F4F4FD" />
<SortedAscendingHeaderStyle BackColor="#5A4C9D" />
<SortedDescendingCellStyle BackColor="#D8D8F0" />
<SortedDescendingHeaderStyle BackColor="#3E3277" />
</asp:GridView>
<div>
<asp:Button ID="btnAdd" runat="server" Text="Add" Width="113px" />
</div>
<asp:Panel ID="pnlAddEdit" runat="server" CssClass="modalPopup" style = "display:none">
<asp:Label Font-Bold = "true" ID = "Label4" runat = "server" Text = "Customer Details" ></asp:Label>
<br />
<table align = "center">
<tr>
<td>
<asp:Label ID = "Label1" runat = "server" Text = "StudentID" ></asp:Label>
</td>
<td>
<asp:TextBox ID="txtStudentID" Width = "40px" MaxLength = "5" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID = "Label2" runat = "server" Text = "StudentName" ></asp:Label>
</td>
<td>
<asp:TextBox ID="txtStudentName" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID = "Label3" runat = "server" Text = "Address" ></asp:Label>
</td>
<td>
<asp:TextBox ID="txtAddress" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID = "Label5" runat = "server" Text = "Mobileno" ></asp:Label>
</td>
<td>
<asp:TextBox ID="txtMobileno" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID = "Label6" runat = "server" Text = "Email" ></asp:Label>
</td>
<td>
<asp:TextBox ID="txtEmail" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Button ID="btnSave" runat="server" Text="Save" />
</td>
<td>
<asp:Button ID="btnCancel" runat="server" Text="Cancel" OnClientClick = "return Hidepopup()"/>
</td>
</tr>
</table>
</asp:Panel>
<asp:LinkButton ID="lnkFake" runat="server"></asp:LinkButton>
<cc1:ModalPopupExtender ID="popup" runat="server" DropShadow="false"
PopupControlID="pnlAddEdit" TargetControlID = "lnkFake"
BackgroundCssClass="modalBackground">
</cc1:ModalPopupExtender>
</ContentTemplate>
<Triggers>
<asp:AsyncPostBackTrigger ControlID = "GridView1" />
<asp:AsyncPostBackTrigger ControlID = "btnSave" />
</Triggers>
</asp:UpdatePanel>
</form>
</body>
</html>
SOURCE:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace FormsAuth
{
public partial class jquerygrid : System.Web.UI.Page
{
SqlConnection con;
SqlCommand cmd;
SqlDataAdapter da;
DataSet ds;
DataTable dt;
String _connStr = ConfigurationManager.ConnectionStrings["muthu"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Response.Write("WELCOME" + HttpContext.Current.User.Identity.Name + "<br>");
bind();
}
}
protected void bind()
{
string conn = ConfigurationManager.ConnectionStrings["muthu"].ToString();
SqlConnection con = new SqlConnection(conn);
con.Open();
//SqlCommand cmd = new SqlCommand("select * from formreg WHERE studentname ='" + HttpContext.Current.User.Identity.Name + "'", con);
SqlCommand cmd = new SqlCommand("select * from formreg", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "formreg");
if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
protected void cancelledit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
bind();
}
protected void rowediting(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
bind();
}
protected void pageindexchange(object sender, GridViewPageEventArgs e)
{
GridView1.EditIndex = e.NewPageIndex;
bind();
}
protected void rowupdating(object sender, GridViewUpdateEventArgs e)
{
int studentid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values["studentid"].ToString());
TextBox TextBox1 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox1");
TextBox TextBox2 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox2");
TextBox TextBox3 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox3");
TextBox TextBox4 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox4");
string conn = ConfigurationManager.ConnectionStrings["muthu"].ToString();
SqlConnection con = new SqlConnection(conn);
con.Open();
SqlCommand cmd = new SqlCommand("update formreg set studentname ='" + TextBox1.Text + "', address ='" + TextBox2.Text + "', mobileno ='" + TextBox3.Text + "', email ='" + TextBox4.Text + "' where studentid =" + studentid, con);
cmd.ExecuteNonQuery();
con.Close();
GridView1.EditIndex = -1;
bind();
}
protected void rowdeleting(object sender, GridViewDeleteEventArgs e)
{
int studentid = Convert.ToInt16(GridView1.DataKeys[e.RowIndex].Values["studentid"].ToString());
string conn = ConfigurationManager.ConnectionStrings["muthu"].ToString();
SqlConnection con = new SqlConnection(conn);
con.Open();
SqlCommand cmd = new SqlCommand(" delete from formreg where studentid =" + studentid, con);
int result = cmd.ExecuteNonQuery();
con.Close();
if (result == 1)
{
bind();
}
}
}
}
