What does connection string consists of ?
Answer Posted / m.chandran
Connection String for SQL Server consist of:
1.Data Source or server= “.”; or "Localhost" or "127.0.0.1" or "serverNameinstanceName" or "N/W SQL server IP Address" Server instance.
2.Initial Catalog or database = “DATABASE_NAME”;
Either3.Uid=”UserID for SQL server” and Password= “Password for SQL server”;
ORIntegrated Security=”True”; Use Windows security
optional
5.Provider Name =”System.Data.SqlClient”;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?
What is ado recordset?
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
Define different execute methods of ADO.NET command object ?
What are the different methods available under the sqlcommand class to access the data?
What is serialization and de-serialization in .net?
What connected data?
Explain ado.net features?
What is data control techniques?
How to Read, Add, Update and Delete record in Entity Framework ?
How to connect and retrieve data from database using dataset
What is ado.net object model?
What are the objects of ado.net?
What is ado circle?
What is execute scalar in ado.net?