通过c＃语言连接到phpmyadmin中的sql [英] connect to sql in phpmyadmin via c# language

问题描述

嗨朋友们，

我设计了一个Windows窗体并希望使用C＃语言使用wampp数据库连接到phpmyadmin中的sql ...请给我所有头文件等的整个代码。 。

在我的Windows窗体中有两个textbox = textbox1和textbox2。并且在按钮单击事件上建立连接并且值显示在文本框中..

解决方案

通过应用您的实体来尝试：

 server =   localhost ; 
 database =   connectcsharptomysql; 
 uid =   username; 
 password =   password; 
  string  connectionString; 
 connectionString =   SERVER = + server +  ; +   DATABASE =  + 
 database +  ; +   UID = + uid +  ; +   PASSWORD = +密码+  ;; 
 
 connection =  new  MySqlConnection（connectionString）; 

和她的一些插入，更新，删除语句：

 public void Insert（）
 {
 string query =INSERT INTO tableinfo（name，age）VALUES（'John Smith'，'33'）; 
 
 //打开连接
 if（this.OpenConnection（）== true）
 {
 //创建命令并从构造函数$中分配查询和连接b $ b MySqlCommand cmd = new MySqlCommand（查询，连接）; 
 
 //执行命令
 cmd.ExecuteNonQuery（）; 
 
 //关闭连接
 this.CloseConnection（）; 
} 
} 
 
 //更新语句
 public void Update（）
 {
 string query =UPDATE tableinfo SET name =' Joe'，年龄='22'WHERE name ='John Smith'; 
 
 //打开连接
 if（this.OpenConnection（）== true）
 {
 //创建mysql命令
 MySqlCommand cmd = new MySqlCommand （）; 
 //使用CommandText 
 cmd.CommandText = query分配查询; 
 //使用Connection 
 cmd.Connection = connection分配连接; 
 
 //执行查询
 cmd.ExecuteNonQuery（）; 
 
 //关闭连接
 this.CloseConnection（）; 
} 
} 
 
 //删除语句
 public void Delete（）
 {
 string query =DELETE FROM tableinfo WHERE name = '约翰·史密斯'; 
 
 if（this.OpenConnection（）== true）
 {
 MySqlCommand cmd = new MySqlCommand（query，connection）; 
 cmd.ExecuteNonQuery（）; 
 this.CloseConnection（）; 
} 
} 

现在你可以通过选择staement来绑定你的数据：

公开列表<     string    >  [] Select（）
 {
 string query =SELECT * FROM tableinfo; 
 
 //创建一个列表来存储结果
列表<     string    >  [] list =新列表<     string    >  [3]; 
 list [0] = new List <     string    > （）; 
 list [1] = new List <     string    > （）; 
 list [2] = new List <     string    > （）; 
 
 //打开连接
 if（this.OpenConnection（）== true）
 {
 //创建命令
 MySqlCommand cmd = new MySqlCommand（查询，连接）; 
 //创建数据读取器并执行命令
 MySqlDataReader dataReader = cmd.ExecuteReader（）; 
 
 //读取数据并将它们存储在列表中
 while（dataReader.Read（））
 {
 list [0] .Add（dataReader [ id] +）; 
 list [1] .Add（dataReader [name] +）; 
 list [2] .Add（dataReader [age] +）; 
} 
 
 //关闭数据读取器
 dataReader.Close（）; 
 
 //关闭连接
 this.CloseConnection（）; 
 
 //要显示的返回列表
返回列表; 
} 
其他
 {
返回列表; 
} 
} 

问候......

@Tamer Hatoum



如何将其用作库：

 server =localhost ; 
 database =connectcsharptomysql; 
 uid =username; 
密码=密码; 
 string connectionString; 
 connectionString =SERVER =+ server +; +DATABASE =+ 
数据库+; +UID =+ uid +; +PASSWORD =+密码+;; 
 
 connection = new MySqlConnection（connectionString）; 

并删除web.condig中的连接

Hi friends,
I have designed a windows form and want to connect to sql in phpmyadmin using wampp database using C# language...Please give me the whole code with all header files etc...
In my windows form there are two textbox=textbox1 and textbox2. and on the button click event the connection is made and the values are shown in textboxes..

解决方案

Try that by applying your entities:

server = "localhost";
database = "connectcsharptomysql";
uid = "username";
password = "password";
string connectionString;
connectionString = "SERVER=" + server + ";" + "DATABASE=" +
database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";";

connection = new MySqlConnection(connectionString);

and her some insert, update, delete statements :

public void Insert()
{
    string query = "INSERT INTO tableinfo (name, age) VALUES('John Smith', '33')";

    //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()
{
    string query = "UPDATE tableinfo SET name='Joe', age='22' WHERE name='John Smith'";

    //Open connection
    if (this.OpenConnection() == true)
    {
        //create mysql command
        MySqlCommand cmd = new MySqlCommand();
        //Assign the query using CommandText
        cmd.CommandText = query;
        //Assign the connection using Connection
        cmd.Connection = connection;

        //Execute query
        cmd.ExecuteNonQuery();

        //close connection
        this.CloseConnection();
    }
}

//Delete statement
public void Delete()
{
    string query = "DELETE FROM tableinfo WHERE name='John Smith'";

    if (this.OpenConnection() == true)
    {
        MySqlCommand cmd = new MySqlCommand(query, connection);
        cmd.ExecuteNonQuery();
        this.CloseConnection();
    }
}

and now you can bind your data by select staement :

public List< string >[] Select()
{
    string query = "SELECT * FROM tableinfo";

    //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
        while (dataReader.Read())
        {
            list[0].Add(dataReader["id"] + "");
            list[1].Add(dataReader["name"] + "");
            list[2].Add(dataReader["age"] + "");
        }

        //close Data Reader
        dataReader.Close();

        //close Connection
        this.CloseConnection();

        //return list to be displayed
        return list;
    }
    else
    {
        return list;
    }
}

regards...

@Tamer Hatoum

How to use this as a library:

server = "localhost";
database = "connectcsharptomysql";
uid = "username";
password = "password";
string connectionString;
connectionString = "SERVER=" + server + ";" + "DATABASE=" +
database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";";
 
connection = new MySqlConnection(connectionString);

and remove the connection in web.condig

这篇关于通过c＃语言连接到phpmyadmin中的sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！