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
