这是一段完整的gridview操作代码，你自己好好看下吧，各位高手们也请指教下
protected void Changing(object sender,GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
bind(strCon);
}
protected void Download(object sender, GridViewCommandEventArgs e)
{
int id = 0;
if (e.CommandName == "download")
{
id = System.Convert.ToInt32(e.CommandArgument.ToString());
string strSql = "select filepath from normal_info_deploy where info_id = " + ((Label)GridView1.Rows[id].Cells[0].FindControl("NoItem")).Text;
if (ConnectDB() == "0")
{
SqlCommand sqlCmd = conn.CreateCommand();
sqlCmd.CommandText = strSql;
SqlDataReader thisReader = sqlCmd.ExecuteReader();
string tempvar = "";
try
{
while (thisReader.Read())
{
tempvar = thisReader[0].ToString();
}
thisReader.Close();
}
catch
{
thisReader.Close();
}
string name = Server.MapPath(tempvar);
string[] filename = name.Split('\\');
//name += "." +
FileInfo aFile = new FileInfo(name);
if (File.Exists(name))
{
//构建html表头
Response.Clear();
Response.ClearHeaders();
Response.BufferOutput = false;
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.ContentType = "application/octet-stream";
Response.AppendHeader("Content-disposition", "attachment;filename=" + filename[filename.Length - 1]);
Response.AddHeader("Content-Length", aFile.Length.ToString());
Response.WriteFile(name);
Response.Flush();
Response.End();
}
else
{
Response.Write("<script>alert('服务器未能找到相应文件，请咨询管理员')</script>");
}
}
else
{
Response.Write("<script>alert('与服务器连接失败')</script>");
}
}
else if (e.CommandName == "del")
{
id = System.Convert.ToInt32(e.CommandArgument.ToString());
string strSql = "select filepath from normal_info_deploy where info_id = " + ((Label)GridView1.Rows[id].Cells[0].FindControl("NoItem")).Text;
if (tempdb.ConnectDB() == "0")
{
string Sql;
Sql = "update normal_info_deploy set filepath = '_',deployfilename = '_' where info_id = " + ((Label)GridView1.Rows[id].Cells[0].FindControl("NoItem")).Text;
if (tempdb.ExecuteSql(Sql) == 0)
{
Response.Write("<script>alert('删除成功')</script>");
}
}
else
{
Response.Write("<script>alert('无法连接数据库')</script>");
}
if (ConnectDB() == "0")
{
SqlCommand sqlCmd = conn.CreateCommand();
sqlCmd.CommandText = strSql;
SqlDataReader thisReader = sqlCmd.ExecuteReader();
string tempvar = "";
try
{
while (thisReader.Read())
{
tempvar = thisReader[0].ToString();
}
thisReader.Close();
}
catch
{
thisReader.Close();
}
string name = Server.MapPath(tempvar);
tempdb.DeleteFile(name);
}
bind(strCon);
}
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
bind(strCon);
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
if (tempdb.ConnectDB() == "0")
{
string strSql;
strSql = "delete from normal_info_deploy where info_id = " + GridView1.DataKeys[e.RowIndex].Value.ToString();
if (tempdb.ExecuteSql(strSql) == 0)
{
Response.Write("<script>alert('删除成功')</script>");
}
}
else
{
Response.Write("<script>alert('无法连接数据库')</script>");
}
bind(strCon);
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
bind(strCon);
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
if (tempdb.ConnectDB() == "0")
{
string strSql;
((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].FindControl("tittle"))).Text.ToString();
((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].FindControl("info"))).Text.ToString();
((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].FindControl("deployer"))).Text.ToString();
((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].FindControl("obj"))).Text.ToString();
strSql = "update normal_info_deploy set info_title = '" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].FindControl("tittle"))).Text.ToString() + "'" + "," +
"info_cont = '" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].FindControl("info"))).Text.ToString() + "'," +
"deployer = '" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].FindControl("deployer"))).Text.ToString() + "'," +
"deploy_object = '" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].FindControl("obj"))).Text.ToString() + "' where info_id = " + GridView1.DataKeys[e.RowIndex].Value.ToString();
if (tempdb.ExecuteSql(strSql) == 0)
{
Response.Write("<script>alert('修改成功')</script>");
}
}
}
catch
{
Response.Write("<script>alert('修改失败')</script>");
}
GridView1.EditIndex = -1;
bind(strCon);
}
public void bind(string str)
{
if (tempdb.ConnectDB() == "0")
{
string strCondition = str;
DataSet set = new DataSet();
set = tempdb.GetNormalDeployInfo(strCondition);
GridView1.DataSource = set;
GridView1.DataKeyNames = new string[] { "info_id" };
GridView1.DataBind();
int j = 0;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
if (set.Tables[0].Rows[i].ItemArray[10].ToString() == "_")
{
((LinkButton)GridView1.Rows[i].FindControl("download")).Visible = false;
((LinkButton)GridView1.Rows[i].FindControl("delete")).Visible = false;
}
if (set.Tables[0].Rows[i].ItemArray[10].ToString() == null || set.Tables[0].Rows[i].ItemArray[10].ToString() == "")
{
break;
}
}
}
}
}
