Question

查询代码怎么写? textbox :职位 dropdownlist:部门,搜索按钮button1

是三层架构来的，C#语言，还要在datalist控件显示出查询的结果，谢谢各位帮助一下，感激不尽！！！

Answer 1

给你个我们的例子，希望对你有帮助
protected void DropDownListPerson_SelectedIndexChanged(object sender, EventArgs e)
{
switch (DropDownListPerson.SelectedItem.Text)
{
case"刘欢":
ListBoxMusic.Items.Clear();
ListBoxMusic.Items.Add("弯弯的月亮");
ListBoxMusic.Items.Add("这一拜");
ListBoxMusic.Items.Add("千万次的问");
break;
case"腾格尔":
ListBoxMusic.Items.Clear();
ListBoxMusic.Items.Add("天堂");
ListBoxMusic.Items.Add("在那遥远的地方");
break;
case"阎维文":
ListBoxMusic.Items.Clear();
ListBoxMusic.Items.Add("母亲");
ListBoxMusic.Items.Add("小白杨");
ListBoxMusic.Items.Add("一二三四歌");
break;
case"将大为":
ListBoxMusic.Items.Clear();
ListBoxMusic.Items.Add("敢问路在何方");
ListBoxMusic.Items.Add("在那桃花盛开的地方");
break;
case"韩红":
ListBoxMusic.Items.Clear();
ListBoxMusic.Items.Add("穿行");
ListBoxMusic.Items.Add("家乡");
ListBoxMusic.Items.Add("神话");
break;
}
}
protected void ButtonOK_Click(object sender, EventArgs e)
{
string str = "您选择的歌曲是：";
if (ListBoxMusic.SelectedIndex > -1)
{
str += ListBoxMusic.SelectedItem.Text;
}
string scriptString = "alert('"+str+"');";
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "success", scriptString, true);
}

Answer 2

private DataSet GetList()
{
string sqlStr="查询语句";
SqlConnection conn=new SqlConnection ("连接字符串");
SqlCommand cmd =new SqlCommand (sqlStr,conn);
SqlDataAdpter da=new SqlDataAdpter (cmd);
DataSet ds=new DataSet ();
da.Fill(ds);
return ds;
}
........................................................................
DataTable dt=GetList().Tables[0];
datalist1.DataSource=dt;
datalist1.DataValueField = dtpath.Columns["ID"].ColumnName;
datalist1.DataTextField = dtpath.Columns["NAME"].ColumnName;
datalist1.SelectedValue="查询出来的结果的ID的值。。。。"