i trying connect mysql database c# using default credentials. able connect following code. argument used here 1 suggested mysql.
connecttomysql(@"server=my_server;userid=my_id;password=my_password;database=my_database"); public static mysqlconnection connecttomysql(string connectioninfo) { try { //instantiate connection mysqlconnection mysqlconn = new mysqlconnection(connectioninfo); //open , close mysql connection make sure works. can re-opened later mysqlconn.open(); mysqlconn.close(); //return connection return mysqlconn; } catch (exception e) { // print off error message , return null connection //throw exception, log error string n = environment.newline; file.appendalltext("\\logfile.txt", "failed connect mysql." + n + e.tostring() + n + n); throw new exception ("failed connect mysql. "); } } now have working, want create argument using
system.net.credentialcache.defaultcredentials to generate password , username. problem there doesn't seem way default credentials string format. realize prompt user enter credentials, doesn't work application i'm programming. working in visual studios express 2013 creating windows form application. don't have connect using system.net.credentialcache.defaultcredentials, open other solutions.
Comments
Post a Comment