I do not want to split connection strings using string manipulation functions to get Server, Database, Username, and Password. I read the following link and read the accepted answer, I found that is the best way to get username and password out from connection string, but what about Database Name? Right way to get username and password from connection string?
Tag: asp.net
Stored Procedures vs Code in Database Query
What are the performance differences between accessing a database to query using ASP.NET Code behind against using SQL Stored Procedure For ease of use, coding the query is easier, especially when …
sql runs fast in ssms slow in asp.net
I have been having this problem for a couple of weeks now. The problem is that the query takes 4-5 minutes to run on the website and at most 2 or 3 seconds to run in ssms. Also I found that after I make a change to this query like adding the customerId variable it will start running quickly on
How to convert last insert id into string?
I have a create account page and on the page I have one button to insert all the details into two seperate tables one of the tables Pictures is dependant on the User table 1:1 relationship via UserID. I have written some code to try get the last insert id so I can insert into the pictures table: Not sure
How do I safely read from a stream in asp.net?
If: Reading from a stream in a single call to Read is very dangerous. You’re assuming all the data will be made available immediately, which isn’t always the case. You should always loop round, reading until there’s no more data. How should I change the above code to make it ‘less dangerous’? Answer Jon Skeet actually has a really good