protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
databind();
}
}
private void databind()
{
SqlConnection con = DB.createConnect();
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "select * from xin";
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "table");
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();
con.Close();
}
protected void Button6_Click(object sender, EventArgs e)
{
//添加数据
string stuid = TextBox1.Text;
string stuname = TextBox2.Text;
string stuclass = TextBox3.Text;
SqlConnection con = DB.createConnect();
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "insert into xin values('" + stuid + "','" + stuname + "','" + stuclass + "')";
Int32 sum = cmd.ExecuteNonQuery();
if (sum > 0)
{
databind();
TextBox1.Text = TextBox2.Text = TextBox3.Text = "";
}
else
{
Response.Write("<script>alert('添加失败!')</script>");
}
con.Close();
}
protected void Button4_Click(object sender, EventArgs e)
{
//查询数据
SqlConnection con = DB.createConnect();
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "select * from xin where s_id="+TextBox4.Text.ToString();
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();//上一句的方法将查询的结果转化成数据流的形式,通过read方法读取一条数据。如果用while(dr.Read())就可以循环读取了。
TextBox5.Text = dr["s_name"].ToString();
TextBox6.Text = dr["s_class"].ToString();//通过dr["当前行的某一字段"]。也可以用dr.get(2)读取当前行某一列数据;
con.Close();
dr.Close();
}
protected void Button7_Click(object sender, EventArgs e)
{
//修改数据
SqlConnection con = DB.createConnect();
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "update xin set s_name='"+TextBox5.Text+"',s_class='"+TextBox6.Text+"'where s_id='"+TextBox4.Text+"'";
Int32 sum = cmd.ExecuteNonQuery();
if (sum > 0)
{
databind();
TextBox1.Text = TextBox2.Text = TextBox3.Text = "";
}
else
{
Response.Write("<script>alert('修改失败!')</script>");
}
con.Close();
}
protected void Button5_Click(object sender, EventArgs e)
{
//删除数据
SqlConnection con = DB.createConnect();
con.Open();
SqlCommand cmd = new SqlCommand("delete from xin where s_id='"+TextBox7.Text+"'",con);
int sum = cmd.ExecuteNonQuery();
if (sum > 0)
{
databind();
TextBox7.Text = "";
}
else
{
Response.Write("<script>alert('无法删除!')</script>");
}
}