Displaying Data

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;

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.