how to get the count value for gridview from (sqlserver database)database [modified]

[priyamsc]

Hi, I am doing forum project. I have a doubt, tat how to count the value. that is, all the data which displays in gridview. in tat i need to show the reply value [count the value from database].it means in database i hv field lke pid,pstreplyid,uid,tit,sub ...., in tat wen i create new msg it ll save in database giving pid automaticaly and in pstreplyid if its newmsg it creates 0 if its reply ten it takes pid value. in gridview what i wud lke to display is, the reply value, if the pid(2) has 3 reply means, the field of reply shud show 3. but i hv given query which displays only the new msg tat is pstreplyid=0. i need to display new msg at the same time it should display the replyvalue also. but i dnt knw how to count tat value so pls help me to do. you just give me the suggestion to overcome the issue. this is the gridview coding ============================

page load()
{
string k = "select *,(select uname from login where login.uid=thread.uid)as uname from thread where pstreplyid=0";
adp = new SqlDataAdapter(k, con);
DataSet ds = new DataSet();
adp.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}

HTML ====

<asp:TemplateField HeaderText="Thread">
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("tit") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<
<asp:LinkButton ID="LinkButton1" runat="server" Text='<% # Eval("tit") %>' CommandName ="viewmsg" CommandArgument ='<%# DataBinder.Eval(Container.DataItem,"pid")%>' >LinkButton</asp:LinkButton>
<br />
<%#Eval("sub") %>
</ItemTemplate>
<asp:BoundField HeaderText="Replies" DataField="pstreplyid"/>
<asp:BoundField DataField="pdate" HeaderText="Post Date" />
<asp:BoundField DataField="rdate" HeaderText="Reply Date" />
<asp:TemplateField HeaderText="Posted By">

Thank you in advance.

k.priya

modified on Sunday, August 9, 2009 12:08 PM

[Arindam Sinha]

priyamsc wrote:

how to count the value. that is, all the data which displays in gridview

Try out ds.Tables[0].Rows.Count..(just check the syntax :))

Regards, Arindam Sinha MyBlog - http://arindamsinha.wordpress.com/ Please give your feedback on this answer.

[priyamsc]

could you say little bit clearly

k.priya

[Arindam Sinha]

I think, you can get the count of rows which you are looking for. ds.Tables[0].Rows.Count would give you the count of rows. Let me know if you are looking for something else. :)

Regards, Arindam Sinha MyBlog - http://arindamsinha.wordpress.com/ Please give your feedback on this answer.