使标签静态错误:无法访问外部类型的非静态成员';windowsForm8.Form1';通过嵌套类型'

本文关键字:静态成员 windowsForm8 Form1 嵌套类型 错误 静态 标签 类型 外部 访问 | 更新日期: 2023-09-27 18:20:09

Yo这是我在这里的第一篇文章,我想知道如何在C#中解决这个问题所以我尝试连接到数据库并从中选择信息,这些信息将显示为标签!容易的所以这就是我得到的错误:

无法访问外部类型为"windowsForm8.Form1"的非静态成员通过嵌套类型"windowsForm8.Form1.DBConnect"


这是代码:

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 MySql.Data.MySqlClient;
namespace WindowsFormsApplication8
{
public partial class Form1 : Form
{
    public Form1()
    {
        InitializeComponent();
    }
    public class DBConnect
    {
        private MySqlConnection connection;
        private string server;
        private string database;
        private string uid;
        private string password;

        //Constructor
        public DBConnect()
        {
            Initialize();
        }
        //Initialize values
        private void Initialize()
        {
            server = "net";
            database = "rainbow";
            uid = "ok";
            password = "passwd!";
            string connectionString;
            connectionString = "SERVER=" + server + ";" + "DATABASE=" +
            database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";";
            connection = new MySqlConnection(connectionString);
        }
        //open connection to database
        private bool OpenConnection()
        {
            try
            {
                connection.Open();
                return true;
            }
            catch (MySqlException ex)
            {
                //When handling errors, you can your application's response based 
                //on the error number.
                //The two most common error numbers when connecting are as follows:
                //0: Cannot connect to server.
                //1045: Invalid user name and/or password.
                switch (ex.Number)
                {
                    case 0:
                        MessageBox.Show("Cannot connect to server.  Contact administrator");
                        break;
                    case 1045:
                        MessageBox.Show("Invalid username/password, please try again");
                        break;
                    default :
                        MessageBox.Show("Connected Successfuly!!");
                        break;
                }
                return false;
            }

        }
        //Close connection
        private bool CloseConnection()
        {
            try
            {
                connection.Close();
                return true;
            }
            catch (MySqlException ex)
            {
                MessageBox.Show(ex.Message);
                return false;
            }
        }
        //Insert statement
        public void Insert()
        {
            string query = "INSERT INTO mytable (username, password) VALUES('shryder', 'nopassword')";
            //open connection
            if (this.OpenConnection() == true)
            {
                //create command and assign the query and connection from the constructor
                MySqlCommand cmd = new MySqlCommand(query, connection);
                //Execute command
                cmd.ExecuteNonQuery();
                //close connection
                this.CloseConnection();
            }
        }
        //Update statement
        public void Update()
        {
        }
        //Delete statement
        public void Delete()
        {
        }
        //Select statement
        public List<string>[] Select()
        {
            string query = "SELECT * FROM mytable";
            //Create a list to store the result
            List<string>[] list = new List<string>[3];
            list[0] = new List<string>();
            list[1] = new List<string>();
            list[2] = new List<string>();
            //Open connection
            if (this.OpenConnection() == true)
            {
                //Create Command
                MySqlCommand cmd = new MySqlCommand(query, connection);
                //Create a data reader and Execute the command
                MySqlDataReader dataReader = cmd.ExecuteReader();
                //Read the data and store them in the list
                if (dataReader.Read())
                {
                    /*list[0].Add(dataReader["username"] + "");
                    list[1].Add(dataReader["password"] + "");
                    list[2].Add(dataReader["email"] + "");*/
                    newscontent.Text = dataReader["username"]; //this is the error

                }
                //close Data Reader
                dataReader.Close();
                //close Connection
                this.CloseConnection();
                //return list to be displayed
                return list;
            }
            else
            {
                return list;
            }
        }
        //Count statement

        //Backup
        public void Backup()
        {
        }
        //Restore
        public void Restore()
        {
        }
    }

}
}

请帮帮我,谢谢:)

使标签静态错误:无法访问外部类型的非静态成员';windowsForm8.Form1';通过嵌套类型'

将类DbConnect中的所有代码移动到Form1类中。然后,您的所有方法都可以访问表单控件。

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 MySql.Data.MySqlClient;
namespace WindowsFormsApplication8
{
public partial class Form1 : Form
{
    public Form1()
    {
        InitializeComponent();
    } 
        private MySqlConnection connection;
        private string server;
        private string database;
        private string uid;
        private string password;
        //Initialize values
        private void Initialize()
        {
            server = "net";
            database = "rainbow";
            uid = "ok";
            password = "passwd!";
            string connectionString;
            connectionString = "SERVER=" + server + ";" + "DATABASE=" +
            database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";";
            connection = new MySqlConnection(connectionString);
        }
        //open connection to database
        private bool OpenConnection()
        {
            try
            {
                connection.Open();
                return true;
            }
            catch (MySqlException ex)
            {
                //When handling errors, you can your application's response based 
                //on the error number.
                //The two most common error numbers when connecting are as follows:
                //0: Cannot connect to server.
                //1045: Invalid user name and/or password.
                switch (ex.Number)
                {
                    case 0:
                        MessageBox.Show("Cannot connect to server.  Contact administrator");
                        break;
                    case 1045:
                        MessageBox.Show("Invalid username/password, please try again");
                        break;
                    default :
                        MessageBox.Show("Connected Successfuly!!");
                        break;
                }
                return false;
            }

        }
        //Close connection
        private bool CloseConnection()
        {
            try
            {
                connection.Close();
                return true;
            }
            catch (MySqlException ex)
            {
                MessageBox.Show(ex.Message);
                return false;
            }
        }
        //Insert statement
        public void Insert()
        {
            string query = "INSERT INTO mytable (username, password) VALUES('shryder', 'nopassword')";
            //open connection
            if (this.OpenConnection() == true)
            {
                //create command and assign the query and connection from the constructor
                MySqlCommand cmd = new MySqlCommand(query, connection);
                //Execute command
                cmd.ExecuteNonQuery();
                //close connection
                this.CloseConnection();
            }
        }
        //Update statement
        public void Update()
        {
        }
        //Delete statement
        public void Delete()
        {
        }
        //Select statement
        public List<string>[] Select()
        {
            string query = "SELECT * FROM mytable";
            //Create a list to store the result
            List<string>[] list = new List<string>[3];
            list[0] = new List<string>();
            list[1] = new List<string>();
            list[2] = new List<string>();
            //Open connection
            if (this.OpenConnection() == true)
            {
                //Create Command
                MySqlCommand cmd = new MySqlCommand(query, connection);
                //Create a data reader and Execute the command
                MySqlDataReader dataReader = cmd.ExecuteReader();
                //Read the data and store them in the list
                if (dataReader.Read())
                {
                    /*list[0].Add(dataReader["username"] + "");
                    list[1].Add(dataReader["password"] + "");
                    list[2].Add(dataReader["email"] + "");*/
                    newscontent.Text = dataReader["username"]; //this is the error

                }
                //close Data Reader
                dataReader.Close();
                //close Connection
                this.CloseConnection();
                //return list to be displayed
                return list;
            }
            else
            {
                return list;
            }
        }
        //Count statement

        //Backup
        public void Backup()
        {
        }
        //Restore
        public void Restore()
        {
        }
    }

}
}

像这样,你的代码应该能够访问标签,所以它应该编译。它仍然没有做任何事情,因为没有调用任何方法
在我的手机上编辑了这个,所以无法测试代码。