Environment versions
Network:
Windows 2003 Server
Ok, I tried that, that was the first thing i tried but it didnt seem to work..
I just want to fill it even though i'm going to have to add two columns together eventually. THis is what I have:
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);
con1.Close();
this.listBox1.DataSource = searchresults;
this.listBox1.DisplayMember = "userid";
Previous
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