Database

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

sebastian yeok wrote:

myCmd.Parameters.Add("@startDate", sDate)
myCmd.Parameters.Add("@endDate", eDate)
is't correct i do like this?

sebastian yeok wrote:

10 records means, retrive 10 rows of record or more.

SELECT Column1, Column2, Column3
FROM MyTable AS mt
INNER JOIN SomeOtherTable AS sot ON mt.pk = sot.fk
INNER JOIN (SELECT fk, ColumnA, ColumnB, ColumnC
            FROM InnerTable
            WHERE ColumnD = 10) AS it ON mt.pk = it.fk
WHERE mt.Column4 IS NOT NULL
ORDER BY Column2;

SELECT 
  filed1, 
  field2
FROM 
  table1, 
  table2
WHERE 
  condition 1
  AND 
  contidion 2
ORDER BY 
  field
LIMIT 
  1
DESC

Colin Angus Mackay wrote:

My particular scheme is something like

sebastian yeok wrote:

the select statement used the .ExecuteReader and the insert statement used .ExecuteNonQuery how to join this both used in question (1)?

sebastian yeok wrote:

how to move 1000 or more rocord from table1 to table2 ?. how to i store the 1000 records from table1. is there any solution to this problem.

SELECT a.pk, b.pk
FROM FirstDatabase.dbo.TableName AS a
FULL OUTER JOIN SecondDatabase.dbo.TableName AS b WHERE a.pk = b.pk
WHERE a.pk IS NULL
OR b.pk IS NULL

OR a.column1 <> b.column1
OR a.column2 <> b.column2

<br />
conn.Open();   //conn = IDbConnection<br />

<br />
sess.Open();    //sess = NHibernate's ISession<br />