What does connection string consists of ?
Answers were Sorted based on User's Feedback
Answer / sachin gupta
it consist
1. data source(Server)
2. database(Initial Catalog)
3. user name(Uid)
4. password(Pwd)
5. Integrated Security
6. Provider
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / ansu kamar
it consist of
data source
database
user name
password
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / hardit singh
sqlconnection con=new sqlconnection
("server=localhost;database=testdb;uid=sa;pwd=sa;");
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
How xml files and be read and write using dataset ?
What are the attirbutes of DataSet?
What is a column variable?
I am fresh graduate, trained in C# .net. How do i answer when interview ask me , Where do you see yourself within 5 years from now?
Difference between function and trigger?
What is data adapter in ado.net with example?
How can we serialize the dataset object?
What providers do you use to connect to oracle database ?
What is the difference between connected environment and a disconnected environment?
What is command class in ado.net?
What is difference in record set and dataset?
How do we invoke queries from the application
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)