Answer Posted / ashwani

using System;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;

class MainClass
{
static void Main(string[] args)
{
string SQL = "SELECT * FROM Orders";

string ConnectionString ="Integrated
Security=SSPI;Initial Catalog=Northwind;Data Source=localhost;";
SqlConnection conn = new
SqlConnection(ConnectionString);

SqlCommand StoredProcedureCommand = new
SqlCommand("Sales By Year", conn);
StoredProcedureCommand.CommandType =
CommandType.StoredProcedure;
SqlParameter myParm1 =
StoredProcedureCommand.Parameters.Add( "@Beginning_Date",
SqlDbType.DateTime, 20);
myParm1.Value = "7/1/1996";
SqlParameter myParm2 =
StoredProcedureCommand.Parameters.Add("@Ending_Date",
SqlDbType.DateTime, 20);
myParm2.Value = "7/31/1996";
conn.Open();
SqlDataReader TheReader =
StoredProcedureCommand.ExecuteReader();
string orderlist = "";
while (TheReader.Read())
{
string nextID = TheReader["OrderID"].ToString();
string nextSubtotal = TheReader["Subtotal"].ToString();
orderlist += nextID + '\t' + nextSubtotal + '\n';
}
conn.Close();
}
}

What is microsoft ado?

508

---

What is a dataview?

527

---

What is the difference between a datareader and a dataset?

508

---

What is the difference between sqlcommand and sqldataadapter?

491

---

What is data view and variable view?

478

---

---

What are the disadvantages of using datalist?

499

---

What is difference between datareader and dataadapter?

542

---

What is the role of the dataset object in ado.net?

565

---

What is ado rdo dao in visual basic?

641

---

What is openquery?

523

---

Is bulk insert faster than insert?

484

---

What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?

552

---

Which control of the BindingNavigator returns the current position within the data source?

727

---

Which provider is used to connect ms access, oracle, etc…?

518

---

What are all features of ADO.Net?

544

---