> úÁÐÁÒÉÌÓÑ ÎÅ ÍÏÇÕ ×ÒÕÂÉÔØÓÑ ËÁË ÏÒÇÁÎÉÚÏ×ÁÔØ ÐÏÄËÌÀÞÅÎÉÅ Ë ÂÁÚÅ ÉÚ
> ÓÒÅÄÙ ÒÁÚÒÁÂÏÔËÉ (ÎÅÏÂÈÏÄÉÍÏ × ÕÞÅÂÎÙÈ ÃÅÌÑÈ) × ÎÁÊÄÅÎÎÏÊ ÄÏËÕÍÅÎÔÁÃÉÉ
> ÜÔÏÔ ×ÏÐÒÏÓ ÎÅ ÏÓ×ÅÝÑÅÔÓÑ.
>
> åÓÌÉ ÍÏÖÎÏ ÔÏ ÓÏ ÓËÒÉÎÁÍÉ É ÐÒÏÞÉÍÉ ÐÏÄÒÏÂÎÏÓÔÑÍÉ.
>
> úÁÒÁÎÉÅ ÓÐÁÓÉÂÏ!
ðÏÄËÌÀÞÅÎÉÅ:
private void Open()
{
string connectionString = "";
connectionString += "User="+Username+";";
connectionString += "Password="+Password+";";
connectionString += "Database="+Database+";";
connectionString += "DataSource=" + DataSource + ";";
connectionString += "Port=" + Port + ";";
connectionString += "Dialect=" + Dialect + ";";
connectionString += "Charset=" + Charset + ";";
connectionString += "Role=" + Role + ";";
connectionString += "Connection lifetime=" + Connection_lifetime + ";";
connectionString += "Connection timeout=" + Connection_timeout + ";";
connectionString += "Pooling=" + Pooling + ";";
connectionString += "Packet Size=" + Packet_Size + ";";
connectionString += "Server Type=" + Server_Type;
connection = new FbConnection(connectionString);
connection.Open();
}
string sql = "Select * from MyProc ('1')";
// óÔÁÒÔÕÅÍ ÔÒÁÎÚÁËÃÉÀ.
FbTransaction transaction = Connection.BeginTransaction();
// óÏÚÄÁÅÍ ÎÏ×ÕÀ ËÏÍÁÎÄÕ
FbCommand command = new FbCommand(sql, Connection, transaction);
// úÁÄÁÅÍ ËÏÍÁÎÄÕ
FbDataAdapter adapter = new FbDataAdapter(command);
// ðÒÉ×ÑÚÙ×ÁÅÍ áÄÁÐÔÅÒ Ë ËÏÍÁÎÄÅ.
FbCommandBuilder sqlcmd = new FbCommandBuilder(adapter);
//óÏÚÄÁÅÍ äÁÔÁóÅÔ, ÐÏÌÕÞÅÎÎÙÊ ÉÚ ×ÙÚÙ×ÁÅÍÏÊ ËÏÍÁÎÄÙ.
dataSet = new DataSet();
//úÁÐÏÌÎÑÅÍ ÎÁÂÏÒ ÄÁÎÎÙÈ.
adapter.Fill(dataSet, cmd);
//óÏÈÒÁÎÉÑÅÍ ôÒÁÎÚÁËÃÉÀ.
transaction.Commit();
