search.aspx.cs

这是asp.net^和Visual C++Sharp编写的串并口通讯的书籍 源代码

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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.Data.SqlClient;
public partial class search : System.Web.UI.Page
{
    SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ccc"]);
    protected void Page_Load(object sender, EventArgs e)
    {
        string newque;
        int stype = Convert.ToInt32(Request.QueryString["stype"]);
        string key = Request.QueryString["key"].ToString();
        if (key == "")
        {
            newque = "select * from tb_goods where typeid='" + stype + "' order by id desc";
        }
        else
        {
            newque = "select * from tb_goods where typeid='" + stype + "' and goodsname like '%" + key + "%'";
        }
        DataList1.DataSource = DataBase.ReDataSet(newque);
        DataList1.DataKeyField = "id";
        DataList1.DataBind();
    }
}