Count duplicate rows

[bayron209]

Can someone help me, how to count duplicate rows in vb.net using mysql . auto count after search or filter but in my code it count all existing data within the range

my code:

 Try
            con.Open()
            With cmd
                .Connection = con
                .CommandText = "select s_monthname, count(*) as Total from sample2"
                reader = .ExecuteReader
            End With

            da.SelectCommand = cmd
            table1.Clear()
            da.Fill(table1)
            DataGridView1.DataSource = table1
        Catch ex As MySqlException
            MessageBox.Show(ex.Message)
        Finally
            con.Dispose()

        End Try

Please help me

[Santanu.Das]

To count record nos. the syntax is

select count(*) from <TableName> Where <Condition>

To get the number of records the syntax is

Dim x as Integer = .ExecuteScalar()
or
Int x =.ExecuteScalar()

[JOSheaIV]

A little addition to Shark_1's post,

You probably will also want to add a Group By onto that select statement. So for instance if you want to see how many occurances there are of the s_monthname in the table, but only return distinct records in relation to the month name (so only 1 record) you could do something like

select s_monthname, count(*) as Total from sample2 GROUP BY s_monthname

Not only will that return the s_monthname value, but the Total will be how many times that a value in that column has occured in the table (but all in one record)

[bayron209]

Thank you guys, it really works.. i ask again later