Search results

  1. D

    Option to copy data from remote mySQL through the office firewall

    Hi, I'm not sure what part of the forum to post this as its really help on a desktop app getting data from a mySQL database on a remote webserver using vb.net I am able to connect to an external mySQL database and return the result of a query and store in a win form datagridview. But from my...
  2. D

    Resolved Winform to capture records from an online mySQL db

    Hi, I designing a winform application to capture data stored in a mySQL db on my https website. I am not sure whether to access the mySQL db directly (if I can) or goto a webpage and read the records from it? I have the passwords for both It seems more logical to go straight to the db and...
  3. D

    Resolved Google map API call from winform

    I have a winform app and want to add a call a Google API with two or more postcodes and I want the API to return the driving distance between these 2 or more point. I intend to use net.http and newtonsoft JSON object. JohnH posted code for an earlier answer that should help me. The API on...
  4. D

    Form size not working properly

    Hi, I have a from with a Tabcontrol and inside a Datagridivew. I am using windows 10 and VS 2013 When I launch the form it doesn't size to the size as created in the designer. I checked my code and at no point do I adjust the form size programmatically. I been reading on line and it does seem...
  5. D

    Resolved WinForm API call to return result

    HI, I'm testing an API call from a Winforms, I'm using VS 2013. I've been reading a lost about it and was using an API call to a google website to test, but its very confusing, normally I can figure out what happening and get it going but its all very confusing between the imports the events...
  6. D

    Appointment Calendar for a month on one form

    Hi, I am trying to design a monthly calendar to be shown on a form at once. I can do a week using a datagridview, showing each appointment by time and day of the week, but with 31 days it seems difficult to decide which way I should do it. Do I add 31 datagridviews to a single form, that may...
  7. D

    Draw lines around a group of cells in column in a datagridivew

    Hi, Im using VS 2013. I have a datagridview which represents a diary with times from 9:00am increasing every 15 minutes down the left most column. Each other column represents a day of the week Mon to Fri. I want to group a number of cells together in each column with a box around them to...
  8. D

    Referencing an instance of a Form object

    Hi Folks, Here is an issue im not getting my head around, a simple scenario I have 3 classes 2 are forms and 1 patient class. FrmClients, FrmDialog Patient class I create an instance of FrmClients called frmClient and during its operation a user click on a button to open an instance of...
  9. D

    To Bind or not to Bind

    Hi, Im looking for opinions here rather than actual code. I am designing an office application to show a clients details, there a number of ways to implement this, I first present a list of clients and the user chooses the particular client and then I show all the clients details about 20 data...
  10. D

    Get A Report Viewer to Show different reports

    Hi, I having been using VS 2013 for a few months now and decided I would try and get a Report Viewer on a Form to show different reports. I use a Form for the user to choose the report and then on launching the Report Viewer I change the details to show that specific report. There's a few...
  11. D

    Question Key Down not working in Datagridview

    Hi, I am trying to capture a key down (or key press or key up) as I want to count the number of characters in a cell and let the user know how may the have left. The datagridview is tied to a dataset and the column has a max 200 character limit in the database, thus once they go above this the...
  12. D

    Question Report View Report.rdlc passing in datasets

    Hi, I have only started to use the ReportViewer and Report in Visual Studio 2013 and I am finding it very confusing to be honest, I cant find a good example or even explanation of how the whole thing links together so far as I can work out it goes like this. 1) Add a new Report or Report...
  13. D

    filtered comboboxes in datagridview

    Hi, I have 2 comboboxes in a datagridview and depepending on what value I choose in the first combobx I want the second combobox to be filtered to a subset of its orginal list of values. This would ean that each rows combobox woudl show a different list of values. From looking on the net the...
  14. D

    Concurrency Violation

    Hi Guys, I am using VB.net 2010 and SQL Server 2008 R2 express. I've been reading all about concurrent violation on the web as its an occasional problem on my system too. I think I understand why its happening i.e. data changed in datagridview and dataset doesn't match underlying data in sql...
  15. D

    messagebox text

    Hi Guys, I use message box.show a lot in my apps but am looking for some way to format the message text to make it larger and for it to stand out. I scoured the net but couldn't find any answer. Maybe it can't be done! Kind regardd
  16. D

    Concurrency Violation

    Hi, I am using vb express 2010 and sql server 2008 express. I have a simple datagridview on a Windows Form. It retrieves from a standard table and updates the changes when I click the update button see code below. It all works beautifully except occasionally I get an error "Concurrency...
  17. D

    Problem renaming a Form

    Hi , I'm using vb.net 2010 express and I have a form in my vb.net project called frmEditStaff.vb I have many other form and they all start with uppercase FrmEdit.... I tried renaming to FrmEditStaff so that I can then do Dim frmEStaff As New FrmEditStaff frmEstaff.show But its not allowing...
  18. D

    Question Problem passing just the Time parameter to a query

    Hi, I am using vb.net 2010 express. I am connecting to a sql server database and trying to pass a time parameter to a query. But because the time variable in vb is '05:00:00' I get a sql date time overflow error. IT seems to be expexting a date and time ! Is there some easy way of adding the...
  19. D

    Question Sort a DataGridView by values displayed in a combobox

    Hi, Im using vb.net 2010 express and sql server express. I have a datagridview and want to sort it by a column that is a combobox. The combobox display member shows a persons name but that data member is their personnel no. When I sort automatically this sorts by the hidden 'personnel no' and...
  20. D

    Solution to 'cant update a multi table dataset error'

    Hi, Im using vb.net 2010 ans sql server express. I have a dataset that is based on a View (which is only 2 tables linked by a common column. But when I try to update the datatset back to the database I get the error msg cant update a multi table dataset! So on researching this I find I have...
Top Bottom