Hi friends, I am using C#, Asp.net and my Ms Sql server table name is getdetail which contains id(int), name(nvarchar(20)) fields and the table data are 101, bob. Now i want to fetch the name value and assign it to the string datatype variable and show that value in the page. Can anybody give me the code please...?