使用gridview时出现"无法确定 MetaTable。无法为数据源“SqlDataSource1”确定 MetaTable,且无法从所...."错误

修改你的查询，删除，更新语句。

 

  <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MySchoolConnectionString %>" SelectCommand="SELECT * FROM [Student]" DeleteCommand="DELETE FROM [Student] WHERE [StudentId] = @StudentId" InsertCommand="INSERT INTO [Student] ([LoginId], [LoginPwd], [UserStateId], [ClassId], [StudentNO], [StudentName], [Sex], [StudentIDNO], [Major], [SchoolBefore], [Phone], [Address], [PostalCode], [CityWanted], [JobWanted], [Comment], [Email]) VALUES (@LoginId, @LoginPwd, @UserStateId, @ClassId, @StudentNO, @StudentName, @Sex, @StudentIDNO, @Major, @SchoolBefore, @Phone, @Address, @PostalCode, @CityWanted, @JobWanted, @Comment, @Email)" UpdateCommand="UPDATE [Student] SET  [ClassId] = @ClassId, [StudentNO] = @StudentNO, [StudentName] = @StudentName, [Sex] = @Sex, [StudentIDNO] = @StudentIDNO, [Major] = @Major, [SchoolBefore] = @SchoolBefore, [Phone] = @Phone, [Address] = @Address, [PostalCode] = @PostalCode, [CityWanted] = @CityWanted, [JobWanted] = @JobWanted, [Comment] = @Comment, [Email] = @Email WHERE [StudentId] = @StudentId">

这是gridview设计视图源码

中的sqldatasource，在修改~~~