ADO.net增删改的使用
添加数据
--------------------------------------------------
//让用户输入要添加的内容
Console.WriteLine("请输入要添加的代号:");
string code = Console.ReadLine();
Console.WriteLine("请输入姓名:");
string name = Console.ReadLine();
Console.WriteLine("请输入性别:");
bool sex = Console.ReadLine()=="男"?true:false;
Console.WriteLine("请输入民族:");
string nation = Console.ReadLine();
Console.WriteLine("请输入生日:");
string birthday = Console.ReadLine();
string nationcode = "n001";
//将民族名称转为名族代号
SqlConnection conn = new SqlConnection("server=.;database=mydb;user=sa;pwd=123");
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select Code from Nation where Name = '"+nation+"'";
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
nationcode = dr[0].ToString();
}
conn.Close();
//往Info表添加数据
cmd.CommandText = "insert into Info values('"+code+"','"+name+"','"+sex+"','"+nationcode+"','"+birthday+"')";
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
Console.WriteLine("添加成功!");
Console.ReadLine();
------------------------------------------------------
删除数据
----------------------------------------------------------------
//用户输入要删除的数据主键值
Console.WriteLine("请输入要删除的代号:");
string code = Console.ReadLine();
//判断该数据存不存在
SqlConnection conn = new SqlConnection("server=.;database=mydb;user=sa;pwd=123");
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from Info where Code='"+code+"'";
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
//说明该数据存在
Console.WriteLine("查到该数据,是否要执行删除操作,如果要删除请输入:1");
int sc = Convert.ToInt32(Console.ReadLine());
if (sc == 1)
{
//删除
dr.Close(); //关闭读取器
cmd.CommandText = "delete from Info where Code='"+code+"'";
cmd.ExecuteNonQuery();
Console.WriteLine("删除成功!");
}
else
{
//不删除
dr.Read();
string sex = Convert.ToBoolean(dr[2])?"男":"女";
string nation = MinZu(dr[3].ToString());
string str = "代号:"+dr[0]+"\t姓名:"+dr[1]+"\t性别:"+sex+"\t民族:"+nation+"\t生日:"+dr[4];
Console.WriteLine(str);
}
}
else
{
//数据不存在
Console.WriteLine("输入的代号错误!");
}
conn.Close();
Console.ReadLine();
}
static string MinZu(string code)
{
string name="";
SqlConnection conn = new SqlConnection("server=.;database=mydb;user=sa;pwd=123");
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select Name from Nation where Code = '" + code + "'";
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
name = dr[0].ToString();
}
conn.Close();
return name;
----------------------------------------------------------------
修改数据
将cmd.commandtext语句改为需要update语句即可
最新文章
- JDK1.7 HashMap 源码分析
- vsftp配置参数
- 《编写高质量代码--Web前端开发修炼之道》读书笔记
- windows phone使用sharpcompress进行解压压缩文件
- 【JQuery Plugin】WdatePicker
- 攻略三战的完美体验3Castle Fantisia阿兰·梅希亚战争艾伦西战记它包含重做版本(这是新的艾伦·梅希亚大战)
- EasyMonkeyDevice vs MonkeyDevice&;HierarchyViewer API Mapping Matrix
- Linux下部署tomcat
- Luogu P1894 [USACO4.2]The Perfect Stall
- 大数据平台Lambda架构详解
- BUAAOO P1-P3 Expression Dirivation
- 《Pro SQL Server Internals, 2nd edition》15w
- 《c#图解教程》
- 了解fastadmin标准的控制器模块js的表格事件
- Linux第八章:文件,文件系统的压缩,打包备份
- 图书管理(Loj0034)+浅谈哈希表
- POJ 3320	Jessica's Reading Problem (尺取法)
- Django 的逆向解析url--reverse(转)
- JAVA常识1
- ubuntu安装pgAdmin 4