I have the following code, what it should do it write 98 columns down and 15 columns across.but what it seems to be doing to just writing into the 1st column over and over again.
Dim TBF_IST_Min As DataTable = TBF_Dataset.Tables.Add("TBF Minutes")
' Add columns to the TBF_IST_Min table.
TBF_IST_Min.Columns.Add("0-2", GetType(Integer))
TBF_IST_Min.Columns.Add("2-3", GetType(Integer))
[code]....
I have a few classes, one is a form, the other is the source of the datagridview. I want to be able to sort the columns of the datagridview by clicking on the header. Here are the classes that I am dealing with:
Imports DiscoveryByte.AddTools.Misc_Tools
Public Class ViewDiscoveryFlashCards
Private DBBindingSource As New BindingSource
[code].....
I have a 2d array of data that I have performed the sum of the individual column of the 2d array. I want to send the results to a datagridview and also will like to have the result as a 1d or 2d array.
Below is sample of my code
Dim Array1(,) as double
Array1(0, 0) = 5
Array1(0, 1) = 7
[code].....
I am trying to create a array and then add elements to it based on some conditions and then add the elements in the array and display it...
but i am getting a larger number that expected..
this is my code
Dim IBNRTotal as decimal
dim element as integer
dim totals(6) as decimal -- create a array3
[Code]....
i know the amt value correct cause in return amt.. i am seeing the right value but somehow when it goes to the array and when i add the whole thing it doesnt seems right...
I have the following array
Dim items() = {
New CheckedListBoxItem("NYC", False),
New CheckedListBoxItem("CHI", False),
New CheckedListBoxItem("PHL", False),
New CheckedListBoxItem("SFO", False),
}
I am trying to query against it like this
Try
Dim item As CheckedListBoxItem = items.ToList().Where(Function(x) x.Value = "PHL")
MsgBox(item.Value)
Catch ex As Exception
MsgBox(ex.Message)
End Try
I am getting the error
Value cannot be null.
Parameter name: source
I also tried
Dim item As CheckedListBoxItem = items.FirstOrDefault(Function(x) x.Value.ToString() = "PHL")
I just need to query against the list to get an item and change it's checkedstate from false to true.
I am trying to declare a array within a structure, and it is not working. [code] So I want each league to have a single name and id and 20 players.Is there a way other than writing out dim player1, player2 etc.
View 3 RepliesDim asd As String() = TextBox3.Text.Split(vbNewLine)
Dim asd1 As String() = TextBox1.Text.Split(vbNewLine)
Dim asd2 As String() = TextBox2.Text.Split(vbNewLine)
Dim count As Integer
[code]....
i need to remove the vbnewlines from the array but its not working, the array populates by braking multiline textsbox's up from vbnewline but seems to keep the newlines.
[Code]...
I have an array with about 10 items in it. In order to get the desired functionality I need to append some text to each item in the array in order to sort it properly. Once it is sorted I want to remove the text I added and then just display the second half of each item in the array. The sort works great, but the split function is not worrk.
[Code]...
I can edit values on the DataGridView and as long as the program is running it is there exit the program and restart the program and return to the DataGridView and all changes are gone. I know there has been a lot of posts on this subject and I have read many of them but nobody seems to be using SqlClientCE for the data base and I need instructions of how to make a table adapter say like the following do the trick.[code]...
View 1 Repliesi got problem while saved the record.here is my code.
Imports System.Data.OleDb
Imports System.Data
Imports System.Configuration
Public Class Form2
[code]....
Private Sub DataGridView1_CellClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellClick
If e.ColumnIndex <> 3 Then
Exit Sub
[code]....
I am using the CellClick event to update DB column PaidStatus from Paid to Un-Paid and vice-versa....Once updated i want the updated data to be reflected..i am using DataGridView1.Refresh()....but it does not show the updated data from the DB..i have to close the application and re launch it to see the changes.
[ VB.NET 2008 ]
I'm facing new problem that MaxInputLength is not working in my code, my code is here.
I have set 12 for NQty . New Row allows only 12 chars but already existing rows are allowing more than 12.. so here maxinput lengh not working
i have set 7 for N1 Qty but it allows 7 chars for already existing and new rows because i did not assign any values to that column..
Private Sub Load_Grid()
With DataGridView1
.Columns.Clear()
[Code]....
I have a form with a button and a tabcontrol that has 2 tabs, on each tab I have 1 datagridview in them
both datagridviews are bound in the load event to a different bindingsource each.
When I click the button I fill the datatables programatically, and set some cells and columns on the datagridview to readonly.
The columns are set to readonly on both grids, but the cells are not. Only the cells in the first datagridview are being set to readonly and the cell on the second grid are not.
Further info:
If before clicking the button i switch to the second tabpage on the tabcontrol, and click the second grid on a column, and then go back to the first tabpage, the readonly cells are set fine when I click the button
If I press the button a second time, the readonly cells are set on both grids are set fine.
It seems to me that this error is presented on non-active (in lack of a better name) datagridviews.
I have tried, to call update, refresh, focus, endedit, etc etc on the click event of the button for the second grid but nothing seems to make it work.
I have found a lot of examples of this kind of thing on the web but cannot get one that works - basically i am serializing to a byte array and want to store it in a string i have tried all of the System.Text.** (ASCIIEncoding,UTF32Encoding,UTF7Encoding and UTF8Encoding) in the following way:
[Code]...
I'm writing a program that reads a directory of xml files (not well-formed), parses the xml, and dumps the data into an Excel Workbook.The file contents are similar in that they have many common xml nodes/attributes.Some files have additional nodes/attributes.The xml in these files represent configuration settings for a Web Application, one file per user.The expected output is a worksheet with a column for each node/attribute combination and a row of node/attribute values for each user.I'm just about finished with the program, but I've run into a bit of a snag.As the final step in the process, I need to loop through a generic list of array objects (that represent a user row) and send the array elements to Excel.I don't know the correct syntax to get the array objects out of the list and have been unable to find sample code specific to generic lists of array objects.[code]
View 3 RepliesI have an unbound checkbox in my datagrid view along with other bound fields from a dataset. I do not need to send back the checkbox status to my dataset or the DB. Instead I will loop though the DGV and look for those checked and do another process with them after its done being loaded. The problem is this. When I check a checkbox, then check another, the first one goes back to unchecked and so forth, back and forth. There is no add, update or deletes needed for this DGV.
[Code]...
i have a windows forms app which displays a bunch of records from my sql database. when i modify records in the grid and click on save, all changes are saved EXCEPT the changes made to the currently highlighted row. they aren't written out the database until i exit the actual program, despite clicking on my save button.so for example, if i change 5 different records in the grid, and click on save, and then click on refresh to reload the data from the database, 4 out of the 5 are saved correctly, but the row that is currently highlighted (meaning, the last row i changed) still has the old data.My code for the save button look like:
Code:
Private Sub TerritoryBindingNavigatorSaveItem_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TerritoryBindingNavigatorSaveItem.Click
[code]....
I'm using vb 2005, seems sorting is not working if I change the data by code. For example, if I have a simple form with only one datagridview and one button, grid was sorted on column 1, then I press the button to randomly change data in column 2, then use column 2 to sort, the display order is not correct, but after the button click, if I click on a cell, the grid will re-sort by itself, and get the right list. I know DataGridView is not for Editing data...
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim dt As New DataTable
dt.Columns.Add("C1")
[Code] .....
Datagridview With Access - The Delete Is Not Working
View 3 RepliesI can't understand is it VB 2008 bug or I am doing something wrong.But code like:
if datagridview1.CurrentRow.IsNewRow=true then msgbox "That is new row!"
I want to delete rows in datagridview by clicking button. Have found on some sites code like:
[Code]...
But if CurrentCell is on new row and I click to delete row - it's deleting that row that is standing before current selected cell. It means that dgv.CurrentRow.IsNewRow is not showing is realy currentRow new or not! But why? Old VB version? I am using VB Professional 2008
Dim cv As Integer
Dim cc As Integer
Dim CurrentValue As Double
Dim ObsoleteValue As Double
[code]....
Basically this code works for the first column of the DataGridView. It sort of stops iterating after the last calculation of the row is performed and doesn't change the cc value at all. Meaning the loop gets stuck after the first iteration.
I've been trying to get the update method to work on a DataGridView for the past 2 days and I just can't get it to happen!I'm using a "Save Button" to invoke the update and no errors are thrown but the table is not updated when the save button is pressed.
Private Sub Main_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
With NodesDataGridView.ColumnHeadersDefaultCellStyle
.Alignment = DataGridViewContentAlignment.MiddleCenter
[code]....
I have some code written by another developer(no, really). The datagridview has the AllowUserToResizeColumns property set to true, but at runtime the grid will not allow column resizing. I've checked the code to see if the property is being set in code and I can't find anything. Is there some other grid property that, if set to a certain value, will disable column resizing?
View 2 RepliesI am trying to update my DGV with the following code. i have generated SQL update command in the tableadapter. but still the changes are not affecting the DB.
[Code]...
I am not sure whether it is possible or not? need suggestion.I want to display filenames from 2 different folders into 2 different DataGridview controls that are placed in 2 tab pages of TabControl1. Here is the code that I have tried. By running this code, I can able to show the filenames from a folder onto DataGridView1 in Tabpage1 but not in DataGridView2 of tabpage2.
[Code]...
Private Sub dgvTransactions_CellContentClick(sender As Object, e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dgvTransactions.CellContentClick
If e.ColumnIndex = 0 Then
[code]....
I've used DataAnnotations attribute DisplayName successfully using MVC model binding, and even with WPF/Silverlight model binding and of course it works just fine, but now I'm on a project that I'm forced to use VB.NET 3.5 WinForms.
I have a Linq2Sql model and I created a partial class for one of my classes and included a MetadataType attribute to point to a metadata class. I added a DisplayName attribute to a property in the metadata class. I then bind my datagridview with an IQueryable(Of mydatatype), but the column name in the grid is the Property's name and not the DisplayName.
Am I missing something? Is there something else I need to do to get the datagridview to use the DisplayName?
In my Model class:
Imports System.ComponentModel
Imports System.ComponentModel.DataAnnotations
<MetadataType(GetType(vwREVIEW_ECRMetadata))> _
[Code]....
In my application I am selecting a folder path and then asking the user if he/she wants to display full path or file names only.
My problem arises when I want to insert the results in a datagridview. The datagridview has 2 columns:
column1 ----> shows file name
column2 ----> shows file size in MB.
with the below code I get the file name and then the file size on the same column one after the other
I want to show as follows:
File Name Size (MB)
sample.txt 1.2
myspreadsheet.xls 0.6
Seanie.bmp 0.8
What do I need to modify in order to achieve this?
Code:
What is the proper way of working with percentages and DataGridView and dividing by zero..In my code I am attempting to divide two numbers, sometimes one of the numbers is zero..Then I need to add a column to my datagrid, I think i need it to be decimal? So i can sort it later. I had it as a string and everything worked fine excpet i couldnt sort properly.[code]If I change column to Double it handles it fine, then i am not sure how to read the value as a percentage?
View 12 Replies
