做一个简单的ASP界面可以进行查询，筛选

小弟刚学ASP，做一个简单的ASP界面具有查询，筛选功能。
用了两个Dropdownlist 控件（做过滤条件），一个button触发事件，一个GridView显示数据表。


数据是通过存储过程实现的，其中的参数还不会写，不会参数传递，dropdownlist控件绑定数据源做完了。
目前想写一个方法，把控件的值取出来，去存储过程查找。
页面第一次加载显示所有数据，求教存储过程的代码。

不知道说的清楚不清楚，达到目的就行能进行筛选查询。
我是新手，尽量给源码，谢谢大家。


protected void Page_Load(object sender, EventArgs e)
{
Bind();
ReturnDataFromDropDownListOfClass();
ReturnDataFromDropDownListOfSchool();
}
//控件初始化方法
private void Bind()
{
var ServerIp = DropDownList_Class.SelectedItem;
var Application = DropDownList_School.SelectedItem;

//这里不会写

GridView1.DataBind();
}

protected void Button_search_Click(object sender, EventArgs e)
{

// 想在这个事件里直接调用Bind()方法，再绑定gridview


}

//连接数据库
private DataTable GetDataTable(string queryStr)
{
string connectionString = "Data Source=(local)\\SQLEXPRESS;Initial Catalog=DomainManager;Integrated Security=SSPI;";
using (SqlConnection conn = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand(queryStr, conn))
{
DataSet ds = new DataSet();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[tempDomain]";
//这里应该写存储过程参数吧，不清楚（传递参数）

SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
return ds.Tables[0];
}
}
}

//ServerIP控件的数据绑定方法
public void ReturnDataFromDropDownListOfClass()
{
string querystring = "select * from Class;";
string connectString = "Data Source=(local)\\SQLEXPRESS;Initial Catalog=DomainManager;Integrated Security=SSPI;";
DataSet result = new DataSet();

using (SqlConnection connection = new SqlConnection(connectString))
{
SqlDataAdapter ad = new SqlDataAdapter();
ad.SelectCommand = new SqlCommand(querystring, connection);
ad.Fill(result, "Table_Class");
DataTable dataTable_ServerIP = result.Tables["Table_Class"];

DropDownList_Class.DataSource = dataTable_Class.DefaultView;
DropDownList_Class.DataTextField = "Name";
DropDownList_Class.DataValueField = "Id";
DropDownList_Class.DataBind();
DropDownList_Class.Items.Insert(0, "请选择---");
}
}
//School控件的数据绑定方法
public void ReturnDataFromDropDownListOfSchool()
{
string querystring = "select * from School;";
string connectString = "Data Source=(local)\\SQLEXPRESS;Initial Catalog=DomainManager;Integrated Security=SSPI;";
DataSet result = new DataSet();

using (SqlConnection connection = new SqlConnection(connectString))
{
SqlDataAdapter ad = new SqlDataAdapter();
ad.SelectCommand = new SqlCommand(querystring, connection);
ad.Fill(result, "Table_School");
DataTable dataTable_Application = result.Tables["Table_School"];

DropDownList_ASchool.DataTextField = "Name";
DropDownList_School.DataValueField = "Id";
DropDownList_School.DataSource = dataTable_School.DefaultView;
DropDownList_School.DataBind();
DropDownList_ASchool.Items.Insert(0, "请选择---");
}
}