Home > Net >  C # client server program received data, how to find qualified in the MYSQL database records
C # client server program received data, how to find qualified in the MYSQL database records

Time:11-06



Database has three fields, field 1, 2, the field 3

The client to the server transfer [1] field values (X1), after the server receives in the database to find records of qualified field 1=X1,

Excuse me:
, after find out how to record the field values of 2 and the value of the field 3 read it out?

CodePudding user response:

The select field 1, field 2, 3 from table where field 1=X1

CodePudding user response:

Direct use of SQL queries, similar to the following:
The Select field 1, 2, the field 3 * From your table name fields Where 1='X1'
As for the specific how to implement, see ADO.Net related knowledge,

CodePudding user response:

refer to the second floor datafansbj response:
direct use of SQL queries, similar to the following:
The Select field 1, 2, the field 3 * From your table name fields Where 1='X1'
As for the specific how to do, see ADO.Net related knowledge,


To find the field 1=X1, the value of how to remove the field 2 and 3?

CodePudding user response:

reference ba_wang_mao reply: 3/f
Quote: refer to the second floor datafansbj response:
direct use of SQL queries, similar to the following:
The Select field 1, 2, the field 3 * From your table name fields Where 1='X1'
As for the specific how to do, see ADO.Net related knowledge,


To find the field 1=X1, the value of how to remove the field 2 and 3?


You need to use the ADO.Net related components, the database data into a DataSet, DataTable, then pull data from the DataTable, this type of code is online, we can only give you ideas, specific implementation requires you to find, for example: https://blog.csdn.net/feiduan1211/article/details/81512996? Utm_medium=distribute. Pc_relevant_bbs_down. None - task - blog - baidujs - 1. Nonecase& Depth_1 - utm_source=distribute. Pc_relevant_bbs_down. None - task - blog - baidujs - 1. Nonecase

CodePudding user response:

The select field 1, field 2, 3 from table where field 1=x1 is not to go
  •  Tags:  
  • C#
  • Related