http://sqlite.phxsoftware.com/forums/p/532/532.aspx
On Sun, Jan 11, 2009 at 12:18 PM, Alessio Forconi <forco...@gmail.com> wrote:
> It means that the connection that I use in the code that I showed you is
> the same as that used in other parts of the program, only that we do not
> work, I get that bug that I told you.
>
> Thanks for your availability.
>
> Roosevelt Anderson ha scritto:
>> What does your connection string look like?
>>
>> On Fri, Jan 9, 2009 at 2:36 PM, Alessio Forconi <forco...@gmail.com> wrote:
>>
>>> Thanks for your suggestion, I do not think that is the problem because
>>> the connection is the one used with success in other parts of the
>>> program, you show the code that I wrote following your suggestions:
>>>
>>> string sqlString = "SELECT * FROM Proclamatori";
>>> conn = new SQLiteConnection(connString);
>>> try
>>> {
>>> conn.Open();
>>> SQLiteDataAdapter apt = new SQLiteDataAdapter(sqlString, conn);
>>> DataTable dtProclamatori = new DataTable();
>>> apt.Fill(dtProclamatori);
>>> }
>>> catch (SQLiteException ex)
>>> {
>>> MessageBox.Show(ex.Message);
>>> }
>>> finally
>>> {
>>> conn.Close();
>>> }
>>>
>>>
>>> I know that there are groups for microsoft c # but that does not seem
>>> like a software applications that are not microsoft: (
>>>
>>> Roosevelt Anderson ha scritto:
>>>
>>>> It should be "Data Source=database.db" not "DataSource=database.db". I
>>>> didn't realize this because of the line break in the email. This will
>>>> create a new, empty database named database.db in the directory where
>>>> your application is running.
>>>>
>>>> On Fri, Jan 9, 2009 at 7:32 AM, Alessio Forconi <forco...@gmail.com> wrote:
>>>>
>>>>
>>>>> Thanks...
>>>>>
>>>>> I get this error
>>>>>
>>>>> "Data Source cannot be empty. Use :memory: to open an in-memory database"
>>>>>
>>>>> but the connection is sattamante the same as that used in other parts of
>>>>> the program
>>>>>
>>>>> Roosevelt Anderson ha scritto:
>>>>>
>>>>>
>>>>>> If you trying to extract data from a sqlite database to a DataTable
>>>>>> here is how you do it using the .Net data provider:
>>>>>>
>>>>>> SQLiteConnection conn = new SQLiteConnection("Data
>>>>>> Source=database.db");
>>>>>> conn.Open();
>>>>>> SQLiteDataAdapter apt = new SQLiteDataAdapter("select * from
>>>>>> tbl", conn);
>>>>>> DataTable dt = new DataTable();
>>>>>> apt.Fill(dt);
>>>>>> conn.Close();
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Thu, Jan 8, 2009 at 11:28 AM, Alessio Forconi <forco...@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>> Hello everyone,
>>>>>>>
>>>>>>> I am making the first steps with the programming and I want to help
>>>>>>> create a DataTable from a database sqlite with C #.
>>>>>>>
>>>>>>> Can you give me an example of how do I create it without using a
>>>>>>> dataset?
>>>>>>>
>>>>>>> Thank you very much for your help.
>>>>>>> _______________________________________________
>>>>>>> sqlite-users mailing list
>>>>>>> sqlite-users@sqlite.org
>>>>>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> _______________________________________________
>>>>>> sqlite-users mailing list
>>>>>> sqlite-users@sqlite.org
>>>>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>> _______________________________________________
>>>>> sqlite-users mailing list
>>>>> sqlite-users@sqlite.org
>>>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>>>
>>>>>
>>>>>
>>>> _______________________________________________
>>>> sqlite-users mailing list
>>>> sqlite-users@sqlite.org
>>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>>
>>>>
>>>>
>>> _______________________________________________
>>> sqlite-users mailing list
>>> sqlite-users@sqlite.org
>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>
>>>
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
