counting

[katheeja]

helo i want to count values from database in c# please help me?

[JorgeM]

Can you clarify?

Do you want to count the number of rows in a table...for example...
SELECT COUNT(*) FROM tableName

[katheeja]

i want to count the number of values in a particular column. plz give the sqlcommand with c#coding. Am using asp.net. plz tell as soon as possible

[JorgeM]

Well the SQL statement is what I gave you, but replace the * with the name of the column. with regard to setting up the connection, that question has been asked on this forum a few times. refer to this posting: http://www.daniweb.com/software-development/csharp/threads/21636/how-do-you-connect-to-a-sql-database-using-c

[jijo cleetus]

this may help........

cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select count(FEILD NAME) from TABLE NAME";
da.SelectCommand = cmd;
da.Fill(dt);

int count =int.parse(dt.Rows[0][0].ToString());

Response.write(count.ToString());