sqldatasource to fill a datatable

[Tina]

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

[=?Utf-8?B?TGFkaXNsYXYgTXJua2E=?=]

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" wrote:

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

[Tina]

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

"Ladislav Mrnka" <La***********@discussions.microsoft.comwrote in message
news:61**********************************@microsof t.com...

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" wrote:

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