Tuesday, May 13, 2008

fixed header in Datagrid,Gridview in asp.net

<head runat="server">
<title>Untitled Page</title>
</head>
<script type="text/javascript">   
function showheader()
{
var ab= document.getElementById("<%=gd.ClientID%>");
var pnid = document.getElementById("<%=pn.ClientID%>");
var abc = ab.cloneNode(true);
var i = abc.rows.length -1;
for(;i>0;i--)
abc.deleteRow(i)
ab.deleteRow(0)
pnid.appendChild(abc)
}
window.onload =showheader
</script>

<body>
<form id="form1" runat="server">
<div><asp:Panel ID=pn runat=server></asp:Panel>
<asp:Panel ID=pnn runat=server style="overflow-y:scroll;height: 250px;weight:300px" >
<asp:GridView ID="gd" runat="server">
</asp:GridView>
</asp:Panel>
</div>
</form>
</body>
code file//////////
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlConnection con = new SqlConnection("Server=.;Database=dbdata;uid=sa;pwd=sa");
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "select top 100 * from locality";
cmd.Connection.Open();
SqlDataReader rdr = cmd.ExecuteReader();
gd.DataSource = rdr;
gd.DataBind();
cmd.Connection.Close();

}

2 comments :

AJAX, asp, Asp.net, asp.net and sql server security, Asp.net IntemIndex, C#, Css, DataBinder.Eval, DataKeyNames, Datalist, Datapager, DataSet, DataTable, DropDownList, FindControl, gridview, JavaScript, jquery, Listview, Paging, Regex, RegularExpression, Repeater, Server side validation, Sql Server, timer, timercallback, Validation, XML, xmlnode, XPath