TopDean's Q&A profile

• .NET Development Edit "Summary" in files

  Hey guys/girls I am writting a program that sorts photos using an Access database and ADO.net. Does anybody know how to set/retreive information shown in the Summary page of the file (RightClick/Properties/Summery Tab) I need to retreive text from the summary page (If it is a photo from a Digital Camera (Date/Flash/Exposure e.t.c.) Or set data in the "Comments" section. Does anybody know how to do this Also: Can someone tell me how to check if two pictures are the same I think getting the HASH of the files should do it but I have no idea how this is done And last question: Is there anyway to check if two pictures are almost the same This is needed for scanned photos where it is impossible for the pictures to be exactly the same ...Show All

• Visual Basic How to obtain WIFI access point information?

  I was wondering if it's possible to access information from within Visual Basic about WIFI connections, such as their SSID, MAC address, ect. I don't know whether I have to add a reference, what commands to use, ect. Thanks for any help. Hi! Sorry about that. I believe the corrected line of code should read: For Each obj As Management.ManagementBaseObject In objarr ...Show All

• Visual Studio Where is the Recipe History stored?

  The speed issue is really a problem, and i would like to programmatically clear the history whenever the package loads. All I need to know is where this information is stored. Cant seem to find it anywhere in the filesystem or registry. thanks thanks much for the answer, Victor! hopefully this will help alleviate the issue. Incidentally, do you know if the GAT team is planning to make it optional to make entries in the history list I know that i have some things that it really doesnt make sense to put an entry into the history for, as undoing the action cant really be done or shouldnt be done due to the nature of the recipe, and it would be nice to not waste entries in the history list for these.. thanks ...Show All

• Windows Forms displaying custom control in datagridview column

  Hi , I have a datagridview in which I want to display a user control. I know how to create a custom editing control that will be activated when the user is editing a cell. But I want the control to be displayed even when the user is not editing. Please help me in achieving this. Thanks, Vara Whether both IDataGridViewEditingControl Interface and IDataGridViewEditingCell Interface are to be implemented and if yes plz explain how is it possible ...Show All

• Visual Studio Tools for Office Problem opening Excel 2007 file from Word 2007 addin

  I am attempting to open an Excel 2007 file (test1.xlsx) from my Word 2007 addin using OleDb. The code runs fine as long as I have the Excel 2007 application running with "test1.xlsx" open. But if Excel 2007 is not running, I get an exception "External table is not in the expected format" on the myConn.Open() statement. Does anyone know what the problem is Here is the code: using System; using System.Windows.Forms; using System.IO; using System.Data; using System.Data.OleDb; using Microsoft.VisualStudio.Tools.Applications.Runtime; using Word = Microsoft.Office.Interop.Word; using Office = Microsoft.Office.Core; namespace testAddIn { public partial class ThisAddIn { private void ThisAddIn_Startup(object ...Show All

• Visual C++ "error LNK2005"

  I have the following code in my Form1.h file: #include "stdafx.h" #include <stdio.h> #pragma once struct Record { char arr[15]; }; Record theRecord; errno_t err_temp; FILE *tempfile; namespace StrToCharArr { .... //typical stuff } #pragma endregion private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) { StrToCharArray(this->textBox1->Text); } }; } My StrToCharArray.cpp function is the following: #include "stdafx.h" #include "Form1.h" using namespace StrToCharArr; void Form1::StrToCharArray(String^ str) { err_temp = tmpfile_s(&tempfile); fprintf(tempfile,"%s",str); } I am g ...Show All

• SQL Server Stored Procedure

  I have a table with Id , Date and Price I would want to have a stored procedure to input a parameter n (for number of days) and i would like to get the price difference for the n days . If n = 1 it should be Sum of price for day 1 - sum of prices for day 2 I have a query for this but its not very usefull to work with a stored procedure. SELECT Table1.Price1 - Table2.Price2 AS PriceDiff FROM (SELECT SUM(Price) AS Price1 FROM MyTable WHERE Date = CurrentDate) AS Table1), (SELECT SUM(Price) AS Price2 FROM MyTable WHERE Date = CurrentDate - 1) AS Table2) Any help would be greately appreciated Try SELECT (SELECT SUM(Price) AS Price1 FROM MyTable WHERE Date = CurrentDate) - (SELECT SUM(Pri ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Any other way to buy an XNA subscription?

  For some reason or another my Xbox isn't accepting my credit card info (I think it may be due to the form not having an "Address line 2" field and I live in an apartment, I've checked and doublehecked all the info and the account has an ample amount of money in it), so is there any other way for me to get an XNA Creators Club subscription I tried looking to see if I could add my credit card info via Windows Live, but that didn't work out. About 60% of the reason I got this thing is because I could write programs for it, if anyone knows how to help me out I'd really appreciate it. Thanks, Johnny I'm not 100% sure but you may be able to add a credit card by going to http://billing.microsoft.com I ...Show All

• Visual Basic Add columns from different tables in SQL to a datagridview to show info via SQL Query including joint statement.

  The problem I have is the following: I need to have a datagridview in which I can add columns from different tables in my database (SQL), not only from one table. The idea is that I want to make a query in which I use a joint statement to obtain from certain table that has an idnumber, the name of this id number which is obtain from another table. And all of this I need to be presented elegantly in the datagridview, in which I present columns from the first table and columns from the second table, thanks that I have made the joint in the query. I have read a lot and still I haven’t found what I’m looking for. I’m using Visual Studio 2005 (need and answer in visual basic form not in C#). Thanks people in advance ...Show All

• Visual Studio 2008 (Pre-release) Pagin controls

  how to make paging in listview or GridView or any listing control i want it by xaml code I have not found anything about paging in WPF. But I have written PagingList<T> which adds paging support to any IList<T>. It works with Windows Forms and WPF, but in WPF, there is a problem with grouping - it is done only per active page with this solution. It is not easy to support paged grouped list, because WPF grouping is not designed with this in mind... If you want to try my PagingList have a look at http://developer.db4o.com/ProjectSpaces/view.aspx/Db4o_Binding_NET/db4o_Binding_NET . ...Show All

• Windows Forms How to create a alpha-blended & transparent rectangle with shadow

  How to draw a round-edge rectangle (lenght 200, height 30). Border color should be white and the interior totally tansparent Plus the borders should be alpha-blended with smooth shadows / blurring effect Is it possible to create this using .NET's native GDI+ Yes, the problem is that the transparecy color is only one. You need per pixel alpha to achive what you want. See this Code Project page for a sample: http://www.thecodeproject.com/cs/media/perpxalpha_sharp.asp It's C#. If needed I can translate it to VB.NET. Now I'm not sure what you're trying to do. If you're trying to do a Window Vista style window that has a glass border then you're pretty much out of luck. TransparencyKey can be us ...Show All

• Visual Studio Derive from Microsoft.VisualStudio.Package.EditorFactory

  Hi, On the one hand I would like to create a custom designer for specific Xml files, not all the Xml files. For exemple I need to check the name or the xsd of the file. Maybe I can open all the Xml files with my EditorFactory and create the default editor for the files I do not want to open in my custom editor. However I do not know how to return the default Xml editor. On the other hand I would need to have the same behavior as the xsd file editor, i.e. the user can hit F7/ Shift+F7 to switch between the default editor and the custom editor. I wonder to tell VS that my View/Editor is a design view and that it should not replace the default view. I found the Microsoft.VisualStudio.Package.EditorFactory ...Show All

• .NET Development finding connected users in current ftp sessions programmatically in iis

  hi all, i am trying to programmatically get a list of connected ftp users exactly like what's in the current ftp sessions tab in iis6. i cant seem to find anything on the net to help me, i've looked at the System.Net namespace, WMI, ADSI, System.DirectoryServices(where i create and delete the virtual directories in the first place) and various other places but there seems to be nothing out there. i create the windows logins via code as well so i thought it would be easy to map the ftp virtual directory and windows user login to the open tcp connections seeing as ftp users authenticate to be able to use ftp in the first place. i have looked at using some code i found somewhere which looks promising but i don't know where to t ...Show All

• Visual Studio General and conceptual questions about Crystal Reports

  Hi guys, I have general and conceptual questions about Crystal Reports. Here is my situation. I'm using MS Reporting Services right now for all reports. I use Reporting Services web based interface to redirect to the report web server page, use web service to access reporting services reports for individual reports. My questions are the following. 1. Is there any way that people can use Crystal Reports just the way reporting services right now. I want to give the user feature so that they can select reports from some kind of web based interface, select report, pass in the parameters and run the reports that I put out there (somewhere) Looked to me like I would use the crystal reports viewer web control for this, but it looked like ...Show All

• SQL Server SSAS Poor resource usage

  Our users use Excel 2003 pivot table to analyze data on our SSAS 2005 database. They experience poor performance as soon as the products dimension is involved (800.000 leaf members), query performance is worse than with AS2000. At the same time, we notice that msmdsrv.exe only occupies 350 Mb of memory at the peak, and only 25% of processor time (bursts above 25% of processor time do occur, but are extremely rare). This is on a dual-core x64 Opteron, effectively a 4-way processor, with 16 Gig of memory. Why is msmdsrv waisting time constantly allocating and freeing-up memory at the 100 to 400 Mb level, where we have about 12 Gig of memory on that server sitting idle How can we make msmdsrv aware of those available 12 Gig and 7 ...Show All