TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Rajkumar R
NA
183
219.7k
how to bind data into gridview in asp.net
Nov 1 2011 6:25 AM
protected void PageDropDownList_SelectedIndexChanged(Object sender, EventArgs e)
{
GridViewRow pagerRow = gvDetails.BottomPagerRow;
DropDownList pageList = (DropDownList)pagerRow.Cells[0].FindControl("PageDropDownList");
gvDetails.PageIndex = pageList.SelectedIndex;
}
private void BindGrid()
{
//Set your connection String here
SqlConnection CN = DBUtil.GetCon();
if (CN.State != ConnectionState.Closed)
CN.Close();
CN.Open();
string q = "SELECT Head_Code,Head_Name,Section_Code,Head_Mode,Head_Type,Head_Status FROM eLogs_Acc_Account_Master";
SqlCommand cmd = new SqlCommand(q, CN);
//SqlConnection cn = new SqlConnection("Data Source=.;Initial Catalog=Northwind;Integrated Security=True");
////Write a select Query
//string q = "select CustomerID,CompanyName,ContactName,Phone,City,Country from Customers";
DataSet dset = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(q, CN);
//cn.Open();
DataTable dtable = new DataTable();
da.Fill(dtable);
//Bind grid.
gvDetails.DataSource = dtable;
gvDetails.DataBind();
CN.Close();
}
protected void gvDetails_DataBound(object sender, EventArgs e)
{
GridViewRow pagerRow = gvDetails.BottomPagerRow;
if (pagerRow == null) return;
DropDownList pageList = (DropDownList)pagerRow.Cells[0].FindControl("PageDropDownList");
if (pageList == null) return;
Label pageLabel = (Label)pagerRow.Cells[0].FindControl("CurrentPageLabel");
for (int i = 0; i < gvDetails.PageCount; i++)
{
int pageNumber = i + 1;
ListItem item = new ListItem(pageNumber.ToString());
if (i == gvDetails.PageIndex)
{
item.Selected = true;
}
pageList.Items.Add(item);
}
if (pageLabel != null)
{
int currentPage = gvDetails.PageIndex + 1;
}
gvDetails.DataBind();
}
Here i m not able to view data in the grid it displaying empty page
Reply
Answers (
1
)
Read timeout error
Build Fails for VS 2008 whenever i am using Framework 2.0 Code