TiberiusOne's Q&A profile

• .NET Development How to Zip files within a folder?

  In my application multiple reports are generated and saved on server. I want to zip all these reports and keep a link on webpage so that user can download this zip. But I am not able to figure out a way to zip the files programatically..Please help me...thanks in advance.. I have written code to zip multiple files and entire folders and published the following article that may be helpful to you: GZipStream, C# to Compress Folders and Multiple Files ...Show All

• Windows Forms Passing values from one form to datagrid placed on diff form....

  Hi, If the two forms are in the same project, then there are several ways to do. 1. make the value public (though not a good idea) or global 2. write a function which you can pass the value as parameter ... But if they're two different windows applications, then you may use the Clipboard (OLE) to transfer the data. ...Show All

• Visual Studio Including code with the help documentation.

  We have used Doxygen to create .chm files. Doxygen includes the code in the html and also provides links to the actual project files. Does or will Sandcastle support this functionality for .NET 2.0 Thanks Yes and Steve sent me an attachment with a screenshot. We do not have this feature in Sandcastle but I have added this as a feature request. We will do our best to have such a feature by RTW. However we support and we have ExampleBuilder, a component, that interrogates a code example store and extracts all the code snippets defined there. The output of ExampleBuilder is a shared-content xml file, consumable by MrefBuilder, that contains all the snippets found. We use this for our internal .Net ...Show All

• SQL Server Excel 2007 and OLAP Server Formatting

  Hi, I can't make Excel 2007 to apply on percent number format. I use the CustomMemberOption on my calculated AS2000 members. It works great for number formats like FORMAT_STRING='0.00' but I can't get Excel 2007 to apply on FORMAT_STRING='percent'. It works great in ASManager browser. Any idea Thanks, Christer ...Show All

• SQL Server Dynamic SQL in SSIS with Oracle

  Hi , 1.Dynamic Sql ---------------- My source table is Oracle .we want to have dynamic query the following steps we have done. a.Created a new variable called StrSQL & ProductID variable contains values for where clause. b.Set EvaluateAsExpression=TRUE c.Set Expression=""select * from prod where product_id = " + @[ProductID]  d.OLE DB Source component, opening up the editor e.Set Data Access Mode="SQL Command from variable" f.Set VariableName = "StrSQL" But i am getting the following error Error at DataFlow Task[OLEDB Source[1]]:An OLEDB error has occured, Error code: 0x80040e14. AN OLE DB records is available . Source "Microsoft OLEDB Provider for Oracle" Hresult: 0x80040e14 Description : "ORA-00936:mi ...Show All

• Visual C# How to return indefinite quatity result form function?

  I have a function to return some result from database and the amount of result is not definite. How to set the return type I do not think array is a good idea but I do not know other type thanks Why not use a dataset or datatable to hold the result. Once you have the dataset you can do whatever you want with it. DataSets are not the most efficent but I have never found them to cause any performance prolems. Here is an example: DataSet ds = new DataSet(); string strSQL = "SELECT name FROM tblPoints WHERE tblStudyImageKey = " + imageKey; adapter = new SqlDataAdapter(strSQL,m_Conn); adapter.Fill(ds,"tblData"); foreach(DataRow dr in ds.Tables["tblData"] ...Show All

• Visual Studio Exception occured when retrieving ContactItem in olFolderContacts

  I'm using the following code to retrieve ContactItems in Outlook: Outlook.MAPIFolder defaultFolder = applicationObject.GetNamespace ("MAPI").GetDefaultFolder(Outlook.OlDefaultFolders.olFolderContacts); foreach (Outlook.ContactItem item in defaultFolder.Items) { //codes...... } However, there are also DistListItem in the same folder and the following exception occured: System.InvalidCastException: Unable to cast COM object of type 'System._ComObject' to interface type 'Microsoflt.Office.Interop.Outlook.ContactItem'. This operation failed because the QueryInterface call on the COM component for the interface with IID ...... Is there another way other than 'foreach' clause that I can get the ContactItem or DistListIt ...Show All

• Audio and Video Development Imediaobject::ProcessOutput() return error.

  Hi, I am developmenting an app that will invoke the interface of mp3 decoder DMO to render mp3 file on smartphone. While invoking Imediaobject::ProcessOutput() , there is an error, it return 0x8000FFFF(E_UNEXPECTED). But if I invoke Imediaobject::AllocateStreamingResources() before Imediaobject::ProcessInput() and Imediaobject::ProcessOutput(), Imediaobject::ProcessOutput() just return S_FALSE and pBufferStruct.dwStatus = 0x01000005. What is the reason Is the allocated buffer too small The size of buffer is from Imediaobject::GetInputSizeInfo() and GetOutputSizeInfo(). The following is my code: hr = m_pObject->ProcessInput (0, m_pBuffer, DMO_INPUT_DATA_BUFFERF_TIMELENGTH, rtStart, rtStop - rtStart); if (FAILED(hr)) { DEB ...Show All

• SQL Server 1 project - Multiple packages

  Greetings SSIS friends, If I have more than one package within one project, how do I select which package I want to run first Thanks in advance. Right-click on the project. Select properties Go to the Debugging tab Select your package in the StartObjectID property. I never actually knew this so I've learnt something today -Jamie ...Show All

• Windows Forms how do I restrict extension?

  Hi, I've developed application with log files. I want to restrict extension to load the log files such as like, .aspx, .xml, .html, .htm. In my Parser class, I do something like this; public class Parser { public LogEntry[] Load(string p) { ArrayList entries = new ArrayList(); using (StreamReader sr = new StreamReader(p)) { do { string lineread = sr.ReadLine(); if (!lineread.StartsWith("#")) { string[] information = lineread.Split(' '); string[] allowedExtension = new string[] { ".aspx", ".xml", ".html", ".htm" }; if ( ) { LogEntry newEntry = new LogEntry(); newEntry.IPAddress = inf ...Show All

• SQL Server Dynamic create table

  Hi, I need to create a table....whose column names should be dynamic...I wouldnt know in advance what the column names would be...These coulmn names are availabe in another table as rows... Ex: TABLE_A Data Column Names Col1 Col2 Col3 Col4... Some column Names are known already...I need help in writinf the Create table statement.. I need to write something like Create table Table1 (SerialNo int,Name nvarchar(50)+ AS select * from TABLE_A + Address nvarchar(500)).... Now the Table1 should look like Serial No Name Col1 Col2 Col3 Col4 Address Can some one please let me know how can i accomplish this...I know i need to write a Dynamic Query but dont exac ...Show All

• Visual C# How to always force rebuild C# project?

  Hey I have this C# project (.csproj extension).  I want to have it always rebuild every time, regardless.  How do I do that   Is there a flag or something I can manually throw into the project file (xml tag) One project is overwriting another one's binaries. I think you get what I want here, even if you don't understand why I want it.  Really though is there a way to accomplish this with some kind of flag in the .csproj xml file Think of it as a challenge! ...Show All

• Visual Studio Team System Project Portals stop working after restoring TFS from backups

  Synopsis of Problem: After restoring TFS from backups, the Project Portals cease working. When I try to load one I get the error message "The virtual server that is referenced here is not in the config database.". Full Story: In my evaluation of Team Foundation Server I decided to see how smoothly a backup and restore would go. The backup was easy enough. I backed up all the TFS databases (per this article ) and the reporting services encryption key (per this article ). With backups safely stored on a separate machine I wiped the server running TFS, reinstalled Server 2003, applied all available updates, and started the TFS install by following the instructions found in the installation guide for a single server configuration. ...Show All

• Visual Studio Team System "Add" operations not appearing in VS 2005 when performed from VS.NET 2003

  Our development shop uses VS.NET 2003 with the MSSCCI provider plug-in. One of the big drawbacks of the plug-in is that it breaks up check-in operations into separate changesets, making documenting those changesets more difficult. One of the workarounds I had come up with involved refreshing the VS 2005 Pending Changes window. This would show all pending changes that needed to occur in VS.NET 2003, or so I thought. It turns out that only edit operations are visible from VS 2005 in this case. This means all add and delete operations need to be treated as separate changesets. Is there a workaround for this other than upgrading to VS 2005 I cannot get the pending edits and pending adds to show up in ...Show All

• Visual Studio Express Editions Cannot bind to the property on the DataSource

  I'm trying to add a new column to a DataTable. I first added the field to the underlying Access database. Then I added the column to the DataTable. But when I try to set the Source property, the field does not show up on the list. The field shows up in the Data Sources window for the DataTable, but I cannot seem to bind the new column to it. What am I missing John Hi, The strongly-typed table must be regenerated. Delete it from the dataset and redrag the table from the server explorer. You'll lose any modification you made... This is annoying and I hope they fix this in SP1. Charles ...Show All