?? ywywh.aspx.cs
字號(hào):
?using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class spwh : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//默認(rèn)顯示商品資料的第一頁
bindgrig();
}
}
void bindgrig()
{
SqlConnection Conn;
// 設(shè)置數(shù)據(jù)庫連接
String strConn = ConfigurationManager.AppSettings["conn"];
Conn = new SqlConnection(strConn);
//從數(shù)據(jù)庫取查詢結(jié)果
SqlDataAdapter Cmd = new SqlDataAdapter("select 業(yè)務(wù)員編號(hào),姓名,性別,職務(wù),電話 from 業(yè)務(wù)員 where 姓名 like '%" + this.TextBox1.Text + "%' order by 業(yè)務(wù)員編號(hào)", Conn);
DataSet Ds = new DataSet();
Cmd.Fill(Ds, "業(yè)務(wù)員資料");
//指定數(shù)據(jù)源
GridView1.DataSource = new DataView(Ds.Tables[0]);
//數(shù)據(jù)綁定
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
//查詢符合條件商品,默認(rèn)第一頁
GridView1.PageIndex = 0;
bindgrig();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
//改變顯示頁面
GridView1.PageIndex = e.NewPageIndex;
bindgrig();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
//設(shè)置行編輯狀態(tài)
GridView1.EditIndex = e.NewEditIndex;
bindgrig();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//設(shè)置數(shù)據(jù)庫連接
SqlConnection Conn;
String strConn = ConfigurationManager.AppSettings["conn"];
Conn = new SqlConnection(strConn);
Conn.Open();
//刪除行處理
String sql = "delete from 業(yè)務(wù)員 where 業(yè)務(wù)員編號(hào)='" + GridView1.DataKeys[e.RowIndex].Value.ToString()+ "'";
SqlCommand Comm = new SqlCommand(sql, Conn);
Comm.ExecuteNonQuery();
Conn.Close();
GridView1.EditIndex = -1;
bindgrig();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//設(shè)置數(shù)據(jù)庫連接
SqlConnection Conn;
String strConn = ConfigurationManager.AppSettings["conn"];
Conn = new SqlConnection(strConn);
Conn.Open();
//提交行修改
String sql = "update 業(yè)務(wù)員 set 姓名='" + ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox1")).Text + "',性別='" + ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox2")).Text + "',職務(wù)='" + ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox3")).Text + "',電話='" + ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox4")).Text + "' where 業(yè)務(wù)員編號(hào)='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
SqlCommand Comm = new SqlCommand(sql, Conn);
Comm.ExecuteNonQuery();
Conn.Close();
GridView1.EditIndex = -1;
bindgrig();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
//行編輯狀態(tài)取消
GridView1.EditIndex = -1;
bindgrig();
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -