i have used the following code to bind the data from an access database using datagrid in vb.net 2003. But when i execute, it is showing the error as " Object reference not set to an instance of an object". Can anybody guide me to find the error i have done.
[Code]...
can data reader be used as a data source for a grid control?
View 5 RepliesI have a form allowing user to search details of employees. the form allows users to key in 7 search criteria. the results of this search open in a new window. employee details (data) are of following 3 types: personal details contact details additional details
I want to achieve the following with the results window the new window that opens to show the search results has a tab control with 3 tabs for displaying the results for each of the above categories. hence the three tabs would be personal details contact details additional details each tab would display the required data in a datagridview control. on adding the datagridview directly to the tabpages of the tabcontrol the window does not resize to the size of the datagridview that is displayed. i understand that the property AutoResize is not applicable to a tabcontrol or a tabpage, hence 1 added a panel to each of the tabpages and then added the datagridview to it.
However, even this does not help and the results window is still does not resize to the size of the datagrdiview. i have set the AutoScroll property of all the tabpages to, AutoResize of the datagridview and results window all to True. How to do this as the results widow does not rezise even to the size of the tabcontrol that i have added and the tabcontrol ends up with scroll bttons in the window.
I need to restrict the user to enter only integer value in a particular columns in a Data Grid View. How to do this?I tried with "KeyPress", "KeyDown" & "KeyUp" events. But not succeeded. But the same worked well in a text box. (http://msdn.microsoft.com/en-us/library/system.windows.forms.control.keypress.aspx)
How to do the same for a cell in data grid view?
i m using excess database to create my project..But i stuck when i wanted to render a combo box and a button in my data grid view...means i wan every data row have it owns delete button and etc.
View 1 Repliesi am having sum textboxes and combos which have been populated accordingly. as in the attchment i enter the data in the textboxes/select values 4m combo and when click on save button all the related text is added to the datagridview's respective col. as desired. the problem is now that if suppose a user enters a wrong data and wants to edit/update the record already added the he will select the desired record from datagrid, double click and all the related data appears again on the combos and textboxes. the user then edits and click on save so that the selected record gets updated
[Code]...
I am using VB 2008...
On my form I have a "Combobox1" that pulls a list from an access table. I also have a "DataGridView1" that pulls data from another access table.
I am trying to set the "DataSource" property of the "DataGridView1" after clicking a button, which pulls the "Text" property from the "ComboBox1".
ComboBox1.Text will always equal DataGridView1.DataSource as a text string.
I researched the Get/Set command, but it does not make sense to my specific application. I have read countless articles online for weeks, but I have now taken the next step.
I am student of MCS and i am working on my final project i face some problems regarding to show cubes data in grid control in vb.net around with dimensions
View 1 RepliesI'm looking to see if anyone has a sample app or has a link to such an app that uses data binding with a grid control and textboxes and is able to insert, change and delete from a datatable which gets updated to a sql server database.I have done an app that has the grid control and the textboxes already and is able to change and delete from the datatable and that action is reflected in the grid control because it has the datatable as the binding source.
The problem I'm having is when the user tries to insert into the datatable I get a concurrency violation error when using the .Update statement to save the changes to the database. This is happening because I don't know exactly how to get those inserts synchronised correcly.I'm sure I'm also doing the processing wrong but here is what I'm doing.When the user clicks an insert button I insert a new row into the datatable. The user now has the ability to enter text into the textboxes. When the user is finished doing that the user can click the save button which issues a .Update statement. That's where the error is displayed
This is a VB .NET application where we are showing the output of a SQL statement in a Datagrid view. using .NET 2005.We need to get the seperators of the headers on the grid control to be the same colors as the GridColor on the form. See the picture below:We've tried looking through all of the properties of the DataGridView control, and found some interesting things that looked promising such as the DataGridViewAdvancedHeaderStyle, and DataGridViewHeaderBorderStyle, but none of it seems to allow you to change the colors on it.Does anyone know how to do this without remaking the entire thing with a GDI+ control?
View 2 RepliesIs there a way to automatically put a Data Grid Row Column in a data Grid?[code]...
View 5 RepliesI have the below code that i am trying to have two datagrids with a grid splityter in the middle. The split seems to be working fine but the issue i am having is when I populate the datagrid it is growing in height and changing the splitter instead of leaving the height alone and adding scroll bars.
What simple thing am I overlooking?
<Grid x:Name="gdHistory" Grid.Column="0" Grid.Row="2" >
<Grid.RowDefinitions>
[code].....
I have a FlexGrid control in my Windows application that contains a row of data. The data in this row is related to even more data that won't all fit on the same row. For Example:The main data row contains Username, Last Name, First Name, Middle Name, E-mail Address, Phone Number, etcA secondary row to this might contain user permissions to certain resources, such as File Server Access, FTP Access, Remote Access, etc.Now, I can use the subtotal and outline capabilities of the VSFlexGrid to make a second row, but the column widths are still bound by those set for the main data row. Additionally, I can't put real "headers" on the supplemental data. I have to fake it by creating an additional row, setting the background color of that row to gray, putting the header strings into those fields, and then adding the next row with the actual details.
What I would like to do is create separate grids for these secondary rows and "embed" them in a blank row of the existing FlexGrid control directly under the related main data row. This would give me the ability to use a different number of columns, to format these columns independently of the "parent" FlexGrid settings, as well as put a new header row for the new grid that identifies its data.In other words, I'd like to somehow make a "child" grid that's related to a particular row of the "parent" grid (not the entire grid itself). I don't know if this is possible, and if there is another way for me to accomplish this goal, I'm all ears. However, if it IS possible, I'd love some advice on how to implement it.
I have a problem with importing an excel into a data grid.
Here is my code:
Try
Dim _Obj As New ExcelConnection.ExcelConnection
_Obj.ImportAttendence("c:Info_pc.xls", DataGrid1)
Catch ex As Exception
End Try
In the excel i have numers and text and "Service Pack", "Processor Speed" and "Numar procesoare(Number of processors)" and the values for these are numers. in the data grid when i import the excel those values doesn't appear, i receive the value "null".
I have 1 datagridview and i want to transfer all records to another datagridview, how can i possibly do that. Newbie here. This is my code in transferring 1 record to another datagridview to another one.
[Code]...
how to cambine 2 data grid view into 1 data grid view
View 2 RepliesI just want to display data in a DataGridView (from SQL - already made the connection) based on what is selected in a ComboBox (data that is also coming from SQL). The 2 are separete on the form. I am using VB 2010.
This doesn't work for me:
objCommand2.CommandText = "SELECT ProductID, Name, Color, Size, ListPrice FROM SalesLT.Product WHERE ProductCategoryID = " & cbCategory.SelectedValue
[code].....
The control comes up blank??Imports System.Data Imports System.Data.OleDb Public Class Form1
[Code]...
I'm trying to create a simple Data Grid that will automatically save changes. So far I have a data grid connected to a MS Access 2007 Database that reads the data. I can create new fields in the Data Grid, but I need to program to save the data automatically to the database on update (or on close).
View 6 RepliesI have an excel file that I would like to load into my form and display there.
View 1 Replieshow to display data in grid view using code that you can edit, update and delete the data...do i need to have a stored proc in this?
View 4 RepliesAre there any good free alternatives to DevExpress data grids (WinForms)?I am looking for WinForms Data Grid and Data Editor Controls.
View 1 RepliesData binding should be an extremely simple thing to manage but I can't find a SIMPLE solution to the following problem.
I have two forms
Form1 contains a 4x4 MSFlexGrid (unfortunately an unmanaged COM object but I can merge cells, which I can't do with a managed Datagrid)
Form2 contains other controls which change the data in the Flexgrid.
I connect the two with a Public 4x4 array. Form2 changes the data in this array. I can update the grid data by reading the array. But how do I bind the Grid to the array so that it auto-updates - which is the whole point of binding isn't it?
I am trying to pass a different template to a Telerik Grid, depending on if the add button or the edit button is pressed (on creation: a few field to fill. on existing: add button : some extra fields to fill, edit button : most field are read-only, new field to fill).
Dim myGrid = Html.Telerik().Grid(Of SomeModel) _
.Name("myGrid")
If Model.Action = AddNewData Then
myGrid.Editable(Sub(editing) _
[code]....
I have no idea on how to do the if "gridBoutonPushed = Add" then part.
I have a datagridview which have 5 columns. The name of the columns are T,C,F,S,H. [cod]e...
So i want to display this data in datagried view. I must display the number beside T to T column, the number beside C to C column and so on. It should only display number in the respective column. It should not display the T,C and so on. [code]...
i have a form which search data in specific date and show result in the datagridview, what i want is that when delete button is clicked all datas that in the datagridview will be deleted sameway in the database
View 3 Repliesi have a problem with the sales transaction. i need to show all the product purchase and i need to show it on the data grid but everytime i input a product it keeps on replacing the data i entered. need code for adding data in the rows of data grid.
View 1 RepliesI'm using a mysql as my backend database and i'm using the mysqldata adapter for binding the data, i have my data in the database, but the problem is i don't know how to retrieve it, for example when i want to add a record, before i add that record, i want to retrieve the data in my database to trap that the record i'm adding is an existing record
View 11 RepliesInstead of computing the result for each value of variables in combo boxes 1 & 2 separately. I want to compute the result for all the values of variables in both the combo boxes. This whole collection of computations is to be displayed in the Data Grid View, while on top of each column I want combo boxes with the same values as combo box 1 & 2, to optimize the selection from Data Grid View.
[Code]...
I have a data grid view on a FrmItem Form, data grid fill with table item master and item master have 1 lack item. when user click on item text box then FrmItem Form call and when user choose any item then FrmItem form close and it return item code.The problem is every time when user press any key on Item text box, Frmitem load 1 lack item which takes a lot of time around 10 second.So i want Data grid fill when i start application and use that Data grid on the Frmitem form.data grid is already loaded and its not take more time. may be its show with in seconds.
View 4 Replies
