dbscript.Connection.connectionString C# (CSharp) Method

connectionString() public method

public connectionString ( ) : string
return string
        public string connectionString()
        {
            string connstr = "Data Source=" + serverName
                           + "; User Id=" + username
                           + "; Password=" + password;
            return connstr;
        }

Usage Example

Esempio n. 1
0
        public static string[] getTables(Connection conn, string dbName)
        {
            ArrayList tbls = new ArrayList();

            SqlConnection sqlconn = new SqlConnection(conn.connectionString());
            sqlconn.Open();

            SqlCommand cmd = new SqlCommand(dbName + ".dbo.sp_tables", sqlconn);
            cmd.CommandType = CommandType.StoredProcedure;

            SqlDataReader rdr = cmd.ExecuteReader();
            while (rdr.Read())
            {
                if (
                    Convert.ToString(rdr["TABLE_TYPE"]) == "TABLE" &&
                    Convert.ToString(rdr["TABLE_OWNER"]) != "sys"
                    ) tbls.Add(rdr["TABLE_NAME"]);
            }
            rdr.Close();

            return tbls.ToArray(typeof(string)) as string[];
        }
All Usage Examples Of dbscript.Connection::connectionString