Hi.

I want to now a little about CodeBehind how to use it with SqlConnection, SqlCommand and SqlDataReader.

How i use:
Web.Config
 <connectionStrings>
<add name="ConnectionStringTest" connectionString="Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=|DataDirectory|\DSNbase.mdb;Persist Security Info=True" providerName="System.Data.OleDb"/>
</connectionStrings>

Default.aspx
<asp:Repeater ID="test" runat="server" DataSourceID="SqlDataSourcetest">
...
..
<asp:SqlDataSource ID="SqlDataSourcetest" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionStringTest %>"
ProviderName="<%$ ConnectionStrings:ConnectionStringTest.ProviderNam e %>"
SelectCommand="SELECT [ID], [Name], [************], [Born], [Color], [Dog], [Images] FROM [Dogs] WHERE ([Dog] = 'YES') ORDER BY [ID]">
</asp:SqlDataSource>

How can i take my asp:SqlDataSource and put it in my CodeBehind, so it use the ConnectionString from my Web.Config and so i can use my Repeater on my default.aspx site.. !?
Maybe if u got a great link that show "How to do" maybe om MSDN/MSDN2.

The SQLDataSource is not really used in code behind per say.. but you can use bind the SQL Datasource to your connection string by doing the followning.

1) Go to design view
2) from your Tools pallette drag an SQL Datasource on to your .aspx page.
3) Click on "Configure Data Source"
4) It will then prompt you to choose a connection fromn your Web. Config.
5) Bind your repeater to the SQLDatasource using code like the following:

 <asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1"/>

Hope this helps.

Jason

yes but have do i make the datareader/sql conn on my CodeBehind