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.SqlClient;
namespace Chaxun_stu
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
string strSQL;
SqlConnection conn;
DataSet ds;
SqlDataAdapter da;
private void Form1_Load(object sender, EventArgs e)
{
strSQL = "select * from stuInfo";//执行 SQL 读出stuInfo 中的数据
conn = DB.CreateConn();//引用DB中的连接语句
da = new SqlDataAdapter(strSQL, conn);
ds = new DataSet();
da.Fill(ds, "stuInfo");
this.dataGridView1.DataSource = ds.Tables["stuInfo"].DefaultView;
this.txtSno.DataBindings.Add("Text", ds, "stuInfo.Sno");
this.txtSname.DataBindings.Add("Text", ds, "stuInfo.Sname");
this.txtSage.DataBindings.Add("Text", ds, "stuInfo.Sage");
this.EnableButtons();
}
private void btnSearch_Click(object sender, EventArgs e)
{
ds.Tables["stuInfo"].DefaultView.RowFilter = "sno='" + this.txtSno.Text + "'";
// ds.Tables["stuInfo"].DefaultView.RowFilter = "sname= '" + this.txtSname.Text + "'";
}
private void btnSearchAll_Click(object sender, EventArgs e)
{
DataView dv = new DataView(ds.Tables[0]);
this.dataGridView1.DataSource = dv;
}
private void btn_Click(object sender, EventArgs e)
{
if (sender == this.btnFirst)
{
this.BindingContext[ds, "stuInfo"].Position = 0;
}
else if (sender == this.btnPreviouse)
{
this.BindingContext[ds, "stuInfo"].Position--;
}
else if (sender == this.btnNext)
{
this.BindingContext[ds, "stuInfo"].Position++;
}
else if (sender == this.btnLast)
{
this.BindingContext[ds, "stuInfo"].Position = ds.Tables[0].Rows.Count - 1;
}
this.EnableButtons();
}
private void EnableButtons()//设置按钮是否可用
{
this.btnLast.Enabled = false;
this.btnNext.Enabled = false;
this.btnPreviouse.Enabled = false;
this.btnFirst.Enabled = false;
if (this.BindingContext[ds, "stuInfo"].Position > 0)
{
this.btnFirst.Enabled = true;
this.btnPreviouse.Enabled = true;
}
if (this.BindingContext[ds, "stuInfo"].Position < ds.Tables[0].Rows.Count - 1)
{
this.btnLast.Enabled = true;
this.btnNext.Enabled = true;
}
}
}
}