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 |
What is the use of Scalewidth and ScaleHeight Proeperty?
What is visual basic used for?
How should dates be implemented so they work with other language and country formats?
Explain the types of Views in Listview Control?
Is visual basic c#?
Through which protocol OLEDB components are interfaced?
How does VB Pass arguments to a function by default?
Explain the differences between ActiveX Dll and ActiveX Exe?
What is ado data control in vb?
How do I mimic a toggle button?
How do I make an animated icon for my program?
Which ADO object is used to perform commit / rollback ? Is it command or connection or recordset I am not sure of the options given. So please let me know the answer if it is something else.