Question

急急！！一个DropDownList,一个TextBox,一个Button怎么实现商品的查询。《完整代码》

用c#

Answer 1

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using System.Web.Configuration;
using System.Data.SqlClient;

public partial class Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
string conString = 你的数据库连接路径;
string sql = “select * from 数据库名称 where " + ropdownlist.electitem.Text + "='” +TextBox1.Text + "'";
SqlConnection con = new SqlConnection(conString);
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
con.Close();
}
}

Answer 2

select * from datebase where tablename1=‘“+this.dropdownlist.selectitem.text+”’ and tablename2='"+this.textbox.text+"'
手打的 到环境里再打一下