I’ve done a asp.net application to generate reports over a particular data. Initially i created local reports (.rdlc) to generate reports. I created separate .xsd for each rdlc and designed the reports. I build the dataset programmatically and bind it to the rdlc. I used the following code for binding the datasource to the reports –
I had this method to insert new company to database but I have problem with List<Contacts> because I want to be able to insert multiple contact for company. Could someone help me?
I have an ODBC connection to a database and I would like the user to be able to view data within any table. As this is an ASP.net application I cannot trust that the table name sent doesn’t also contain nasties. I have tried using a parameterised query but I always get an error saying that I “Must declare the table variable” – this appears to be an issue because it is the table name
This is the connection string that gets generated with the “New ASP.Net Website” template in vs 2010
I created a new database (AC_2012) on my localhost in SQL Server 2008 Management Studio.
I have added a database file (.mdf) to my application using Visual Studio built-in functionality. Database is in the App_Data folder. It is running fine. But when I publish it and upload it to server it gives this error.
It seems that whenever I add anything to my project which uses code in my commonClass.vb file, I get errors about SQL Server not being recognized.
SELECT CAST ([content_html] AS XML).query('/root/Physicians/specialty/a') AS [Specialty1] , CAST ([content_html] AS XML).query('/root/Physicians/specialty2/a') AS [Specialty2] , CAST ([content_html] AS XML).query('/root/Physicians/specialty3/a') AS [Specialty3] , CAST ([content_html] AS XML).query('/root/Physicians/specialty4/a') AS [Specialty4] , CAST ([content_html] AS XML).query('/root/Physicians/specialty5/a') AS [Specialty5] , CAST ([content_html] AS XML).query('/root/Physicians/specialty6/a') AS [Specialty6] FROM [db].[dbo].[content] WHERE [folder_id] = '188' AND (content_status = 'A') ORDER BY [content_title] … Read more
I already asked this question before, but without any good response,
my problem is that I have a local database (aspnetdb.mdf) in my app_data folder, here is the connection string in the web.config :
I Recently began learning ASP.net / SQL. I Installed Sql Server 2008R2 Express Edition; and Visual Web Designer 2008 Express Edition. I recently tried to create a login page and was unsuccessful; any help would be appreciated. I tried by taking the following steps:
-Create New WebSite
-Go to design view
-Drag “login status” into design view; Drag “Login” control onto design view as well;
-In Web.config I changed the authentication to “forms” (didnt add anything else)
-Run the page without debug / Type in any information in the login to have a “ASPNETDB.MDF” file automatically created into my “app_data” folder;
and i receive the error below.