Torgg's Q&A profile
SQL Server SSIS Runtime - free redistributable?
Few questions regarding the SSIS runtime... 1. Is the SSIS runtime a free redistributable like in DTS 2000 2. Can it be used to run a package where SQL Server 2005 is not installed ... e.g. on clients 3. Can the SSIS object model be used in a custom .NET application to execute packages stored on the server Is the runtime required in any way in that scenario...hope not. Also does the usage of the Object Model require any sort of SQL Server lice ...Show All
.NET Development Column Expression
I have database with two tables what i would like to do is in the sales table when i put data in the datagrid is to have a column expression that calculates the quantity * price that gives the total.I am using C# express edition2005 and SQL server express edition 2005 hope someone can help with code and where to place it. Thankyou Thankyou for your quick reply I made the quantity and price columns in my sal ...Show All
Visual Studio 2008 (Pre-release) Databinding bug into Bold element...or?
When I do this the app works fine and databinds to the Value property: < TextBlock Text = " {Binding Source={StaticResource DS},Path=Current.Value} " /> But when I do this I get an exception < TextBlock > < Bold Text = " {Binding Source={StaticResource DS},Path=Current.Value} " /> </ TextBlock > Is this a bug or a "feature" The exception I get is: System.Windows.Mar ...Show All
Visual Studio Team System Problems with Debug and FxCop
Hi All, Sometimes when I starts the debug process, it do not stops in my breakpoints. I do the same thing with all my rules, but sometimes all my breakpoints do not work in all my rules.... When it happens, I am forced to create a new project and import all my rules to this new project. It is not a good idea and I'd like to know why it happens and if there is a solution. It happenned 4 times up to now. I am using fxcop 1 ...Show All
Windows Forms Full Trust in Click Once
I have an application which uses SMO to perform various database tasks. When deployed using ClickOnce from a Website and set as a FullTrust application the application has the following behaviour when attempting to transfer database\data: ... transferObject.TransferData() ... Error: 'HRESULT: 0xC0011008', ie DTS_E_LOADFROMXML error The application runs OK in Visual Studio when run as a Full Trust Application. I can duplicate this error ...Show All
Windows Forms Custom columns in databound DataGridView
Custom columns in databound DataGridView In a .NET 2.0 VS2005 project i'm trying to use custom columns in a DataGridView ... the goal is to have one or more non-persistent columns whos values are based on persistent values from a Dataset . Normally i would implement my own class and add a property with get&set, but in this case the DataGridview is connected to a BindingSource which in terms is connected to a retrieved via ...Show All
Windows Forms Form Shortcut
How do I get to, on a short cut key, bring the focus to my form Like press print screen from any window adn my form comes to the front. Hi, Is your form running or are you asking for shortcut while on Visual Studio IDE If your form is running and is visible on TaskBar, pressing Alt-Tab would bring you a choice of applications you can see on your taskbar. -chris ...Show All
Visual Studio SQL Server 2005 Express April CTP Fails from VSTS DVD
When installing VS 2005 (Team Suite) the SQL Server Express install fails with an error code 1603. Also tried reinstalling it after VS but still fails with same error code. Anyone else got this problem /Per Salmi This was a clean installation on a new PC. I can't find the installer or the folder you mentioned to do a manual install. ...Show All
Visual Studio Team System Changing Methodology During Working On The Projcet
Hi Can we change project methodology during working on a project If YES, How thnx Not really in an easy way. The best that you can do is too modify the existing workitems or add new ones (modifying the existing types is very limited). Reports, documents, etc can be handled in a similar manner. ...Show All
SQL Server Properties affected by Expressions
Hi, is there any way to see which property is changed/affected by expressions If not that would make things really complicated because you look at a property and it seams to be OK but the task doesn't do what it's supposed to because "behind the scenes" the setting is changed by an expression... Thanks, Take a look at the updated UI for the File Watcher Task. I expose the expression instead of the property when set. Hope MS implement some ...Show All
.NET Development I need help on embeding a database in an application
can anyone help me on how to embed a database with an application i am developing an application for organizations to give an HR system. so which database tool should I use and how do we include a database inside an application I mean it istalls with the application You can access any database you want via .NET. You can use OleDb or ODBC to Connect to a database, or ADO.NET, you can also use the specialized SQLC ...Show All
Visual Basic Simple Question on Datareader
Hi, I want the datareader to load data in one table based on certain cretaria match in other table in which case both the tables are linked like this Both tables have pkid as primary key fields and compaddress is linked to compmast through cid field. cmd.commandtext="select pkid as cid, compname from compaddress inner join compaddress on compmast.pkid=compaddress.cid where compaddress.city like '%Bangalore%'" dr=cmd.execut ...Show All
SQL Server Bulk Insert -- Access denied issues
Problem: Insert a network file in the DB using BULK Insert Works for a local sqlcmd connection. Does not work for a remote sqlcmd connection. SQL Server is running on Machine 'WalRepTest'. User account for SQL Server Service: 'Domain\vivek_uppal'. This has admin privilieges on SQL Server machine and the machine hosting the file. I have 2 scenarios. Scenario 1 behaves as expected, Scenario 2 causes error. Scenario 1. Connect using sqlcmd ...Show All
Visual C# What should be the best practice to check the object ?
Hi, Normally we check a value by this format if ( obj == null ) { //do some code } I know it is good for readability. But for performance reason I am suggested by one of my coleagues that we shuold check the constant value first i.e. if ( null == obj ) { //do some code } What is the best possible way to check the object Could any body give the proper reason to use the later one. Not sure if ther is any difference ... only 1 way to k ...Show All
Smart Device Development Reading XML ISO-8859-1 is not supported?
how to read xml with ISO-8859-1 it always throw error ISO-8859-1 is not supported. i need to build application in smart device that can read RSS xml, but most of RSS out there is ISO-885901. any idea how to trick this problem thank you. You can use some supported encoding, but characters out of ASCII range might be mangled. You might be able to implement 8859-1 Encoding class as well and use it like this: ...Show All
