Click here to Skip to main content
16,014,392 members

Comments by Member 11745361 (Top 3 by date)

Member 11745361 2-Dec-15 3:43am View    
I want Import excel sheet data into datadgrid in C#. connection string is sql.
Member 11745361 3-Jul-15 14:45pm View    
I tried to use below code as suggested but still it upload all the string and special character int the grid.

Emp_Id = new System.Text.RegularExpressions.Regex(@"^[a-zA-Z0-9]$").Replace(columns[0].Trim(), ""),

I need a prompt from the system before uploading that row, which having string or special character in the uploading file.
Member 11745361 2-Jul-15 14:25pm View    
But i want remove that particular row from txt manually for which Emp_ID has other than numeric data.

Please suggest !