Eleven

過去用字串連接  SQL讀檔   需要長長的一段

            if (!IsPostBack)
            {
                ConnectionString 取得或設定用來開啟 SQL Server 資料庫的字串。
                SqlConnection dataConnection = new SqlConnection();
                dataConnection.ConnectionString = "Data Source=ELEVEN-PC;Initial Catalog=MyDB;Integrated Security=True";
                dataConnection.Open();
                ---------------------------------------------------------------------------------------------------
                SqlDataAdapter sqlAdapter = new SqlDataAdapter("select * from TestTable", dataConnection);
                //////////////////////////////////////////////////////////////////////////////////////////////////////
                DataSet dt = new DataSet();
                dt.DataSetName = "Name";
                ////////////////////////////////////////////////////////////////////////////
                sqlAdapter.Fill(dt, "TestTable");
                --------------------------------------------------------------------------------------------------
                第二：執行SQL指令 讀
                string sqlstr = "select * from TestTable";
                SqlCommand cmd = new SqlCommand(sqlstr, dataConnection);
                SqlDataReader dr = cmd.ExecuteReader();

                while (dr.Read())
                {
                    TextBox1.Text = dr["Name"].ToString();
                    TextBox2.Text = dr["Id"].ToString();
                    TextBox3.Text = dr["Pw"].ToString();
                    TextBox4.Text = dr["Data"].ToString();
                }

                 Call Close when done reading.
                dr.Close();
            }

若改成     linq to sql  的方法   是不是簡化了許多!~!!!

 

            if (!IsPostBack)
            {

                TestTable tb = new TestTable();
                MainDataClassDataContext main = new MainDataClassDataContext();
                // linq to sql 讀的方法
                foreach (var aaa in main.TestTable)
                {
                    TextBox1.Text = aaa.Name;
                    TextBox2.Text = aaa.Id;
                    TextBox3.Text = aaa.Pw;
                    TextBox4.Text = aaa.Data;
                }
            }