datagrid/datatable

[Techno]

Hi there. I was just testing and playing about, i have made a function which does something i need it to do. however it uses a datagrid/datatable to get the values from

is there another way of getting the values without having to show or use the datagrid?

Thanks!

[brown monkey]

You can use DataReader instead of Adapter and use ListView

        SqlConnection cn=new SqlConnection("user id=sa;password=password;initial catalog=northwind");
        private void Form1_Load(object sender, System.EventArgs e)
        {
            cn.Open();
            SqlCommand cm=new SqlCommand("select * from territories",cn);
            SqlDataReader dr=cm.ExecuteReader();
            while(dr.Read())
            {
                ListViewItem li=listView1.Items.Add(dr[0].ToString());
                li.SubItems.Add(dr[1].ToString());
                li.SubItems.Add(dr[2].ToString());
            }
            cn.Close();
        }