hula_samvaad's Q&A profile

• SQL Server Help with SQL

  Hi, i hope i posted int he appropiated forum. I hope you can help me with an sql sentence i dont know how to do,... The problem is that i have a database with fields like this: name, adress, etc.... , phone number but sometimes, i get them like this: paul, ... street... , etc... , 776509332 paul, ... street... , etc... , 234536445 paul, ... street... , etc... , 567847345 The client si the same, but he has more than one phone number.... I need to do, somehow, another table that makes this kind of duplicates to dissapear, and joins the phone numbers in an unique field for that person, so it will in the end look like this: paul, ... street... , etc... , 776509332 234536445 567847345 Can anybody help me Thanks ...Show All

• .NET Development Setting/getting encoding property

  Is there any way to get/set the 'encoding' property of a DOMDocument With .NET the System.Xml.XmlDocument does not have a property named encoding (or Encoding). In general for the in memory DOM document encoding does not matter as the DOM simply exposes anything (element names, attribute names, text content) as an Unicode string (i.e. a sequence of Unicode characters). What should the encoding be if you build the whole document in memory with e.g. CreateElement/AppendChild With the .NET DOM model the XML declaration is modelled as a node of type XmlDeclaration and that node has a property named Encoding you could check e.g. XmlDocument xmlDocument = new XmlDocument(); xmlDocument.Load(@&q ...Show All

• Windows Forms ClickOnce doens't install application locally

  Hello ! I have an Winforms application that uses a component DLL and specific configuration by mean of app.config file. When I used ClickOnce to install the application on a client computer, a start menu item was added, but it seems that created shortcut points to the internet site where the installation resides. The application wasn't installed locally. I need to customize the app.config file to accomodate to client environment, but if the application is launched remotely, I cannot do that. Any help will be greatly appreciated Thanks Jaime Hi Lama, Sorry I might have misunderstood. I thought it never installed in your PC. Yes the application when it installed it always stores it under local setting under app and ...Show All

• Visual Basic Font differences between VB6 and .NET

  I am finding that the spacing between characters of certain fonts is slightly wider in VB.NET than it is in VB6. For instance, if I print a string with an Arial bold font in .NET, it takes up more space than the same string with the same font and point size in VB6. Any ideas why this might be happening I suspect that VB6 uses GDI. Try setting UseCompatibleTextRendering to true: http://msdn2.microsoft.com/en-us/library/system.windows.forms.application.setcompatibletextrenderingdefault.aspx Best regards, Johan Stenberg ...Show All

• Visual C++ Changing a constant with a pointer?

  [code] #include <cstdio> using namespace std; int main( void ) { FILE *out; fopen_s(&out, "test.out" , "w" ); const int a = 100; *( int *)(&a) = 200; fprintf(out, "%d %d\n" , a, *( int *)(&a)); fclose(out); return 0; } [/code] The code above prints 100 200 . Is that normal If so, why does it do that Looking at Assembly code produced by C++ compiler, I see that compiler uses constant value 100 instead of a variable: const int a = 100; 004113AE mov dword ptr [ a ],64h *(int*)(&a) = 200; 004113B5 mov dword ptr [ a ],0C8h printf("%d %d\n", a, *(int*)(&a)); 004113BC mov esi,esp 004113B ...Show All

• Visual Basic Richtextbox and Telnet Window Size

  I'm trying to build into an application some telnet emulation using VB.NET 2005. One of the options I need to cope with is the Window Size option, which equates to the 'output area' height and width. The 'output area' in question is a rich textbox where the font is configurable. I've noticed that a font has a height property, but I can't see a width property. Does anyone know how I can get the number of characters in height/width of the RichTextBox that can be displayed based on the Richtextbox height/width Any help appreciated! not sure if this is what you are looking for...but maybe it will help: Dim x As Integer = 1 Dim g As Graphics = Me . RichTextBox1 . CreateGra ...Show All

• Visual C# Why is there a PDB file in my projects Release folder?

  This is probably a deployment question, but there doesn't seem to be a deployment section in .NET Development Forum. I thought the PDB file was only for debugging purposes, so why is there a PDB file in my bin\Release folder What are the (dis)advantages of including this file in deployment It started happen in Visual Studio 2005 only, In Visual Studio 2003 it did never happen so the thing you can see that in Visual Studio you could debug assemblies only in debug mode but in 2005 you can also debug when its set to Release. Lets have more comments ;-) ...Show All

• Visual C# windows service running on particular time and debug.write() where it prints ?

  Dear All, I have windows service done with C# and able to be install using the installutil.exe. My problem now is that I want to set it like to run on particular time of day for instance 10.00 am daily How can I set this I have tried to use timer but it sets an interval only Another thing is that I have debug.write() in my windows service where can i check the output of the debug.write Where is the file Thanks. as I understand you have to. declare timer variable in class body. in OnStart method initialize Timer variable and add event handler to Elapsed event. Make timer enabled In this event hlandler do your work as you check for the time constraints  In OnStop method disable ...Show All

• Visual Studio Express Editions Webbrowser - need options - help needed

  Hey how can i make a option on a menu strip under file called work offline and what i need it to do is basicly turn the browser off so that i can't connect to the net like in Internet Explorer etc... also dose any one know how to get the favourites to work say if some one clicks on a button i need it to popup with a small window with there favourites in cheers. that cant be right as I've just done it and reading the docs as well as the tooltip description "Gets or Sets a value indicating whether the System.Windows.Forms.WebBrowser control is in Offline mode" can you show us exactly what you have coded for this and if you are using a WebBrowser control ...Show All

• Visual Basic Application setup wizard error

  when i start my application setup wizard I get the error "Invalid property type" it will then not run whats the problem here Have tried the install uninstall thing that does not good Thanks I have exactly the same problem than you... when I click on my "Application Setup Wizard" in order to create a setup program for my applications, I have the error "Invalid Property Value"... Can anyone help us Please... I have Windows XP and Visual Basic 5 Thanks... ...Show All

• Microsoft ISV Community Center Forums Can't Edit the View >> A working ArithAbort method

  Hi there im linking a view on an ms sql server to my access database using VBA using DoCmd.TransferDatabase acLink, etc.etc. How ever, I can NOT get the `Select Unique record Identifier` pop up to stop coming up when the link is being made. I dont care about needing a unique identifier, its a read only record source. The only way ive found is using sendkeys command to cancel the popup - however this can not be relied on, if it happens when the user doesn't have the access window in focus, it fails and the pop up appears. That pop up is way beyond many of my users to even press cancel and looks very unprofessional :) any ideas many thanks martin no good trying to add an index based on a view which ...Show All

• SQL Server SSIS package fails in a job - Currency Rates updater

  Ok so I created a SSIS package to get currency exchange rates from web service - http://www.webservicex.net/CurrencyConvertor.asmx . Everything works fine I can run it successfully - i uploaded to SSIS package store - runs successfully./ BUT when I put it in a job - it FREAKING fails every *dem time. In addition to run it the JOB as SSIS package from store - also straight from the File System = still same freagging error - and SQL 2005 has gotten more stupid than SQL 2000 & DTS - they provide no clue as to y you get an error Help please Sounds like it's a proxy issue. Does your development machine go through a proxy to get to the Internet Perhaps the server (where the package store is) can't connect to the Internet. Phil ...Show All

• Visual Studio Team System How to control policy evaluation?

  I have a custom policy that forces users to provide comments on changesets (standard example). The problem is that if it fails and after that user provides a comment policy doesn't evaluate again and has to be forced to do it. How can I track it and evaluate this policy after each change of comment Marcin Thanks for your clue. I will track comment text changes it is the most reasonable solution for that problem. Marcin ...Show All

• Visual Basic How to get context menu for webBrowser control

  I am using the webBrowser control to do ftp and this works great... When i right click on a folder in the browser window i am presented with the standard menu items.. I have alredy worked with the ShellAPI and have project that wraps a treeview so that i can get the shellFolder that is assoisated with the treeNode...The code below is what i use to get the context menu for a shellFolder. I would like to get be able to capture the context menu and add items, then handle the commands with the system.windows.forms.webBrowser.. how do i capture the context menu so that i can add items.. thanks erik public static bool GetIContextMenu( IShellFolder parent, IntPtr [] pidls, out IntPtr iContextMenuPtr, ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. problem under "less than pixel shader 1.1" environment / can't use REF ?

  Hi all. I'm using poor notePC having Intel 865 Graphics Chipset. This one doesn't support pixel shader 1.1, so XNA Template(NewProjects-WindowsGame) doesn't work well. Program stopped at game.Run(). I thought that ReferenceR asterizer (SoftwareShader ) can resolv this problem. So I write below codes, but program stopped at game.Run(). Moreover, I confirmed that graphics_PreparingDeviceSettings was not called. (I n debug_mode step execution, this function was not called.) Hmm...EventHander is called after CreateDevice by default DeviceInformation(required pixel shader 1.1) Are there any solution to execute XNA in "less than pixel shader 1.1" environmen Thank. void graphics_PreparingDeviceSettings(object sender, PreparingDevic ...Show All