0

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

3
Contributors
3
Replies
11
Views
1 Year
Discussion Span
Last Post by bayron209
0

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()
1

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)

Votes + Comments
yeah yeah.. all in one record will display.. so this is the right syntax? gonna try this one
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.