源代码如下:
db.myConnection.Open();
//昨天日期
string y = Convert.ToString (DateTime.Now.Year);
string mo = Convert.ToString(DateTime.Now.Month);
string d = Convert.ToString(DateTime.Now.Day - 1);
com = new SqlCommand("select gist from gist where stringdate= "+y+"/"+mo+"/"+d,db.myConnection );
dr = com.ExecuteReader();
dr.Read();
textBox1.Text = dr["gist"].ToString(); db.myConnection.Close();数据库表名:gist,包含两列:date和gist(初始值为:date 2011/2/9,gist 0)错误为:Conversion failed when converting the nvarchar value '2011/2/9' to data int忘好心人帮助
db.myConnection.Open();
//昨天日期
string y = Convert.ToString (DateTime.Now.Year);
string mo = Convert.ToString(DateTime.Now.Month);
string d = Convert.ToString(DateTime.Now.Day - 1);
com = new SqlCommand("select gist from gist where stringdate= "+y+"/"+mo+"/"+d,db.myConnection );
dr = com.ExecuteReader();
dr.Read();
textBox1.Text = dr["gist"].ToString(); db.myConnection.Close();数据库表名:gist,包含两列:date和gist(初始值为:date 2011/2/9,gist 0)错误为:Conversion failed when converting the nvarchar value '2011/2/9' to data int忘好心人帮助
yyyymmdd hh:mi:ss.mmm