What is sql command in ado net?
Answer / Chandra Mohan Jha
The SQL command in ADO.NET is executed using the Connection object's CreateCommand() method. Here's an example:
```
SqlConnection connection = new SqlConnection("Data Source=(local);Initial Catalog=Northwind;Integrated Security=True");
SqlCommand command = new SqlCommand("SELECT * FROM Customers", connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
// Process the data
connection.Close();
```
| Is This Answer Correct ? | 0 Yes | 0 No |
What is main five diffrent between Connected And Disconnected environment
15 Answers HCL, Satyam, US India, Wipro,
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
What is the full form of ado?
How is entity framework different from ado.net?
What is shadow copy?
What is the difference between ado.net and oledb?
What is openquery?
How to Handle the exceptions in Sqlsrver2000
What is microsoft ado.net?
What is Debug.write does?
What are relation objects in dataset and how & where to use them?
What is dataset and datatable in ado.net?
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)