c# - is it possible to retrieve data in the database automatically? -

so far have use list view retrieve data first , put in designated text boxes,,what want when retrieve or search data automatically put in designated text boxes in form

private void btnretrieve_click(object sender, eventargs e) {         con.open();         sqlcommand cmd = new sqlcommand("select * information", con);         sqldataadapter dta = new sqldataadapter(cmd);         datatable dt = new datatable();          dta.fill(dt);         con.close();         lvwcontacts.items.clear();          (int index = 0; index < dt.rows.count; index++)         {             lvwcontacts.items.add(dt.rows[index]["contact_id"].tostring());             lvwcontacts.items[index].subitems.add(dt.rows[index]["contact_name"].tostring());             lvwcontacts.items[index].subitems.add(dt.rows[index]["contact_address"].tostring());             lvwcontacts.items[index].subitems.add(dt.rows[index]["contact_no"].tostring()); } 

with listview won't able that. however, approach might this:

lvwcontacts.items.addrange(     r in dt.select()     select new listviewitem(r.itemarray.cast<string>().toarray()) ); 

but, you'll need change select statement be:

select contact_id, contact_name, contact_address, contact_no information