Is it possible to call backend procedures with ADO control?
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
| Is This Answer Correct ? | 1 Yes | 0 No |
How many types of ActiveX Components are there in Visual Basic and what are they?
Types of LockEdits in RDO.
How would you Create a Query Builder and Explain its uses ?
How can you save and Get data from Clipboard?
To populate a single column value which dbcontrols you to use?
What are the Sequence of events when a form is loaded in Visual Basic?
How to find size of the file. Which method or function is used to occomplish this?
what are the three main differences between flexgrid control and dbgrid(Data bound Grid) control
Can we change back color of command button control? if yes than how it is possible?
Explain about creating VB applications in excel?
How can you get selected file from file system Control?
Difference between Recordset and Resultsets.
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)