数据库操作

来源：互联网发布：适用于mac的办公软件编辑：程序博客网时间：2024/05/21 21:39

数据库与vs的连接，操作vs代码，使数据库内的数据实现增加，查询，删除，改动。

namespace 查询
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("请输入您要找的人的名字");
            string name = Console.ReadLine();
            string sqlsercon = "Data Source=WIN-80HN7P0RL9Q;Initial Catalog=texts;Persist Security Info=True;User ID=sa;Password=abcdef";
            SqlConnection con = new SqlConnection(sqlsercon);
            con.Open();
            SqlCommand cmd = con.CreateCommand();
            cmd.CommandText = "select * from T_User where RealName=@realname ";
            cmd.Parameters.AddWithValue("@realname", name);
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            DataTable d = new DataTable();
            adapter.Fill(d);
            cmd.Dispose();
            con.Close();
            con.Dispose();
            string RealName = "";
            string UserName = "";
            string Card = "";
            string Address = "";
            for (int i = 0; i < d.Rows.Count; i++)
            {
                RealName = d.Rows[0][2].ToString();
                UserName = d.Rows[0][0].ToString();
                 Card=d.Rows[0][5].ToString();
                 Address=d.Rows[0][4].ToString();
           Console.WriteLine("这个人的姓名是：{0}，昵称是:{1},身份证号:{2},住址:{3}",RealName,UserName,Card,Address);

           }
        Console.ReadKey();

查询

namespace 修改
{
    class Program
    {
        static void Main(string[] args)
        {
            string sqlsercon = "Data Source=WIN-80HN7P0RL9Q;Initial Catalog=texts;Persist Security Info=True;User ID=sa;Password=abcdef";
            SqlConnection con = new SqlConnection(sqlsercon);
            con.Open();
            SqlCommand cmd = con.CreateCommand();
            cmd.CommandText = "update T_User set Card=@card where Id=6";
            cmd.Parameters.AddWithValue("@card", "130988777788886666");
            cmd.ExecuteNonQuery();
            cmd.Dispose();
            con.Close();
            con.Dispose();
            Console.WriteLine("修改成功");
            Console.ReadKey();
        }
    }
}

修改

class Program
    {
        static void Main(string[] args)
        {
            string sqlsercon = " Data Source=WIN-80HN7P0RL9Q;Initial Catalog=texts;Persist Security Info=True;User ID=sa;Password=abcdef";
            SqlConnection con = new SqlConnection(sqlsercon);
            con.Open();
            SqlCommand cmd = con.CreateCommand();
            cmd.CommandText = "insert into T_User(UserName,password,RealName,Mobile,Address)values(@username,@password,@realname,@mobile,@Address)";
            cmd.Parameters.AddWithValue("@username", "nicai");
            cmd.Parameters.AddWithValue("@password", "abcdef");
            cmd.Parameters.AddWithValue("@realname", "你猜");
            cmd.Parameters.AddWithValue("@mobile", "15044141178");
            cmd.Parameters.AddWithValue("@address", "莲花山池水沟子");
            cmd.ExecuteNonQuery();
            cmd.Dispose();
            con.Close();
            con.Dispose();
            Console.WriteLine("成功插入一行");
            Console.ReadKey();

}
}
}

增加

            cmd.Dispose();
            con.Close();
            con.Dispose();
            Console.WriteLine("已删除");

            Console.ReadKey();
        }
    }
}

删除