vandewst's Q&A profile

• Visual Basic A problem about get paper size ID.

  Dev Tools:Visual Basic 2005 OS:Windows XP Professional Crystal Report 11 R2 SP1 MHF1 When I am developing a WinForm applicaion with Crystal Report,I found a problem about custom paper size. And then I look it for the document of Crystal Report and It says: The reason why a report created using a custom paper size prints differently once it is distributed is that the report’s paper size ID (Form ID) is saved with the report file. It is the ID value that is saved and not the name of the paper size because the Crystal Reports print engine uses the operating system's DEVMODE structure to save the printer information with the report. This is by design, and affects all Crystal Reports development tools. To pass a custom paper ...Show All

• Visual Studio Team System Looking for a way to create a SelF eXtractor (SFX)

  I have a copy of wzipse32 (winzip se) but it doesn't seem to work over the TFS, seems like some sort of running as a service problem. Does anyone else know of any other ways to do this I had actually tried this , but it didn't work because the process was still running at a service TFSService, and there was presumably a popup window which caused it to hang ...Show All

• SQL Server Update of a text/image and a clustering key

  Hello Everyone, We receive this error with ADO.NET (on a SQL Server 2000): The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at OnExecuteNonQuery@dtbmsq_Statement_c@@$$FUAE AW4dtb_Result_t@@PAUdtbsql_Connection_ip@@PAH@Z(dtbmsq_Statement_c* , dtbsql_Connection_ip* Connection, Int32* NbRowsAffected) in s:\ogl20061\src\odbmsq\dtbmsq\dtbmsq_statement_c.cpp:line 598 N.B. The update concerned only update one row. I ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. build problems (in fact, cant build at all)

  Hello, i need your help badly... Started to have some interests in mechcommander2 source codes about 5 days ago. Downloaded and installed all files necessary ;Mechcommander 2 shared source code,  Xna, Framework, etc... Then i try to build the code...How do i do i searched and finally found something:in visual express, there is a dos command...doesnt work. But, acessed with the shortcut in the start menu, it can be opened. Doing what is told in the webcasts, i type '' C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\msbuild.exe C:\MechCommander2 Source\BuildProj\mechcommander2.proj It doesnt work. Why Cause (i think) DOS takes C:\Mechcommander as a command Then, i rename the folder, deleting the space between m ...Show All

• Visual C# try / catch question

  Is it a good pratice to do the following void foo() { try{ ..... } catch(FileNotFoundException ex) { throw new FileNotFoundException(); } } void foo2() { try { foo(); } catch(FileNotFoundException ex) { .... } } generally wherever the exception is going to be thrown in, foo method in this case, will be thrown in that and not passed back to the caller, unless perhaps there is an exception thrown BUT you did not handle it. I just did a quick test, similar to the above and it confirmed that if Foo() caused an exception that we can handle, it will only be thrown in there and not raised/thrown back up to the caller.   general note: Throwing exceptions maybe expensive but be sure to catch the ...Show All

• Visual Studio Tools for Office Reading Excel From C#

  You can read data from Excel using the JET OLEDB provider. See the URL below for the necessary connection string, and a link to a KB article with further information ... http://www.carlprothman.net/Default.aspx tabid=87#OLEDBProviderForMicrosoftJetExcel -- Brendan Reynolds wrote in message news:9226766e-a1d5-400c-8d3c-8ffc566bec50@discussions.microsoft.com... > Hi > > Can anyone help me how to read values in Excel in C# . So that Once I > read I can send them to DataBase. My excel file Test.xls in ("C:\") > > Thanks > Doss > If you are using a dynamically generated excel file then you can use the following: Excel.Sheets sheets = m_Excel.Worksheets; Excel.Worksheet ...Show All

• Visual Basic What's the best way to wipe a document and then write an array to it?

  I'm trying to read a document by reading each line into an array or arraylist. Depending on a predetermined variable that specifies the line to change, I want to change the specified line. I've tried a few different options, but nothing seems to work. Here's the code: Private Sub btnAddBook_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAddBook.Click Dim line As Integer line = lstAuthors.SelectedIndex Dim sr As New StreamReader("authors.txt") Dim docline As String Dim coll As New Collection 'read in the contents of each line and manipulate that string - LOOP Do While sr.Peek <> -1 'If line = docline, then append the book to the line If sr.Peek = line Then docline = sr.ReadLine() ...Show All

• SQL Server SQL Mobile create sdf file from SQL 2005 DB

  Hi, I'm trying to create a SQL Mobile .sdf file from my SQL Server 2005 database and cannot. I read the ms support docs for doing this and have had no luck . I created the respective publication and SQL Subscription for the db and when i run the process (not sure if i'm running the right process - docs don't say) it creates a directory under a "unc" directory with all my table objects (articles) with subscription/replication files for each table such as .cft, .bcp, .dri, .prc, .sch, and .trg. But no .sdf file for my SQL Server 2005 database. All I want is the .sdf file so that i can copy it to my Pocket PC device and then connect my mobile application to it. I want to copy my SQL Server 2005 database to my device so that t ...Show All

• Windows Forms Filtering a BindingSource

  BindingSource.Filter = "select * from tStock where Barcode='" + txtBarcode.Text + "';" This seems to fine in th eory. There is no refresh or update on the BindingSource. Any ideas or other way that it might work PS: I am using Visual Studio 2005 .Net and a MS-Access database. You don't write the entire SELECT statement - just the WHERE clause: BindingSource.Filter = " Barcode='" + txtBarcode.Text + "'" ...Show All

• SQL Server Stored Procedures

  Hello Have you ever worked with stored procedures I am making an application in .NET using CSLA framework and I use as a data base one i've made in Access (not my wish) and I can't really manage those stored procedures. Any help Thank you, Monika Hello, What I wanted to ask is how you use them, for example, in this code : /****** Object: StoredProcedure [dbo].[addAssignment] Script Date: 01/18/2006 09:28:48 ******/ IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID (N '[dbo].[addAssignment]' ) AND type in (N 'P' , N 'PC' )) DROP PROCEDURE [dbo].[addAssignment] GO what sys.objects represents and what are those "N" and "P" and ""PC" what d ...Show All

• SQL Server using a datetime as dynamic filter... How?

  Hi! Is there any way to use datetime value as dynamic filter in the Merge Replication (Yeah, I use HOST_NAME in order to pass datetime value) I used all possible approaches, but or I got the error Conversion failed when converting datetime from character string. (Microsoft SQL Server, Error: 241) or I got 0 rows on the subscriber after synchronization. Any ideas how it can be solved Thanks Paul I've sufficiently large table. Filtering based on date allows me to reduce appreciably the snaphot size. (Yep, it doesn't save a situation if a user want to have all data, but..) ...Show All

• Audio and Video Development full file encyption

  What's the design consideration of Media Foundation in the case of full file encyption, where the media source cannot get stream description or split stream without the decryptor (to decrypt at least part of a file) An example of what I described is to implement DTCP/IP under MF. The DTCP/IP packets are encypted. The Media Source is unable to demux the packets unless they are decrypted. If the decryption happens in the Media Source, that does not effectively use the PE protection. If the decryption is done within PE, Media Source, which is outside PE, cannot perform demuxing. ...Show All

• Visual Studio 2008 (Pre-release) Potential Bug: IPv6 + ServiceHost + NamedPipe

  I've noticed something unusual. When creating a ServiceHost and passing this for a base address: net.pipe://[::1]/servicebase It is expanded to the full IPv6 address: net.pipe://[0000:0000:0000:0000:0000:0000:0000:0001]/servicebase The named pipe transport then fails to identify this as a local address and authentication operations fail. Whether the abbreviated form is used or not, the expanded address or any intermediate variations should still be considered local. ::1 0::1 0:0:0::0:1 0000:0:0::0000:1 etc. I was able to duplicate the same behavior on the RTM bits, but i'm not familiar enough with IPv6 and NamedPipe to give you a solid answer, i did want to let you know i've notified the ...Show All

• SQL Server [097] Memory leak detected [1260 bytes]

  I have received the following error my SQL Server Agent Log. [097] Memory leak detected [1260 bytes] When this happens jobs will fail with the following error. [000] Unable to retrieve steps for job Backup TLog - 1stComp (Increm) My current work around is to stop and restart the SQL Server Agent services. Has anyone seen this before Is it corrected in the the 2153 hotfix What is the service pack level on SQL & Windows Also the memory leak errors seems to be hardware related too, might invole the Vendor to confirm the health state of hardware. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Beginners

  My friends and I have no experience with coding or anything like that but have taken an interest in XNA and have some ideas that we would like to try to create. How easy is XNA going to be to use to make a simple 2d game just for fun I know it uses C# and I am going to start trying to learn, but is this going to be something where only experts can use this program, or is someone like myself going to be able to create at least simple games and not have to spend hundreds of years doing it Thank you for your resoponses. I will continue to learn C# and wait for a better version for people like me. I will also take a looke at Garage Games and the absolute beginners videos. Thanks again. ...Show All