Search:

Type: Posts; User: chdboy

Page 1 of 3 1 2 3

Search: Search took 0.02 seconds.

  1. Re: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constra

    It was missing curly braces issue.

    It has been solved.
  2. Re: How to make Integer number increment by 1 in a JTextField?

    After inserting into Table I have used this code for generating next file number.

    int fileno1=Integer.parseInt(Result.getString(2));
    int increment = ++fileno1;
    int increment2 =...
  3. Re: How to make Integer number increment by 1 in a JTextField?

    Yes I'm saving that data(file no) in MSQL.
  4. [RESOLVED] com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint

    Error on this line


    int rowsAffected = statement.executeUpdate();

    With this code


    int rowsAffected = statement.executeUpdate();
    if(rowsAffected > 0)
  5. [RESOLVED] How to make Integer number increment by 1 in a JTextField?

    I have a form in which I have made File no field which hold the Integer value like 1-2-3-4 and so on.

    I want that ,when I save a form which has file no 1 ,and then after when I want to save the...
  6. [RESOLVED] How to align RadioButtons in MigLayout?

    This is the Image of what I have right now

    105985

    I want to align Radio Buttons so that It will not have the space left to "Y" ,so that they will align correctly.



    String yesString = "Y";...
  7. [RESOLVED] Resizing Tabbedpane with JScrollpane

    I have this code (Sample code not a full code)


    JTabbedPane tabbedPane = new JTabbedPane();
    JPanel jp1 = new JPanel();
    JScrollPane scroll_pane = new JScrollPane(tabbedPane);...
  8. [RESOLVED] Adding more than one JPanel to my JFrame(North,South)

    I want to add two Jpanel on my tabbed pane ,one should be in south with buttons,and other should be in north where I have Text fields and Labels.
    My problem is that the buttons on container Jpanel...
  9. Re: Fetch records and navigate throught next records displaying in Text Fields

    If I close the resultset and when I click on fetch button it shows me the first record and the error message that resultset is closed.


    com.microsoft.sqlserver.jdbc.SQLServerException: The result...
  10. Fetch records and navigate throught next records displaying in Text Fields

    I have two buttons Fetch(which fetches the records)and next(which navigates to the next record)
    When I click on my fetch button it shows me the first record from my database.
    But when I click on...
  11. Replies
    3
    Views
    2,118

    Re: Attach Database MS Sql

    ok so I have to install 2012 version back again ....thanks for the help
  12. Replies
    3
    Views
    2,118

    [RESOLVED] Attach Database MS Sql

    I had two versions of SQLEXPRESS on my computer earlier ,now I have uninstalled 2012 SQLEXPRESS from my computer
    Now when I try to attach .MDF file made in 2012 version it gives me error.


    ...
  13. Re: Conversion failed date and/or time?

    Yes,I looked closely then I found out that the two records which has date ,was in format "yyyy/mm/dd" and the third input I was trying with "dd/mm/yyyy" format ,that was the problem.

    Now my...
  14. Re: Conversion failed date and/or time?

    I'm saving the data into database not to get text
  15. [RESOLVED] Conversion failed date and/or time?

    I want to insert date to the column Date of birth

    "insert into table (firstname,lastname,dateofbirth) values(?,?,?)"

    statement.setString(3,dob.getText());
    dob is my JTextField name
    Data type...
  16. Re: The conversion of the nvarchar value overflowed an int column.

    Yes that was the problem I have changed my data type from int to big int,now it's fine
    Thanks a lot.:)
  17. [RESOLVED] The conversion of the nvarchar value overflowed an int column.

    This is the error


    com.microsoft.sqlserver.jdbc.SQLServerException: The conversion of the nvarchar value '8737383838' overflowed an int column.


    I'm putting the value integer into bank...
  18. Replies
    10
    Views
    979

    VS 2010 Re: Why my Application is closing?

    Me.ComboBox1.SelectedIndex = Me.ComboBox1.Items.Count + 1

    I have changed +1 to -1 ,so now it worked.
  19. Replies
    10
    Views
    979

    VS 2010 Re: Why my Application is closing?

    When I click on LinkLabel here is the code behind it

    Private Sub LinkLabel1_LinkClicked(ByVal sender As System.Object, ByVal e As System.Windows.Forms.LinkLabelLinkClickedEventArgs) Handles...
  20. Replies
    10
    Views
    979

    VS 2010 Why my Application is closing?

    When I click on a button or LinkLabel my application closes automatically.
    Why is this happening?
  21. Replies
    2
    Views
    1,014

    VS 2010 Adding sum Result beneath the column(SQL)

    Hi I want the sum of the column(Esicemployeeshare) exactly beneath the column(Esicemployeeshare)How can I do that
    here is my code

    Private Sub Button6_Click(ByVal sender As System.Object, ByVal...
  22. Replies
    1
    Views
    597

    VS 2010 Radio Buttons with DGV double click values

    I have two Identical twins forms (for editing and updating purposes),when I double click on the DGV row it gives me the value of the row in another form.
    Now I have three radio buttons on form...
  23. Replies
    2
    Views
    1,065

    VS 2010 Re: Keyboard Tab Key Control

    I got the answer ...:)
  24. Replies
    2
    Views
    1,065

    VS 2010 [RESOLVED] Keyboard Tab Key Control

    Hi,
    I have a form in which there are 11 text boxes and two button controls(Just example) ,I want the tab key control to be in the textbox1 when the form loads ,and then If I press Tab Key from...
  25. Replies
    17
    Views
    1,443

    VS 2010 Re: Update Employee Salary

    * szlamany*
    This is no school project ,I'm learning Vb.net as a language and making a project like a payroll system, so I can cover as much as I can(learning),and in coming time when it is ready...
  26. Replies
    17
    Views
    1,443

    VS 2010 Re: Update Employee Salary

    But what I make the salary of a person for a whole year then how would I be calculating ,which field value will I use and how? ...still no Idea @&!#
  27. Replies
    6
    Views
    11,424

    VS 2010 Re: SUM() Sql query

    Ok the problem has been solved


    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim con = New SqlConnection("Data...
  28. Replies
    6
    Views
    11,424

    VS 2010 Re: SUM() Sql query

    cmd.CommandText = "SELECT SUM(Present) FROM Attendance WHERE AttendanceStatus = 1 And (Firstname = Firstname) Group BY Firstname"

    If I change above statement to this


    cmd.CommandText =...
  29. Replies
    17
    Views
    1,443

    VS 2010 Re: Update Employee Salary

    Adding a new column to an existing table ,how would it solve my problem ...when I update the column by new salary at the end of the month, when salary is to be made how would it work?
    Or adding a...
  30. Replies
    6
    Views
    11,424

    VS 2010 Re: SUM() Sql query

    Present is the Column name and it hold the value 1 who ever is present against the name is 1 and I want to count the number or sum against the name.
  31. Replies
    17
    Views
    1,443

    VS 2010 Re: Update Employee Salary

    ok so I have to add the columns for previous salary in the update and date change also.
  32. Replies
    6
    Views
    11,424

    VS 2010 [RESOLVED] SUM() Sql query

    Hi,

    CODE:


    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim con = New SqlConnection("Data...
  33. Replies
    17
    Views
    1,443

    VS 2010 Re: Update Employee Salary

    Yes I have stored all the information about Employee including his basic salary in the sql database ,so if I update the basic salary of an employee,from 3000 to 5000 the it show in m y end of the...
  34. Replies
    17
    Views
    1,443

    VS 2010 Update Employee Salary

    Hi,
    This code is just an Example

    update dbo.Employee set
    Salary = Salary * 1.2 -- Increase Salary by 20%
    where
    Employeename = 'danial'

    The salary of the Employee is 3000 per...
  35. Replies
    1
    Views
    675

    VS 2010 How to navigate records from XML File?

    This code creates XML File


    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim connetionString As String
    Dim...
  36. Replies
    3
    Views
    663

    VS 2010 Re: Combobox trouble

    dunfiddlin
    DavesChillaxin
    Thank you two for solving this issue :)
  37. Replies
    3
    Views
    663

    VS 2010 [RESOLVED] Combobox trouble

    I have two combo boxes
    when I use this in the form load event
    one on the top gets populated ,other does not...why this is happening?And if I put the second one on the top, it get's...
  38. Replies
    1
    Views
    501

    VS 2010 Date and Time Picker

    Hi,

    When the form loads the DateandTime Control shows the current date,but I want the date to be blank when the form loads and when I click on the dateandtime down arrow then the date shows up to...
  39. VS 2010 Re: Inner Join two tables and getting their values

    I have assigned fk to EmpoyerID on the employee table and then the data is there ,but now I wonder weather now the two tables related or not ,If I create employer profile and add three employee how...
  40. VS 2010 Re: Inner Join two tables and getting their values

    Yes both the tables have there first name matching,with column name Firstname
    Employer table,Fieldname Firstname = Danial
    Employee table,Fieldname Firstname = Danial
Results 1 to 40 of 119
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width