C#

SELECT Count(*)
FROM Engineer
WHERE  [User Name]= [@UserName] AND [Password] = [@Password] ;

SELECT Count(*)
FROM Writer
WHERE  [User Name]= [@UserName] AND [Password] = [@Password] ;

public int StaffExists(string myPath, string UserName, string Password)
   {
       OleDbConnection OleConn = null;

       OleDbCommand oCommand = null;

       OleDbParameter param = null;

       OleConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + myPath + "");

       OleConn.Open();

                       //Passing in Proc1 Stored Proc
       oCommand = new OleDbCommand("Proc1", OleConn);

       oCommand.CommandType = CommandType.StoredProcedure;

       param = new OleDbParameter("@UserName", UserName);

       oCommand.Parameters.Add(param);

       param = new OleDbParameter("@Password", Password);

       oCommand.Parameters.Add(param);

       //First check in Engineer table
       oCommand.CommandText = "Proc1";

       int Count = (int)oCommand.ExecuteScalar();

       OleConn.Close();
       oCommand.Dispose();

       int UserCount = Count;
       int UserCount2 = 0;

       if (UserCount > 0)
       {  //User exists in Engineer table

           return UserCount;
       }
       else
       {
           if (UserCount == 0)
           { //User name not in Engineer table, check in Writer table

               OleConn.Open();
                                 // Pass in Proc2 Stored Proc
               oCommand = new OleDbCommand("Proc2", OleConn);

               oCommand.CommandType = CommandType.StoredProcedure;

               param = new OleDbParameter("@UserName", UserName);

               oCommand.Parameters.Add(param);

               param = new OleDbParameter("@Password", Password);

               oCommand.Parameters.Add(param);

               oCommand.CommandText = "Proc2";

               UserCount = (int)oCommand.ExecuteScalar();

               OleConn.Close();
               oCommand.Dispose();

               UserCount2 = UserCount;

               if (UserCount2 > 0)
               {//User exists in Writer table
               }
               else
               {
               }
           }

           return UserCount2;
       }
   }

public class quote
   { ... 
        
        public string[] data;
        public string[] date;
        public string[] release;
        public string[] baseID;
     ...

        DataTable t2 = new DataTable();
        //fill the datatable
     ...
        //code that doesn't work
        for (int i = 0; i < t2.rows.count + 1; i++)
            {
                DataRow r2 = t2.Rows[i];
                
                
                this.baseID[i] = (string)r2["BASE_ID"];
                this.data[i] = (string)r2["Data"];
                this.date[i] = Convert.ToString(r2["Date"]);
                this.release[i] = (string)r2["Release"];
            }