There is ActiveX collection called "Sheridan". It has a various types of databind controls as well as data list controls, where you can edit inside the grid itself and you can enter new rows to the grid as well.
can Do it, assume you have connection called con, placed two text boxes in the form (txtUID,txtPWD).
Dim con as new ADODB.connection
cmdOK_Click()
dim sUser,sPass as string
sUser=txtUID
sPass=txtPWD
con.open "DSN=DSN_Name;UID=" & sUser & ";PWD=" & sPass & ";"...
Try this out and let me know if it works,
With Grid
I = 0
If .Rows >= 1 Then
For I = 1 To (.Rows - 1)
If .TextMatrix(I, 1) <> "" Then
conInv.Execute "INSERT INTO Table_Name(pc_index,comment) " _
& "VALUES(" & pc_index & ",'" &...
Try this out,
Step 1.
Dim strCon as string
Dim con as new ADODB.Connection
Step 2.
if you are using a DSN(Data source name) to connect to the SQL server, Then use this method
Syntax:
strCon="DSN=DSN_Name;UID=userID;PWD=password;Database=databasename"
Or you can use this method...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.