how to use App_Data databases

Posted by mohammedr88-18313 under ASP.NET on 3/7/2013 | Points: 10 | Views : 15448 | Status : [Member] | Replies : 6

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

hi is there any possible to use App_Data sql database ie insert , select , update ect

i have used the connection string below

<add name="connectionstring"
connectionString="data source=.\SQLEXPRESS2008R2;Integrated Security=true;AttachDBFilename=app_dataLocation\database.mdf;User Instance=true"
providerName="System.Data.SqlClient" />
</connectionStrings>

thanks in adavance

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Ranjeet_8 on: 3/7/2013 [Member] [MVP] Gold | Points: 25

0	Try this, <connectionStrings> <add name="connectionstring" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=\|DataDirectory\|\database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/> </connectionStrings> Refer this url: http://aspdotnetsiva.blogspot.in/2012/10/insertupdatedelete-records-from.html Please Mark As Answer if this helps you. . mohammedr88-18313, if this helps please login to Mark As Answer. \| Alert Moderator

Try this,

<connectionStrings>

  <add name="connectionstring" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>  </connectionStrings>

Refer this url:
http://aspdotnetsiva.blogspot.in/2012/10/insertupdatedelete-records-from.html

Please Mark As Answer if this helps you.

.

mohammedr88-18313, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Raj.Trivedi on: 3/7/2013 [Member] [MVP] Starter | Points: 25

0	<connectionStrings> <add name="ConnectionName" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=\|DataDirectory\|testdb.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings> Regard's Raj.Trivedi "Sharing is Caring" Please mark as answer if your Query is resolved mohammedr88-18313, if this helps please login to Mark As Answer. \| Alert Moderator

Regard's
Raj.Trivedi
"Sharing is Caring"
Please mark as answer if your Query is resolved

mohammedr88-18313, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: mohammedr88-18313 on: 3/8/2013 [Member] Starter | Points: 25

0	Dear maam / sir I have used your code but while connection to App_data database its throwing an exception beow Server Error in '/' Application. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Thanks mohammedr88-18313, if this helps please login to Mark As Answer. \| Alert Moderator

Dear maam / sir

I have used your code but while connection to App_data database its throwing an exception beow

Server Error in '/' Application.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Thanks

mohammedr88-18313, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ranjeet_8 on: 3/8/2013 [Member] [MVP] Gold | Points: 25

0	Refer this url http://www.sqlmusings.com/2009/03/11/resolving-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server/ Please Mark As Answer if this helps you. . mohammedr88-18313, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Raj.Trivedi on: 3/9/2013 [Member] [MVP] Starter | Points: 25

0	Hello Mohammedr88, can you please paste the code where are you getting error and also your code of appconfig. One more thing to use the App_Data database you should have atleast sql server express. Regard's Raj.Trivedi "Sharing is Caring" Please mark as answer if your Query is resolved mohammedr88-18313, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: mohammedr88-18313 on: 3/9/2013 [Member] Starter | Points: 25

0	Hi, thanks for helping me <connectionStrings> <add name="ConnectionName" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=\|DataDirectory\|testdb.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings> i have used above connection string ,the exception thrown while opening the connection to insert the values mohammedr88-18313, if this helps please login to Mark As Answer. \| Alert Moderator

Hi,
thanks for helping me
<connectionStrings>
<add name="ConnectionName"
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|testdb.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>

i have used above connection string ,the exception thrown while opening the connection to insert the values

mohammedr88-18313, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts