how use drop down list as as search text

Hi,

Design the gridview control.

AllowPaging="True" AllowSorting="true" DataSourceID="dsGridview" Width="540px"

PageSize="10">

SortExpression="Department" ItemStyle-Width="130px" />

SortExpression="Location" ItemStyle-Width="130px" />

Place the drop down list as well.

Bind the all country names into the drop down list control.

Fill the drop down

string _ConnectionString = "Data Source=SSD438\SQLEXPRESS;Initial Catalog=Master;Integrated Security=true;";

SqlConnection sqlConnection = new SqlConnection();

sqlConnection.ConnectionString = _ConnectionString;

sqlConnection.Open();

string sqlQuery = "SELECT * FROM Country";

SqlCommand sqlCommand = new SqlCommand(sqlQuery, sqlConnection);

sqlCommand.CommandType = CommandType.Text;

SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);

DataSet dataSet = new DataSet();

sqlDataAdapter.Fill(dataSet);

ddlCountry.DataSource = dataSet.Tables[0];

ddlCountry.DataTextField = "CountryName";

ddlCountry.DataValueField = CountryID";

ddlCountry.DataBind();

protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e)

{

SqlConnection sqlConnection = new SqlConnection();

sqlConnection.ConnectionString = _ConnectionString;

sqlConnection.Open();

string sqlQuery = "SELECT * FROM Employees WHERE name LIKE "+ddlCountry.SelectedItem.Value.ToString();

SqlCommand sqlCommand = new SqlCommand(sqlQuery, sqlConnection);

sqlCommand.CommandType = CommandType.Text;

SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);

DataSet dataSet = new DataSet();

sqlDataAdapter.Fill(dataSet);

GridView1.DataSource = dataSet.Tables[0];

gridView1.DataBind();

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Senthilkumar14y ago
Hi,

Design the gridview control.

AllowPaging="True" AllowSorting="true" DataSourceID="dsGridview" Width="540px"
PageSize="10">

SortExpression="Department" ItemStyle-Width="130px" />

SortExpression="Location" ItemStyle-Width="130px" />

Place the drop down list as well.

Bind the all country names into the drop down list control.

Fill the drop down
string _ConnectionString = "Data Source=SSD438\SQLEXPRESS;Initial Catalog=Master;Integrated Security=true;";
SqlConnection sqlConnection = new SqlConnection();
sqlConnection.ConnectionString = _ConnectionString;
sqlConnection.Open();
string sqlQuery = "SELECT * FROM Country";
SqlCommand sqlCommand = new SqlCommand(sqlQuery, sqlConnection);
sqlCommand.CommandType = CommandType.Text;
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
DataSet dataSet = new DataSet();
sqlDataAdapter.Fill(dataSet);
ddlCountry.DataSource = dataSet.Tables[0];
ddlCountry.DataTextField = "CountryName";
ddlCountry.DataValueField = CountryID";
ddlCountry.DataBind();

protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection sqlConnection = new SqlConnection();
sqlConnection.ConnectionString = _ConnectionString;
sqlConnection.Open();
string sqlQuery = "SELECT * FROM Employees WHERE name LIKE "+ddlCountry.SelectedItem.Value.ToString();
SqlCommand sqlCommand = new SqlCommand(sqlQuery, sqlConnection);
sqlCommand.CommandType = CommandType.Text;
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
DataSet dataSet = new DataSet();
sqlDataAdapter.Fill(dataSet);
GridView1.DataSource = dataSet.Tables[0];
gridView1.DataBind();
}
0