数据库连接

来源：互联网发布：windows 7 64 sp1补丁编辑：程序博客网时间：2024/06/03 13:03

今天说下c#程序怎么连接数据库

程序访问数据库的步骤：

具体代码例子

namespace Arraylist

{

class Person

{

private string name;

private string password;

private int id;

public string Name { set; get; }

public string Password { set; get; }

public string Id { set; get; }

}

class DataBase

{

public void Get()

{

SqlConnection con = new SqlConnection("server=.;Trusted_Connection=SSPI;database=cwh");

con.Open();

SqlCommand com = new SqlCommand("select*from T_cwh", con);

// con.Open();

SqlDataReader reader = com.ExecuteReader();

while (reader.Read())

{

Console.WriteLine("{0}{1}{2}",reader.GetValue(0),reader.GetValue(1),reader.GetValue(2));

}

reader.Close();

con.Close();

}

public List<Person> selectList()

{

List<Person> list = new List<Person>();

SqlConnection con1 = new SqlConnection("server =.;Trusted_Connection=SSPI;database=cwh");

con1.Open();

SqlCommand com1 = new SqlCommand("select * from T_cwh",con1);

SqlDataReader reader1 = com1.ExecuteReader();

while(reader1.Read())

{

Person p = new Person();

p.Name = reader1.GetValue(0) + "";

p.Password = reader1.GetValue(1) + "";

p.Id = reader1.GetValue(2) + "";

list.Add(p);

}

reader1.Close();

con1.Close();

return list;

}

public int insert(){

SqlConnection con2 = new SqlConnection("server =.;Trusted_Connection=SSPI;database=cwh");

con2.Open();

string a = "insert into T_cwh(name,password) values('王五','789')";

SqlCommand com2 = new SqlCommand(a, con2);

int count = com2.ExecuteNonQuery();

return count;

}

public static void Main(string[] args)

{

DataBase S = new DataBase();

//List<Person> list1 = S.selectList();

//foreach (Person p1 in list1)

//{

// Console.WriteLine(p1.Id+" "+p1.Name+" "+p1.Password);

//}

//List<Person> list2 = S.selectList();

//IEnumerator<Person> it = list2.GetEnumerator();

//while (it.MoveNext())

//{

// Console.WriteLine(it.Current.Id + " " +it.Current.Name+" "+it.Current.Password);

//}

int a= S.insert();

Console.WriteLine(a);

}

0 0