Lei Jiang's Q&A profile

• SQL Server reporting services and mozilla

  would someone know what i should to to make my report display in mozilla. I have added a textbox at the bottom of the reports' layout and this only helps a little because only the firts page of the report shows clearly in mozilla. The rest of the pages appear squashed to the left in the mozilla browser. This is due to a bug in Mozilla code. For your reference: https://bugzilla.mozilla.org/show_bug.cgi id=350506 We are investigating a possible workaround which may be available in SP2. Stay tuned. -Chris ...Show All

• SQL Server Lookup Task Datatype issue

  Hello: I'm attempting to use the lookup task and i'm running into an issue about incompatible datatypes. The table that i'm referencing in the lookup has a field named DateCreated, and it's DataType is DateTime. But when I hook it up to the Lookup Task, the lookup task thinks it's a DB_Timestamp, so i get an incompatible data type error. What can i do Duane: Thanks for your reply. My problem is not with the dataflow, but with the Lookup Task misinterpreting the Data Type of one of the columns in my lookup table. Instead of being DateTime as the column is set to, the the Lookup task thinks the column is a DB_Timestamp. ...Show All

• Visual Studio Team System Help needed to resolve a Windows Group/User when trying to add them in Team Foundation Server

  Hello All, When I try to add a Group or User from the domain, I get an error message that Team Foundation Server can't resolve the group or user name. The Virtual Server where the Team Foundation server resides, is on the domain so I am not sure where I need to make a change. Thanks in advance :) Bob Hanson I believe that the necessary Active Directory permission is "Read". In a Domain Controller/DNS machine I've been using for some of my local testing, the Domain Users group has the following effective permissions. My service account is only in this group: Read Create All Child Objects Delete All Child Objects Send To Read Phone and Mail Options Write Phone and Mail Options The two "Child Objects&qu ...Show All

• SQL Server Sql Transactions

  Hello All, When i am working with Transactions i got one doubt. If i am inserting any records into a table with primary key if a transaction is rolled back i am finding one primary ID is missing. Is it so. Even if not specified I suppose you have an IDENTITY and PRIMARY KEY table column. In that case you're correct: Sql Server does not reuses *ANY* ID, even if generated in a rolled back transaction. ...Show All

• Microsoft ISV Community Center Forums A vector of vectors (vectors Collection)

  Hi... I need to create a vector of vectors (or a vectors container) using VBA for Excel. How can i do this Thanks.. Glad to be of service. Just a note on the Collection object -- it's much more flexible than setting up an array. For example, let's say you've got an array dimensioned with 50 elements, of which 20 are occupied. If you want to delete the 10th element of the array, you need to manually move each element of the array from the 11th to the 20th into the previous "slot". With a Collection, you don't need to muck around with this kind of thing. You can simply use the Add and Remove methods to work with the Collection's contents, without needing to worry about which item appears ...Show All

• Software Development for Windows Vista Windows Vista interface on XP

  I have started using C# 2005 on Windows Vista and wanted to know how can i deploy my application to XP with the sane Vista's style and interface The june ctp brings us a step closer to allowing that look at this blog entry for more info. http://laurenlavoie.com/avalon/162 ...Show All

• Windows Forms extend binding navigator service

  Hi I want to add two button controls to the binding navigator for query by example first button: filter , in that case , all controls of the form are cleared , and user can enter values in the controls. second button: apply filter, when user click it , the filter which is composed by reading every control value is applied to the base table and data is reterieved. i want to add these services to the binding navigator . can you help me thanks in advance Assume you use datatable as datasource, then you can try something like this: namespace Sample2 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } BindingSo ...Show All

• Visual Studio Tools for Office VSTO version 2003

  Where can i download VSTO version 2003(VS 2003) I can not find the link to download. Only VSTO version 2005 is available. If you're trying to download from an MSDN subscription, try contacting the on-line Concierge or some other support channel on MSDN. Please note, however, that VS 2003 has probably been discontinued from MSDN. If you don't have an MSDN subscription then I don't believe it's possible to download VSTO at all, except for the "second edition" (VSTO 2005 SE) for creating Add-ins. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. I need Path-Finding

  I am currently working on an RPG using XNA and I was wondering if anyone has implemented a shortest path algorithm on XNA. I need some shortest-path collision-avoiding code that I can use on a grid. I have looked at A* and Dijkstra's algorithm, but I think both may be outside my capabilities as a programmer. Any help is greatly appreciated. A-star is usually better than Dijkstra, even for "guaranteed shortest path." That's because it won't examine nodes that can't possibly be part of the shortest path. Dijkstra calculates global costs (examine all nodes). A-star is really simple, though. It looks something like: Pos p = startPos; Pos g = theGoal; PriorityQueue<Pos, Cost> open = new Prior ...Show All

• Visual Studio 2008 (Pre-release) Service and operation name decoration

  Hello: Is it possible to decorate a service contract or operation contract name with the name of a generic type argument, similar to what is supported by data contract. I would like to do something similar to this: [ServiceContract(Name = "Echo_of_{0}")] public interface IEcho<T>{ [OperationContract] T Echo(T t); } The name of the service would depend on the name of the type used for the generic parameter T. I've tried this and it does not work. Why is this supported on data contracts and not on service or operation contracts Thanks Pedro Felix This feature is not available for ServiceContracts, though perhaps you could use extensibility (e.g. overriding CreateDescription() on ServiceH ...Show All

• .NET Development -Using Sproc to insert rows in the DB and the Sproc returns identity columns to my dataset

  If we use sqdataadapter to insert data from a datatable into a table in the database using an SPROC. The Sproc also returns the identity column values that are created by the database. If those identity columns are called “IDcolumn” in the physical DB but in my dataset I call them “MyIdentity”. So IDcolumn is an output of my SProc I use : Pm.Direction= ParameterDirection.Output Then I use pm.SourceColumn property : Should I use IDcolumn” or “MyIdentity” Like this: Pm.sourcecolumn=”IDcolumn” or like this: Pm.sourcecolumn=” MyIdentity” Thank you it should be the same fieldname as the fieldname in the database otherwise it will throw an exception stating that the fieldname was not found ...Show All

• SQL Server Database stress tester

  Hello Are there any database stress testing tools like database hammer bundled with any editions of 2005 Or is there a resource kit somewhere that has one Thanks third-party tool... http://www.idera.com/Products/SQLscaler/ s=GW ...Show All

• Software Development for Windows Vista how to force the interactive user to logoff

  is there a way for a service to force the interactive user to logoff the ExitWindowsEx API applies to caller's desktop, so i don't think this works from a service to shut down another user. i'm trying to write a program that is similar to cybercafe software -once a user has used up their allotted time (to be monitored by the service), i want to force that user's desktop to lock or logoff. if i have a timer program running within the user's session that initiates the logoff, then the user could (in theory) cancel that process. The problem is in the parameters of the WTSDisconnectSession. WTS_CURRENT_SESSION -> Indicates the session of the process that is calling the method. In your case, session 0 (w ...Show All

• SQL Server SQL Server 2005 Service Pack 2 -- Now Available

  SQL Server 2005 Service Pack 2 has been released to the web. Many of the questions asked on this forum will be solved by applying Service Pack 2. Please take the time to read about the many benefits this service pack provides. SQL Server 2005 Service Pack 2: http://www.microsoft.com/sql/sp2.mspx SQL Server 2005 Service Pack 2 blogs: http://blogs.msdn.com/sqlrem/archive/tags/SQL+Server+2005+-+SP2/default.aspx Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability http://blogs.msdn.com/sqlrem/ I read that there is a post sp-2 hotfix to apply and that the sp-2 files on MS site will be ammended for this hotfix. Any idea where to get the hotfix We've applied sp-2 and even though we are not in production yet, ...Show All

• SQL Server Reporting services with SQL Express

  Ok, here's the deal. I'm just learning sql express and I'm trying to get my reporting services worked out. I have everything installed and I have managed to connect to the report server at http://<computername>/Reports my problem is I can only connect to this page when I am at the machine where the sql database, reporting database, etc... I cannot log on to this site from any other computer no my network Does any one know why Thanks!!! I get a page cannot be displayed in the browser window when I try from a different machine. Header bar at the top of browser window says "Cannot find server - Microsoft Internet Explorer" ...Show All