在将 varchar 值 'year1' 转换成数据类型 int 时失败。的问题

[FeelTouch Labs]

//创建连接桥并从数据库检索数据
int year1, month1, day1;
year1 = Int16.Parse(DropDownList1.SelectedItem.Text);
month1 = Int16.Parse(DropDownList2.SelectedItem.Text);
day1 = Int16.Parse(DropDownList3.SelectedItem.Text);
SqlDataAdapter sda = new SqlDataAdapter("select * from Attendance,Member WHERE Attendance.Number=Member.Number and year(Time)='year1'and month(Time)='month1' and day(Time)='day1'order by Name asc", S601_myConn);
我的意思是从数据库得到三个下拉菜单组合的时间（即某一天的记录），但提示错误

[仙道彰]

.net

试试year(Time)='“+year1+"'

[仙道彰]

哦看错了，也写错了
试试
year(Time)=year1

[liangCK]

int year1 = 10;

string sql = "select year";

跟

string sql2 = "select " + year1;

是不一样的.

[liangCK]

SqlDataAdapter sda = new SqlDataAdapter("select * from Attendance,Member 
                             WHERE Attendance.Number=Member.Number 
                                   and year(Time)=" + year1.ToString() + ' 
                                   and month(Time)=" + month1.ToString() + ' 
                                   and day(Time)=" + day1.ToString() + '
                             order by Name asc", S601_myConn); 

--建议使用参数化方式.

[liangCK]

SqlDataAdapter sda = new SqlDataAdapter("select * from Attendance,Member "
                            + " WHERE Attendance.Number=Member.Number "
                            + "  and year(Time)=" + year1.ToString() 
                            + "  and month(Time)=" + month1.ToString()
                            + "  and day(Time)=" + day1.ToString()
                            + "  order by Name asc", S601_myConn); 

--建议使用参数化方式.

[fcuandy]

这是c#最简单的语法问题吧

[liangCK]

SqlDataAdapter sda = new SqlDataAdapter("select * from Attendance,Member "
                            + " WHERE Attendance.Number=Member.Number "
                            + "  and year(Time)=" + year1.ToString() 
                            + "  and month(Time)=" + month1.ToString()
                            + "  and day(Time)=" + day1.ToString()
                            + "  order by Name asc", S601_myConn); 

--建议使用参数化方式.