SqlDataReader对象使用例子

最新推荐文章于 2020-11-30 16:52:43 发布

tuwen

最新推荐文章于 2020-11-30 16:52:43 发布

阅读量1.3k

点赞数

文章标签： string mysql server each cmd

本文链接：https://blog.csdn.net/tuwen/article/details/2003202

版权

SqlDataReader对象使用例子

if(!this.IsPostBack )

   {

    SqlConnection con=new SqlConnection( "server=.;database=MsgBoard;uid=sa;pwd=sa");

    con.Open();

    string mysql="select * from MsgBoard";

    SqlCommand cmd=new SqlCommand(mysql,con);

    cmd.Connection=con;

    //Command对象的ExecuteReader方法,返回值为SqlDataReader

    SqlDataReader sdr = cmd.ExecuteReader();

    while (sdr.Read())

    {

     // get the results of each column

     string Name = (string)sdr["MsgWriter"];

     string Content = (string)sdr["MsgContent"];

     string MyTime    = (string)sdr["MsgTime"];

     // print out the results

     this.lblWriter.Text=Name.ToString();

     this.tetContent.Text =Content.ToString();

     this.lblTime.Text=MyTime;

    }

con.Close();

}