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"];
            }

public Form()
        {
            InitializeComponent();
            TextBox[] tbs = new TextBox[] { monTxtBox, tuesTxtBox, wedTxtBox, thurTxtBox, frdtxtBox };
            foreach (var c in tbs)
            c.TextChanged += new EventHandler(textBoxes_TextChanged); //create a common event for all textBoxes
        }
        
        private void textBoxes_TextChanged(object sender, EventArgs e)
        {
            TextBox tb = sender as TextBox;
            if(tb != null)
            {
                decimal temp =0;
                if(decimal.TryParse(tb.Text,out temp))
                {
                    if(temp < 1)
               //     totalTimetxtBox.Text = Convert.ToDecimal(tb.Text.Replace(",",".").ToString())+temp;
                     totalTimetxtBox.Text = tb.Text+temp;
            else
                MessageBox.Show("Please enter the number between 0 and 1.");
                }
        else
            MessageBox.Show("Please enter a decimal value only!");
            }
        }