SqlConnection conn = new SqlConnection("server=localhost;database=DB_NAME;uid=sa;pwd=1234567");
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM TABLE_NAME",conn);
DataTable dt = new DataTable();
adapter.Fill(dt)
Completed a period created connection and fill data from sql to datatable in C#. :-O