date

来源：互联网发布：淘宝平铺拍摄技巧编辑：程序博客网时间：2024/05/01 05:34

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
using System.Data.SqlClient;

namespace data
{
public partial class Form1 : Form
{

        string connString =
      "Data Source=localhost;Initial Catalog=zzz;User ID=root;Pwd=root";
        MySqlConnection connection;
        SqlDataReader dataReader;

        DataSet dataSet;
        MySqlDataAdapter sdp;
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            connection = new MySqlConnection(connString);
            connection.Open();
            string sql = string.Format("select COUNT(*) from useradmin where username ='{0}' and password='{1}' ", textBox1.Text, textBox2.Text);
            MySqlCommand command = new MySqlCommand(sql, connection);
            int num = Convert.ToInt32(command.ExecuteScalar());
            if (num == 1)
            {
                MessageBox.Show("adf");
            }

connection.Close();

}

        private void button2_Click(object sender, EventArgs e)
        {
            connection = new MySqlConnection(connString);
            connection.Open();
            string sql = string.Format("delete from useradmin where username ='{0}' and password='{1}' ", textBox1.Text, textBox2.Text);
            MySqlCommand command = new MySqlCommand(sql, connection);
            int num = Convert.ToInt32(command.ExecuteNonQuery());
            if (num == 1)
            {
                MessageBox.Show("adf");
            }

connection.Close();
}

        private void button3_Click(object sender, EventArgs e)
        {
            connection = new MySqlConnection(connString);
            connection.Open();
            string sql = string.Format("select* from useradmin ");
            MySqlCommand command = new MySqlCommand(sql, connection);

MySqlDataReader dataReader = command.ExecuteReader();

            while (dataReader.Read())
            {
               string aaa= dataReader["username"].ToString();
            }

connection.Close();
}

        private void button4_Click(object sender, EventArgs e)
        {
             dataSet = new DataSet();
            connection = new MySqlConnection(connString);
            //connection.Open();
            string sql = string.Format("select* from useradmin ");
             sdp = new MySqlDataAdapter(sql, connection);

sdp.Fill(dataSet,"useradmin");
dataGridView1.DataSource = dataSet.Tables["useradmin"];

//connection.Close();

}

        private void button5_Click(object sender, EventArgs e)
        {
            DialogResult result = MessageBox.Show("ﾈｷﾊｵﾒｪｽｫﾐﾞｸﾄｱ｣ｴ豬ｽﾊｾﾝｿ篦・", "ｲﾙﾗ睫ｾ", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
            if (result == DialogResult.OK)
            {
                MySqlCommandBuilder builder = new MySqlCommandBuilder(sdp);
                sdp.Update(dataSet, "useradmin");
            }
        }
    }
}