Removal of string or spacial char. while uploading text file in datagrid in c#

See more:

C#

I am using below code to upload txt file data separated by '|' delimiter in datagrid view. For the column[0](Emp_ID), datatype is numeric. Many time we found string or special charactor(*,#,@,$ etc.) for the first column of the txt file. While we have to upload only number data in the datagrid for first column from txt file.
I am looking for a code here which will actually prevent string or special character values to upload in the datagrid. It should invoke with line number error while uploading, so that we can remove that particular string related data from the txt file.


public class User
{

public string Emp_Id { get; set; }
public DateTime Atten_Date { get; set; }
public DateTime Atten_Punch_Date { get; set; }
public string Atten_Project_code { get; set; }
public string Atten_states { get; set; }

public static List<user> LoadUserListFromFile(string location)
{

Stream mystream;
OpenFileDialog opentext = new OpenFileDialog();
if (opentext.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
if ((mystream = opentext.OpenFile()) != null)
{
location = opentext.FileName;
// string filetext = File.ReadAllText(strfilename);
}
}

var users = new List<user>();

try
{
foreach (var line in File.ReadAllLines(location))
{

var columns = line.Split(new[] { '|' });

users.Add(new User

{
Emp_Id = columns[0].Trim(),
Atten_Date = Convert.ToDateTime(columns[1]),
Atten_Punch_Date = Convert.ToDateTime(columns[2]),
Atten_Project_code = columns[4].Trim(),
Atten_states = columns[3].Trim()

}


);

}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message, "Please select file to upload");
}
return users;

}