CodeDjinn's Q&A profile

• SQL Server Email subscriptions: changing "from" address for different subscriptions on same server

  I doubt this is possible, but can someone think of a way to change the email address used for sending report subscriptions based on the report or subscription It's a need that I've heard from a number of different clients. Scenario: a company has one reporting services server with reports running from numerous departments. Report subscriptions are sent to internal and external email addresses and there's a business need to use different "from" addresses based on the report (or audience). Unfortunately this isn't really possible without doing some messing around. You can make a call to the RS WMI provider to change the SenderEmailAddress value, but you would have to synchronize the code making ...Show All

• Visual Basic Does VB.NET support DDE-link to another windows applications

  Hi there, I want to establish a DDE- connection with a windowsapplication by using Vb.net Is this still possible or do i have to use VB6 ( which i dont have) Thanks ! No, DDE is retired. You might be able to pick up a Visual Studio 6 license at an auction site. ...Show All

• SQL Server Does MS plan a GUI

  Hello all, We are planning to base a product on Microsoft SQL-2005 Notification services. However, one of the required properties from this software is to provide the client administrator a user interface to configure the Instance Configuration File (ICF) and Application Definition File (ADF). Working with XML files will not do for us, once the responsibility is delegated from a developer to an administrator. Before going into the process of writing such an application from scratch, I would like to know if Microsoft has such an enhancement on the SQL-NS roadmap, and if so, when it is scheduled to. Does anyone have any thoughts or knowledge Thanks Ziv G. Hi Ziv - ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Creative Club Member Website

  Is there such a thing And yes, a search in our forum returned no results. Odd, there's a lot though regarding something called DBP - what ever that is. No, there isn't an exclusive site for CC members. DBP refers to the www.DreamBuildPlay.com ...Show All

• SQL Server How to add a trend line, equation and r-squred value to (XY) scatter chart using SQL Reporting Service 2005?

  I had no problem to add a trend line, equation and r-squred value in Excel. But couldn't find the same functionalities in SQL reporting service 2005. Any helps would be appreciated. Thanks. Kelly ...Show All

• Visual FoxPro Report strategy

  Hi everyone; I am going to develop quite a few reports for a customer. They want to develop a report engine that would let them customize reports both in the scope and in the format of the report. I am wondering if I should use a third party product like CR. Can someone give me some pointers ergarding the benefits of using CR or other reporting engine, and also how difficult is it to incorporate such reports into my application, and letting users customize reports Thanks. Aleniko, I would suggest CR yes. It's great - easy to learn and use. As far as customization - that kind of depends on what it is your customers are willing to do to customize it. I use CR for reporting, but I'm ...Show All

• .NET Development Validating xml with xsd problem.

  Hi all, I am trying to validate an xml document which has been created in the dom. Once it has been saved it will validate fine but I need my application to work without any files being physically saved. Below is a example of what I am trying to do: SCHEMA: < xml version="1.0" encoding="utf-8" > <xs:schema xmlns:xs=" http://www.w3.org/2001/XMLSchema " xmlns="urn:Schema" targetNamespace="urn:Schema" elementFormDefault="qualified" attributeFormDefault="unqualified">  <xs:element name="root">   <xs:complexType>    <xs:sequence>     <xs:element name="element">      <xs:complexType>      & ...Show All

• Visual Studio Express Editions vb excel align

  Hi. I was looking for an answer to that question for quite awhile. How can I center text in excel using vb. I was trying Dim xlws As Microsoft.Office.Interop.Excel.Worksheet = oWorkbook.Worksheets.Item(1) xlws.cells.HorizontalAlignment = xlcenter but it doesn't work Pseudo Code.... Dim xl As New Excel . Application Dim xlWkbk As Excel . Workbook Dim xlSheet As Excel . Worksheet xlWkbk = xl . ThisWorkbook xlSheet = CType ( xlWkbk . Sheets (1), Excel . Worksheet ) xlSheet . Range ( "A1" ).Select() xlSheet . Range ( "A1" ). HorizontalAlignment = Excel . XlHAlign . xlHAlignCenter ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. A few XNA questions.

  Now with XNA will you be making the game right in XNA, or do you like make it with another program using different code and then just use XNA to make it playable on the 360 Thanks! Jim Perry wrote: Correct. You use XNA GSE to code (on your PC) and debug (remotely on your 360 or on your PC for a Windows version) your game. The assumption, I believe, is that you have a network in your house that both your 360 and PC are hooked up to. yupp. Got a network and a wireless router and bridge for my pc and 360. Ok, thanks alot for all of your help. Just one more question, what is XNA "GSE" Thanks! ...Show All

• .NET Development SourceTable and SourceField

  Hi I'm upgrading my code based on DAO to ADO.NET in VB2005 and got stuck looking for SourceTable and SourceField properties of DataTable fields. DAO.Recordset.Fields have .SourceTable and .SourceField properties which tell you the original table/field which provides the data in that particular field of the recordset. This is useful in my application where I am filtering users' queries to the database to see whether I want to allow them access to that particular bit of data.  Although I can imagine that there are maybe other solutions to security issues, I've already built a whole system around this method, and would like for simplicity's sake just upgrade it without changing the methodology. Can anyone advise where to g ...Show All

• Visual Studio 2008 (Pre-release) Very simple projection question partial retrieve

  Say you have a query like below: var q = from c in ctx.Contact select c; foreach (Contact item in q) { .... } If you run that, the sql provider retrieves all columns from the table that's mapped to Contact. What would be the simplest way to grab only certain columns but still keep the type as Contact Here's my attempt: var q = from c in ctx.Contact select new Contact { FirstName = c.FirstName, LastName = c.LastName }; So I am basically, recreating the same object but only populating certain properties. This, when I examine the generated query, is doing exactly what I want. However, I was wondering if there was a simpler, perhaps more efficient - my approach seems to me like it's creating one redundant object ...Show All

• Visual Studio Team System SQL Server requirement

  Please, explain me the database requirement during DB Pro work. Am I right that it's necessary to install SQL Server (i.e. SQL Express) to work with DataDude What does it do during it with databases Thanks To me this defeats the whole purpose of the product. Why should I have to install a local copy of SQL for this to "validate" when I already have development and test servers This makes absoluetly no sense to me. Someone please explain the retionale behind this. Why should I have to pay for yet ANOTHER SQL SERVER LICENSE to use this product Also, why do I specifically need to have Enterprise or Developers Why doesn't Standard or Express version work ...Show All

• Windows Forms display msi path

  Hi, I want to display msi path from where it is running. For example my msi is in "c:\msifolder\test.msi".and when i click on msi.after initial dialogs,it should display "c:\msifolder\test.msi". Thanks If you're talking about getting the path to the MSI file from a custom action, you'd pass the OriginalDatabase property via the CustomActionData property to the custom action, case-sensitive. You'd put [OriginalDatabase] there, in brackets. It's not clear what you mean by "it should display". ...Show All

• .NET Development TableAdapter missing the update method

  Hi all, I am trying to call the update method of my table adapter that was automatically created by dragging the table from data sources view. However, it appears that the update method doesn't exist Only Fill and Getdata. Even on single tables this happens Is there a known bug here. I am currently using VSTO 2005 and excel and it is extremely frustrating! I have followed this code (using my database instead of northwind) and no update method on my tableadapter http://msdn2.microsoft.com/en-us/library/4esb49b4.aspx Cheers Damien 1. Open the dataset designer 2. Right click on the tableadapter with the missing command and click configure. 3. Hit next and check the third option which will gener ...Show All

• Visual C++ Compiling sourcecode written in vc++ 1.52 in vc++6.0

  Hello every body. I am quite new to vc++ arena. I have an application written in vc++ version 1.52 ( very old version 16 bit Dos ) and the application is deployed in client machines. Is it possible to compile the same source code in VC++ 6.0 Or I have to compile the source code in vc++ 1.52 only to give patches to the user I am getting lots of compilation errors. I would appriciate if anybody can guide me. Thanks in advance Since your original app is 16-bit DOS, you really can't write a patch in VC6 since it doesn't support 16-bit DOS. You could write the patching app in VC6, but the actual binary changes have to be compiled in 1.52. ...Show All