int ad_name = int.Parse(DropDownList1.SelectedValue);
int ad_year = int.Parse(DropDownList2.SelectedValue);
int ad_mothe = int.Parse(DropDownList3.SelectedValue);
int ad_game = int.Parse(DropDownList4.SelectedValue);where a.AD_Name='9' and b.Visit_Date like %200705% and a.Game='7'第一个问题:现在9和7的位置替换成相应的ad_name和ad_game
第二个问题:怎么把ad_year和ad_mothe加在一起放进%%里进行模糊查询???就剩10分了,多谢
int ad_year = int.Parse(DropDownList2.SelectedValue);
int ad_mothe = int.Parse(DropDownList3.SelectedValue);
int ad_game = int.Parse(DropDownList4.SelectedValue);where a.AD_Name='9' and b.Visit_Date like %200705% and a.Game='7'第一个问题:现在9和7的位置替换成相应的ad_name和ad_game
第二个问题:怎么把ad_year和ad_mothe加在一起放进%%里进行模糊查询???就剩10分了,多谢
where a.AD_Name="+ ad_name +" and a.Game="+ ad_game +" and year(b.Visit_Date)="+ ad_year +" and month(b.Visit_Date)="+ ad_mothe +"
int ad_year = int.Parse(DropDownList2.SelectedValue);
int ad_mothe = int.Parse(DropDownList3.SelectedValue);取到的是200705,但我在他们之间怎么加个横杠呢,因为数据库是Datetime类型,在数据库表现的是2007-15-05我数据库是要恶补一下了,先狂谢了
int ad_mothe = int.Parse(DropDownList3.SelectedValue);取到的是200705,但我在他们之间怎么加个横杠呢,因为数据库是Datetime类型,在数据库表现的是2007-15-05我数据库是要恶补一下了,先狂谢了其实用我上面的语句就可以了,当然也可以用like:where a.AD_Name='"+ ad_name +"' and a.Game='"+ ad_game +"' and Convert(varchar(20),b.Visit_Date) like '"+ ad_year +'-'+ ad_mothe +"%'
string ad_mothe = DropDownList3.SelectedValue;string sMonth = ad_mothe.Substring(3,1).ToString();
string sDay = ad_mothe.Substring(3).ToString();
string myDate = ad_year + "-" + sMonth + "-" + sDay ;
DataTime getMyTime = DataTime.Parse(myDate);where a.AD_Name='"+ ad_name +"' and a.Game='"+ ad_game +"' and Convert(varchar(20),b.Visit_Date) like '"+ getMyTime +"%'
string ad_mothe = DropDownList3.SelectedValue;string sMonth = ad_mothe.Substring(3,1).ToString();
string sDay = ad_mothe.Substring(3).ToString();
string myDate = ad_year + "-" + sMonth + "-" + sDay ;
DataTime getMyTime = DataTime.Parse(myDate);where a.AD_Name='"+ ad_name +"' and a.Game='"+ ad_game +"' and Convert(varchar(20),b.Visit_Date) like '"+ getMyTime +"%'
string ad_mothe = DropDownList3.SelectedValue;string sMonth = ad_mothe.Substring(3,1).ToString();
string sDay = ad_mothe.Substring(3).ToString();
string myDate = ad_year + "-" + sMonth + "-" + sDay ;
DataTime getMyTime = DataTime.Parse(myDate);where a.AD_Name='"+ ad_name +"' and a.Game='"+ ad_game +"' and Convert(varchar(20),b.Visit_Date) like '"+ getMyTime +"%'