Smith5646

If you can post what has you stuck, either the code that isn’t working or pseudo code if you’re completely stuck with the language, we can help you out. We are here to help and gladly do, but we will not do the work for you.

I am guessing (since I don't have tables to verify with) that the problem is that in the below select you have two tables named p, the ledgertable and the result of the select. If I try this with MySQL, I get an error. If you find this is not …

Just to clarify where your error is... if you find an even number, you are executing a boolean statement (number = even). if you find an odd number, you are executing a boolean statement (number = odd). You are never incrementing even or odd. That is what ddanbe is showing …

I have written a REST API using C# that runs on my server. When it is started, I want to preload some data from the database based on the organization that has purchased it (name, address, etc). However, I can't seem to figure out the name of the initial program …

I am confused with what you are trying to do because your question says you want then number of days REMAINING in the year yet your sample shows days PASSED. I didn't walk through all of the code you posted but here are a few thoughts on what I'm seeing. …

I am trying to find an efficient way to build a cross reference in C# and I am at a loss so I thought I would ask for ideas. I have tried using a list view, concatenating the source and associated values into a single dimension array, and several other …

As I dig deeper into the capabilities of Visual Studio, I have seen that you can have multiple projects in a single solution. I must be missing something because I can't come up with a reason to ever do this? My guess is that I don't understand the benefit. So, …

I'm not 100% clear on what you want. If you only care that both textboxes are non blank, can you initially set your button to disabled and then use the following code? When both textboxes have a non blank value, the button is enabled. private void textBox1_TextChanged(object sender, EventArgs e) …

I don't see a screen print and don't know what you database looks like so maybe some stupid questions but... 1) is book_date a true date field or something else (char or number) with what something that looks like a date? 2) is there a sort defined on the list …

I am trying to find information on best practices for json data. I am working on a client server app that will contain family information. For purposed of this question, this is an oversimplification of the database. I have a family table, an address table, and a family members table. …

I'm looking for some ideas on a direction to take on a project. I have a software package that I want to develop. When I discussed the software with a potential customer, the first question I got was does it run on a mac? The second question was does it …

I am trying to build a webpage that has a list of topics on the left side of the page and then when the user points to them (request has been made for hover and not click), the details of that topic show on the right side of the page. …

If you haven't already figured this out, you need to copy lines 28 and 29 to just after line 34 so it clears the boxes before adding values. If this doesn't fix the problem, let me know.

What is the problem? Is the program blowing up? Is it not returning rows? Is it returning wrong rows?

I use the Mod operator which returns the remainder. [CODE] Dim lvi As New ListViewItem lvi.Text = "Hello" If ListView1.Items.Count Mod 2 = 0 Then lvi.BackColor = Color.white Else lvi.BackColor = Color.LightGray End If ListView1.Items.Add(lvi) [/CODE]

Is your app a window app or command line app? I found this on Microsoft's website. Command-line applications must have a Sub Main defined. Main must be declared as Public Shared if it is defined in a class, or as Public if defined in a module. You Main should look …

The idea of children windows is so that many windows can be open and manipulated at the same time. If you want the app to halt while the child window is open, you should use a dialog box, not a child window.

yy returns only the last two digits of the year (12). The variable strTheId in your program = 0112. Try extracting yyyy instead of yy to get 2012 and then concatenate them in the reverse sequence...strYear & strMonth to get 201201.

You are missing some &s for joining strings. "" such as "string1""string2" is translated as string1"string2 and not string1string2 [CODE]Public urlMySQLDatabase1 As String = "Server=" & frmLogin.txtServerIP.Text & ";" _ & "Port=" & frmLogin.txtServerPort.Text & ";" _ & "Database=DatabaseName" & ";" _ & "Uid=UserID" & ";" _ & "Pwd=Password" & …

Try dateTimePicker1.value.hour

I have a menustrip with several levels of submenus as in below Client 1 [INDENT]Project 1[/INDENT] [INDENT][INDENT]Project 1 Task 1[/INDENT][/INDENT] [INDENT][INDENT]Project 1 Task 2[/INDENT][/INDENT] [INDENT]Project 2[/INDENT] [INDENT][INDENT]Project 2 Task 1[/INDENT][/INDENT] [INDENT][INDENT]Project 2 Task 2[/INDENT][/INDENT] Each entry is clickable, even if it has children. In the above example, I can select …

I have read your post a number of times and can't figure out what you are asking. Maybe if you can provide additional information someone will be able to answer your request.

Line 28 should be cboStreetName1.Text. .selectedindex.tostring returns the number of the selected index. As a debugging hint, I often use MessageBox.Show to make sure I am getting the value that I am expecting as in MessageBox.Show(cboStreetName1.SelectedIndex.ToString) I am assuming that you are wrapping lines 22-33 in a SelectedIndexChanged block so …

I think you have a problem with the build of your names array. See if the value of the last entry in it is NOTHING.

Try setting a value for DialogResult in the second form based on the button clicked and then interrogate it in the first form.

Maybe you could use an arraylist (drivers in the example below) instead of 6 different variables (d1 - d6). Then you could do something like this. [CODE] If player(x).drivers.Contains("VETTEL") Then player(x).score += score.vettel End If [/CODE]

I'm confused with what you are expecting to see. Do you want the two textboxes to look the same without the first and last line or do you want it in a single line with a space between each value like this... sadsadasdas dsad as das d Either way, I …

I am trying to find a good sample license agreement for some software that I have written but can't find anything that meets my requirements. The software will be tier priced which will be controlled by an authorization key that limits the entries into the database. Since the control is …

I am working on an app that is an MDI. When the user clicks a button on an MDI child, I want to "disable" the current MDI child (and only the current child window), open a new window that has control, and then re-enable the child window when the new …

[CODE]If (dateDifference > 7 Or dateDifference < -7) Then[/CODE] will trap dates outside of the 7 day range in either direction.

The below code will trap the event you are after. However, once an item is selected, it can't be deselected without selecting another value. In other words, SelectedIndex will never again = -1. It would seem that you need to set Label26.visible = true during load and then let this …

Assuming you are using a SaveFileDialog, try .InitialDirectory = "yourpath" [QUOTE=udayreddy;1150433]how to set destination directory path to save file[/QUOTE]

I have a program that adds controls on the fly to an auto-scroll panel. When the panel is scrolled (viewing the bottom of the panel for example) and a control is added, it looks like it is added assuming the top left corner of the panel is still at 0,0 …

In my program, I want the user to be able to move an MDI child window anywhere inside the MDI container but I need it to be kept completely inside the container boundary. For example, the upper left corner should never be at a location less than 0,0 when moved …

I have a main form that has IsMdiContainer = true. I have a second form (FamilyForm) that is to be the MDI child. Using the code below, when the line TempForm.MdiParent = Me is executed, the FamilyForm window size, font, and all controls are larger than shown in Visual Studio, …

I'm not sure what you are trying to do but try changing it to Array.Reverse(arrFilename)

It has been a while so I could be remembering this incorrectly. I believe you need to do your rs.next() before your rs.getstring(). The execute query does not retrieve any data from the database, only prepares it for the first rs.next(). By having a do...while, your while is not executed …

Your SQL statement is messed up. Where clauses need "AND"s between comparisons, not commas. '12345' = CustomerID AND 'Smith' = Surname Run this in the debugger and break on line 130 (based on the above code) and look at SQLString. Also, before you have problems with it later, your SQLString …

I'm not sure when you are trying to total so here are two possible ways. Create a variable named Total [CODE] Dim Total as Double [/CODE] To keep a running total as things are entered... After adding the info to the listboxes... [CODE] QuantityList.Items.Add(quantity) MenuitemList.Items.Add(item) PriceList.Items.Add(price) Total += quantity * …

I wanted to delete all of the TextBoxes that I put on a form that start with "tbx". The below code only deleted some of them. [CODE] For Each ctl As Control In Panel1.Controls If ctl.Name.StartsWith("tbx") Then ctl.Dispose() End If Next [/CODE] So, I took it a step further in …

.Remove does not delete or alter the control, it just takes it off of Form1. .Dispose removes the control from Form1 and deletes it. .Add adds the control to Form1 AS IS. I'm not sure what you mean by "does not load" and what variables are not reloaded. Give me …

You have a <BR> between each of your table row end tags and the next table row start tags. [CODE] </TR> <BR> </TR> [/CODE] Because the <br> is not in a table row, the browser moves it outside of the <table>. If you want a blank line, add a <br> …

Since rd.read() will return a true if the read was successful and false if it was not, try... [CODE] If rd.read() Then If TextBox8.Text = rd(0) Then ...remainder of your code End If Else MsgBox("BAD Username") End If [/CODE]

I have a program that allows the user to add steps to a process (tabpages in a control). All tabpages are generated on the fly by duplicating a "template" tabpage and consequently have the same control names such as textboxStepDesc. Here is the hierarchy of the controls to get to …

From the code posted, I think you are trying to update the record you previously read, correct? If so, the syntax you need is something like: UPDATE MathsTest SET EasyTime = @EasyTime, EasyDate = @EasyDate WHERE LoginName = '@Username' AND Password= '@Password' and don't forget to also pass the Username …

Without seeing code, I'm flying blind but here are a few possibilities. 1) Is the query that does not work not passing all parms? 2) Is the value for Param4 not a string? This should give a different error but it's a guess. Post a little code and maybe I …