SqlDataReader读取数据的代码

最新推荐文章于 2021-01-27 18:31:21 发布

cooledi

最新推荐文章于 2021-01-27 18:31:21 发布

阅读量1.2k

点赞数

分类专栏： c#语法

本文链接：https://blog.csdn.net/cooledi/article/details/53389542

版权

c#语法专栏收录该内容

14 篇文章 0 订阅

订阅专栏

	string sql = "SELECT * FROM table WHERE (D_DealerID=@DealerID and sss=@sid)";
        string connectionStr = "Data Source=127.0.0.1;Initial Catalog=dbName;uid=sa;password=sa123456";
        using (SqlConnection connection = new SqlConnection(connectionStr))
        {
            SqlCommand command = new SqlCommand();
            command.CommandText = sql;
            command.Connection = connection;
            command.Parameters.Add(new SqlParameter("@DealerID", SqlDbType.VarChar)).Value = dealerId;
            command.Parameters.Add(new SqlParameter("@sid", SqlDbType.VarChar)).Value = sid;

            connection.Open();
            using (SqlDataReader reader = command.ExecuteReader())
            {
                while (reader.Read())
                {
                    if (false == reader.IsDBNull(0))
                    {
                        fullName = reader.GetString(0);
                    }
                }
            }
        }

记录一下