Daveko's Q&A profile

• SQL Server Transaction Rollback Issues

  Hi We are loading data from one extract file in to 4 different database tables. When we are loading if the first table gets loaded without any issues and the second table loading gives any issues, we need to rollback the data loaded in to the first table also. In the package for achieving this, we are using Sequence container. In the sequency container we are having 4 different tasks for loading data to 4 different tables from the same extract file. We also tried setting the different transaction options given in the properties box of the packages, container and tasks. Also we tried the properties by setting as mentioned in the Test# 7 and 8 in the following URL http://www.sqlservercentral.com/c ...Show All

• .NET Development Beginner Questions

  1. When creating a new WCF project in VS2005, I have the choice of File | New | Web Site... | WCF Service and File | New | Project | WCF Service Library. What is the difference between the two and when would I select one over the other 2. When I select the "new web site" choice from above, I get a basic "hello world" project created for me by VS2005. I rebuild the web site w/o any errors but when I run it, it only displays the contents of the service.svc file (I ran ServiceModelReg -i, but had the same results). Why 3. Why didn't any DLL get created as part of the build process in step 2 I got an App_Code directory with a cs file but no DLL. 4. The only tutorials I've found always skips over steps (e.g., " ...Show All

• Visual C# Data structures in C#

  Hi, I need some advice on the data structures to use in C#. My need is to construct a something like a code syntax tree. what would the embedded data structures in C# to use so as to ensure memory optimisation and run time efficiency currently, stacks/lists/ dictionaries are my choice of options. If any experienced C# developer would give me some sound advice, I would like to hear from you. Thanks The most efficient way is not to use a data structure at all but a program structure. Most compilers don't build a syntax trees but build the compiled code as they parse source code on the fly. The only structures they require are a few symbol tables and some buffers for their input and output. If you reall ...Show All

• .NET Development Dynamic creation of ASP Controls using xml and xslt

  Hi.. How to create asp controls like textarea, radiobutton list,checkbox list using xml dynamically Could anyone please help me.. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. using the XmlImporter w/Content Pipeline

  I have all my game objects defined in XML files and I would like to use the Content Pipeline to load them. Looking at the available importers, it seems like the XmlImporter is the right choice, but it appears to want the XML in a certain format (a reasonable requirement). So far I haven't found any documentation on the correct way to format the file. It seems like this would use the XML serialization in C# to serialize/deserialize the object. When you pick XmlImporter in the properties, however, it appears to want a particular root element. Also, I would assume that you would use the No Processing Required for the Content Processor. If that is the case, then I think it is just a matter of formatting the XML file correctly, selecting the XM ...Show All

• SQL Server Any idea why OpenRowSet to open Excel file doesn't work well in SQL 2005?

  Maybe it worked once, but in most time it doesn't work, query like below select top 10 * from OpenRowSet('microsoft.jet.oledb.4.0','Excel 8.0;hdr=yes;database=\\ws8\web\ablefiles\sitefiles\4000010\reibc\active.xls', 'select * from [crap2$]') I got error OLE DB provider "microsoft.jet.oledb.4.0" for linked server "(null)" returned message "Unspecified error". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "microsoft.jet.oledb.4.0" for linked server "(null)". but the same query can run without any problem on a SQL 2000 server run on a server in the same network. Any idea Something is not righ ...Show All

• Visual C++ Truncated text in reports

  Hi experts! I have a table in access with a field type memo, but when I generate a report the fields with more than 255 characters are truncated. Tks, To correct this problem, obtain the latest service pack for Microsoft Office 2000. there is a workaround for this bug: Instead of exporting the report in Excel format, export it as HTML. However, this provides only a partial solution. When you open the file in Excel, the text in the Memo field will be spread over multiple cells instead of being in one single cell. Please also note that such questions are out of scope of this forum, for the scope of the Visual C++ General forum please look at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostI ...Show All

• SQL Server Report Builder reports not compatible with MS CRM 3.0???

  I'm currently testing our setup of CRM 3.0 and SSRS2005 which are on the same server. I can successfully design a custom report in VS2005 report designer, and then add the report from within CRM -- viewing the report works fine, too. But, when I create a report model in VS2005, and then create a report using the Report Builder, CRM can't upload the file. I receive the following error: "System.NullReferenceException: Object reference not set to an instance of an object." Why can't CRM add the report made from report builder I can add this report to the server from within VS2005, and actually view it from within CRM, but I get an error if I attempt to "edit" the report in CRM. I suspect that the issue is ti ...Show All

• Visual Basic Programming Languages

  Hi, I'm relatively new to programming, and Visual Basic doesn't seem to be that good of a language, and not that much used in real applications. I want to move onto a different language, one that is very popular, can do almost anything, and can be and IS used in professional applications. Another important factor is platform compatibility. Java provides that, but Java isn't that popular for Windows, and Windows is my primary target. C++ works, but I have a couple of questions: 1) Can C++ be used on any OS Is it a good language to use as my primary language 2) Is C# going to replace C++ Does that work on other OS's C# is newer, and so I'm thinking maybe its the new version of C++ that's going to replace it, as xhtml is probably going to do ...Show All

• Windows Forms How to synchronize data between two windows forms

  Hi I have two windows forms: 1-st with a DataGridView control and 2-nd with a detailed view of selected row from the 1-st form. How can I synchronize the data between 2-nd form and the linked DataGridView control on 1-st form. When I close the detailed form how to refresh data in the linked row. Thanks in advance George   Hi,modtran Here is some code for you.In this sample,DGV2 will keep synchroniztion with DGV Private Sub ExampleBindingSource_ListChanged( ByVal sender As Object , ByVal e As System.ComponentModel.ListChangedEventArgs) Handles ExampleBindingSource.ListChanged ' Whenever there is an update, note that a change is pending. ' ' ListChanged does not fire wh ...Show All

• Visual C++ Two programs using one DLL

  I hope this is the forum. I have two program that use the same DLL. I want to launch both program and debug one of the programs as it uses this DLL. I want a single copy of the DLL in memory so that when I debug into the DLL I can see the footprints both program left behind. How do I setup Visual Studio 2005 to do this Jeff Stout So what you are saying is, "You can't share variable in a DLL easily, unless all the threads trying to access the data are in the same process." The method to do that kind of sharing is called IPC (Inter Process Communication). Yes, that makes since. Thanks for the explination. Jeff Stout ...Show All

• Visual Studio Report Viewer External Image Display Issue

  Hi, In the VS 2005 ReportViewer I have created a local report that contains an image. The value of the image is retrieved from the database column = (First(Fields!signature.Value)) (which is for example Delsign_241391_04_20060517141108.bmp). Along with this name, the path for this image is to be specified for which the following code in the Code tab of Report Properties is written: - Public Function imageSource(ByVal e As String) As String imageSource = "http:\\localhost\Signatures\" + e End Function Following is the RDLC Code generated :- <Image Name="name1"> <Sizing>FitProportional</Sizing> <Left>11.25cm</Left> <MIMEType /> ...Show All

• Windows Forms Problem with DataGrid column width

  I am working on DataGrid (VS 2003) and I am having problem with width of the columns. I have added the DataGridTableStyle and DataGridColumnStyles to the DataGrid for each column. I have adjusted the width of each of the columns so that the total width of the columns equals the width of the DataGrid. My main intension is not to leave any area on the DataGrid blank. Everything was fine on my machine but when I ran that application on another machine, the columns were not occupying the entire DataGrid area. How do I make it same on all the machines I appreciate any help! Thanks Basani ...Show All

• Visual Studio Team System Specifying source folder in workspace command line

  How does one specify the source folder in the workspace command line tf workspace /new newworkspace /server:VCTFSRV01 /noprompt will just create an empty workspace with no source folder mapped. Thanks, Maggie ...Show All

• Visual FoxPro Strip HTML out of a memo field

  What is the best way to Strip all HTML out of a memo field I can’t think of a better method than of looping thought every charter copying one at a time but ignoring those between “<” and ”>” . Is there a better way A faster way Thanks, Sammy Regular expressions might help you out here. lcMemo = "<HTML><HEAD><TITLE>Title</TITLE></HEAD>" ; + "<BODY><H1>Header</H1><P>Paragraph</P></BODY></HTML>" _regexp = NEWOBJECT("_regexp", HOME(1) + "ffc\_REGEXP.VCX") _regexp.Pattern = "<\/ \w*>" lnMatchCount = _regexp.Execute(lcMemo) lcTest = lcMemo ...Show All