Question

关于vs05 的gridview使用

public partial class _Default : System.Web.UI.Page

{

OleDbConnection sqlcon;

OleDbCommand sqlcom;

// string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+server.mappath("."+\dbdb\global.mdb) ;

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)
{

bind();

}

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

GridView1.EditIndex = e.NewEditIndex;

bind();

}

//删除

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

try
{
string sqlstr = "delete from grade where 学号=" + GridView1.DataKeys[e.RowIndex].Value.ToString();
Response.Write("<script language=javascript>alert('成功删除！')</script>");

sqlcon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;"+"Data Source="+Server.MapPath("person.mdb"));

sqlcom = new OleDbCommand(sqlstr,sqlcon);

sqlcon.Open();

sqlcom.ExecuteNonQuery();

sqlcon.Close();

bind();

}
catch (Exception ex)
{
Response.Write(ex.Message);
Response.Write("<script language=javascript>alert('删除失败！')</script>");
}

}

Answer 1

private void bind()
{
sqlcon = new OleDbConnection (strCon );
sqlcom = new OleDbCommand ("Select * From grade",sqlcon );
sqlcon.Open();
OleDbDataReader dr = sqlcom.ExecuteReader();
GridView1.DataSource = dr;
GridView1.DataKeyNames = new string[]{"学号"};
GridView1.DataBind();
dr.Close();
sqlcon.Close();

}

Answer 2

看不懂

Answer 3

你的bind方法在哪？