HospitalManageSys/Form_DrugIm_2.cs

   1 using System;
   2 using System.Collections.Generic;
   3 using System.ComponentModel;
   4 using System.Data;
   5 using System.Drawing;
   6 using System.Linq;
   7 using System.Text;
   8 using System.Windows.Forms;
   9 using MySql.Data.MySqlClient;
  10
  11 namespace HospitalManageSys
  12 {
  13     public partial class Form_DrugIm_2 : Form
  14     {
  15         public Form_DrugIm_2()
  16         {
  17             InitializeComponent();
  18         }
  19         DataSet ds = new DataSet();
  20         MySqlDataAdapter sda;
  21         private void Form2_Load(object sender, EventArgs e)
  22         {
  23             mtbBirthDate.MaskInputRejected += new MaskInputRejectedEventHandler(mtbBirthDate_MaskInputRejected);
  24             string connectionString = "Data Source=localhost;Initial Catalog=hospitalmanagesys;User ID=root;Password=nnnbc4318";
  25             string query = "insert into hospitalmanagesys.drug value('115','jam','29.0','nothing','ssk','u','19');";
  26             ds = SelectRows(ds, connectionString, query);
  27             /*MySqlConnection conn = new MySqlConnection(connectionString);
  28             string sql = "select*from drug";
  29             sda = new MySqlDataAdapter(sql, conn);
  30             sda.Fill(ds);
  31             DataTable dt = new DataTable("childTable");
  32             DataColumn column = new DataColumn("ChildID", typeof(System.Int32));
  33             column.AutoIncrement = true;
  34             column.Caption = "ID";
  35             column.ReadOnly = true;
  36             column.Unique = true;
  37             dt.Columns.Add(column);
  38             DataRow row;
  39             for (int i = 0; i <= 4; i++)
  40             {
  41                 row = dt.NewRow();
  42                 row["ChildID"] = i;
  43                 dt.Rows.Add(row);
  44             }
  45             ds.Tables.Add(dt);
  46             dataGridView1.DataSource = ds.Tables[0];*/
  47
  48         }
  49         private void mtbBirthDate_MaskInputRejected(object sender,MaskInputRejectedEventArgs e)
  50         {
  51             ToolTip toolTip = new ToolTip();
  52             toolTip.IsBalloon = true;
  53             toolTip.ToolTipIcon = ToolTipIcon.Warning;
  54             toolTip.ToolTipTitle = "system warning";
  55             toolTip.Show("please input effective number",label1,2000);
  56         }
  57
  58         private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
  59         {
  60
  61         }
  62         private static DataSet SelectRows(DataSet dataset, string connectionString, string queryString)
  63         {
  64             using (MySqlConnection connection = new MySqlConnection(connectionString))
  65             {
  66                 MySqlDataAdapter adapter = new MySqlDataAdapter();
  67                 adapter.SelectCommand = new MySqlCommand(queryString, connection);
  68                 adapter.Fill(dataset);
  69                 return dataset;
  70             }
  71         }
  72         private void button1_Click(object sender, EventArgs e)
  73         {
  74             DialogResult dr = MessageBox.Show("确定要将修改的数据保存到数据库吗？", "修改提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
  75             if (dr == DialogResult.OK)
  76             {
  77                 MySqlCommandBuilder sb = new MySqlCommandBuilder(sda);
  78                 sda.Update(ds);
  79                 MessageBox.Show("修改成功", "成功提示");
  80             }
  81         }
  82
  83         private void button2_Click(object sender, EventArgs e)
  84         {
  85
  86         }
  87     }
  88 }