大家别看代码有点长,其实问题很简单,进来看看
System.Data.IDataReader GetPlayersByTeam(int teamID)
{
string connectionString = ConfigurationSettings.AppSettings["ConnectionString"];
System.Data.IDbConnection dbConnection = new System.Data.OleDb.OleDbConnection(connectionString);
string queryString = "SELECT [Players].[PlayerName], [Positions].[PositionName], [Teams].[TeamName] FROM [Players], [Positions], [PlayerTeam], [Teams] WHERE ([PlayerTeam].[TeamID] = @TeamID))";
System.Data.IDbCommand dbCommand = new System.Data.OleDb.OleDbCommand();
dbCommand.CommandText = queryString;
dbCommand.Connection = dbConnection;
System.Data.IDataParameter dbParam_teamID = new System.Data.OleDb.OleDbParameter();
dbParam_teamID.ParameterName = "@TeamID";
dbParam_teamID.Value = teamID;
dbParam_teamID.DbType = System.Data.DbType.Int32;
dbCommand.Parameters.Add(dbParam_teamID);
dbConnection.Open();
System.Data.IDataReader dataReader = dbCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
return dataReader;
}
上面的代码用C#写会报错"@TeamID"未声明
但是如果用VB写就不会报错,这是怎么回事?
问题点数：20、回复次数：1Top
1 楼kingdhy（飞鹰）回复于 2006-03-04 15:37:33 得分 0
注意大小写Top
