C#

private Country _country = new Country();

krinaljariwala wrote:

Please help me its urgent.

[DllImport("TheCplusplus.dll")]
static extern uint BTSeparateItems([In, MarshalAs(UnmanagedType.BStr)] string filePath, out object obj);

using System;
using System.Configuration;
using System.Data;

namespace Common.Data {

    public static class DbAssist {

        private static void CheckConnectionClosed(IDbConnection connection) {
            if (connection.State != ConnectionState.Closed) {
                throw new InvalidOperationException("An error has occurred: connection is not in closed state.");
            }
        }

        // Connection help

        public static string GetConnectionString(string key) {
            try {
                return ConfigurationManager.ConnectionStrings[key].ConnectionString;
            } catch (NullReferenceException ex) {
                throw new ConfigurationErrorsException("An error has occurred: "
                    + key + " does not exist in config.", ex);
            }
        }

        // Scalar help

        public static object ExecScalar(string sqlText, IDbConnection connection) {
            return ExecScalar(sqlText, connection, CommandType.Text);
        }

        public static object ExecScalar(string sqlText, IDbConnection connection, CommandType cmdType) {
            return ExecScalar(sqlText, connection, cmdType, null);
        }

        public static object ExecScalar(string sqlText, IDbConnection connection,
                CommandType cmdType, IDataParameter[] parameters) {
            CheckConnectionClosed(connection);
            using (connection) {
                connection.Open();
                IDbCommand command = connection.CreateCommand();
                command.CommandText = sqlText;
                command.CommandType = CommandType.StoredProcedure;
                if (parameters != null) {
                    foreach (IDataParameter p in parameters) {
                        command.Parameters.Add(p);
                    }
                }
                return command.ExecuteScalar();
            }
        }

        // IDataReader help

        public static IDataReader ExecReader(string sqlText, IDbConnection connection) {
            return ExecReader(sqlText, connection, CommandBehavior.CloseConnection);
        }

        public static IDataReader ExecReader(string sqlText, IDbConnection connection,
            CommandBehavior behavior) {
            return ExecReader(sqlText, connection, CommandType.Text, behavior);
        }

        public static IDataReader ExecReader(string sqlText, IDbConnection connection,
                CommandType cmdType, CommandBehavior behavior) {
            CheckConnectionClosed(connection);
            connection.Open();
            IDbCommand command = connection.CreateCommand();
            command.CommandText = sqlText;
            command.CommandType = cmdType;
            return command.ExecuteReader(behavior);
        }

        public static IDataReader ExecReader(string sqlText, IDbConnection connection,
                CommandType cmdType, IDataParameter[] parameters, CommandBehavior behavior) {
            CheckConnectionClosed(connection);
            IDbCommand command = connection.CreateCommand();
            command.CommandText = sqlText;
            command.CommandType = cmdType;
            if (parameters != null) {
                foreach (IDataParameter p in parameters) {
                    command.Parameters.Add(p);
                }
            }
            return command.ExecuteReader(behavior);
        }

        public static T GetDataFromReader<T>(IDataReader reader, string fieldName, T fallbackValue) {
            int ordinal = reader.GetOrdinal(fieldName);
            if (!reader.IsDBNull(ordinal)) {
                return (T)reader.GetValue(ordinal);
            }
            return fallbackValue;
        }
    }
}