using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace 志愿分配系统
{
public partial class frmXiugai : Form
{
public frmXiugai()
{
InitializeComponent();
}
SqlConnection conn;
SqlDataAdapter sda;
DataSet ds;
private void getData_Click(object sender, EventArgs e)
{
conn = new SqlConnection(SQL.sqlCon);
conn.Open();
string str = "select 编号, 单位名称,需求人数,所在城市,单位详细地址 from 医院信息表 order by 编号";
sda = new SqlDataAdapter(str, conn);
ds = new DataSet();
sda.Fill(ds,"医院信息表");
dataGridView1.DataSource = ds.Tables[0];
}
private void upData_Click(object sender, EventArgs e)
{
SqlCommandBuilder scb = new SqlCommandBuilder(sda);
sda.Update(ds,"医院信息表");
int i = Convert.ToInt32(sda.UpdateBatchSize);
if (i > 0)
{
MessageBox.Show(i.ToString());
}
else
{
MessageBox.Show("false updata!");
}
}
}
}
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace 志愿分配系统
{
public partial class frmXiugai : Form
{
public frmXiugai()
{
InitializeComponent();
}
SqlConnection conn;
SqlDataAdapter sda;
DataSet ds;
private void getData_Click(object sender, EventArgs e)
{
conn = new SqlConnection(SQL.sqlCon);
conn.Open();
string str = "select 编号, 单位名称,需求人数,所在城市,单位详细地址 from 医院信息表 order by 编号";
sda = new SqlDataAdapter(str, conn);
ds = new DataSet();
sda.Fill(ds,"医院信息表");
dataGridView1.DataSource = ds.Tables[0];
}
private void upData_Click(object sender, EventArgs e)
{
SqlCommandBuilder scb = new SqlCommandBuilder(sda);
sda.Update(ds,"医院信息表");
int i = Convert.ToInt32(sda.UpdateBatchSize);
if (i > 0)
{
MessageBox.Show(i.ToString());
}
else
{
MessageBox.Show("false updata!");
}
}
}
}