为什么我不能拖动&像vs2012一样在vs2013中删除sql表吗? [英] Why I cannot drag & drop sql table in vs2013 like vs2012 any more?
问题描述
回到vs2012，我可以拖动&将SQL表从Data Server Explorer放到Web设计窗口中，vs2012将自动填充GridView并在相应的.aspx文件中写入InsertCommand，UpdateCommand等.当我在做同样的事情 vs2013，我得到的只是[p] [/p]中的表名. vs2013如何获得相同的结果?谢谢.
Back in vs2012, I could drag & drop a SQL table from Data Server Explorer into the Web Design window, vs2012 would automatically populate a GridView and write InsertCommand, UpdateCommand, etc in the corresponding .aspx file. When I do the same in vs2013, all I get is the table name inside [p][/p]. How can I get the same result with vs2013? Thank you.
推荐答案
嗨Lz1234，
我可以在VS2013中成功地将SQL表从Server Explorer拖放到.aspx页的Web设计器中.当我拖放时，将自动填充GridView.请确保您打开一个设计"视图 一个aspx文件，然后将该表放到Web设计器视图中的正确位置. Web Designer中的某些位置不允许添加控件.如果可能的话，请向sql表中添加一些数据以使其不为空，然后将其拖动到Web设计器中.
I can drag and drop a SQL table from Server Explorer into the Web Designer of a .aspx page successfully in VS2013. When I drag and drop, a GridView is populated automatically. Please make sure that you open a Design view for a aspx file and drop the table to the correct place in the web designer view. Some places in web designer are not allowed to add controls. If possible, please add some data into the sql table to make it not empty and then drag it to web designer.
如果仍然无法获取sql表的GridView，请打开一个新的Web应用程序和一个新的aspx文件，然后单击底部的设计"在Visual Studio编辑器中将aspx文件，然后从服务器中拖放SQL表 Web设计器的资源管理器.也许以前的文件/项目已损坏.
If you still can’t get a GridView for the sql table, please open a new web application and a new aspx file, click ‘Design’ at the bottom of the aspx file in Visual Studio Editor, then drag and drop a SQL table from Server Explorer to the Web Designer. Maybe the previous file/project is corrupt.
要检查表上是否存在问题，可以将其他sql表拖放到Web设计器中.
In order to check the issue is on the table, you can drag and drop a different sql table to the web designer.
此外，为了解决您的问题，您可以 通过工具"->导入和导出设置"->重置所有设置"->…来重置您的VS设置.
In addition, in order to resolve your issue, you can reset your VS settings through Tools->Import and Export settings->Reset all settings->….
如果问题仍然存在，请使用devenv.exe/safemode( 第三方VSPackages .
If the issue still exists, please run VS under safe mode using devenv.exe /safemode(http://msdn.microsoft.com/en-us/library/ms241278(v=vs.120).aspx ) to avoid the impact from some third-party VSPackages.
最好的问候，
这篇关于为什么我不能拖动&像vs2012一样在vs2013中删除sql表吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
