sqldatasource to fill a datatable

[Tina]

Can I use a sqlDataSource to fill a datatable in code? How?
Thanks,
T

 

[Guest]

Hi Tina,
SqlDataSource is component used for databinding. If you need to fill
DataTable in your code use SqlDataAdapter instead.

DataTable table = new DataTable();
using (SqlConnection conn = new SqlConnection(myConnectionString))
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand("some database query", conn);
adapter.Fill(table);
}

Best regards,
Ladislav

 

[Tina]

I'm aware of what you are saying.
My question stands.
T