C#

IService1 File:

[OperationContract]
WBGTS.DataEntities.dsEntities.IndustryDataTable GetIndustries()

Service1 File:

public WBGTS.DataEntities.dsEntities.IndustryDataTable GetIndustries()
{
WBGTS.DataAccess.dsIndustryTableAdapter taIndustry = new WBGTS.DataAccess.dsIndustryTableAdapter();
return taIndustry.GetIndustries();
}

Windows Form:

Form_Load(object sender, eventargs e)
{
ServiceReference1.ServiceClient proxy = new ServiceReference1.ServiceClient();
dsEntities.Industries.Merge(proxy.GetIndustries());
}

<br />
Byte[] fileData = File.ReadAllBytes(file.FullName);       <br />
String fileAsString = System.Text.Encoding.Unicode.GetString(fileData);<br />

String line = null;
int lineNum = 0;

// open the file in binary mode
using (Stream stream = file.Open(FileMode.Open, FileAccess.Read))
{
	byte[] readBuffer = new byte[16384]; // our input buffer
	int bytesRead = 0; // number of bytes read
	int offset = 0; // offset inside read-buffer
	long filePos = 0; // position inside the file before read operation
	while ((bytesRead = stream.Read(readBuffer, offset,
	readBuffer.Length - offset)) > 0)
	{
		line = System.Text.Encoding.Unicode.GetString(readBuffer);
		
		MatchCollection matches = regEx.Matches(line);
		if (matches.Count > 0)
		{
			foreach (Match match in matches)
			{
				if (match.Success)
				{
					 StoreMatch(match.Captures[0].Value);
				}
			}
		}

		// store file position before next read
		filePos = stream.Position;

		// store the last few characters to ensure matches on "chunk boundaries"
		//offset = bufferToLookFor.Length;
		
		offset = (task.Search.Replacement.Length * 2); // crude set of a chunk boundary
		for (int i = 0; i < offset; i++)
			readBuffer[i] = readBuffer[readBuffer.Length - offset + i];
	}
}

private static TaskSearchResult SearchUNC(TaskSearch task)
{
	if (!task.Location.Equals(_location))
	{
		_location = task.Location;
		_locationFilePath = new DirectoryInfo(task.Location.Path);
	}
	task.Search = new SearchRegEx(task.Search);
	
	TaskSearchResult taskResult = new TaskSearchResult();
	taskResult.Result = true;

	//Check if Directory Exists
	if (_locationFilePath.Exists)
	{
		//Call Location search, combine results
		taskResult.Combine(SearchFileLocation(_locationFilePath, task));
	}
	else
	{
		taskResult.Result = false;
		taskResult.SearchResults.Add(new SearchResult(task.Location.Path, String.Format("Directory {0} does not exist", task.Location.Path)));
	}
	
	return taskResult;
}
private static TaskSearchResult SearchFileLocation(DirectoryInfo directory, TaskSearch task)
{
	TaskSearchResult taskResult = new TaskSearchResult();
	Console.WriteLine("* File Location being searched {0}", directory.FullName);
	try
	{
		FileInfo[] files = directory.GetFiles(task.Location.Filter, SearchOption.TopDirectoryOnly);
		//Iterate thru all the files in this location
		foreach (FileInfo fi in files)
		{
			try
			{
				if (IsTextFile(fi))
				{
					taskResult.Combine(SearchFile(fi, task));
				}
				else
				{
					//TODO Possibly make the "Large File Size" a config option
					if (fi.Length > (1024 * 1024)) // 1024B * 1024 = 1MB
						taskResult.Combine(SearchFileBinaryLarge(fi, task));
					else
						taskResult.Combine(SearchFileBinary(fi, task));
				}
			}
			catch (Exception ex)
			{
				Console.WriteLine(String.Format("File :{0} Error: {1} \n", fi.FullName, ex.Message));
				taskResult.SearchResults.Add(new SearchResult(task.Location.Path, String.Format("{0} - Error:{1}", fi.FullName, ex.Message)));
				//result += String.Format("File :{0} Error: {1} \n", fi.FullName, ex.Message);
			}
		}

		//If task Location IsRecusive, get the Sub Dirs to iterate thru
		if (task.Location.IsRecursive)
		{
			//get directories to search
			DirectoryInfo[] directories = directory.GetDirectories();
			foreach (DirectoryInfo subDirectory in directories)
			{
				taskResult.Combine(SearchFileLocation(subDirectory, task));
			}
		}
	}
	catch (Exception ex)
	{
		taskResult.SearchResults.Add(new SearchResult(task.Location.Path,String.Format("{0} - Error:{1}", directory.FullName, ex.Message)));
	}

	return taskResult;
}

data_set = new DataSet();

sql_connection = new SqlConnection("Data Source=.\\SQLEXPRESS;initial catalog=rent_a_car_company;integrated security=true");
sql_connection.Open();

sql_command = new SqlCommand("sp_get_agreement_by_id", sql_connection);
sql_command.CommandType = CommandType.StoredProcedure;
sql_command.Parameters.Add("@vehicle_id", SqlDbType.Int).Value = 1;
sql_adapter = new SqlDataAdapter(sql_command);
sql_adapter.Fill(data_set);
// sql_adapter.Dispose();

// sql_connection.Close();

ReportDocument rptDoc = new ReportDocument();
rptDoc.Load(@"C:\Users\Jassim\Documents\Visual Studio 2008\Projects\Taajeer\Taajeer\agreement.rpt");
rptDoc.SetDataSource(data_set);
crystalReportViewer1.ReportSource = rptDoc;