anomolous's Q&A profile

• Architecture Looking for database design patterns

  Hi all, I am looking for some good references or guidance on database design. Some of the issues I would like to research include: Storing hierarchies. From what I can gather there are 3 main ways to do this. Storing graphs. By this I mean graphs with vertices and edges, not graphics or images. i.e. see http://en.wikipedia.org/wiki/Graph_theory Recording and reporting on changes to items over time. Through, for example, History tables or using Insert-only tables. Custom item types. The ability for customers to define their own types of items. Custom metadata. Ability for customers to add fields to items. Some ways I have seen to do this include: extension table per type, store custom data in an XML ...Show All

• SQL Server How to launch a dts 2000 from Framework 2.0?

  Either c# or vb samples are welcomed. Thanks in advance, What issues do you have You can simply call DTSRUN.EXE to execute the package. Or you can use the object model - the usage is well documented in SQL 2000 books online, the VB code with minor changes can be used in VB.NET; you need to reference "Microsoft DTS Package Object Library" COM type library just like you would do in VB. ...Show All

• Windows Forms Loop capture image and generic error occured in GDI+

  I've application to capture video of image and grab the still image. It runs well untill I put loop to regrab the still images many times automatically.. and the error (generic error occured GDI+) happend. For your information, I also run different code of application that have similar function which to capture the image repeatedly that I found from internet. However, it give the same error message. I think maybe I've to setup something in the configuration but I still blur about it. I'm using C# Express edition. Could anybody help me please... Hi, This could be the solution. Try releasing the resources of the bitmap you are using in the OnCaptureComplete() method, and to do this correctly you should pass a new bitmap to you ...Show All

• Visual Studio SubReports & Streams

  I cannot get a subreport to work when I am loading my report via Stream. The SubReportProcessing event does not fire unless I load using the ReportPath property. Is this a bug or by design Nobody has any info on this This is a big setback for me. I am converting from Crystal Reports and the only way I see to be able to do several reports is using SubReports. I don't think using the ReportPath option will work for me. Anybody have any insight to this Also, MS I am wondering if this is a bug or not. If it is a bug I need to get it escalated, if not I need to submit an enhancement. ...Show All

• SQL Server SSAS shows incorrect data

  Hello, I have the following three tables (fact & dimension) sales, (dimension) manager and (dimension) salesperson The sales table looks like this: Date, amount, m_id, sp_id Where m_id = manager ID and sp_id = sales person ID I have set up all relations correctly and calculated the cube without any errors. What will happen is that the manager of sales person 1 will change during the year. So when you want to have report you want to see that person 1 has sold so much for manager A and so much for manager B When I am browsing the cube, I drop the (measure sales) amount in the detail section. I drop the (dimension sales) m_id in the columns and the (dimension sales) sp_id in the rows. I get the correct data back. Now I c ...Show All

• SQL Server Service Pack 1 for Express Edition with Advanced Services?

  Will Microsoft SQL Server 2005 Express Edition Service Pack 1 work with Microsoft SQL Server 2005 Express Edition with Advanced Services or is there going to be another version of Service Pack 1 Hi, SP1 is slipstreamed within the products.Make sure you move your database to the SP1 with Advanced Services, this can be download from here: http://msdn.microsoft.com/vstudio/express/sql/download/ HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Express Editions Whats the code for Shutting down logging off and othe similer functions

  Whats the code for Shutting down logging off and othe similer functions To shutdown the machine - the following should work Shell ("shutdown -s -t 00") To restart windows use the following : Shell("shutdown -r -t 00" ) You can use process.start instead of shell. ...Show All

• Smart Device Development Displaying version information of an application dynamically in vc++

  hi Everyone, I have a smart device mfc (vc++) dialog based application. I have a requirement of displaying the version information of my application (exe) dynamically. Could anyone guide me as to how i need to go about it I have seen something like version in the .rc file of the application. Can I use it to my benefit thanks in advance cheers Regards Kulkarni The version information is a part of the resource data. You can edit it in Visual Studio Resource Editor (double-click on .rc file in your solution) To read it programmatically use something like: DWORD dwHandle, cbSize; cbSize = GetFileVersionInfoSize(" \\Path to your executable " , &dw ...Show All

• SQL Server SQLServer dll's disappeared

  When I removed/re-installed SQLServer 2005 (Express) all of my dll's related to SQL Server disappeared from C:\ProgramFiles\Microsoft SQLServer\90\SDK\Assemblies:  .ConnectionInfo, .Smo,.SMOEnum,.SQLEnum,.WmiEnum that I know of - maybe more.  How can I re-install these   Are they in the SQL kit, VB, SDK Any help would be appreciated.          If you need the SMO package and in common the feature pack you can use the following link: http://www.microsoft.com/downloads/details.aspx FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Need help with a query 2

  My last post was perhaps unclear. So we will start all over again. I have a table with four columns. Guid Saleid icecreamType icecreamflavour It contains several rows of icecreams 1 A GB Glace null 2 A GB Glace chocolate 3 A GB Glace null 4 A GB Glace vanilla 5 B Ben & Jerrys null If the icecreamflavour-field is null this means the sale is for all flavours. If I SELECT * FROM Icecreams WHERE icecreamType ='GB Glace' I will get four rows. I would like it to return only two: 2 A GB Glace chocolate 4 A GB Glace vanilla But in the case (id= 5) where there is no data in the icecreamflavour field I want it to return that row anyway. Select ...Show All

• Visual Studio Team System Visual Studio Team Suite, 180-day trial version - Visual Studio Tools for Office

  I am having trouble with a part of the Visual Studio Team Suite free trial. I downloaded and installed Visual Studio Team Suite and now am trying to use the Visual Studio Tools for Office (VSTO) with Access to try creating a RunTime Access DB. I see the VSTO package was dowloaded (I see the files in Windows Explorer), but the packaging wizard is not appearing anywhere. Any advice Thanks in advance!!! ...Show All

• Smart Device Development how to ensure xml file is deployed to device emulator

  Hi I'm running the windows mobile 5 emulator within VS 2005 (vb). My compact framework application uses a text file to load some xml. The problem is I don't know how to ensure the text file is deployed to the device (emulator) at run time - currently I keep getting file not found error. Any advice appreciated. Cheers Kenny Add that file to your project, set build action to “Content” and set condition to “Always” or “Copy of newer”. For production deployment add it to your CAB file. ...Show All

• SQL Server SQL Server 2005 JDBC Driver Output Parameter/Result Set issue

  I'm having an issue with the JDBC driver when I execute a stored procedure that both has a return value and also returns a result set. If I attempt to retrieve the return value (registered as an output parameter) after I execute the stored procedure, then any subsequent attempts to retrieve the result set always return null. Is this by design If I use the result set first and then later get the return value that works; however, in my situation I need to first check the return value before I work on the result set. Am I'm I doing something wrong Code: CallableStatement cs = connection.prepareCall("{ = call spGetCustomer( , ) }"); cs.registerOutputParameter(1, Types.INTEGER); cs.setString(2,"blahblahblah"); cs.setB ...Show All

• .NET Development how to save data based on listbox selection

  Dear All, I am bit new to this programmming world. Currently i am making web application using C# ,asp.net and sql. in a web page there i have listbox with multiple selection option. now with single option i am able to save the form data. but problem occur when there is multiple option. as i am confuge with how can i based on selection (no of selected data). i can save the record. please guide me. Actually there is agent master where i need to capture or display agent name, Services he provides(listbox with multiple select option) and which branch he belongs to corresponding to agentid. Fine . Now One agent can provides any no. of services. so i have provides listbox with multiple select option. i need to save all this information. my p ...Show All

• Smart Device Development Resume from standby

  Hi to all, i made an application in C++ for pocket pc that allow the user of pocketpc to set a timer . When the timer stop, the application play an alarm. I have that problem: if the operator turn the pocket pc in standby mode, the application is freeze. So i need 2 things: 1) Allow the application to run in background when the pocketpc is in standby mode 2) when the timer finish, WAKE UP the pocket pc from standby and play alarm. How i can do that Thanks for any help. Muze ...Show All