Everyone help under is really don't know where is wrong-CodePudding

Read the eyes are spent countless times

CodePudding user response:

Oh my god this column names where not clear

CodePudding user response:

And this I have not a datetime type zha this

CodePudding user response:

Grammar is wrong,

 select "Anderson d, a.N ame from a inner join b on Anderson, d=b.I d where Anderson, d=@ Id"

Behind this, new methods, write the parameters in the parentheses, of this kind of writing you have not seen the

 ClassX objClassX=new ClassX (parameters parameters 1, 2, 3)

And if there is an error, take a look at all the textbox value in monitoring

CodePudding user response:

The

quoted Chen - Xin reply: 3/f

grammar is wrong,
 select "Anderson d, a.N ame from a inner join b on Anderson, d=b.I d where Anderson, d=@ Id" 
Behind this, new methods, write the parameters in the parentheses, of this kind of writing you have not seen the
 ClassX objClassX=new ClassX (parameters parameters 1, 2, 3) 
And if there is an error, take a look at all the textbox value in monitoring

the second has solved is the first press you to write so or not

CodePudding user response:

 string SQL="select Anderson d, a.A thleteId, a.A thleteName, a.S ex, a.C lass, a. d. epartmentId, Amy polumbo rojectRanking, a.S core, Amy polumbo rojectId from Athletes a" + 
"Inner join the Projects on Amy polumbo rojectId b=p. rojectId where Amy polumbo rojectId=@ ProjectId";

Or not to name the table alias, directly in the name of the table. The field name
And if there is an error if the SQL values and the corresponding error,

CodePudding user response:

quoted Chen - Xin 5 floor response:

 string SQL="select Anderson d, a.A thleteId, a.A thleteName, a.S ex, a.C lass, a. d. epartmentId, Amy polumbo rojectRanking, a.S core, Amy polumbo rojectId from Athletes a" + 
"Inner join the Projects on Amy polumbo rojectId b=p. rojectId where Amy polumbo rojectId=@ ProjectId"; 
Or not to name the table alias, directly in the name of the table. The field name
And if there is an error if the SQL values and the corresponding error,

can the careless because two tables have a projectid but when I was looking for no clear the table so he is wrong. Thank you