[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
Re: [2008] DataGridView save to db
So, is the bottom line question how to run a stored procedure from VB.NET?
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?