0

How could I connect my simple project in C# with SQLite?
Let's say, I have function in C# sendWords(letters,word)
The aim of function would be find words that will be able to construct word with my letters (able to use wildcards - where * means here could be anything).
Sample: word is do* and my letters are ihnkngz - one of the result would be doing If I place * anywhere there should be also another solution do*g => doing

In SQLite I must load dictionary with words, so here shouldn't be any problem, because I have it.

But the problem is that I'm yellow in using databases :( I really do not know where should I start.


SOLUTION

1 download dlls what you want from http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki

2 add reference from file you downloaded to your project

3 try code (add gridView and change TABLE PATH):

private void Show()
    {
        DataTable dt = new DataTable();

        String insSQL = "select * from TABLE";
        String strConn = @"Data Source=PATH";

        SQLiteConnection conn = new SQLiteConnection(strConn);

        SQLiteDataAdapter da = new SQLiteDataAdapter(insSQL, strConn);
        da.Fill(dt);

        dataGridView1.DataSource = dt.DefaultView;

    }

If it doesn't work, change in project's properities > build > platform > x64/x86 If you want create base try sqlite Administrator http://www.macoratti.net/10/03/c_sqlt1.htm

1 Answer 1

1

http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki

Just add a reference to System.Data.SQLite.dll. That's all.

Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.