ADO.NET :: Get ID Values Of A Text?

I am having 2 tables. In 1 table i am having 10 columns. out of 10 i m inserting 9 column values with the Table Structure of Column Names but in 10 th Column(This Column is not Declared in Table1 but Declared in Table 2). i am inserting Text But this Text is having ID values in Table 2.

Ex:-

Table1

Col1 Col2 Col3 ---------Col9 Col10
1 ff fd ----------- HowToGet ID? xyz

Table2

Col1 Col2
1 Admin
2 Role1
3 Role2

Now in My inserting Code Snippet is like this....

List<string> roles = new List<string>();
roles.Add("Admin");
roles.Add("Role1");
roles.Add("Role2");

[Code]....