Environment versions
Network:
Windows 2003 Server
Trying to fill a listBox on a windows form, I've tried different approaches but have been unsuccessful. I've posted my code below, I'm just not getting any return result, in the listbox.
string search_item = textBox1.Text.Trim();
SqlConnection con1 =new SqlConnection(connection);
SqlCommand cmd1 = new SqlCommand("sp_PMsearch_item", con1);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.Add(new SqlParameter("@search_item", SqlDbType.VarChar));
cmd1.Parameters["@search_item"].Value = search_item;
SqlDataAdapter searchs = new SqlDataAdapter(cmd1);
DataTable dtsearch = new DataTable();
searchs.Fill(dtsearch);
con1.Open();
DataView searchresults = new DataView(dtsearch);
foreach (DataRowView drv in searchresults)
{
this.listBox1.Items.Add(drv["item"].ToString());
}
con1.Close();
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only