How to set the database in ASP.Net

Question

I have a database at location xmachina\sqlexpress named News, News has a table NewsTable. How do I tell ASP to look at News database? Is it part of the SelectCommand? Or a webconfig variable?

Right now I get a [SqlException (0x80131904): Invalid object name 'NewsTable'.]

web.config

<add name="NewsTableConnectionString" connectionString="Data Source=XMACHINA\SQLEXPRESS;Integrated Security=True" providerName="System.Data.SqlClient" />

Default.aspx

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
   ConnectionString="<%$ ConnectionStrings:NewsTableConnectionString %>"
       ProviderName="<%$ ConnectionStrings:NewsTableConnectionString.ProviderName %>" 
       SelectCommand="SELECT [NewsHeadline] FROM [NewsTable]">
</asp:SqlDataSource>

Jason Irwin · Accepted Answer · 2010-01-04 18:36:34Z

2

use this in your connection string setting in your web.config

Database=News;

See the following site for in depth details: link text

answered Jan 4, 2010 at 18:36

Jason Irwin

2,0512 gold badges29 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

patrick · Accepted Answer · 2010-01-04 19:01:59Z

1

I needed this "Initial Catalog" attribute

<add name="NewsTableConnectionString" connectionString="Data Source=XMACHINA\SQLEXPRESS;Integrated Security=True;Initial Catalog=News" providerName="System.Data.SqlClient" />

answered Jan 4, 2010 at 19:01

patrick

17.1k29 gold badges109 silver badges178 bronze badges

Collectives™ on Stack Overflow

How to set the database in ASP.Net

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related