Sometimes it’s necessary to format numbers as Strings with leading zero’s. One such example is when we sort a list in Excel, Excel will sort the numbers as 0,1,10,2,20,3,30,….. So, to get round this, we simply append a leading 0 to the number. This is achieved in T-SQL by using the RIGHT instruction with following [...]
I have a method here which allows you to add Parameters to the Stored Procedure from Excel. There are quite a few steps, but I’ve broken it down quite alot. The process is actually really easy once you know how... as with anything. Open Excel Select the Data Tab (If you’re using Excel 2007 onwards!) [...]
When applying a sort to a Database BindingSource, executing the BindingSource.EndEdit method causes the currently selected row to change. This has the effect of reloading any bound controls when tee edited row is saved, which of course can have unwanted effects if you need to operating on data related to the currently selected row after [...]