//下面用WinForm结合DataGridView控件做个crud
//用到的ADO.NET对象有Connection、Command、DataAdapter、Dataset、DataReader
//另外提下using的三种用法
//①.using引入命名空间,例如:using System;
//②.using创建的对象,自动释放资源,例如:下面创建的SqlConnection对象
//③.using引入命名空间的同时赋别名,例如:using AA=System.Text;
using System;
using System.Data;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
public static string connStr = "server=.;database=winform;integrated security=true";
/// <summary>
/// 窗体加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Form1_Load(object sender, EventArgs e)
{
dataGridView1.AutoGenerateColumns = false;//不自动产生列
DataBind();
}
/// <summary>
/// 刷新列表
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
DataBind();
}
#region 新增
private void button2_Click(object sender, EventArgs e)
{
string name = textBox1.Text.Trim();
string pwd = textBox2.Text.Trim();
string sex = "男";
if (rad