using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
public DataTable Dummy_DataTable(string SQLcmb, string TableName)
{
try
{
string Connstring;
Connstring = "Provider=Microsoft.jet.OLEDB.4.0;Data source=" +
Application.StartupPath + "\\data.mdb;" +
"Jet OLEDB:Database Password=";
OleDbConnection conn = new OleDbConnection(Connstring);
conn.Open();
OleDbDataAdapter da = new OleDbDataAdapter(SQLcmb, conn);
DataSet ds = new DataSet();
da.Fill(ds, "data");
conn.Close();
da.Dispose();
//霶嘘 Datatable
return ds.Tables[TableName];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return null;
}
}
private void button1_Click(object sender, EventArgs e)//丿낋券们鞈欧隙Button
{
string Selectcom = "";
Selectcom = "select * from data order by 學號";
dataGridView1.DataSource = Dummy_DataTable(Selectcom, "data");
dataGridView1.AutoResizeColumns();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
private void Form1_Load(object sender, EventArgs e)
{
// TODO: ⒣ꆌ蝔鲳벏蝣潭鲃撠殴뎇⒣벉ꔠ'dataDataSet.data' 鞈欧隙銵具肂典骓隞亥Ꚗ胨ꚁ脰ꆌ蝘餃讕緐宏扎肂
this.dataTableAdapter.Fill(this.dataDataSet.data);
}
private void button2_Click(object sender, EventArgs e)
{
string selectCmd="";
string input1 = "";
input1 = textBox1.Text;
selectCmd="select * from data where 學號 like '%" + input1 + "%' or 姓名両邍 like '%" + input1 + "%' or 居住縣市 like '%"+input1+"%'";
dataGridView1.DataSource=Dummy_DataTable(selectCmd, "data");
dataGridView1.AutoResizeColumns();
}
private void label1_Click(object sender, EventArgs e)
{
}
private void textBox2_TextChanged(object sender, EventArgs e)
{
}
private void label2_Click(object sender, EventArgs e)
{
}
private void button3_Click(object sender, EventArgs e)
{
string selectCmb = "";
int KeyIN=int.Parse(textBox2.Text);
selectCmb = "DELETE FROM data WHERE 學號 ='"+KeyIN+"'";
dataGridView1.DataSource = Dummy_DataTable(selectCmb, "data");
dataGridView1.AutoResizeColumns();
}
}
}
這是我整篇的完整碼!! 僅有查詢跟刪除功能!!
最下面一段就是出問題的地方!!(button3_Click)
麻煩了!!
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 114.47.224.226