Connecting C# Applications to SQL

Connecting C# Applications to SQL:
Creating Sql Connection:
There are different ways to create a Sql connection. Most commonly used are
·         Through UDL file
·         From C# Application 
Through UDL File:
·         Create a new text document file.
·         Open the file.
·         Name the file and save the file with .UDL extension.
·         A new UDL file will be created.
·         Right click the file and go to Properties.
·         A properties window will be displayed like this.
·         Go to the Provider tab.
·         Select Microsoft OLE DB Provider for SQL Server.
·         Now go to Connection tab.
·         Enter Server Name.
·         Select Windows Authentication if you are not a database user.
·         Select Sql Server Authentication if you are a database domain user.
·         Specify your User name and password which you use to connect to Sql Server.
·         Now select your Database.
·         Now click on Test Connection button.
·         If you have entered all information correctly a message box will appear”Test Connection Succeeded.”  
·         Now go to the UDL file and open it with notepad you will see a connection string in it which you will use in your application to connect to Sql server.
·         Now copy this connection string and use it in your application.
From C# Application:
·         Open a new WindowsFormApplication.
·         Go to the tab Tools.
·         Select Connect To Database.
·         A window will appear.
·         Choose your data source as Microsoft Sql Server.
·         Enter Server Name.
·         Select Windows Authentication if you are not a database user.
·         Select Sql Server Authentication if you are a database domain user.
·         Specify your User name and password which you use to connect to Sql Server.
·         Now select your Database.
·         Now click on Test Connection button.
·         If you have entered all information correctly a message box will appear “Test Connection Succeeded.”
·         Now in Server Explorer window you will see a connection.
·         Select that connection and go to properties window.
·         Here you will see a property Connection String and a string in front of that property this is your connection string that you will use in your application.




                       

Comments

Post a Comment

Popular posts from this blog

Using Progress Bar In C#

Image
Using Progress Bar in C#: Progress Bar is very commonly used control in many applications to display the progress of task being performed. Progress Bar is displayed when copying files, deleting files or installing some software. How to use Progress Bar: ·          Start New Windows Form Application. ·          Go to Toolbox. ·          Select Progress Bar and Drag it to your Form. To make Progress Bar working you need to know some properties of Progress Bar Progress Bar.Maximum: Defines how long it should run Progress Bar.Step: Defines how much it should increase current position of Progress Bar. Progress Bar.Style: How should it look like? There is also a very basic method which is used to run Progress Bar properly. Progress Bar.PerformStep() Let’s see an example. In this example we will copy files and folders from one location to another and show the progress bar wh...
Read more

Get elements by class name in javascript

To get elements using class name we use getElementsByClassName method available with document object. This method takes name of class an argument.  It returns array of elements because more than one element(s) can have same class. < input type ="button" value ="Get By Class" onclick =" GetByClassName() " /> < div id ="myDiv" class ="myClass">     This is a div </ div > < script type ="text/javascript">   function GetByClassName() {         var elements = document.getElementsByClassName( "myClass" );         if (elements.length > 0) {             alert(elements[0].innerHTML);         }     else       alert( "No matching element found" );    }   </ script >
Read more

Jquery serer side datatables in asp.net

In this post we will learn how we can implement jquery   server side datatables in asp.net mvc application. We need to add datatables library to our page, we can add references of libray from datatables <a href="https://datatables.net/" target="_blank">website</a>. We need to create an html table on which we will apply datatable. <table class="table table-striped table-bordered table-hover table-checkable order-column dataTable" id="tblInventoryItems">   <thead>     <tr>       <th>Item Name</th>       <th>Item Price</th>       <th>Item Quantity</th>       <th></th>     </tr>   </thead>   <tbody></tbody> </table> Then we need the code which will apply the datatable to above html table. Below is the code to apply datatable $("yourtableid").DataTable({         "p...
Read more