debasisdas

[QUOTE=zoraster01;1617259]can you give me some search engine code.[/QUOTE] No, You have to show some effort for that first.

Have you compiled the package specifications before trying to compile the package body ?

It is highly recommended for you to read [URL="http://download.oracle.com/docs/cd/B19306_01/server.102/b14200.pdf"]this[/URL].

Check for proper join and existence and use of indexes in the table structure.

You need to write log for each event or each execution step if required .

You can go ahead and implement the approach if you have proper back up and recovery mechanism. Remember you are putting all the eggs in a single basket.

First lets know how familiar and how comfortable you are in coding VB 6.

Lets see your validation code that you are working on and fix it.

2100 parameter ! for what ?

Hi Lyandor, Welcome to Daniweb. Hope you have a nice time learning new things here.

How are you populating the data grid ?

is it compulsory to add value to all the text boxes ?

Your code is horrible. Columns names are qualified by table name not the reverse as mentioned by you in the SQL.

What the file contains and why you need to decode and using what ?

What exactly you are trying to do ?

[QUOTE=wattaman;1615590]the table rows now are jumping[/QUOTE] I really do not understand what exactly you mean by that, are you trying to re arrange the ids starting from 1 and increment by 1 till the last record ?

Using the owner argument with the Show method ensures that the dialog box will be minimized when it’s parent is minimized, or unloaded should the parent form be closed. Using the Show method with both style and owner arguments. For example: [CODE] ' Display frmAbout as a modeless child of …

What is the expected result ?

If your .SQL file contains insert scripts, use that to insert records into the target DB and then use any DB front end tool to export the data back to .CSV format.

what is the problem with current code ? In which part you are struck ?

You need to read books for all that. Try using any search engine will get a lot of code online.

Check for the 1st character of the string ,if that start with 1 0r 7 concatenate with 0.

ADODC is not a database, it is a control to connect to database. use ADODB and try this code [CODE]cn.begintrans ' cn--adodb connection object cn.execute "your update command goes here" cn.committrans[/CODE]

From VB use ADO to connenct to database. Please find the connection string [URL="http://www.connectionstrings.com/"]here[/URL].

But i don't understand what pagination has to do with database design. That should be handled at application level.

Requirement is not clear.

Please find the connection string specific to your version of SQL Server [URL="http://www.connectionstrings.com/"]here[/URL].

How are you reading data from text file ?

Please read more [URL="http://support.microsoft.com/kb/209805"]here[/URL] and [URL="http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/62ee4978-ca29-48d3-9367-6dd4ab639d2d/"]here[/URL].

No.

First of all tell me from where you got VB 6.5 ? Is it a home grown version ? ;) 1. Use ADO (refer to ADODB library). 2. Open recordset using desired SQL. 3. Populate the controls from recordset.

That so simple, just by writing some code.

How you set which file to play using the control ?

Welcome aboard.

Welcome aboard.

Start crying louder, that may help. That is what school kids do when they are not spoon feed.

The solution is [URL="http://www.daniweb.com/software-development/vbnet/threads/372664"]here[/URL].

let see the code that you are working on.

What exactly you are trying to do ?

No wonder why all these never happens in countries ,where technology is not that developed.

Welcome aboard.

You need to store the details of the room in database with a flag for empty/occupied.

What about using database for the purpose.

Check for proper syntax in your code. Are you storing the username and password in database ?

Hi Cliff, Welcome to Daniweb.

What exactly you are trying to do ?

[QUOTE=blogger371;1611266]Please teach me step-by-step[/QUOTE] You need to read books for all that.

are you sure the database is MS Access 2007 format ?

Donate $5 to daniweb and you will know all the secrets of this universe that is not visible to mere mortals. :)

You need to read books for all those details.