C# 连接mssql简单增删改查

   //查询总数
        public void QueryCount() {

            SqlConnection con = new SqlConnection("Server=PC-201807031219;DataBase=test;Trusted_Connection=SSPI");
            try
            {
                con.Open();
                SqlCommand com = new SqlCommand("select count(*) from users", con);

                int x = (int)com.ExecuteScalar();
                Console.WriteLine("现在有几条数据:" + x);

            }
            catch (Exception s)
            {

                Console.WriteLine("错误信息" + s.Message);
            }
            finally
            {

                con.Close();
            }
        }


        public void InsertData() {

            SqlConnection con = new SqlConnection("Server=PC-201807031219;DataBase=test;Trusted_Connection=SSPI");
            try
            {
                con.Open();
                SqlCommand com = new SqlCommand("insert into users(id,name,password) values(@id,@name,@password)", con);
                com.Parameters.AddWithValue("@id",3);
                com.Parameters.AddWithValue("@name","ss");
                com.Parameters.AddWithValue("@password","ss");
                com.ExecuteNonQuery();


                Console.WriteLine("写入成功");

            }
            catch (Exception s)
            {

                Console.WriteLine("错误信息" + s.Message);
            }
            finally
            {

                con.Close();
            }

        }


        public void ModifyData() {


            SqlConnection con= new SqlConnection("Server=PC-201807031219;DataBase=test;Trusted_Connection=SSPI");
            try
            {

                con.Open();
                SqlCommand com = new SqlCommand("update users set id=@id,name=@name,password=@password where id=@value", con);
                com.Parameters.AddWithValue("@id", 5);
                com.Parameters.AddWithValue("@name", "sss");
                com.Parameters.AddWithValue("@password", "sss");
                com.Parameters.AddWithValue("@value",3);
                com.ExecuteNonQuery();


                Console.WriteLine("修改成功");

            }
            catch (Exception s)
            {

                Console.WriteLine("错误信息" + s.Message);
            }
            finally
            {

                con.Close();
            }

        }


        public void DeleteData() {



            SqlConnection con = new SqlConnection("Server=PC-201807031219;DataBase=test;Trusted_Connection=SSPI");
            try
            {

                con.Open();
                SqlCommand com = new SqlCommand("delete from users where id=@id", con);
                com.Parameters.AddWithValue("@id", 5);
   
                com.ExecuteNonQuery();


                Console.WriteLine("删除成功");

            }
            catch (Exception s)
            {

                Console.WriteLine("错误信息" + s.Message);
            }
            finally
            {

                con.Close();
            }

        }