<%@ Page Language="C#" AutoEventWireup="true" EnableEventValidation="false" CodeFile="GridExport.aspx.cs" Inherits="GridExport" %> <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ATKS" %> <!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> <style type="text/css"></style> <link href="Custom.css" rel="Stylesheet" /> </head> <body> <form id="form1" runat="server"> <asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager> <div> <asp:LinkButton ID="LnkAdd" runat="server">Add Airport</asp:LinkButton> <asp:Panel ID="Panel1" runat="server" Style="display: none" CssClass="modalPopup"> <asp:Panel ID="Panel3" runat="server" Style="cursor: move; background-color: #DDDDDD; border: solid 1px Gray; color: Black"> <div> <p> Insert Name To Add In Gridview! </p> </div> </asp:Panel> <asp:TextBox ID="txtName" runat="server"></asp:TextBox> <asp:Button ID="OkButton" runat="server" Text="OK" AutoPostBack="True" OnClick="Click_InsertData" /> <asp:Button ID="CancelButton" runat="server" Text="Cancel" /> </asp:Panel> <ATKS:ModalPopupExtender ID="ModalPopupExtender" runat="server" TargetControlID="LnkAdd" PopupControlID="Panel1" BackgroundCssClass="modalBackground" CancelControlID="CancelButton" DropShadow="true" PopupDragHandleControlID="Panel3"> </ATKS:ModalPopupExtender> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CssClass="body" DataKeyNames="AirportId" OnRowCommand="GridView1_RowCommand"> <RowStyle CssClass="tablerow" Width="100px" /> <AlternatingRowStyle CssClass="tablealtrow" /> <Columns> <%-- <asp:BoundField DataField="AirportId" HeaderText="AirportId" InsertVisible="False" ReadOnly="false" SortExpression="AirportId" /> <asp:BoundField DataField="Name" HeaderText="AirportName" SortExpression="AirportName" /> <asp:BoundField DataField="CityName" HeaderText="CityName" SortExpression="CityName" /> <asp:BoundField DataField="Area" HeaderText="Area" SortExpression="Area" /> <asp:BoundField DataField="PhoneNo" HeaderText="PhoneNumber" SortExpression="PhoneNumber" /> <asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address" /> <asp:BoundField DataField="EstablishedDate" HeaderText="EstablishDate" SortExpression="EstablishDate" /> <asp:CheckBoxField DataField="IsRunning" HeaderText="IsRunning" SortExpression="IsRunning" />--%> <asp:TemplateField> <ItemTemplate> <%# Eval("Name") %> </ItemTemplate> </asp:TemplateField> <asp:TemplateField> <ItemTemplate> <%# Eval("CityName")%> </ItemTemplate> </asp:TemplateField> <asp:TemplateField> <ItemTemplate> <%# Eval("Area")%> </ItemTemplate> </asp:TemplateField> <asp:TemplateField> <ItemTemplate> <%# Eval("PhoneNo")%> </ItemTemplate> </asp:TemplateField> <asp:TemplateField> <ItemTemplate> <%# Eval("Address")%> </ItemTemplate> </asp:TemplateField> <asp:TemplateField> <ItemTemplate> <%# Eval("EstablishedDate")%> </ItemTemplate> </asp:TemplateField> <asp:TemplateField> <ItemTemplate> <%# Eval("IsRunning")%> </ItemTemplate> </asp:TemplateField> <asp:TemplateField> <ItemTemplate> <asp:ImageButton ID="Img1" runat="server" ImageUrl="~/Images/comp.gray.png" AlternateText="expand" CommandName="Choice" CommandArgument='<%#Eval("AirportId") %>' /> </ItemTemplate> </asp:TemplateField> <asp:TemplateField> <ItemTemplate> <%-- <asp:ImageButton ID="Img2" runat="server" ImageUrl="~/Images/sound1.png" AlternateText="expand" CommandName="Choice2" CommandArgument='<%#Eval("AirportId") %>' />--%> </ItemTemplate> </asp:TemplateField> <asp:TemplateField> <ItemTemplate> <ATKS:DropDownExtender runat="server" ID="DDE" TargetControlID="Img1" DropDownControlID="DropPanel" /> <asp:Panel ID="DropPanel" runat="server" CssClass="ContextMenuPanel" Style="display: none; visibility: hidden;"> <asp:LinkButton runat="server" ID="Choice1" Text="Print" CssClass="ContextMenuItem" /><br /> <asp:LinkButton runat="server" ID="Choice2" Text="Export" CssClass="ContextMenuItem" /><br /> <asp:LinkButton runat="server" ID="Choice3" Text="Copy" CssClass="ContextMenuItem" /><br /> </asp:Panel> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> <asp:SqlDataSource ID="SqlAMS" runat="server" ConnectionString="<%$ ConnectionStrings:DB_AMSConnectionString %>" SelectCommand="SELECT * FROM [Airport]"></asp:SqlDataSource> </div> </form> </body> </html>
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.IO; using System.Data; using System.Drawing; using System.Data.SqlClient; using System.Configuration; using System.Text; [Serializable] public partial class GridExport : System.Web.UI.Page { SqlConnection objConn = new SqlConnection(@"Data Source=SHUBHAM-PC\SQLEXPRESS;Initial Catalog=DB_SAMS;Integrated Security=True"); SqlCommand objCommand = new SqlCommand(); DataTable dt; protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { this.BindData(); GridView1.DataBind(); dt = new DataTable(); MakeDataTable(); } else { dt = (DataTable)ViewState["DataTable"]; } ViewState["DataTable"] = dt; } private void MakeDataTable() { dt.Columns.Add("AirportId"); dt.Columns.Add("Name"); dt.Columns.Add("CityName"); dt.Columns.Add("Area"); dt.Columns.Add("PhoneNo"); dt.Columns.Add("Address"); dt.Columns.Add("EstablishedDate"); dt.Columns.Add("IsRunning"); } private void BindData() { string strQuery = "select *" + " from Airport"; SqlCommand cmd = new SqlCommand(strQuery); GridView1.DataSource = GetData(cmd); GridView1.DataBind(); } private DataTable GetData(SqlCommand cmd) { DataTable dt1 = new DataTable(); using (SqlConnection con = new SqlConnection(@"Data Source=SHUBHAM-PC\SQLEXPRESS;Initial Catalog=DB_SAMS;Integrated Security=True")) { using (SqlDataAdapter sda = new SqlDataAdapter()) { cmd.Connection = con; con.Open(); sda.SelectCommand = cmd; sda.Fill(dt1); return dt1; } } } protected void Click_InsertData(object sender, EventArgs e) { try { DataRow dr = dt.NewRow(); dr["AirportId"] = "11"; dr["Name"] = txtName.Text; //dr["Number"] = txtNumber.Text; dt.Rows.Add(dr); GridView1.DataSource = dt; this.BindData(); GridView1.DataBind(); } catch (Exception ex) { throw (ex); } } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)