SmartCart | A simple , lightweight transportation plugin for MineCraft

There are 2 approaches applicable to this case:

1. At TListView level TLinkControlToField1 -> CustomFormat : "$ "+UpperCase(%s). This is the most applicable approach as the number stays in its number format and can be included in the calculation. You might wonder what the Uppercase is doing here? It is only to show (%s) the data as string and has no effect.

2. Use the Display Format of the TDataset field with this format $ #,##0.00. In this approach, the $ will create an error when you start to include this number in your calculation.

You should check this link to a more detailed explanation https://stackoverflow.com/a/18819719/13810710.

Can I get you to do this, in a new project, as a mini tutorial to make your life easier:

• make a new project
• Add a Form
• Add a DataSet
• Open the DataSet, right click in the surface and add a tableadapter
• create a connection string to store in the settings: Pick mysql connector (note for this to work you need mysql connector AND ALSO mysql for visual studio https://dev.mysql.com/downloads/windows/visualstudio/ ) and fill in the details to create a database connection string make sure the test connection succeeds
• proceed through the wizard choosing "query that returns rows", "by sql", enter a query of SELECT * FROM addition_stock WHERE ID = @id
• write names of FillByID, and GetDataByID
• finish

You'll see something that looks like a database table appear, with a thing called addition_stockTableAdapter underneath it

• Right click the tableadapter, choose add .. query
• add another query that is more relevant to how you will search this table, like maybe SELECT * FROM addition_stock WHERE stock_code = @stockCode
• call it FillByStockCode/GetDataByStockCode
• always give relevant names to your fill/get data methods

Always make the first query that creates the datatable/tableadapter pair a "select where id =" - it makes things easier later on. Add as many additional queries as you will need

Do the same thing again (Add a tableadapter) this time with a table that is either a parent or a child of addition_stock - it doesn't matter which, I'm just trying to demonstrate something here. Make sure you use a table that has a foreign key in the database, to addition_stock

Once you add your other datatable/tableadapter pair that is related to addition_stock you will see a line connecting the two datatables

• Right click this line and choose "show relation labels" to display the name of the relation - it comes from the foreign key in the database

Now we are going to add a convenience method to load child data based on the parent id

• Right click your child tableadapter and choose Add Query

• add a query of SELECT * FROM tablenamehere WHERE parentidcolumnnamehere = @parentid and call it a suitable FillByXxx - obviously Replace the table name, column name and xxx with real values

• save your DataSet and switch to the forms designer

• show the Data Sources window (view menu.. other windows)
• expand all the nodes of your DataSet - you'll see a parent table and two child tables, one underneath the parent, one not
• drag the parent table out of datasources and onto the form - a datagridview with columns will appear, as will a tableadapter, bindingnavigator, DataSet and a bindingsource in the tray at the bottom. The nav has a textbox you can write an id into and a button to press. The datagridview columns are set up appropriately and the grid is bound to the bindingsource. The bindingsource is bound to the DataSet parent table.
• run the app, enter an ID in the textbox, click fill, edit the name of something, click save, go use mysql workbench to look in the db. Super; you can download, edit and save db data and you haven't written a single line of code; you're just using the thousands of lines of code visual studio has written for you.
• stop the app, go back to the forms designer
• drag the child table that is underneath the parent table onto the form. More items appear - a datagridview bound to another bindingsource, another navigator etc. You can delete this second navigator- we won't use it
• take a look at the bindingsource of the child table - note that it is NOT bound directly to the DataSet but instead it is bound to the other bindingsource, with a DataMember property that is set to the name of the relation line between the two tables
• switch to code view and look at the code of the Fill toolstripmenu that fills the parent record by the id/whatever. If there is any redundant code from the child bindingnavigator, remove it (or comment it out: it could be slightly useful for the next step

• under the line of code that fills the parent datatable by id put the following code:

  childTableAdapter.ClearBeforeFill = False yourDatasetName.ChildTableName.Clear() For Each parentRow in yourDataSetName.YourParentTableName childTableAdapter.FillByParentId(yourDataSetName.ChildTableName, parentRow.Id) Next

Run the app again, enter the parent id, click fill. The parent data and the related child data loads. Great, but the real magic happens when we load multiple parent rows. Go back to code and swap the FillById on the parent tableadapter for the other query you write (if you didn't do one, go back to DataSet, Add a query to the parent table adapter that loads multiple rows, like select * from person where lastname = @lastname so we can enter a last name like smith, of which there are many) so now your code looks like this in the fill:

Here's how i've done mine