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]....
I have a datagrid on a silverlight 4 application that I am trying to export to excel by calling the COM component for Excel in silverlight. It keeps error-ing out and tells me that the functionality is not supported. I can't quite figure out what is wrong and believe my code is solid, obviously not though.[code]
View 1 RepliesI have a LOB app written in VB.NET with a WinForms front-end and SQL back-end. After many months weighing up how to get onto the Web, I decided last month to use Silverlight 2. Now, Silverlight 3 Beta is out, but there is no end-user runtime.
Does anyone know when the runtime will be available for deployment of SL 3 apps onto client sites?
My dev timeline is about 3 months: should I persist with SL 2 and then u/g to SL3, or jump straight in to SL3?
I am developing an application using VS 2008/MySql and I am trying to export the crystal report on runtime using my own code. I get an error saying:
Quote:Invalid export DLL or export format.
My code is:[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].....
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'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 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 RepliesI have been able to export data from a query to the xlsx file..howerver those fields which are currency in my sql server 2005 table are currency are showing up in the spreadsheet as text. The column mappings are correct when I look at it in connection manager.
Also Is there also a way to create a new worksheet each time the export is run or does the file have to be already named?
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
View 16 RepliesI am trying to implement multibinding in Silverlight using VB.Net. I have found a very good reference for an implementation in C# here. I spent some time trying to use various converters to migrate it into VB.Net but I still didn't get it working properly. So..
I'm looking for some references that exemplify how MultiBinding can be done in VB.Net. Also an example using Silverlight 5 beta would be fine (I read in a post right here on Stack Overflow that it supports multibinding).
is it possible to write xml in silverlight with vb
View 5 Repliesif this has been asked before (I couldn't find the answer anywhere), but I have a WCF Service Application that I have created, and am trying to access via my Silverlight 4 app. I have added the service reference to the SilverLight App and am just trying to call one of the default pre existing methods on the service (GetData). When calling the method i get an error of:
[Code]...
How can i use SilverLight Video Player on Visual basic 2010
View 1 RepliesI am designing a web application in Visual Studio 2010 Beta 2, using Silverlight 3, with Visual Basic as the underlying programming language. What is the Visual Basic code that I would put in a Button1_Click event to tell the program to navigate to another UserControl XAML file?
View 4 RepliesI'm testing and trying to understand how to create a DLL and call a function from it in my Silverlight project. I'm getting an exception: Unable to find an entry point named 'WriteTextFile' in DLL 'C: empTestDLL.dll'.[code]...
View 1 Repliesi built a patient management software for a clinic and i need to export patiet list from ASP.net grid view to excel file my question is:Is there a way to export gridview to excel i am using vb.net and visual web developer 2010 i store datasource from advanced search page into a session and redirect to result page
here is the code of result page
[Code]...
If Class X is within the scope of Class Y, is X a subclass of Y?If Class A is a sub Class of B, then is Class B considered a super class of A?if Class C inherits Class D is Class D a superclass or parent of Class C?if Class E extends Class F then we can consider Class E a child of F?if Class G inherits Class H and is within the scope of Class I then who is the parent of Class G? Classes that inherits Class J and classes that are within Class J are all sub classes of Class J?
View 1 Replies I call upon your combined intellects. I have a web application with a silverlight app that calls a ria service. The ria service is defined inside the web application and everything else is just dandy.
The issue is this.It is my understanding that in order for the silverlight application to talk and know what the ria service is, you need to add a service reference for that service. The service reference defines the ria service and sets up the connection binding. One of the files it adds is the ServiceReference.ClientConfig which has the connection binding in it. During the course of this application's development, this is the way it was set up. And it worked perfectly fine locally and on the dev server.
Unfortunately there were issues when deploying to the clients in-house server. At this point I was onto other projects while my co-worker continued with the deployment. He soon became frustrated with the goofy errors that were occurring and recruited some help. This dev came in and, albeit got it working, but in order to do so he removed the service reference from the silverlight project but left the ServiceReference.ClientConfig which pointed to the location of the service in the web application(but that's it, no definition or explanation as to what the service does and I'm not sure how the silverlight app is supposed to know how to work with it..). This works perfect on my co-workers workstation and he has deployed this version to the clients server fine.
When I open the project it doesn't run at all. And the reason why is that it doesn't know what the service is that i'm using in code. Specifically, it doesn't know where this is (names changed for clarification):
Imports SilverlightApp.ServiceReference.WebApp.Service
I have cleaned the solution, completely deleted and got the latest from source control, built the web app first and made sure the asp.net dev server was running so that the address in the ServiceReference.ClientConfig resolved correctly. But, alas, it still doesn't know what Imports SilverlightApp.ServiceReference.WebApp.Service is.
So, to get it working on my workstation, I added the ServiceReference back but kept the current connection bindings so that it matched the endpoint in the web app web config. and changed the import statement to Imports SilverlightApp.ServiceReference and everything works fine.
I currently have a silverlight application which has silverlight class library. The silverlight class library has a WCF service reference which works as expected for small data. However we have come across a problem which is caused by the default value of maxItemsInObjectGraph. We have tested it with an increased value (called from vb app set in behaviour) and it works however we are unsure how to set the value of maxItemsInObjectGraph when it is in a silverlight class library (as it is only defined in the clientconfig file and no services are added to the client). I have seen posts about adding it to the web.config but this only seems to apply when the service is called directly by the app not by a class library?
View 1 Replies