本人原创,转载请注明地址 。
这篇文章主要是用代码方式使用GridView进行新增、修改、删除,新增是用弹出新窗体的方式,完成后关闭新增窗体并且刷新页面和GridView。
代码节选自本人的工程,具体的数据库和表可以自己建,方法参照下面的方法。
先在类里面定义一些参数和连接字符串:
string
sConnString
=
"
server=数据库IP地址;database='数据库名';uid='用户名';pwd='密码'
"
;
SqlConnection Conn = new SqlConnection();
public static string sAddSql;
public string productTime;
public string productLineId;
public string DataType;
public string productNameId;
public string Side;
public string productIn;
public string productOut;
public string productEye;
public string productNum;
public string StartTime;
public string TimeSectID;
SqlConnection Conn = new SqlConnection();
public static string sAddSql;
public string productTime;
public string productLineId;
public string DataType;
public string productNameId;
public string Side;
public string productIn;
public string productOut;
public string productEye;
public string productNum;
public string StartTime;
public string TimeSectID;
然后写页面事件:
protected
void
Page_Load(
object
sender, EventArgs e)
... {
if (!IsPostBack)
...{
Bind(sAddSql);//绑定gridview的方法
}
}
... {
if (!IsPostBack)
...{
Bind(sAddSql);//绑定gridview的方法
}
}
接着是绑定方法和弹出窗体方法:
public
void
Alert(
string
msg)
//
弹出提示框
... {
this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script
language='javascript'>alert('" + msg + "');</script>");
}
public void Bind( string sSql) // 绑定事件
... {
Conn = new SqlConnection(sConnString);
SqlDataAdapter adapter = new SqlDataAdapter("select id,productTime as 生产日期,productLineId as
生产线ID,DataType as 数据类型,productNameId as 产品名称ID,Side as 面次,productIn as 进数," +
"productOut as 出数,productEye as 人工,productNum as 合计,TimeSectID as 班次 from product"
+ sSql, Conn);
Conn.Open();
DataSet ds = new DataSet();
adapter.Fill(ds);
GridView1.DataSource
... {
this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script
language='javascript'>alert('" + msg + "');</script>");
}
public void Bind( string sSql) // 绑定事件
... {
Conn = new SqlConnection(sConnString);
SqlDataAdapter adapter = new SqlDataAdapter("select id,productTime as 生产日期,productLineId as
生产线ID,DataType as 数据类型,productNameId as 产品名称ID,Side as 面次,productIn as 进数," +
"productOut as 出数,productEye as 人工,productNum as 合计,TimeSectID as 班次 from product"
+ sSql, Conn);
Conn.Open();
DataSet ds = new DataSet();
adapter.Fill(ds);
GridView1.DataSource