C#数据库开发

来源：互联网发布：svn server linux下载编辑：程序博客网时间：2024/04/30 06:27

C#数据库开发之SQL Server 2005在当今信息高速的时代  信息就是money  信息数据的处理就显得尤为重要了  所以希望能给你一点帮助using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SqlClient;using System.Data;namespace ConsoleApplication1{    class Program    {        static void Main(string[] args)        {            SqlConnection sqlConn = new SqlConnection();            try            {                sqlConn.ConnectionString = "Data Source=.\\SQLEXPRESS; AttachDbFilename = D:\\student.mdf; Integrated Security = True;Connect Timeout=30;User Instance=True";                sqlConn.Open();                Console.WriteLine("连接成功");                //插入一条数据                SqlCommand sqlCmd = new SqlCommand();                sqlCmd.Connection = sqlConn;                sqlCmd.CommandText = "insert into student values('0006', '孙西', '女', 20, '英语')";                sqlCmd.ExecuteNonQuery();                //读出所有数据                string queryString = "Select * from student ";                SqlCommand sqlCommand = new SqlCommand(queryString, sqlConn);                SqlDataReader read = sqlCommand.ExecuteReader();                while (read.Read())                {                    Console.WriteLine(read["number"] + " " + read["name"] + " " + read["sex"] + " " + read["age"] + "    " + read["special"]);                }                read.Close();                //单值查询                string queryString1 = "Select * from student where number = '";                Console.Write("请输入要查询的学号：");                string searchNumberValue1 = System.Console.ReadLine();                queryString1 += searchNumberValue1 + "'";                SqlCommand sqlCommand1 = new SqlCommand(queryString1, sqlConn);                SqlDataReader read1 = sqlCommand1.ExecuteReader();                while (read1.Read())                {                    Console.WriteLine(read1["number"] + " " + read1["name"] + " " + read1["sex"] + " " + read1["age"] + " " + read1["special"]);                }                read1.Close();                //删除一条数据                string queryString2 = "Delete student where number = '";                Console.Write("请输入要删除的学号：");                string searchNumberValue2 = System.Console.ReadLine();                queryString2 += searchNumberValue2 + "'";                SqlCommand sqlCommand2 = new SqlCommand(queryString2, sqlConn);                sqlCommand2.ExecuteNonQuery();                Console.WriteLine("成功删除学号为：" + searchNumberValue2 + "的数据");                //数据更新                string operateString = "Update student set age =@age where number =@number";                Console.Write("请输入要更新年龄的学号：");                string searchNumberValue3 = System.Console.ReadLine();                SqlParameter paramNumber = new SqlParameter("@number", SqlDbType.NChar);                paramNumber.Value = searchNumberValue3;                Console.Write("请输入要更新的年龄：");                string searchAgeValue3 = System.Console.ReadLine();                SqlParameter paramAge = new SqlParameter("@age", SqlDbType.Int);                paramAge.Value = Convert.ToInt16(searchAgeValue3);                SqlCommand sqlCommand3 = new SqlCommand(operateString, sqlConn);                sqlCommand3.Parameters.Add(paramNumber);                sqlCommand3.Parameters.Add(paramAge);                                sqlCommand3.ExecuteNonQuery();                Console.WriteLine("更新操作成功");            }            catch (Exception ex)            {                Console.WriteLine("连接失败！");                Console.WriteLine("错误为：" + ex.Message);            }            finally            {                sqlConn.Close();                Console.WriteLine("连接已关闭！");            }        }    }}运行结果

由于是截图时自己没有注意  截的是两个不同的运行图  所以你看到的0007数据没有被删除掉  上面的代码没有问题  如果你自己拷贝去运行  注意每次运行把插入的数据变动一下（设了主键  不能插入重复的数据）

0 0