MEW99's Q&A profile

• SQL Server Problem with Group By

  I have the following query and it's result is not according to my expectation. SELECT PaymentTerms, VendorCode , count(HeaderId) FROM Tbl_FPOHeader GROUP BY PaymentTerms, VendorCode Both PaymentTerms, VendorCode are NVarchar(50) and HeaderId is int type. I want the result to be sorted by PaymentTerms, but the result is Vendorcode. If i use Order By PaymentTerms it is working fine, but I would like to get by using group by only. Please help. Thank you. HI, data in entities is just an unordered set of data unless you use an order statement. So you will have to use an order by clause. if not you might or might not get the results (by accident :-) ) in the prefered order. HTH, Jens K. Suessmeyer. - ...Show All

• Visual Studio 2008 (Pre-release) date picker not available, someone already working on it?

  Okay, so I'll be the first to whine about this: it's been said in some video's and a few blog posts that there will not be a datetimepicker for avalon provided by microsoft. Is that true If so, is someone working on this / planning on going to work on it I'm probably going to need this pretty soon, and I think it's a bit too involved to just do myself. Regards Hello, Ruurd If you can descript your scenario in detail, it will help us a lot in developing a sample. Ji ...Show All

• SQL Server Can't Find ConfigEdit

  I installed the ConfigEdit XML editor mentioned in Kirk Haselden's great Integration Services book. But I can't use it unless I can find it! It's nowhere to be found in the Start menu or BIDS or right-click menus or inside projects. The book assumes you know where to go to open the editor. I'll be the first to eat crow if it's somehwere obvious. jaegd wrote: ConfigEdit installs to %ProgramFiles%\SSIS\Package Configurations Editor. I wouldn't call that obvious. The setup executable prompted me for the location to save it to... So, yes, it is obvious. Did you guys run (do you have) SetupConfigEdit.msi dated 12/27/2005 ...Show All

• Visual C++ Expanding struct/union (VARIANT exemple)

  Hi guys, I'm trying to understand how the struct/union of the VARIANT type is done. See file <oaidl.h> for VARIANT definition. I want to implement a more simple VARIANT type for my application, but I want the same behavior, i.e. if my variable name is var (VARIANT var), I want to be able to achieve both var.vt = VT_I4 and vt.iVal = 0. My problem is that if I do a struct like this, struct MYVARIANT { int vt; union { int iVal; long lVal; double dVal; } __MYVARIANT1; }; var.vt will be visible but not iVal nor lVal nor dVal ... how can I acheive the same implementation as the VARIANT type Thanks, P.A. You can use an unnamed union, such a ...Show All

• Visual C# *Newbie* Can Parameters be added to a textbox changed or leave event?

  Hi, I have sub classed a new text box class using the standard windows text box. I have been asked to add the following code to the text leave event so that my rules file when when the user leaves the control. (So that it will do this for every text box instance of this class). can i add parameters to the method, ie private void Textbox_Leave( object sender, EventArgs e, dataSet, RuleExecution) and how would they be passed in private void Textbox_Leave( object sender, EventArgs e) { if (null != ruleExecution) { try { this.ruleSetDataSet.RuleSet.Execute(ruleExecution); } catch (Exception e) { MessageBox.Show("Exception thrown \n" ...Show All

• Visual Studio Malayalam Support in .Net

  I heard that VS.Net 2003 does not have support for the local Language Malayalam. Does it have support in VS 2005 I have developed an application in vb.net 2003 with malayalam langauge support.This app is giving me an error that's related to culture id for Malayalam.Has it been corrected in VS 2005 Please help... ...Show All

• Smart Device Development bitmap to char*

  Hello, i m newbie i have got the IBitmapImage * but i want to convert it to image is there any method that convert ibi* to butter* or directly convert bitmap to image how i do it help me ASAP any stuff u know API ,articles,Forum etc imf->CreateImageFromFile(L "\\My Documents\\My Pictures\\PixSense.jpg" ,&img); imf->CreateBitmapFromImage(img,0,0,PixelFormat24bppRGB,InterpolationHintDefault,&ibi); Thanks in advance Regards Salman First of all, you've got to learn not to finish your every post with "help me ASAP". We are not here for your convenience. Using capital letters and punctuation also helps. Regarding your question - you already have IIm ...Show All

• Visual Basic Extended Euclidean Algorithm

  Read from message 4..   Here's the code that will accomplish what you are looking for: Function ModularArithmetic( ByVal Base As Long , ByVal Power As Long , ByVal Modulo As Long ) As Long Dim Result As Long = 1 Dim ExpCount As Integer = 0 Do While (Power > 0) If (Power And 1) Then Base = Pow(Base, 1 << ExpCount) Mod Modulo Result = (Result * Base) Mod Modulo ExpCount = 0 End If ExpCount += 1 Power >>= 1 Loop Return Result End Function Function Pow( ByVal base As Long , ByVal power As Long ) As Long Return CLng(System.Math.Pow(base, power)) End Function Do note that ...Show All

• .NET Development Accessing Indexers using Reflection

  Hi, How to access the indexers using reflection. I would like to get the values based on the index. Please help me. The following should work i think A a = new A(); // Get the indexer property of type int, in my case i needed to use Item for the property name PropertyInfo pi = a.GetType().GetProperty("Item", new Type[] { typeof(int) }); // get the item on index 0 pi.GetValue(a, new object[] { 0 }); Greetings, GJ ...Show All

• .NET Development FtpWebRequest GetResponse throw The server committed a protocol violation :(

  Hello. I have some trouble with FtpWebRequest class. I use it for connection to two ftp servers The first server is working perfectly, but when i use the same programm to connect to another one the "The underlying connection was closed: The server committed a protocol violation." exception is thrown when I call GetResponse method. I found only one difference between servers. The first server returns: 220 Hello k-net ftp server The second FTP return the same banner but ON RUSSIAN Lang!!! 220 ! ! Is any UseUnsafeHeaderParsing property exists for FTPWebRequest, like for HTTP P.S> I'am not using SSL! The sources is here: ///... FtpWebRequest listRequest = ( FtpWebRequest ) We ...Show All

• Visual Studio 2008 (Pre-release) Does LINQ appliable to SQL server 2000

  As many of our customer is using SQL Server 2000, can we upgrade our application to use LINQ Thanks. ...Show All

• .NET Development Visual Studio Upgrade???

  Hi all, I have the 1.1 Visual Studio and I am having trouble working with the new standard of 2.0 for Data Base communication. What can I do Thanks, JR Yes that is exactly my problem... what can I do... Does Visual Studio 2003 is built to upgrade to the new .NET 2.0 standard! ! ! JR  ...Show All

• Visual Studio Team System ReviewVisibleEventHandlers conflicts with Framework Design Guidelines if there's a security demand

  Hi, In Framework Design Guidelines, Section 5.4 Event Design (p. 135), it states: DO use a protected virtual method to raise each event. ... protected virtual void OnAlarmRaised(AlarmRaisedEventArgs e) { However, one of my implementations of the above has a linkdemand: [SecurityPermission (SecurityAction.LinkDemand, ControlAppDomain = true)] protected virtual void OnLoad (EventArgs e) { The linkdemand seems to trigger ReviewVisibleEventHandlers: "Warning 23 CA2109 : Microsoft.Security : Consider making OnUnload(EventArgs):Void not externally visible or ensure that it is benign code." If I remove the linkdemand, FxCop complains "OnLoad(Even ...Show All

• .NET Development Xml and the dreaded ampersand character

  I have 2 xml strings that are being generated in 2 different ways. String 1 is generated using the various framework classes (ver 1.1.) from the xml namespace (i.e. XmlNode, XmlAttribute, etc.). String 2 is generated using the GetXml() function on the dataset class. The framework xml classes will substitute the ampersand character (&) with &amp; automatically. However the GetXml() function on the dataset class does not. It returns the xml string with the actual ampersand character in the xml. Whats the deal Why does it perform the substitution in one area and not in the other Is there some way to specify to the dataset to perform the substitution. Right now I just call Replace() to substitute the values out Thanks for your ti ...Show All

• Visual Studio Tools for Office VS2005 SP1 to be used with VSTO2005 SE?

  hi, VSTO2005 SE is not explicitly mentioned in the release notes of VS2005 SP1 to be a "valid" VS-Version for this service-pack. Can/should this SP1 be used with VSTO2005 SE thanks Ewald ...Show All