Populate listview with data received from SQL query

Question

I am currently trying to populate a listview with some data I have pulled from my database table; but not sure where to start; I have tried the following:

lstData.DataSource = conn;
lstData.DataBind();

But that causes an error:

"Data source is an invalid type. It must be either an IListSource, IEnumerable, or IDataSource. MVC"

Am I using the correct query strings in order to populate my listview?

Thanks,

Callum

C# Code:

string ssConnectionString = "Server connection";
SqlConnection conn = new SqlConnection(ssConnectionString);
conn.Open();

SqlCommand command = conn.CreateCommand();
command.CommandText = "SELECT Category FROM [dbo].[Category] WHERE CategoryID = '16'";            

command.ExecuteNonQuery();          

string com = command.ExecuteScalar().ToString();
lblSQL.Text = com;
conn.Close();

Assigning an SqlConnection to .DataSource property is not logical. And your ExecuteNonQuery is meaningless. It doesn't do anything at all. What are you try to do exactly? And use using statement to dispose your database connections — Soner Gönül
– Soner Gönül, Commented Jun 28, 2014 at 9:58
I am trying to get the information I pull from the SqlConnectionString into a listview via different controls. — user3744373
– user3744373, Commented Jun 28, 2014 at 10:02
lstData.DataSource = conn; is wrong lstData.DataSource=aDataTable — Vivek S.
– Vivek S., Commented Jun 28, 2014 at 10:35

Craig Moore · Accepted Answer · 2014-06-28 10:31:11Z

1

Using your code as a base to start from you may want to try the following: I assume your connection in "Server connection" is a place holder for a real connection string and you know what should go there.

string ssConnectionString = "Server connection";
SqlConnection conn = new SqlConnection(ssConnectionString);
conn.Open();
SqlCommand command = conn.CreateCommand();
command.CommandText = "SELECT Category FROM [dbo].[Category] WHERE CategoryID = '16'";     
SqlDataAdapter da = new SqlDataAdapter(command); 
DataTable dataTable;
da.Fill(dataTable);   
lstData.DataSource = dataTable;
lstData.DataBind();
conn.Close();

answered Jun 28, 2014 at 10:31

Craig Moore

1,0911 gold badge6 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

Populate listview with data received from SQL query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related