Recent content by spidydotnet

Hi, The below code works for me (which I use in my own app to read a CSV / Excel sheet). Give this a go. GOOD LUCK. Dim ConnectionString, CommandText As String Dim conn As OleDb.OleDbConnection Dim Command As OleDb.OleDbCommand Dim strMsg As String Dim da As...

Yes.. we own the code and it was developed by us from scratch. So, we are free to do what we want.

Hi, We already have a retail EPOS system which gets a barcode and brings up the prices (anything a normal basic ePOS system would do). Currently, discounts are applied manually by the till operator. The requirement now is to automate them. i.e., we need to design the system to be able to setup...

Hi Guys, Has anyone programmed Retail Promotions before into a system. I now have a task to come up with some programming to get retail promotions like Buy 1 get 1 free, Buy 2 get 1 free, buy 3 for £10 etc.. Can anyone share their experiences on how best to start etc. regards

I found the solution.. It is basically not clearing up the memory after the form is closed. So, when the form is opened again..It is firing the events twice and causing. Now, before closing the form I am clearing all the objects in that form and then closing the form. After doing that the...

Hi guys. I've got a strange problem. Here are the steps which explains it quite clearly. This is an inherited form and has a list box in it. 1) I open a form (which has got data connectivity and bindings) it is working fine. And I close it. 2) I open the same form again, It takes couple of...

It is supposed to print the data.. but it is not..it prints OK when installed on another computer. I am using Crystal Reports for .NET (VS.NET2003)..It just prints lines which are used as seperators in the report by me.. Spidy.NET 'Discussion is Knowledge'

Hi guys.. I created a report and it prints properly on one system and it doesn't on the other.. it prints the lines and boxes in the second one but not the data.. Any ideas will be appreciated.. Spidy.NET 'Discussion is Knowledge'

Hi guys.. I am getting this error when I schedule a DTS package. any ideas will be appreaciated.. ... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_3 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnError...

I am referencing it thru the Mapped path..and Just now I learned that we have to follow UNC path.. And I am trying to schedule it now.. thanks for the effort.. and If you have any ideas about calling it from a VB.net application.. please let me know.. thanks Spidy.NET 'Discussion is Knowledge'

Hi guys.. I created a DTS Package which executes successfully when I execute it from Enterprise Manager..But when I schedule it, it doesn't execute and it leaves an error message in the logfile saying that it can't find the source..stock.dbc which is a foxpro file. I am doing it from Foxpro to...

I am very new to crystal reports formula editing.. I am thinking to do this.. If RequestASample is true then I want to change the Background color of that field.. How can I create or use a formula in the formula editor to do this.. Any advice will be appreciated.. Spidy.NET 'Discussion is...

Hi Folks.. I've created a Crystal Report in VB.NET. When the report is generated its fine when u click for next page. It asks for Login information for the Database.. can anyone help me please.. I am using ODBC DSN for connecting Database and my DB is SQL2000 thanks Spidy.NET 'Discussion is...

Hi folks.. How can you shutdown windows automatically when a program comes to an end. I am using vb.net. Soon after the user exit my program, system should shutdown by itself. many thanks Spidy.NET 'Discussion is Knowledge'

Hi folks.. When I am creating a form in an MDI and showing that it is generating an error 'Error Creating window handle' can anyone tell me why this error occurs.. Thanks Spidy.NET 'Discussion is Knowledge'