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 DataTableCollection?

1103

---

Which is the best method to get two values from the database?

1014

---

Which database is the ado.net?

1024

---

What is ado in agriculture?

1012

---

Explain all the classes those are used for database connections between sql server and asp.net?

1062

---

How do you merge 2 datasets into the third dataset in a simple manner?

1059

---

What is ado.net objects?

1014

---

Why is it important to close an ado.net application?

1078

---

How to perform sorting on a table in ADO.NET?

1080

---

How to add a javaScript function in a datagrid?

1180

---

What is aggregate root?

1188

---

What is the difference between an ADO.NET Dataset and an ADO Recordset?

1090

---

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

1059

---

Which is faster datareader or dataadapter?

1045

---

How to identify the updated rows in a dataset?

1055

---