Connection timeout for SQL server
Can I increase the timeout by modifying the connection string in the web.config?
ado.net
How DataReader works?
I was thinking that the SQLDataReader should not work if there is no connection to the SQLServer.
Unable to find the requested .Net Framework Data Provider in Visual Studio 2010 Professional
Why am I getting “Unable to find the requested .Net Framework Data Provider” when trying to setup a new datasource in Visual Studio 2010 Professional?
Using ASP.Net MVC with Classic ADO.Net
I am looking out for a way to access stored procedures using Classic ADO.Net, since I am new to ASP.Net MVC I do not know how to go about it.
Entity Framework v2 doesn’t support sql 2000?
I installed the beta 2 of Visual Studio 2010 today. I went to test out the new entity framework stuff (to see if my “issues” from v1 were fixed.).
How to get Database Name from Connection String using SqlConnectionStringBuilder
I do not want to split connection strings using string manipulation functions to get Server, Database, Username, and Password.
How to use executeReader() method to retrieve the value of just one cell
I need to execute the following command and pass the result to a label. I don’t know how can i do it using Reader. Someone can give me a hand?
How can I retrieve a table from stored procedure to a datatable?
I created a stored procedure so as to return me a table.
Keyword not supported: ‘server’
I’ve been trying to edit my connection string for uploading my website to a server.
I am not really experienced with this. I got this exception: the Keyword not supported: ‘server’.
Here is my connection string:
ExecuteScalar(); With scope_identity() Generating “System.InvalidCastException: Specified cast is not valid”
I did it 🙂 My sql server 2008 returns
System.Decimal packed into ‘object’.
Try to use System.Convert.ToInt32
instead of cast.