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 drpgrid :
System.Web.UI.Page
{
adosession obj;
protected void
Page_Load(object sender, EventArgs e)
{
obj =
new adosession();
DataSet ds = obj.bindgrid(Convert.ToInt32(Session["id"]), "ById");
DataTable dt = new
DataTable();
dt.Columns.Add("id", typeof(int));
dt.Columns.Add("name", typeof(string));
dt.Columns.Add("address", typeof(string));
if (Session["dt"]
== null)
{
dt.Rows.Add(ds.Tables[0].Rows[0][0].ToString(),
ds.Tables[0].Rows[0][1].ToString(), ds.Tables[0].Rows[0][2].ToString());
grd.DataSource = dt;
grd.DataBind();
Session["dt"] = dt;
}
else
{
DataTable dt2 = (DataTable)Session["dt"];
dt2.Rows.Add(ds.Tables[0].Rows[0][0].ToString(),
ds.Tables[0].Rows[0][1].ToString(), ds.Tables[0].Rows[0][2].ToString());
Session["dt"] = dt2;
grd.DataSource = dt2;
grd.DataBind();
}
}
}
Stored Procedure
USE [naresh]
GO
/****** Object: StoredProcedure [dbo].[sp_getgridvalues] Script Date: 06/30/2014 13:04:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE procedure [dbo].[sp_getgridvalues]
@id int,
@type varchar(50)
as
begin
if(@type='Byid')
select id,name,address from gridsession where id=@id
else
select * from gridsession
end
GO
