Make A DataGridView Similar To An Excel Function?
Jul 2, 2010
I am trying to essentially convert an Excel spreadsheet into a Windows Form. On the first worksheet I have setup an IF statement to work as a search function =IF(C10="","",VLOOKUP(C10,'Price List'!$A$2:$D$40008,2,FALSE)) to read a price list on a separate worksheet. It works by taking a partnumber then puts the description in the next column (description column) and then the price in the "price each" column then finally totalling the row based of the quantity selected (see below).[code]...
View 11 Replies
ADVERTISEMENT
Jun 22, 2012
een using excel extensively. In excel I use vlookup function to connect and retrieve data from other workbooks. I want to know how I can do it in VB. So far I have created a form.The form has say three text boxes viz (i) A unique Number (ii) Name (iii) Address. I want that when I write the unique number in the text box for unique number the other two text boxes i.e. of Name and of Address should be auto populated. I have also established and tested the connection with the access database file using ADO.NET. I do not know whether I need to write an SQL or LINQ query for this purpose or I should write some codes. What should i do it and how should i do it?
View 5 Replies
Mar 2, 2010
I have written a code that performs calculation similar to SUMIF function used in excel. My data is in a datagridview and is all dynamic. My data is in the following format
X1 X2 Yj
1 1 11
1 2 12
2 1 13
[Code].....
I am getting a PE value for every cell in the code. How can I modify my code to get the results above. Kindly guide me through it, I know I am probably missing a minute detail somewhere but I am really struggling with this.
View 4 Replies
Feb 8, 2010
If I'm not mistaken PHP crypt() function use DES-based encryption algorithm. So I've search DES Encryption code and all that I found is code that similar to the one in this post http://www.vbforums.com/showthread.php?t=471798
But with those codes I must enter 8 character lenght salt. Less then that the code wouldn't succeed. In the other hand. The PHP crypt() function only could use 2 character length salt. If you enter more than that, it seems it only use the first 2 character..[URL]
View 1 Replies
Jul 28, 2009
Im looking to make a desktop app that will be similar to the doodle function in yahoo messenger but with a loaded background image to draw on. I was thinking of using a P2P/IP chat on the side.Im just starting with vb most of my coding has come from actionscript
View 3 Replies
Feb 2, 2012
In Visual Basic I used to use the Mid function to loop through a string and examine each character, i.e. like this:
[Code]...
Question is, how would I go about doing something similar using Java?
View 3 Replies
Sep 6, 2010
Lets say I have function returns an object and that object has 10 properties. for example
myStudent.ID
myStudent.Name
myStudent.Surname
[code].....
View 10 Replies
Aug 20, 2009
can some one help me show the code how to pass textbox value and then search it at datagridview.when i write "abc" in text box then datagridview wil show only a record that contain "abc" word.and can it be outomatically show at datagridview.i mean when i just type a at the text box then datagridview will show a record that contain a, and when i add b in text box = ab then datagrid will show record that contain ab word..
View 1 Replies
Nov 12, 2010
I have a flow document table with text in it. The text some timess just on one line , often on many lines, that means it could include a return and a tab spacing (all in the same cell).I want to put the data from the table to the clipboard in such a way that i
View 7 Replies
Mar 26, 2010
I have combobox in a form. The combobox is bound to a table and displays the list of values as expected. What I want to do is also bind the combox to another field in a different table similar to the way the datagridview with combobox works. That is the dgv is bound to the combobox column but the dgv's bound value sets/reflects the value selected by the combobox. I can't figure out if this is possible with a standalone combobox.
View 3 Replies
Jul 26, 2010
I'm trying to group similar items together, for example, the image below.
I wish to group the "apple" together and once it is grouped, I want the average value from the two values.
Here's my codes.
VB.net
Public Partial Class MainForm
Public Sub New()
[Code].....
View 11 Replies
Jun 3, 2011
Basically I'm trying to make a file browser similar to what XBMC has, a file browser that you navigate with your arrow keys.This is the custom UserControl I made:
The small box on the left will be an icon, I will have a custom icon for directories/files. The label box that says title will be the name of the directory/file.
What I need to know is How to get the name of the directory/file so I can change the Title labelbox text to match the name.How to distinguish whether it's a file or a directory so I can set the picturebox to the right icon.How to create a new UserControl for each directory/file
View 1 Replies
Sep 14, 2011
I'm wondering if it's possible in VB.NET to make similar properties call one generic one?A sentence doesn't explain it well so here's a code example.I have a bit field defined like this:
<Flags()> _
Enum E_Operation As Integer
Upload = 1
[code]....
View 1 Replies
May 7, 2012
I'm making a seat booking system in vb.net (WinForms) and I need the user to be able to select the seat they wish to use and for it to change colour (so they can tell that it selected).
I began to try using buttons, but 480 buttons seriously slowed down the load time for the form. I then tried a data grid view with buttons in the rows/columns, but couldnt make that work properly.
Would it be worth trying to use 480 picture boxes and change their background colour? Or would that just slow the form down the same way as 480 buttons?
View 2 Replies
Mar 23, 2012
I want to pass a List of T where T is an object I've created that has about ten properties (strings, dates and integers).The lst passes to the function successfully. I am also passing an New T of the Object (itm as T).I can see all the values (see image below), but because it's generic I cannot seem to retrieve the property values and I cannot figure out how to iterate through the properties of each itm as they are retrieved in the For Each.[code]
View 10 Replies
Mar 28, 2010
how can i add two excel sheets with numbers and the equal (similar)numbers to save once
View 1 Replies
Jan 10, 2012
I'm trying to export a datagridview to Excel and open the Excel spreadsheet (not SAVE the worksheet).
Public Sub ExcelRpt(ByVal DgvName As GridView, ByVal url As String)
Dim xlApp As Microsoft.Office.Interop.Excel.Application
Dim xlWorkBook As Microsoft.Office.Interop.Excel.Workbook
Dim xlWorkSheet As Microsoft.Office.Interop.Excel.Worksheet
[code]....
View 1 Replies
Aug 1, 2009
i wanted to ask how to make picturebox1 ,to which functions are already assigned, perform the same function as picturebox2 ,to which no functions are assigned.For example:I have already made picturebox1 and have assigned it alot of function like when play button is pressed then picturebox1.visible = true and when we press pause button picturebox1.visible = false. So now i decided to make a theme and have to remove the picturebox1 and want to allow the picturebox2 to havefunction of picturebox1.But when i disable the theme the function of picturebox1 should go back to picturebox1.
View 6 Replies
Jul 16, 2010
I am looking to make a "user.settings" file or something similar that stores information for my application. I'm not sure how I would read a text file per line and do something depending on what it says.
View 7 Replies
May 18, 2011
Is it possible in Visual Basic to make a Windows form vibrate randomly for a few seconds, similar to an "earthquake" effect?
View 3 Replies
May 19, 2011
I'm doing a project for school. I'm trying to make a game similar to the Impossible game. I need a square (picturebox) to jump but I want gravity to effect it.
View 1 Replies
Oct 12, 2010
Can I make a certian function that will fade out [make a black screen that fades out for 2 seconds], then come back? Is that possible? ON A FORM.
View 3 Replies
May 20, 2010
I know how to check whether an item exists in a list using (MyList.Contains), But I do not know how to check the whole list. For example (use one button and one richtextbox):
[Code]...
View 14 Replies
Oct 22, 2009
I've got a basic logon form where if you enter the right password/username, it redirects you to the "MainMenu" Form How can I make a function called "checkLogon" that checks the username/password text to a variable in that function?
View 3 Replies
Dec 12, 2009
Heres my code
Public Class Encryption
Private _cipherEngine As New Cipher
#Region " PassEncryption "
[code].....
View 2 Replies
Jan 29, 2010
I am using VS2008 and I have a form which has a datagridview. This is for an invoice where I already have the user select the customer from a details view and want to have the items in the datagridview change based on what the customer selected. Then when the item is selected I want to have the price change accordingly.
So far I have the customer selction as well as the item combobox(not limited to cust items yet) appear, but I cannot figure out how to get the join of the 2 items (cust+item as the price varies from cust to cust) to change the price. Question is, is it possible to do this in the same datagridview, or should i try to just break this down some other way?
View 1 Replies
May 24, 2011
Does VB.NET have a function to get the quotient like you can in excel.
Quotient(12, 6)
View 3 Replies
Mar 22, 2010
actually im new with VB 2008. i need some help to solve my project.i create table at excel 2007. in that table, i insert function so that when i key in some value, there will be some result at that table. my problem is how to import table with that function that i create in excel 2007 to VB 2008 so that the table with function appear at VB 2008? please help me..i really need help to solve my problem..
View 1 Replies
May 20, 2009
adding the from line in the below code. It works fine now, but I would like to add the from line and send it on behalf of a group distribution list. I have tried multiple combinations such as From and .from, sendfrom, mailfrom, fromto.
[Code]....
View 1 Replies
Nov 5, 2009
I have a function in VBA that I need to convert into VB.net:Sub Crossfunction(ByVal Array1 As Decimal, ByVal Array2 as Decimal) As Boolean
Dim C As Variant
Dim Above as boolean
Array1 = Array(1, 2, 3, 4, 5, 6, 7, 8, 9)
Array2 = Array(1, 4, 3, 7, 5, 8, 7, 2, 9)
[Code]...
Is this the correct method? And how can I convert the function and not get an error: Error 1 Value of type 'System.Collections.Generic.List(Of Decimal)' cannot be converted to '1-dimensional array of System.Collections.Generic.List(Of Decimal)' when I redefine the Arrays as: ByVal Array1() as List(of Decimal),ByVal Array2() as List(of Decimal).
View 3 Replies