Loop to count data in data grid view column 2

Question

0.00/5 (No votes)

See more:

VB

Dim s As String = dgv.Rows(row).Cells("Column1").Value
             cmd = New OleDbCommand("SELECT COUNT(Protocol) As num FROM Raw_Protocol WHERE Protocol = '" & s & "'", connection)
        Dr = cmd.ExecuteReader

            While Dr.Read()


                dgv.Rows.Add()
                dgv.Rows(row).Cells("Column2").Value = Dr("num")
                   datagridview1.Rows(row).Cells("Column4").Value = Dr("num")
                row += 1

           End While

This is another question,i want to make it loop to count the data in the mdb database only when data grid view row column 1 got data and stop when the data grid view row column 1 don't have data. Can show me how i changed the code.Thanks

Posted 28-Jun-11 5:32am

william_nhl

Add a Solution

Comments

[no name] 19-Apr-12 2:53am

i have a gridview and i want to bind it from the loop in which loop contain data from database and gridview displays only last record. i want to display all records which data is according to query.

my query in for loop like...
for (int k = 0; k < intArray.Length; k++)
{
//select document.title from document,document_rights where document_rights.user_id in('" + intArray[k] + "')";
string xxxx = "select title from document where id in('"+intArray[k]+"')";
ad1 = new SqlDataAdapter(xxxx, c.getcon());
ds1 = new DataSet();
ad1.Fill(ds1);

if (ds.Tables[0].Rows.Count != 0)
{

GridView1.DataSource = ds1;
GridView1.DataBind();
}

}

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2011-06-28T06:01:00

Not an answer, but a strong suggestion: never, ever concatenate your strings to generate an SQL command: it is an open invitation to an accidental or deliberate SQL injection attack which can destroy your database. Use Parameterized queries instead:

cmd = New OleDbCommand("SELECT COUNT(Protocol) As num FROM Raw_Protocol WHERE Protocol = @PCL", connection)
cmd.Parameters.AddWithValue("@PCL", s);

Mehul M Thakkar · Answer 2 · 2011-06-28T06:20:00

Solution 2

Can you explain properly what you want to achieve?

Posted 28-Jun-11 6:20am

Mehul M Thakkar

Comments

william_nhl 28-Jun-11 12:35pm

What i want is to let the source code above to run to calculate each data grid view row column 1 data and show it on that row column 2 if the column 1 have data. The below is the source code that will show the distinct data in data grid view column 1.
Dim n As Integer = 0
row = 0
dgv.Rows.Clear()
datagridview1.Rows.Clear()
connection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\AnalyzerDb.mdb")
connection.Open()
cmd = New OleDbCommand("SELECT DISTINCT (Protocol) FROM Raw_Protocol", connection)
Dr = cmd.ExecuteReader
Do
While Dr.Read()
dgv.Rows.Add(Dr("Protocol"))
datagridview1.Rows.Add(Dr("Protocol"))
n += 1
End While
Loop While Dr.NextResult
Dr.Close()
connection.Close()

Simon_Whale · Answer 3 · 2011-06-28T12:06:00

If I get what your after!

its a list in a datagridview that shows Protocol and Count of Protocol i.e.

Protocol, Count
a, 10
b, 2

and so on. If so you can solve this in a query

SQL

select protocol, count(protocol) from raw_protocol

using the query with a dataadapter as shown in this article, oleDbAdapter[^]

The example uses a dataset but you can just replace it for a datatable if you wish.

Loop to count data in data grid view column 2

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0