using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OracleClient;
using System.Collections;
using System.Data.OleDb;
using System.Data;
string connstring = "Data Source=127.0.0.1:1521/wj123 ;user id=rr;password=wj123"; 这一句该怎么写???
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OracleClient;
using System.Collections;
using System.Data.OleDb;
using System.Data;
string connstring = "Data Source=127.0.0.1:1521/wj123 ;user id=rr;password=wj123"; 这一句该怎么写???
string connString = "server=localhost;port=3306;user id=root;persistsecurityinfo=False;database=northcerp;password=xxxx;Convert Zero Datetime=True;Allow Zero Datetime=True;CharSet=utf8";
string sql = "select * from BA_Shop"; MySqlConnection conn = new MySqlConnection(connString);
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
sda = new MySqlDataAdapter(cmd);
MySqlCommandBuilder scb = new MySqlCommandBuilder(sda);
DataTable dt = new DataTable();
sda.Fill(dt);
this.dataGridView1.DataSource = dt;