asp.net help please...

• • Reply

  13 years ago

  by anmbia

  S Russell

  , Canada

  Joined 13 years ago

  please... whats wrong with my syntax....

   

  sub Page_Load(sender as Object, e as EventArgs) Dim AutoValue dim Dscon as OleDbConnection dim SQL as string dim DBCon1 as OleDbCommand Dscon = Server.CreateObject("ADODB.Connection") Dscon.Open ("DSN=405d") SQL = "Select Max(cnum) as cnum From clientreg; " Set DBCon1 = Dscon.Execute(SQL) if not Isnull (DBCon1("cnum"))then AutoValue = DBCon1("cnum") + 1 else Autovalue = "1001" end if end sub

  Report abuse