//Coding by flyso
SqlConnection mySqlConnection = flyso_cs.GetConnection();
SqlCommand mySqlCommand = new SqlCommand("flyso_list", mySqlConnection);
mySqlCommand.CommandType = CommandType.StoredProcedure;
SqlParameter flysoPar;
//数据表名
flysoPar = mySqlCommand.Parameters.Add("@TableName", SqlDbType.VarChar, 30);
mySqlCommand.Parameters["@TableName"].Value = "80NT";
//数据表字段,以","号分隔
flysoPar = mySqlCommand.Parameters.Add("@Field", SqlDbType.VarChar, 200);
mySqlCommand.Parameters["@Field"].Value = "id,flyso";
//查询条件,不需where"
flysoPar = mySqlCommand.Parameters.Add("@Condition", SqlDbType.VarChar, 500);
mySqlCommand.Parameters["@Condition"].Value = "url='www.flyso.cn'";
//显示记录数
flysoPar = mySqlCommand.Parameters.Add("@dispnum", SqlDbType.VarChar, 150);
mySqlCommand.Parameters["@dispnum"].Value = this.dispnum;
//排序字段 不需要加Order By
flysoPar = mySqlCommand.Parameters.Add("@Order", SqlDbType.VarChar, 50);
mySqlCommand.Parameters["@Order"].Value = "flyso_id desc";
mySqlConnection.Open();
Repeater1.DataSource = mySqlCommand.ExecuteReader();
Repeater1.DataBind();
mySqlConnection.Close();