数据库与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();
}
}
}
增加
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 = "delete from T_user where Id=5";
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
con.Dispose();
Console.WriteLine("已删除");
Console.ReadKey();
}
}
}
删除