datatype ?

Results 1 to 2 of 2

Thread: datatype ?

  1. #1
    Join Date
    Dec 1969

    Default datatype ?

    i&#039;m getting this error. could someone help straighten me out<BR><BR>Compiler Error Message: BC30451: Name &#039;SQLDataType&#039; is not declared. <BR><BR>// code<BR> cmd.Parameters.Add(New OleDbParameter("@CurrentPage", SQLDataType.Int))<BR> cmd.Parameters.Add(New OleDbParameter("@PageSize", SQLDataType.Int))<BR> cmd.Parameters.Add(New OleDbParameter("@TotalRecs", SQLDataType.Int))<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: datatype ?

    Are you using SQL or OleDB? You have it mixed.<BR><BR>SQL:<BR>cmd.Parameters.Add(New SqlParameter("@CurrentPage", SQLDbType.Int))<BR><BR>OleDb:<BR>cmd.Parameters.Ad d(New OleDbParameter("@CurrentPage", OleDbType.Integer))

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts