Aravindakshan's Q&A profile

• Visual Studio Tools for Office Action Pane

  I've created an Action Pane in C# VS2005 and inserted a Tab control. I'm trying to make the tab control fill the entire action pane. I can't work out how to set the control so it fills the entire Action Pane space. If you create a custom control you can set the docking property to Fill for the custom control if available. customcontrol _cc as new customcontrol(); this.ActionsPane.Controls.Add(_cc); _cc.Dock = DockStyle.Fill; Regards ...Show All

• SQL Server What component to use for Calling View

  In SSIS 2005 what component can I use inside my Data Flow task to call my View and use it as a datasource I know I've used an Execute T-SQL Task but I don't know what component to use inside an actual task itself. What I'm trying to do is in my Data Flow task, instead of using 3 OLE DB Source components, I want to actually call 3 stored procs and use those 3 components as the data sources to merge on using the merge and sort components later on You've lost me. At the start of the above post you say you want to use a view. At the end of the post you say stored proc. Which is it Either way, a view or a stored proc can be used inside a ...Show All

• SQL Server SQL table and column metadata

  SQL table and column metadata Is there a way to add or update the column or table (using the extended properties) description metadata via T-SQL (from within a stored procedure) or via a program (such as VB.NET using ADO) These metadata properties are available via the SSMS interface: Columns via the Column Properties/Table Designer/Description Tables via the Table Properties/Extended Properties/[Extended Property Name] Thanks in advance, Mark Hi, look for sp_addextendedproperty procedure in the BOL. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Smart Device Development Can I send a click in .NETCF1

  Hi,    I'm in the middle of porting a high performance 3d app to a CE 4.2 device, I'm currently using eVC4. Would using Visual Studio 2005 (with the plugin) give me better code generation than eVC 4   At the moment I am unable to do inline asm (__asm) for ARM4I using eVC4. Would this be possible in 2005 Many thanks, Steven Haggerty. Hi Steve, The newer compiler is capable of producing better code than the old, but as for whether is will be better in your specific case, you'll have to profile to be sure. One advantage that you may find is that the new compiler/linker are capable of Link ...Show All

• Visual Studio Express Editions Is it possible to connect to SQL Server Express?

  From the SQL Server Express web site it claims that you can use Visual C# Express 2005 with SQL Server Express 2005, but I have yet to find a way to make that happen. When I try to select a data source the only options I get are Microsoft Access Database File Microsoft SQL Server Database File When I try to select the latter, I just go on a wild goose chase where it claims that I don't have credentials with the server. When I use the regular version of Visual Studio 2005 at work, I also get the option Microsoft SQL Server Which lets me connect to SQL Server Express 2005 no problem. What is a "Microsoft SQL Server Datab ...Show All

• Visual C++ Managed C++ Question: gcroots and App Domains

  Quick question: I'm working on a managed plugin to an open source unmanaged application. To achieve this I have an MC++ bridging dll plugged into the unmanaged host, which itself hosts a C# dll which does the real work: Host App ---> MC++ Bridging Dll (a thin interface) ---> C# Dll (does the real work) When the host app calls a Run function, my plugin bursts into life. I instantiate a whole bunch of managed objects exposed by the C# dll into an unmanaged structure by using the gcroot template; so as to be able to "store" managed objects inside that unmanged data structure jointly owned by the host app and the MC++ bridge. It ...Show All

• Windows Forms Windows Service

  Hello All,  I'm in the middle of writing a small windows service and i've run into a small problem. I want some code to execute every 30 minutes or so but i can't seem to get it to work. I placed a timer control onto the project(Not the timer from the windows forms area, but from the components area) and it still doesn't work. Here  ...Show All

• Visual C++ Using Printf in a "C" DLL?

  Hello, I've been writing a DLL in VisC++6, and I've run into a bit of rut... Everything is fine, until I try to use the 'Printf' command within the DLL, I realise that the DLL will not have a console window associated with it, and I have tried to use a few API commands... Which brings a console window up... but I still cannot send anything to the console, either with 'Printf' or 'WriteConsole()'... The error message I receive from the latter API command says 'Invalid Handle', but everything seems fine to me, and so, I'm a little stuck!!! :) Hope this makes a little sense and someone can point me in the right direction... a little example wou ...Show All

• Visual C# Datagrid Events

  I am trying to find an event that then the user scrolls down the datagrid for each record I can display the notes in a listview control. So, when the user goes to a different record the notes for that record will appear in the listview control. Can somebody help thanks Hopefully this is not taken in the wrong thought, but did you create a handler for the event, not just copy and paste the code I presume this is Framework 1.1 not 2.0, since the datagrid is now a data grid view ...Show All

• SQL Server Trying to do too much in a view... I think?

  Hello all, I have a table that contains a whole bunch of clinical statistics. There are some other fields I would like to add, but they are best created on the fly, so I thought I would do this with a view. I can create some of my dynamic fields (like BMI below), but when I try to use them again in the view it doesn't work. (ie, I get an error when I try and include the case statement bit). Does anyone know what I can do Kitty. CREATE VIEW dbo.vAAA AS SELECT BMI = (WEIGHT / POWER((HEIGHT/100), 2)), BMI_GROUP = CASE WHEN BMI < 26 THEN 0 WHEN BMI >= 26 THEN 1 ELSE NULL END -- other bits removed ...Show All

• Visual Studio Team System Additional binaries don't get shadow-copied

  i have three assemblies (class libraries) in my solution: the first one contains classes only (1), the second one contains the interfaces (2) and the third one works as a plugin (3) for 1 (implementing the interfaces from 2). at design-time 1 only references 2; i then have a post-build command that copies the binary from 3 to the bin-folder of 1 (2 gets copied anyway because of the reference). that works fine using my app normally. but when i run a unit-test for 1 the plugin 3 is not found. i checked the log and saw that the assemblies are shadow-copied to some temp folder in the users application data directory. that's a good ...Show All

• Visual Studio Express Editions Using Data from a Checked Listbox

  Howdy, I'm trying to use a checked listbox to choose some numbers to add and return the total value to a label. Here's where I'm at so far (i'll throw in as much code as I can). I want to step thru the checked listbox list and if a box is checked add it's value to the total and then return the total of the checked boxes to a label. I can do it with a bunch of If statements, but I've got 14 checked listbox items and would rather use more automation and less code, i.e. For/Next or Do/Until all the items have been checked for check marks: Dim i, intSumOfNumbers, intBox1, intBox2, intBox3, intBox4 as Integer intBox1 = 4 intBox2 = 3 ...Show All

• Visual Studio Team System Unable to create a Team Project - SharePoint connection problem

  I have installed the Beta 3 refresh of TFS, along with SQL Server and SharePoint following the instructions in the installation guide.  However when I try to create a project I am getting an error that there is a problem in installing the SparePoint site.  The Project Creation Wizard is unable to connect to Windnows SharePoint Services.  At this point it attempts an incomplete rollback and I end up with what appears to be a partial install.  Any ideas as to why the wizard can't connect to SharePoint.  And how can I complete the rollback of the failed project creation. I had the same p ...Show All

• Visual Basic "Ambiguous Namespace" problems in VB.NET 2003

  I am writing a public class called StaffPost which sits within a namespace called Davnet (the name of the DB these classes control).  Under this class are several public sub classes such as Post, People & OrgStructure. I'm pulling my hair out over this because it all works fine then suddenly gives me major grief.  I tried adding a form to the class (as it was originally a class module) but changed it to a windows app, added the form and could test it.  The next day I loaded it, I was getting "Sub Main() not found' and this wouldn't go away.  When I didn't get that, occasionaly I'd get 'StaffPost is ambiguous in the na ...Show All

• SQL Server Can I update several columns by CASE expressions?

  Hi, all here, I am having a question-is it possible to update several columns using CASE expression in SQL language like if I wanna set each CASE for each column. Thanks a lot in advance for any help and guidance. I think so. Have you tried something and it didn't work A CASE expression just returns a scalar value, so you can do: update tablename set column1 = case when .... end, column2 = case when ... end, If you want. If the case statements are completely independent of one another this might be the best way to do something, but if they are from the same data set then you might want to use a join, and possibly a deri ...Show All