C# MSSQL

建立連線

string strConn= "server=localhost;database=資料庫;uid=帳號;pwd=密碼;MultipleActiveResultSets=true";
 SqlConnection conn = new SqlConnection(strConn);
 conn.Open();

建立命令物件

string strCmd="select * from table"
SqlCommand cmd = new SqlCommand(strCmd, conn);
cmd.Parameters.AddWithValue("@value1", area);
cmd.Parameters.AddWithValue("@value2", dateStart);
cmd.Parameters.AddWithValue("@value3", dateEnd);

執行命令