Juan Carlos Trimiño's Q&A profile

• SQL Server Horizontal results

  how can i use concatenation to query the results horizontally example output: CustomerID=1002, Name=Mr Anderson, City=NY you can get the Primary key column of a table by SELECT k.Column_Name FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE k,INFORMATION_SCHEMA.TABLE_CONSTRAINTS t where t.Constraint_Name=k.constraint_name and t.CONSTRAINT_TYPE = 'PRIMARY KEY' and k.Table_Name='[Give Tablename Here]' If it is to get the rows with columnname horizondaly (as one column ) use: declare @Columns varchar(5000),@TableName varchar(50),@Condition varchar(500) set @TableName='[Give Tablename Here]' set @Condition='1=1' -- give the condition here set @Columns='' select @Columns =@Columns + '' + c.Column_name + '=''+ ' + case c.data_type when ' ...Show All

• Software Development for Windows Vista Create "Custom SetState" activity

  Hi Im am trying to create my own SetState activity. My goal is that the activity is to validate a property on the workflow and the go to 1 of 2 states defined on my CheckParameterAndGoToState Activity. I have look at the SetState with reflectot and have created my own version of the internal StateDropDownEditor which allows my new activity to have two TargetStateProperties. This works. But this does not draw the lines on the state machine since i am not using the originally SetState activity. How do i do that Should i implment my own ActivityDesigner for my activity If yes. Which one should "look at" eg. with reflector Thanks in regards Anders Yes that would defently be a solution. H ...Show All

• Visual Studio Team System Call to Static class from Set of originating Methods

  Hi, I'm new to FxCop and am not sure what I want to achieve is possible so was hoping that someone could confirm this. I need to determine whether any calls to a specific static class are being made from a fixed set of methods. The methods are defined in a base class but overridden by descendants. However, what complicates this further is that these methods may be several calls deep within the call stack, as they call other methods which in turn could call others. The methods called by the ORIGINAL set of methods are unknown. For example: Originating Method 1 -> Sub Method 1 -> Sub Method 2 -> <CALL TO STATIC CLASS> I would want this to be flagged as a broken rule. So I have two problems I'm not sure FxC ...Show All

• Software Development for Windows Vista Windows vista Activation error for build for 5384

  when i try to run Activation on my system i get this ***The product key you typed in is in use*** the key i have is PLYFQ-2JTBV-9KXQ2-FQHDY-MYBVH i HAVE THIS $1500 SYSTEM AND I WANT ON IT WINDOWS VISTA can u PLEASE HELP ME!!!!!! When windows fails... go to LINUX Vista supports upto 5 concurrent licences on a LAN with a key, it is possible that 5 people are already logged in your LAN who are already using this key. I think that you can try with some other key if you have one or generate a new key and use it ...Show All

• Visual Studio Howto disable Visual Studio Extension?

  Hi, When Visual Studio starts up, there is a list a installed package loaded.. "Visual C#" "Visual VB" ... I want temperary disable several of them. I know that I can remove them in VS setup program, but it cause a lot of time. there must be some keys in registy to toggle if the extension enable or not Please help! Thanks in advance There is no supported scenario that will prevent the various packages from loading. I am curious as to why you are seeing packages load if you're not using them. Most are designed to load on demand. Meaning they aren't loaded until they are needed. Note, the list you see in the about box and splash screen are simply the list of "installed products& ...Show All

• Windows Forms Upgrade the application with Runas command

  Hi, We are using VB.Net (VS 2003 - .Net Framework 1.1). Our application has feature to execute and install the upgrade. When the user select the option for upgrade we execute the setup.exe from the network drive. Since some users will not have admin access the application get failed to execute and install. So while calling the applcaiton we used process.start("runas user:\@username applicaiton.exe"). But it throws us with the dialog asking for admin password. Since the admin password can't be given to user, we wanted to pass the password as parameter. Is any way we can pass the username and password to execute the process in VS2003. I also came to know that VS2005 supports process.startinfo has parameters for username and passwo ...Show All

• Visual Studio Express Editions Matrix free function problem

  Hi everyone, My program creates a matrix with the specified size. And it also some additional function that can free the matrix. However, when I call the below main function, my free function does not work properly so how can I fix it For example the outpt that I gave when I ran the below application; Sorry,we can not perform the add operation since the sizes of matrices are different 1 2 3 4 2 5 6 7 3 6 8 9 4 7 9 10 0134526920134526944134526968 134526920 5 6 7 134526944 6 8 9 134526968 7 9 10 so how can I correct this 0134526920134526944134526968 134526920 5 6 7 134526944 6 8 9 134526968 7 9 10 The codes for .cpp file; #include ...Show All

• SQL Server Creating new Notificatio services instance

  When I try to create new Notification services instance, I am getting the following error message. "Notification services failed to open a connection to sql server". I have changed default connections to remote.But still I am getting same error.Please help me I am new to Notification services. ...Show All

• Visual Studio Visual Studio 2005 SDK April 2006

  Hello, I've tryed to installed Visual Studio 2005 SDK April 2006 version but I get the following message => "Visual Studio SDK installation failed (Error Code = 2)". Any clue about what could be the problem Regards, Richard Thanks for your fast reply. I had VS 2005 Professional version before and I installed the SDK without a problem. But then I switch to VS Team Developer 2005, I unsinstalled the SDK and VS 2005 before, of course. I cannot see any remains from the previous installation at least in the file system, it could be some registry keys still there maybe. Richard ...Show All

• Visual C# Project Idea

  Hello every one, I have just recently started coding away with C# and decided that this would be a suitable language to produce third year project for my degree course for various different reasons. I am still researching couple of ideas, was wondering if any of you bright people would kindly give me some ideas which will not only be a fun project to work on but something i can learn from. p.s. I have a good understanding of OOP Thanks in advance Strongly advise going the web route rather than winforms... everyone seems to want it. The trick here is to decide what industry you fancy i.e. banking and specifically code something to match that. Will help greatly with your career. ...Show All

• SQL Server ReportViewer 2005 InValidOperationException

  Hi, I am using VS 2005 and ReportViewer 2005 web control in ASP.NET 2.0 web application. I am building custom page to host reports in web application. The website is running under known NT account that has rights to the remote Reporting Server. On the page I am using ReportService2005 web service to retrieve the list of available reports on the server and then trying to use ReportViewer control to display the selected report. I can connect to the remote Reporting Server through Web Service fine and able to retrieve all the data. I can also retrieve the report using the web service. However, when I set the URL and Report path in the ReportViewer control I get following error: Exception: InValidOperationException Message: Clien ...Show All

• Visual Basic Web Browser Popups

  Hello everybody, I have created a successful webbrowser in VB Express Edition 2005, with all controls (back, forward, stop etc..). Yet when a link is clicked which opens a new window on a website, it always opens in internet explorer... how can I prevent this from happening Thankyou Ben wb.navigate( http://microsoft.com )   '<-----  Navigate property This needs to be in an executable pathway (routine, procedure, property, or method). Does this make sense The event occurs asynchronously after the browser had navigated. It is not essential that you do anything in the event. You may want to do something when the page is full loaded when correspnds to documentcompleted event What goes there Whatever ...Show All

• Visual Studio 2008 (Pre-release) vNext August CTP and Linq May CTP problem on VS 2005 Team Edition

  Hi When install vNext and Linq at home on VS 2005 Pro Edition there is no problem. But when I intalled it at work on VS 2005 Team Edition the error list is full. It can not recognize something like this from c in db.Categories where c.CategoryID == categoryId select c).ToSequence().First(); it give errors like this ' ; exprected' 'invalid expression term 'in' ' and etc. but when I run the app it works fine!!! there is no intellisense in the query and even not recognize the Model Obejct assembly when I type using NorthwindModel although that there is a reference in the project. Like I said when I run the app it works but how to fix this 10x Man I have just reinstalled Linq AGAIN and now I don't know but ...Show All

• SQL Server Database Modification (Insert/Update/Delete) Event Notifications

  Hello, I am new to SQL Server and am building a C# application which will use a local SQL Server Express 2005installation. My application will be interacting with a DB Schema with approx 250 tables and the schema is already defined. My application is responsible for monitoring changes to the data in the DB. It must watch for all data changes in the database (Insert/Update/Delete). I am looking for a way to monitor changes to the DB data due to Insert/Update/Delete activity. Is there a simple way in SQL Server for my application to receive events whenever the table content is modified. I have come up with a few ideas myself, for example adding trigger to each table to update an additional Event table that I could look at or even r ...Show All

• SQL Server more tables do search,please help me,sql server stored procedure problem

  i have more tables exmaple: table1(id,title,content,date) table2(did,type,title,text1,text2,requestdate) table3(subid,value1,value2,value3,value4) .......................15 tables left,some exmaple now i want use stored procedure do search for asp.net asp.net send search keyword to sql server,sql server get keywords execute search and return results to web application(asp.net) i don't konw how what write t-sql,please friends help me. because table colums is different,so need write t-sql put the temp DATA TO Temp DataTable,last return Temp DataTable to asp.net,asp.net execute split pager display data,eventable colums is different,so on asp.net links is different,need t-sql programming,hope friends can help me comp ...Show All