How to add library in project

[zoran035]

I am new in b4a and have a question
about :

"... after copy the System.Data.SqlClient.Dll file and the MSSQL.Dll.!!!
...
Sub Globals
'Declare the global variables here.
End Sub

Sub App_Start
Form1.Show
cnDatos.New1
End Sub

Sub Button1_Click
If cnDatos.Open("Persist Security Info=False;Integrated Security=False;Server=XPS,1433; initial catalog=windip; user id=sa; password=12345;") Then
Msgbox("Conexion exitosa!!!","My First Program",cMsgboxYesNo,cMsgboxHand)
Else
Msgbox("Conexion ERRONEA!!!","My First Program",cMsgboxYesNo,cMsgboxHand)
End If
End Sub
...."


My question is where to copy lib an how to add to b4a project
Pleas help me
Thanks.

 

[wl]

Also have a look at the response NJDude gave on your other (related) question.

Android is a Linux based operation system and can not run any .Net DLL assembly (or plain Windows DLL ). Therefore: B4A can not connect directly to SQL Server.

The only way is to write a .NET webservice or website to which your Android app can connect, which is exactly what is described in the post NJDude refers to.

 

[gjoisa]

I think you are referring about Basic4PPC . The key word 'new1' is not used in b4a . If you asked about b4a then adding a library is very easy . At right side lower end of the code wind there are 4 tabs . Click on 'Libs' tab . there you find the list of libraries available . Just check the desired library check box . Then declare as variable for using the library . For sql use like this :
Dim SQL1 As SQL
Dim Cursor As Cursor

Regards .

 

[zoran035]

I think you are referring about Basic4PPC . The key word 'new1' is not used in b4a . If you asked about b4a then adding a library is very easy . At right side lower end of the code wind there are 4 tabs . Click on 'Libs' tab . there you find the list of libraries available . Just check the desired library check box . Then declare as variable for using the library . For sql use like this :
Dim SQL1 As SQL
Dim Cursor As Cursor

Regards .

how to add users lib

 

[Erel]

There are several tutorials here: Libraries developers questions - Android Development Forum - Basic4android

As I wrote to you by mail, you will not find a simpler way to connect to the MS SQL server (other than the one mentioned in the tutorial).