Cla82's Q&A profile

• SQL Server Expression on hidden property

  I have param named Direction i would like to put on the hidden property of image this expression iif(Parameters!Direction.Value = "ascending" ,False ,True) But i've got error message .....my expression is not avalid value. why It’s like a said before... =iif(Parameters!Direction.Value = "ascending" ,False ,True) if everything's ok that should hide your image when the Parameters!Direction.Value is "ascending" and show it otherwise. ...Show All

• SQL Server Integrate more than one SSIS packages into one package

  Hi I'm new to SSIS field. I'm importing data from flat files to sql server 2005 through SSIS packages. I have around 30 packages which transfers data from flat files to corresponding database tables. I want a single package that will run all the 30 packages by running that single package. Like in a single stored procedure we can run multiple stored procedure, I want the same solutions for my packages. Is there any method which can solve the above issue Please kindly guide me . Its urgent. please reply soon. Thanks in advance. Rafael is right on about package configurations. You can find info on this here, here and here. ...Show All

• .NET Development how to create .xml file using SQL query (SQL Server 2000)

  i'm using a datawarehouse from which i need to pickup huge data and show it using a grid on a web page. my thought is to create an .xml file suing SQL query and then create a dataset from the XML file and then bind it to a datagrid do any one have any better(best) approach for this   What format is the data in the warehouse If you can pull it out using a standard ADO.Net provider, then you can push that directly into a dataset for binding. Another question to think about: Why do you need huge data in a grid Maybe just a subset of the data that is relevant to the current display is all you need ...Show All

• Visual Studio Team System GET Task Definition and Attributes??

  Hi All, Is there some detailed documentation and samples of the Get task in Team Build I used this blog, but didn't really detail what i wanted to do. http://blogs.msdn.com/nagarajp/archive/2005/10/21/483590.aspx Can anyone tell me what atrtibutes I have to set to get the contents of a certain folder in Source Control to a specific physical filepath location on the harddisk This doesn't work: < Get Condition = " '$(SkipGet)'!='true' " FileSpec = " $/MySourcePath/HelloWorld/**/* " Workspace = " C:/Temp " Recursive = " $(RecursiveGet) " /> THanks Md Md, The mapping betwe ...Show All

• SQL Server Nonadditive Measure in Standard Edition

  How do I define a measure to be nonadditive in Standard Edition If I set the AggregateFunction property to None, I get this error when trying to deploy: Aggregate function None is not allowed in Standard server edition. This is for a percentage measure based on a named calculation in my data source view. It obviously cannot be aggregated. Any workaround for this -Larry You're right, that was easy -- but only after I fully understood what it was doing. MDX is taking me a little while to get, but it's starting to sink in. Thanks again for your help! -Larry ...Show All

• Visual Studio 2008 (Pre-release) Accessing invidual objects for a xaml file parsed with XamlLoader.Load()

  I am trying to access objects created by parsing a .xaml file, using XamlLoader.Load(). For example if my .xaml file contains rectangles I'd like to be able to access them and modify a parameter, like their color. Is there a way to obtain a tree-structure of the objects created during the parsing Stream s = File.OpenRead("test.xaml"); Canvas newCanvas = (Canvas)XamlReader.Load(s); s.Close(); foreach(Rectangle r in newCanvas.Children) { r.Color= Blue; } ...Show All

• Visual Studio Express Editions VC6 to VC Express 2005 error!

  Hello; I recently start moving from VC++ 6 to VC++ Express 2005. I read the book "Game Programming all in One" from Premier Press and practice all the examples with VC++ 6 having no troubles at all. But when I start coding all the examples for VCE the problems start. Initially nothing difficult, some type errors, "some functions are deprecated because more secure versions are available", another warnings, etc. But, when I tried to compile a game (working fine in VC++ 6) called Monster I found an error I couldn't solve, the error message is next: 1>\chapter 07\monster\conlib.cpp(75) : error C2664: 'SetConsoleTitleW' : cannot convert parameter 1 from 'char *' to 'LPCWSTR' Types pointed to are unrelated; conv ...Show All

• SQL Server SQL Statements with inner join too slow in 2005 runs faster in 2000

  Hi all, I'm desperately looking for answers to following issue that we are currently experiencing on our test server. We inheritted one of our business app from another company. We replicated exact same hardware environment. The only difference is we are using Windows 2003 server and SQL Server 2005 whereas the other company who wrote this app is using Windows 2000 server and SQL Server 2000. We are experiencing huge performance problems running few types of queries. The Stored Procedure that takes 7 minutes to run, exact same code with same data takes about 45 minutes to complete on our end. I have narrowed it down to one view that is called in a trigger that inserts rows into a specific table. Below is the trigger code and the vie ...Show All

• Windows Forms Font is Combobox text?

  Hey, How would I make it so that the font in a richtextbox is the selected font in a combobox(combobox2.text)  I tryed thisrichtextbox.TextBox.Font = (toolStripComboBox2.Text); but I got a error with the toolstripcombobox2.text part...: Cannot implicitly convert type 'string' to 'System.Drawing.Font'   Thanks :) Oops unless you had selected text, you would not see the change. Sorry, try this thisrichtextbox. Font = comboBox1.Font; ...Show All

• .NET Development Get exception when calling TransactionScope.Complete() method.

  Hi, Following is my code to use system.transaction: ConnectionStringSettings setting = ConfigurationManager.ConnectionStrings["Sample"]; DbProviderFactory factory = DbProviderFactories.GetFactory(setting.ProviderName); using (TransactionScope scope = new TransactionScope()) { DbConnection conn = factory.CreateConnection(); conn.ConnectionString = setting.ConnectionString; conn.Open(); DbCommand cmdUpdate = conn.CreateCommand(); cmdUpdate.CommandType = CommandType.Text; cmdUpdate.UpdatedRowSource = UpdateRowSource.None; using (DbTransaction tran1 = conn.BeginTransaction()) { cmdUpdate.CommandText = "UPDATE Table1 SE ...Show All

• SQL Server Copy data in Sql Server table A to B on same server - Identical schemas

  Greetings, I have two SQL Server tables on the same server and in the same database. I'll call them table A and table B. They have identical schemas. I need to insert all rows in table A into table B. (Don't laugh - this is just for testing and long run the tables will reside on different servers.) Can someone please tell me the correct task to use for this and the connection type I need for both the source and destination Thanks, Black Cat Bone Phil's right. That's exactly what it is. Its explained a bit more here: Destination Adapter Comparison ( http://blogs.conchango.com/jamiethomson/archive/2006/08/14/4344.aspx ) -Jamie ...Show All

• Visual Studio CodeModel function information

  Is there a way to get the code within a function using the codemodel public void GetFunctionCode(){ String getThisStatement = "some statement"; String andThisStatementToo = "another statement"; String usingTheCodeModel = "third statement"; } Hi, What Craig meant is that the code model does not support code inside methods, neither read nor write. You have to do it parsing the code or adding new lines on your own. ...Show All

• SQL Server Problem restoring database to a compressed drive.

  I am learning how to use SMO and I have a test application that allows me to restore a database backup to a new database. On my system I have one physical drive but two logical drives on separate partitions. Drive C: is on a partition that is a FAT32 partition and drive D: is on a partition that is a NTFS partition and is a compressed partition. The database backup file is located on drive D:. When I try to restore the backup to a new database and provide a path on the D: drive in the RelocateFile object I get the following error message. "The file 'D:\NPS_Test.mdf' is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. When I do a restore and indicate that the new database file wi ...Show All

• Visual Basic migration from TrueBasic

  I All I have the following conversion problem.  In TrueBasic (an old structured Basic) nested routine were allowed. Look, for instance, the the following Module main       Sub XXX() Dim a Sub ZZZ() Dim b End Sub End Sub Sub YYY()       End Sub End Module     In the above fragment the variable "a"  and also "b" are seen from both XXX and ZZZ( this last is the nested procedure) but not from YYY. I do not succeed in reproducing this behavior in VB.net but I know that with all that power ( class, structure , module,etc) it is surely possible. Please, can somebody help me   thank in advance   Federico ...Show All

• .NET Development Transaction support in MS ACCESS

  I made the following query on the Office forums... I am using VB.NET 2005 to program a Database Application, with Access 2003 as the DB backend. Every now & then, I have to make a series of updates to the tables as a result of user actions. Either all of these updates should be performed or none of them should be applied to the database. ADO.NET provides transactions fo the purpose. So, I create OleDB commands for each update. Now, the problem is that when I set the command's Transaction property as: command.Transaction=tx and later try to commit or rollback the transaction using, tx.Commit or tx.Rollback It gives me an exception saying that the ...Show All