How to compare inserted text in (textbox1.text) with
existing database value in (Sqldatasource1) in visual
studio 2005 ?
Dim strValue As String
strValue = txtValue1.Text
Dim rstData As ADODB.Recordset
rstData = New ADODB.Recordset
rstData.Fields.Append("A",
ADODB.DataTypeEnum.adInteger, 0,
ADODB.FieldAttributeEnum.adFldKeyColumn)
rstData.Fields.Append("B",
ADODB.DataTypeEnum.adVarChar, 10,
ADODB.FieldAttributeEnum.adFldIsNullable)
'rstData.Fields.Append("C",
ADODB.DataTypeEnum.adVarChar, 0)
rstData.Open()
rstData.AddNew()
rstData.Fields("A").Value = "1"
rstData.Fields("B").Value = "Amol"
rstData.Update()
rstData.MoveFirst()
If UCase(Trim(rstData.Fields("B").Value)) =
UCase(Trim(strValue)) Then
MsgBox("True")
Else
MsgBox("False")
End If
Is This Answer Correct ? | 3 Yes | 2 No |
Is visual basic case sensitive?
What is the use of Imagelist Controls
Which controls can not be placed in MDI?
Whats the advantages/disadvantages of using datacontrol vs DAO/ADO/RDO?
1 Answers L&T, MAHINDRA, Teledata,
What is Dataware Control?
What are the Style properties of List Box?
what is the Benefit of wrapping database calls into MTS transactions?
Name the four different cursor and locking types in ADO ?
How do I call a DLL?
What is the use of progress Bar Control?
what is the front end you used?
Describe Database Connection pooling relative to MTS ?