WYTC-C#-SQL-command物件

 command物件
executeReader()方法　將結果傳給datareader物件　用於查訊結果
executeNonquery()方法　傳回異動筆數　用於insert update delete

語法范例:
string selectCmd = "select * from tab";
SqlCommand cmd = new SqlCommand(selectCmd,conn);
SqlDataReader dr = cmd.ExecuteReader();
//或者 int i = cmd.ExecuteNonQuery(); //i = 異動資料筆數

SqlCommand　常用方法
CommandText 取得資料來源
CommandTimeOut 超時時間
CommandType CommandText屬性的解讀方式
Connection 取得使用的sqlconnection連接物件
parpameters 取得sqlparametercollection

sqlcommand　常用方法
cancel() 取消sqlcommand的執行
dispose() 釋放sqlcommand所占用的資源
executeNoeQuery()
ExecuteReader()

//code ex:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient; //新增命名空間

namespace SqlCommand_ex
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        //變更密碼
        private void btn_OK_Click(object sender, EventArgs e)
        {
            try
            {

                string ConnString;
                ConnString = "Data Source =127.0.0.1;Initial catalog = authority;" +
                                 "User id = sa;Password = 123";
                SqlConnection conn = new SqlConnection(ConnString);
                conn.Open();

 

                string UpdateCmd = "Update Login Set Password='" + txt_NewPwd.Text +
                        "' WHERE UserID = '" + txt_UserID.Text + "' And Password ='" +
                        txt_Password.Text + "' And IsValid =1";

                SqlCommand cmd = new SqlCommand(UpdateCmd, conn);
                int i = cmd.ExecuteNonQuery();

                if (i == 1)
                {
                    MessageBox.Show("恭喜您，密碼變更成功!", "密碼變更");
                }
                else
                {
                    MessageBox.Show("對不起，密碼變更失敗!", "密碼變更");
                }

                conn.Close();
                cmd.Dispose();

            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }
        //關閉表單
        private void btn_Close_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}