change sql statement block in a stored procedure (in 1 execute)

See more:

C#

WinForms

My friends, I have a method like this.

axCZKEM1.ReadAllUserID(iMachineNumber);

while (axCZKEM1.SSR_GetAllUserInfo(iMachineNumber, out sdwEnrollNumber, out sName, out sPassword, out iPrivilege, out bEnabled)) {

    Dt = new DataTable();

    StrSQL = "select * from [MsEmployee] " + System.Environment.NewLine +

             "where [EmployeeID] = " + sdwEnrollNumber + "";    

    if (clglobal.DBType == "SQL Server") {

        cldbSQL.sqlSelectReturnDt(StrSQL, Dt);

    }



    if (Dt.Rows.Count > 0) {

        if (Convert.ToString(Dt.Rows[0]["EmployeeName"]) != sName) {

            StrSQLUser += "update [MsEmployee] set " + System.Environment.NewLine +

                          "[EmployeeName]='" + sName + "'" + System.Environment.NewLine +

                          "[EditBy]='" + MasterForm.UserName + "', " + System.Environment.NewLine +

                          "[EditDate]=GetDate() " + System.Environment.NewLine +

                          "where [EmployeeID]=" + sdwEnrollNumber + "";

        }

    } else {

        StrSQLUser += "insert into [MsEmployee]([EmployeeID], [EmployeeName], [CreateBy], [CreateDate]) " + System.Environment.NewLine +

                      "values(" + sdwEnrollNumber + ", '" + sName + "', '" + MasterForm.UserName + "', GetDate()) " + System.Environment.NewLine;

    }

}



if (StrSQLUser != "") {

       if (cldbSQL.SqlExecuteQuery(StrSQLUser) == 1) {

           clglobal.ShowMessage("Success synchronize user.");

       } else {

           clglobal.ShowMessage("Fail synchronize user!");

       }

} else {

    clglobal.ShowMessage("Already the most recent data.");

}

} else {

clglobal.ShowMessage("Please connect the device first!");

return; 

}

I want to change the method above, using storeprocedure, where I want to execute many query that is generated in one time execution, if there is one query fails, then everything must be thwarted. I've been searching for answers on google was not to my liking it.