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");
}
}
}
}