Guest User

Untitled

a guest
Jun 10th, 2012
32
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. how to populate a listview from a datatable
  2. DataTable dt = new DataTable();
  3. SqlConnection conn = new SqlConnection(@"connectionstring");
  4. SqlCommand ccmd = new SqlCommand("SELECT img FROM '" + user + "'", conn);
  5. conn.Open();
  6.  
  7. SqlDataAdapter da = new SqlDataAdapter(ccmd);
  8. da.SelectCommand = ccmd;
  9. da.Fill(dt);
  10.  
  11. listView.DataSource = dt;
  12. listView.DataBind();
Advertisement
Add Comment
Please, Sign In to add comment