filling the list view from database

how to fill in a data table from the database using data adapter,can show me the code? thk

A short example is available under:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataSqlClientSqlDataAdapterClassTopic.asp

You just need to provide the connection to the database and the SQL select command. Here is an example how a connection is created:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatasqlclientsqlconnectionclassctortopic.asp

the problem is they are not in c#,eh maybe u write some for me?

On these pages there are examples in Visual Basic, C# and C++. Just scroll a little

do u mean like this?this are my code...

private void comboBox1_SelectedIndexChanged(object sender, System.EventArgs e)
            {
                  if (comboBox1.SelectedIndex==0)
                  {
                        
                        try
                        {
                              SqlCeConnection connection = new SqlCeConnection(_localConnectionString);
                              connection.Open();
                              //SqlCeCommand command = new SqlCeCommand("SELECT matric_no, student_Name, tutorial_grp FROM tutorial1Class_listCE WHERE tutorial_grp ='T01';", connection);
                              
                              SqlDataAdapter adapter = new SqlDataAdapter();
                              adapter.SelectCommand = new SqlCommand("SELECT matric_no, student_name, tutorial_grp  FROM tutorial1Class_listCE Where tutorial_grp= 't01';", connection);
                              adapter.Fill(dataset);
                              return dataset;

                    foreach (DataRow row in dataTable)
                   this.listView1.Items.Add (new ListItem (new string[] {row[0].ToString(), row[1].ToString(), ....}));



                              //SqlCeCommand command = new SqlCeCommand("SELECT matric_no, student_name, tutorial_grp  FROM tutorial1Class_listCE Where tutorial_grp= 't01';", connection);
                              //IDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
                              //System.Text.StringBuilder sb = new System.Text.StringBuilder();
                              //while (reader.Read())
                              //{
                        
                                    listView1.Clear();



                                    //ListViewItem item = new ListViewItem(reader.Item("student_Name").ToString);
                                    //item.SubItems.Add(reader.Item("matric_no").ToString);
                                    //ListViewItem item = new ListViewItem("Steve Martin");
                                    //item.SubItems.Add("hi");
                                    

                      //  listView1.Items.Add(item);
                              }
                              reader.Close();

                        }
                        catch (SqlCeException ce)
                        {
                              ShowErrors(ce);
                        }
                        catch (Exception er)
                        {
                              MessageBox.Show(er.ToString());
                        }
                        finally
                        {
                              MessageBox.Show("ok", "RDA Lab");
                        }

This should be simple. Can you check this out - http://www.codeguru.com/Csharp/Csharp/cs_controls/tutorials/article.php/c8071/

cheers

 well i check it out and it seen a bit hard to understand so i try this code but i got error

   for this line of code.(  ListViewItem item = new ListViewItem(reader.GetInt32(0).ToString());  )
 can u tell me what does this line do, i think my data type is not int32 but is nvarchar.
 

                              SqlCeCommand command = new SqlCeCommand("SELECT matric_no, student_name, tutorial_grp  FROM tutorial1Class_listCE Where tutorial_grp= 't01';", connection);
                              IDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
                              System.Text.StringBuilder sb = new System.Text.StringBuilder();
                              while (reader.Read())
                              {
                        
                                    listView1.Clear();

                         ListViewItem item = new ListViewItem(reader.GetInt16(0).ToString());
                         item.SubItems.Add(reader.GetString(1));
                                    //ListViewItem item = new ListViewItem(reader.Item("student_Name").ToString);
                                    //item.SubItems.Add(reader.Item("matric_no").ToString);
                                    //listView1.Columns.Add("Student Name", -1, HorizontalAlignment.Center);
                                    //listView1.Columns.Add("Matric No", 150, HorizontalAlignment.Left);
                       
                                    //ListViewItem item = new ListViewItem("Diana");
                                    //item.SubItems.Add("hi");
                                    

                        listView1.Items.Add(item);
                              }
                              reader.Close();

  for this line of code.(  ListViewItem item = new ListViewItem(reader.GetInt32(0).ToString());  )
 can u tell me what does this line do, i think my data type is not int32 but is nvarchar.

This means that the first column is of type interger and is being converted into a string

If it is not a number in your case and is just a string , then say
ListViewItem item = new ListViewItem(reader.GetString(0));  

If any of your columns return a number, then use the syntax in line 1 and substitute an appropriate column number.

cheers