602 Posted Topics
 | Hi All, Two questions really: 1. Is Windows 2003 still supported? (With all the fuss about XP support ending, I'm not sure if I missed it) 2. We have an old Windows 2003 Small Business Server as our domain controller, Exchange server and file server which is coming to the … |
 | We are the borg prepare to be assimilated... |
 | Hi, Try something like this: Sub PopulateComboWithFieldNames(byref TableName as string, byref Combo as ComboBox, ByVal connection As SqlConnection) Dim cmd as new SQLCommand Dim reader As SqlDataReader cmd.Connection = connection 'I'd recommend using a stored Procedure with TableName passed as parameter 'But for sake of clarity I'll do it like …  |
| | Hi, Not exactly sure what it is you're asking - you want to build an interface on your application that looks like Outlook 2010? |
| | hi, Just to explain why you had results that appeared odd. Your month and Year columns were both varchar type when you sort these types, it will by default, sort the columns alphabetically... i.e April, August, December etc. not January, February, March, April, May, June, July etc. So if you … |
 | Hi, The Visual Basic versions are the pre .NET versions, the Visual Basic.NET versions are the versions of Visual Basic that run on the .NET framework. Yes, there are differences between the two but if you have Visual Basic experience it should not be a huge "jump" to Visual Basic.NET. … |
| | HI, I don't think the issue is passing the arrays, I think it is what you are doing with them... Your nBath, nPeople, nHouse etc are all defined as single dimensioned integer arrays but for example, in your Sub routine ProcessHouse you seam to treat them as as single integer … |
| | Re: Settings Hi, You need to store the data in a shared file or on a database. The settings are stored locally in a file on which ever machine the application is deployed on. So if you run an application for the first time on a new deployment it will create the … |
| | Hi, instead of `Dim addr As String = "www.fedex.com/fedextrack/index.html?tracknumbers=" & strTID` try `Dim addr As String = "http://www.fedex.com/fedextrack/index.html?tracknumbers=" & strTID` |
 | Hi, No offense but your handle is Mr. Hacker and you want to hide programs from control panel etc.... I'm just slightly curious as to the purpose of this query. |
| | Re: vb.net Hi, It doesn't matter what version of Visual studio you use (for backwards compatibility,) your VB.Net project runs on the .Net framework and you can target earlier versions of the .NET framework in your project. e.g. if I select a .Net Framework version of 4.0 then as long as the …  |
| | Hi If you are using Visual Studio 2010 or less then I've good news, you need to add a setup project to your solution and there is a setup project wizard to guide you through it. This setup project will deploy your program to the client in an executible. You … |
| | Hi, What code have you done or tried so far? Can you post and we will look at it for you? Have you a dataset populated with the two tables? Or is it a single result set from the two tables? You need to give more details to go on... |
| | Re: VB.NET Hi, I take it you are starting out in the world of programming. If so, you wont be asked too many questions on experience but just in case have a few examples rehearsed of any projects you worked on in your course. When answering questions of this type, always try … |
 | Hi Does your Stored procedure use an Output Parameter? (Example below:) CREATE PROCEDURE GETVISITCOUNT @UserID bigint, @NoVisits int OUTPUT AS SELECT @NoVisits = COUNT(*) FROM Visits WHERE (UserID = @UserID) ... Then in your code you would add the parameters but specify the NoVisits parameter is an output parameter: Function … |
| | Hi, Just a note on using Mod, 0 Mod (any number) = 0 so you should also check your input is greater than 0 (unless of course, zero is an acceptable input)  |
 | Recently taken up Judo (2-3 months) Going for my yellow belt in Early November. I also attempt to play golf and have been for years...  |
 | A 2005 [SEAT Cordoba 1.4 TDi](http://www.autoevolution.com/engine/seat-cordoba-2002-14-tdi-80-hp.html) Sport, which will probably confuse people outside of Europe who have either never heard of SEAT or who wonder how a car with an 80 bhp, 3 cylinder, 1.4 litre diesel engine can drive at a 100 - 120KPH on my daily commute of …  |
| | Re: Date Format As daniel955 says, you should watch that capitalisation, "mm" is actually minutes in VB.NET as in "hh:mm:ss" e.g. "28/10/2013 11:30:44" is "dd/MM/yyyy hh:mm:ss" but if you had converted this date to "dd/mm/yyyy" you would get this string "28/30/2013" (28th day, 30 minutes, year 2013) |
| | Hi You call and initiate the second form, from the first forms load event: Sub Form1_Onload ( byval sender as object, byval e as system.eventargs) Handles Form1.OnLoad dim NewForm as new Form2 NewForm.Show() '.... End Sub Using this technique, you can even set values of controls (or add new controls,) …  |
| | Hi, Also you need to specify that your command will use the connection... |
 | Hi, If you can't sort the table directly, you should be able to make a [DataView](http://msdn.microsoft.com/en-us/library/system.data.dataview.aspx) which you should then be able to sort. |
| | Hi, If you used a DataAdaptor to supply the datasource, you can specify the Insert Update and Delete Commands then apply the Update method to push the changes over to the database. [DataAdaptor Updates](http://msdn.microsoft.com/en-us/library/system.data.common.dataadapter.update(v=vs.110).aspx) To add a new row to your DataGridView you can either pass the "default" values in … |
| | Hi, Try debug with break points and step through it, paying particular attention to the connection string values. Also, check your access Database isn't open elsewhere or locked - This could prevent the update from happening |
| | Hi, [This Article](http://visualbasic.about.com/od/quicktips/qt/AutoCompleteGuide.htm) is all about using the **Autocomplete** property in VB.NET. I'm not 100% sure about the normal DataGridViewTextBoxColumn but I do know the DataGridViewComboBoxColumn supports Autocomplete. |
| | Hi, Your going to have to use the [process class](http://msdn.microsoft.com/en-us/library/System.Diagnostcs.Process(v=vs.110).aspx) There is an [example here](http://msdn.microsoft.com/en-us/library/system.diagnostics.process.id(v=vs.110).aspx) of starting a process (in this case notepad,) then getting it's ID and then stopping it. You'll have to do something simliar to Apache i.e get its ID then stop and start it again. |
| | Hi, [Try this link](http://www.tutorialspoint.com/vb.net/vb.net_print_dialog.htm) |
| | Hi, [Connectionstrings.com](http://www.connectionstrings.com) will allow you to check the connection string but it looks ok to me. Is con an OLEDB connection object? i.e. `dim con as new OleDbConnection()` Does the Access file reside at the path specified? Is access installed on the machine? Sorry if these questions seam basic, you …  |
 | Hi , Have you tried setting integrated security to false and supplying a blank password and username value in your connection? |
| | Re: I'm puzzled Hi, Have you defined an Insert command for the Adaptor? Have you checked the syntax of the command by running it in your database? |
| | [MSDN Multiply in SQL](http://technet.microsoft.com/en-us/library/ms176019.aspx) Exactly as you have done there (providing both values are numeric data types,) just to be sure in case you get NULL values I would use the ISNULL function to return a zero if there is a NULL: SELECT ISNULL(quantity,0) * ISNULL(rate, 0) as VALUE FROM |
| | Hi, Your SELECT statement that is run in the command is **only** selecting *quantity* and *rate* so the datareader will only have quantity and rate fields. |
| | Hi, Did you specify Update, Delete and InsertCommands for your DataAdapter? [InsertCommand](http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter.insertcommand(v=vs.110).aspx) [DeleteCommand](http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter.deletecommand(v=vs.110).aspx) [UpdateCommand](http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter.updatecommand(v=vs.110).aspx) This will allow you to push your data changes back to the database. If you haven't what is actually happening is the data is being changed in the system memory (Dataset) but not on the actual … |
| | Hi, I think you can get the current users desktop from the [environment.specialfolders](http://msdn.microsoft.com/en-us/library/system.environment.specialfolder.aspx) there is a .desktop (for the desktop virtual,) and a .desktopdirectory for the physical file directory. |
 | Re: VB.NET Help Trevino, You should really post your question under it's own discussion. Anyway, you should look at the [System.IO Namespace](http://msdn.microsoft.com/en-us/library/System.IO(v=vs.110).aspx) This will help you with writing to files and reading from them. |
| | Hi, It may be cheating to use another forum but it looks like the person was controlling volume levels [Here](http://www.vbforums.com/showthread.php?605042-RESOLVED-How-to-change-master-volume-level) |
| | Hi The [Directory class in the System.IO namespace](http://msdn.microsoft.com/en-us/library/system.io.directory(v=vs.110).aspx), should give you what you need. The problem is directories do not have sizes, it is the files stored in them that have sizes. However, it will enable you to bring back the sub directories and files i.e. if the folder has … |
| | Hi, I'd recommend using the express versions as well, - In the full version I can do all my programming for desktop and web sites and I use this as work as the company pay for it. At home, I have Visual Studio Express for Windows Desktop and Visual Studio … |
 | Hi, You now have several choices on how to get data from the database: You can use a [DataAdapter](http://msdn.microsoft.com/en-us/library/system.data.common.dataadapter.aspx) to fill a [DataSet](http://msdn.microsoft.com/en-us/library/system.data.dataset.aspx) Which is an in memory collection of Datatables, (think of it as an in memory database snap shot,) [See DataSets, DataTables, DataViews](http://msdn.microsoft.com/en-us/library/ss7fbaez.aspx) Or if you want to … |
| | Hi, I may have asked this before but why are Databases not out on their own forum? Instead of under Web Development? It isn't just Web apps that use databases and the amount of How do I get records from <Insert Database Name Here>?, How do I create a stored … |
 | Hi If you go to the Web Development > Databases > MySql forum you may get someone who knows MySQL (Why Databases is under web development I don't get, it should be out on it's own category) If it was Microsoft SQL server, I'd check that the collation I was … |
| | Hi, The following code will trigger the garbage collector (that is actually what it is called) to "clean" the system memory of any disposed or redundant objects System.GC.Collect() System.GC.WaitForPendingFinalizers() System.GC.Collect() I usually use this if I'm doing a series of complex code inside a loop like this: dim iCount as …  |
| | Re: vbnet and mysql [www.connectionstrings.com](http://www.connectionstrings.com) will show you how to connect to a mysql database (Or any other for that matter)  |
| | Greetings People of Daniweb! I'm trying to add a 3rd party control to a form and I'm getting the following message: **Unable to cast object of type 'Microsoft.Practices.EnterpriseLibrary.Data.Configuration.SyntheticConfigSettings' to type 'Microsoft.Practices.EnterpriseLibrary.Data.Configuration.ContainerModel.ITypeRegistrationsProvider' ** Does anyone have any idea why this could happen? Any searches I tried on google brings back nothing … |
| | HI, Not sure you can customise each individual cell size, Height would be determined by the row's height and width by the Columns width I have a feeling Excel does this automatically - you could look at wrapping / not wrapping text You should be able to set the individual … |
| | Hi, You need to think about the two separate cases you have just outlined. You have to forgive me but I'm not 100% sure of Access syntax Case 1 - one month or more since last serviced, the sql would be something like: `WHERE (LastServiced <= DATEADD(Month, -1, GETDATE())` Case … |
 | Hi, The combobox will take objects rather than just strings as it's items. I tend to make a custom class I call it dataitem and give it a string property and a data property. You then can override the ToString to return your String value: Class DataItem Private _Data as … |
 | Hi, You'd be better trying the MySQL forum, it is under Web Development > Databases > MySQL (Why it is under Web Development is a loss to me) |
| | Re: Cpu usage meter Hi, Not being the person who wrote the code I cant be 100% sure BUT I can take an educated guess. 1. The `cpuLoad = 100- cpuLoad` I think it could be that the`Performancecounter1.NextValue.ToString()` could be giving you the available resource as a percentage so 100 minus this figure would … |
| | HI the code where you set the style value is wrong... Public Property Style As Integer 16. Get 17. Return PointerStyle 18. End Get 19. Set(value As Integer) 20. PointerStyle = Style 21. Invalidate(Rect) 22. End Set 23. End Property You want `PointerStyle = value` not `PointerStyle = Style` you … |
The End.