Add Connection String in Web.Config File

By -
First option can be used for windows authentication and second option is for SQL server authentication.
1. <connectionStrings>
    <add name="CustConnectionString" connectionString="Data Source=localhost; Integrated Security=SSPI; Intial Catalog=LocalTestDB" providerName="System.Data.sqlClient"/>
</connectionStrings>

 2. <connectionStrings>
   <add name="CustConnectionString" connectionString="Data Source=localhost; uid=sa; pwd =" providerName="System.Data.sqlClient"/>
</connectionStrings>

Comments

Post a Comment

Popular posts from this blog

Enable HTTP Transport Security (HSTS) in IIS 7

By -
Q.  What is the best way to turn on   HTTP Strict Transport Security   on an IIS 7 web server? Ans:  This can be done by adding following block in Web.Config:               <system.webServer>                     <httpProtocol>                          <customHeaders>                               <add name ="X-CustomName" value="MyCustomValue"/>                                               </customHeaders>                    </httpProtocol>             </system.webServer> We have to configure ...
Read more

Steps To Create New Project/Team On TFS

By -
Image
Select New item from drop-down tab that will be on left of Dashboard tab. On click New Items from drop-down will open Create new team pop-up:-    Put new Team name > Give Description > Select permissions (if permissions is already there else create a new permissions). Create a new sprint:- Click on iteration > New > Add Iteration name > Start Date & End Date > Click Save and close button. Go to newly created project/team dashboard. Click Backlog in Work area Newly created sprint will be show in Backlog items:-
Read more

Difference Between Delete & Truncate in Sql Server

By -
INTRODUCTION While working on database, we are using Delete and Truncate without knowing the differences between them and when to use them . In this article we will discuss the difference between Delete and Truncate in Sql. Delete Delete is a DML command. Delete statement is executed using a row lock,each row in the table is locked for deletion. We can specify filters in where clause. It deletes specified data if where condition exists. Delete activities a trigger because the operation are logged individually. Slower than Truncate because it Keeps logs Truncate Truncate is a DDL command. Truncate table always lock the table and page but not each row.As it removes all the data. Cannot use Where condition.  It Removes all the data. Truncate table cannot activate a trigger because the operation does not log individual row deletions. Faster in performance wise, because it doesn't keep any logs. Note Delete and Truncate both can be rolled back when used with Tr...
Read more