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

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 
> 
> 
> 

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

"Ladislav Mrnka"  wrote in message 
news:61307DEC-64FB-45D0-9D00-2D0E61A195ED@microsoft.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
>>
>>
>>