Eleven

        protected void Page_Load(object sender, EventArgs e)
        {
            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();
            }


        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            //第一：連結SQL資料庫
            SqlConnection dataConnection = new SqlConnection();
            dataConnection.ConnectionString = "Data Source=ELEVEN-PC;Initial Catalog=MyDB;Integrated Security=True";
            dataConnection.Open();
            //第二：執行SQL指令  //  新增
            String sqlstr = "";
            sqlstr = "INSERT TestTable ( Name, Id, Pw , Data  ) VALUES ( @Name, @Id, @Pw,@Data)";
            SqlCommand cmd = new SqlCommand(sqlstr, dataConnection);
            cmd.Parameters.AddWithValue("@Name", TextBox1.Text);
            cmd.Parameters.AddWithValue("@Id", TextBox2.Text);
            cmd.Parameters.AddWithValue("@Pw", TextBox3.Text);
            cmd.Parameters.AddWithValue("@Data", TextBox4.Text);

            cmd.ExecuteNonQuery();
            cmd.Cancel();
            dataConnection.Close();
        }

        protected void Button2_Click(object sender, EventArgs e)
        {
            //第一：連結SQL資料庫
            SqlConnection dataConnection = new SqlConnection();
            dataConnection.ConnectionString = "Data Source=ELEVEN-PC;Initial Catalog=MyDB;Integrated Security=True";
            dataConnection.Open();
            //第二：執行SQL指令   // 修改
            String sqlstr = "";
            sqlstr = "UPDATE TestTable SET Pw= @Pw , Name =@Name , Data=@Data WHERE Id=@Id ";
            SqlCommand cmd = new SqlCommand(sqlstr, dataConnection);
            cmd.Parameters.AddWithValue("@Name", TextBox1.Text);
            cmd.Parameters.AddWithValue("@Id", TextBox2.Text);
            cmd.Parameters.AddWithValue("@Pw", TextBox3.Text);
            cmd.Parameters.AddWithValue("@Data", TextBox4.Text);
            cmd.ExecuteNonQuery();
            //第三：關閉連線
            cmd.Cancel();
            dataConnection.Close();

        }

        protected void Button3_Click(object sender, EventArgs e)
        {
            //第一：連結SQL資料庫
            SqlConnection dataConnection = new SqlConnection();
            dataConnection.ConnectionString = "Data Source=ELEVEN-PC;Initial Catalog=MyDB;Integrated Security=True";
            dataConnection.Open();
            //第二：執行SQL指令   //刪除
            String sqlstr = "";
            sqlstr = "DELETE FROM TestTable WHERE Id = @Id ";
            SqlCommand cmd = new SqlCommand(sqlstr, dataConnection);
            cmd.Parameters.AddWithValue("@Name", TextBox1.Text);
            cmd.Parameters.AddWithValue("@Id", TextBox2.Text);
            cmd.Parameters.AddWithValue("@Pw", TextBox3.Text);
            cmd.Parameters.AddWithValue("@Data", TextBox4.Text);
            cmd.ExecuteNonQuery();
            //第三：關閉連線
            cmd.Cancel();
            dataConnection.Close();
        }

        protected void Button4_Click(object sender, EventArgs e)
        {
            //第一：連結SQL資料庫
            SqlConnection dataConnection = new SqlConnection();
            dataConnection.ConnectionString = "Data Source=ELEVEN-PC;Initial Catalog=MyDB;Integrated Security=True";
            dataConnection.Open();
            //第二：執行SQL指令   //查詢
            var sqlstr = "SELECT * FROM TestTable WHERE Id = 'Dozzznma'";
            var  cmd = new SqlCommand(sqlstr, dataConnection);           
            var reader = cmd.ExecuteReader();
            Response.Write(reader.HasRows+"");                      
            //return;
            //第三：關閉連線
            cmd.Cancel();
            cmd.Connection.Close();
         
        }