Click here to Skip to main content
15,922,325 members
Home / Discussions / Database
   

Database

 
QuestionTyped dataset and ReadXml Pin
slappe20-Feb-06 2:37
slappe20-Feb-06 2:37 
QuestioncomboBox1.ValueMember = "column1" Pin
myNameIsRon19-Feb-06 11:51
myNameIsRon19-Feb-06 11:51 
AnswerRe: comboBox1.ValueMember = "column1" Pin
Ritesh123419-Feb-06 18:37
Ritesh123419-Feb-06 18:37 
GeneralRe: comboBox1.ValueMember = "column1" Pin
myNameIsRon20-Feb-06 12:50
myNameIsRon20-Feb-06 12:50 
AnswerRe: comboBox1.ValueMember = "column1" Pin
AlexeiXX320-Feb-06 7:18
AlexeiXX320-Feb-06 7:18 
GeneralRe: comboBox1.ValueMember = "column1" Pin
myNameIsRon20-Feb-06 12:45
myNameIsRon20-Feb-06 12:45 
GeneralRe: comboBox1.ValueMember = "column1" Pin
AlexeiXX320-Feb-06 13:41
AlexeiXX320-Feb-06 13:41 
QuestionDate problem Pin
sebastian yeok18-Feb-06 22:41
sebastian yeok18-Feb-06 22:41 
hi, my Date field in the database formated as 2/15/2006 11:40:46 AM . i try to manually give a date (no) but it give me error. the error come from myReader!. help me to correct, thanks


no = "2152006"
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 cast(Date as datetime) ='" & no & "'"
myCmd.CommandText = strSQL
myConn.Open()
myCmd.Connection = myConn
myReader = myCmd.ExecuteReader
myReader.Read()

Author = myReader("Author")

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


-- modified at 4:41 Sunday 19th February, 2006
AnswerRe: Date problem Pin
Colin Angus Mackay19-Feb-06 0:41
Colin Angus Mackay19-Feb-06 0:41 
GeneralRe: Date problem Pin
sebastian yeok19-Feb-06 1:53
sebastian yeok19-Feb-06 1:53 
GeneralRe: Date problem Pin
Colin Angus Mackay19-Feb-06 2:19
Colin Angus Mackay19-Feb-06 2:19 
GeneralRe: Date problem Pin
sebastian yeok19-Feb-06 2:37
sebastian yeok19-Feb-06 2:37 
GeneralRe: Date problem Pin
Colin Angus Mackay19-Feb-06 2:43
Colin Angus Mackay19-Feb-06 2:43 
QuestionHow to indent SQL statements? Pin
sacoskun18-Feb-06 21:19
sacoskun18-Feb-06 21:19 
AnswerRe: How to indent SQL statements? Pin
Colin Angus Mackay19-Feb-06 0:26
Colin Angus Mackay19-Feb-06 0:26 
GeneralRe: How to indent SQL statements? Pin
CWIZO19-Feb-06 1:40
CWIZO19-Feb-06 1:40 
GeneralRe: How to indent SQL statements? Pin
Paul Conrad19-Feb-06 7:45
professionalPaul Conrad19-Feb-06 7:45 
GeneralRe: How to indent SQL statements? Pin
sacoskun20-Feb-06 9:10
sacoskun20-Feb-06 9:10 
Questionmove table record Pin
sebastian yeok18-Feb-06 21:02
sebastian yeok18-Feb-06 21:02 
AnswerRe: move table record Pin
Colin Angus Mackay19-Feb-06 2:47
Colin Angus Mackay19-Feb-06 2:47 
QuestionDifference between two tables Pin
niceguyeddie199917-Feb-06 5:11
niceguyeddie199917-Feb-06 5:11 
AnswerRe: Difference between two tables Pin
Colin Angus Mackay17-Feb-06 5:35
Colin Angus Mackay17-Feb-06 5:35 
GeneralRe: Difference between two tables Pin
niceguyeddie199917-Feb-06 5:38
niceguyeddie199917-Feb-06 5:38 
GeneralRe: Difference between two tables Pin
Colin Angus Mackay17-Feb-06 8:46
Colin Angus Mackay17-Feb-06 8:46 
QuestionUrgent: SQL Server log: Login succeeded for user 'APPL_ACCOUNT'. Connection: Non-Trusted. Pin
devvvy16-Feb-06 17:45
devvvy16-Feb-06 17:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.