今天老师讲了游戏商城的项目,里边的项目都是套用一些有关增,减,删,改的方法,我也知道了这四个方法的重要性,下面是我学会的四个方法,希望对大家有所帮助
查方法连接数据库:
List<Userss> list = new List<Userss>();
public List<Userss> select()
{
SqlConnection con = new SqlConnection("server=.;Trusted_Connection=SSPI;database=student");
con.Open();
SqlCommand cmd = new SqlCommand("select * from student");
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read()) {
Userss s = new Userss();
s.Id = (int)reader.GetValue(0);
s.Name = (string)reader.GetValue(1);
list.Add(s);
}
return list;
}
增方法连接数据库
public int insert(string name)
{
SqlConnection con = new SqlConnection("server=.;Truseted_Connection=SSPI;datebase=student");
con.Open ();
SqlCommand cmd =new SqlCommand ("insert into student values ('"+name+"')");
int i=cmd.ExecuteNonQuery();
return i;
}
删方法连接数据库
public int delete(int id)
{
SqlConnection con = new SqlConnection("server=.;Trusted_Connection=SSPI;datebase=student");
con.Open ();
SqlCommand cmd=new SqlCommand ("delete from student where id="+id+"");
int i = cmd.ExecuteNonQuery();
return i;
}
改方法连接数据库
public int update(string name, int id)
{
SqlConnection con = new SqlConnection("server=.;Trusted_Connection=SSPI;datebase=student");
con.Open();
SqlCommand cmd = new SqlCommand("update student set name='" + name + "' where id=" + id + "");
int i = cmd.ExecuteNonQuery();
return i;
}
连接数据库的时候一定要在命名空间前边加两行
using System.Data;
using System.Data.SqlClient;
Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE 更多精彩关注: http://www.gopedu.com/
查方法连接数据库:
List<Userss> list = new List<Userss>();
public List<Userss> select()
{
SqlConnection con = new SqlConnection("server=.;Trusted_Connection=SSPI;database=student");
con.Open();
SqlCommand cmd = new SqlCommand("select * from student");
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read()) {
Userss s = new Userss();
s.Id = (int)reader.GetValue(0);
s.Name = (string)reader.GetValue(1);
list.Add(s);
}
return list;
}
增方法连接数据库
public int insert(string name)
{
SqlConnection con = new SqlConnection("server=.;Truseted_Connection=SSPI;datebase=student");
con.Open ();
SqlCommand cmd =new SqlCommand ("insert into student values ('"+name+"')");
int i=cmd.ExecuteNonQuery();
return i;
}
删方法连接数据库
public int delete(int id)
{
SqlConnection con = new SqlConnection("server=.;Trusted_Connection=SSPI;datebase=student");
con.Open ();
SqlCommand cmd=new SqlCommand ("delete from student where id="+id+"");
int i = cmd.ExecuteNonQuery();
return i;
}
改方法连接数据库
public int update(string name, int id)
{
SqlConnection con = new SqlConnection("server=.;Trusted_Connection=SSPI;datebase=student");
con.Open();
SqlCommand cmd = new SqlCommand("update student set name='" + name + "' where id=" + id + "");
int i = cmd.ExecuteNonQuery();
return i;
}
连接数据库的时候一定要在命名空间前边加两行
using System.Data;
using System.Data.SqlClient;
Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE 更多精彩关注: http://www.gopedu.com/