harun didin

harun didin

  • NA
  • 72
  • 1.4k

C#,windows form splitting text from sql data received

Jul 30 2015 6:17 AM

Hi everybody i want to ask you about something like the Picture below. How can i split text values and upload them to new datagridview? We use sql server to save datas. And make a record with ','. I can split one row with

textBox5.Text.Split(....)

but we have 2 colums and more then 100 rows. Can u hepl me? 
IDNUMBERERRORSNOTES
120A10,B20,C34ECC,OPP,ERR
221B10,A20OPP,ERR
322A22,A12,B21ACC,ECC,OPP
423B20ACC
524B12,B13,A10ECC,ACC,OPP
    
    
    
    
IDNUMBERERRORSNOTES
120A10ECC
 20B20OPP
 20C34ERR
221B10OPP
 21A20ERR
322A22ACC
 22A12ECC
 22B21OPP
423B20ACC
524B12ECC
 24B13ACC
 24A10OPP
 

 


Answers (5)