Versions des environnements
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();
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement