I'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 am currently programming within Visual Studio 2010 using VB.Net and DevExpress V10.2 Winforms. I currently have a DevExpress GridControl that contains two DevExpress GridViews.So there is the main view and the subgrid (similar to the DevExpress demo for Master-Detail Grids - example with WinForms and better view with ASPxGridView). Currently the data for the grid is fetched into a DataSet:
If myDataSet.Tables.Count > 0 Then
myDataSet.Relations.Add("Details", myDataSet.Tables(0).Columns("id"), myDataSet.Tables(1).Columns("id"))
[code].....
I'm having a hard time joining 2 datatables and have the joined datatable as result. First datatable (labels) holds data including a printerid. Second datatable (printers) holds printer references (id > unc). I would like to have as endresult (joined) a datatable with all data from the first datatable with the field (unc) of the second datatable. [Code]
View 3 RepliesIs it possible to change the data source of a dropdown list in a gridview from another dropdown list selected index changed method in the same gridview
View 2 RepliesI was having a heck of a time populating a gridview combo box.I learned a ton in the last 48 hours but would really like to know the answers to the bottom three questions.You guys are the experts, so I'm hoping you will enlighten meBut the summary of it is below:I was never able to get the ComboBox to bind to the data source. I tried everything until I turned blue. So I went to the basics and coded all the automatic stuff. I'm curious as to why the automatic binding didn't work. Perhaps its because my gridview datasource was LINQ.Here is how I pulled it off. I hope someone down the road benefits from the last 48 hours of my delima:First of all, know that I have two drop down lists on my form, one is the GPField and the other is the BankField. These are already populated DDLs that are static. So I used them to cheat on the values instead of using enums.
Sub fillGPFieldListDDL(ByVal obj As Object)
Dim db As New CompanyDataDataContext
Dim myConn As New Connection With {.ConnCls = ConnCls}
[code].....
I have created a site in VB.Net and ASP.Net where a user types in a centre code and clicks on 2 buttons to retreive 2 GridView's of records from an SQL Server backend database.
View 1 RepliesIm trying to add data into a new column I have created in my gridview.[code]...
Now I need to go in and add data for the rows below the column. I have seen ppl saying I need to set it equal to a datafield but how do I create a datafield from scratch then?
I'm developing a user control that exports a grid view to many file formats, this control takes the gridview as a property, I need a code that returns the gridviews in the form if so that in design time user can choose one to export
View 3 RepliesUsing DevExpress 10.2 within Visual Studio 2008 with VB.Net I have created a single gridcontrol that contains two different gridviews. The gridviews are related using an id column. Basically if there are related details about a row in the first gridview then the user can click on the plus sign to see all the related details. When I have any row on the first gridview I am able to get the focused row. Yet when I have the focus on any of the rows in the second gridview I am unable to get the focused row or the content of the row.
[Code]...
Is there any way to get the value in id from the focused inner gridview? Or at least figure out the parent row and grab the id value from there?
When I have changed the name of a table field name none of my combo boxes or grid views work properly. The TableAdapter still refers to the original name. Is there an easy way to make the change propergate through the program or do I have recreate all my TableAdapters.
View 5 RepliesI've created a Gridview control that pulls some data from my database, but doesn't display all of the information I'm hoping it gathers. I choose not to display the primary key for user interface purposes, but require that key for basic operations on the grid.I'm currently attempting to add a "Delete" option to the table, but unfortunately I'm having very little luck. Here's my .aspx file.
<asp:GridView ID="ManagerList_GV" runat="server"
AutoGenerateColumns="False" AllowSorting="True"
DataKeyNames = "ManagerID" OnRowEditing="editManager"
[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].....
I 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]....
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 Repliesthis 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 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 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]...
I 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 RepliesHow 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 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 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 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 RepliesI'm trying to the contents of a datatable to a datatable thats allready in my form using the openfiledialog.[code]...
View 4 RepliesI'm trying to create a program that will merge two data tables (one from a database on a network drive, the other is found in a database on the local machine). Each datatable is identical in structure, only (maybe) differs in content. The structure has a primary key, dateCreated, and dateLastEdited fields (plus other fields). I would like to merge down from the network to the local database. If the primary key does not exist on the local db but does on the network, copy from the network db to the local table. If it does exist, check the dateLastEdited column and copy the latest row to the local table.
How would i set up the code to do this? Any assistance would be great.
How to intersect two dataTables in vb.net 2.0? I want to get common rows in two datatables and add it in third datatable.
View 1 RepliesI need to marge two datatables with condition. I have a datatable where the data comes from a local XML Database and another datatable where the data comes from a remote SQL Server. If any update made in the remote datatable I need to update/merge with the local datatable. Here is what I have so far:
Public Sub MargeTwoTable()
Dim SQL As String = ""
Dim RemoteTable As New DataTable
Dim LocalTable As DataTable
[code]....
In this code data comes from the remote database which updates a date getter then the local database . Both tables have "ID" as the primary key. The code is working well, but the problem is that when more than 1000 records are updated this function takes too long using loops.