quotationpage.aspx.cs

来自「为了便于企业对客户按照地区进行统计查询分析」· CS 代码 · 共 34 行

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.Data.SqlClient;
using System.Data;

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

    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        DataTable dt;
        SqlConnection sqlcnn = new SqlConnection("server=.;user=sa;pwd=sa;database=pubs");
        string sql = "SELECT dbo.bb.Address, dbo.aa.Name, dbo.aa.sex FROM dbo.aa INNER JOIN dbo.bb ON dbo.aa.ID = dbo.bb.ID";
        SqlDataAdapter adp = new SqlDataAdapter(sql,sqlcnn);
        dt = new DataTable();
        adp.Fill(dt);
        this.GridView1.DataSource = dt;
        this.GridView1.DataBind();
        //this.DataList1.DataSource = dt;
        //this.DataList1.DataKeyField = "Address";
        //this.DataList1.DataBind();
    }
}