C# (CSharp) GetCreds示例

示例#1

文件： DBConn.cs 项目： glensault/c-sharp-Database-connections

 //contructor for passing an objects containing the parameters
 public DBConn(GetCreds cr)
 {
     Uname  = cr.Uname;
     Pword  = cr.Pword;
     DBname = cr.DBname;
     Server = cr.Server;
 }

示例#2

文件： Program.cs 项目： glensault/c-sharp-Database-connections

        static void Main(string[] args)
        {
            GetCreds gc = new GetCreds(@"C:\Users\gsaul\source\repos\CnClass\GetCredentials\Credentials.txt");

            Console.WriteLine("Prop1: " + gc.Uname);


            string  SQL = "SELECT AddressLine1 FROM Person.Address";
            DataSet ds  = new DataSet();
            DBConn  db  = new DBConn("AdventureWorks2017", "GLENWIN10");

            ds = db.GetData(0, SQL);

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                Console.WriteLine(row["AddressLine1"]);
            }
        }