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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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!
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...
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
But its not allowing...
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...
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...
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...