how to retrieve the data from mysql to visual studio 2017 using c #

Question

how to retrieve the data from mysql to visual studio 2017 using c shar

Vishal Yelve · Answer

Hi Pragadeeshwar, try this MYSQL Query -- Database: `testdb` -- Table structure for table `student` -- CREATE TABLE IF NOT EXISTS `student` ( `Name` varchar(200) NOT NULL, `Address` varchar(200) NOT NULL, `Mobile` varchar(200) NOT NULL, `Email` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `student` -- INSERT INTO `student` (`Name`, `Address`, `Mobile`, `Email`) VALUES ('vishal', 'mumbai', '1234567890', 'vishal@gmail.com'), ('kunal', 'pune', '9700000000', 'kunal@gmail.com'), ('priya', 'delhi', '4512369870', 'priya@gmail.com'); C# Code using System; using MySql.Data.MySqlClient; namespace RetrieveSqlDataReader { class ShowData { static void Main(string[] args) { string connectionString = "Your connection string "; MySqlConnection conn = null; MySqlDataReader Reader = null; conn = new MySqlConnection(connectionString); conn.Open(); Console.WriteLine("
 Retrieving data from database MySql server
"); try { MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT * FROM student"; Reader = cmd.ExecuteReader(); Console.WriteLine("Name|Address|Mobile|Email
"); while (Reader.Read()) { Console.WriteLine(Reader.GetString(0) + "|" + Reader.GetString(1) + "|" + Reader.GetString(2) + "|" + Reader.GetString(3)); } Console.ReadLine(); } catch (Exception ex) { Console.WriteLine("Error: " + ex.ToString()); } finally { if (Reader != null) { Reader.Close(); } if (conn != null) { conn.Close(); } } } } }

Tahir Ansari · Answer

Follow the steps 1)Install the MySQL Connector/NET using NuGet Package Manager: 2) C# code using System; using MySql.Data.MySqlClient; namespace MySQLDataRetrieval { class Program { static void Main(string[] args) { // Replace the placeholders with your MySQL server details string connectionString = "your connection string here"; // Step 3: Write C# Code using (MySqlConnection connection = new MySqlConnection(connectionString)) { try { connection.Open(); // SQL query to retrieve data string query = "SELECT * FROM your_table_name;"; MySqlCommand command = new MySqlCommand(query, connection); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { // Access the data using reader methods based on the data types int id = reader.GetInt32("id"); string name = reader.GetString("name"); int age = reader.GetInt32("age"); // Do something with the retrieved data Console.WriteLine($"ID: {id}, Name: {name}, Age: {age}"); } reader.Close(); } catch (Exception ex) { Console.WriteLine("Error: " + ex.Message); } } } } }