string sql = "";
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sql, cn);
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
ddl.DataSource = ds;
ddl.DataTextField = "Name";
ddl.DataValueField = "id";
ddl.DataBind();
}
protected void ibtnSearch_Click(object sender, ImageClickEventArgs e)
{
string searchTXt=ddlComments.SelectedValue.ToString();
string sql = "";
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sql, cn);
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
Gridview.DataSource = ds;
Gridview.DataBind();
}
}