1, SQL data table need a connection after each table
2, also need to connect to the database after add new data sources in VB?

Can have bosses said about process

CodePudding user response:

I am a beginner, you own understanding is:
Problem a: the establishment of data table, can some fields you need keywords, then use the SQL query can two to table associated query keywords, of course, two tables of keywords should need the same data, for example: a "gonghaowu" as keywords, so table 2 also keywords should also be "union", so the two tables the same working data can be queried,
Problem two: need, programming is to "tell" the computer, at what time or what conditions to the operation of the database, add data source just shows that there is a "thing" and not "tell" the computer when to "use" this thing,

CodePudding user response:

reference 1st floor weixin_43405952 response:

I am also a beginner, just your own understanding is:
Problem a: the establishment of data table, can some fields you need keywords, then use the SQL query can two to table associated query keywords, of course, two tables of keywords should need the same data, for example: a "gonghaowu" as keywords, so table 2 also keywords should also be "union", so the two tables the same working data can be queried,
Problem two: need, programming is to "tell" the computer, at what time or what conditions to the operation of the database, add data source just shows that there is a "thing" rather than "tell" the computer when "with this stuff,"

typo, the original "table 2 also keywords should also be" union ", "should be" table 2 also keywords should also be "gonghaowu" ",

CodePudding user response:

1, can even can not even, as a relational database on teaching, is the need to have a foreign key link, the actual development, the associated benefit in processing program code, more logical,
2, see don't understand, you is what kind of framework connect database? There are many ways to.net and database interaction, the underlying ado.net with encapsulated controls, there is also a popular EF framework

CodePudding user response:

Questions from you, it seems, you don't know anything, can find a almost ready to run, is your lucky,