That's what I really wanted jmcilhinney. Thank you so much! I would like to post the sample for some newbies like me who are trying to switch from other development scenarios to SQL + VB.Net. Please let me know
Getting it done!
I'm sure, this is not the way to achieve what I wanted, however, I have managed something. Copying the code, if the method at all is applicable, please do let me know
Public Class Form1
Dim Header_Id As Integer
Did I mention that I started learning VB.Net just few days back? :) I asked my first question after almost 6 years about Typed Datasets and security and you were the one who answered me. Why I kept getting back to you was just because I really don't know what to write within...
That's all good :) Now, as you know the sequences already exist and the values from SEQUENCES could be retrieved using simple SQL, can you please guide me how I could achieve my goal with the "Save" button click?
Private Sub OrdersBindingNavigatorSaveItem_Click(sender As...
Correct me if I am wrong, I have clearly created SEQUENCE using the following SQL
CREATE SEQUENCE dbo.OrderHeaderId_Seq
START WITH 1
INCREMENT BY 1
and could retrieve values by using
I'm using SQL 2014 Express edition for the learning purpose. Why I asked you for SEQUENCES is because we will be moving from Oracle ERP to Microsoft Dynamics and for many applications we would require to generate different series of numbers based on a certain organization...
I am designing a simple windows form application using typed datasets. My requirement is to assign a sequential value from a database SEQUENCE to one of the textboxes available with the form while default navigator "Save" button is clicked. My Database level Sequence name is...
Thank you very much
Thank you very much for your valued inputs. I was/am working with Oracle centric development from last 15+ years and had the epiphany when I tried to create a simple master detail data entry form using some sample HR schema that I stripped from Oracle...
I am a seasoned Oracle developer, forced to start developing Windows forms against MS SQL server as my firm is planning to implement Microsoft Dynamics AX suite. I know bit of how to use the Vistual Studio IDE and how to hook up the tables using textboxes and by using DataSets
Thank you jm, a final favor
This application is scheduled to run once in 3 days, hence I would like to create a log file like 12012013.log or 15012013.log depending upon the date and write the details of files (file name, creation date etc) deleted from the folder. Would you please help?
Thank you jm
Actually, I must say, I am surprised to see that you had put so much efforts to restructure the entire codes. Thank you very much. From the beginner's eyes, your coding looks like a feast :)
I will check it and update you.
I am trying to make a simple console application for deleting files which are N days old and the console application should take three switches like following:
deleteoldfiles -dFolder C:\myfolder -fType *.dmp -nDays 3
The below module does it, however I am not sure whether the logic...
Thank you very much Tom
What we are trying to do is simple like following:
1. We are running the service from server A.
2. We want one folder within Server A to be synchronized with files from a particular folder from Server B.
3. Both A & B Servers are logged in with the same user...
Hi guys we are developing a small utility for synchronizing a network folder where, as domain admins we have the full privileges, with a local folder in another computer.
We had written a service to do this job and found that when the service starts the error returned is "Access denied". This...
A final question related the above subject. I need to create a master detail form for my application. I already know how I could create a dataset and create the master form. Now I need a tabular format details entry area (Example, Invoice Screen, Customer receivables etc)
Is there a...
Thank you very much cjard. I had my first VB.net course almost three years back and later was only concentrating on Oracle based developments. Your suggestion has provided me enough guidence and I am sure I would able to develop applications pretty easy now.
well, my first intention is to create a form against a table. For example, if i have a table "tableA" with 10 columns, instead of creating 10 textboxes with VB.net, I would prefer to refer to those table columns straight away for processes like entry/delete/update...
I am more familiar with oracle developer and recently started with VB.net (VS 2008). Would appreciate if somebody could provide me some information regarding the following:
I have an Oracle table consist of around 39 columns and want to create a data entry form against it using...