寻找将VB windows应用程序中的数据插入SQL数据库的教程 [英] Looking for a tutorial to insert data from VB windows app into SQL database

问题描述

有没有人有一个很好的教程来学习如何将记录添加到SQL数据库中？数据库的布局有一个主键表和9个与之相关的外键表，或者我认为它与之相关。



我知道如何将表单中的数据插入到一个没有主键外键的表中，但我似乎无法找到任何有关如何从Windows应用程序向多级数据库添加数据。



我尝试过：



我尝试过大量的谷歌搜索和YouTube搜索，但我发现的一切都是谈论将数据从多个表格拉入表格中的对象或将表格中的数据发送到一个表格。



我不是说嘘声，因为那是最基本的操作，而且大多数学习的人都需要从那时开始，但是我已经过了那个时候了似乎找不到通过所有绝对初学者教程的方法。

Does anyone have a good tutorial to learn how to add a record into an SQL database? The database is laid out with one primary key table and 9 foreign key tables that are related to it, or I suppose that it relates to.

I know how to insert data from a form into one table that has no keys outside of the primary key, but I can't seem to find anything that talks about how to add data to a multilevel database from a windows application.

What I have tried:

I have tried copious google searches and YouTube searches, but everything I've found either talks about pulling data from multiple tables into objects on a Form or sending data from a form to one table.

I'm not saying boo to that, because that's the most basic operation and most folks that are learning need to start at that point, but I'm past that at this point and can't seem to find a way through all of the absolute beginner tutorials.

推荐答案

索引的更新是透明的。所以，你的问题归结为如何插入记录。



如果您的问题是：如何创建具有主索引和二级索引的数据库，那么另一个问题/故事。



如果在插入记录的过程中你违反了二级索引规则，那么这又是另一个话题。



vb.net - 如何我可以使用VBNet将数据插入SQL Server - Stack Overflow [ ^ ]

The updating of the indexes is "transparent". So, your question boils down to "how to insert a record".

If your question is: how do I create a database with primary and secondary indexes, then that's another question / story.

If in the process of inserting a record you violate secondary index rules, then that's another topic again.

vb.net - How can I Insert data into SQL Server using VBNet - Stack Overflow[^]

这篇关于寻找将VB windows应用程序中的数据插入SQL数据库的教程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！