求C#中的连接数据库的代

求C#中的连接数据库的代码

答案：create database test
go
use test
go
create table term
(
 tid int primary key,
 tname varchar(10)
)
go
------------------------------
create table course
(
 cid int primary key,
 cname varchar(50) not null,
 tid int references term(tid)
)
go
-------------------------------
insert into term
values(1,'第一学期')
insert into term
values(2,'第二学期')
insert into term
values(3,'第三学期')
-------------------------------
insert into course
values(1,'软件技术基础',1)
insert into course
values(2,'程序设计基础',1)
insert into course
values(3,'数据库基础',1)
insert into course
values(4,'Window开发基础',1)
insert into course
values(5,'网页编程',1)
insert into course
values(6,'Oracle数据库',2)
insert into course
values(7,'面向对象程序设计',2)
insert into course
values(8,'Java Web开发',2)
insert into course
values(9,'C#程序设计',2)
insert into course
values(10,'Window高级开发',2)
--------------------------------
select * from term
select * from course
 
 
SqlConnection cn = 
            new SqlConnection(@"server=.\SQLEXPRESS;database=test;uid=sa;pwd=;");
            SqlCommand cmd = 
                new SqlCommand("select * from term",cn);
            // CommandText,Connection
            cn.Open();
            SqlDataReader reader = cmd.ExecuteReader();
            while(reader.Read()){
                list.Add(reader.GetInt32(0));
                Console.WriteLine(reader.GetString(1));
            }
            reader.Close();
            for (int i = 0; i < list.Count; i++) {
                string sql = 
                    "select cname from course where tid=" + list[i];
                cmd.CommandText = sql;
                reader = cmd.ExecuteReader();
                while (reader.Read()) {
                    Console.WriteLine(reader.GetString(0));
                }
                reader.Close();
            }
            cn.Close();
 
什么数据库？
 

上一个：C#语言Java语言那个好学点？
下一个：C#编写的存储过程 要源码