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 |
make a login control??
Which is faster ado.net or linq?
Execute nonquery returns no. of afected rows.So if my stored procedure hav lot of select stmnt, delete stmnt, insert stmnt..then what does execute nonquery returns in this case?
What DataReader class do in ADO.NET ?
What is different between sqlcommand object and command behavior object?
What is difference between Dataview and Datatable?
Which provider is used to connect ms access, oracle, etc…?
What is a control toolbox?
Describe ado.net object model in detail.
What is openquery?
Define executenonquery?
how to add a selected row of a gridview to another gridview without reloading the page??
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)