ado.net入门-优快云博客

本文详细介绍了使用C#进行SQL数据库操作的方法，包括连接字符串配置、查询行数、插入数据、更新记录以及获取结果集的具体实现。通过实际代码示例，展示了如何使用SqlConnection、SqlCommand等对象执行SQL语句。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

            //1.0连接字符串
            string conStr = "Data Source=.;Initial Catalog=test;User ID=sa;Password='qwertyu'";
            //2.0返回第行第一列结果
            using (SqlConnection conn = new SqlConnection(conStr))
            {
                string sqlStr = @"select count(1) from sys_users where deleteflag =0";
                conn.Open();
                SqlCommand command = new SqlCommand(sqlStr, conn);
                int result = Convert.ToInt32(command.ExecuteScalar());
            }

            //3.0返回第行第一列结果
            using (SqlConnection conn = new SqlConnection(conStr))
            {
                string sqlStr = @"insert into sys_users (ID,Name,Age) values(100,'12334efdgdfg',13)";
                //string sqlStr = @"insert into sys_users values(100,'12334efdgdfg',13,0)";
                //update Sys_Users set Name='pppppppppp' where ID=1
                conn.Open();
                SqlCommand command = new SqlCommand(sqlStr, conn);
                int result = Convert.ToInt32(command.ExecuteNonQuery());
            }


            //4.0返回结果集
            SqlDataAdapter da = new SqlDataAdapter("select name from Sys_Users  where DeleteFlag=0;select age from Sys_Users  where DeleteFlag=0", conStr);
            DataSet ds = new DataSet();
            da.Fill(ds);

转载于:https://www.cnblogs.com/junhuang/p/9410780.html