C#

Member 11956589 wrote:

which is filled from a SQL database using a SELECT query

foreach (DataRow animalsDataRow in ds.Tables["Animals"].Rows)
         {
            // Do Something with animalsDataRow<br />
         }

Member 11956589 wrote:

and tells me that there is a Null value.

DataSet ds = new Dataset();

private void searchBtn_Click(object sender, EventArgs e)
    {


  string connectionString = "Data Source= ... your connection string";

            SqlDataAdapter da = new SqlDataAdapter(
                "SELECT your fields " +
                "FROM Animals" +
                "WHERE gender = @searchFor",
            connectionString);

            da.SelectCommand.Parameters.AddWithValue("@searchFor", tbSearch.Text);
            // Fill the DataSet.
            da.Fill(ds);

            DataTable animals = ds.Tables["Animals"];
            foreach (DataRow row in animals.Rows)
            {
               //operation with rows
            }
        }

namespace YourNameSpace
{
    public abstract class Animal
    {
        public string Name;

        public abstract string MyAbstractMethod();

        public virtual string MyVirtualMethod()
        {
            return string.Format("Animal: {0}", Name);
        }
    }

    public class Mammal : Animal
    {
        public override string MyAbstractMethod()
        {
            return string.Format("Mammal: {0}", Name);
        }

        public new string MyVirtualMethod()
        {
            return string.Format("Mammal: {0}", Name);
        }
    }

    public class Dog : Mammal
    {
        public new string MyAbstractMethod()
        {
            return string.Format("Dog: {0}", Name);
        }

        public new string MyVirtualMethod()
        {
            return string.Format("Dog: {0}", Name);
        }
    }
}

namespace YourNameSpace
{
    private void TestAnimal()
    {
        Dog myDog = new Dog();
        myDog.Name = "Spot";
    
        string dname = myDog.MyAbstractMethod();
    
        string mname = (myDog as Mammal).MyAbstractMethod();
    
        string aname = (myDog as Animal).MyAbstractMethod();
    
        string dname2 = myDog.MyVirtualMethod();
    
        string mname2 = (myDog as Mammal).MyVirtualMethod();
    
        string aname2 = (myDog as Animal).MyVirtualMethod();

        // set a break-point here and observe variable values:
        // repeat until 'understanding' happens :)
    }
}

Member 10476529 wrote:

Now I need to kepp this WPF-Window to be ALWAYS on top.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

<requestedExecutionLevel level="asInvoker" UiAccess="true" />

Unhandled WPF exception
Exception thrown:
System.ComponentModel.Win32Exception (0x80004005): Diese Anwendung konnte nicht gestartet werden, da die Side-by-Side-Konfiguration ungültig ist. Weitere Informationen finden Sie im Anwendungsereignisprotokoll. Weitere Details können auch mit dem Befehlszeilentool sxstrace.exe angezeigt werden
   at System.Diagnostics.Process.StartWithShellExecuteEx(ProcessStartInfo startInfo)
   at System.Diagnostics.Process.Start()
   at System.Diagnostics.Process.Start(ProcessStartInfo startInfo)
   at ICSharpCode.SharpDevelop.Services.WindowsDebugger.StartWithoutDebugging(ProcessStartInfo processStartInfo)
   at ICSharpCode.SharpDevelop.Project.DefaultProjectBehavior.Start(Boolean withDebugging)
   at ICSharpCode.SharpDevelop.Project.ProjectBehavior.Start(Boolean withDebugging)
   at ICSharpCode.SharpDevelop.Project.ProjectBehavior.Start(Boolean withDebugging)
   at ICSharpCode.SharpDevelop.Project.ProjectBehavior.Start(Boolean withDebugging)
   at ICSharpCode.SharpDevelop.Project.ProjectBehavior.Start(Boolean withDebugging)
   at ICSharpCode.SharpDevelop.Project.AbstractProject.Start(Boolean withDebugging)
   at ICSharpCode.SharpDevelop.Project.Commands.Execute.<>c__DisplayClass1.<Run>b__0(Object param0, EventArgs param1)
   at ICSharpCode.SharpDevelop.Project.Commands.AbstractBuildMenuCommand.OnBuildComplete(EventArgs e)
   at ICSharpCode.SharpDevelop.Project.Commands.AbstractBuildMenuCommand.CallbackMethod(BuildResults results)
   at ICSharpCode.SharpDevelop.Project.BuildEngine.<ReportDone>b__3()
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(Object source, Delegate method, Object args, Int32 numArgs, Delegate catchHandler)

---- Recent log messages:
13:32:18.552 [1] DEBUG - ActiveWorkbenchWindowChanged to [AvalonWorkbenchWindow: WpfModalDialog*]
13:32:18.552 [1] DEBUG - NavigationService
	ActiveViewContent: WpfModalDialog
	          Subview: TabPageText
13:32:18.552 [1] DEBUG - ActiveViewContentChanged to ICSharpCode.SharpDevelop.Project.Dialogs.ProjectOptionsView
13:32:22.153 [1] DEBUG - Activated feature 'ICSharpCode.SharpDevelop.Project.Commands.ExecuteWithoutDebugger', activation=Toolbar
13:32:22.161 [1] DEBUG - Activated feature 'ICSharpCode.SharpDevelop.Project.BuildEngine.Build'
13:32:22.162 [1] INFO - Start building WpfModalDialog
13:32:22.162 [1] DEBUG - CompilerMessageView: Combined 2 appends.
13:32:22.162 [26] DEBUG - Setting property CurrentSolutionConfigurationContents to '<SolutionConfiguration><ProjectConfiguration Project="{38951BDB-95FB-46CE-900E-0B4FF29292F9}">Release|AnyCPU</ProjectConfiguration></SolutionConfiguration>'
13:32:22.162 [26] DEBUG - Setting property SolutionDir to 'C:\temp\SharpDevelop\wpfmodaldialog\'
13:32:22.162 [26] DEBUG - Setting property SolutionExt to '.sln'
13:32:22.162 [26] DEBUG - Setting property SolutionFileName to 'WpfModalDialog.sln'
13:32:22.162 [26] DEBUG - Setting property SolutionName to 'WpfModalDialog'
13:32:22.162 [26] DEBUG - Setting property SolutionPath to 'C:\temp\SharpDevelop\wpfmodaldialog\WpfModalDialog.sln'
13:32:22.263 [17] DEBUG - Received command ReportEvent
13:32:22.309 [17] DEBUG - Received command ReportEvent
13:32:22.322 [17] DEBUG - Received command ReportEvent
13:32:22.581 [17] DEBUG - Received command ReportEvent
13:32:22.873 [17] DEBUG - Received command ReportEvent
13:32:22.889 [17] DEBUG - Received command ReportEvent
13:32:22.892 [17] DEBUG - Received command ReportEvent
13:32:22.893 [17] DEBUG - Received command BuildDone
13:32:22.894 [17] INFO - Finished building WpfModalDialog, success=True
13:32:22.894 [17] INFO - Start building WpfModalDialog
13:32:22.894 [14] INFO - Finished building WpfModalDialog, success=True
13:32:22.895 [1] INFO - Debugger Command: Start (withDebugger=False)

---- Post-error application state information:
Installed 3rd party AddIns: 
Workbench.ActiveContent: ICSharpCode.SharpDevelop.Project.Dialogs.ProjectOptionsView
ProjectService.OpenSolution: [Solution: FileName=C:\temp\SharpDevelop\wpfmodaldialog\WpfModalDialog.sln, HasProjects=True, ReadOnly=False]
ProjectService.CurrentProject: [CSharpProject: WpfModalDialog]

Fehler beim Generieren des Aktivierungskontextes für "C:\temp\SharpDevelop\wpfmodaldialog\WpfModalDialog\bin\Release\Test.exe".
Fehler in Manifest- oder Richtliniendatei "C:\temp\SharpDevelop\wpfmodaldialog\WpfModalDialog\bin\Release\Test.exe" in Zeile 18.
Das "UiAccess"-Attribut ist in diesem Kontext nicht zulässig im requestedExecutionLevel-Element.

namespace Technewlogic.Samples.WpfModalDialog
{	
	/// <summary>
	/// Interaction logic for App.xaml
	/// </summary>
	public partial class App : Application
	{
        public bool TopMost { get; private set; }
        // couldn't find a .NET-way to bring the window
        // to top, reverting to old Win32 functions...
        [System.Runtime.InteropServices.DllImport("User32.dll", CharSet = CharSet.Unicode)]
        public static extern Int32 FindWindow(String lpClassName, String lpWindowName);
        [System.Runtime.InteropServices.DllImport("User32.dll", CharSet = CharSet.Unicode)]
        public static extern Int32 SetForegroundWindow(int hWnd);
        
        private void triMain_Click(object sender, System.EventArgs e)
        {
            int hWnd = FindWindow(null, "Test"); // Win32 API, don't want to use this
            SetForegroundWindow(hWnd); // Win32 API, don't want to use this
            TopMost = true;
            Show();
        }

        private void Show()
        {
            throw new NotImplementedException();
        }
...

Benjamin.Buhr wrote:

Is there a method to put a timer in this so the application always becomes TopMost (about every 10 seconds)?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

	...
public partial class App : Application
	{
        // 24.09.2015: Timer in WPF
        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            System.Windows.Threading.DispatcherTimer dispatcherTimer = new System.Windows.Threading.DispatcherTimer();
            dispatcherTimer.Tick += new EventHandler(dispatcherTimer_Tick);
            dispatcherTimer.Interval = new TimeSpan(0, 0, 10);
            dispatcherTimer.Start();
        }

        private void dispatcherTimer_Tick(object sender, EventArgs e)
        {
            //listBox1.Items.Add(DateTime.Now.ToString("HH:mm:ss"));
            //System.Windows.Input.CommandManager.InvalidateRequerySuggested();
            //listBox1.Items.MoveCurrentToLast();
            //listBox1.SelectedItem = listBox1.Items.CurrentItem;
            //listBox1.ScrollIntoView(listBox1.Items.CurrentItem);
            SystemSounds.Beep.Play();
            InitializeComponent();
        }

        // 24.09.2015: Keep my application on top
        public bool TopMost { get; private set; }
...

public partial class App : Application
	{
            System.Windows.Threading.DispatcherTimer dispatcherTimer = new System.Windows.Threading.DispatcherTimer();

        // 24.09.2015: Timer in WPF
        private void Window_Loaded(object sender, RoutedEventArgs e)
        {

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

<Application x:Class="Technewlogic.Samples.WpfModalDialog.App"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
	Startup="Application_Startup">
	
    <Application.Resources>
    </Application.Resources>
	
</Application>

using System;
using System.Runtime.InteropServices;
using System.Security;
using System.Threading;
using System.Windows;

namespace Technewlogic.Samples.WpfModalDialog
{	
	/// <summary>
	/// Interaction logic for App.xaml
	/// </summary>
	public partial class App : Application
	{
        // 24.09.2015: Timer in WPF
        System.Windows.Threading.DispatcherTimer dispatcherTimer = new System.Windows.Threading.DispatcherTimer();
        private void dispatcherTimer_Tick(object sender, EventArgs e)
        {
            TopMost = true;
            this.TopMost = true;
            //MessageBox.Show("Popup: dispatcherTimer_Tick");
            InitializeComponent();
        }

        // 24.09.2015: Keep my application on top
        public bool TopMost { get; set; }
        // couldn't find a .NET-way to bring the window
        // to top, reverting to old Win32 functions...
        [SuppressUnmanagedCodeSecurity]
        public class SafeNativeMethods
        {
            [System.Runtime.InteropServices.DllImport("User32.dll", CharSet = CharSet.Unicode)]
            public static extern Int32 FindWindow(String lpClassName, String lpWindowName);
            [System.Runtime.InteropServices.DllImport("User32.dll", CharSet = CharSet.Unicode)]
            public static extern Int32 SetForegroundWindow(int hWnd);
        }

        private void triMain_Click(object sender, System.EventArgs e)
        {
            int hWnd = SafeNativeMethods.FindWindow(null, "Test"); // Win32 API, don't want to use this
            SafeNativeMethods.SetForegroundWindow(hWnd); // Win32 API, don't want to use this
            TopMost = true;
        }

        // Only One Instance of App allowed
        private void Application_Startup(object sender, StartupEventArgs e)
		{
            // 24.09.2015: Keep my application on top + Timer in WPF
            dispatcherTimer.Tick += new EventHandler(dispatcherTimer_Tick);
            dispatcherTimer.Interval = new TimeSpan(0, 0, 1);
            dispatcherTimer.Start();

            bool createdNew;
      		Mutex mutex = new Mutex(true, this.GetType().GUID.ToString(), out createdNew);
      		if (createdNew)
      			{
                	Window window = new MainWindow();
        			window.Closed += (sender2, args) => mutex.Close(); ;
        			window.Show();
                }
      		    else
      			{
        			// MessageBox.Show("App already running...");
        			mutex.Close();
        			Application.Current.Shutdown();
      			}
		}
    }
}

public class SafeNativeMethods
{
    [System.Runtime.InteropServices.DllImport("User32.dll", CharSet = CharSet.Unicode)]
    public static extern Int32 FindWindow(String lpClassName, String lpWindowName);
    [System.Runtime.InteropServices.DllImport("User32.dll", CharSet = CharSet.Unicode)]
    public static extern Int32 SetForegroundWindow(int hWnd);
}

using System;
using System.Diagnostics;
using System.Windows;
using System.Runtime.InteropServices;

namespace Technewlogic.Samples.WpfModalDialog
{
    /// <summary>
    /// Interaction logic for MainWindow.xaml
    /// </summary>

    public partial class MainWindow : Window
	{
        // 28.09.2015: C# Check If Application Is Already Running Then Set Focus
        [DllImport("user32.dll")]
        private static extern bool SetForegroundWindow(IntPtr hWnd);
        [DllImport("user32.dll")]
        private static extern bool ShowWindowAsync(IntPtr hWnd, int nCmdShow);
        [DllImport("user32.dll")]
        private static extern bool IsIconic(IntPtr hWnd);
            /*
            const int SW_HIDE = 0;
            const int SW_SHOWNORMAL = 1;
            const int SW_SHOWMINIMIZED = 2;
            const int SW_SHOWMAXIMIZED = 3;
            const int SW_SHOWNOACTIVATE = 4;
            const int SW_RESTORE = 9;
            const int SW_SHOWDEFAULT = 10;
            */
        const int swRestore = 9;

        // 25.09.2015: Timer fiering
        System.Windows.Threading.DispatcherTimer dispatcherTimer = new System.Windows.Threading.DispatcherTimer();
        private void dispatcherTimer_Tick(object sender, EventArgs e)
        {
            //MessageBox.Show("Popup: MainWindow_TimerTick");
            // 28.09.2015: C# Check If Application Is Already Running Then Set Focus
            var me = Process.GetCurrentProcess();
            var arrProcesses = Process.GetProcessesByName(me.ProcessName);

            if (arrProcesses.Length > 1)
            {
                for (var i = 0; i < arrProcesses.Length; i++)
                {
                    if (arrProcesses[i].Id != me.Id && arrProcesses[i].SessionId == me.SessionId)
                    {
                        // get the window handle
                        IntPtr hWnd = arrProcesses[i].MainWindowHandle;
                        // if iconic, we need to restore the window
                        if (IsIconic(hWnd))
                        {
                            ShowWindowAsync(hWnd, swRestore);
                        }
                        // bring it to the foreground
                        SetForegroundWindow(hWnd);
                        break;
                    }
                }
            }
        }

        // Main Window
        public MainWindow()
		{
			
			//Alt-Tab preventing
			Window w = new Window(); // Create helper window
        	w.Top = -100; // Location of new window is outside of visible part of screen
        	w.Left = -100;
        	w.Width = 1; // size of window is enough small to avoid its appearance at the beginning
        	w.Height = 1;
        	w.WindowStyle = WindowStyle.ToolWindow; // Set window style as ToolWindow to avoid its icon in AltTab 
        	w.Show(); // We need to show window before set is as owner to our main window
        	this.Owner = w; // Okey, this will result to disappear icon for main window.
        	w.Hide(); // Hide helper window just in case

            // 25.09.2015: Timer settings
            dispatcherTimer.Tick += dispatcherTimer_Tick;
            dispatcherTimer.Interval = new TimeSpan(0, 0, 5);
            dispatcherTimer.Start();
            //Initialisierung der Komponenten
            InitializeComponent();
			ModalDialog.SetParent(ModalDialogParent);
		}

        // ModalDialog
        private void ShowModalDialog_Click(object sender, RoutedEventArgs e)
    	{
            var res = ModalDialog.ShowHandlerDialog(MessageTextBox.Text);
			var resultMessagePrefix = "Result: ";
			if (res)
				ResultText.Text = resultMessagePrefix + "OK";
			else
				ResultText.Text = resultMessagePrefix + "Break";
		}
	}
	
}