Connect to Sql Database and get data C#
Download Nuget package Mysql.Data Import namespace MySql.Data.MySqlClient Construct the connectionstring eg., server=localhost;user=root;password=secret;database=myDatabase Employees has three rows EmployeeId, FirstName and LastName var connectionString = $"server={dbCon.Server};user={dbCon.UserName};password={dbCon.Password};database={dbCon.DatabaseName}"; using var connection = new MySqlConnection(connectionString); connection.Open(); string query = "select * from Employees"; var cmd = new MySqlCommand(query, connection); var reader = cmd.ExecuteReader(); while (reader.Read()){ Console.WriteLine($"{reader.GetString(0)} {reader.GetString(1)} {reader.GetString(2)}"); }

Comments
Post a Comment