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
