C#

while ((line = file.ReadLine()) != null)
{
    if (line.Substring(0, 2) == "CL")
    {
        try
        {
            string[] strArray = line.Split("=".ToCharArray());
            string key = strArray[0];
            string str = strArray[1];

public static void letsdoit(SqlConnection con)
{
    string[] files;
    string line;
    int counter = 0;

    using (UNCAccessWithCredentials unc = new UNCAccessWithCredentials())
    {
        if (unc.NetUseWithCredentials(@"\\ql1telutil1\c$\inetpub\wwwroot", "xxxxxxxxxx", "xx", "xxxxxx"))
        {
            files = Directory.GetFiles(@"\\ql1telutil1\c$\inetpub\wwwroot\backup96XX");

            foreach (string f in files)
            {
                sqlString = null;
                int myCounter = 0;

                List<Int32> myCountList = new List<Int32>();
                List<Int32> UniqueCallNumber = new List<Int32>();

                System.IO.StreamReader file = new System.IO.StreamReader(f);

                string[] array2 = f.Split("\\".ToCharArray());

                string myStat = array2[7].ToString().Substring(0, 5);

                log.Info("Getting history for extension: " + myStat);

                while ((line = file.ReadLine()) != null)
                {
                    if (line.Substring(0, 2) == "CL")
                    {
                        try
                        {
                            string[] strArray = line.Split("=".ToCharArray());
                            string key = strArray[0];
                            string str = strArray[1];

                            sqlString = sqlString + MinifyB(str.Trim()) + "','";

                            myCounter = myCounter + 1;

                            if(myCounter == 9)
                            {
                                try
                                {
                                    addSQL =
                                        "INSERT INTO tblStationCallHistory(CLSTATION, CLNAME, CLNUMBER, CLTYPE, CLDATE, CLTIME, CLDURATION, CLBRIDGEDFLAG, CLMISSEDCNTR, CLBCALBL) " +
                                        "VALUES('" + myStat + "','" + sqlString.Substring(0,sqlString.Length - 2) + ")";

                                    SqlCommand updateCMD = new SqlCommand(addSQL, con);

                                    try
                                    {
                                        updateCMD.ExecuteNonQuery();
                                    }
                                    catch (Exception ex)
                                    {
                                        log.Error("There was a problem executing the command. " + ex.Message);
                                    }
                                }
                                catch (Exception ex)
                                {
                                    log.Error("There was a problem inserting the coverage path into the table. " + ex.Message);
                                }

                                sqlString = null;
                                myCounter = 0;
                            }
                        }
                        catch (Exception ex)
                        {
                            string myError = ex.Message.ToString();
                        }
                    }
                    counter++;
                }

                file.Close();
            }
        }
    }
}