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

[jesuie]

小弟刚学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, "请选择---");
}
}

[syb1045]

private void Bind()
{
var ServerIp = DropDownList_Class.SelectedItem;
var Application = DropDownList_School.SelectedItem;
string queryStr="class='"+DropDownList_Class.SelectedItem.Value+"'";
queryStr+=" and School='"+DropDownList_School.SelectedItem.Value+"'";
//这里不会写
GridView1.DataSource=GetDataTable(queryStr);
GridView1.DataBind();
}

================
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[tempDomain]";
SqlParameter sp = new SqlParameter("@queryStr",queryStr);
cmd.Parameters.Add(sp);
//这里应该写存储过程参数吧，不清楚（传递参数）
cmd

[子夜__]

protected void Page_Load(object sender, EventArgs e)
        {

            string sql = "select * from table where xx='" + DropDownList1.SelectedValue + "'";
        }
        public static DataTable ReturnDataTable(string cmdtext)
        {
            SqlConnection cn = new SqlConnection();
            cn.ConnectionString = "数据库连接字符串";
            DataTable dt = new DataTable();
            SqlCommand cmd = new SqlCommand();
            cmd = new SqlCommand(cmdtext, cn);
            cmd.CommandType = CommandType.Text; ;
            SqlDataReader dr = null;
            using (dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
            {
                dt.Load(dr);
            }
            return dt;
        }

先学学基础 写这些就快了。

[kkbac]

顶,
紧跟随子夜的脚步.

[jesuie]

[Quote=引用 2 楼 wxr0323 的回复:]
C# code

protected void Page_Load(object sender, EventArgs e)
{

string sql = "select * from table where xx='" + DropDownList1.SelectedValue + "'";
}
public ……
[/Quote]

我上面哪里写的不对，那个存储过程不知道怎么进行过滤筛选

[jesuie]

[Quote=引用 1 楼 syb1045 的回复:]
private void Bind()
{
var ServerIp = DropDownList_Class.SelectedItem;
var Application = DropDownList_School.SelectedItem;
string queryStr="class='"+DropDownList_Class.SelectedItem.Value+"'……
[/Quote]
请教存储过程里面怎么写， 那几个变量怎么定义，怎么加条件

[jesuie]

知道怎么写啦
知道怎么调用存储过程了，虽然代码有点繁琐，
经过好些天折腾，总算完成了