Answer / amol

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

How to change the Mouse Pointer?

2 Answers  

---

What are different types of cursors in ADODB?

5 Answers  

---

by writing MACRO CODE,i want to retrive data from one spead sheet to another UI (workbook). control will search cell by cell for each row and load the data in another workbook(UI). ex: custdetails custname lastname locaton mobile pincode custdetails raj tony hyd 555555 521245 servcreqrd srvce# srvcename location srvcepincode servcreqrd 754 drilling hyd 521784 for the above example in the another workbook retrive data like this custname Raj srvce# 754 srvcepincode 521784. while retrieving data control will search cell by cell for each row.

0 Answers   CGI, Infotech,

---

___,__,___ are the type of combo box?

0 Answers  

---

____ is the difference between Listindex and Tab index.

0 Answers  

---

What do you mean by ADO?

5 Answers   King Indus Software Solutions, TCS,

---

To.set the command button for ESC ___ Property has to be changed.

0 Answers  

---

How do you make a TEXTBOX read only? Or, how do I prevent the user from changing the text in a TEXTBOX?

0 Answers  

---

___,___ and __ are difference between image and picture controls.

0 Answers  

---

What was introduced to Visual Basic to allow the use of Callback Functions?

1 Answers  

---

Explain about literals?

0 Answers  

---

What is the difference between modal and modaless form in VB?

1 Answers  

---