Set @Result = replace(@Result, char(145)+char(243), char(242))
Set @Result = replace(@Result, char(243)+char(145), char(242)) Set @Result = replace(@Result, char(242)+char(243), char(242)+char(145)+char(243))
List<byte> IS_Result = new List<byte>();
//for (int i = 0; i < limit; i++)
for (int i = limit - 1; i >= 0; i--)
{
if (is_Lattin_Letter(b22[i]))
{
cur = get_Lattin_Letter(b22[i]);
IS_Result.Add(cur);
pre = cur;
}
else if (i != 0 && i != b22.Length - 1)
{
cur = get_Unicode_To_IranSystem_Char(b22[i - 1], b22[i], b22[i + 1]);
if (cur == 145) // برای بررسی استثنای لا
{
if (pre == 243)
{
IS_Result.RemoveAt(IS_Result.Count - 1);
IS_Result.Add(242);
}
else
{
IS_Result.Add(cur);
}
}
else
{
IS_Result.Add(cur);
}
pre = cur;
}
} string dbfDirectory = Server.MapPath("~/Content/") + "myDBF.dbf";
string connectionString = "Provider=VFPOLEDB.1;Data Source=" + dbfDirectory + ";Password=;Collating Sequence=MACHINE";
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
connection.Open();
string CreateTableK = "Create Table myDBF (dsw_id1 int, dsw_fname v(250), dsw_lname v(250) )";
OleDbCommand cmdCreateTable = new OleDbCommand(CreateTableK, connection);
cmdCreateTable.ExecuteNonQuery();
OleDbCommand cmd2 = new OleDbCommand("Insert Into myDBF Values (1, @param1, @param2)", connection);
cmd2.Parameters.AddWithValue("@param1", "شهرزاد");
cmd2.Parameters.AddWithValue("@param2", "جواهری");
OleDbCommand cmd3 = new OleDbCommand("Insert Into myDBF Values (2, 'ma', 'bi')", connection);
cmd2.ExecuteNonQuery();
cmd3.ExecuteNonQuery();
connection.Close();
}