Interested to Buy Any Domain ? << Click Here >> for more details...
What does connection string consists of ?
- 4 Answers
- 11425 Views
- Digital GlobalSoft, I also Faced
- E-Mail Answers
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
What is difference between datagridview and datagrid control in winforms?
how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
Is datareader faster than datatable?
What are the different methods available under the sqlcommand class to access the data?
What is ole in excel?
What is commandbuilder in ado.net?
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
How do I delete a row from a DataTable?
What does executereader return?
Which object holds only data and does not interact with data source?
What is connected architecture in ado.net?
Explain the architecture of ado.net?
How to load multiple tables into a dataset?
How will you fill the gridview by using datatable object at runtime?
What is the difference between typed and untyped dataset?
