Dylan Smith's Q&A profile

• Visual Studio Express Editions searching text (in a column) from a database

  Hi everybody (programming in VB2005 pro, beginner) I made an adressbook with a database from a SQL server pro. Now i want to make a form with the possibilty to search text in a specific column(in a database ) (e.g. First Name). So i made the form with a grid (named: GRID1), a textbox (named: TxtSearch) and a button (named:BtnSeek). So i need the code to put into the button to search in the column database what I have entered in textbox. It have to search in the column(FirstName), (No primary key). And if it has found a record, highlight that record . Pls help, thx in advance (pls post anything you know about searching in SQL databases) regards, Marnik You haven't read what I written, read it again and you'll ...Show All

• SQL Server DBCC command for data file size

  Is their a DBCC command or some other kind of command that can show how much of data file is actually being used I looking for something similar to the DBCC SQLPERF (LOGSPACE) command, but for data files You might try this: -- Individual File Size query SELECT name AS 'File Name' , physical_name AS 'Physical Name', size/128 AS 'Total Size in MB', size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS int)/128.0 AS 'Available Space In MB', * FROM sys.database_files; You could write a script like this to hit all of your databases. USE DatabaseName; GO SELECT name AS 'File Name' , physical_name AS 'Physical Name', size/128 AS 'Total Size in MB', size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') A ...Show All

• .NET Development Inner workings of the DataSets

  Hi, I'm using C# 2.0 and I'm wondering a bit about the inner workings of the DataSets. We get a "Timeout expired" error from time to time when using DataSets. So I had a look at the stack trace (posted below). Now, what does the SqlInternalConnectionTds.CompleteLogin method really do that generates an error Stack trace: CompApp.exe Error: 0 : System.Data.SqlClient.SqlException: Tidsgransen overskreds innan atgarden slutfordes eller servern svarar inte. vid System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) vid System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) vid System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateOb ...Show All

• Software Development for Windows Vista WF as a web service & capturing WF events

  I have seen a few examples of using ASP.Net as a WF host and then the host code subscribing to workflow completed, terminated etc. events. When you expose a WF as a web service, in this case you do not have any such code. What would be the appropriate way to capture such events in cases like this I would think that if I added a global.asax and tried to capture the information there, that this could cause a problem with not knowing which particular workflow was being completed or terminated. Thanks! Hi - Globals.asax seems to be a possible approach! You can get the specific information about the instance from WorkflowTerminatedEventArgs: e.WorkflowInstance. I guess that was your specific question - right ...Show All

• .NET Development Microsoft .NET Framework 3.0: x86 (KB928416) will not install.

  The following updates are already downloaded on my computer: --------------------------------------------------------------------------------------- Definition Update for Windows Defender - KB915597 (Definition 1.15.2321.2) Root Certificates Update Microsoft .NET Framework 3.0: x86 (KB928416) --------------------------------------------------------------------------------------- But they won't install. Everytime I try to install them my computer shuts down. And at night when I want to shut down my computer, it says on the screen that updates are going to be installed. I shut down the computer but it restarts, and the updates still aren't installed. I have -Windows XP -Service Pack 2 -Home Edition -Version 2002 ...Show All

• SQL Server Error creating first SQL Express database via VWD 2005 Express: "User does not have permission to perform this action"

  I get an error dialog when I try to create a new SQL database , both via the Add New Item dialog and the property wizard of a new SqlDataSource control. The error is: Local Database File: User does not have permission to perform this action. I've searched for help with this. I ensured the App_Data folder exists and I added the local ASP.NET account to the group that have R/W access to it (although the RO flag is in an unchangeable tri-state on the folder). The SQL Server Express error log is clean and indicates full functionality. Everything is running locally. No VWD installation errors. Any ideas Thank you! VWD creates your database using a User Instance is your U ...Show All

• SQL Server Comma Separated Values

  I need deptno and against/beside it comma separated ename's for join dept.deptno=emp.deptno in a single query. I require deptno=10 against/beside ename=scott,blake,richard,moxon like this. can u try this select * from dept,emp where dept.deptno = emp.deptno and emp.ename in ('scott','blake','richard','moxon') ...Show All

• Visual Studio 2008 (Pre-release) ItemsTemplate and DockPanel

  Hi! I'm trying to use a DockPanel instead of the StackPanel for a HeaderedItemsControl. I know how to get it to work but only for vertical (left->right) docking. How can I have a HeaderedItemsControl with every item docked to Top and the last item fills the remaining space (LastChildFill = True). Thanks. Thanks, that worked! I tried to set the DockPanel.Dock property in the ItemTemplate which doesn't make sense now that I think about it. The LastChildFill thing doesn't work out-of-the-box tho. How could I achieve that I thought by specifying a DockPanel with LastChildFill="True" in the ItemPanel property would be enough but it doesn't seem to be. Thanks! ...Show All

• Visual Studio Tools for Office DLL memory problem when called from within Excel

  Hopefully this is the correct place to post this. If not, please advise where I should ask this. I have a macro in Excel that calls subroutines from a .dll built with Compaq Visual Fortran. It works fine for all the routines except one. This particular routine dynamically creates a large 2D array (15000x15000 4-byte reals) and causes a virtual memory error when run. This routine does not cause this error when built and run as a standalone executable -- it runs fine and outputs the correct data. I created a similar routine as a C++ program and it also runs fine as a standalone executable. So the problem occurs only when the routine is loaded from the .dll. Is there something obvious I'm missing I have tried increasing the virtual memory of ...Show All

• Windows Forms DataGridView, CheckBox fields and Strongly Typed datasets....

  I have run into a particularly irritating problem and I am hoping that there is a simple solution. I have a couple of DataGridViews on tabs in a tab control. The DataGridViews have a mix of Check boxes and text cells in them. The Datasources are pointing to tables in a strongly typed dataset. In one case I have a non-Databound column ( a check box ) and in the other grid all fields are databound. The problem that I am seeing is that my column ordering is not staying the way I put it. Something that either I or VS 2005 is doing is putting all the checkbox fields at the very front ( far left ) of the datagrid. This gets very frustrating as it happens on the grids regardless of whether or not I happen to be actively working on them in V ...Show All

• Windows Forms ClickOnce ISV Mode

  Hi All, I've only been looking at ClickOnce for a very short time and so this question may be way too early. In any case: Is there a way ClickOnce can be used to distribute ShrinkWrapped Software. My question is specifically around building the bootstrap executable. Can we manage all of the following requirements: a) There are some redistributables that need to be set up and cannot just do an XCopy and so must be part of the Prerequisites. b) We dont want each customer hitting the Vendor's download area c) We dont want to host the downloads on our own site d) We only want to bundle all of the prerequisites with our deployment media (cd etc.) e) We want to let the customer choose a suitable distribution mode - CD/Network Share/ ...Show All

• Windows Forms multi select in grid

  Hi friends i've dataviewgrid with data from sql server db. our select can multi select on the grid. my question is ,users may sometime forget to hold Ctrl key and they loose all previous selections. and they have to redo all those selections again. am just wondering is it possible to have checkbox for selection (like in listbox) in grid Thanks for ur ideas Thanks Aaron. finally I've added a column of boolean datatype to bindingsource of my grid and i removed multi select property of the grid. now if users want to select multiple rows they can do so by simply selecting check boxes. much better now. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DrawTransform problem - ploted lines to suddenly "jump" to infinity

  Hi there, I use Line.DrawTransform to plot some 3D lines. They all plot fine, however when I start moving the camera forward all lines that are in the direction of the camera move "jump" to infinity when I clip the near plane (it is my guess that it is the near plane). Could you please help with some advice. My hunch tells me that it is a rather obvious problem for more advanced game programmers - too spectacular to miss :) There is not much in the code, really 1. I define the lines in a Vector3 [][] v3Lines = new Vector3 [1][]; 2. Draw the lines with float FieldOfView = ( float )( Math .PI / 4); float aspectRatio = this .Width / this .Height; //1.0f; float zNearPlane = 10.0f; //pure guess for this ...Show All

• Visual Basic Is the IDE Tab control available as a component?

  The IDE Tab control has some features that I would like as a run-time component - mainly the auto-hide feature. Is the component MS uses in the IDE availalble as a usable component If not, is there a tab control component that behaves like the IDE version with auto-hide Thanks for your replies. I wonder why MS did not include the component in it's toolbox as it is used to build the development IDE If any MS Visual Studio people are reading this, can you make the tab control component you build the IDE with available Thanks.. ...Show All

• Visual Studio Tools for Office Regarding VSTO Tool

  I want to know whether we can drop the project of VSTO tool on any form or not Hi Pallavi Yes you can do a "Document Style Assembly" solution in VSTO and you can markup using XML in the document to populate data fields from the Task pane or as this is a rich control on the right hand side you directly access the document content and do whatever you wish with it. There are some good starting guides on VSTO at the following addresses: http://msdn2.microsoft.com/en-us/library/d2tx7z6d.aspx Regards ...Show All