c# forms (holy crap i'm not ready for this)

[Lost User]

You will never learn programming from Google or Youtube. Get yourself a decent book that will teach you properly, starting with the basics. Time spent now will pay dividends in the future.

[Uranium 235]

actually this is throwing me an error. "

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);
    }
}

[Uranium 235]

I learned PHP and VB from googling. Actually I learned PHP because a game named Tribes used the zend engine and I picked up a PHP book and realized I knew the syntax better than the book. Did PHP for 10 years and made some pretty impressive stuff. I also did some stuff in VB that was pretty advanced. But I haven't done it in a few years (like, 4?) Once you learn many of the basics of .net, all I have left is translating it into the syntax of c#, which IMO has better structure than VB, and a structure i'm more familiar with (logic and conditions like PHP, some variables like C++, which I took in high school) I don't think I could relearn the VB crap. I'm used to &&, ||, if() foreach loops, all in PHP. One thing I didn't like is you can't do multiple logical comparisons in switch/case, but that it rarely used in PHP

[Lost User]

Your CreateDB form needs to return a valid DialogResult. See Form.ShowDialog Method (System.Windows.Forms) | Microsoft Docs[^].

[Uranium 235]

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

        return DialogResult.Cancel;
    }

I returned a DialogResult now I get Since 'TechTracker.CreateDB.Cancel_Click(object, System.EventArgs)' returns void, a return keyword must not be followed by an object expression and yeah I tried changing void to DialogResult and it gave me an error on the form

[Lost User]

The Cancel_Click is a delegate type, so it cannot return a value. It handles an event and then returns to the framework. You need to return your DialogResult from the main method of the form. See Form.ShowDialog Method (System.Windows.Forms) | Microsoft Docs[^].

[Uranium 235]

ok I get it, so I didn't even need cancel_click (this is a delegate, right?) at all since the DialogResult was already cancel in the form properties.

[Lost User]

Correct.

[Uranium 235]

ok, been working on it, i'd figure i'd just add to this instead of making a new thread. I've been messing with SQLite. What I want is to make a function to run the query, get row data and return it. Of course, rows are of mixed types, Using GetDataTypeName(), but storing these into an array is impossible because arrays can only be one type is there a way to store the row data into an array? I've tried the reader row data itself, but i'm not sure i'm going about it the right way this is the core section i'm trying. I've successfully done the query and got the data inside the function, just returning it is the problem

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;
    }

and return the row. I tried passing the reader up by reference but that was unsuccessful My error: Bad array declarator: To declare a managed array the rank specifier precedes the variable's identifier. To declare a fixed size buffer field, use the fixed keyword before the field type.

[Uranium 235]

oh duh I needed to specify 'Array' but now I get

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

[Uranium 235]

wait a second I used this

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;
                }

            }
              \*/

to try to load the query into a datatable (unsuccessfully, datatype problems), and you can just use .load()? That was a day well wasted