same problem has occured with me but the next day i have found that mail is sent.wait for a while..... ;) Maniiiiiiiiiiiiiii

i'm not sure if this can be done using a static variable....can a static variable retain its last value when the page loads again? :confused:

Well, if you enter the Bill No in a database, at the start of the program select the maximum bill no from the database and use that as your starting number rather than zero, and do not let the user enter it manually. Hope this helps, its fairly normal practice. Bob Ashfield Consultants Ltd

Another way can be using OloeDB classes. You can connect to the excel file and perform insert.

thanks a lot teejayem :rose:...your code works like a charm ...only one correction... PrintDocument printDocument1 = new PrintDocument(); had to be declared....thanks a lot...u saved my day(infact u saved me many hours of searching on google) :-D

Try to use : instead of @. So in your example it would be like: OracleStmt = "insert into TABLE2_HDB1 (PURPOSE) values(:PURPOSE)"; ... cmd.Parameters.Add(new OleDbParameter(":PURPOSE", OleDbType.VarChar , 20)); cmd.Parameters[":PURPOSE"].Value = textBox6.Text; I'm not sure that if this correct when using OleDBConnection, but it works with native OracleConnection Mika