Search results

  1. P

    Resolved Conversion failed when converting date and/or time from character string

    Someone else may be able to understand what and why, I sort of stumbled along and managed to resolve it. On my computer the date was showing as "dd Month yyyy" on the screen, but on the other computers it was showing as "Weekday dd mm yyyy". When parsing the data from the form to the sql...
  2. P

    Resolved Conversion failed when converting date and/or time from character string

    Okay have managed to isolate it to one of 3 date fields on the form...but still no further advanced as to why
  3. P

    Resolved Conversion failed when converting date and/or time from character string

    Okay, not sure if right part of forum to ask the question, but this one is stumping me, and some direction is needed......... On my computer which has visual studio installed, when I click on the save form button, it reports job saved. However on all the other computers in the office, when...
  4. P

    Question Idea on how to gice a drilldown capability

    Hi all again, I have a system I am designing, that is a project / job management system. So I have a job list, and a job by client, and a jobs by owner, and a jobs by vehicle, and a jobs by employee form, which all display the job details in a datagridview. What I am trying to figure out is...
  5. P

    Question Help with SQL Query to return NULL fields

    HI all, I have a datagridview, that I have a search capability on. The searching allows for the filtering of the datagridview. One of the columns in the table has NULL values in the field, which is totally allowable. However when I search, with this field in play, the search results exclude...
  6. P

    Really confused...trying to access data in a bound datasource

    That is the newbie problem I am having. I cannot figure out the syntax for getting the information from the bindingsource. Have spent more than enough hours on trying to figure it out...even the www has been no help, as just about every post talks about putting the data into the...
  7. P

    Really confused...trying to access data in a bound datasource

    The code below is part of a tab page form, they is used on event tabpage_enter Me.taChassis.Fill(Me.DsTTDJobs.chassis) bsChassis.Filter = "Chassis_Job_number = " & intchassisjobno & "" If txtchassiscerttype.Text = "LT400" Then rbChassisLT400.Checked = True Else...
  8. P

    Making an txtbox.text blank freezes program

    Okay have sorted it, but not what I thought, more leaning towards where you were heading I think. Seems to be a problem that has not been fixed .net - Data-bound TextBox: can't exit - Stack Overflow So what I have done is changed the advanced binding data source update mode on the numeric...
  9. P

    Making an txtbox.text blank freezes program

    Yep...... If I change the value in vehicle year to blank and click save, the breakpoint does not get hit...the program actually stops responding, and I have to stop it via the VS Console Yet there is nothing reporting in the debugging screen, that indicates there is an error
  10. P

    Making an txtbox.text blank freezes program

    And I have done this so many times I have lost count. When I click on Save absolutely nothing happens, if the field Vehicle Year is changed from a value to blank
  11. P

    Making an txtbox.text blank freezes program

    Okay thanks for that. However the fundamental issue is that if the Vehcile Year field is blank, absolutely nothing happens when I press the Save button on the form. The program basically stops responding.
  12. P

    Making an txtbox.text blank freezes program

    Hi all, again... I have an interesting one (well I think it is interesting). I have a form with a binding source on it. If I change one of the bound fields which is an integer - to have a value of blank, through the use of a textbox then the program stops working. If I change a text field...
  13. P

    Datagridview / SQL / Saving data

    Thank you. I will use full words from now on...appreciate that comment. But what I really appreciate is your honesty and plain language in detailing that there is nothing wrong with the way I am heading. I prefer using a typed dataset as it allows me to format the datagridview, explicitly...
  14. P

    Datagridview / SQL / Saving data

    Okay, I can sort of see what needs to be done, but it also seems that I am possibly making things over complicated for myself. All the online tutorials / videos / suggestion seem to indicate that a SQLCon is maybe a better way to go. Am I better off using an SQLCon and setting things up that...
  15. P

    Datagridview / SQL / Saving data

    Okay...I can see where the confusion from my oringal post may have originated, and yes I am can see what you are suggesting. The problem is that the wizard does not like joined table, and so will not automatically generate the code for me from the wizard. (I am sure this is sorta making sense)...
  16. P

    Datagridview / SQL / Saving data

    VS 2015, SQL 2008 Okay, have been trying to get my head around this one for a day or so now, and have searched extensively but to no avail...... I have a SQL view (2 tables into 1), for a datagridview. I am using datasource, and databindings instead of SQL code to populate the datagrid. How...
Top Bottom