test | nopaste | share your clipboard

test

Edit & repaste | raw paste | Request removal

#region how to work with firebird database
        FbConnectionStringBuilder builder = new FbConnectionStringBuilder();
 
        builder.DataSource = "localhost";
        builder.Database = "C:\Development\READERDATABASE.FDB";
        builder.UserID = "SYSDBA";
        builder.Password = "masterkey";
        builder.Charset = "UTF8";
 
        using (FbConnection connection = new FbConnection(builder.ToString()))
        {
            connection.Open();
 
            using (FbCommand command = connection.CreateCommand())
            {
                #region to build a command
                //OR
                command.CommandText = "SELECT * FROM table WHERE field = ?";
 
                command.Parameters.Add(new FbParameter() { Value = 23});
 
                //OR
                command.CommandText = "PROCEDURENAME";
 
                command.CommandType = System.Data.CommandType.StoredProcedure;
                command.Parameters.Add(new FbParameter() { Value = 23 });
                #endregion
 
                #region To execute a command
                // No return values
                command.ExecuteNonQuery();
 
                // 1 value (or 1st value of 1st row)
                string scalarValue = command.ExecuteScalar().ToString();
 
                // Data reader (table)
                using (FbDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        string strResult = reader[0].ToString();
                        int intResult = Int32.Parse(reader[1].ToString());
                    }
                }
                #endregion
            }
        }
        #endregion

Latest pastes

THREE XXX VIDEOS FULL HD EXCLUSIVE CONTENT

5 days ago

AM4Z1NG S3X VID3OS .. THE BEST

6 days ago

T33N S3X APRIL 19 2024 COLLECTION

6 days ago

2 AM4ZING TTEENN V1DEOS APRIL 17 COLL3CTION

8 days ago

ATM CREDIT CARD Cloned Cards transfers PAYPAL(Telegram +1( 202) 503 9187 ) Cashapp Bank Western Union Zelle Cc cVV Authentic DL and Passport VbV Dumps

9 days ago