Question

请问这段程序的最核心代码是哪一部分，我看不懂，求解释呀~

public partial class Managehuo : System.Web.UI.Page
{
protectedvoid Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
gridviewBind();
}
}
//gridview绑定
private voidgridviewBind()
{
String str= "select huoID,huoName,huoDanwei,cfck,rkdw,ckdw,yskc+isnull((selectSUM(shuliang) from ruku where ruku.huoName=huopin.huoName group byhuoName),0)"
+" -isnull((select SUM(shuliang) from chuku where chuku.huoName=huopin.huoNamegroup by huoName),0) as kc,dixian,gaoxian from huopin order by huoID desc";
SqlConnection scon = newSqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
scon.Open();
SqlDataAdapter dbAdapter = new SqlDataAdapter(str, scon);
DataSetds = new DataSet();
dbAdapter.Fill(ds);
scon.Close();
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataKeyNames = new string[] { "huoID" };
GridView1.DataBind();
}
////f分页
protectedvoid GridView1_PageIndexChanging1(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataBind();
gridviewBind();
}
protectedvoid GridView1_RowDeleting(object sender, GridViewDeleteEventArgse)
{
stringss = "delete from huopin where huoID='" +this.GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
SqlConnection scon = newSqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
scon.Open();
SqlCommand scmd = new SqlCommand(ss, scon);
scmd.ExecuteNonQuery();
scon.Close();
GridView1.DataBind();
gridviewBind();
}
protectedvoid Button1_Click(object sender, EventArgs e)
{
stringstr = "select huoID,huoName,huoDanwei,cfck,rkdw,ckdw,yskc,dixian,gaoxianfrom huopin where yskc<dixian order by huoID desc";
SqlConnection scon = newSqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
scon.Open();
SqlDataAdapter dbAdapter = new SqlDataAdapter(str, scon);
DataSet ds = new DataSet();
dbAdapter.Fill(ds);
scon.Close();
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataKeyNames = new string[] { "huoID" };
GridView1.DataBind();
}
protectedvoid Button2_Click(object sender, EventArgs e)
{
stringstr = "select huoID,huoName,huoDanwei,cfck,rkdw,ckdw,yskc,dixian,gaoxianfrom huopin where yskc>gaoxian order by huoID desc";
SqlConnection scon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
scon.Open();
SqlDataAdapter dbAdapter = new SqlDataAdapter(str, scon);
DataSetds = new DataSet();
dbAdapter.Fill(ds);
scon.Close();
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataKeyNames = new string[] { "huoID" };
GridView1.DataBind();

Answer 1

代码没什么重不重点吧，少1句也可能运行不了。下面简略做了注释。哪句不明白的就再说吧

public partial class Managehuo : System.Web.UI.Page
{
protectedvoid Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
gridviewBind();//引用下面的绑定方法
}
}
//gridview绑定
private voidgridviewBind()
{
String str= "select huoID,huoName,huoDanwei,cfck,rkdw,ckdw,yskc+isnull((selectSUM(shuliang) from ruku where ruku.huoName=huopin.huoName group byhuoName),0)"
+" -isnull((select SUM(shuliang) from chuku where chuku.huoName=huopin.huoNamegroup by huoName),0) as kc,dixian,gaoxian from huopin order by huoID desc";
SqlConnection scon = newSqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
scon.Open();
SqlDataAdapter dbAdapter = new SqlDataAdapter(str, scon);
DataSetds = new DataSet();
dbAdapter.Fill(ds);//查出数据填充到dataset中
scon.Close();
GridView1.DataSource = ds.Tables[0].DefaultView;//把gridview的数据源绑定为上面获取的的dataset表
GridView1.DataKeyNames = new string[] { "huoID" };//设置gridview的主键
GridView1.DataBind();
}
////f分页
protectedvoid GridView1_PageIndexChanging1(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataBind();
gridviewBind();
}
//删除行
protectedvoid GridView1_RowDeleting(object sender, GridViewDeleteEventArgse)
{
stringss = "delete from huopin where huoID='" +this.GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
SqlConnection scon = newSqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
scon.Open();
SqlCommand scmd = new SqlCommand(ss, scon);
scmd.ExecuteNonQuery();//执行删除
scon.Close();
GridView1.DataBind();
gridviewBind();//重新绑定数据源
}

//选出符合条件的行出来，现实到gridview中
protectedvoid Button1_Click(object sender, EventArgs e)
{
stringstr = "select huoID,huoName,huoDanwei,cfck,rkdw,ckdw,yskc,dixian,gaoxianfrom huopin where yskc<dixian order by huoID desc";
SqlConnection scon = newSqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
scon.Open();
SqlDataAdapter dbAdapter = new SqlDataAdapter(str, scon);
DataSet ds = new DataSet();
dbAdapter.Fill(ds);
scon.Close();
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataKeyNames = new string[] { "huoID" };
GridView1.DataBind();
}
//选出符合的行出来在gridview中显示
protectedvoid Button2_Click(object sender, EventArgs e)
{
stringstr = "select huoID,huoName,huoDanwei,cfck,rkdw,ckdw,yskc,dixian,gaoxianfrom huopin where yskc>gaoxian order by huoID desc";
SqlConnection scon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
scon.Open();
SqlDataAdapter dbAdapter = new SqlDataAdapter(str, scon);
DataSetds = new DataSet();
dbAdapter.Fill(ds);
scon.Close();
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataKeyNames = new string[] { "huoID" };
GridView1.DataBind();