Input a range of numbers and sort them into 6 equal amounts and then having the program tell you which amount the number was put into?
I.e
Input:
1200, 2400, 600, 600, 300, 300, 1200, 1200
Sorted into:
Group A: 2400 = 2400
Group B: 1200 + 1200 = 2400
Group C: 600 + 600 + 300 + 300 + 1200 = 2400
I'm trying to assign some parameters for a stored procedure with some values that are stored in a data table. in the code, I can set the parameter values to the data table, and give a column header or index without issue, but when it tries to execute at runtime it bombs out.the error I get is a variation on "Failed to Convert Parameter Value from a DataColumn to a String" depending on exactly how I try to assign the value.the data types are all correct elsewhere in the code.
my code for this bit is
Try
ConnectionAttempt.Open()
Try
With NewYearCommand_Dates
[code]....
other things I've tried to get this to work are all variations on the .Value=dates bit, such as
.Value=dates(0) (so using column index)
.Value=dates.columns(0) (again using column index)
I've also tried declaring variables, and setting their values to the values in the columns, but the code returns an error saying that "Value of type 'System.Data.DataColumn' cannot be converted to string".I should point out that i'm doing this for 3 tables at once in this sub, 2 of them will only have a single row of data, but the third has an indeterminate number of rows.I'm afraid I don't know what else to do. I'm lead to believe by my mate and my lecturer that this should work, and of course it will work, but the evidence says otherwise.
I have a winform with richtextbox. I want to get the user input values in any window like chat programs(msn,yahoo,gtalk), Ms Word,...etc, and set the values into richtextbox?
View 3 RepliesI want to check If a variable is equal to some values or not, for example:
if a = 1 or a = 5 or a = 7 or a = 10
is it possible to do it like sql:
if a in (1,5,7,10)
I am using VS 2010 to make a web site and working on a page right now. After submitting my variables, I need to output the values as a pdf
View 1 Repliesuse values to output and save as pdf
View 4 Replieshow to plot a graph using the out put values in textbox[code].....
this is my code but it doesnt seem to accept the output. It works everytime I enter number only.
I have a problem with a sql query. Through the query I am trying to search database for any occurrences of string (can be anything) in a column using the SQL LIKE command. The problem is that it works fine for most of the strings say john, jim, ji"m , but does not work when i include the following characters which are ( ' , { , } , and a single quotation mark). MYSQL query takes care of these special cases by putting them in [] block whenever user enters them .But i am getting the following error when i go to query the database using the GetSelectCommand() in VB.NET
Exception Details: System.ApplicationException: Number of values provided must be equal to the number of placeholders in query.I have checked the query over and over again .. but its fine .My database server is Sql Server 2008.So my application throws the exception in this command:
Using reader As MustDisposeDataReader = _
pmSystem.DatabaseManager.GetSelectCommand(selectStatementBuilder.ToString(), New Object() {})
Where MustDisposeDataReader is an instance of a class in an internally developed library, which inherits from System.Object. pmSystem is an instance of the class PlanManagerSystem which implements the commandlayer. GetSelectCommand() takes the select command
i am having trouble displaying the values i get from an IList(Of T) and displaying that in a listbox found on another form. I have used a for loop to get the values from the IList, then i can display that in a msgbox. for eg:
Dim j As Integer
Dim path As String = ""
For j = 0 To best_tour.Count - 1
[code]....
best_tour is ot type IList() path keeps the name found in the list everything works fine inside the loop..but it does not populate the lst_output listbox.I have tried using files, but in vain. It just get the values from the list but does not display that on the listbox.If that can help, then listbox is found in a panel on the form2, but taking it out of the panel does not affect anything.
I wrote this code and everything works as planned:
Module SalesCommissionProgram
Sub Main()
Dim name As String = 0
Dim code As String = 0
Dim monthlySales, commissionDollars As Double
' Prompt user to input value for name
[Code] .....
For the finished project I am supposed to have it output the total sales and commissions for that were calculated before the sentinel value (Eugene) was entered. Here is what I tried and here is where I am lost.
Module SalesCommissionProgram
Sub Main()
Dim name As String = 0
Dim code As String = 0
Dim monthlySales, commissionDollars As Double
[Code] .....
How to reconfigure code to output specific values rather than collection
View 2 Replies"Working with Multiple Forms in Visual Basic .NET: Upgrading to .NET" url...states very clearly, "you need an instance of a form before you can display it or work with any of its controls or properties". Granted, this was written for VB.NET 2003, but I can't find any reference where this has been changed in later versions. [code] Running this in Debug, both OriginalForm and InstantiatedCopy work fine. The Output window displays the values for both forms identically. (I'm using Visual Studio Professional 2010.)
View 17 RepliesI currently this code on my app that works great to loop through a page and grab the label of an input value of a form and then print the value to a rich text box.I am now trying to revamp the code to give me the ID the value if the label contains a specific name.For instance if the label before the input field contains the word Username then I want the application to output the ID of the input field rather than just everything that has a label.
Here is my current code:
Dim web As HtmlAgilityPack.HtmlWeb = New HtmlWeb()
Dim doc As HtmlAgilityPack.HtmlDocument = web.Load("http://shaggybevo.com/board/register.php")
Dim nodes As HtmlNodeCollection
[code]....
Just sorting a value and displaying them with original values. Procedure is displaying the sorted values in msgbox but in place of the original values, it displays the original values again.
Public Sub FlagProb2()
Dim Count() As Integer = {2, 1, 4, 3} 'Original Array
Dim SortedCount() As Integer = Count 'New array for sorted values of original array
Array.Sort(SortedCount) 'Sorting values
For j As Integer = 0 To Count.GetUpperBound(0)
MsgBox(SortedCount(j) & " , " & Count(j)) ' Displaying sorted and unsorted values
Next
End Sub
Using VB.Net
Database Form
Server Name, Username, Password - textbox
SQL Authentication, windows Authentication - checkbox
I have Database Form, First Time i run my software, I have to give Server Name, Window or SQL Authentication mode, UserName and password. Next Time I run the software, given data's like Server name, username, password, window or sql authentication should appear in the form. Before I used VB6, I used the ini file for getting the username, password and servername.
vb6 code.
Dim File As String, OFLen As Double, str As String
File = App.Path & "SQLServer.ini"[code]....
There is any option is available in the vb.net for saving the data's or i have to use the same format(ini file) in vb.net
what im trying to do is make an application to change values in my modems web config page.my trouble at the moment is that I want a textbox to display the value held in an input box from the modem.I currently have a web browser control on my form and have it navigate to the config page on form_load.
How do i get data from a database and put it in to multiple text boxes?Basically i have abilling form with; name, address, etc.But i have a 'retrieve' function underneath which allows a name and post code to be entered and then the information above is automatically filled in if the name and post code exists. At the moment i just setup a connection with the variables. not sure how to do the rest
objCommand.Connection = objConnect
objCommand.CommandType = Data.CommandType.Text
objCommand.CommandText = "SELECT CustomerName FROM Customer WHERE CustomerName = @CustomerName AND PostCode = @PostCode"
[code]....
I have an input box that allows users to enter a date that when the user clicks "Ok" that it does two things, marks a field called "code" in my Exceptions SQL table as H and passes whatever date they have entered to that table as well.
View 1 RepliesI have a form that requires input from a user that will update a database table. So they are offered input boxes. What the input box will do is ask the user to enter a date, what that will then do is to mark a field marked 'code' in my sql table as "holiday" for that entire day.
View 4 RepliesI have several textboxes and one combobox in which I would like them to have them placed in a file, but I have run into several problems while doing it. I am taking a beginning course and the book doesn't seem to explain things to well.
1. How can I let the user enter a file name after the data and button has been clicked
2.How do get I get a information from the combobox to grab the text within the selected item to the file
3.How to I write the entered text value to the file like using the notepad file?[code]..
User inputs values into textboxes , user hits calculate(Button) user needs to be able to input new values so.
[Code]....
I am trying to create an input validation for my program to prevent the user from entering negative values. I've been using:
If (decLabor < 0) Or (decPartss < 0) Then
MessageBox.Show("Input prices for parts and labor must be positive")
To pass decimal values to radio buttons so I can calculate an output answer. it is a tip calculator. I am using radio buttons as options to choose what amount to tip, ie. 10, 15, and 20%. I need to figure out how to pass the value to the buttons in code so I can calculate the tip amount.
View 1 RepliesI have to scan through documents. Excell, Word, txt, ect looking for company names that match a pre-difined list of companies.I then email the companies some specifics in regards to that doc.The problem I have been having recently is that the list of companies keeps growing and I am starting to miss some more than I used to.What I would like to build is a tiny app that has 2 Text boxes.1 on the left for input (where I would copy/paste) the document text I receive.and one on the right for the output where it will highlight any line that contains the name of any of the pre-defined companies.
I started toying with the idea and so far I have form with a SplitContainer. Within that SplitContainer each side has a TextBox... Below the Textbox on the left hand side splitcontainer I have a submit button with no actions currently assigned to it.
I'm creating an emulator for a device to simulate wave forms. My challenge is that when I try to convert the output of the following code, I can't convert the Math.Sin's double output into byte values that lend themselves to the byte array format required by an existing graphing control as listed at bottom below. I''m not sure how to handle this when the sin function creates negative values but the byte values will need to be positive and basically 'shifted up' so that anything over 127 is negative. (0 - 255) unsigned. BitConverter.GetBytes has been suggested but THIS is the result of that attempt.
[Code]....
I have some problems with coding my visual keypad in order to input a value when the selected textbox has focus.With the code below makes the value I chose in all the textboxes.
Here the code:
'Number pad section------------------------------------------------
'Number 1
Private Sub Button5_Click(sender As System.Object, e As System.EventArgs) Handles Button5.Click
[code]....
I have some code that broadly looks like the following ...
WebBrowser1.Document.All("btn_submit").InvokeMember("click")
WebBrowser1.Document.GetElementsByTagName("select").Item("id_pickupdate").SetAttribute("value", "2011-07-07")
I cannot seem to get it to work in one code routine. I end up having to have a separate button to set the date after the page has loaded. I have tried all the blog posts using isbusy, timer etc but it does not seem to work. The code breaks and the error prompt says that id_pickupdate does not exist.
Using Visual Basic 2008 Express Edition.Note: Program is to be used with Touch Screen. (No keyboard or mouse)TODO: Get Log in form to allow the input of values from clicking on Buttons 1 thru 0.*,# '1. So far Buttons on Log in form allow one entry only. Form needs to allow 9 entries. 2. When Clear button is clicked. Password box entry clears, but then, there is no Cursor.Will worry about the rest (authentication) Later its taken two weeks to get this far.NOTE: Not using a User Name Just a Password
[code]...
I'm using visual basic 2010 and i am able to import the raw data from excel and into my datagirdview but i am unable to get the code to add the values of raw data in column 2 and 3 and show the answer in column 5. Do i need to loop it?
The entire project is in the attachment take a look at it.
This is the entire code i have now:
Imports System.Data.SqlClient
Imports System.IO
Imports System
[Code]....
How do you input binded Radio button if checked values "String" to the data base using query Like if check radio button Male the gender in the database will be "Male" And female if otherwise the ,database column is string in my db and my dataset is radio button the inputted record should have male or female in gender column. I'm confused also with date time picker in vb and it is date/time format in database column.
View 1 Replies