Database

nauty wrote:

1. not able to see the "OracleClient" namespace after the "system.Data ".How can i get it.

nauty wrote:

2. if I want to get connected through Oledb. how can i do that.

SELECT SupplierID, NameOrCompany, IsLocal
  FROM
   (
    SELECT SupplierID
           , LastName + ', ' + FirstName AS NameOrCompany
           , IsLocal 
      FROM Suppliers 
     WHERE IsLocal=false
    UNION ALL
    SELECT SupplierID
           , Company AS NameOrCompany
           , IsLocal 
      FROM Suppliers 
     WHERE IsLocal=true
    ) x
 ORDER BY NameOrCompany

Select a.username as User, b.domainname as Domain, a.MaxDT as Date
  From 
   (
    Select username, Max(dt) as MaxDT
      From testtable
     Group By username
   ) a INNER JOIN testtable b ON a.username=b.username AND a.MaxDT = b.dt

select ID, M_ID, S_ID, min(Date)
from t
group by ID, M_ID, S_ID

select tt.userid, tt.domain, tt.date
  from ( select m.userid, max(m.domain)
           from testtable m
          group by m.userid
       ) tmp
      , testtable tt
 where tt.userid = tmp.userid
   and tt.domain = tmp.domain
;

sebastian yeok wrote:

my Date field in the database formated as 2/15/2006 11:40:46 AM .

Dim no As DateTime = New DateTime(2006, 2, 15)
Dim myConn As SqlConnection
Dim myCmd As SqlCommand = New SqlCommand
Dim myReader As SqlDataReader
Dim strSQL As String

myConn = New SqlConnection(ConfigurationSettings.AppSettings("ConnStr"))
strSQL = "SELECT Author FROM Booktbl WHERE [Date] = @date";
myCmd.CommandText = strSQL

' The parameter is added so that (1) you don't inject the value into the SQL String and
' (2) you don't have to worry about the formatting of the date as the framework will
' do that for you. Notice how @date corresponds to the @date in the strSQL above.
myCmd.Parameters.Add("@date", no)
myConn.Open()
myCmd.Connection = myConn

' Use execute scalar. Remember to check for DBValueNull in case no rows were found
' and to cast the result to what ever type Author is.
Author = myCmd.ExecuteScalar()

myReader.Close()
myConn.Close()
lblShow.Text = Subject

sebastian yeok wrote:

1) How to display the "author" using the lblShow.

sebastian yeok wrote:

in this, it retrive one record, how about retrive more records?

sebastian yeok wrote:

let say 10 records, how to display it?

sebastian yeok wrote:

how about retrive data between 2005/5/15 and 2006/5/15

SELECT Columns 
FROM MyTable 
WHERE DateColumn >= @startDate
AND DateColumn <= @endDate