How to use vb code will appear a column value in the same line to delete

CodePudding user response:

Sort by name first, and then a cycle according to the total number of rows, determine if the current line name=the name of the previous line, then delete the current line,

CodePudding user response:

Behind the source database SQL statement to select and distinct, if you have any other different name attribute, need a little more complicated SQL statements, stick out your SQL, look at how to processing,

CodePudding user response:

refer to the second floor xrbaa response:

source database SQL statement to select followed by distinct, if you have any other different name attribute, need a little more complicated SQL statements, stick out your SQL, look at how processing,

at first did not use SQL

CodePudding user response:

reference weixin_44751616 reply: 3/f

Quote: refer to the second floor xrbaa response:

source database SQL statement to select followed by distinct, if you have any other different name attribute, need a little more complicated SQL statements, stick out your SQL, look at how processing,

at first did not use SQL

The data you zha of? Binding ADO controls?

CodePudding user response:

I am a data printed in this datagridview

CodePudding user response:

reference 4 floor response: VB amateurs

Quote: reference weixin_44751616 reply: 3/f

Quote: refer to the second floor xrbaa response:

source database SQL statement to select followed by distinct, if you have any other different name attribute, need a little more complicated SQL statements, stick out your SQL, look at how processing,

at first did not use SQL

The data you zha of? Binding ADO controls?

I grab is a software data into it

CodePudding user response:

Use the select distinct statement

CodePudding user response: