Tables are there in a field ID code name
A data table is 1, 1, 2, 3 ", "ball"

Table ii have ID code name
Data in table 2 for 1, 1, "football".
2, 2, "basketball";
3, 3, "volleyball";
4, 4, "table tennis";
According to the code a query out the table lookup table 2 the corresponding data
Do this with Asp.Net (c # language) three layer architecture to do?

CodePudding user response:

Do you mean the MVC or aspx

CodePudding user response:

What can be put into three layers, god saw will shed tears,

CodePudding user response:

DAL: Table1Dal Table2Dal
The BLL: Table1BLL Table2BLL
Model: Table1 Table2
UI: (interface)

Table1 and Table2 is the name of the two tables, write data access code in the dal in the BLL assembly related business logic, and finally the UI reference the BLL call

The UI - & gt; The BLL - & gt; DAL this is access to the process

CodePudding user response:

If you ask what is function of the
The table a code with the Split () function according to the comma Split into an array, the query again

CodePudding user response:

reference 4 floor?????? Response:

if you ask how is the function of the
The table a code with the Split () function according to the comma Split into an array, then the query

How to check, has been divided into array have never checked according to the array, to solve

CodePudding user response:

reference 5 floor qq_42282768 reply:

Quote: refer to 4th floor?????? Response:

if you ask how is the function of the
The table a code with the Split () function according to the comma Split into an array, then the query

How to check, has been divided into array have never checked according to the array, solving

reference 5 floor qq_42282768 reply:

Quote: refer to 4th floor?????? Response:

if you ask how is the function of the
The table a code with the Split () function according to the comma Split into an array, then the query

How to check, has been divided into array have never checked according to the array, solving

Used for or the foreach loop iterates through the array,
The query in the loop

CodePudding user response:

reference 1st floor ManBOyyy response:

do you mean the MVC or aspx

With the BLL dal access database logic in MVC view displays the data query

CodePudding user response:

You what is the relationship between a database and three layer architecture,,,,

CodePudding user response:

reference 1st floor ManBOyyy response:

do you mean the MVC or aspx

With the BLL dal access database logic in MVC view displays the data query

CodePudding user response:

"1, 2, 3, 4," like '% 1, %'

What do you think of the

Code in (1, 2, 3, 4)
How do you think

CodePudding user response:

God's to god, database to database, don't set of three layers of anything

CodePudding user response:

XX garden that kind of bird X college level great god fool type promotion, always belong to the buried pipe kill no matter, the same as the value of American imperialists output, who believe who beat, (hey hey, the latest news today, Argentina collapsed again, alas, poor Argentina, since grade seduced great god output can only sing "don't cry for me Argentina")

CodePudding user response:

Query out all the code and do not duplicate data in table 1, then cycle the data query table 2

CodePudding user response:

is one of the most basic line column data check??????? In table 2, and 3 types is a kind of ball games, and give the same correlation,
One line function, and filter conditions, and can query the data in table 1,,, a table is a data show,,, turn to line column,
Three layer and the database is ok relationship ah,,, I look at the two answer for not bottom go to, and directly on my answer,,, see by yourself

CodePudding user response:

ASP.net shows a set of data was unexpectedly have so profound learning

CodePudding user response:

Three layer architecture is the most began to write views and stored procedures, database and data manipulation layer (DAL or called DAO) and then the business logic layer (BLL or BIZ) dealing with multiple data layer or the business logic of the formation of the corresponding data, then the presentation layer (UI, display data and behavior operation)

In the MVC or WinForm basically is directly corresponding to the business logic layer,

MVC could someone on the Controller, probably on the Model,

In the new basic MVC is singleton into the Controller,

CodePudding user response:

reference 15 floor it_gz_xi response:

ASP.net shows a set of data was unexpectedly have so profound knowledge

Too much

CodePudding user response:

One day does not stop, here also can only sing "programmer, please don't cry for.net"

CodePudding user response:

, I went to the wrong picture, I have a look at how to withdraw

CodePudding user response:

Don't quite understand what you want to ask three layer architecture, is the normal method and guess whether you want to say write SQL zha,

CodePudding user response:

Very good very good

CodePudding user response:

Are you ok?

CodePudding user response:

DAL, BLL, Model, the UI


The UI - & gt; The BLL - & gt; DAL this is access to the process

CodePudding user response:

No matter what technology, ideas are the same SqlHelper responsible for transmitting database connection
Dal is responsible for the writing of each table to add and delete SQL statements such as
The BLL is responsible for the logical processing
The Model is responsible for carrying data

CodePudding user response:

Base class you will learn and understand, or do anything half half

CodePudding user response:

Agree with the upstairs,

CodePudding user response:

Do you mean the MVC or aspx

CodePudding user response:

Select * from table 1 as a left as the join table 2 b on a.c ode=biggest ode where a.c ode=1

CodePudding user response:

CodePudding user response:

God's to god, database to database, don't set of three layers of anything

CodePudding user response:

Possible data is such: table 2 id code associated with the table, after the database automatically processing, note: two table field design seems not very reasonable, you need to do,

CodePudding user response:

nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull