vtortola's Q&A profile

• SQL Server Restricting memory Express constumption

  Hi We are developing some applications for Sunit computers (In-vehicle computers) which have limited memory . Because the applications display maps, the will consume alot of memory. Because of this, we want to restrict the amount of memory and other resources SQL Server Express uses to a minimum. I've tried setting 'max server memory', which doesn't help too much as this is only a limit on the SQL engine and not the sqlserver.exe process. What other settings and restrictions can I apply to limit memory consumption by the process We have considered using SQL Server Everywhere, but as it doesn't support ODBC (will there be any ODBC support ), we are not too happy about using it. As of now, we have no experience with OLE DB, and the ap ...Show All

• Visual Studio Team System Problem with references in TFS

  Hi guys, I am having troubles with references in a projects under Source Control, VS2005. And because of them cant run TF Builds. The probem is that when I am finished with editing source code of some solution under SC and it runs perfectly, and I check in pending changes after that, but when some other guy from the development team `checks out for edit ` same solution, even though he clicked that `get latest version` before, he gets errors with references to dll files, custom made components, even though path is the same and they all point to valid and up to date dll`s. And every time someone else has to work with particular project, he has to remove all references manually and add them up from that same directory in order to bui ...Show All

• Windows Forms Numeric Only Cell/Column in DataGridView

  I need a numeric only cell/column for the DataGridView. I'm guessing that I'd need to create a custom column inheriting the DataGridViewTextBoxCell. Are there any examples of this or has someone already created it Thanks, Kyle Thanks for the reply. I've seen the numeric up/down column... also the Calendar one and one that has a MaskedEditBox. All very good. But what I need is a DataGridView Column that has a TextBox that only accepts numeric values. Also, I'd like to be able to specify the number of decimal places. I've seen other posts looking for this same type of column.... surely someone has developed one by now! It seems like a very basic feature that anyone using the DataGridView would need. I guess I'll tak ...Show All

• Visual Studio Tools for Office outlook add-in 2002 vs 2003

  I have built an outlook add-in on my machine (has outlook 2003) and is running fine. But when running the same dll in another machine (has outlook 2002) it fails. Any idea why Few Questions... Where it is failing What specific error message it is giving Have you tried running that from Visual Studio and check on what line of code it is failing ...Show All

• Smart Device Development Load Image from stream?

  .NET CF 2.0 Trying to load an image into a picturebox from a memorystream - is this possible when I try to do it I get a notsupportedexception theImageStream.Position = 0; this .thePictureBox.Image = new Bitmap(theImageStream); I dont think so.... the whole writing to stream is "wrapped up" when we get a "command" or notification from the server saying something like EOF, which then it writes the last bits of data recieved (minus the EOF command) pretty much its:   write data from byte[] buffer into memorystream flush memorystream send memorystream to method   method wants to load the image from the memorystream, first setting the memorystream position to 0 (beginning of stream) & ...Show All

• Visual Studio 2008 (Pre-release) Return value of Interface type

  hi all how can i declare Method in service with Interface Type Return value for example [ ServiceContract (Name = "TestService" , Namespace = http://test )] public interface ITestService { [ OperationContract ] IUser [] GetAvailableUsers(); [ OperationContract ] I User AddUser( string userName); } my question is, how i can call this service and receive the value of IUser thanks Gili Does this thread help Cheers, ...Show All

• Windows Forms Windows Forms Designer Instablility

  I'm having trouble with the Windows Forms Designer in VS Pro 2005. I'm trying to build an MDI application where each document consists of a tab control with a different chart/text report on each page. I'm using the ComponentOne charting solution and trying to layout all the reports and charts in the windows forms designer. The IDE becomes terribly unstable. It quits unexpectedly without any error message at various points within the forms designer: changing focus from one control to another, editing control properties, adding one of my custom controls, and assigning a new event handler to a control. It also quits during the build, even at the very end. I think the problem may be related to a custom control. The control itself is fair ...Show All

• SQL Server VERY large binary import/export headache

  Hi, I am currently importing (and exporting) binary flat files to and from Db fields using the TEXTPTR and UPDATETEXT (or READTEXT for export) functions. This allows me to fetch/send the data in manageable packet sizes without the need to load complete files into RAM first. Given that some files can be up to 1Gb in size I am keen to find out a new way of doing this since the announcement that TEXTPTR, READTEXT and UPDATETEXT are going to be removed from T-SQL. I had a quick foray into SSIS but couldn't find anything suitable which brings me back to T-SQL. If anyone knows a nice elegant way of doing this and is prepared to share, that would be grand. Thanks for your time, Paul SqlServer 2005 has a new .write extension to the UPDATE s ...Show All

• Windows Forms How to create window controls using database values

  Hello everyone, my name is Brandon M. Hunter and I'm a programmer...(AAA introduction humor). Anyways I need to find a way to create controls at run-time (checkbox,radio buttons,etc) that is based off the number of records I have in my database. So for example, I have a 5 records that are defined as subjects that a school teaches, I need to create 5 checkboxes for each of those records Does anyone know I tried using this piece of code for example: Private Sub Button1_Click( ByVal sender As Object , ByVal e As System.EventArgs) Handles Button1.Click Dim i As Integer = 1 Dim stringTest As String For i = 1 To 4 Select Case i Case 1 stringTest = "checkboxvalue1" Case ...Show All

• SharePoint Products and Technologies sate machine workflows in share point site

  hi i want a solution wher i can create state machine workflow using infopath forms as user interface. once workflow is created i want to attach it to document library of my sharepoint site. if anyone can pass on some clue,i will start working help ...!! ...Show All

• SQL Server dbo user / permissions error.

  I had found one or two other questions about this, but neither of them seemed to be the same as my instance, and there solutions were not valid for me. I purchased the Build a Program Now MS Visual C# 2005 Express Edition book with CD. This was installed by the auto installer on the disk. which included the SQL Express 2005 version. I have used the Visual Express C# interface, build a small program, created the database, created tables. all went well. I can even add data, and so forth. My problem came when I went to click on database Diagrams in the Database Explorer. I get a Dialog box stating " This Database does not have a valid dbo user or you do not have permissions to impersonate the dbo user, so da ...Show All

• SQL Server Return first row only for each of the same group

  How would I just display the first record the query comes to for each set of groupings in a certain column. Say I have some names with phone numbers and I have sorted these so that even though one person might have 3 phone numbers, the most relevant one is going to be the first one listed. I can get my query sorted where I can do it this way, but I can't seem to find a way to return the first record of a group like in the example above. It simply returns the position of a row in the output set. It is easy enough: row_number() over (partition by columnName order by columnName ) Partition by (optional) is used to reset the count: Partition by id Id row_number 1 1 1 2 1 3 2 1 3 ...Show All

• Windows Live Developer Forums Limiting results to one domain or a set of explicitly defined domains

  I would like to limit the web search results to the particular Web site domain that the api is implemented on. So that all the results return will belong to this domain. I can manually filter the results by the result Url property but because of the limit on the number of results being returned I will have to make consecutive requests to the search server until I have completely checked all results or until a tempory collection of results reaches a length equal to the total results per page limit. In addition to the above mentioned issue. There is this request per day limit of 10,000 requests. if every search request cannot return more than 50 results per page (on average) a 50,000 item result set will take up 5000 requests of the 10 ...Show All

• Visual Studio Express Editions Express for Small Buisness

  HI : I am from Pakistan, Lahore. As Microsoft products are licensed and their use in production environment entitles with "some cost". Can small businesses or self owned type business use the "express editions" for their customers. Please also refer some link which briefs about the "feature difference" between Express Web Developer / C# Express developer and Visual Studio Professional /Standard Edition. Please help. oh sorry hi, Muhammad Ali Inayat  (what a long name, ) Which edition you'd choose depends on what kind of project you want to dev and the function you gonna to implement. If you use it to study or other self-use, then ex ...Show All

• Software Development for Windows Vista Problem to install software in Vista (windows/system32 folder)

  Hello, I have an VB6 application who use hhctrl.ocx to the help file and use msmapi32.ocx to prepare email, etc.. I have test this software with Vista but I can install these activeX ! I find that a securite ! But how can I do All system (XP, 2000, NT) haven't by default hhctrl.ocx or msmapi32.ocx ! I Do install it.. Please help me, thanks christof Hello Matthew, In fact, the installer ( Ethalone Ghostinstall http://www.ethalone.com ) install and reg the file in %system%. To launch the install software on Vista I click-right and choose "run as administrator". And during the installation, I have a message [Can not register C:\windows\system32\hhctrl.ocx]. I have try in the install to unreg this file, and it is ok ! But ...Show All