title: how to display value in listbox from dataview
body: <p>i have a textbox and listbox in a winform app. when i type a value(i.e,string) in the textbox i want the listbox to show the values from datatable and when i am selecting a particular value from listbox it will display in textbox .</p>
  
  <p>code:</p>
  
  <pre><code>private void txtIName_TextChanged(object sender, EventArgs e)
          {
              string constring = "Data Source=.;Initial Catalog=Test;User Id=sa;Password=admin@123";
              using (SqlConnection con = new SqlConnection(constring))
              {
                  using (SqlCommand cmd = new SqlCommand("SELECT distinct * FROM Item_Details", con))
                  {
                      cmd.CommandType = CommandType.Text;
                      using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
                      {
                          using (dt = new DataTable())
                          {
                              sda.Fill(dt);                            
                              DataView dv = new DataView(dt);
                              dv.RowFilter = string.Format("IName Like '%{0}%'", txtIName.Text);
                              listBox1.Visible = true;
                              listBox1.DataSource = dv;
  
                          }
                      }
                  }
              }
          }
  </code></pre>
  
  <p>but i got the output in listbox like "system.data.datarow". By debugging i can seen that rows which i want, in dataview 'dv'. what i am missing here? thanks. </p>