About SQL Database

[gjoisa]

Hi
I have created a database called "Atlas.sl3" with SQL . My question is, how to get the first field of a record with key ? My intention is to get the first fields of all records in a list , when i type 1 or 2 letters in a textbox and clicking a button . eg: when i type 'A' ,all first fields of records (Agra , Ajmer , Ahmedabad) starting with "A" should be added to a listbox . how to write the coding ?

[willisgt]

On each key press (I presume the user is typing into a text box), create and execute a new sql query, like such:

"SELECT field1,field2,field3 FROM (your_table_name) WHERE field1 LIKE '" & textbox1.text & "%' "

Be warned, this method can be slow, especially if you've got a lot of data. You might consider reading the contents of the database into a table, and extracting only the records matching your search - especially if the data won't be modified by the user.

Gary

[gjoisa]

thank you for your suggession . now i have problem in compiling after setting database actions .there comes one error message about SQL . pls help me .

[Erel]

Can you describe the error message or take a screen shot of it?

[gjoisa]

the error message reads so ;"Error Compiling Program . Error message : Error CS0012 : The type 'System.Data.Common.DBConnection' is defined in an assembly 'System.Data,Version=2.0.0.0, Culture=neutral,PublicKeyToken=b77a5c561934e089'.L ine Number=25 . Line:Com.New1("""",con.Value)" .

I have added System.data.SQLite.dll in both desktop and device(seperately as required) in components . I used here 'com' for command . I think this much can help you to understand my problem .

[Erel]

You shouldn't add System.data.SQLite.dll in the components dialog.

[gjoisa]

then which sql dll files to be added ?

[Erel]

You should add SQLDesktop to the desktop and SQLDevice to the device.
Later when you distribute your application you should include System.Data.SQLite.dll (from Libraries\SQLNative folder).

[gjoisa]

i have added the dll files as directed by you . After when tried to compile there is another error message :Error CS00234: The type or namespacename 'SQLite' does not exist in the namespace 'System.data" .(Are you missisng an assembly reference?) .what does it mean ? what to do ?

[Erel]

You are probably not using the updated SQLDesktop / SQLDevice.
Please download the attached files and copy them to your source code folder.
SQLDesktop and SQLDevice date should be 11/25/2007.