Results 1 to 3 of 3

Thread: [2008] DataGridView save to db

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Sep 2008
    Posts
    21

    [2008] DataGridView save to db

    Hi
    I have an unbound DataGridView that the user fills manually
    I have 3 columns

    Code KeywordList SubjectList
    50a 11,4,5 20,14
    50b 18,9 78,54,65

    I have 2 tables in the database "Keywordlist" and "SubjectList"
    KeywordList has 3 fields:
    ID(autonumber)
    Code
    KeywordID

    SubjectList has 3 fields
    ID(autonumber)
    Code
    SubjectList

    behind the datagridview,there is a SAVE button when clicked i will call a stored procedures that for each Code, writes into "Keywordlist" and "SubjectList" so that "Keywordlist" and "SubjectList" will be populated as follow:
    KeywordList
    ID Code KeywordID
    1 50a 11
    2 50a 4
    3 50a 5
    4 50b 18
    5 50b 9

    SubjectList
    ID Code KeywordID
    1 50a 20
    2 50a 14
    3 50b 78
    4 50b 54
    5 50b 65

    Any help on how I can write this procedure and how I can pass parameters into it

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: [2008] DataGridView save to db

    So, is the bottom line question how to run a stored procedure from VB.NET?

  3. #3

    Thread Starter
    Junior Member
    Join Date
    Sep 2008
    Posts
    21

    Re: [2008] DataGridView save to db

    no i can't figure out how to write this stored procedure,i need some hints to write the SP

    any help?

Posting Permissions

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



Click Here to Expand Forum to Full Width