1.查询方法
class a{
List <users>List=new List<users>();
public List<users> select(){
sqlconntion con=new sqlconntion("server=.;database=gameMarket;Trusted_Connection=SSPI");
con.open();
sqlcommand y=new sqlcommand(sql,con);
SqlDataReader reader = sc.ExecuteReader();
while (reader.Read()) {
Users u = new Users();
u.Id =(int) reader.GetValue(0);
u.Name = (string)reader.GetValue(1);
list.Add(u);
}
return list;
}
2.增(插入)的操作
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;
}
3.删的操作
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;
}
4.改(更新)的操作
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;
}