Attach sql query to a ListView control

Question

Here is my asp.net code:

public static void GetInvoices(int client_id) { using ( var conn = new SqlConnection( GetConnectionString() ) ) using ( var cmd = conn.CreateCommand() ) { conn.Open(); cmd.CommandText = conn.Open(); cmd.CommandText = @"SELECT o.OrderID, o.OrderDate, o.Status, o.ShipDate, o.PostAmount, sum(p.PaymentAmt) as Paid FROM Orders o left outer join payment p on o.orderid = p.orderid WHERE o.DistID = @client_id Group by o.OrderID, o.OrderDate, o.Status, o.ShipDate, o.PostAmount Order By o.OrderDate Desc"; cmd.Parameters.AddWithValue( "@client_id", client_id ); cmd.ExecuteNonQuery();; } }

How can I attach the information returned from this (which could possible be 0 rows returned) to a ListView control?

Is it as easy as

ListViewInvoices.DataSource = GetInvoices(1); ListViewInvoices.DataBind();

Or is there a more involved to connect it to a sql query data set?

I did not because it just didn't make sense in my mind. Then I got pulled off on something else, will still have to come back to this just couldn't test those last two lines at the moment. — James Wilson
– James Wilson, Commented Apr 27, 2012 at 21:20

Prashanth Thurairatnam · Accepted Answer · 2012-04-27 21:27:12Z

1

As you can see GetInvoices is a void method; returns nothing. You will need to use DataAdapter to fill and return a DataTable or DataSet. Then the last two lines should work

answered Apr 27, 2012 at 21:27

Prashanth Thurairatnam

4,3592 gold badges17 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

James Wilson Over a year ago

Alright that makes sense. I will add that and test it as soon as I can get to it.

Prashanth Thurairatnam Over a year ago

OK. May be instead of last two lines probably you will need to iterate through the DataTable and construct ListViewItems and add to the list view.

Emad Mokhtar · Accepted Answer · 2012-04-27 21:59:34Z

GetInvoices don't return neither DataSet nor DataTable, you're just executing the query but don't get the returned data in DataContainer aka DataSet or DataTable.

Collectives™ on Stack Overflow

Attach sql query to a ListView control

2 Answers 2

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Related