debasisdas

Hi lew, Welcome aboard.

You seem to carry a bunch of good qualities.

What kind of tasks ? I think you need to pass more information.

What does [B]tv1.SelectedItem.Key[/B] returns ?

1. save image from cam to a file. 2. store the picture file into database(can convert the file to binary and store or store the file path only). 3. retrieve from database to display back in control.

the first one uses client side cursor.

You simply need to store the database in a shared location to which all the PC running the application has access. You do not need to make any specific changes to your code to do any DB operations.

[URL="http://bytes.com/topic/visual-basic/insights/726143-adding-items-treeview-listview-database"]This[/URL] might be helpful to you.

You need to call [B]AddNew[/B] or [B]Edit[/B] method before calling [B]Update[/B].

CITY should refer to province not to country table directly.

Please find all that [URL="http://www.google.co.in/search?hl=en&q=materialized+view+in+oracle&sourceid=navclient-ff&rlz=1B3GGGL_enIN354IN354&ie=UTF-8&aq=2&oq=materia"]here[/URL].

Hi Eric, Welcome aboard.

Welcome Ochieng. You can post your questions if any in the related section of the forum.

Hi Fritz, Welcome aboard.

Why you need to store the data in the client machine in case of a online application ? If you want something free try to go for [URL="http://www.oracle.com/technology/software/products/database/xe/index.html"]oracle Express[/URL]

Try using scheduled jobs, if your database is ORACLE.

What about storing the users(contacts) and the relationship details in separate tables and linking them using PK and FK.

if that contains picture, that works directly in crystal report(you can directly drag the filed to report area). I am not sure of Data report.

Please find the connection string [URL="http://www.connectionstrings.com/oracle#p14"]here[/URL].

Hello from all of us here.

you need to open the recordset with multiple columns and then to add to the list box try this [code]list1.additem (rs(0)&" " & rs(1) & " " & rs(2))[/code]

Check if you have permission and can call the components of the Yahoo Messenger in your own application.

How much you are ready to pay me for that ?

You only need to change the [URL="http://www.connectionstrings.com/mysql"]connection string[/URL] to access the database. There would hardly be any changes to your VB code for MySQL.

Please do not hijack others threads. Always start a new thread for your own question. You need to read [URL="http://www.daniweb.com/forums/thread199614.html"]this[/URL] to the solution to your question.

Kindly post the code that you are working on and also mention the part that you are struck with or having any error.

Since you are storing user name and password in database, user name field must be the PK of the table(so it is unique and can't be null). Assuming the above criteria. run the following query SELECT COUNT (*) FROM TABLE_NAME WHERE USER_FIELD='USERNAME_THAT_YOU_ENTERED' AND PASSWORD_FIELD='PASSWORD_THAT_YOU_ENTERED' If the above query returns one …

Hi Ramya, Welcome to Daniweb. You are welcome to ask all your computer related doubts but in specific sections of the forum only.

That is the way to learn. We all did that to learn what we have learned today.

Hello Welcome to Daniweb.

You need to read [URL="http://www.dreamincode.net/forums/showtopic29575.htm"]this[/URL] for a complete explanation.

What exactly you want, What is the data type of that PK field ? Please pass more information.

Welcome to daniweb.

Why you have posted this code here ? Do you have a question ?

If you have designed the DB (something to start with), Please post the ER here. That will be really helpful to add to your ideas.

You need to join the tables to fetch the data from multiple tables.

Try to access the DLL or other componenets of the tool to achieve the same from your own application

you can't assign an entire recordset to a textbox. You need to fetch one field of a record and display the same in the textbox.

I think you need to read [URL="http://www.bkent.net/Doc/simple5.htm"]this[/URL].

can you connect the device to system using COM port or something ?

Hi Jerry, welcome to daniweb.

Hi Aparna, Welcome aboard.

What makes you think that handling 10 million records is next to impossible. You can use any database like Oracle, MySql or MsSql .

what kind of data file you are using.

use two database connection 1 for access 2 for excel read from excel and write to access.

What about reading books for these basic lines of code and learning yourself ...

It is always better to create a database directly at backend not from frontend code. No where there will be a requirement when you have to create a database at runtime.

[URL="http://books.google.com/books?id=lOJeeibMbJ4C&printsec=frontcover&lr=#v=onepage&q=&f=false"]This[/URL] just might help you.

you want to update the entire table each time any row is updated ?

Which code ? are you using any application ?