I used to have a single DataGridView (DGV) on a form. I formatted and populated this, then used DGV.Show to make it appear on my form. This worked fine.I upgraded my form, to included 2 DGVs. Within a sub I dim a new DGV, populate and format it as before then set this equal to whichever DGV on the form it's meant to be. For example:
Dim pDGV as new DataGridView
with pDGV
.ColumnHeadersVisible = True
[code].....
I have a class library with a component class in it. Everything is in VB.NET. It's only one file so you can see it here [url].. On line 92, there is the OnTextChanged Sub. I was thinking about adding ProcessAllLines() (as on line 128) to the end of that Sub, and it worked. However when I was typing in code to the RichTextBox (source which I used is here [url...) after each text change it was checking and processing ALL the lines. So I deleted ProcessAllLines() in the OnTextChanged Sub.[code]...
View 3 RepliesI have an application which connects to a database, retrieves a username from a user's table and matches it against the username retrieved with System.Security.Principal.WindowsIdentity.GetCurrent.Name.On my localhost, everything works fine. The database exists on the development server but the application lies on my localhost. All of my authorization and authentication techniques are running smoothly.However, when I publish my application to the development server, I'm faced with the following error.Cannot open database requested in login 'databaseName'. Login fails.Login failed for user 'DevelopmentServerNameASPNET'.
[Code]...
I have a simple login field, which works fine with the exception of one quirk. The form is set up with the tab order to go to the UserID first and the Password text box second. This works fine when the form is used the first time, but when the form is used the second time the focus in placed in the Password field. If the form is used a third time, focus is moved the OK button, that is each time moves to the next tab order. I even tried to set the focus in the Load event as in Me.txtUserID.Focus(), but this doesn't change the behavior. Again, I should note that I close the form and not hide the form.
View 3 RepliesSQL statements:
SQL = "SHOW TABLES;"
Try
conn.Open()
The remarked area works fine when I'm accessing a specific table. I've successfully inserted the products_model field into the combobox too. The datagridview does show the table names in the db using the SHOW TABLES sql statment, but I'm not understanding how to get this info into the combobox instead.
Changing DataGridView BindingSource at Runtime Works but then Fails When Changed
View 1 RepliesThe VB format(object,formatString) command fails when placed in the handler routines of a DataGridView.In the following procedure the newCellValue returns the Format string value instead of a formatted cell value.This pproblem occurs in both the dgv_CellFormatting and the dgv_CellClick routines.The same commands work properly when placed in a procedure on the form.
Private Sub dgv_CellFormatting(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellFormattingEventArgs) Handles dgv.CellFormatting
If e.FormattingApplied = False And Not e.CellStyle.Format = Nothing Then[code]...........
I Fill a DataTable using a SQLDataAdapter then use a BindingSource as my DataGridViews DataSource. My DataGridView contains a ComboBoxColumn named "Status". There are two ways to update the Status column. One, the user can change the value by clicking a cell in the column then the combobox appears and they make their selection. Second, the user can click a button on the form and the Status for all the visible rows are changed to "Exported". I use a stored procedure as my adapters Update command.
[Code]...
How do you refresh a datagridview in code to show to show new data in the DB?
View 3 RepliesUsing VB Express 2010 in windows XP Pro 64.
A ListBox shows the project forms names.
On ListBox_DoubleClick
For Each F As Form In xFormCollection
[Code]....
Works fine the first time but after closing the form opened by the DC, if I try to open it again, throws an exception "Cannot access a disposed object".
Since I can still access any other form not previously showed I guess that the closing changes a status that allowed the form to be .Show, there is no F.Load , F.Activate after the exception doesn't seem to do anything. What should I do?
i have visual studio ultimate 2010 and i was using visual basic and when i tried the messagebox.show command it does not work , am i missing any libraries that need to be installed or did they change this command , if i am missing some libraries , is there a patch or something that needs to be setup.
View 6 RepliesI am making a picture viewer in vb.net. When I click a button to show images from a listview it does not work without the msgbox! I included code
Sub shows()
Dim k, s As String
Dim i, j, m As Integer
''' When I use this, it doesnt work!!!
'Dim cbz As New Thread(AddressOf shows)
'cbz.Start()
[Code] .....
I'm currently in Logic, Design, and Programming at college and we have homework over Arithmetic Operations.For example:100 ^ 2 - (((43 2) + 17) Mod 5 - 7.4) * 3 = 10,013.2
I need to solve it, we can use VB Express 9 to get the answer but we need to show the work. I've done fine up until the question. We have a test tomorrow and we are have 30/100 points just over math equations where we aren't allowed any use of the PC or calculator and I'm stuck on how to break this down.
[Code]...
Using VB Express 2010 in windows XP Pro 64.
A ListBox shows the project forms names.
On ListBox_DoubleClick
For Each F As Form In xFormCollection
[code].....
I can't figure out why my messageboxs won't work when they encounter errors.Here is my
[Code]...
I have a test app driven by bluetooth serial events In my form load code I hide the cursor so it doesn't get in the way of pictures (fullscreen) When one event is called by bluetooth, it brings up a msgbox and the user has to click OK. I tried Windows.Forms.Cursor.Show() but it doesn't work.
I'm guessing it's something to do with delegates and events and the form, but the debugger doesn't complain at any point. It just refuses to show the cursor. How can I get my serialport event to show the cursor? And then hide it after?
I am trying to put in a datagridview in my program, and when I add the connectionMiscrosoft SQL Server Database File as the data sourceand i have a .mdf file for the database..when I click OK it says it couldn't login my computer account, i tried putting my login name and password, and it still didnt work.
View 1 RepliesI have a datagridview to show the database data in order to let the user view the data. But i am thinking of adding a checkbox column to the datagridview and when the user selects on the checkbox in the datagridview on a particular row, he can actually delete that row when he checks the msgbox are you sure you want to delete this?
I am also not sure on how to provide the provision for user updating through the datagridview. If he can update through the datagrid view and press the save button, and the database is updated, it would be better.
Currently i wrote the code for the inserting of data already . But i am stuck at the deleting and updating of data through datagrid view. the below is my code for inserting of data
[code...]
Possible Duplicate: Datagridview doesnt work! I have written code to show records in a datagridview but it shows nothing. I have tried to debug & when it step into GetData function following codes
Catch ex As Exception
returnData = Nothing
If connection.State = ConnectionState.Open Then
connection.Close()
End If
become gray & it shows error sign. When I take my mouse pointer on it it shows message. It says "Cannot open database SUIMT requested by the login. The login failed. Login failed for user 'MY-PCJames'".
Imports System.Data.SqlClient
Public Class Form34
Private Const ConnectionString As String = "Server=.SQLEXPRESS;" & _
"Database=SUIMT;Trusted_Connection=True"
[code]....
Visual Studio 2010 VB.NET
I have a DataGridView.DataSource set to a Collection of custom objects. The columns use read only properties from the custom object for display, this dialog is for display only. The properties all return String objects. I set the columns all but 2 of them to sortmode automatic (the ones that are not set is a button or a checkbox). Yet it does not sort. I have googled around and most people use sql or binding sources but I am using a trivial vb collection. Some say I should implement IComparable but isn't String already IComparable?
Per a request here are some code snippets.
This method defines the columns in detail from columns I designed in the designer.
The column names are called pSelected or pCustomer and corresponds with a property by the same name that the column definition ties to.
Protected Sub UpdateDGVUS()
If Not USColumnsInitted Then
USColumnsInitted = True
[Code]....
I'm trying to align datagridview columns at once to middlecenter. It works for the first column and does not for the others. I suspect it's a matter of the datasource property which is bind to a datatable which catches data from a SQL Server table. Below is my simple code and I thought that after this code runs I would have every column aligned to middlecenter:
[Code]...
Private Sub dgvfeljegyz_CellParsing(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellParsingEventArgs) Handles dgvfeljegyz.CellParsing
'dátumellenőrzés
[code]....
I am beginning to work with .NET technology after several years of VB6 and C++ and I want to learn as fast as possible.
My problem is with a DGV. It shows the prices of several store items, and I intend to let the user modify those prices by entering a % in a textbox (radio button states if that % is positive or negative) or by editing cell by cell manually.
As editing prices is kind of sensitive, what I do is loop through the DGV, add or substract the % engtered in the corresponding column and ask for a confirmation after whole DGV loop is done. If user agrees, DB is updated with new values. No problem here.
If user denies (in case he/she made a mistake), I restore grid's DataSource to a copy I made before calculating new percentages and this automatically refreshes my grid to its original state.
The issue is that if a user denies the operation for a 2nd time, this 2nd execution of the code fails at showing the original values, disabling the pseudo-rollback function.
Here is the code:
.
.
.
If MessageBox.Show(mensaje, "Actualizo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) = DialogResult.Yes Then
[Code]...
remember this works OK if user denis once. What am I missing regarding DataSources or its Tables? Is there anything like .Redraw?
Btw, I tried update, refresh and I also used a sleep function (this helped me a few times back in VB6...).
I have a DataGridView bound to a list of business objects:
Dim template As New IncidentTemplate
Dim temps As List(Of IncidentTemplate) = template.LoadAll
Dim bs As New BindingSource
[code].....
I'm creating a program for a bookstore & I'd like to create an "inventory table" using the DataGridView function. I've created a form with 2 tabs for the bookstore clerk. I'd like to have a new row created once the information for a new book is entered.[code]
View 8 RepliesI' newbie and i dont understand why this won't work TableName is String "Tab"DataGridMain is name of DataGridView.[code]
View 5 RepliesI am working with a datagridview and checkboxes. Ok, I have the following code which runs without any errors but doesnt give the required results.
1) My problem is that, when I uncheck the checkbox in Cell 2, I want Cell 9 and Cell 6 to be empty.
2) When I uncheck the checkbox in Cell 2 and click any other Cell in the datagridview and check again checkbox in Cell 2 - it DELETES the data in Cell 9 & 6.
Now, when I check again the checkbox in Cell 2, Data is not populated in Cell 9 & 6 regardless how many times I try....
[Code]...
I have a datagridview with 4 columns (bound to a datasource).The following code ensures only numbers can be typed in the first column, all but numbers in the 2nd column, and only letters in the 3rd and 4th cooumn. It also converts the input in column 3 and 4 to capital letters.
Private Sub validatekeypress0(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyPressEventArgs)
If Asc(e.KeyChar) <> 13 AndAlso Asc(e.KeyChar) <> 8 AndAlso Not IsNumeric(e.KeyChar) Then
e.Handled = True
[code]...
The problem I have is that the user still has the possibility to place restricted characters in a column by pasting them in (with ctrl+v or right click-->paste), because the keypress doesn't notice the pasting.What should I do to make it impossible for the user to use restricted characters? In other words, how can i check the text the user wants to paste in a cell (cause that's the only other way to input data I can imagine)
Basically I try to get a DataGridView and a BindingSource working inside a class. I define them by:
Dim TempDGV3 As DataGridView = New DataGridView
Dim TestBinding As BindingSource = New BindingSource
When I manually add columns to the DataGridView, it works perfectly, but when I set it's DataSource to a bindingsource from a base class, it doesn't load data and keeps throwing 'object does not exist' errors. The bindingsource mentioned here did, however, work on other DataGridViews that are defined in the base class (and implemented in the form to which the base class belongs)
Same for the BindingSource(not the above mentioned, but the one I try to create inside the class in the beginning of this post). I try to use it in the following way:
TestBinding.DataSource = TempDGV3
TestBinding.Filter = filterString()
SourceDataGridView.DataSource = TestBinding
But the BindingSource keeps returning 'Nothing' for it's datasource and basically doesn't work. However, the SourceDataGridView mentioned here gets filled with 63 columns with "AllowUserToAddRows" and other properties when the columns names are asked.
So my question is: how do I get the BindingSource and the DataGridView to work in this class? I'm getting the feeling I'm missing out on something very obviously here. If that's not the case, I can report back with more code?
I have a datagridview that takes time when loading, and once loaded, is also very slow when using the scroll bar to see the other rows.[code]..
View 12 Replies