如何在datatable.select中使用Not IN？ [英] How to use Not IN in datatable.select?

问题描述

如何在datatable.select中使用Not IN？

请帮助..

How to use Not IN in datatable.select?
Pls help ..

推荐答案

尝试

http：//blog.sqlauthority。 com / 2007/05/22 / sql-server-2005-comparison-except-operator-vs-not-in / [ ^ ]

使用字符串它可以工作，但是使用int，guids等你必须使用转换。

检查这个帖子：

http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/db75a5f8 -af77-4801-8d29-73b13f5928b8 / [ ^ ]

With strings it works, but with int, guids etc you have to use a conversion.
Check this thread:
http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/db75a5f8-af77-4801-8d29-73b13f5928b8/[^]

chinnu20写道：

chinnu20 wrote:

紧急

有趣的是，对我们来说根本不紧急。如果您需要免费帮助，您必须接受它的速度。你考虑买一本关于SQL的书吗？阅读一些在线文章？如果你真的对这个问题毫无头绪，那么你应该记住，当我写一篇我期待很多的文章时，我输入的回答一个人的内容要远远少于我所做的工作。人们会读。使用这些论坛了解具体问题，使用谷歌和在线文章我无能为力，不能为购买书籍而烦恼。

Funny enough, it's not urgent to us at all. If you want free help, you have to accept the speed at which it comes. Did you consider buying a book on SQL ? Reading some online articles ? If you're really this clueless on the subject, you should keep in mind that what I'd type in to answer one person, is a lot less than the work I'd put in if I was writing an article that I expected many people would read. Use these forums for specific questions, use google and online articles for 'I am clueless and can't be bothered buying a book' questions.

这篇关于如何在datatable.select中使用Not IN？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！