pmsc's Q&A profile

• Smart Device Development GPRS Connection Setup in Code

  Hi, I was wondering if there is a way to configure a connection for GPRS on a windows mobile 5 device in code. I am having a few problems doing it through setting the registry as I can get the connection to appear under the Connections > Manage existing connections dialog but if I try and connect to the connection I am prompted for the username and password however I do not want this prompt to appear. I have been able to do configure the connection with great success for a windows ce 4.2 and pocket pc OS however it seems a little different for the mobile 5 device I am working ok. I do not want to import registry entries, I would like to be able to set the registry values in code, which is working as I get the connection in the required ...Show All

• .NET Development How do I add the ClassInterface attribute using ModuleBuilder.DefineType()

  I am using System.Reflection to create a dynamic assembly and I use ModuleBuilder.DefineType() to add an interface type and a class type. I want to add the attribute [ClassInterface(ClassInterfaceType.AutoDual)] to my class definition - but cannot figure out how to do this dynamically using the classes ModuleBuilder,TypeBuilder etc. Anyone know how I haven't verified it works but this should do the trick. //Your type TypeBuilder bldrType = new TypeBuilder (); bldrType.Name = "MyClass" ; //The desired attribute Type attrType = typeof ( ClassInterfaceAttribute ); ConstructorInfo ctor = attrType.GetConstructor( new Type [] { typeof ( ClassInterfaceType ) }); //The attribut ...Show All

• SQL Server Incremental Update

  Good afternoon, I was wondering if someone could help. I'm busy researching into SSAS's capabilities, specifically Incremental Updates, however this would be the first time I'm working on SSAS, so I don't know where to begin. I've read through the BOL July 2006, and it explains that you have to enable this option; however to me it's not very clear. I followed the steps outlined in the Book; however when I go and update the source table, the partition does not update automatically. Could anyone please let me know if there is a website detailing how Incremental Updates work, and also how to set it up correctly Thanks Colin. Hi Irina, I actually saw your book online the other day when searc ...Show All

• SQL Server Moving data to and from SQL Server 2005, with manipulation in C#

  Hi I am wishing to * take a table of data into a C# CLR procedure and store it in an array * take a second table of data into this procedure row by row, and return a row (into a third table) for each row (and this returned row is based on the data in the array and the data in this row). I am new to CLR programming, and pulling my hair out at the moment. I’m sure that what I’m trying to do is simple, but I am not making any progress with the on-line help and error messages L . I have now described what I am trying to do in more detail, firstly in English, and then in a T-SQL implementation that works (for this simple example). I’m looking for the C# CLR code to be returned – containing preferably two parts: ...Show All

• SQL Server Newbie - sa password error after ACT! install - Need pro's help!!!

  Hello, I am admittedly new to this, especially sql server and am in need of a pro's assistance.. I installed Microsoft Small Business accounting, which in turn installed and configured a sql server. When I installed ACT! 2005 (v7.0) and tried to create a database, it states that it cannot find the master file.... so I tried to install sql server from Microsofts site - downloaded all the packages, unzipped them and ran them... the error I get is that the sql server needs to have an sa password and to use some switch to change it... for the life of me I am lost here. I can't use ACT! at this point and I have not ideas of how to remove, reinstall or repair the sql server.... Any help you can provide would be greatly appreicated! Yes, it ...Show All

• SQL Server QA options

  Hello, In QA there are options for displaying results in TEXT, Grid or to a file. It is possible to lock these options so that only one is available. How is it possible to change it back to the default so that any of the 3 can be selected Hi there OldtimerMCSE, There is an option. From within SSMS go to Tools, Option, Query Results, SQL Server. There you can select the destination. Terrence Nevins SQL Server Program Manager ...Show All

• Visual Studio attaching Biztalk process Visual Studio is crashing

  Hello Bruce, When I am attaching Biztalk process Visual Studio is crashing. I really appreciate if you know any fix for this. Please reply to seshu.x.vutukuri@jpmchase.com Thanks & Regards, Seshu. Hi, apologise if i shouldn't write it here but i'm with a similar problem in similar enviorenment (VS2005, BTS 2k6). Each time i try to build any BTS project within any solution the process takes 100% of CPU processing. Although i expected for a long (the whole night) it didn't take any advance and the process seems hanged up. The BTS project within the solution has a folder and within the process i made a very simple process of requesting and sending files. I hadn't continue creating my orchestration due to the ...Show All

• Windows Forms Setting Currency format on a DataGridView

  Hi,   This question might seem very basic to most of you.  Not for me it seems...  How can I set the following currency format "$9,999,999.99" for one of my DataGridView column   I would also like this same column to be right justified.   By the same way, how can I set a TextBox control to handle currency number format    I already tried the MaskedTextBox control  but really don't like the "$ ________.__" allways showing because of the mask.  I would rather expect an empty textbox from start and then the number showing with the "$" at it's left as the user is typing it.  Am I dreaming  Any good trick or article on the subject Thanks in advanc ...Show All

• Visual C# Web Service Partial Class

  I just converted an application that communicates with the database via web services to VS2005. The conversion worked fine but I could not get the application to communicate with the web services. I kept getting a web method error. So, I decided to convert the web services to VS2005 as well. The conversion of the web services went well also. However, when I generate the proxy class through WSDL.exe, and add the proxy class to my application, it will not compile. The proxy class generated by the WSDL.EXE utility for VS2005 creates a Public Partial Class and the compiler doesn't like it. It throws an error for each of the three Public Partial Classes generated by the WSDL.EXE utility that states: Expected class, delegate, enum, interface, or ...Show All

• SQL Server Performance Issue with Count(*) query combined with exist()?

  I have been looking in to using the new XML column in SQL Server 2005 and noticed the following performance abnormality. I'm running the following query: select count(*) from XmlData where Contents.exist('/Person/Name/NameLast[.="Smith"]') = 1 The query should return 499,999 (there are 499,999 records in the XmlData table and this query matches them all). The problem is that the query takes 2:30 minutes to execute the first time. A bigger problem is that my Available system memory (as seen in Task Manager) goes from 460M to 80M while the query executes. The XML column has a Primary Index and a Secondary Path Index. In comparison, the following query returns in less than a second and requires no extra memory: s ...Show All

• Windows Search Technologies Elementary questions about Desktop Search - please help

  I installed Windows Desktop Search and cannot find adequate help documentation on a number of features. I have a Server 2003 Enterprise SP1 OS. Complaints: (1) Desktop Search replaced my Windows Search which I was familiar with. But it's much more complex to operate. (2) It's nice that it searches email, but the fact that it does so by default is a pain in the neck (3) The setup of desktop search is single-setup for all profiles. I have 4 people using this computer, and they should have different search setups, but WDS only allows a single one as far as I can tell. The single index for all profiles is stored in the "all users" profile. Let me know if you think this is not the case. (4) There is no documentation ...Show All

• Visual Studio Express Editions Desktop shortcuts

  I am creating my own setup program using VB Express and cannot figure how to create a desktop shortcut.I've been researching for a while both on the net and VB help but have found nothing. If any one has any ideas please reply. I have a related question, forgive me I'm not a VB developer.  I need to create a script that will look through all the desktop shortcuts for all the users of a PC and delete the ones that point to certain executables.  Can you show me how to accomplish that ...Show All

• Windows Forms About winform UI like options in vs

  I want to make a options window like option window in vs. when I click node in tree view leftside, the content on the right panel will changed. I get to way, one is use groupbox, the other is usercontrol. but I think all of them is too complex if there is a lot of options. Is there any suggestion thanks thanks all This my choice A designable PropertyTree for VS.NET ...Show All

• Visual Basic How do I set the row number of a DataGridView?

  psuedo code... set DataGridView1.row = i 'where i = 0 to DataGridView1.Rowcount Me .DataGridViewAnalog.CurrentCell = Me .DataGridViewAnalog(COL_NUMBER, ROW_NUMBER) I guess I can't just set the row.... DataGridView.CurrentRow is Read Only... meant to be used to retrieve the current row, but not set it.... ...Show All

• SQL Server Major alerts in SQL 2005

  Hi All, Does anyone know, how to produce Major alerts(Warning messages in alert log) in SQL 2005. As i understand from SQL 2000,All messages with severity 10<Severity>16, produce warning messages to eventlog but with 2005 all messges between severity > 10 are errors in eventlog and below 10 are informational messages Did anyone notice this difference ...Show All