using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace WindowsFormsApplication2
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
SqlConnection conn = new SqlConnection("server=.;database=SuperKTV;uid=sa;pwd=123456;");
DataSet ds = new DataSet();
{
string sql = "select * from song";
dap = new SqlDataAdapter(sql, conn);
dap.Fill(ds, "SingerList");
//创建commandbuilder对象 自动生成增删改查的语句
SqlCommandBuilder builder = new SqlCommandBuilder(dap);
//dataGridView1 不允许自动创建列
this.dataGridView1.AutoGenerateColumns = false;
//dataGridView1绑定数据源
this.dataGridView1.DataSource = ds.Tables["SingerList"];
}
//更新
private void button1_Click(object sender, EventArgs e)
{
dap.Update(ds,"SingerList");
}
//刷新
private void button2_Click(object sender, EventArgs e)
{
ds.Tables.Clear();
dap.Fill(ds, "SingerList");
}
//删除
private void tsmDelete_Click(object sender, EventArgs e)
//yes 删除 no 返回
switch (b)
{
case DialogResult.Yes:
int a = this.dataGridView1.CurrentRow.Index;
this.dataGridView1.Rows.RemoveAt(a);
break;
case DialogResult.No: break;
}
}
}
}
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace WindowsFormsApplication2
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
SqlConnection conn = new SqlConnection("server=.;database=SuperKTV;uid=sa;pwd=123456;");
DataSet ds = new DataSet();
SqlDataAdapter dap;
//窗体加载事件
private void Form1_Load(object sender, EventArgs e){
string sql = "select * from song";
dap = new SqlDataAdapter(sql, conn);
dap.Fill(ds, "SingerList");
//创建commandbuilder对象 自动生成增删改查的语句
SqlCommandBuilder builder = new SqlCommandBuilder(dap);
//dataGridView1 不允许自动创建列
this.dataGridView1.AutoGenerateColumns = false;
//dataGridView1绑定数据源
this.dataGridView1.DataSource = ds.Tables["SingerList"];
}
//更新
private void button1_Click(object sender, EventArgs e)
{
dap.Update(ds,"SingerList");
}
//刷新
private void button2_Click(object sender, EventArgs e)
{
ds.Tables.Clear();
dap.Fill(ds, "SingerList");
}
//删除
private void tsmDelete_Click(object sender, EventArgs e)
{
//是否删除
DialogResult b = MessageBox.Show("确定删除?", "", MessageBoxButtons.YesNo);//yes 删除 no 返回
switch (b)
{
case DialogResult.Yes:
int a = this.dataGridView1.CurrentRow.Index;
this.dataGridView1.Rows.RemoveAt(a);
break;
case DialogResult.No: break;
}
}
}
}