C# 调用存储过程并绑定Repeater

时间:2015/11/23 14:42:00来源:互联网 作者:flyso 点击: 1101 次

//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();

Copyright © 2005 - 2016 flyso.cn. 飞搜 版权所有 鄂ICP备11002783号-3