Answer / sarada

Yes it is possible,the code as follows:

Public myConn As New ADODB.Connection ‘In Declaration
Section

myConn.open “DRIVER={MySQL ODBC 3.51
Driver};SERVER=127.0.0.1;Database=Db;UID=root;PWD=changeme”

myConn.CursorLocation = adUseClient

If myConn.State = ADODB.adStateOpen Then

myConn.execute “CALL sp_deleter( )“ 'Procedure calling

End If

How to find the current record position in data control?

0 Answers  

---

How would you Create a Query Builder and Explain its uses

0 Answers  

---

Different types of Passing Value?

1 Answers  

---

what is the Property used to count number of items in a combobox?

1 Answers  

---

What is form in visual basic?

0 Answers  

---

---

How would you attach pictures in column headers of List View Control?

0 Answers   RRB,

---

What is the difference between a Dynaset and Snapshot and how would you create one?

2 Answers  

---

Difference between listbox and combo box.

12 Answers   HCL, Infosys,

---

What does option Explicit means?

8 Answers   IBM, Infosys,

---

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

1 Answers  

---

What is the use of command Object?

2 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,

---