int yer=DateTime.Now.Year;
int moon=DateTime.Now.Month;
conn=new SqlConnection("workstation id=ZERG1;packet size=4096;integrated security=SSPI;data source=ZERG1;persist security info=False;initial catalog=Northwind");
string sql="select * from biyesheji where datepart(yyyy,time1)="+yer+" and datepart(mm,time1)="+moon+"";
cmd=new SqlCommand(sql,conn);
SqlDataAdapter da=new SqlDataAdapter(cmd);
DataSet ds=new DataSet();
da.Fill(ds,"biyesheji");
dataGrid1.DataSource=ds;
dataGrid1.DataMember="biyesheji";
conn.Close();
按月份查询数据,这是在.NET做的
最新推荐文章于 2023-07-31 16:21:46 发布