using (SqlConnection sqlCnn = new SqlConnection(str))
{
SqlDataAdapter da = new SqlDataAdapter("sp_Student_Select_by_Page_rowNumber", sqlCnn);
da.SelectCommand.Parameters.AddWithValue("@pageIndex", pageindex);
da.SelectCommand.Parameters.Add("@pageCount", SqlDbType.Int).Direction = ParameterDirection.Output;
da.SelectCommand.Parameters.AddWithValue("@pageSize", 2);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
DataSet ds = new DataSet();
da.Fill(ds);
this.DataList1.DataSource = ds.Tables[0].DefaultView;
this.DataList1.DataBind();
this.HiddenField1.Value = pageindex;
this.HiddenField2.Value = da.SelectCommand.Parameters["@pageCount"].Value.ToString();
}
Datalist通过代码实现数据库的绑定以及删除、编辑分页等效果
没有使用数据源控件
protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)
{
string name = (e.Item.FindControl("TextBox1") as TextBox).Text;
string sex = (e.Item.FindControl("TextBox2") as TextBox).Text;
string age = (e.Item.FindControl("TextBox3") as TextBox).Text;
string str = ConfigurationManager.ConnectionStrings["studentCnn"].ConnectionString;
using (SqlConnection sqlCnn = new SqlConnection(str))
{
SqlCommand sqlcmm = sqlCnn.CreateCommand();
sqlcmm.CommandText = "update student set sname=@sname,sex=@sex,age=@age where sid=@sid";
sqlcmm.Parameters.AddWithValue("@sname", name);
sqlcmm.Parameters.AddWithValue("@sex", sex);
sqlcmm.Parameters.AddWithValue("@age", age);
sqlcmm.Parameters.AddWithValue("@sid", e.CommandArgument);
sqlCnn.Open();
sqlcmm.ExecuteNonQuery();
}