Home > Net >  How to SQL database of the corresponding data into multiple columns in the table 1 2 corresponding c
How to SQL database of the corresponding data into multiple columns in the table 1 2 corresponding c

Time:12-26

I have been read by the program to a number in the table all the names and number two in the table column name and display in the checkListBox respectively, how to realize and selected for example in the multiple and checkListBox_1: well hole type identification number... The corresponding data in the database at the same time, one of the corresponding deposit checkListBox_2 respectively for example: the main and 16 and 17 and 18 Lord in SQL in the corresponding column which?


CodePudding user response:

You have to get the raw data of the column name and you want to copy the column, and then the rest is bulk copy

CodePudding user response:

General situation, the database will also need a order ID, such as 10 data, they sort of ID is 1,2,3,4,5,6,7,8,9,10, between 5 to 6 to be inserted, then the data after the insertion, he sort of ID written in 5.5, then the SQL to continue reading,
Prone to bugs and sorted for many times, two values of the poor can no longer continue to divided by 2, then you need to put all the data rewrite sort number,
Sort is not frequent data, you can ignore the BUG, the BUG is the, afraid of a board, or, sorting since 0300, 0400, 1000200,
  •  Tags:  
  • C#
  • Related