Database control

Question

Hello, I am about to start codeing a big project in C# and I am going to be using an Oracle database in it. I wanted to hear from you if you have ever used some third party libraries or Add-ons that have some set of great tools provided for you that will ease the way you browse and select rows and edit and stuff like that.... ????

Answer 1

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;

         }