Database

using System;
using System.Data.SqlClient;

namespace ReportOrders
{
	
	class Report
	{
	
	[STAThread]
	static void Main(string[] args)
	{
	
	try
	{
	SqlConnection dataConnection = new SqlConnection();
	dataConnection.ConnectionString = "user ID=blah;pwd=BLAH;Initial Catalog=sellmdat2kSQL;Data Source=localhost";
	dataConnection.Open();
	Console.WriteLine("Please enter a Location ID (4 characters): ");
	string Location_ID = Console.ReadLine();
	Console.WriteLine("Please enter a Shift Number (4 characters): ");
	string Shift_Number = Console.ReadLine();
	SqlCommand dataCommand = new SqlCommand();
	dataCommand.Connection = dataConnection;
	dataCommand.CommandText = "SELECT sum (Amount)as Amount";
        //dataCommand.CommandText = "SELECT Sequence_Number, sum (Amount)as Amount";
	dataCommand.CommandText += "FROM transaction_table WHERE Location_id ='" + Location_ID + "' and Shift_Number='" + Shift_Number + "'";
	Console.WriteLine("About to execute: " + dataCommand.CommandText);
	SqlDataReader dataReader = dataCommand.ExecuteReader();
	while (dataReader.Read())
	{
	int Sequence_Number = dataReader.GetInt32(0);
	if (dataReader.IsDBNull(2))
	{
	Console.WriteLine("Shift Number {0} not yet closed\n\n", Shift_Number);
	}
	else
	{
	string Amount = dataReader.GetString(0);
	Console.WriteLine("Value {0}\nAdded Since Last Shift ", Amount );
	}
	}
	dataReader.Close();
	dataConnection.Close();
	}
	catch(Exception e)
	{
	Console.WriteLine("An error occurred accessing the database: " + e.StackTrace);
	}
	}
	}
}

Console.WriteLine("Current Shift Value on machine [" + Location_ID + "] is $" + dataReader["Value"].ToString());

SELECT TOP 10 FROM MyTable ORDER BY ClusteredIndexColumns DESC

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More