Search
 
SCRIPT & CODE EXAMPLE
 

SQL

c# select Mysql

DataSet ds = new DataSet();
using (MySqlConnection con = new MySqlConnection(connectionstr))
{
    using (MySqlCommand cmd = con.CreateCommand())
    {
        con.Open();
        cmd.CommandText = "select * from mysql.user;";
        MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
        adapter.Fill(ds);
    }
}
Comment

PREVIOUS NEXT
Code Example
Sql :: how to count the number of rows in sql 
Sql :: create table like another table 
Sql :: sql left 
Sql :: how to get initials in sql 
Sql :: sql server delete table 
Sql :: how to find unique element in sql 
Sql :: sql get character at index 
Sql :: mysql connectiion timeout 
Sql :: sql online compiler 
Sql :: psql no such file or directory 
Sql :: select users with same username 
Sql :: postgres data location 
Sql :: postgresql conectar 
Sql :: oracle dynamic select into 
Sql :: find mysql password 
Sql :: sql server port 
Sql :: array of objects sql 
Sql :: mysql if statement 
Sql :: docker add mysql to image 
Sql :: sqlalchemy bulk delete 
Sql :: how to define a save method in ruby for sql databases 
Sql :: create a PostgreSQL user django on mac 
Sql :: SQL Modify Column in a Table -SQL Server 
Sql :: sqlite get date only 
Sql :: mysql show slave status 
Sql :: install mysql in ubuntu 18.04 
Sql :: mysql two joins 
Sql :: sql arithmetic operators 
Sql :: tsql edit table column 
Sql :: double in sql server example 
ADD CONTENT
Topic
Content
Source link
Name
1+2 =