How to retrieve data using sql

Discussion in '.NET' started by mausimo, Oct 5, 2009.

  1. mausimo

    mausimo

    Joined:
    Sep 24, 2009
    Messages:
    4
    What i am trying to do is retrieve the current date by using sql so that the date is dependant on the server, not the user's computer. Here is what i got:

    // create the data adapter
    SqlDataAdapter dataAdapter = new SqlDataAdapter("declare @Date datetime set @Date = getdate()", myCon);

    // create the DataSet
    DataSet dataSet = new DataSet();

    // fill the DataSet using our DataAdapter
    dataAdapter.Fill(dataSet);

    When i run this, it complies fine, however the dataset does not get any data.
    Im pretty sure my problem is that a DataSet is looking for a table of data, where this sql command does not return a table of data. I need something similar to this, i just want to retrieve the date from the server.
     
    mausimo, Oct 5, 2009
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Shiva
    Replies:
    0
    Views:
    973
    Shiva
    Aug 11, 2004
  2. =?Utf-8?B?VmVhcg==?=
    Replies:
    1
    Views:
    5,047
    =?Utf-8?B?UGhpbGxpcCBXaWxsaWFtcw==?=
    Mar 21, 2006
  3. irfangani@gmail.com
    Replies:
    1
    Views:
    705
    =?Utf-8?B?QWx0YWYgQWwtQW1pbiBOYWp3YW5p?=
    May 19, 2006
  4. =?Utf-8?B?ZGF2aWQ=?=

    How to store/retrieve binary data in/from SQL server DB?

    =?Utf-8?B?ZGF2aWQ=?=, Jul 6, 2006, in forum: ASP .Net
    Replies:
    4
    Views:
    10,143
    sloan
    Jul 7, 2006
  5. Mark B
    Replies:
    0
    Views:
    415
    Mark B
    May 7, 2008
Loading...

Share This Page