Hi
Try the following..
Html
<asp:GridView ID="gvEmployees" runat="server" OnDataBound="OnDataBound" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="PNO" HeaderText="PNO" />
<asp:BoundField DataField="NAME" HeaderText="NAME" />
<asp:BoundField DataField="COURSE" HeaderText="COURSE" />
<asp:BoundField DataField="COMPANY" HeaderText="COMPANY" />
</Columns>
</asp:GridView>
<asp:Label ID="lblEmployeeCount" runat="server"></asp:Label>
VB.Code
int count = 0;
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
this.GetData();
}
}
protected void OnDataBound(object sender, EventArgs e)
{
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not IsPostBack Then
Me.GetData()
End If
End Sub
Protected Sub OnDataBound(ByVal sender As Object, ByVal e As System.EventArgs)
Dim count As Integer = 0
For Each row As GridViewRow In Me.gvEmployees.Rows
If row.Cells(2).Text = "MCA" Then
count += 1
End If
Next
Me.lblEmployeeCount.Text = count.ToString()
End Sub
Private Sub GetData()
Dim dt As New DataTable
dt.Columns.AddRange(New DataColumn(3) {New DataColumn("PNO"), New DataColumn("NAME"), New DataColumn("COURSE"), New DataColumn("COMPANY")})
dt.Rows.Add("121", "RAJU", "BCA", "TCS")
dt.Rows.Add("234", "RK SINGH", "MCA", "TECHNO")
dt.Rows.Add("525", "P RAJ", "MCA", "KELTRON")
dt.Rows.Add("325", "ANIL", "BBA", "BPL")
dt.Rows.Add("235", "KUMAR", "MCA", "TATA")
gvEmployees.DataSource = dt
gvEmployees.DataBind()
End Sub
}
private void GetData()
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[4] { new DataColumn("PNO"), new DataColumn("NAME"), new DataColumn("COURSE"), new DataColumn("COMPANY") });
dt.Rows.Add("121", "RAJU", "BCA", "TCS");
dt.Rows.Add("234", "RK SINGH", "MCA", "TECHNO");
dt.Rows.Add("525", "P RAJ", "MCA", "KELTRON");
dt.Rows.Add("325", "ANIL", "BBA", "BPL");
dt.Rows.Add("235", "KUMAR", "MCA", "TATA");
this.gvEmployees.DataSource = dt;
this.gvEmployees.DataBind();
}
}