- Strength to Increase Rep
- +8
- Strength to Decrease Rep
- -2
- Upvotes Received
- 103
- Posts with Upvotes
- 89
- Upvoting Members
- 52
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
- Interests
- Reading, eating, drinking
- PC Specs
- Samsung NP880Z5E 15.6-inch ATIV Book 8
229 Posted Topics
 | Hi One way to do this would be to use the SelectedRows property of the DataGridView and when it is double clicked you could pass this to your next form. For example, if I had two Forms (Form1 and Form2) and Form1 contained a DataGridView I could set it up …  |
| | Hi Looking at your code, I am confused as to why you are creating an SQL statement with values from your text boxes and then proceeding to add parameters to your OleDbCommand objects. Usually you would only use parameters if you were using a parameterised query such as "INSERT INTO …  |
 | Hi This is because paramSource has not been declared in the code above. Essentially, this is the value that you want to associate to the parameter, so substitute paramSource for the value that you want to provide to the parameter. HTH  |
| | Hi Below is some code that will satisfy Task 1 (although you will need to modify to suit your needs). This is in VB.NET as you have some VB like syntax so figured it may be easier to understand. Note, this is not the final solution as it is prone …  |
 | Hi If I understand correctly, you want to do some work on files in a directory and provide feedback via a progress bar. If that is correct, hopefully the following will help. First, add a progress bar and set its Step property to 1. This tells the progress bar how … |
| | Hi I tried out your code and was able to read a value from that section of the registry, but not DriverDesc as I only have ClassDesc there. The only argument I needed to change was the writeable property which I set to False as it seems that you are … |
 | Hi What have you tried so far? Where is your attempt? To give you a start, check out [How to Open ADO Connection and Recordset](https://support.microsoft.com/en-us/kb/168336), this will show you how to connect to a database using ADO and how to open a recordset which will contain records from the database … |
 | This code snippet demonstrates how to use ADO.NET to read the contents of a Microsoft Excel Worksheet. This snippet also demonstrates the use of the [GetSchema](https://msdn.microsoft.com/en-us/library/ms135981%28v=vs.110%29.aspx?f=255&MSPPError=-2147217396) method to determine what worksheets are available within an Excel workbook allowing the end user the ability to select a specific worksheet in order … |
| | Re: Database testing Hi Not sure I fully understand the output that you are looking for. Can you provide an example of the input file and an example of what you would expect the output to be. HTH |
 | Re: Nature's Temper > Having said that, my husband considers it a disaster when a premier league game falls on the same day as an FA cup tie. I'm with him on that one, it's so inconsiderate!! > Oh and every once in a while, Chubby Brown comes to town. That made me …  |
| | Hi Your query is joining ID columns against char columns which is incorrect (although I would have expected a different error than the one you mention). For example, INNER JOIN Client on RegisterShipmentNoDetails.**ClientID** = Client.**ClientName** is wrong, it should be RegisterShipmentNoDetails.**ClientID** = Client.**ClientID** and so on. HTH |
| | > Go has a goto, so that would make it a legacy language Just because a language supports goto (regardless of the arguments for or against it) does not make it a legacy language. VB.NET and C# supports goto and they are certainly not legacy languages as do many other … |
| | Hi The following is an example of reading an varbinary(max) field containing an image from an SQL Server table. You will need to adapt it to fit your purpose, but the example simply reads the image and displays the image in a picture box: string connectionString = @"Your connection string"; … |
 | Hi I copied your code as is and it works fine for me. I am assuming that you are right clicking on a link and selecting "Open in New Window" from the context menu. For me, this opens a new instance of Form1 with the page loading for the selected … |
| | Hi Looking at the code that you have posted and the use of aspx and aspx.vb suggests that this is a WebForms web application. There are predominately two types (Web Forms and MVC) in the .NET Web arena. Currently, it looks like you are taking the classic ASP approach (using … |
| | Hi You will need to register a global hot key and ideally unregister it when your program closes. Take a look at the following Win32 API functions: * [RegisterHotKey](http://allapi.mentalis.org/apilist/RegisterHotKey.shtml) * [UnregisterHotKey](http://allapi.mentalis.org/apilist/UnregisterHotKey.shtml) HTH  |
 | Hi If I understand correctly, you are trying to grab a review directly from the model which is of type Book. This won't work as the class Book does not have a Review property. It does however have a Reviews property which is a collection, so you will need to … |
| | Hi How are you populating the DataGrid? If it is standard OleDb with a DataTable then you can simply issue a new query against the database using the WHERE criteria to filter returned data for the selected employee ID, populate a new DataTable and then bind that DataTable to the … |
| | Hi Not sure I fully understand how you want to work with the currentTime method based on your description. But in the most simple terms, you would declare a type of EWrapperImpl in your form class and then call currentTime: EWrapperImpl ewrap = new EWrapperImpl(); ewrap.currentTime(...); HTH |
 | Hi The MSDN documentation states that this will not compile in .NET versions 4.5.2 or greater. So, if you need to use this and have no requirement to use .NET 4.5.2 or greater then simply change your target framework to a lower version. This may not be the most suitable … |
| | Hi When using inline SQL you need to enclose each of your field types in the correct characters. For example, text data needs to be enclosed in ', dates (for Access) need to be enclosed with # and numbers do not need to be enclosed in anything. So in your … |
 | Hi It might be as simple as your controls are locked. When you select a control like a button or something, do you see a padlock icon in the upper right corner of that control? If so, right click on an empty area of the form and select "Lock Controls" … |
 | Hi The exception is telling you that it does not recognise the string as a valid DateTime value and that it was thrown by this file: "D:\visual studio 2010 - 20-12-2014\projects\LicensesProject\LicensesProject\UpdateMediaProduction.cs" at line 104. So, what does the code look like for this file, specifically lines 25 and 104. > … |
| | > AFIAK The Form constructor has no overloads. That's not strictly true, the form at the end of the day is just a class. In VB.NET, you do not see the constructor by default but if you type `Public Sub New` and hit enter you will get the following standard … |
| | Hi In the most simple terms, a model can be considered a table in the database. When you first create your application and your first model, EF will create the database and the table that maps to the model for you. Subsequent changes to that model (addition of a new … |
 | Hi What you are referring to is a mechanism known as Single sign-on (SSO). Here are a couple of articles that will hopefully explain how to accomplish what you want to achieve: [Single sign-on: Concepts, methods and frameworks](https://mauriziostorani.wordpress.com/2008/07/21/single-sign-on-sso-concepts-methods-and-frameworks/) [Building and implementing a Single sign-on solution](http://merbist.com/2012/04/04/building-and-implementing-a-single-sign-on-solution/) HTH |
 | Hi If you want to return data from both tables where the contents of ColumnY are the same, then you can use the following query that simply does an INNER JOIN on the two tables: SELECT dbo.TableA.ColumnY FROM dbo.TableA INNER JOIN dbo.TableB ON dbo.TableA.ColumnY = dbo.TableB.ColumnY If you only want … |
 | Hi In addition to deceptikon's suggestion, I just wanted to point out that if you are data binding to a DataTable then you do not need to enumerate each row and continuously update the DataSource. The following is enough to bind a DataTable to a Combo Box: comboBox1.DisplayMember = "ListVal"; … |
| | Re: Invalid Path Hi > my program has no app.path thats why i install it on Local disk D Not sure what you mean by this, Vb6 does have an App.Path method, see the Code Changes to the App Object [here](https://msdn.microsoft.com/en-us/library/fc353bw2%28v=vs.90%29.aspx) for an example. Also, I would recommend storing this type of information … |
| | Hi > Now, before you say "well then insert the key", please note that I have never had to do that before This is probably because your previous models used a public property with the name ID or *classNameID* such as EmployerDetailsID. Entity Framework will discern the primary key from … |
| | Hi What version of Visual Basic are you using? You have posted in the VB 6 forum but mention Visual Basic 6 2013 so wondering if you are in fact using VB.NET? Also, can you clarify what you mean by making buttons go to other windows? Do you mean, how … |
| | Hi The |DataDirectory| simply tells ADO.NET where to look for the database file. In the case of a Windows Forms application, this will be the same location where the executable file resides (in this case the bin\debug folder). If this was an ASP.NET application then it would be the App_Data … |
| | Re: upload image Hi You can use the [FileUpload](https://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.fileupload%28v=vs.110%29.aspx) control to request the file from the user and then use the [SaveAs](https://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.fileupload.saveas(v=vs.110).aspx) method to save it to the server. That is assuming that you want to save it to disk and not to a database or something else as you haven't really specified … |
 | Re: RPM 5400 vs 7200 7200 is the faster disk access. 5400 is pretty standard but if you can shell out for a faster RPM then it is very much worth it. Even better, go with an SSD.  |
| | Hi I haven't seen that constructor before when adding columns and did a check and still can't see it. Can you provide a screen shot or more info on this? In terms of using a Font however, you can apply a Font style when adding items to the ListView. For … |
 | Hi What do you mean by grouping command? Are you referring to aggregate functions in a database or something else? You will need to provide a lot more detail in order to get a relevant answer. |
 | I have not been receiving notifications for about a week, but today they started coming through again, although for posts that are days old. Guessing there is a Gremlin in the system.  |
| | Hi This would usually be done with an INSERT statement. For example, if you had two text boxes for First Name and Last Name and you wanted to insert that data into a table called Contacts with fields FirstName and LastName then your INSERT statement would look like: INSERT INTO … |
| | Hi What is the actual problem? Are you getting any errors? Some notes on your code, you should really get into the habit of naming your controls so that they mean something when you are reading the code. Looking at your code at the moment, all I see is TextBox1, … |
| | Re: vb6 Hi Are you looking to "push" data to Sage from VB6 or "pull" data from sage? A quick google search for a Sage API led me to a page regarding their [Software Development Kit](http://www.sage.co.uk/partnering-sage/developers/benefits/sdk.html) (SDK) with contact details to speak to their technical experts. Have you tried this avenue? HTH |
| | Or if you have a menu already, assign a shortcut key to the menu item. |
| | Hi I'm guessing you have Option Strict On (which is great) as if it was Off then both your code and that posted by Reverend Jim would work fine. But with Option Strict On you get a conversion error from System.Windows.Forms.Shortcut to System.Windows.Forms.Keys. To fix, you need to cast the … |
 | Hi You could use the SelectedIndexChanged event of the TabControl to then find the the WebBrowser control on that tab page and read its Url property. Something like: Private Sub TabControl1_SelectedIndexChanged(sender As Object, e As EventArgs) Handles TabControl1.SelectedIndexChanged 'Grab the Web Browser control on this tab and read its URL … |
| | Hi You need to specify the type of command you are running. I believe the default is Text which is why you get the exception regarding the missing parameter. Add the following: cmd.CommandType = CommandType.StoredProcedure; HTH |
| | If this is SQL Server then you could use the DATENAME method: SELECT * FROM YourTable where DATENAME(month, YourDateField) = 'July' In this way, you can select all records that match a month regardless of year which is what I believe you want. |
| | Use the [break](https://msdn.microsoft.com/en-us/library/adbctzc4.aspx) statement. |
| | Re: creating a guid Hi A GUID (Globally Unique Identifier) by its definition will change each time you request one. If you want a persistent one then you will need to generate it once and save it somewhere. |
| | Hi Your openreport line looks invalid. If your reports are located in a folder called "\abc\" that is in the same location as your application then you should be using something like: app.path & "\abc\report.rpt" HTH |
| | Hi Your table is using field names with both spaces and potentially reserved words (password). So you will need to enclose both of these within square brackets (or rename the fields in the table). command.CommandText = "select * from log where [User Name]='"+textBox1.Text+"' and [Password]='"+textBox2.Text+"'"; HTH |
 | Hi The following syntax should work: IF EXISTS (your select statement) BEGIN 'Your update statement END ELSE 'Your insert statement Note in the above there is no BEGIN or END on the ELSE part of the statement. Also, I am not sure if your number and measure are string values … |
The End.