与数据库连接从中读取数据的几种常见的形式

最新推荐文章于 2024-11-13 08:56:46 发布

转载最新推荐文章于 2024-11-13 08:56:46 发布 · 128 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/ike_li/archive/2009/10/28/1591451.html

文章标签：

#数据库

1 我们一般执行插入，删除等这些对数据库的操作会影响到数据表的行数，可用以下代码

Code
string strConn = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
        using (SqlConnection conn = new SqlConnection())
        {
            conn.ConnectionString = strConn;
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "insert into TestTable values(name,age)";
            int row = cmd.ExecuteNonQuery();

        }

2.返回查询结果的两种

Code
  string strConn = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
        using (SqlConnection conn = new SqlConnection())
        {
            conn.ConnectionString = strConn;
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "select *from TestTable";
            SqlDataReader dr = cmd.ExecuteReader();
            DataTable dt = new DataTable();
            dt.Load(dr);
            dr.Close();
        }

Code
string strConn = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
        using (SqlConnection conn = new SqlConnection())
        {
            conn.ConnectionString = strConn;
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "select *from TestTable";
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = conn;
            DataSet ds =new  DataSet();
            da.Fill(ds, "data");
           // 这里ds.Tables["data"];里就是查询结果

        }

转载于:https://www.cnblogs.com/ike_li/archive/2009/10/28/1591451.html