Database Listview Select * Query

The best way is to use the DataSource.

Here is the code as per your requirement(add columns to the data gridview either in design mode or before calling this code)

string connectionString = ConfigurationManager.ConnectionStrings["MyConnection"].ToString();

using (SqlConnection conn = new SqlConnection(connectionString))

using (SqlCommand myCommand = conn.CreateCommand())

myCommand.CommandType = System.Data.CommandType.Text;

myCommand.CommandText = "SELECT * FROM employee";

SqlDataReader dr = myCommand.ExecuteReader();

while (dr.Read())

http://www.codeproject.com/KB/books/PresentDataDataGridView.aspx

Here is sample code to create columns and add data from SQL to list view. Hope this helps and please tune the code

You can create columns to ListView within the code as shown below or you can add columns in Designer View

        private void LstVw_Load(object sender, EventArgs e)

        {

            AddColumnsToListView();

            string connectionString = ConfigurationManager.ConnectionStrings["MyConnection"].ToString();

            using (SqlConnection conn = new SqlConnection(connectionString))

            {

                using (SqlCommand myCommand = conn.CreateCommand())

                {

                    myCommand.CommandType = System.Data.CommandType.Text;

                    myCommand.CommandText = "SELECT * FROM employee";

                    conn.Open();

                    SqlDataReader dr = myCommand.ExecuteReader();

                    while (dr.Read())

                    {

                        ListViewItem lvi = new ListViewItem( new string[] {dr[0] != System.DBNull.Value ? dr.GetInt32(0).ToString() : string.Empty,

                        dr[1] != System.DBNull.Value ? dr.GetString(1) : string.Empty,

                        dr[3] != System.DBNull.Value ? dr.GetString(3) : string.Empty});

                        //ListViewItem lvi = new ListViewItem(dr[0] != System.DBNull.Value ? dr.GetInt32(0).ToString() : string.Empty);

                        //lvi.SubItems.Add(dr[1] != System.DBNull.Value ? dr.GetString(1) : string.Empty );

                        //lvi.SubItems.Add(dr[3] != System.DBNull.Value ? dr.GetString(3) : string.Empty);

                        listView2.Items.Add(lvi);

                    }

                }

            }

        }

        private void AddColumnsToListView()

        {

            listView2.Columns.Add("Id", 30, HorizontalAlignment.Right);

            listView2.Columns.Add("Name", 80, HorizontalAlignment.Left);

            listView2.Columns.Add("Job", 50, HorizontalAlignment.Left);       

        }

Ok it works

But I'm trying to have all of my fields  ( 3) from the database to the Listview1. each of them in their columnheader.

I saw some code but it is not a way to understand what they r doing

string connectionString = yourconnectionstring;

using (SqlConnection conn = new SqlConnection(connectionString))

using (SqlCommand myCommand = conn.CreateCommand())

myCommand.CommandType = System.Data.CommandType.Text;

myCommand.CommandText = "SELECT * FROM employee";

SqlDataReader dr = myCommand.ExecuteReader();

while (dr.Read())