Search results

  1. R

    Question Assign Sequence NextVal to textbox

    Dear jmcilhinney 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 regards, raj
  2. R

    Question Assign Sequence NextVal to textbox

    Getting it done! Hey Guys 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 Imports System.Data.SqlClient Public Class Form1 Dim Header_Id As Integer Private Sub...
  3. R

    Question Assign Sequence NextVal to textbox

    Dear jmcilhinney 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...
  4. R

    Question Assign Sequence NextVal to textbox

    Dear jmcilhinney 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...
  5. R

    Question Assign Sequence NextVal to textbox

    Dear jmcilhinney 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 MINVALUE 1 MAXVALUE 99999999999999 CYCLE CACHE 10 ; and could retrieve values by using SELECT...
  6. R

    Question Assign Sequence NextVal to textbox

    Dear jmcilhinney 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...
  7. R

    Question Assign Sequence NextVal to textbox

    Hi guys 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...
  8. R

    Question A beginner's concerns about Windows Forms & Security

    Thank you very much Dear jmcilhinney 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...
  9. R

    Question A beginner's concerns about Windows Forms & Security

    Hi guys 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 My...
  10. R

    Question Console application switch values

    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? regards,
  11. R

    Question Console application switch values

    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. regards, raj
  12. R

    Question Console application switch values

    Hi guys 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...
  13. R

    Accessing network folder using windows service

    Details 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...
  14. R

    Accessing network folder using windows service

    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...
  15. R

    Question Table based "forms"

    Hello Cjard 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...
  16. R

    Question Table based "forms"

    Exactly!! 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. Regards,
  17. R

    Question Table based "forms"

    Multiple validations 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...
  18. R

    Question Table based "forms"

    Hello guys, 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...
Top Bottom