Using the Web.Config to set up my SQL database connection string?
Can anyone help me out please? I’m confused.
sql-server-2008
Asp.Net 4.0 Storing Session in SqlServer
I Have Database provided by shared hosting. I want to store the session in sql server but it give me error:
Generate ASP.Net Membership password hash in pure T-SQL
I’m attempting to create a pure t-sql representation of the default SHA-1 password hashing in the ASP.Net Membership system. Ideally, what I would get would be this:
export from sql server to excel file using asp.net and vb.net?
is there a way to export the whole data in one table from sql server 2008 directly using asp.net and vb.net without using datagridview to EXCEL FILE?
Ordering SQL Server results by IN clause
I have a stored procedure which uses the IN clause. In my ASP.NET application, I have a multiline textbox that supplies values to the stored procedure. I want to be able to order by the values as they were entered in the textbox. I found out how to do this easily in mySQL (using FIELD function), but not a SQL Server equivalent.
Getting Sql Server Data Tools to work with Visual Studio 2012 Express Release Candidate
I’m struggling with migrating to Visual Studio 2012 Express Edition to handle a project that includes a database project with a .dbproj extension. This blog http://visualstudiomagazine.com/blogs/data-driver/2012/06/getting-visual-studio-2012-and-ssdt-to-work-together.aspx gives the impression that with a bit of work this is all basically manageable.
Check if user is already logged in asp.net website
I am developing a website where in user is required to login to the system to be able to use it. The current functionality is:
When user enters username and password, a check is made in DB to check if that user exists and if he has entered a correct password.
Only then allow that user to login.
error: 26 – Error Locating Server/Instance Specified. (Can’t connect to my local Db From my host server)
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 :
Can’t save byte[] array data to database in C#. It’s saving 0x
I am trying to upload a file and save it’s binary content to my database field. Each time I try to save, it simply enters the database as 0x.
Changing connection string dynamically
I have a scenario where i am getting dynamically generated databases. I want to create a connection string for each database. So only initial catalog parameter will be changing. Other parameters i ll get it from web config file. It is already having all entries of connection string. I want to change only initial catalog part dynamically based on database created.