LINQ Insert Update Delete

ASPX.CS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

public partial class Default2 : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

    }

    protected void btnSubmit_Click(object sender, EventArgs e)

    {

        Class1 obj = new Class1();

        obj.insert(txtname.Text, txtaddress.Text);

    }

    protected void Button1_Click(object sender, EventArgs e)

    {

        Class1 obj = new Class1();

        obj.delete(Convert.ToInt32(txtid.Text));

    }

}

Class file

using System;

using System.Collections.Generic;

using System.Linq;

using System.Data.Linq;

using System.Web;

using System.Configuration;

/// <summary>

/// Summary description for Class1

/// </summary>

public class Class1

{

    public string aaa = ConfigurationManager.ConnectionStrings["nareshConnectionString"].ToString();

    DataClassesDataContext aaaa = new DataClassesDataContext();

    public Class1()

    {

        //

        // TODO: Add constructor logic here

        //

    }

    public void insert(string name, string address)

    {

        T_Linq obj = new T_Linq();

        //obj.id = id;

        obj.name = name;

        obj.address = address;

        aaaa.T_Linqs.InsertOnSubmit(obj);

        aaaa.SubmitChanges();

    }

    public void delete(int id)

    {

        T_Linq objid = (from p in aaaa.T_Linqs

                          where p.id == id

                          select p).SingleOrDefault();

        objid.id = id;

        aaaa.T_Linqs.DeleteOnSubmit(objid);

        aaaa.SubmitChanges();

    }

}

Dynamically add textboxs in Windows forms Click Button Catch that text box values

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Linq;

using System.Drawing;

namespace asdf

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

             

        }

        private void button1_Click(object sender, EventArgs e)

        {

            Label label = new Label();

            int count = panel1.Controls.OfType<Label>().ToList().Count;

            label.Location = new Point(10, (25 * count) + 2);

            label.Size = new Size(40, 20);

            label.Name = "label_" + (count + 1);

            label.Text = "label " + (count + 1);

            panel1.Controls.Add(label);

            TextBox textbox = new TextBox();

            count = panel1.Controls.OfType<TextBox>().ToList().Count;

            textbox.Location = new System.Drawing.Point(60, 25 * count);

            textbox.Size = new System.Drawing.Size(80, 20);

            textbox.Name = "textbox_" + (count + 1);

           // textbox.TextChanged += new System.EventHandler(this.TextBox_Changed);

            panel1.Controls.Add(textbox);

            Button button = new Button();

            count = panel1.Controls.OfType<Button>().ToList().Count;

            button.Location = new System.Drawing.Point(150, 25 * count);

            button.Size = new System.Drawing.Size(60, 20);

            button.Name = "button_" + (count + 1);

            button.Text = "Button " + (count + 1);

            button.Click += new System.EventHandler(this.Button_Click);

            panel1.Controls.Add(button);

        }

        private void Button_Click(object sender, EventArgs e)

        {

            Button button = (sender as Button);

            TextBox rc = (TextBox)FindDynamicControlByName("textbox_1");

            if (rc != null)

            {

                MessageBox.Show("hai");

            }

        }

        private Control FindDynamicControlByName(string controlName)

        {

            return Controls.Find(controlName, true).FirstOrDefault();

        }

    }

}

Manager Emp Query

select e.eid,e.ename,m.ename as manager from xxx as e left after xxx as m on e.mid=m.eid

WHERE XXX table name same Table 

Top One Salary and top 2 salary

TOP 1 

Select Top 1 Salary from (select top 1 salary from xxx order by salary desc) as salary order by salary asc

TOP 2

Select Top 1 Salary from (select top 2 salary from xxx order by salary desc) as salary order by salary asc

----
Note
WHERE XXX Is Table name

Ms Office 2007 Oledb Read file Excel Code and 2010 code

2007................
OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source='E://Naresh.xlsx';Extended Properties=\'Excel 8.0';");

     
        OleDbCommand cmd = new OleDbCommand("select * from [Sheet1$]");
        cmd.Connection = con;
        OleDbDataAdapter dap = new OleDbDataAdapter(cmd);
        DataSet ds = new DataSet();
        dap.Fill(ds);
        return (ds);

2010..................

OleDbConnection con = new OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;Data Source='E://Naresh.xlsx';Extended Properties=\'Excel 8.0';");

     
        OleDbCommand cmd = new OleDbCommand("select * from [Sheet1$]");
        cmd.Connection = con;
        OleDbDataAdapter dap = new OleDbDataAdapter(cmd);
        DataSet ds = new DataSet();
        dap.Fill(ds);
        return (ds);

Gridview Searching textBox using OLEDB Connection Excel

Aspx
------------------------
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Excel.aspx.cs" Inherits="Excel" %>

<!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">
    <div>
    <asp:TextBox ID="txtsearch" runat="server"></asp:TextBox>
    <asp:Button ID="btnsearch" runat="server" Text="Search" onclick="btnsearch_Click" />

    <asp:GridView ID="grd" runat="server" AutoGenerateColumns="False" BackColor="White"
            BorderColor="White" BorderStyle="Ridge" BorderWidth="2px" CellPadding="3"
            CellSpacing="1" GridLines="None">
        <Columns>
            <asp:TemplateField HeaderText="empid">
                <ItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%# bind("empid") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField >
            <asp:TemplateField HeaderText="empname">
                <ItemTemplate>
                    <asp:Label ID="Label2" runat="server" Text='<%# bind("empname") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="salary">
                <ItemTemplate>
                    <asp:Label ID="Label3" runat="server" Text='<%# bind("salary") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
 
        <FooterStyle BackColor="#C6C3C6" ForeColor="Black" />
        <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#E7E7FF" />
        <PagerStyle BackColor="#C6C3C6" ForeColor="Black" HorizontalAlign="Right" />
        <RowStyle BackColor="#DEDFDE" ForeColor="Black" />
        <SelectedRowStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" />
        <SortedAscendingCellStyle BackColor="#F1F1F1" />
        <SortedAscendingHeaderStyle BackColor="#594B9C" />
        <SortedDescendingCellStyle BackColor="#CAC9C9" />
        <SortedDescendingHeaderStyle BackColor="#33276A" />
 
    </asp:GridView>
 
    </div>
    </form>
</body>

</html>

--------------------------------------------------------------------------------------------------

ASPX.CS

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.OleDb;

public partial class Excel : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Session.Clear();
            grd.DataSource = getData();
            grd.DataBind();
        }
    }
    public DataSet getData()
        {
        OleDbConnection con = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='D://Naresh.xlsx';Extended Properties=\'Excel 8.0;'");
        OleDbCommand cmd = new OleDbCommand("select * from [emp$]");
        cmd.Connection = con;
        OleDbDataAdapter dap = new OleDbDataAdapter(cmd);
        DataSet ds = new DataSet();
        dap.Fill(ds);
        return (ds);
    }
    protected void btnsearch_Click(object sender, EventArgs e)
    {



        //grd.DataSource = getValues(txtsearch.Text);
        //grd.DataBind();

        foreach (GridViewRow objgrd in grd.Rows)
        {

            Label lblname = (Label)objgrd.FindControl("Label2");
            Label lblid = (Label)objgrd.FindControl("Label1");
            Label lblsalary = (Label)objgrd.FindControl("Label3");
            if (txtsearch.Text == lblname.Text)
            {
                DataTable dt = new DataTable();
                dt.Columns.Add("empid", typeof(string));
                dt.Columns.Add("empname", typeof(string));
                dt.Columns.Add("salary", typeof(string));
                dt.Rows.Add(lblid.Text, lblname.Text, lblsalary.Text);
                grd.DataSource = dt;
                grd.DataBind();
            }
        }
        //}
        ////    //DataSet ds =
        ////    grd.DataSource = getValues(lblsalary.Text);
        ////    grd.DataBind();
        ////    //DataTable dt = new DataTable();
        ////    //dt.Columns.Add("empid", typeof(string));
        ////    //dt.Columns.Add("empname", typeof(string));
        ////    //dt.Columns.Add("salary", typeof(string));
        ////    //if (Session["dt"] == null)
        ////    //{
        ////    //    dt.Rows.Add(ds.Tables[0].Rows[0][0].ToString(), ds.Tables[0].Rows[0][2].ToString(), ds.Tables[0].Rows[0][2].ToString());
        ////    //    Session["dt"] = dt;
        ////    //    grd.DataSource = dt;
        ////    //    grd.DataBind();

        ////    //}
        ////    //else
        ////    //{
        ////    //    DataTable dt2 = (DataTable)Session["dt"];
        ////    //    dt2.Rows.Add(ds.Tables[0].Rows[0][0].ToString(), ds.Tables[0].Rows[0][2].ToString(), ds.Tables[0].Rows[0][2].ToString());
        ////    //    Session["dt"] = dt2;

        ////    //    grd.DataSource = dt2;
        ////    //    grd.DataBind();

        ////    //}


        ////}
     

    }
    public DataSet getValues(string name)
    {
        OleDbConnection con = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='D://Naresh.xlsx';Extended Properties=\'Excel 8.0';");
        OleDbCommand cmd = new OleDbCommand("select * from [emp$] Where empname like '" + name + "%'");
        cmd.Connection = con;
     
        OleDbDataAdapter dap = new OleDbDataAdapter(cmd);
        DataSet ds = new DataSet();
        dap.Fill(ds);
        return (ds);
    }


}

Datalist Grid Cart using Sessions

ASPX.... Laps.aspx

---------------
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="laps.aspx.cs" Inherits="_Default" %>

<!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">
    <div>
        <asp:DataList ID="dllap" runat="server" BackColor="LightGoldenrodYellow"
            BorderColor="Tan" BorderWidth="1px" CellPadding="2" ForeColor="Black">
            <AlternatingItemStyle BackColor="PaleGoldenrod" />
            <FooterStyle BackColor="Tan" />
            <HeaderStyle BackColor="Tan" Font-Bold="True" />
            <ItemTemplate>
                <table>
                    <tr>
                        <td>
                            <asp:CheckBox ID="chklap" runat="server" />
                        </td>
                        <asp:Label ID="lbllapid" runat="server" Text='<%#bind("lapid") %>' Visible="false"></asp:Label>
                        <td>
                            <asp:Label ID="lbllapname" runat="server" Text='<%#bind("lapname") %>'></asp:Label>
                        </td>
                        <td>
                            <asp:Image ID="lapimg" runat="server" ImageUrl='<%#bind("lapimg") %>' Height="100px" />
                        </td>
                        <td>
                            <asp:Label ID="lbllapprice" runat="server" Text='<%#bind("lapprice") %>'></asp:Label>
                        </td>
                     
                    </tr>
                </table>
            </ItemTemplate>
            <SelectedItemStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
        </asp:DataList>
        <asp:Button ID="btnok" runat="server" Text="ok" OnClick="btnok_Click" />
        <asp:Button ID="btnlogout" runat="server" Text="logout"
            onclick="btnlogout_Click" />
    </div>
    </form>
</body>
</html>

-----------------------------------------------------------------------------------------------

laps.ASPX.CS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

public partial class _Default : System.Web.UI.Page

{

    Class1 obj = new Class1();

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

             

            //Label lbll=(Label)dl.FindControl("lbllapid");

                dllap.DataSource = obj.totaaps();

                dllap.DataBind();

                //Session.Clear(); 

          

        }

    }

    protected void btnok_Click(object sender, EventArgs e)

    {

        foreach (DataListItem dll in dllap.Items)

        {

            //finding the control in container.

            CheckBox chk = (CheckBox)dll.FindControl("chklap");

            

            if (chk.Checked)

            {

                Label lbll = (Label)dll.FindControl("lbllapid");

                Label lblitemname = (Label)dll.FindControl("lbllapname");

                Image lblimg = (Image)dll.FindControl("lapimg");

                Label lblprice = (Label)dll.FindControl("lbllapprice");

                

                //DataSet ds = obj.nnn(Convert.ToInt32(lbll.Text));

                DataTable dt = new DataTable();

                dt.Columns.Add("lapid", typeof(string));

                dt.Columns.Add("lapname", typeof(string));

                dt.Columns.Add("lapimg", typeof(string));

                dt.Columns.Add("lapprice", typeof(string));

                dt.Columns.Add("txtqty", typeof(string));

                dt.Columns.Add("txtlaptotal", typeof(string));

                if (Session["dt"] == null)

                {

                    dt.Rows.Add(lbll.Text,lblitemname.Text, lblimg.ImageUrl,lblprice.Text,"","");

                    Session["dt"] = dt;

                }

                else

                {

                    DataTable dttt = (DataTable)Session["dt"];

                    dttt.Rows.Add(lbll.Text, lblitemname.Text, lblimg.ImageUrl, lblprice.Text,"","");

                    Session["dt"] = dttt;

                }

            }

            

        }

       

        //foreach (DataListItem dl in dllap.Items)

        //{

        //    CheckBox chk = (CheckBox)dl.FindControl("chklap");

        //    if (chk.Checked)

        //    {

        //        Label lbl_id = (Label)dl.FindControl("lbllapid");

        //        Label lbl_name = (Label)dl.FindControl("lbllapname");

        //        Image img = (Image)dl.FindControl("lapimg");

        //        Label lbl_price = (Label)dl.FindControl("lbllapprice");

        //        dt.Rows.Add(lbl_id.Text, lbl_name.Text, img.ImageUrl, lbl_price.Text);

        //    }

           // Session["lapid"] = dt;

        //}

        Response.Redirect("selectedlap.aspx");

    }

    protected void btnlogout_Click(object sender, EventArgs e)

    {

        Session.Clear();

    }

}

----------------------------------------------------------------------------------------------

Selected ASPX

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="selectedlap.aspx.cs" Inherits="selectedlap" %>

<!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">

    <div>

    <asp:Button ID="btnlogout" runat="server" Text="Logout" onclick="btnlogout_Click" />

        <asp:GridView ID="gridlap" runat="server" AutoGenerateColumns="False" 

            OnSelectedIndexChanged="txtqtyChange" BackColor="#DEBA84" BorderColor="#DEBA84" 

            BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2">

            <Columns>

                <asp:TemplateField HeaderText="id">

                    <ItemTemplate>

                        <asp:Label ID="lbllapid" runat="server" Text='<%#bind("lapid") %>'></asp:Label></ItemTemplate>

                </asp:TemplateField>

                <asp:TemplateField HeaderText="name">

                    <ItemTemplate>

                        <asp:Label ID="lbllapname" runat="server" Text='<%#bind("lapname") %>'></asp:Label></ItemTemplate>

                </asp:TemplateField>

                <asp:TemplateField HeaderText="image" ControlStyle-Height="50px" ControlStyle-Width="50px">

                    <ItemTemplate>

                        <asp:Image ID="lapimg" runat="server" ImageUrl='<%#bind("lapimg") %>' />

                    </ItemTemplate>

<ControlStyle Height="50px" Width="50px"></ControlStyle>

                </asp:TemplateField>

                <asp:TemplateField HeaderText="quantity">

                    <ItemTemplate>

                        <asp:TextBox ID="txtqty" runat="server" Text='<%#Bind("txtqty") %>' OnTextChanged="txtqtyChange" AutoPostBack="true"></asp:TextBox></ItemTemplate>

                </asp:TemplateField>

                <asp:TemplateField HeaderText="price">

                    <ItemTemplate>

                        <asp:Label ID="lbllapprice" runat="server" Text='<% #bind("lapprice")%>'></asp:Label></ItemTemplate>

                </asp:TemplateField>

                <asp:TemplateField HeaderText="total">

                    <ItemTemplate>

                        <asp:TextBox ID="txtlaptotal" runat="server" Text='<%#Bind("txtlaptotal") %>'></asp:TextBox>

                    </ItemTemplate>

                </asp:TemplateField>

            </Columns>

            <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />

            <HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />

            <PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />

            <RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />

            <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />

            <SortedAscendingCellStyle BackColor="#FFF1D4" />

            <SortedAscendingHeaderStyle BackColor="#B95C30" />

            <SortedDescendingCellStyle BackColor="#F1E5CE" />

            <SortedDescendingHeaderStyle BackColor="#93451F" />

        </asp:GridView>

        total:

        <asp:TextBox ID="totaltxt" runat="server"></asp:TextBox>

        <asp:Button ID="btnbacklap" runat="server" Text="back" 

            OnClick="btnbacklap_Click" style="height: 26px" />

    </div>

    </form>

</body>

</html>

------------------------------------------------------------------------------------------------------

selected.aspx.cs

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;

public partial class selectedlap : System.Web.UI.Page

{

    Class1 obj1 = new Class1();

    int total = 0;

    DataTable dt2;

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            

            DataTable dtr = (DataTable)Session["dt"];

            

            gridlap.DataSource = dtr;

            gridlap.DataBind();

        }

    }

    public void txtqtyChange(object sender, EventArgs e)

    {

        foreach (GridViewRow gd in gridlap.Rows)

        {

            TextBox txttotal = (TextBox)gd.FindControl("txtlaptotal");

            TextBox txt = (TextBox)gd.FindControl("txtqty");

            Label lbl = (Label)gd.FindControl("lbllapprice");

            if (txt.Text == string.Empty)

            {

            }

            else

            {

                txttotal.Text = Convert.ToString(Convert.ToInt32(txt.Text) * Convert.ToDecimal(lbl.Text));

                total += Convert.ToInt32(txttotal.Text);

            }

        }

        totaltxt.Text = total.ToString();

    }

    protected void btnbacklap_Click(object sender, EventArgs e)

    {

        Session.Clear();

        foreach (GridViewRow objrow in gridlap.Rows)

        {

            Label lblid = (Label)objrow.FindControl("lbllapid");

            Label lbname = (Label)objrow.FindControl("lbllapname");

            Image img = (Image)objrow.FindControl("lapimg");

            TextBox txtqtyy = (TextBox)objrow.FindControl("txtqty");

            Label lblprice = (Label)objrow.FindControl("lbllapprice");

            TextBox txttotl = (TextBox)objrow.FindControl("txtlaptotal");

            if (Session["dt"] != null)

            {

                

                DataTable dt1 = (DataTable)Session["dt"];

                dt1.Rows.Add(lblid.Text, lbname.Text, img.ImageUrl, lblprice.Text,txtqtyy.Text, txttotl.Text);

                Session["dt"] = dt1;

            }

            else

            {

                DataTable dt = new DataTable();

                dt.Columns.Add("lapid", typeof(string));

                dt.Columns.Add("lapname", typeof(string));

                dt.Columns.Add("lapimg", typeof(string));

                dt.Columns.Add("lapprice", typeof(string));

                dt.Columns.Add("txtqty", typeof(string));

                dt.Columns.Add("txtlaptotal", typeof(string));

                dt.Rows.Add(lblid.Text, lbname.Text, img.ImageUrl, lblprice.Text, txtqtyy.Text, txttotl.Text);

                Session["dt"] = dt;

            }

           

        }

        Response.Redirect("laps.aspx");

    }

    // Response.Redirect("laps.aspx");

    protected void btnlogout_Click(object sender, EventArgs e)

    {

        Session.Clear();

    }

}

----------------------------------------------------------------------------------------------------

.Class.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

/// <summary>
/// Summary description for Class1
/// </summary>
public class Class1
{
    public string cn = ConfigurationManager.ConnectionStrings["con"].ToString();
    SqlConnection con;
    SqlCommand cmd;
    SqlDataAdapter da;
    DataSet ds;
    public Class1()
    {
        //
        // TODO: Add constructor logic here
        //
    }
    public DataSet totaaps()
    {
        con = new SqlConnection(cn);
        cmd = new SqlCommand("select * from lap", con);
        da = new SqlDataAdapter(cmd);
        ds = new DataSet();
        da.Fill(ds);
        return ds;
    }
    public DataSet nnn(int lapid)
    {
        con = new SqlConnection(cn);
        cmd = new SqlCommand("select * from lap where lapid='"+lapid+"'", con);
        da = new SqlDataAdapter(cmd);
        ds = new DataSet();
        da.Fill(ds);
        return ds;
    }
}
---------------------------------------------------------------------------------------------------

Grid PopUp Extender Ajax

ASPX.CS

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Grid.aspx.cs" Inherits="Grid" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>

<!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 id="Head1" runat="server">

    <title></title>

</head>

<body>

    <form id="form1" runat="server">

    <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">

    </asp:ToolkitScriptManager>

    <div>

        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BorderColor="#336699"

            BorderStyle="Solid" BorderWidth="1px" CellPadding="3" Font-Names="Verdana" Font-Size="10pt"

            OnRowCreated="GridView1_RowCreated">

            <Columns>

                <asp:BoundField DataField="ProductID" HeaderText="Product ID" />

                <asp:BoundField DataField="ProductName" HeaderText="Product Name" />

                <asp:TemplateField ItemStyle-Width="40" ItemStyle-HorizontalAlign="Right">

                    <ItemTemplate>

                        <asp:Image ID="Image1" runat="server" ImageUrl="Images/image.jpg" />

                        <asp:PopupControlExtender id="PopupControlExtender1" runat="server" PopupControlID="Panel1"

                            TargetControlID="Image1" DynamicContextKey='<%# Eval("ProductID") %>' DynamicControlID="Panel1"

                            DynamicServiceMethod="GetDynamicContent" Position="Bottom">

</asp:popupcontrolextender>

                    </ItemTemplate>

                </asp:TemplateField>

            </Columns>

            <HeaderStyle BackColor="#336699" ForeColor="White" />

        </asp:GridView>

        <asp:Panel ID="Panel1" runat="server"> </asp:Panel>

    </div>

    </form>

</body>

</html>

------------------------------------------------------------------------------

Aspx.CS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Data;

using System.Text;

using AjaxControlToolkit;

public partial class Grid : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!Page.IsPostBack)

        {

            LoadData();

        }

    }

    private void LoadData()

    {

        string constr = "Data Source=KCLINK-45-PC\\SQLEXPRESS;Initial Catalog=naresh;Integrated Security=True";

        string query = "SELECT ProductID, ProductName FROM aaaa";

        SqlDataAdapter da = new SqlDataAdapter(query, constr);

        DataTable table = new DataTable();

        da.Fill(table);

        GridView1.DataSource = table;

        GridView1.DataBind();

    }

    protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)

    {

        if (e.Row.RowType == DataControlRowType.DataRow)

        {

            PopupControlExtender pce = e.Row.FindControl("PopupControlExtender1") as PopupControlExtender;

            string behaviorID = "pce_" + e.Row.RowIndex;

            //pce.BehaviorID = behaviorID;

            Image img = (Image)e.Row.FindControl("Image1");

            string OnMouseOverScript = string.Format("$find('{0}').showPopup();", behaviorID);

            string OnMouseOutScript = string.Format("$find('{0}').hidePopup();", behaviorID);

            img.Attributes.Add("onmouseover", OnMouseOverScript);

            img.Attributes.Add("onmouseout", OnMouseOutScript);

        }

    }

    [System.Web.Services.WebMethodAttribute(),

    System.Web.Script.Services.ScriptMethodAttribute()]

    public static string GetDynamicContent(string contextKey)

    {

        string constr = "Data Source=KCLINK-45-PC\\SQLEXPRESS;Initial Catalog=naresh;Integrated Security=True";

        string query = "SELECT UnitPrice,Description FROM aaa WHERE ProductID = " + contextKey;

        SqlDataAdapter da = new SqlDataAdapter(query, constr);

        DataTable table = new DataTable();

        da.Fill(table);

        StringBuilder b = new StringBuilder();

        b.Append("<table style='background-color:#f3f3f3; border: #336699 3px solid; ");

        b.Append("width:350px; font-size:10pt; font-family:Verdana;' cellspacing='0' cellpadding='3'>");

        b.Append("<tr><td colspan='3' style='background-color:#336699; color:white;'>");

        b.Append("<b>Product Details</b>"); b.Append("</td></tr>");

        b.Append("<tr><td style='width:80px;'><b>Unit Price</b></td>");

        //b.Append("<td style='width:80px;'><b>Stock</b></td>");

        b.Append("<td><b>Description</b></td></tr>");

        b.Append("<tr>");

        b.Append("<td>" + table.Rows[0]["UnitPrice"].ToString() + "</td>");

        //b.Append("<td>" + table.Rows[0]["UnitsInStock"].ToString() + "</td>");

        b.Append("<td>" + table.Rows[0]["Description"].ToString() + "</td>");

        b.Append("</tr>");

        b.Append("</table>");

        return b.ToString();

    }

}

----------------------------------------------------------------------------------------------------