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 ascii = Encoding.ASCII.GetString(list.ToArray());
//ایجاد بانک اطلاعاتی خالی
var dir = @"D:\Prog\"; // این مسیر پوشه است و نه مسیر فایل
using (OleDbConnection connection = new OleDbConnection(@"Provider=VFPOLEDB.1;Data Source=" + dir))
{
using (var command = new OleDbCommand())
{
command.Connection = connection;
command.Connection.Open();
command.CommandText = "Create Table myDBF (dsw_id1 int, dsw_fname v(250), dsw_lname v(250) )";
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
}
} //ثبت اطلاعات در بانک ایجاد شده
var dbPath = Path.Combine(dir, "myDBF.dbf");
using (OleDbConnection connection = new OleDbConnection(@"Provider=VFPOLEDB.1;Data Source=" + dbPath))
{
using (var command = new OleDbCommand())
{
command.Connection = connection;
command.Connection.Open();
command.CommandText = "Insert Into myDBF Values (1, ?, ?)";
command.Parameters.AddWithValue("?", "B"); // فقط علامت سؤال در اینجا کار میکند و نه هیچ چیز دیگری
command.Parameters.AddWithValue("?", "A");
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
}
} 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();
}