Im new to ASP.NET i have searched the web and i have come to a few threads which are close to what i am looking for, however they are only helpful to me to a certain extent.
I have a grid in a form which is being populated by a table adapter, which has three Three attributes.
I have included a select button to be enabled,
What i would like to achieve is : When the user select a row, i would like to add the three attributes to a new table and i would like to add a few more details which are not displayed to the table for example Username (windows authentication).
What i have so far is on the code behind is i believe a query that i can use which is :
SqlCommand("INSERT INTO tb2 (s.no, name,class) SELECT s.no, name , class FROM tb1", sqlcon). However this access the table 1 which i dont want, i want to add the selected data to the new table.
I am writing this in VB.
Thank you very much for reading this and any help would be really appreciated.
Thank you ,