How to load datatable from database fastly.

See more:

C#2.0

C#

I am very frustrated that in my application I am using data adapter to fill datatable but it is taking much more time to fill the datatable. In my application scenario I want full data in datatable and in SQL Server management studio it takes only seconds to show the data.
I have tried datareader and dataadapter but it taking more time. Current record size is 10000+ and it may increase so now its taking 2-4 minuts and if database records increase then it will take more time. My project developed in C#2.0 only.

I am using below code for fill datatable. I also tried with datatable load method with datareader.

SqlConnection connection=new SqlConnection("connectionString");
connection.Open();
SqlCommand cmd = new SqlCommand("StoredProcedureName", connection);

cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@param1", 16));
cmd.Parameters.Add(new SqlParameter("@ID", 341));
cmd.Parameters.Add(new SqlParameter("@LOCATION", "Bank Street"));
cmd.Parameters.Add(new SqlParameter("@NAME", "Prince"));
DataTable dt = new DataTable();
new SqlDataAdapter(cmd).Fill(dt);
connection.close();

Please give me better solution for it.

Thanks in Advance :)