Syed's Q&A profile

• Microsoft ISV Community Center Forums Can a field result in a Query be formatted as a hyperlink?

  I'm struggling with outputting a result field in a MS Access 2003 query. Need to output the field as a hyperlink. I've properly constructed the destination URL and the hyperlink target, but cannot get MSA2003's query for format the field properly. Hi, I don't think what your looking for can be done without changing the data type of the field to hyperlink in the table. You can do simple data type conversions from Integers to Strings in queries using CInt, CStr, etc, but there's no CUrl. You could try displaying the field on a form in such a way that it acts like a hyperlink. Hope that helps ...Show All

• Visual Studio Tools for Office Pivot table using c#

  Hi, I am trying to create PivotTable in Excel from c#, I get to the point of creating the table but I am not able to specifi what will be the RowField or ColumnField etc. and format those data, I have written it earlier in VBA but I want to convert all my application into VSTO using c#, is there any example code for creating Pivot Table using C# by opening up an instance of Excel and then a particular workbook and then a particular worksheet in that workbook (because the data for the pivot table resides there). Thanks The full code for the funtion is as follows; public void stgPivot() { Xl.Appli ...Show All

• .NET Development Typed Dataset Questions

  1. Is there any good and in-depth tutorials on typed dataset It will be great if the tutorial is able to solve the following problems. 2. How to add new row using typed dataset 3. How can I handle the identity column in typed dataset 4. How to use transaction together with typed dataset 5. Any other design consideration on using typed dataset 2. As you would in untyped or use the strong typed method New[RowType] where RowType is deduced from datatable name. Also, don't forget to add newly created row to rows collection using Rows.Add(..) 3. What do you want to handle Just set it as AutoIncrement=true. 4. As you do wit ...Show All

• Visual Studio classic chm Help doesn't link to MSDN Library

  on new PC, reinstalled VS and Library again, but links to commonly inherited NET members like "string" display a Page Not Found error, yet the help 2 versions work in VS and in H2 Viewer... is this a registry problem does this relate to MS article 827054 or 318945 thanks multiple ones, this used to work on my PC, seems to work on others, but does not work on my new PC, even after resinstalling VS.NET and MSDN Library... ...Show All

• Software Development for Windows Vista Custom EventSinkActivity

  Hi all, I'm trying to create a custom EventSinkActivity. But I'm wanting to define the 'EventName' in the workflow (that the custom activity is going to live in). In my custom (sequential) activity there is a requirement to fill in the EventName property. Upon checking out some of the WWF samples in the SDK - I believe that this causes the runtime to create queues in the names of 'EventName'. My problem is I would like to set this property at a later date, not when I'm creating my CustomActivity (the WWF UI designer comes up with a big red ! telling me I must fill it in) I dont want to head down the path of 'Enquing items' to ...Show All

• SQL Server Rebuild index failed

  I scheduled a maint plan to rebuild index. All table's indexes are successfully built except for one table. The error message I got: Failed:(-1073548784) Executing the query "ALTER INDEX [Index_name] ON [dbo].[table] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = ON ) " failed with the following error: "Online index operations can only be performed in Enterprise edition of SQL Server.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set ...Show All

• Windows Forms databinding a classic form header and datagrid

  Hi, I want to be able to manually bind a standard parent-child dataset where my child data is in a grid. i'd like to be abble to move forward and backward to next and prev. header records and for the datagrids data to display according to the current parent row it's bound to. i can bind the grid by itself and standard controls by themselves&n ...Show All

• Smart Device Development genasm error message when adding DesignTimeAttributes.xmta to my project

  This is weird. I have a Smart Device C# library that builds perfectly. When I add a DesignTimeAttributes.xmta to it and rebuild it I got the following error message: genasm.exe(1) : error There was an error finalizing type . Type 'MyNameSpace.MyClass, MyLibrary, Version=9.2.0.0, Culture=neutral, PublicKeyToken=null' was loaded in the ReflectionOnly context but the AssemblyBuilder was not created as AssemblyBuilderAccess.ReflectionOnly. My Namespace is MyNameSpace. My library is called MyLibrary. I have tried to reproduce it on a small project and I can't. I will keep trying to see if I can narrow it down. Thanks in advance for helping. ...Show All

• Visual Studio Team System Can I install Sql 2005 June Ctp with Team foundation server?

  Can I install Sql 2005 June Ctp with Team foundation server No, you cannot. The TFS Beta2 is meant to be used only with the Yukon April CTP. (There have been changes in the Yukon June CTP which TFS needs to change to handle) Thanks, Amit ...Show All

• Windows Forms Date Time Picker

  Hi, Anyone know how to format the Date Time Picker in C# to shows MONTHS only Hi, Sorry, please allow me to ask more, can you guide me more details on how to traverse the list view items and create the loop Thanks. ...Show All

• .NET Development late bound resolution warning

  late bound resolution warning               Dim i As Integer             For i = 0 To lstAuthors.SelectedIndices.Count - 1                 iT = CInt(Me.lstAuthors.SelectedValue(i))                 tta.InsertQuery(i1, iT)             Next             On the line iT = C ...Show All

• SQL Server Strange out of memory error on 2005

  Hi, I am getting the following: spid53,Unknown,Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 262144 spid53,Unknown,Memory Manager <nl/> VM Reserved = 1662084 KB<nl/> VM Committed = 954940 KB <nl/> AWE Allocated = 0 KB <nl/> Reserved Memory = 1024 KB <nl/> Reserved Memory In Use = 0 KB ... <lots of memoryclerk/cachestore stuff) ... Followed by loads of 701s (There is insufficient system memory to run this query.) until the service is stopped. No new connections can be made at this time either. I'm running an ASP page under IIS 5.0 (on 2000) against the SQL Server. Connec ...Show All

• Visual Studio Crystal Reports and the VS IDE (toolbar align lefts, rights, etc..)

  Why, when designing a report, the toolbar with Align Lefts, Align Tops etc is greyed out, but right-click align lefts does work Anyway to add those features to a toolbar in the IDE Carl What version of VS/CR are you using   What objects in the report are you right clicking on   ...Show All

• Visual C++ vc2005: strcpy(char[100], CString); doen't work. Why?

  Hi, Recently I updated to Visual Studio 2005 (from 2003) In VC++2003 this code worked: char SuperString1[100]; //m_supervar is a member variable associated with some Dialog Edit contron (CString) strncpy(SuperString1, m_supervar, 5); This does not compile in VC++2005... the same problem with strcpy... So question is how to convert CString to char in VC++2005 Thanks in advance Serhiy I am sure it compiles, but you are probably talking about the warning. In VC++ 2005, the CRT string functions have been deprecated. I'd suggest that you update your code to use the new secur ...Show All

• Visual C++ error C2440: 'static_cast' : cannot convert from 'BOOL’ to to 'AFX_PMSG'

  This question is related with MFC code that compiles on VS C++6 and now converting to VS C++ 2005. In my Dialog box class CEngOLCDlgBLAmbTemp : public CDialog I have button and when user clicks button, its message IDOK for ON_BN_CLICKED is captured in the code using method OnBLOK. I do some error checking and then decide wheather to close the dialog box or not. The methods OnBLOK returns BOOL. afx_msg BOOL OnBLOK(); BEGIN_MESSAGE_MAP(CEngOLCDlgBLAmbTemp, CDialog) //{{AFX_MSG_MAP(CEngOLCDlgBLAmbTemp) ON_BN_CLICKED(IDOK, OnBLOK) //}}AFX_MSG_MAP END_MESSAGE_MAP() ...Show All