Luo Cao's Q&A profile

• SQL Server Problem with service of the SQL server 2005

  Hello, I have a problem: I accede to the SQL server 2005 having installed the SQL server locally but it does not allow me to initiate, to stop nor to reinitiate the service, that only happens to my user, however with another one if it allows. the network is with work group, that podria to be thanks for its attention You need to log in to your computer as a member of the Windows Administrators group to start or stop the SQL Server service. When you are logged in as an administrator, you can use the SQL Server Configuration Manager tool to start and stop the service or change service startup properties. ...Show All

• Windows Forms Developing a UI with a DataGridView Control

  I found that I could construct a table defined with appropriate columns with added data in rows which I could edit, add more rows or delete rows. The content of this table with any indicated ccchangespersisted - it survived closing and re-opening the table I found that above table could fully populate a DataGridView control on the Form-Form1 of the project. Gudance notes indicated that I should expect to be able to edit, add rows, and delete records in the UI which would be carried through to the main table of the database. - this did not happen. Add and save data buttins int he UI seemed to have no effect at all. Moreover if the columns included a computer column specification with a formula and Yes to inicate that the enty is per ...Show All

• Commerce Server cms recommendation

  Hello Doeas any one has any recommendation for CMS application to use in cs2007 site (Other than MOSS) Thanks arik Arik, Any well-built ASP.NET-based content management system should work. Cheers, Colin ...Show All

• Windows Forms Datagridview combobox query

  I have a datagridview with 5 columns which a populate with dataset, which retrieves data from a table. The first column in the datagridview is a combo box which contains IDNumbers. In the combo box, I wish to show a number of IDNumbers that are in another table. In code, I have defined another dataset to retrieve the IDNumbers, but I do not know how to connect the secondary dataset with the IDNumbers to the combobox's items collection in the datagridview. How am I able to do this in such a way that I can have multiple rows in the datagridview with the same IDNumber (The database has been setup correctly to allow for this scenario.) Thanks James Hi, Try the following code I ...Show All

• SQL Server Restricting access to certain folders?

  Hi all, I have a user who I only want to provide access to a single folder within RS2005. I don't seem to be able todo this, they can either see everything or nothing at all. What am I missing Any help much appreciated. Kind regards Tarun SystemUser at site level and browser (and even higher roles tested) at home folder level. The home remains empty (can't see any of the folders in it). ...Show All

• .NET Development How to store a string which contain Null Character?

  I need to send a string which contain the NULL (&H00) character through the serialport. I found that the System.Text.Encoding.ASCII.Getstring will stop when the byte value is equal to zero. Here is the coding Dim bvtAVP() as byte bvtAVP(0)=&H0 bvtAVP(1)=&H65 bvtAVP(2)=&H0 bvtAVP(3)=&H66 strAVP = System.Text.Encoding.ASCII.GetString(bytAVP, 0, bytAVP.Length) Please help me on this, thanks. Your byte array looks a lot like a Unicode string in BigEndian format. If all of your arrays look like this and only contain ASCII codes, just create a new Byte() array from the odd bytes... ...Show All

• Internet Explorer Development IE 7 RC1 Breaks Scripts

  I just installed IE 7 RC1 and my application scripts stopped working. An example: Dim IE, doc, pics Set IE = CreateObject("InternetExplorer.Application") IE.navigate "about:blank" Do until IE.ReadyState = 4: WScript.Sleep 50: Loop Set doc = IE.document doc.write("test test <img src='abc.jpg'> test") set pics = doc.all.tags("IMG") pics.length now returns 0 Help! Help! What should I modify Thanks in advance kk PS: It was still ok in the beta before RC1 I would like to let all know that after I installed the golden IE7, everything works like before in IE6 with nothing amiss, and without me having to modify anything. Thanks Microsoft. - ...Show All

• SQL Server Profiler Error data column

  I run Profiler against my production Db to keep an eye on poorly performing t-SQL batches and SPs. There's an "Error" column in the profiler output. According to BOL (topic: Describing Events by Using Data Columns), Error = The error number of a given event. Often this is the error number stored in sysmessages. The profiler output usually shows "0 - OK" in the error column. But it sometimes shows "1 - Error" or "2 - Abort" in this column. What do these error messages mean I've looked around but haven't been able to find anything more detailed about what these two messages mean and how I can perhaps dig deeper to figure out what's going on. (When these values are displayed, CPU is usually taking ...Show All

• .NET Development Generate and read config data in XML form

  I was just wondering if XML can be generated and parsed very simply. I need to write a number of operating parameters into a file before my app exits, and then read them back when the app starts again. Can this be done in a very automated fashion by generating XML into a file I am exceedingly lazy and would hate to have to write code to parse parameters in traditional Windows dot ini file format. Sounds like a task for the a User Settings action . The settings file, which is written in Xml, is used for such purposes like reading in a value at start and saving it on close with minimal effort on the developers part.... See Using Settings in C# . ...Show All

• SQL Server How to get "Current Week" details in MDX query

  We are trying to migrate TFS (RC) warehouse report to TFS (RTM) warehouse. My query in TFS (RC) is using “[Current Week]” for getting the current week details. SELECT NON EMPTY {([Measures].[Current Work Item Count]),([Measures].[tasksendedthatweek]),([Measures].[tasksactuallyendedthatweek]),([Measures].[tasksactuallystartedthatweek])} ON COLUMNS, lastperiods (5, strtomember ( ' [ HP_Apprise_PM_Task_StartDate1].[Year Week Date].[Week].[Current Week] ' )) on rows FROM [Current Work Item] where { strtoset (@TeamProjectTeamProject)} The above query is failing in TFS (RTM) reporting (its not giving any error, but am not able to get the data). When I replaced “[Current Week]” with the specific Week date, am able ...Show All

• Visual C# data objects

  Hello my name is Mike I am very new to C# as a language but not new to programming at all. Let me first explain what I am working on. It is a Mortgage Calculator and I am trying to Declare and Create a new data object and I'm not quite sure about the syntax Also I have an Amortization table that I'm trying to create and then retreive the data from. I just basically need to know the syntax on how to do this. Please help me I'm stuck. what do you mean by data object Do you mean instances of a class (Object Orientation) You simply create a class, with methods/properties/constructor(s) and create an instance of it wherever you want in your project. Example: MyClass theClass = new MyClass(); theClass.DoS ...Show All

• Windows Forms Is there a .pre folder in clickonce upgrade?

  I was told, when you upgrade one version to another version, the clickonce first copies all the files to .pre folder of the data directory and then based on the date it will move the files to data folder. I want to change the data structure of one of my file. So in my FirstRun logic, I did a check for data\.pre folder and folder is not found. Is this correct or am I doing something wrong/ Thanks. ...Show All

• SQL Server online index rebuild Problem

  Hi Please advice whether i have to do update stats after i do online index rebuild I use Alter index with (options as below) ONLINE =  ON SORT_IN_TEMPDB =  ON STATISTICS_NORECOMPUTE =OFF Should i be doing update stats after this online index rebuild After doing online index rebuild when  clients connecting to DB the Response time has increased .. During Online INDEX REBUILD page file usage rises from 3 Gb to 10 GB and stays at 10 Gb even after online index rebuild i have no idea on this  .. pls Advice ...I Need help.......................... Thanks in advance Pagefile is increased, then check the memory settings on SQL Server. Also if there ...Show All

• SQL Server Management Studio - drag table and drop to SQL Editor

  Hi In Management Studio, when I am dragging a table (stored proc, etc.) from Object Explorer to the Query Editor, and when that table name contains a space(s). For example, a table named dbo.[Sample table with a few spaces], when I am dragging it into Query Editor I am getting dbo.Sample table with a few spaces. Then I need to add missing brackets manually. The same is with table columns, stored proc functions, etc. Is it possible to get these brackets automatically Kamil I suppose because they haven't ever been reported. You can try here: http://connect.microsoft.com/site/sitehome.aspx SiteID=68 ...Show All

• Visual C++ use templated base class declared in 1 C++/CLI assembly in another C++/CLI assembly?

  Hi, In C++/CLI, is it possible to take a template base class declared and defined in one assembly and use it as a base class in another assembly If so, how IOW: assemblyA: template < typename T > public ref class Wrapper : PtrWrapper< T > { protected: Wrapper( T* pObj ) : PtrWrapper<T>( pObj ) { // do something } ~Wrapper( void ) {} }; assemblyB: public ref class Batch : public CoreAPI::Wrapper< cBatch > { }; where T is an UNmanaged type (and cBatch is also). Both assemblies are DLLs, and both are CPP/CLI, if that matters. Wrapper is being successfully used as a base for many classes in AssemblyA. I can't get this to work. If I just have a reference in B to A, ...Show All