vijil's Q&A profile

• Visual Studio 2008 (Pre-release) (405) method not allowed after migrating from RC1 to RTM

  Have just migrated simple web service wrapper application that is WCF hosted under IIS from .NET 3.0 RC1 to .NET RTM. Under RC1 an http request to "service.svc" returned a nice HTML formatted page "You have created a service" because my declaration had the required meta documentation tags specified. Under .Net 3.0 RTM I am now simply getting the two Page declarations that comprise that service.svc file More importantly the service itself is not working - requests are returning an error (405) Method Not Allowed. has something changed between RC1 and RTM that I need to be aware of Stack trace is shown below: Stack trace: Message The remote server returned an unexpected response: (405) Method Not ...Show All

• SQL Server SSRS -- Data Driven Subscription and Pivoting for Dynamic Parameter Mapping

  Hi, For the Data Driven Subscription in SSRS we are using the following stored procedure In Step 3 - Create a data-driven subscription create procedure spRSGetReportSettings ( @ReportID as integer ) as begin set nocount on declare @t as table ( y int not null primary key ) declare @cols as nvarchar ( max ), @y as int , @sql as nvarchar ( max ) set @cols = stuff ( ( select N ',' + quotename ( y ) as [text()] from ( select ParameterName as y from Reportsettings where reportid = 1 ) as Y order by y For XML Path ( '' )), 1 , 1 , N '' ); set @sql = N 'select * from (select reportid,parametername, ...Show All

• SQL Server Checking to see if a record exists and if so update else insert

  I've decided to post this as a sticky given the frequency this question is asked. For those of you wishing to build a package that determines if a source row exists in the destination and if so update it else insert it, this link is for you. http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx Thanks Jamie! If you want to do a similar concept to Jamie's blog post above, but with the Konesan's Checksum Transformation to quickly compare MANY fields, you can visit here: http://www.ssistalk.com/2007/03/09/ssis-using-a-checksum-to-determine-if-a-row-has-changed/ Phil This is very helpful. Thanks! I am completely new to the SQL Server Integration Servi ...Show All

• SQL Server Importing data from one source in two destination tables linked by a foreign key

  Hi, I have a new problem when I import data from an xml source file in two destination tables. The two tables are linked by a foreign key... for example : table MOTHER (MOTHER_ID, MOTHER_NAME) table CHILD (CHILD_ID, MOTHER_ID, MOTHER_NAME) After a lot of transformations data are inserted into MOTHER table and I want to insert other fields of the data flow in CHILD table. To do this, I need the MOTHER_ID field that is auto incremented in MOTHER table. My problem is to chain the insertion in CHILD table after the insertion in MOTHER table to be sure that the relative row in MOTHER table is really inserted. I haven't find any solution to chain another transformation task after my flow destination "Insert into MOTHER table& ...Show All

• Visual Studio 2008 (Pre-release) Link May 2006 not install

  The LINQ Preview (May 2006).msi doesn't find any Visual Studio 2005 installed when Visual Studio is french version. I've got Visual Studio 2005 Pro French Version with Cpp and CSharp installed and Framework .Net Sdk 2.0, but the installer cant't find any visual studio products installl !! It asks me to install Visual Studio Express !! (Windows XP Pro Sp 2, Sql Server 2005 Express and got yet Visual C 6.0 cause simple as Visual Cpp 2005 for Cpp developpement). Dvpt Uml Installing on a non-english version of VS is a known issue. See http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=395991&SiteID=1 for a command line work-around to the issue. Jim Wooley http://devauthority.com/blogs/jwooley/default.aspx ...Show All

• Visual Studio 2008 (Pre-release) arbitrary column ordering when invoking Sproc

  hi, i'm using SqlMetal and binding a gridview to the return value of one of the sproc generated methods. it works fine, showing a bunch of records. However the column ordering in the gridview appears to be arbitrary, and is very different to how i have them defined in the sproc. i know i could run a linq query on top of the results selecting them into a new dynamically created class, but that isn't really an option because i'm reflecting the name of the sproc method and wouldn't be able to figure out the correct ordering. am i doing something wrong or is this behaviour normal for completeness sake, i'll include all the relevant bits of code: here is the code to bind the gridview (using autogenerate columns): this.GridView1.DataSource = ...Show All

• Visual Studio Tools for Office Outlook Macro - send email separately to multiple contacts?

  Hi, I'm trying to write a macro for outlook 2003 to send email different contacts separately that means when some person receives the email, they will see their email address in the To section. Currently if I use BCC, the person will see the same email adress for From and To. Do you know how to write codes to connect to the"new message" windows in outlook and all the controls in that windows Thanks. well, the reason I'd like to use outlook objects because I want to take advantage of the htmlbody. If I use system.net.mail, I'll need to write a text editor for my app. Assume that I compose the message in Word and then copy and paste the content to the text editor, which would be a Ric ...Show All

• Visual Studio Team System Using MSTest instead of NUnit

  I've been using CruiseControl.NET for a while with NUnit for unittesting and NCover for coverage statistics. However, after upgrading to the VS2005 Team Edition, I would like to use the MSTest suite instead, but I haven't been able to modify my MSBuild script to do this. < ncover workingDirectory = " . " program = " ${ncover.path} " commandLineExe = " ${nunit.path} " commandLineArgs = " ${nunit.project.path} /config=${build.config} /xml=${output.dir}\nunit.log " coverageFile = " ${output.dir}\ncover.log " logFile = " ${output.dir}\coverage.log " failonerror = " true " > < assemblies basedir = " . " > < include name = " **/${application.base.namespace}*.dll " /> < exclude name = " ** ...Show All

• Visual Basic Exception Handling

  Hi, I am wondering as to what is the best way to handle exceptions when in a .NET InterOp form and need to throw them. How can I catch these exceptions in the VB6 environment. I am using VS 2005 PRO. and the InterOp ToolKit 1.0. In essence, if an error occurs in my .NET InterOp form, I'd like to Throw it to my VB6 client so that it can catch it and display a messagebox. What is the best practice or does someone have some sample code. There are a variety of ways of handling this. Here's a couple of options... 1) If you have an unhandled error in a winform, you can just let winforms default error handler do it's thing (basically, the user will get an error dialog that says an error has occurred ...Show All

• Software Development for Windows Vista Technology used in windows vista

  Hi! Please help me out to know that what is the technology/ language used to develop windows vista This is urgwnt. Please do reply to this post. mainly C/C++ and a tad of .NET Development I believe and Assembly (machine code) different languages have been used to develop the Windows OS overall...not just 1 specific ...Show All

• Software Development for Windows Vista Windows WF installation requirements

  What are the requirements for developing Windows WF applications It lists Windows Workflow Foundation Runtime Components as a requirement but I cannot find this anywhere. I assume this is a subset of fx3.0 runtime components. Do I need to install fx3.0 Do I need to install the Windows SDK separately I ran the installer for Windows WF VS2005 Extensions but I cannot find anything that was installed on my machine. Are there any other requirements Thanks. Here is link that lists out what you need to install http://www.netfx3.com/blogs/news_and_announcements/archive/2006/11/06/.NET-Framework-3.0-has-been-released_2100_.aspx HTH Pradnya ...Show All

• Visual Studio Express Editions Starcraft As Resource?

  Hello My Purpose: Make a login for starcraft to limit my brother's time playing starcraft What I already know I can put 'starcraft.exe' as a resource Call 'starcraft.exe' from resource to run it What I need to know Can I call starcraft.exe to run it as if the file was just there without being a resource What I want to do Make a login program and handtype (in cleartext) in the code such as If userID.text = "ID" Then 'call starcraft.exe from resource' End if and the starcraft.exe only launches if the user enters the right password and user combo The reason that I want to put 'starcraft.exe' into resource is because even my 11-year old brother knows how to get into the Programs File then just manually launch 'starc ...Show All

• Windows Forms Databinding, does anyone use databinding for commercial applications?

  I'm running into this same problem: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=356806&SiteID=1 Databinding seems useless. The idea of the disconnected data model is a really difficult process, mainly because of relational databases. Many of my tables have identities, and if multiple people are hitting the database at once, there is no guarantee that the identity generated in your datagrid is going to be the same when you actually submit the in memory dataset to your database. This makes it a real pain to update related records. Can anyone shed some insight on complex databinding with identities and relationships Perhaps, someone has some good documentation on some methodologies used to create windows forms applicati ...Show All

• Visual FoxPro delete record

  when you are in data entry screen and i want to delete the record. In parent table i already delete the record but in child table i was'nt able to delete. help me. thanks Sir, if u are very new (like me) to advanced visual foxpro programming and dont know how to use triggers, constraints and all and if ur table structures are like this then u can try this. master table order no orderdate itemcode soldqty tran table order no itemcode itemname soldqty and for every one order in your master there are multiple items sold and records exist in tran table then code to be executed when delete push button is clicked sele a use master set orde to orderno seek m.orderno &&orderno that u w ...Show All

• Windows Forms textBox Question

  is there a way to allow only ' a-z A-Z 0-9 ][{}()-* ' characters to be typed into a normal textBox the MaskedTextBox wont work in the way that i want it too. Im using VC++ 2005 thanks no still not working, ive seen similar code for doing this somewhere but i cant remember where although it may have been the same code. maybe someone out there has a solution to this mysterious puzle it doesnt seem to recognise the word ' Regex ' either so it could be that ...Show All