public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridView();
} }
//数据绑定模块
protected void BindGridView()
{
GridView.DataSource = DB.reDs("Select * From examresult");
GridView.DataBind();
}
......
//数据删除模块
protected void GridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string str_1 = GridView.DataKeys[e.RowIndex].Values[0].ToString(); ;
string delete = "Delete From examresult where StuName=" + str_1 + "";
DB.ExSql(delete);
GridView.EditIndex = -1;
BindGridView();
}
......
/// <summary>
/// Excel导入数据库模块
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnReadDataTo_Click(object sender, EventArgs e)
{
if (FuloadExcelFile.FileName == "")
{
Response.Write("<script>alert('请您选择Excel文件')</script> ");
return;//当无文件时,返回
}
string fileExt = System.IO.Path.GetExtension(FuloadExcelFile.FileName);
if (fileExt != ".xls")//必须是EXCEL文件
{
Response.Write("<script>alert('只可以选择Excel文件')</script>");
return;//当选择的不是Excel文件时,返回
}
SqlConnection cn = DB.GetCon();
cn.Open();
string filename = FuloadExcelFile.FileName;
string filepath = FuloadExcelFile.PostedFile.FileName;//文件路径
FuloadExcelFile.SaveAs(filepath);//SaveAs 将上传的文件内容保存在服务器上
DataTable dt = LinkExcel.Excel(filepath);//返回EXCEL文件的数据DataTable
......
}
}
为什么数据我导入了,而且gridview中也显示了,就是无法进行删除、更新等操作,请各位达人教教。
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridView();
} }
//数据绑定模块
protected void BindGridView()
{
GridView.DataSource = DB.reDs("Select * From examresult");
GridView.DataBind();
}
......
//数据删除模块
protected void GridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string str_1 = GridView.DataKeys[e.RowIndex].Values[0].ToString(); ;
string delete = "Delete From examresult where StuName=" + str_1 + "";
DB.ExSql(delete);
GridView.EditIndex = -1;
BindGridView();
}
......
/// <summary>
/// Excel导入数据库模块
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnReadDataTo_Click(object sender, EventArgs e)
{
if (FuloadExcelFile.FileName == "")
{
Response.Write("<script>alert('请您选择Excel文件')</script> ");
return;//当无文件时,返回
}
string fileExt = System.IO.Path.GetExtension(FuloadExcelFile.FileName);
if (fileExt != ".xls")//必须是EXCEL文件
{
Response.Write("<script>alert('只可以选择Excel文件')</script>");
return;//当选择的不是Excel文件时,返回
}
SqlConnection cn = DB.GetCon();
cn.Open();
string filename = FuloadExcelFile.FileName;
string filepath = FuloadExcelFile.PostedFile.FileName;//文件路径
FuloadExcelFile.SaveAs(filepath);//SaveAs 将上传的文件内容保存在服务器上
DataTable dt = LinkExcel.Excel(filepath);//返回EXCEL文件的数据DataTable
......
}
}
为什么数据我导入了,而且gridview中也显示了,就是无法进行删除、更新等操作,请各位达人教教。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货