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 <[email protected]> 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 <[email protected]> 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
>>>> [email protected]
>>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>>
>>>>
>>>>
>>> _______________________________________________
>>> sqlite-users mailing list
>>> [email protected]
>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>
>>>
>>>
>> _______________________________________________
>> sqlite-users mailing list
>> [email protected]
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
