C#

hello.. 
I'm developing a software? for my thesis using C# winform application.. it is an offline system.. and we are not allowed to make a web application..

my goal is to show pdf files from MySQL database without using Adobe Acrobat reader or any pdf viewer that has a printing tool because I want to disable the printing process.. please help me.. Is it possible to show pdf file in a panel? if so, how?.. or even in a picturebox?..

I want to disable the printing process because I want to control my printing process with a coin acceptor and an ARDUINO..

thank you..I hope you could help me..
Shiela Amante

I'm trying to read eventlogs from a server which has about 100 000 records using class EventLogReader(eventLogQuery).

I'm using pagination and each page will show only 25 records in my screen. So, I will be reading 25 records out of total records for the first page and next 25 records for the second page and so on.

My question is how to get the total records count for the below snippet like total rows affected because of that eventLogQuery applied on full set of events?

EventLogReader reader = new 
EventLogReader(eventLogQuery);
                reader.Seek(SeekOrigin.Begin, filter.PageStart);

eventLogs.TotalLogs = **totalRowsAffected**;                    
EventRecord eventInstance = reader.ReadEvent();

int i = filter.PageSize;
while (eventInstance != null && i-- > 0)
{
 try
 {
  eventLogs.Entries.Add(new EventLogData
  {
   Type = eventInstance.LevelDisplayName,
   Source = eventInstance.ProviderName,
   Time = eventInstance.TimeCreated,
   Category = eventInstance.TaskDisplayName,
   EventId = eventInstance.Id,
   User = eventInstance.UserId != null ? eventInstance.UserId.Value : "",
   Computer = eventInstance.MachineName,
   Message = eventInstance.FormatDescription(),
   FullXml = eventInstance.ToXml()
  });
 }catch{}
eventInstance = reader.ReadEvent();
}
}
return eventLogs;

		class public DBCall
{
private string connection_string = "...";

private void SomeMethod()
{
     var zipcode = ExecuteScalar<string>("select zipcode from ZIpcodes where Zip='92108'", connection_string);

}

public T ExecuteScalar<T>(string queryString, string connection_string)
		{
			using (OleDbConnection conn = new OleDbConnection (connection_string))
			{
				using (OleDbCommand cmd = new OleDbCommand (queryString , conn))
				{
					var result = cmd.ExecuteScalar ( );

					if (Convert.IsDBNull (result) && typeof (T).IsValueType)
						return default (T);                                         // if the db value is null, but T is a value type, set T = the default value of the type.
					else
						return (T) (result);
				}
			}
		}

		private void treeView1_NodeMouseClick(object sender , TreeNodeMouseClickEventArgs e)
		{

			if (e.Button == MouseButtons.Left)
			{
				string loadrowset = e.Node.Text;
				Rowset rowset = (Rowset) Enum.Parse (typeof (Rowset) , loadrowset);
				using (OleDbConnection conn = new OleDbConnection (ConnectionString))
				{
					OleDbSchemaTable s = new OleDbSchemaTable (rowset , conn);

					DataTable dt = new DataTable ( );
					dt = s.datatable;

					dataGridView1.Enabled = true;
					dataGridView1.DataSource = dt;	
				}

			}
			else
			{
				return;
			}

		}