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

teen videos collection december

1 hours ago

6GB BOCIL UPFILES PACK

11 hours ago

BOCIL PACK 6GB FREE

1 days ago

2 pack and loli

2 days ago

Free cp no ada

2 days ago