sql查询两种写法

最新推荐文章于 2022-01-22 17:44:25 发布

楚兴

最新推荐文章于 2022-01-22 17:44:25 发布

阅读量1.3k

点赞数

分类专栏： C# 文章标签： sql

本文链接：https://blog.csdn.net/foreverling/article/details/26263311

版权

C# 专栏收录该内容

21 篇文章 1 订阅

订阅专栏

写法一：

            string sql = "select * from tbColumns";
            using (SqlConnection conn = new SqlConnection(PubVarData.ConnectionString))
            {
                conn.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = conn;
                cmd.CommandText = sql;
                cmd.CommandType = CommandType.Text;
                using (SqlDataAdapter adapter = new SqlDataAdapter())
                {
                    adapter.SelectCommand = cmd;
                    DataSet ds = new DataSet();
                    adapter.Fill(ds);

                    string jSon = DataConvertHelper.convertDataTableToString(ds.Tables[0]);
                    return jSon;
                }
            }

写法二：

            string sql = "select * from tbColumns";
            using (SqlConnection conn = new SqlConnection(PubVarData.ConnectionString))
            {
                conn.Open();
                using (SqlCommand cmd = new SqlCommand { Connection = conn, CommandText = sql, CommandType = CommandType.Text })
                {
                    using (SqlDataAdapter adapter = new SqlDataAdapter { SelectCommand = cmd })
                    {
                        using (DataSet ds = new DataSet())
                        {
                            adapter.Fill(ds);
                            string jSon = DataConvertHelper.convertDataTableToString(ds.Tables[0]);
                            return jSon;
                        }
                    }
                }
            }