I have lots of datagrids on one form. However, the datagrid controls are all on different tabpages and tablelayoutpanels.
How can i programmatically "pick" up all the datagrid in one form, even though they are child controls of other controls?
[Code]...
I'm developing a Windows Forms app that will be used to update information on 2 database tables.The 2 tables are related, so the ID fields in them will correspond. In the app, I'm using 2 DataGridView controls. THe first (Status Rules) is DataBound to a DataSet and visible when the application loads. The other (Status Flags) is empty and hidden. The user will select an ID field from the RulesGrid which will fire up a connection to the database and display the entry in the Status_Flags table that has the same ID as the value of the cell the user clicked.I thought of using a standard conditional SELECT statement to do this, but the Flags grid isn't displaying any data. My code Follows:
Private Sub RulesGrid_CellClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles RulesGrid.CellClick
Dim conn As New SqlConnection('ConnectionString)
Dim sql As String = "SELECT * FROM ctblMKA_Status_Flags WHERE intStatusID = '" & RulesGrid.CurrentCell.Value & "'"[code].....
how to accommodate two datagrids from two different tables on same form as only one binding navigator bar is shown on the top of the form.
View 4 RepliesI am trying to create a simple parent-child form in VB2010. I use a datagridview for each table/datasource and each is bound to the parent/child table and each table grid fills correctly. What I want is the parent-child relation to enforce filling the child table with only rows that fulfill the current row on the parent. I have created a DataRelation in the form load, but it will not permit a relation between tables in 2 different datasets. If I attempt to place both tables in a single dataset and define the PK-FK relation in the SQL Server I cannot create 2 separate datagrids from the same dataset.
View 2 RepliesI am working with two databases stored in SQL server 2005, with VB.Net 2005. Database 1 - is the DevelopmentDB and Database 2 - LiveDB. I have two front-ends one connecting to the DevelopmentDB and the other connecting to the LIVEDB.
Now, I have a problem with the live front end. After publishing, it accepts me to log on with the Live username and password..(it connects to the LiveDB) Note: The two front ends i.e., for Development and Live have different usernames and passwords.
So, I get connected to LiveDB, however, when I open a form built in Datagrids it connects again to the DevelopmentDB.I have checked the connection strings its connecting to the Live. This is not an application or database problem. The reason being I tested it on another PC and when I logged on with my credentials it was fine. I was connected to the live database and all the forms were displaying accurate data. Therefore, my conclusion is that this is not the front end or backend problem.
I have a form with a tabcontrol(6 tabs) with a groupbbox on each tab page containing numerous NUDs. The NUDs need to be checked for either 0 (double) or 0.0 (decimal). I don't want to have to do this over and over:
vb.net
If Me.nudLinealFeet.Value = 0 Then
MessageBox.Show("Lineal Feet cannot equal 0.", "No Value Given")
End If
[code]....
but I can't figure out what to do since there are more than 1 "parent controls".
I am newbie in VS 2005 and started learning. Can you please tell me how to Pop up the data from a table when there is a key press in the textbox.
View 11 RepliesI am thinking of creating a code to allows my project to pass through the port forward without the outcoming connection details being pass on the third party software such as packet sniffer.Is it possible to avoid packet sniffer to pick up the outcoming connection details?
View 2 RepliesI am new to VB, I am currently trying to make a basic Lottery application for me and a few friends. I have a couple of questions regarding that. Basically the reqs are:
1) we should be able to input for 2 lotteries (super 7 and pick 3) the amount of money spend individually. IN a separate menu Should be able to input the winning numbers for past draws, in a notepad or access.
2) Should be able to see the most picked 3 numbers in the previous draws for both the lotteries.
Question. Say I have menu entries: Lotteries- Pick 3 and Super 7. This is my main form. If I go pick 3, enter last draw numbers should it open up a new form or can I just repaint and work in the same form?
I want to create a simple form with 2 buttons, one to end the program and one to log the user off, I have done this successfully and have everything looking and working as it should. However, I want to force the user to pick one of these buttons before using the machine, my idea was to trap the mouse in the form so the only thing the user can do is select a button. My question is how can I do this?
View 7 RepliesI a very large text document, I need to read some lines and at the end of each line, insert a text from the header of each page to he preceding lines.I have the following code the reads the file and displays it on a list box.Public Class Dialogs..[code]
View 2 RepliesI have been trying to export some datagrids in Silverlight to excel, but have been unsuccesful so far. So now I am just trying to get them to export as a csv file that can then be opened in excel. I have a class created to export the datagrids and it does export and save a csv file. However, the csv file contains no data.
Imports System.IO
Public Class clsExportData
'Public Shared Sub Export(dg As DataGrid)
[Code]....
this is the wrong forum because I am quite new to this :S and I am actually unsure what this fits under. I am using Visual Studio 2008 windows form in .vb so I am taking a guess at it being Visual Basic 6.0Well the question is this. On a form I have 3 Datagrids. The first one shows information about a case including client name and ID. The second shows a table that contains all the jobs registered to the company by the clients. lient can have up to 8 Jobs. The third is a list of all case numbers that clients have
View 4 RepliesI'm looking for a solution to implement in web apps where I have the option to see a print preview or print either a gridview, datagrid, or datatable or export it to word or excel. What's the best method to do this or has someone written a class that does this, and does it well (I've seen many examples, but many still have errors)?
View 1 RepliesI have an aplication using asp.net 2.0 . In this application i dispaly two datagrids with datatable. I want To drag a one row in another grid.
View 5 RepliesI am creating a form application that should display information from one dataset into individual textboxes (ie. system name, system id, location name, location id). The textboxes populate upon the selection of a pair of cascading combo boxes. So, the user first selects a system name from the first combobox, then that selection will populate the second combo box for the locations of that system. (This means that each system may have more than one location.) Once the location is selected, each of the 4 textbox should populate with the corresponding data but I'm not quite sure how to write the code..
[Code]...
How do i fill my ObservableCollection(of Monitors) with data so that I can save it in an MVVM friendly manner. I normally use a FileNumber to load a DataSet using a DataAdapter and pass the monitors table via monitorDT - should I be loading it differently? How do I save the changes? Right now I have the following for loading data:
[Code]...
How do i fill my ObservableCollection(of Monitors) with data so that I can save it in an MVVM friendly manner. I normally use a FileNumber to load a DataSet using a DataAdapter and pass the monitors table via monitorDT - should I be loading it differently? How do I save the changes?Right now I have the following for loading data:
Public Class Monitors
Inherits ObservableCollection(Of Monitor)
Public Shared Function LoadMonitors(ByVal monitorDT As DataTable) As Monitors
[code]....
I have a datagrid that has a checkbox column and it all works fine and dandy except I'm not sure what the proper way to handle this situation is. When I check one or more checkboxes then loop through to find which ones were checked if I didnt move the selected cell before clicking go it will not detect the last checkbox checked. However if I change selection it does. Problem is I dont want to change selection, I tried unsBelow is the code I'm using to find which checkbox is checked. This will msgbox me the text in the second column of all the rows checked except the last one I checked
For
Each
chk_s In
[code]....
I am trying to update a link table with values from multiple datagrids, the field types in the link table are numbers and the value selected from the datagrids are also numbers. I am getting the following error:
The OleDbParameterCollection only accepts non-null OleDbParameter type objects, not String objects.
In line : cmdCompany.Parameters.Add("@COMPANY_ID")
Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|aop29.mdb"
Dim cmdCompany As OleDbCommand
Dim cmdReceiver As OleDbCommand
Dim CompanySQL As String
[Code] .....
Drag & Drop Between 2 Datagrids Between 2 MDI Child Forms Ive been working on this project of mine for some time now... though im not involved in IT in my current company, im just trying to help to at least have their system computerized (they are still doing it manually by paper & calculator)... I have one problem though which made me stick for 2 days (and still counting) without progress... How To Drag & Drop Between 2 Datagrids Between 2 similar MDI Child Forms my apologies, im not that adept in VB.net programming...
View 1 RepliesI am using memorystream to get and store images into sqlserver 2005 table image field. This process is working and I am able to display image in picture box. I need to be able to store PDF files into the same field and be able to display in a picture box.
View 2 RepliesIve been working on this project of mine for some time now... though im not involved in IT in my current company, im just trying to help to at least have their system computerized (they are still doing it manually by paper & calculator)... I have one problem though which made me stick for 2 days (and still counting) without progress...How To Drag & Drop Between 2 Datagrids Between 2 similar MDI Child Forms
View 16 RepliesSee I got a box and in the box is it a textbox and 2 buttons, one of the button is named open (open a txt file) and the second button is add ( add the names in a rich text box) So my idea is, when i got a txt file with full of names like:
Bob
James
Blabla
Duck etc etc
and want to upload by my upload button and when i have done that... so will one of the 4 names i have added appear in the textbox. After... if i click on the add button the name will appear in the richtextbox, and then will textbox refreash and take a new name of the 4 names.
I'm using VB in Visual Studio 2010
When I resize my form at run time (border set to sizeable) .Net automatically adds scroll bars.
I can pick the vertical scroll bar ok but on the horizontal scroll bar it always shows the resize cursor and so I cannot pick it.
Is there some way of controlling the zone within which the resize cursor is active or the active width of the border detection?
Dim rndnumber As Random Dim number As Integer rndnumber = New Random number = rndnumber.Next(1, 1001)Label1.Text = number.ToString
View 1 RepliesHow to pick data from imdb
View 1 RepliesHow can i fetch the value 500 to a variable from the selected row?
One solution would be to get the row position number and then the CustomerID position number.[code]...
I would like to be able to either: (1) Pick a date from the Monthcalendar box and have it insert that day into a textbox showing in a format of Day of week, Month/Day/Year or Day of week, mm dd yyyy. or in option #2 be able to enter in the date by mmddyyyy and get Day of week, mm dd yyyy showing in the textbox.
View 1 RepliesI have this code to pick a random number Between X and Y
X = Minimum Number
Y = Maximum Number
But the problem is i wanted to know if there is a better random function than the one i have.
Because right now i put
Min = 1
Max= 2
and it keeps picking 1
if i had min =1 and max =2 i want it to pick 1 sometimes and 2 sometimes
and now i tried min = 1 max = 3 and it never picks 3, it only picks 1 and 2
ok
Public Class Form1
Public Function RandomNumber(ByVal MinNumber As Integer, ByVal MaxNumber As Integer) As Integer
[Code].....