Igor Grozman's Q&A profile
SQL Server don't select * but...
Read it at this link http://blogs.conchango.com/jamiethomson/archive/2006/02/21/2930.aspxthat selection from dropdown is equal to Select * . I agree but how do you not select AS400 library from dropdown Also i have not see any other place to supply a query other than Execute Sql task . kushpaw kushpaw wrote: Read it at this link http://blogs.conchango.com/jamiethomson/archive/2006/02/21/2930.aspxthat selection from dropdown is equal to Select * . Actually, the point of that blog post was that they are NOT the same. kushpaw wrote: I agree but how do you not select AS400 library from dropdown Also i have not see any other place to supply a query other than Execute Sql tas ...Show All
Visual Studio 2008 (Pre-release) Setting Width and Height of User Control
Hi , How can I set the Height and Width of a User Control so that it increases or decreases depending on the height and width of the parent control. I have created a Custom control with a Canvas and placed this control in a Tab Item. I am unable the set the Width when I resize the Tab Item (this is again in a Grid Splitter). I tried using the ActualWidth Property .. how ever that value seems to be NaN. Thanks for the help. Thanks Lee and Wolfgang for looking into this. This sample works well when I try to access the ActualWidth and ActualHeight from zamal but the ActualWidth and Height values return zero when I try to access these properties programatically. I have a repro for this, how can I upload thi ...Show All
Silverlight (formerly WPF/E) WPF/E Export: Text as Path, how to change?
Hi, why isn't it possible to export text as an WPF/E XAML Text element. I currently get all my text exported as a path instead. I'm missing something Michael We're currently working on improved tooling for WPF/E and I realize it's painful where we are today. The workflow I usually use is to do the rich graphics in Design then switch to Blend for the WPF/E XAML (including the text). It's painful, but possible to structure your XAML in a way that the WPF/E XAML is WPF compliant, or you can do some design in a WPF project and copy chunks of XAML into your WPF/E project. Hope this helps and sorry for the painful workflow, we're working on it! ...Show All
Windows Forms System.IO.FileNotFoundException In Windows Application
Hello! I have developed a windows Application using VS2003 (VB.NET) to enable my client to export Crystal Reports 8.0 to PDF,HTML and Excel formats. Since the Excel export that comes with VS.NET is not very user friendly, I used Interop.CRAXDRT.dll reference to export the reports to Excel. The application workes fine on my workstation, but when the client installed it, he is getting *** System.IO.FileNotFoundException: File or assembly name Interop.CRAXDRT, or one of its dependencies, was not found**** error. I have tried everything I can think of to resolve this in vain. The interop.craxdrt.dll is in the application bin folder. I made the client copy the file to his system32 folder. Gave the application folder full control permissio ...Show All
Visual C++ In vc2005, How can add Mappoint control to my project, do i need to download a Mappoint control and register it ,is it a Active
In vc2005, How can add Mappoint control to my project, do i need to download a Mappoint control and register it ,is it a ActiveX control You can use the #import statement to create a wrapper for the ActiveX control by the compiler. Read about the #import statement in the MSDN. http://msdn2.microsoft.com/en-us/library/8etzzkb6.aspx http://msdn2.microsoft.com/en-us/library/h31ekh7e.aspx ...Show All
SQL Server Transform SQL table data to XML
I have a Teams table in MS SQL that contains a hierarchical structure (tree) as defined follows: Table Team: (TeamID , ParentID, TeamName). Each row has a pointer to its parent row. I need to come up with an XML in the following format: <DTreeNodeOfOBSTeam xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance " xmlns:xsd=" http://www.w3.org/2001/XMLSchema "> <val> <TeamName>Team0</TeamName> </val> <Nodes> <node> <val> <TeamName>Team10</TeamName> </val> <Nodes> <node> <val> <TeamName>Team1001</TeamName> </val> <Nodes /> </node> <nod ...Show All
SQL Server Print Execution Results
Not a big deal but would be nice to print the execution results from BIDS. Looks like MS intentially won't allow you to print it. Any work-a-rounds other than screen shots thx R.K.S. wrote: Not a big deal but would be nice to print the execution results from BIDS. Looks like MS intentially won't allow you to print it. Any work-a-rounds other than screen shots thx No I don't think so. Not a bad idea tho. Why not request it at Microsoft Connect -Jamie ...Show All
Visual Studio Express Editions Troubles!!
I just downloaded Visual Basic. I am trying to open an executable but I get an error message that I have the wrong tools and what not. Please help and guide me on how to open an executable file in Visual Basic. Thanks in Advance. you could also use a .NET Reflector to reflect the assembly (.NET developed assembly) and view the code. Search for Lutz Roeder's . NET Reflector ...Show All
Visual Studio 2008 (Pre-release) .NET 3.0, SDK, and Cider installation experience, and which MSDN Library/Documentation to use...
Today I took the time to uninstall all my pre-RTM bits and upgrade to the latest official releases. I installed the following: .NET Framework 3.0 Runtime Components MicrosoftR WindowsR Software Development Kit for Windows Vista and .NET Framework 3.0 Runtime Components Visual Studio 2005 Extensions for .NET Framework 3.0 (WCF & WPF), November 2006 CTP First I spent significant time researching how to uninstall the previous versions. Surprisingly there are no specific instructions for how to do this, and the result is too much time being spent on my part. Oh well. By the way, don't use the Pre-released Microsoft .NET Framework 3.0 Uninstall Tool . Why See here: Updated warning - .NET Framework 3.0 cleanup tool removes MS ...Show All
Visual C# How to Retrieve dlls version?
Hi, My app (C# 2.0) used some dlls, some locals and some in GAC. For support, I need to retrieve the dlls version (local and GAC) and the dll file version. How can I do this To see the version number of the .dlls that are installed in the GAC you can use the Window's shell extension. Use windows explorer and navigate to c:\windows\assembly (or wherever your windows directory is located). It should show you a view that contains the entire strong name of the assembly, including the assembly name, version number, culture, public key token, and processor architecture. For the assemblies that aren't loaded in the GAC, you can use the ILDasm utility. Open the "Visual Studio 2005 command prompt" ...Show All
SQL Server Aggregation on monthly base
I need to create a report containing the headcounts of the employees for each month. The data I can retrieve from the database looks like this: Name StartEmp EndEmp tom 1/jan/05 15/mrt/05 dirk 1/jan/05 31/mrt/06 jan 1/feb/05 NULL In order to get the right information for the report the information should be represented in the following way: January 2005 February 2005 March 2005 "April" 2005 Tom 1 1 0,5 1 Dirk 1 1 1 1 Jan 0 1 1 1 HeadCount 2 3 2,5 3 (there should be more data in the 2nd table but it's a sliced repre ...Show All
SQL Server SSRS report runs and times out after stored procedure crashes.
I have a problem with reports on an SSRS 2000; a report appeared to be timing out, but investigations revealed that the stored procedure used by the report to retrieve data was erroring (divide by 0), but the report continued to run, and eventually time out despite this. I have corrected the stored procedure but would like to know if anyone knows why the report does not crash when the error occurs. I have tried creating a similar problem on SSRS 2005 and when the stored proc crashes the report stops and displays an appropriate error message. Any information you can offer would be great, thanks in advance. ...Show All
Visual C++ Language Problem
I have a probem.My Visual c++ Program is from itali.But i don’t speak italian. is it possible to change the language or can i get language packs please help me i dont want to learn italian!! thx thanks for answer! i dont know one day ive found it .it was within a game cover. but it is an orginal cd. sorry for my bad english but my nativ language is german is it possible to send links in here could you send me ...Show All
SQL Server Auto Number Sequence
How can I create a number sequence starting at a certain number and continue on for the number of records I have. For example I have 3000 records in my table and a field named I created called RecordId which I'd like to start at number 1 and goto 3000 (or maybe even start at 9000 and goto 12000 or however many records there are). In my pseudo SQL code Im guessing it would be something like... select * from Incident update Incident set RecordId( i=9000; i<=Number of Records in Table; i++) Whats the easiest way to do this A potentially more expressive function you could use in place of identity is the row_number. select row_number over( partiton by ... order by ...) + startin_numbe ...Show All
SQL Server Stored proc in cache Permanently
Does any body know a way to keep a stored proc in cache Permanently We have a very small query and some times the results are very quick and some times it takes up to 5 seconds, which is no big deal but our application and users demand right now results. (I just do what im told ha ha makes no sense to me.) if you are using SQL Server 2005, you could save a queryplan for the stored procedure. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All