New to C# - DB question

I am used to using old school ADO where I might create things like:

objConn.Open( sConnectString);

objRecordSet.Open ("Select * from users where UID=' + sUserID + "'",
objConn);

Then I have a recordset collection that I can filter on or step through
etc. based on a specific SQL query.

Is there a similar methodology employed in .NET? I see items like

DataSource
TableAdapter
DataSet

But I do not see a specific method for executing SQL against a specific
table or set of tables. I have my data source defined to my project
and I can drag and drop grid or field views to my form but I do not
want that type of functionality. I want user inputs that I then do a
lookup in my database with.

Can someone point me in the right direction?

Thanks in advance!

.

Relevant Pages

  • Re: In VBA how do I link the fields of a form to an on-the-fly SQL
    ... Filter and FilterOn properties. ... Assuming that the Constellation, StarName, ... Now I create a SQL query for just those stars in Orion. ... Dim db as Database, rst as Recordset, strSQL as String ...
    (microsoft.public.access.queries)
  • Re: A very basic search form in access
    ... > gets inserted into a sql query and the results of the query gets ... From the PopUp menu I click on "Filter By Form" ... In the Payee TextBox I enter "Like Sh*" without the quotation marks. ... From the PopUp menu I click "Apply Filter/Sort". ...
    (comp.databases.ms-access)
  • Re: Nullable types - am I missing something?
    ... able to filter based on any combination of them with the additional ... I can write a SQL query quite easily but the ... passed first and then either send Nothing or the value of the ... a null value to a field, passing Nothing will not do. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Nullable types - am I missing something?
    ... able to filter based on any combination of them with the additional ... I can write a SQL query quite easily but the ... passed first and then either send Nothing or the value of the ...
    (microsoft.public.dotnet.languages.vb)
  • Re: select ... count ... inner join statement
    ... > It would help if we knew all the possible values for statusm but given ... I have just added the line you proposed to my SQL query, ... With the filter you propose, instances that return zero are ommited. ... I've never seen such a beast. ...
    (microsoft.public.inetserver.asp.db)