Displaying Data

Question

hello everyone i am really very new to asp.net. please help me out here. i want to retrieve data from the sql server. i have a column in the table that contains the same value as the user login nameso when retrieving data i want to use the login name how do i do that?pliz help me. thanks in advance...

Sandeep Singh Shekhawat · Answer

1. imports namesapce in class using System.Data.SqlClient; 2. create a function in that class which retrun sqlConnection public static SqlConnection Connection() { string connectionString = Data Source=sandeepss-PC;database=Development;user=sa;password=knowdev; SqlConnection con = new SqlConnection(); con.ConnectionString = connectionString; return con; } 3 create a function which return all login names in a data Table public static DataTable getUserLogin() { DataTable dt = new DataTable(); SqlConnection con = Connection(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = select userLogin from tbl_login; cmd.Connection = con; con.Open(); SqlDataReader reader = cmd.ExecuteReader(); dt.Load(reader); return dt; }