FOR WEB

FOR WEB

using System.Collections;

ArrayList ArrSql1 = new ArrayList();

ArrSql1.Add("COMMAND");


        private bool DBWriter(ArrayList SQL)
        {
            try
            {
                SqlCommand DBCommand = new SqlCommand();
                SqlTransaction DBTransaction;
                SqlConnection DBConnection = new SqlConnection();
                DBConnection.ConnectionString = ConfigurationManager.ConnectionStrings["INFOBCKConnectionString"].ConnectionString.Trim();
                DBConnection.Open();
                DBCommand = DBConnection.CreateCommand();
                DBTransaction = DBConnection.BeginTransaction("SQLTransaction");
                DBCommand.Connection = DBConnection;
                DBCommand.Transaction = DBTransaction;
                try
                {
                    for (Int32 i = 0; i < SQL.Count; i++)
                    {
                        DBCommand.CommandText = SQL[i].ToString();
                        DBCommand.ExecuteNonQuery();
                    }
                    DBTransaction.Commit();
                    return true;
                }
                catch (Exception ex)
                {
                    DBTransaction.Rollback();
                    ex.ToString();
                    return false;
                }
            }
            catch (Exception ex)
            {
                ex.ToString();
                return false;
            }
        }

處理中英文夾雜時，要寫入oracle卻發生長度過常的處理方式

直接使用

System.Text.Encoding.GetEncoding("big5").GetByteCount("中文字串ABC")

抓取長度，上例是 11