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");
There is a Table3 Mediator. to get the ID values
Table3
Col1 Col1 Col2
Val Table2Col1 Table1Col9
Now my Question is if a user Registering of 19 th Record of Table1 it has to get the Values of Table 2 all 3 Values Because in List<string> we declared three values na. It has to Fill upthe Table3 like.
21 19 1
22 19 2
23 19 3
How can I Fill up like this Table3. Now while i am inserting record of 19th it has to get the value of Table3 and 19 th Record has to Fill up Successfully...