如何从下拉列表过滤并选择数据到gridviwe? [英] How to filter from dropdownlist and select data to gridviwe ?

问题描述

我在数据库中有3个下拉列表和3个表


我需要在下拉菜单中选择值时，它仅与与选择值相关的行一起出现，但在gridview中呢????

I have 3 dropdownlist and 3 tables in database


I need whene I select values in dropdown it comes only with the row which related to select value and but it in gridview????

推荐答案

使用下拉菜单'' s SelectedIndexChanged事件，用于将感兴趣的表加载到DataTable中，然后将其绑定到DataGrid.

:)

use the dropdown''s SelectedIndexChanged event to load the table of interest in a DataTable, then bind that to your DataGrid.

:)

受保护的void ddlUsers_SelectedIndexChanged(object sender，EventArgs e)
{
字符串strQuery;
字符串userName = ddlUsers.SelectedItem.Text;
if(userName =="All")
strQuery ="SELECT .....";
其他
strQuery ="SELECT ..... Where SCEUD.UserId =""+ userName +"'';
数据集dsHistory = ExecStatements(strQuery);
//这里我正在使用列表框...我们的代码在这里
lstHistory.DataSource = dsHistory;
lstHistory.DataTextField ="URL";
lstHistory.DataBind();
}

受保护的DataSet ExecStatements(字符串sqlCmd)
{
SqlConnection sqlConn =新的SqlConnection(strConnection);
SqlCommand sqlComm =新的SqlCommand(sqlCmd，sqlConn);
SqlDataAdapter sqa =新的SqlDataAdapter(sqlComm);
DataSet ds = new DataSet();
sqlConn.Open();
sqa.Fill(ds);
sqlConn.Close();
返回ds;
}

protected void ddlUsers_SelectedIndexChanged(object sender, EventArgs e)
{
string strQuery;
string userName = ddlUsers.SelectedItem.Text;
if(userName=="All")
strQuery = "SELECT .....";
else
strQuery = "SELECT .....Where SCEUD.UserId=''" + userName + "''";
DataSet dsHistory = ExecStatements(strQuery);
//here I am using the list box ... ur code goes here
lstHistory.DataSource = dsHistory;
lstHistory.DataTextField = "url";
lstHistory.DataBind();
}

protected DataSet ExecStatements(string sqlCmd)
{
SqlConnection sqlConn = new SqlConnection(strConnection);
SqlCommand sqlComm = new SqlCommand(sqlCmd, sqlConn);
SqlDataAdapter sqa = new SqlDataAdapter(sqlComm);
DataSet ds = new DataSet();
sqlConn.Open();
sqa.Fill(ds);
sqlConn.Close();
return ds;
}

这篇关于如何从下拉列表过滤并选择数据到gridviwe?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！