Amazon Mother's Q&A profile

• .NET Development changing command text of command created by command builder

  Hi! I 'm creating a dataadapters commands using a sql command builder. After setting the commands I want to slightly add insert command text so I write the following: myCommand.insertCommand = myCommandBuilder.GetInsertCommand(); myCommand.insertCommand.commandText += myAdditionalSQL; however, performing an update uppon a data table, I see that the additional sql is not used. Why found it! myCommandBuilder.RefreshSchema(); should be cal ...Show All

• Audio and Video Development Which OS apps use Media Foundation

  Hi Out of interest which apps bundled with Vista use Media Foundation, e.g. does Windows Media Player use Media Foundation when playing back formats that have Media Foundation codecs, e.g. WMV etc. and uses DirectShow for other media types And what about Media Center What about the MediaElement in WPF(Avalon) Any other OS apps that I haven't mentioned Cheers Hi Sean, All the applications yo ...Show All

• SQL Server Impact of "Rows per batch" on OLE DB Destination?

  OLE DB Destination has a "Rows per batch" parameter. Are there best practices/guidelines around what it should be set to (for better performance etc) For example, if each row is of size 100 bytes, how does performance change when I set a batchsize of 0, 100, 1000, 10,000 etc I guess the default value for this parameter is zero. Does that mean, internally it is implemented as: For each row: begin transaction insert row commit tran ...Show All

• Visual C# Programmatically select a Listview item

  I can't programmatically select an item on a listview in c# 2005 beta2.  Basically, I: 1. Create a Listview called Listview1 2. Populate Listview1 with some preset items during startup of form 3. Select first item by:        Listview1.Items[0].Selected = true ; 4. Problem is that I get zero when I execute:        Listview1.SelectedItems.Count I have tried s ...Show All

• SQL Server TargetServerURL for named instance?

  Hi There I am running the latest Sql Server 2005 CTP with reports server installed. I am following thorugh the Reporting services tutorial on 2005 BOL. I am at the publishing report step: The tutorial stipulates that under the project properties the url is as follows http://servername/reportserver or http://local/reportserver  for TargetServerURL. The problem is that i am running sql server 2000 and 2005 on my machine. So the named instance ...Show All

• Windows Forms Sample applications...

  I'm looking for some enterprise-level sample (open-source) WinForms applications; something on the level of #Develop ( www.icsharpcode.com ).  I'm mostly interested in architecture patterns of large-scale applications (intense UI, services, etc.)  I have extensive experience in enterprise ASP.NET applications and am trying to broaden my WinForms experience. If anyone could provide links to anything that may spark my interest, it w ...Show All

• Windows Forms DataGridViewCheckBoxColumn

  Hi, I would like to know how to change the appearance of checkbox in DataGridViewCheckBoxColumn. With normal check box control, we can change the appearance to button or normal. How can I do that with in DataGridView Hi, If you want to do this at design time, it's pretty easy. Go to the Properties window of the DataGridView, select Columns then in the Bound Column Properties section, click the dropdown Co ...Show All

• Visual Studio Using Access/Excel data in Crystal Report

  Hello, I'm using a Excel file as a data resource of the Crystal Report. After I entered the file location, I've seen a tree structure as the following: - datafilename - F2 - F3 - F4 - etc.... I'm not so sure what do these mean I could not decide what to select at the time I'm entering it for a plotting a chart. Anyone could tell me any resource or hints My Excel file has 2 columns, i.e. both column A and column B have ...Show All

• Visual C++ Object going out of scope

  I have this following piece of code class B { public : B() { alive1 = false; } bool alive() { return alive1; } bool alive1; }; // end of B class A { public: A() { b = new B(); } ~A() { delete b ; } B& getB() { return *b; } private: B* b; }; // end of A int main() { B *p = 0; { A a; B& c = a.getB(); p = &c; } cout << p->alive(); }// end of main Shouldn't the statement p->alive( ...Show All

• Windows Forms Exporting DataGridView to Excel

  Hi, can someone tell me how I can export a DataGridView to an excel spreadsheet and do row coloring, etc. Also, I want to be able to export to Excel 2000, XP and 2003 Thanks, Tom try using DataGridView Extension - it is a free "upgrade" of the basic DataGridView control (no another control, just an upgrade) and it allows you to export data and visualization to Excel, HTML, Also to search for a tex ...Show All

• Visual Studio Tools for Office Project server error

  Hi. I use PDS to communicate with Project Server. (send xml requests and receive xml replys) Can anyone explain the following error to me: rsVersionNotFound (status=3000) Things have been working fine but recently this error popped up. Regards, Throstur Thorstur, I am sorry you are having trouble with your project server solution. The alias where you have posed your question is monit ...Show All

• Visual C# SQL Server on C# question

  Hi, I want to be able to run, pause or stop a SQL Service (as in SQL Server Service Manager) from within a C# application. How can I do this The server I'm using is called DEANHPLAPTOP. I'm sure this can be done through the command line somehow in DOS but how can I do it in an application The end result I want is to have it so that the first form in the app (login form) starts the service if it's not already running and then stops it when t ...Show All

• Visual Studio Team System Microsoft Project Professional and Project Server 2003

  Whenever I publish enterprise projects from project professional 2003 to Project server 2003 the task appear scrambled when viewed in the Project center using Project Web Access. Why is this I'm sorry but this forum is for supporting people with Team Foundation Server issues and we don't have a great deal of expertise with Project and Project Server specific issues. I'd recommend finding a forum focued o ...Show All

• SQL Server Failed SQL 2005 SP1 installations (Hotifx.exe crashes)

  I am seeing repeated failures installing SP1 database services with crashes in hotfix.exe being reported and the following appearing in log files: Property(S): SqlUpgradeMessage = SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL ...Show All

• .NET Development C++ .NET - Create, Read and Write Excel

  Does anyone have any sample code in C++ .NET managed code to Create, Read and Write and Excel 2000 Spreadsheet If not, can you point me in the right direction to find documentation, articles, etc. For those who are interested, Jason posted a reply in: Visual C++ Visual C++ Language Re: C++ .NET Managed Code - Excel 2000 This solution worked for me. Thanks everyone for your input, Joel ...Show All