I want to add a query on a form called Customers.So, I want to type the begining of the Customer's name, and when i push the button, on the datagridview appear all the Customers with a name like that.
View 2 Replies[Code]...
how to do this. kindly show me some sample code for this
I am trying to find customers name that starts with "S" in my access database. If i run the following query in access its working fine. Select Lastname from employees where Firstname Like '*S*';. it displays two records which is right. if I use it in access it..its not working. Any idea why? All other queries are working in VB. like if I use Firstname equals "Sam" but it doesn't work when I use Firstname Like '*S*'
View 3 RepliesI have a form called FrmPracDetails which is built up with a List view called LvwColProc. Therefore when you click a field on the LvwColProc it takes you to another form called FrmColProcessing, here you can make changes to certain fields which are also present on FrmPracDetails. What I want to do is when you make changes on FrmColProcesing and Click the Save Button (which calls the Save function)the changes appear instantly on FrmPracDetails. Please note, FrmColProcessing will always be open next to FrmPracDetails. I have tried to put this code in the Save function present in FrmCol Processing as shown below, but it doesnt Refresh FrmPracDetails form. [code]
View 1 RepliesI've got a datagrid with checkboxes which calls a routine called checkbox_CheckedChanged. So far, so good. I've managed to get it to work out the value of another column in the dataview, which allows me to ascertain the id of the row I'm dealing with. I'm trying to get it to change the value of the column which defines the initial value of the checkboxes, but the SQL I've written doesn't work when called by vb.net - it does work when entered manually into SQL server, however. Here's my code behind:
[Code]...
I'm trying to run a transaction and I'm having some issues. What would cause a query to be executed before the transaction.commit() is called? Is there a specifice order that queries should be ran when working with a transaction? I have 1 update query that will always execute no matter what, before the .commit() is called. [code]
View 4 RepliesI have a form being called form several forms using ShowDialog().
1. Is there a way for called form to know which form called it by receiving a code or key from the calling form?
2. The calling form has a gridview. How can the called form pick up a column's value from the currently highlighted row in gridview in the calling form?
This is what I have..Dim frmSettings As New frmOptionsfrmSettings.ShowDialog(Me)frmSettings is a settings form that you can choose the color for background of form1(Me)
View 1 RepliesRequested were made by Businese Analyst to set the few Main FORMs VISIBLE PROPERTY TO FALSE when the POPUP FORM is loaded.
[Code].....
When the MAIN FORM loads the POPUP FORM, on the FRMPOPUPCUSTOMER-FORMLOAD even, it has to set the MAIN FORM Visible to False.
When FRMPOPUPCUSTOMER FORM IS UNLOAD it has to set the MAIN FORM Visible = TRUE.
How to the coding is to ensure that different MAIN FORM when loaded FRMPOPUPCUSTOMER it will turn the MAIN FORM Visible to FALSE.
I have two forms. Form1 and Form2. The user is supposed to fill out some information in form2 which then will be used to compute some data in form1. However when I used the code, Form2.Show, within a function in form1, the form2 is diplayed but when the user fills the data and submits them using the ok button, the code does not return back to the function in Form1.
View 3 Repliesam trying to figure out why my 2nd form is not displaying the value i recived in my first form.The code for the first form is:
Private Sub scannerOnCom_DataReceived(ByVal sender As Object, ByVal e As SerialDataReceivedEventArgs)
responceBack = scannerOnCom.ReadLine
[code].....
i was wondering if it possible to have a condition where lets say you have a column in the datatable called amount and a textbox acting as the filter called say maxamount to set it so the rowfilter when filtering the table will sum the number in the amount column until the number in maxamount is met, then stop and only return the rows where the total sum of the amount column is equal or less than the maxamount value, so i guess if the next row takes us over the maxamount it discards this row and returns the rows previous to it. is this possible using datagridview rowfilter or should i be loooking elsewhere to achieve this?
View 4 RepliesI have an sql table called Stock with two fields called StockID and StockCode. I want the user to select the stockcode from a combo which in turn populates the stockid for that item into a lable on my form. I have already populated the stockcode into the combo but dont know how to compelte the rest.
Imports System.Data.SqlClient
Public Class cbo2
Private Sub cbo2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[CODE]...
I have the following line of code in my program:
JCL_History.Enqueue(JCL_History(I))
This JCL_History object is basically a Generic.List encapsulated in a wrapper and has the following method:
Public Sub Enqueue(ByRef value As String)
If Members.Contains(value) Then
Me.RemoveAt(Members.IndexOf(value))
[Code].....
In my testing I have 2 items in this JCL_History list. When I call that first line of code I posted (the one that invokes Enqueue) with I = 1 I expect the first item to be shuffled to the bottom and the second item to be shuffled to the top.
After the thread returns from Enqueue I notice that this is exactly what happens to my list, HOWEVER if I hit the "step_in" button after the execution of Enqueue I go into the Default Property's set method where Index = 1 and value = and it screws everything up, because the item that got shuffled to the end (index 1) gets overwritten by the item value shuffled to the top.
So basically the set method on the default property is getting called at what I think to be a completely ridiculous time. What gives? By the way I'm running VS2005 on XP.
I have a form that is called w/ ShowDialog. Inside that form, I want to pop a message box to ask the user a question, but it doesn't show.[code]
View 2 RepliesI have three buttons on my main form, say Form1. Clicking any of the buttons brings up Form2 modally for input, it's a number pad. Now, depending on which button was clicked to get there, after the user enters his numbers, I need to change a specific label on Form1. In other words, btn1 clicked puts user input into lbl1 and so on... I could probably do this with a variable but wondering if there is a more elegant way.
View 3 RepliesI was having a problem with the debugger not stopping at breakpoints. After a lot of work that yielded no results, I realized that the problem was occuring in the form's load event and subs called from that event.
The problem is that it appears that the load event is not being called. Other startup forms in other projects in the solution seem to be working ok.
what could be keeping the the Load event from working?
I have 3 forms: Form1, Form2 and Form99. Form1 and Form2 both call Form99.What statement(s) does Form99 use to determine which form called it (Form1 or Form2).
Form1
Form99.Show
Form2
[code]....
I am building a program where for part of it the user can enter a parameter which will then query a database and populate a DataTable with the results if the number of results is greater than 1 it will call a "lookup" form to popuate a DataGridView with the DataTable, from this the user can select a row and the result is passed back to the main form or if the result is not there the "lookup" can be closed.
This works fine the first time the parameter is used to query and opens the "lookup" form and populates the DGV, but if the user returns the the main program after using the lookup form and enters a new parameter and the lookup form opens again the DataGridView is not created and populated. But i am 99% sure the DateTable is being populated as if the row count is 1 it will automatically return the single value and this is happening even after the lookup form has been used.
So it is just when the Lookup form is being used a second time the DataGridView is not being popuated or the DataTable is not being passed.
[code]...
How do I use for loop in vb.net something like
dim start as integer
Dim customers as New List(Of Customers)
Customers=dataAcess.GetCustomers()[code].....
I want to process some data for each 500 customers..
I tryed to make a media player and i added a button to the form called "Full Srceen".[code]'so i get an error message : Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))
View 2 RepliesRight basically if a checkbox in my application is checked "Close to system tray" then my form will cancel close and send to tray instead
[Code]...
I call .show() and .hide() on a form and then I want to determine the current state. I've been checking .visible to determine if the form is visible, but I've stumbled uppon a problem. My form is being rendered inside a SplitContainer which I collapse each time I hide the form. So, by logic once I hide the form with .hide() it is no longer visible, and since I have collapsed it's container, even if I call .show() it would still NOT be visible couse it's container is closed.
So, how can I simply check if .show() has been called rather than checking if the form is visible.
The final goal is to show() / hide() the form along with collapsing / un-collapsing the container.
P.S.: I know I could simply check the container and show the form accordingly, but my form also supports detaching from the container, so that wont work for me.
I am writing a control application for an inteface card. The complicated work of initialising communication with the card is written and working fine. However, my problem is to update the text in a dialog label on the communication interface form from a module that contains all the coding for accessing the inteface card. From the module, the interface dll returns data that describes some typical connection errors and the module then calls on Public Subs in the form to display error messages; for example:This is the Public Sub in the Module that initiates communication with the interface card:
Public Sub OpenDeviceInterface()
DeviceID = 1 - My.Resources.DeviceID
h = OpenDevice(DeviceID)
Select Case h
Case 0, 1, 2, 3
[code]....
What happens when these Public subs are called from the module is that the MSgBoxes I made to test the routine show up but the label text doesn't appear.I've tried; Refresh, on the label and the form without success...
When an application "crashes" when the form is forced close is the closing even called and executed or is the process just terminated?
View 2 RepliesI have an access database which includes Customers table and one of its columns is the Birth date. In project in visual studio, using visual basic 2010, I have a form with a calendar. In this form I want to show who has birthday today. How can I compare all the customer�s birth date with the day we have today? And have as result a label with all birthdays?
View 1 Repliesi have a big problem i have no idea what i am doing and need to create a program that can add customers and calculate and add the car qoutes to a text file. the information also needs to be retrieved, basically i want someone to finish the qoutes form for me complete with code its like connect the dots but with code :P can you fill in the "dots", create and edit btw for some reason it was called !! ERROR !! because it was a bad second version of the first version that got deleted so i used this one anyway XD[URL]..
View 5 RepliesThis question appears to have died, so I've decided to offer a bounty.What I'm most interested in knowing is if my scenario in the ETA1 below is viable and is used. If it isn't, then a good explanation of why not would be a good answer. Another good answer would be an alternative (but not including the internalsvisibleto attribute).
The best answer would be, yes, it's viable, everyone does it and customers love it!ETA2: I think I've thought of a good solution. I provide the customer with a distributable edition that is as functional as their edition but is unlicensed and has the classes and members hidden, using attributes.
I can do this with compiler directives, on every single important member, but I wondered if there was some global way to hide all members of a class?
A simplified scenario I have a class that extends a control in someway and I want to sell my class under two licenses;
(1) Standard - The customer gets x number of controls that use my class but can't instantiate the class (its internal).
(2) Developer - The same as Standard except they can create their own controls that use my class.
My problem is that when the developer customer comes to sell their controls, they can't help but expose my class to all their customers.
The only way around it, in my scrambled mind, would be for the developer to somehow integrate my assembly into theirs, and in that way I can keep the constructor internal. Or, use the internals visible to attribute.
ETA1: I'm thinking aloud here, but, I could have a list of permissable calling assembly names which the customer could add to. When they ship their product, their customers' assemblies would not be in the list and therefore they wouldn't be able to instantiate certain classes. (The list could obviously be hashed).
I am using crystal report for displaying reports. I want to display group by customers in report that i am displaying using group by funtion but i also want subtotal of that group by customers. I want to display received amt date, received amt and balance amout between given two dates. That i am getting. output is like first customer name and below that list of there received and balance amt with received amt date. But before displaying second customers list i want to display subtotal of received and balance amt. and in last in page footer i am displaying grand total of received and balance amt.
All data are displayed instead of subtotal of all customers. how to display subtotal of all customers received and balance amt?
In this program I am suppose to use data to compute a customers electric bill. My code works correctly for the most part except for two things. I cant get the loop correct I want it to ask the customer to enter readings but once it does it outputs the same information from the original time so I am wondering what I have to do to have it recalculate when new values are entered by the customer. My other issues is it is suppose to continue to ask the customer for additional readings till the value entered by the customer is -99999, when I run my program and enter -99999 it does not stop.
[Code]...