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 the difference between sqlcommand and sqldataadapter?

727

---

can we create synonymn in ms access,sql server,my sql if so explain me with example

1829

---

What are dcl commands?

711

---

Define the data provider classes that is supported by ado.net?

744

---

What is fill method in ado.net?

721

---

Explain the difference between data reader and data adapter?

711

---

List all the steps in order, to access a database through ado.net?

816

---

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

1805

---

What are all the different methods under sqlcommand?

710

---

What is data adapter in ado.net with example?

705

---

How do you find the count of records in a dataset?

687

---

What are advantages of microsoft-provided data provider classes in ado.net?

767

---

What are the advantage of ado.net?

738

---

What are the important features of ado.net 2.0?

823

---

What is disconnected scenario in entity framework?

776

---