asp.net mysql connection

Question

Sandhiya Priya · Answer

How to connect an ASP.NET application to MySQL . I’ll cover the steps for both classic ASP.NET and ASP.NET Core . 1. Install MySQL Connector You need MySQL.Data library (Connector/NET) to connect ASP.NET to MySQL. Using NuGet: Install-Package MySql.Data Or for ASP.NET Core: dotnet add package MySql.Data 2. Create a Connection String Example: string connString = "Server=localhost;Database=mydb;User ID=root;Password=yourpassword;SslMode=none;"; Server – MySQL server name (localhost if local). Database – Name of your database. User ID and Password – MySQL credentials. SslMode=none – Optional for local development. In ASP.NET Core , you usually put this in appsettings.json : { "ConnectionStrings": { "MySqlConnection": "Server=localhost;Database=mydb;User ID=root;Password=yourpassword;SslMode=none;" } } 3. Using MySqlConnection (Classic ASP.NET) using MySql.Data.MySqlClient; string connString = "Server=localhost;Database=mydb;User ID=root;Password=yourpassword;SslMode=none;"; using (MySqlConnection conn = new MySqlConnection(connString)) { conn.Open(); string query = "SELECT * FROM Employees"; MySqlCommand cmd = new MySqlCommand(query, conn); using (MySqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { string name = reader["Name"].ToString(); int age = Convert.ToInt32(reader["Age"]); // Do something with data } } } 4. Using Dependency Injection (ASP.NET Core) Program.cs: builder.Services.AddTransient (_ => new MySqlConnection(builder.Configuration.GetConnectionString("MySqlConnection"))); Controller Example: public class EmployeeController : Controller { private readonly MySqlConnection _conn; public EmployeeController(MySqlConnection conn) { _conn = conn; } public IActionResult Index() { _conn.Open(); var cmd = new MySqlCommand("SELECT * FROM Employees", _conn); var reader = cmd.ExecuteReader(); var list = new List (); while (reader.Read()) { list.Add(reader["Name"].ToString()); } _conn.Close(); return View(list); } } Tips: Always use using to dispose the connection. For security, never hard-code passwords in code; use appsettings.json or environment variables. For production, consider connection pooling and SslMode=Required .

Cynthia Sathuragiri · Answer

1. Install-Package MySql.Data 2. In your Web.config file, add a section: connectionString="server=localhost;user id=root;password=yourpassword;database=testdb;" providerName="MySql.Data.MySqlClient" /> 3. Write C# Code to Connect and Query using MySql.Data.MySqlClient; using System; using System.Web.UI; public partial class Default : Page { protected void Page_Load(object sender, EventArgs e) { string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["MySqlConn"].ConnectionString; using (MySqlConnection conn = new MySqlConnection(connStr)) { conn.Open(); Response.Write("Connection successful!"); } } } Reading Data using MySql.Data.MySqlClient; using System; using System.Web.UI; public partial class ReadData : Page { protected void Page_Load(object sender, EventArgs e) { string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["MySqlConn"].ConnectionString; using (MySqlConnection conn = new MySqlConnection(connStr)) { conn.Open(); string query = "SELECT id, name, email FROM users"; MySqlCommand cmd = new MySqlCommand(query, conn); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Response.Write($"ID: {reader["id"]}, Name: {reader["name"]}, Email: {reader["email"]} "); } } } } Inserting Data using MySql.Data.MySqlClient; protected void btnSave_Click(object sender, EventArgs e) { string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["MySqlConn"].ConnectionString; using (MySqlConnection conn = new MySqlConnection(connStr)) { conn.Open(); string sql = "INSERT INTO users (name, email) VALUES (@name, @email)"; MySqlCommand cmd = new MySqlCommand(sql, conn); cmd.Parameters.AddWithValue("@name", txtName.Text); cmd.Parameters.AddWithValue("@email", txtEmail.Text); cmd.ExecuteNonQuery(); Response.Write("Record inserted successfully!"); } }

Rajeesh Menoth · Answer

Please provide a brief explanation of your question so we can suggest the most suitable solution for your query.

asp.net mysql connection

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)