.NET (Core and Framework)

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SQLite;
using System.IO;

namespace TechTracker
{
          
    
    public partial class Main : Form
    {
        public Main()
        {
            InitializeComponent();
        }


        private void Main_Load(object sender, EventArgs e)
        {
            if(!File.Exists(Directory.GetCurrentDirectory() + "\\Tracker.db"))
            {
                //yeah none of these worked
                //((CreateDB)this.Owner).Show();
                //Form CreateDBForm = CreateDB.FindForm();
                //TechTracker.CreateDB.ActiveForm.Visible = true;
                //System.Windows.Forms.Control.Invoke;
                 

            }
        }
    }
}

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace TechTracker
{
    public partial class CreateDB : Form
    {
        public CreateDB()
        {
            InitializeComponent();
            
        }
    }
}

CreateDB createForm = new CreateDB();
createForm.ShowDialog();     // Or .Show() depending on requirements

Uranium-235 wrote:

createDB is topmost enabled and won't let the main form be accessible when it's up.

CreateDB dbCreator = new CreateDB();
DialogResult rc = dbCreator.ShowDialog();
// check rc for success etc.

Quote:

Cannot implicitly convert type 'void' to 'System.Windows.Forms.DialogResult

public partial class Main : Form
{
    public Main()
    {
        InitializeComponent();
    }


    private void Main_Load(object sender, EventArgs e)
    {
        if(!File.Exists(Directory.GetCurrentDirectory() + "\\Tracker.db"))
        {
            this.Enabled = false;

            CreateDB dbForm = new CreateDB();
            DialogResult res = dbForm.ShowDialog(); //dbform error

            if (res == DialogResult.Cancel)
                Application.Exit();
        }
    }
}

public partial class CreateDB : Form
    {
        public event EventHandler CancelPressed;
        
        public CreateDB()
        {
            InitializeComponent();
                       
        }

        private void Cancel_Click(object sender, EventArgs e)
        {
            if (CancelPressed != null)
                CancelPressed(this, EventArgs.Empty);
        }
    }

private void Cancel_Click(object sender, EventArgs e)
        {
            //if (CancelPressed != null)
            //    CancelPressed(this, EventArgs.Empty);

            return DialogResult.Cancel;
        }

sqlite_cmd = sql_conn.CreateCommand();
sqlite_cmd.CommandText = sql_query;
sqlite_datareader = sqlite_cmd.ExecuteReader();

SQLLiteReader Row[];


//store reader data in an array?
    for(int i = 0; sqlite_datareader.Read(); i++)
    {
            Row[i] = sqlite_datareader;
    }

Array SQLLiteReader Row[];
                    ^^^
                    "; expected"
                        ^
                        identifier expected  

DataTable returnTable = new DataTable();
           DataColumn dtColumn;
           DataRow dataRow;

           MessageBox.Show(fieldCount.ToString());

           for (int i = 0; i <= (fieldCount - 1); i++)
           {
               //MessageBox.Show(sqlite_datareader.GetDataTypeName(i));

               switch (sqlite_datareader.GetDataTypeName(i))
               {
                   case "TEXT":
                       dtColumn = new DataColumn();
                       dtColumn.DataType = typeof(String);
                       dtColumn.ColumnName = sqlite_datareader.GetName(i);
                       returnTable.Columns.Add(dtColumn);
                   break;

                   case "INTEGER":
                       dtColumn = new DataColumn();
                       dtColumn.DataType = typeof(Int32);
                       dtColumn.ColumnName = sqlite_datareader.GetName(i);
                       returnTable.Columns.Add(dtColumn);
                   break;
               }
           }



           for (int j = 0; sqlite_datareader.Read(); j++)
           {
               for (int k = 0; (k <= fieldCount - 1); k++)
               {
                   MessageBox.Show(sqlite_datareader.GetDataTypeName(k));
                   MessageBox.Show(sqlite_datareader.GetName(k));

                   switch (sqlite_datareader.GetDataTypeName(k))
                   {

                       case "TEXT":
                           dataRow = returnTable.NewRow();
                           dataRow[sqlite_datareader.GetName(k)] = sqlite_datareader.GetString(k);
                           returnTable.Rows.Add(dataRow);
                           //returnTable.Rows.Add(sqlite_datareader.GetString(k));
                           break;

                       case "INTEGER":
                           dataRow = returnTable.NewRow();
                           dataRow[sqlite_datareader.GetName(k)] = sqlite_datareader.GetInt32(k);
                           returnTable.Rows.Add(dataRow);
                           //returnTable.Rows.Add(sqlite_datareader.GetString(k));
                           break;
                   }

               }
                 */

[Required]
[Index("IX_UniqueConstraintCaseAssignedToInvestigator", 2, IsUnique = true)]
[MaxLength (128)]
[ForeignKey(nameof(ApplicationUser))] // <-- Add this attribute
public string UserId { get; set; }
public ApplicationUser ApplicationUser { get; set; }

modelBuilder.Entity<CaseAssignedToInvestigator>()
    .HasOne(case => case.ApplicationUser)
    .WithMany() // Or: .WithMany(user => user.Cases)
    .HasForeignKey(case => case.UserId);