private DataTable GetData() { DataTable dt = new DataTable(); SqlConnection conn = new SqlConnection(ConfigurationClass.ConfigurationMethod()); SqlDataAdapter adapter = new SqlDataAdapter("select * from emptbl", conn); adapter.Fill(dt); return(dt); }
private DataTable GetData() { DataTable dt = new DataTable(); string query = "select * from emptbl"; SqlConnection conn = new SqlConnection(ConfigurationClass.ConfigurationMethod()); SqlDataAdapter adp = new SqlDataAdapter(query, conn); adp.Fill(dt); return(dt); }