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 an ado?

946

---

How to Read, Add, Update and Delete record in Entity Framework ?

997

---

What is the difference in an abstract class and an interface?

954

---

What is basic use of data view?

949

---

What we do with the object of ado.net dataset after using it?

964

---

Explain the namespaces in which .net has the data functionality class.

1022

---

What is ado and rdo?

868

---

What are the steps to connect to a database?

983

---

What are the various methods provided by the DataSet object to generate XML?

973

---

What is maximum pool size in ado.net connection string?

934

---

What is variable view?

834

---

Explain how do you connect to sql server database without using sqlclient?

946

---

Describe ado.net object model in detail.

952

---

What is a dynaset in access?

1022

---

The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx

1978

---