Results 1 to 5 of 5

Thread: SQL Server & DataSets ?? Key Column Info ?

  1. Nov 29th, 2002, 05:23 AM #1
    OptimusPrime
    OptimusPrime is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2002
    Location
    Outer space
    Posts
    97

    SQL Server & DataSets ?? Key Column Info ?

    i've just started developing using sql server & vb.net

    and am slowly learning about ado rather than dao but my question is this

    im using vb.net & i have some code using a OleDbDataAdapter, OleDbConnection, OleDbCommand and a DataSet

    but when i try n update records on the database i keep getting the error

    Dynamic generation of SQL cannot be done . . . .

    because no key column information was selected ???

    whats key column information its really starting to do my head in
    Reply With Quote Reply With Quote
  2. Nov 29th, 2002, 07:17 AM #2
    swatty
    swatty is offline
    Frenzied Member swatty's Avatar
    Join Date
    Aug 2002
    Location
    somewhere on earth
    Posts
    1,478
    How are you updating them ??

    With recordset, updatestatement ??
    Code:
    If Question = Incomplete Then
   AnswerNextOne
Else
   ReplyIfKnown
End If
    cu Swatty
    Reply With Quote Reply With Quote
  3. Nov 29th, 2002, 07:23 AM #3
    OptimusPrime
    OptimusPrime is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2002
    Location
    Outer space
    Posts
    97
    using the myDataAdapter.update command

    and passing in the dataset
    Reply With Quote Reply With Quote
  4. Nov 29th, 2002, 07:55 AM #4
    PilgrimPete
    PilgrimPete is offline
    Frenzied Member PilgrimPete's Avatar
    Join Date
    Feb 2002
    Posts
    1,313
    Does your table have a primary key?
    Reply With Quote Reply With Quote
  6. Nov 29th, 2002, 07:57 AM #5
    OptimusPrime
    OptimusPrime is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2002
    Location
    Outer space
    Posts
    97
    Primary Key

    im using the one column as a Unique ID but its not set as the primary key

    ill give it a goe see if it works []
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width