Home > database >  WinForms: Connection must be valid and open
WinForms: Connection must be valid and open

Time:06-02

There is a DataGridView element on the form, in which there is a connected SQL table. Also on the form there are several elements for entering data and a button, when clicked, the process of adding data should be performed directly.Thanks in advance. Here is the code:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Configuration;
using MySql.Data;
using MySql.Data.MySqlClient;
using System.Data.SqlClient;

namespace Курсовая.Приложение
{
    public partial class ProfileForm : Form
    {
        public ProfileForm()
        {
            InitializeComponent();
        }
        private void ProfileForm_Load(object sender, EventArgs e)
        {
            TouristGridView.DataSource = GetTouristList();
        }
        private DataTable dtTourist = new DataTable();
        private DataTable GetTouristList()
        {
            string connString = ConfigurationManager.ConnectionStrings["dbx"].ConnectionString;
            using (MySqlConnection con = new MySqlConnection(connString))
            {
                using (MySqlCommand cmd = new MySqlCommand("SELECT FIO, dob, phone FROM tourist", con))
                {
                    con.Open();
                    MySqlDataReader reader = cmd.ExecuteReader();
                    dtTourist.Load(reader);
                }
            }
            return dtTourist;
        }
        private void button1_Click_1(object sender, EventArgs e)
        {
            string connString = ConfigurationManager.ConnectionStrings["dbx"].ConnectionString;
            using (MySqlConnection con = new MySqlConnection(connString))
            {
                con.Open();
                MySqlCommand Command = new MySqlCommand("INSERT INTO [tourist] ([FIO], [dob], [phone]) VALUES ('"   NametextBox.Text   "','"   dobDate.Value   "','"   PhonetextBox.Text   "')");
                Command.ExecuteNonQuery();
            }
        }
    }
}

CodePudding user response:

When you instance your MySqlConnection, you have to pass the open connection Object, like that :

private void button1_Click_1(object sender, EventArgs e)
        {
            string connString = ConfigurationManager.ConnectionStrings["dbx"].ConnectionString;
            using (MySqlConnection con = new MySqlConnection(connString))
            {
                con.Open();
                MySqlCommand Command = new MySqlCommand("INSERT INTO [tourist] ([FIO], [dob], [phone]) VALUES ('"   NametextBox.Text   "','"   dobDate.Value   "','"   PhonetextBox.Text   "')", con);
                Command.ExecuteNonQuery();
            }
        }
  • Related