本编程时C#对数据库的操作。
详细步骤和注释。
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.SqlClient; namespace ConsoleApplication2 { class Program { static void Main(string[] args) { #region//修改 //打开数据库连接 string sqlsercon = "Data Source=PC-201209231029;Initial Catalog=qaz;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", "14236554615481538"); cmd.ExecuteNonQuery(); cmd.Dispose();//释放资源 con.Close();//关闭与数据库的链接 con.Dispose(); Console.WriteLine("修改成功"); #endregion #region//插入 /* string sqlsercon = "Data Source=PC-201209231029;Initial Catalog=qaz;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", "xingxin"); cmd.Parameters.AddWithValue("Password", "777777"); cmd.Parameters.AddWithValue("RealName", "张三"); cmd.Parameters.AddWithValue("Mobile", "13888888888"); cmd.Parameters.AddWithValue("Address", "河北秦皇岛北戴河边"); cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); con.Dispose(); Console.WriteLine("成功插入一行"); */ #endregion #region 删除 /* string sqlsercon = "Data Source=PC-20130723IUDE;Initial Catalog=MyTest;User ID=sa;Password=yhb@163"; SqlConnection con = new SqlConnection(sqlsercon); con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "delete from T_User where Id=1"; cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); con.Dispose(); Console.WriteLine("删除成功"); */ #endregion Console.ReadKey() ; } } }
数据库的插入删除查询修改
向表中插入数据
insert into 表名(,,) values(,,);
insert into 表名 value是(,,);
删除数据
delect from 表名 where 条件
如删除所有记录则 delect from 表名
修改数据
update 表名 set 列表名 =值 where 条件
查询语句
select * from 表名
select 值,值 from 表名
select * from where 值
C#连接数据库代码和注释与数据库的应用
最新推荐文章于 2020-04-24 10:10:20 发布