hsiung.博格 ERP軟體

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; //使用DataTable必須的

using System.Data.SqlClient; //取得SqlClient相關物件必須的

using System.Globalization;

 

public partial class Update : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

    {

    }

protected void Button1_Click(object sender, EventArgs e)

    {

//建立連線物件

ConnectionStringSettings WORKFLOWGP =  ConfigurationManager.ConnectionStrings["WORKFLOWGP"];

        SqlConnection conn = new SqlConnection();

        conn.ConnectionString = WORKFLOWGP.ConnectionString;

        conn.Open();

 

string queryStr = "SELECT  TD001+'-'+RTRIM(TD002)+'-'+TD003,TD015 FROM PURTC INNER JOIN PURTD ON TC001 = 

                          TD001 AND TC002 = TD002 WHERE  TD016 = 'N' AND TC014 = 'Y'";

        SqlDataAdapter oda = new SqlDataAdapter(queryStr, conn);

        DataTable  dt = new DataTable("PURTD");

 

//利用SqlDataAdapter的Fill方法將DB取出的data塞入DataTable中,再利用DataTable取出值

oda.Fill(dt);

 

//從DB Load  Data到Array

object[][] LoadData = new object[dt.Rows.Count][];

for (int i = 0; i < dt.Rows.Count; i++)

        {

            LoadData[i] = new object[dt.Columns.Count];

for (int j = 0; j < dt.Columns.Count; j++)

            {

                LoadData[i][j] = dt.Rows[i][j].ToString();

            }

       }

//最後將收集起來的資料存取在陣列中

//Object[][]  LoadData = listResult.ToArray();