You must Sign In to post a response.
  • Category: ASP.NET

    Declare of recordset in the vb using asp.net

    hi team,


    how do i call tables in the vb script using asp.net where data is stored or will be stored?



    Thanks $ Regard

    George
  • #652203
    You need to open a connection first..In below code i am using DSN

    Set objConnection = CreateObject("ADODB.Connection")
    Set objRecordset = CreateObject("ADODB.Recordset")
    objConnection.Open "DSN=Test123;"
    objRecordset.CursorLocation = adUseClient
    objRecordset.Open "SELECT * FROM Table12" , objConnection, _
    adOpenStatic, adLockOptimistic


  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.