im currently developing a system. it's a tracking system and an alpha list..now currently im using datagrid to view thousands of records in foxpro free table in my vb form, how to export the datagrid into an excel for reporting but there is none..
View 8 RepliesIhave been looking for two days, and have not been able to place an msflexgrid or an mshflexgrid on my program. Any ideas what I must be missing? I am using vb in vs 2008 pro. Just building a simple windows form application
View 2 RepliesI just used MsFlex grid In my vb.net project. Its working in XP, but shot showing error in windows 7. error message like dll not found. But msflexgrid dll file included correctly.Still the same problem.
View 1 Repliesi have a textbox,flexgrid and a button. this is my problem. when i input data in the textbox, the data will be added to the flexgrid using textmatrix. and if i click the command button. the data on the flexgrid will be registered to the sql table.however, if there's two or more data (different data) on the flexgrid. the data will be registered to the mysql but the data is same with each other.
the input is :
1st row: (3500)
2nd row: (2000)
3rd row: (1000)
but the output (in the sql table) is this.
1st row: (3500)
2nd row: (3500)
3rd row: (3500)
this is my code in the command button.conn.Execute "INSERT INTO tbl_purchaseDetails(Quantity) VALUES('" & gridpr.TextMatrix(gridpr.RowSel, 0) & "')"..BTW i am using navicat to connect my sql.
I want to upgrade MSFlexGrid to .net datagridview,what is equivalent code for these code? With gridview
If .Row > .FixedRows Then
bDoNotEdit = True
.Row = .Row - 1[code]....
In my application (VB2008),I am using MS flex grid and it was workingfine on 32bit mode. When I tried to compile the same code base in 64 bit ,it crashes the application.
View 2 RepliesI am porting a vb6 application to VB.net. One of the key forms has a large msflexgrid on it - about a 1000 columns and 50 rows. It has 2 header rows - the first header row has merged cells to form a main header and the second row has sub headings. There is no requirement for any data entry and it's unbound. The code does the work in deciding what to display (if anything) in each cell. It is solely used to display data in the form of a character and a coloured background and to display a tooltip text with more information when you mouse over it. Works beautifully in vb6. I'm trying to decide whether to:
a) use the vb6 msflexgrid in the .net version
b) use the datagridview - which at a first glance seems to have a problem merging the cells on the header row
c) build my own custom control to do the job
I have a VB project that is converted from VB6 to VB.NET.In this, I have a MSFlexGrid that is used as an interop compatibiliy. That means it is somewhat converted to .NET, but internally, many of the mechanisms are still from VB6/COM.I need to drag an image from a PictureBox (which is .NET) and drop it on the flexgrid.
This is what I do to initialize the drag:
Private Sub picStartSymbol_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles picStartSymbol.MouseDown
picStartSymbol.DoDragDrop(picStartSymbol.Image, DragDropEffects.Copy)
End Sub
[Code]...
I am using the following code and I am able to create a new WORD Document and create a Table inside it and insert data into it sucessfully from a MSFLEXGRID (just like a datagrid) on my form. I would appreciate if anyone could tell me how to achieve the same but by inserting the data into a specific document saved as ("c:123.doc") with a table already created inside it.
I just don't want to create a new word file everytime and then create a table and then do the insert.I want to keep my 123.doc with a formatted table inside it and all i need is to insert data from the Grid into it.
Dim oWord As Object
Dim oDoc As Object
Dim oTable As Object
Dim oSelection As Object
[code]....
When trying to edit an exisiting or trying to create a new dialog with a MSFlexGrid I get the following error
The ActiveX control "Microsoft FlexGrid Control, version 6.0" could not be instantiated because it requires a design-time license.
Any one know how to get a "design-time license" for the MSFlexGrid control.
I have a fixed-size pane for displaying MSFlexGrid rows, and, when the number of rows exceeds the pane capacity, a vertical scroll bar is displayed. If the user scolls downward, and selects a lower row for action, I want the display to be restored (approximately) after the grid is reloaded.row selection is maintained explicitly by code: If the action is a change in row data, the successor row will be selected (by code); if the action is row deletion, the preceeding row will be selected (by code). Since the grid must be reloaded following the change, MSFlexGrid will present the first n rows by default. (The grid must be reloaded because the actions may have affected the presentation order.)How can I force a scrolling repositioning after a grid reload? In my imagination I see a sequence somewhat like make-non-visible, reload-grid, set-scroll-position, make-visible, set-new-row-selection. Is something like this easily done?
View 3 RepliesI'm at the Studio 2008 stage in migrating from VB6 to Studio 2010. My application appears to run OK for the most part, but my MSFlexGrid display's single column is just 8 or 10 characters wide -- it should span the entire grid display (i.e., have the same width as the grid).The Studio 2008-Upgraded code sets several grid properties correctly, but the statement ".ColWidth(0) = .Width" (in the scope of a With block) causes an error. So does the statement ".TextMatrix(0, 0) = string".
Not only are these properties not included in the upgraded control (now identified as AxMSFlexGrid), but some column-related properties are greyed out in the properties list. My grid size was set originally by cursor drag, and the present .Size sub-properties of .Width and .Height are set to the numbers 593 and 329, respectively. (My form has a fixed size and is user-moveable but not user resizable.)
I have a datagridview with transaction bindingsource I want the datagrid to show the sorted rows only not all the records when i enter a value into a textbox and click button sort.
View 1 RepliesWhat I am trying to do basically is open an access query in a datagrid view and then be able to make changes to the datagrid and then save it back to the database.When I try to save:
Me.BindingSource.EndEdit()
Me.TableAdapter.Update(DataSet)
It says that update is not a member of the tableadapter... Why is that?
now i use acces as datasource to view the agenda in a datagrid and a combo box to select a year or month so i can find the selected month or year in the datagrid .how do i program it so that it searches the selected year or month in a datagrid
View 2 RepliesI have a datagrid who's ItemsSource is a strongly typed IEnumerable object In this datagrid, I have a checkbox column, a price column, a part name column, and a 'total selling for' column. On checking the checkbox I need to update the total selling for column with the value in the price column. This part I have working, however, how can I get the checkbox to remain checked when this happens?
Private Sub UpdateSellFor(sender As System.Object, e As System.Windows.RoutedEventArgs)
Dim _CB As CheckBox = DirectCast(sender, CheckBox)
Dim _ID As Integer = _CB.Tag
Dim _PP = DirectCast(DG_PartsToSelect.CurrentItem, PartTyping).PartPrice
[code]....
I placed a datagrid in my form which l retrive data from my sql. i am using oledb connection. if i run the form i can retrive the data but i am not getting the data in the grid at first ,there is a "+" sign, i have to clik that then it shows the table name and after clicking the table name i can view the data displays in the grid..
View 1 RepliesI have a datagrid which I am using LINQ to fill, I then add some custom columns and fill them in programmatically - if the users clicks on the column header to re-sort, all the data in the added columns disappears. I am obviously missing something very basic here but can't seem to see the forest for the trees. I also have a couple of other questions about how I am doing things:
[Code]...
I am trying to create an xml editor that read and write xml. my code reads the xml with no problem and allows me to create new rows but when I try to "write" it over I get the following error: "Token StartElement in state Epilog would result in an invalid XML document"
here is my xml:
<?xml version="1.0" standalone="yes"?>
<MacroList identifier="test">
[code].....
I decided to rewrite my project. Hit another snag. How do I write the contents from a datagrid to a file and back into the datagrid again later? (Actually, I've done the writing ok - but for the life of me can't get the data back into a blank datagrid.
Here's what I done so far:
Imports System
Imports System.IO
Imports System.Text
[Code]....
how to do cursor moving from one grid it effect to another grid.example Grid A and Grid B have the same number of rows. when I click current row on data grid A, the selected row on data Grid B also follow data grid A..
View 1 RepliesI am printing a files that are shown in datagrid.. But I want to choose a file that I don't want to print by checking the checkbox that I added in datagrid..
I have here the code for printing.. Anyone can edit my code that will print those file that is not checked.
Code:
Try
openMySQL()
Dim sql = "DROP TABLE IF EXISTS dummydisconnectionorder"
[Code].....
I have on my form two datagridviews that correspond to the same table. They are both databound. They have been created automatically through dragging them from the datasources windows.One is datagridview and the other datagridview1. When ever I navigate through a datagrid the corresponding row on the other grid changes as well. I do not want this. Also I want to be able to fill and use each datagrid indepentent from each other. To fill a datagridview on load I use this code
Me.AllServicesTableAdapter.workstation(Me.Database2DataSet.AllServices)This code does not let me choose which datagrid to fill.
I have a search form on that will be pulling search template queries from a table in the underlying (an Access db on a share). The search form has a calendar control for filtering by date range, a listbox containing the names of the search templates, a second listbox which lists the fields in the selected template, and then some controls which show/hide themselves depending on which field is selected so that the user can pick a field and enter it's unique criteria in the appropriate control for filtering. Below these controls is a DataGrid, which will obviously display the results.
The problem is how to dynamically "transform" this DataGrid to display the selected search template. These templates do not represent tables in the underlying; rather they represent preconstructed SQL queries (stored in a table) which are essentially SELECT queries with joins and no WHERE clause (so they are the results of multiple tables joined together by their keys).
To be honest, I'm having trouble even generating the LINQ queries to represent these template dynamically, but that's not as important, since I can manually translate the SQL queries into LINQ. This is definitely not the preferred method, as the whole point of putting these templates in a table, rather than code, was to allow for future additions without rebuilding/redistributing the application interface.
what are the differences between the WPF Datagrid included in the .NET Framework 4.0 versus the Datagrid included in the out-of-band WPF Toolkit? I understand that the toolkit version was released first, and targets the .NET Framework 3.5 SP1.
I needed a WPF datagrid quick and have utilized the toolkit version in my applications. I'm considering moving the application to .NET 4.0 and am wondering what the pros/cons will be in changing out my existing datagrids for the new ones.
I have one data grid which contains a column which contains long string values. When I edit it, the text box which appears is very small. I want to increase the length of text box.
View 2 RepliesI am just trying to put an item into a datagrid from another datagrid.
So I got code like this which takes the right item but puts it into the wrong place. It is suppose to put it into Rows(0).Cells.Item(3) but it puts it into item(2) as it caunts from 0 to 3. If i try to put it into Rows(0).Cells.Item(4) I get an error - indexOutofRange.
DataGridCLI.Rows(0).Cells.Item(3).Value = datagridorder.Rows(0).Cells.Item(2).Value
I have searched alot but can only find info on moving entire rows bound between 2 datagrids, but noting on moving single cells. I have some code below that works ok from DGV to textboxes but not from DGV1 to DGV2.
Dim i As Integer
i = DataGridView1.CurrentRow.Index
Form3.DataGridView1.Item(1, i).Value = DataGridView1.Item(0, i).Value
[code].....
I have converted a VB6 app to .NET using VB 2008 Express Edition, as recommended in the VS 2008. Actually just opened VBP project using this software and followed the wizard's instructions. The app has a form containing the ADODC control and AxMSDataGridLib.AxDataGrid. The DataSource property of the Grid is set to ADODC. (Actual data comes into UI from some DLL.)When I start debugging the converted app I immediately receive following error:Error -2147467259: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.Same error happens when I try to set the ADODC object to the DataGrid.DataSource programmatically (in run time).The VB6 version of same app runs without any problem.
View 4 RepliesI want to ask how to add/insert new row/record and it show at the top in datagridview. i don't want the new add record at the bottom but i want it at the top. I mean,the current is at the top in datagridview. i'm adding the new record is not from inside the datagridview,but from textbox at outside datagridview.
View 5 Replies