Get only the last result

Suhail Rakib

5y802Learn iOS Programming

Hey. Why do I only get the last result with this code?

foreach (DataGridViewRow dr in dgvOperation.Rows)
{
var query = @"GetFullText";
SqlCommand cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Text", dr.Cells[2].Value.ToString());
cmd.Parameters.AddWithValue("@Klientnavn", txtKlientNavn.Text);
DataTable dt = new DataTable();
var sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
sda.Fill(dt);
dgvOperation1.DataSource = dt;
}

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kiran Mohanty5y ago
Accepted answer
Below code should solve your issue .
DataTable dt = new DataTable();
var sda = new SqlDataAdapter();

foreach (DataGridViewRow dr in dgvOperation.Rows)
{
var query = @"GetFullText";
SqlCommand cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Text", dr.Cells[2].Value.ToString());
cmd.Parameters.AddWithValue("@Klientnavn", txtKlientNavn.Text);

sda.SelectCommand = cmd;
sda.Fill(dt);

}
dgvOperation1.DataSource = dt;
Suhail Rakib5y ago
Hi Kiran.
Thank you very much .
It works now.
Suhail Rakib5y ago
Hi Sachin.
Do you have any idea how I can do that?
What did you suggest?
Suhail Rakib5y ago
To get all values based on cell 2.
Sachin Singh5y ago
ohh now i found the mistake , your method is incoorect , you are using it inside foreach block then obviously you will get the result for last row only.
whatever is the value of Cell 2 in your datagrid accordingly you will get the result. you will always get just one result based on the last row of datagrid.
what is the point of assigning datasrc inside foreach???
Suhail Rakib5y ago
I have tried it individually and it ok. But the problem is when I use it from the app which has about 40 rows, I only get the last row.
Sachin Singh5y ago
test your SP by providing the same input what is in your SqlCommand but with SSMS and verify what are you getting. change London and laddoo with exact same string as there in your application and test the result. if you find any difference then let us know.
EXEC GetFullText @Text= 'London', @Klientnav='laddoo'
Suhail Rakib5y ago
This is my SP;

@Text nvarchar(255),
@Klientnavn nvarchar(255)
SELECT Bilag, Dato, Tekst, Konto, Modkonto, Debet, Kredit
FROM (SELECT OpgaveDetail.Id AS Bilag, OpgaveDetail.Dato, OpgaveDetail.Tekst, OpgaveDetail.Modkonto,
(CASE WHEN OpgaveDetail.Beløb < 0 THEN OpgaveDetail.Beløb END) * -1 AS Debet, (CASE WHEN OpgaveDetail.Beløb > 0 THEN OpgaveDetail.Beløb END) AS Kredit
FROM OpgaveDetail WHERE KlientId = (SELECT Id FROM Klient WHERE Navn = @Klientnavn) AND FREETEXT(Tekst, @Text)) a CROSS JOIN (SELECT DISTINCT kn.Konto FROM Kontering kn WHERE kn.KlientId = (SELECT Id FROM Klient WHERE Navn = @Klientnavn) AND FREETEXT(kn.Navn, @Text)) b
Sachin Singh5y ago
what does your GetFullText stored procedure do? whatever this stored procedure will return will be assigned to datatable , better is to show us your SP.