conn = new SqlConnection();
//接收到传递过来的stuGuid
try
{
conn = DBHelp.conn;
cmd = new SqlCommand("HM_ShowCXHInfo", conn);
//cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@pagesize", 16);
cmd.Parameters.AddWithValue("@AlreadyShowNum", numTotal);
//conn.Open();
//cmd.ExecuteNonQuery();
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
this.GridView1.DataSource = dt;
this.GridView1.DataBind();
}
catch (Exception ex)
{
this.Response.Write("<script type='text/javascript'>alert('" + ex.Message + "')</scirpt>");
}
finally
{
//conn.Close();
}
//接收到传递过来的stuGuid
try
{
conn = DBHelp.conn;
cmd = new SqlCommand("HM_ShowCXHInfo", conn);
//cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@pagesize", 16);
cmd.Parameters.AddWithValue("@AlreadyShowNum", numTotal);
//conn.Open();
//cmd.ExecuteNonQuery();
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
this.GridView1.DataSource = dt;
this.GridView1.DataBind();
}
catch (Exception ex)
{
this.Response.Write("<script type='text/javascript'>alert('" + ex.Message + "')</scirpt>");
}
finally
{
//conn.Close();
}