本编程时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() ; } }}using Syste 
