Hi led mike, Thanks for your help. I was able to create a seperate function and delegate in place of his delegate code. Still don't understand what exactly his code does, but I got it to work some how. Thanks again

eatwork

Hi I found some code in an article posted on code project "Asynchronous Method Invocation" and was trying to follow the article, and convert it to vb.net, and got stuck at the last section of the article. I was wondering if anyone out there knows what the code below does, and how to convert it to vb.net. I am most confused with the "MethodInvoker updateGrid = delegate {m_grid.Datasource = ds.Tables[0];}; Thank you private void CallBack(IAsyncResult ar) { // get the dataset as output DataSet ds = m_invokeMe.EndInvoke(ar); // update the grid a thread safe fasion! MethodInvoker updateGrid = delegate { m_grid.DataSource = ds.Tables[0]; }; if (m_grid.InvokeRequired) m_grid.Invoke(updateGrid); else updateGrid(); }

eatwork

Hi I found some code in an article posted on code project "Asynchronous Method Invocation" and was trying to follow the article, and convert it to vb.net, and got stuck at the last section of the article. I was wondering if anyone out there knows what the code below does, and how to convert it to vb.net. Thank you private void CallBack(IAsyncResult ar) { // get the dataset as output DataSet ds = m_invokeMe.EndInvoke(ar); // update the grid a thread safe fasion! MethodInvoker updateGrid = delegate { m_grid.DataSource = ds.Tables[0]; }; if (m_grid.InvokeRequired) m_grid.Invoke(updateGrid); else updateGrid(); }

eatwork

Hi, does anyone know what this error means and how I can resolve the issue? I have created a UFL for crystal reports in VS2005 and have created the assembly etc. It works fine in preview report, but when I load the program and try to load the report from the viewer it gives me the error: "NonComVisibleBaseClass was detected Message: A QueryInterface call was made requesting the default IDispatch interface of COM visible managed class 'CRUFL_VB_ReportFunctions.CrystalReport1'. However since this class does not have an explicit default interface and derives from non COM visible class 'CrystalDecisions.CrystalReports.Engine.ReportClass', the QueryInterface call will fail. This is done to prevent the non COM visible base class from being constrained by the COM versioning rules." I have done some research online to find that the problem might be the MDA, I added the MDA key as described and set it to 0 but am still having problems with mda issues during the build and run within visual studio. Runs fine if I use the exe in the bin folder. Any ideas? thank you

eatwork

Hi, I am currently in need of an article or the steps required for creating a UFL that I can then use within my crystal report. I have no idea how to do this, and after reading a few articles online, they require me to create a new project, win32 dynamic link library project, but I cannot find anything close to that unless I go into the MFC projects. Could someone point me to a good article or give me a walkthrough on how to create this project? thank you. PS I am using visual studio 2003.. standard?

eatwork

Thanks, are there any other pros / cons that you can think of for binding a database? And do you know of any examples/solutions out there that I could look at? My project has 120 tables and the system requires a user login, the user to select their database connection location on the server and I am not sure I want to continue the project in the unbound format. Thanks

eatwork

sorry, ignore the last post, starting to confuse myself. Thanks again

eatwork

Hi kulazfuk, Awesome sample, it works! Not quite what I was expecting, and I guess I need to create a blank xsd for it..but it works and thats all that matters. Thanks a lot for your help

eatwork

hello christian, thank you for your reply. Point well taken, but does it require more maintenance in the future is it faster, etc? thank you

eatwork

maybe you could post your vb code so ppl can analyze that and give a better answer?

eatwork

Hi, I have a question regarding binding and am looking for the pros and cons of each. The question is whether to bind a windows forms system to a database on the server or to have it store the data locally on each of the clients computers and update/insert/delete/ and refresh only when the user has made a change or switched tab pages etc. My current database is not connected to the database and retrieves and stores the data in one dataset and that dataset gets updated as needed. Not sure if it is more efficient to connect directly to the database or if it is better coding standards etc to be linked to the database. Thank you

eatwork

Thank you for your reply and insight. I currently do store the quotes in a database but do not store the reasons why they might/might not have been accepted. But I will ask the users if that is something they would like in the system. I tried the code you suggested, but it doesn't seem to be working for me. The form opens, but without a report in the report viewer. This code is in the pop up form after the user clicks on a button and I call the forms showdialog method my code: Private Sub Form_Load() myReport1.SetDataSource(Me.p_dataset) Me.CrystalReportViewer1.ReportSource = myReport1 End sub also tried Private Sub Form_Load() myReport1.SetDataSource(Me.p_dataset) Me.CrystalReportViewer1.ReportSource = myReport1.FilePath.ToString End sub Do you know of any place on the internet that might give me a tutorial to create a "template report"? All of the reports I have seen online are databinded to a database or have a database/xsd file that it reads data in from. I can't really use those examples because my dataset is created at runtime. I am fairly new to .net and coding, and have never done a crystal report through the integrated crystal reports in vs2003. Thank you very much

eatwork

Hi everyone, Not sure if this is the right place for crystal report posts but here I go. I have a windows application that has been coded in vb.net, in VS2003. the database is MS Access based. I am working on a quotation system and have completed the forms that the user will utilize for input. The windows apps created are not bound to the database and store a local dataset that holds all of the information/tables/data that the user has came in contact with. I would like to create reports that will be populated based on the local dataset. I was wondering if there is any way to create a crystal report, to be used as the template, without binding the report to the database, and then passing the local dataset data into the report that needs to be printed. I have read online about a push method, but they say that can be really slow in creating a report with lots of tables and data, and all of the other solutions are for vs2005. Thank you for reading this post, I am new to crystal reports and am looking for any tutorials etc that might help with this problem. Thank you.

eatwork

Hi I have a windows application where I have programmed and designed my forms in normal(96dpi). The problem is that some of the users are changing their settings to large font(120dpi) and it is causing the text in the forms to enlarge and it is therefore screwing up the design/look of the pages. I have been able to search online to find some code that is available in VS2005, but I am using VS2003 and it does not seem to have the systemfont class required for those solutions. Does anyone know of how I can implement those solutions or if they know of where/how I can solve this issue? thank you eg code: Imports Microsoft.Win32 Public Class Form1 Public Sub New() ' This call is required by the Windows Form Designer. InitializeComponent() ' Add any initialization after the InitializeComponent() call. AddHandler SystemEvents.UserPreferenceChanged, New UserPreferenceChangedEventHandler(AddressOf SystemEvents_UserPreferenceChangesEventHandler) End Sub Private Sub SystemEvents_UserPreferenceChangesEventHandler(ByVal sender As Object, ByVal e As UserPreferenceChangedEventArgs) If (e.Category = UserPreferenceCategory.Window) Then Me.Font = SystemFonts.IconTitleFont End If End Sub Private Sub Form1_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing RemoveHandler SystemEvents.UserPreferenceChanged, New UserPreferenceChangedEventHandler(AddressOf SystemEvents_UserPreferenceChangesEventHandler) End Sub End Class

eatwork

Hello, Does anyone out there know how to update the text value of a subitem of a listview and refresh the list to show the changes? the code I have is: Me.listview.SelectedItems(0).SubItems.Item(1).Text = "Something" Me.listview.Invalidate() Me.listview.Refresh() Me.listview.Update() The setting of the text works, but the invalidate, refresh and update don't seem to update the text displayed to the user. THank you

eatwork

Hi everyone, I was wondering if it is possible to format a listview item's data after the data has been added to the listview. I have a custom listview that is populated from a datatable and one of the columns needs to be in a currency format. Do I need to format the data as it is being added? or can I modify it afterwards? thank you

eatwork

Hello everyone, Thank you for viewing my post. I have a question regarding the Datatable.Select method. I have a program that stores the tables from the database onto the users computer and keeps them in memory, to reduce trips to the database, and not binding my program to the database, to allow the user to make changes without affecting the data directly on the database. I need to populate a listview from the tables within the user's computer. The query in my db is as follows: Me.lstCommodityPool.RowSource = "SELECT commodityId, tbl_Commodity.commodityName " & _ " IIf(nz(commoditySerialNum,'')='','','(S/N:' & commoditySerialNum & ')') " & _ " IIf(nz(commodityUnitNum,'')='','',' - ' & commodityUnitNum) " & _ " IIf(nz(commodityCurrentLSD,'')='','',' - ' & commodityCurrentLSD) AS commodityName " & _ " FROM tbl_Commodity " & _ " where commodityId NOT IN (select quoteCommodityId from join_tbl_Quote_Commodity " & _ " where quoteId=" & Nz(Me.txtQuoteNum) & _ " and quoteRevisionId=" & Nz(Me.txtRevNum) & _ ") and companyId=" & Nz(Me.combCompany) & _ " order by commodityName" The question I have is how can I recreate the condition, especially the "NOT IN" clause, using the tables on the users computer? Thank you

Thank you Asif for your reply. I guess I will have to find another method to compare two tables. eatwork

Hi everyone, I was wondering if anyone out there knows of a way to compare a datable to another datatable in VS 2003. I would like to compare the two datatables to see if any updates were made to a datatable. Is there a better way than looping through all the records within each datatable? thanks

Hi Robert, Thank you for the post and the information. I guess I am stuck with what I got. Thanks again. eatwork