Question

c#sql server 读取数据库中最后一行的数据（表Caogao） 然后把字段ID值赋给a

Answer 1

Sqlconnection sqlcon=new Sqlconnection("server=.;database=XXXXXX;uid=;pwd=;");
sqlcon.open();
SqlDataAdapter sda=new SqlDataAdapter ("select * from Caogao ordey by id desc",sqlcon);
dataset ds=new dataset();
sda.fill(ds);
string a=ds.tables[0].rows[0]["ID"].tostring();