Hi,
I am trying to filter a datalist through a textbox, so if I type anything in the textbox, the datalist should get filtered with the terms in the textbox.
This is the code that populates the datalist:
{
string conString = ConfigurationManager.ConnectionStrings["MNE"].ConnectionString;
SqlCommand cmd = new SqlCommand("spMyQuery");
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DateAdded", ddlDate.SelectedValue);
using (SqlConnection con = new SqlConnection(conString))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataSet ds = new DataSet())
{
sda.Fill(ds);
dlFiles.DataSource = ds;
...
Go to the complete details ...