yogibear0810's Q&A profile
SQL Server Creating Test Data for a Table
Hello, say I have a Table with 2 columns: integer ID varchar Description How can I insert a large number of test rows inside this table for experimentation purposes Thanx in advance! ManiD wrote: The following query may help you.. Create Table TestTable ( Id int, Description varchar(100) ) go SET NOCOUNT ON Declare @Count as int Select @Count = 10000 While @Count >0 Begin Insert Into TestTable values (@Count, 'Description ' + Convert(Varchar,@Count)); Select @Count = @Count - 1 End You can change your Count init value as you want upto 2,147,483,647 .. Nice, after seeing this I realised I mis understood the question ...Show All
Software Development for Windows Vista Regarding Windows WorkFlow Samples ...
Deal all Help Desk Demo by Don Esposito I need bit of information on two windows workflow samples. The first one is from MSDN Article "Windows Workflow Foundation" "http://msdn.microsoft.com/msdnmag/issues/06/03/CuttingEdge/ . This article leverage beta 2.2 version of WF. As we have move to RC now urgently need this sample code to run on latest microosft .net 3.0 release. Now can any one help me out here to convert/rewrite the sample code for .NET 3.0 RC. Purchase Order Demo by Don Esposito This Demo was part of article in MSDN by Don Esposito named " Getting Started with Microsoft Windows Workflow Foundation: A Developer Walkthrough " ( http://msdn2.microsoft.com/en-us/library/aa480214.aspx ...Show All
Visual Studio Antivirus and debugger compatibility.
Hello, Some hours ago I solved a problem with my debugger. Each time I started debugging my program, the debugger didn't work properly (clicking on F5 didn't go to the main menu). This problem I had it for several weeks. Today, I uninstalled my antivirus and spyware and then the Debugger worked correctly. My question is: Is it normal that the debugger does not work with the antivirus I tried even the most faible configuration of the antivirus but it didn't work.. I had to totally un-install the antivirus Or maybe I should do something else... The antivirus I am using is a service of "securitoo.com" a provider of wanadoo france. I will appreciate a hint on this issue cesar Anti-virus programs d ...Show All
Visual C# Using a Console with a Windows Form...
Alright, I've been searching but I can't find anything related to my question... I need to use a Console with my Windows Form (for debug purposes). How do I "add" a Console Another thing... I need to find out how to make a rich text box unwritable. Thanks! Haven't had a lot of luck with that. Closest I can get is this: // Delegate type to be used as the Handler Routine for SCCH delegate bool ConsoleCtrlDelegate(CtrlTypes CtrlType); // Enumerated type for the control messages sent to the handler routine enum CtrlTypes: uint { CTRL_C_EVENT=0, CTRL_BREAK_EVENT, CTRL_CLOSE_EVENT, CTRL_LOGOFF_EVENT=5, CTRL_SHUTDOWN_EVENT } [DllImport("kernel32.dll")] [return: MarshalAs(UnmanagedType.Bool)] static e ...Show All
Visual FoxPro about vfp9 sp2
does vfp9 sp2 have bugs a month ago,I installed sp2,but when I closed the cursor (got by SQLexec() from SQL Server),the IDE opened a dialogbox containing mistakes,then the vfp9 IDE closed right away, SP2 is still in Beta stage. By definition it is not ready and it may have bugs. That is why Beta testers install the software to report on problems they may find. Never install a Beta version in a production system and do not install a Beta unless you are prepared to test the heck out of it. For the latest bug info in VFP SP2 see: http://download.microsoft.com/download/a/b/3/ab3fd0de-74e9-4b0e-9510-82e9bd3a49e4/VFP9SP2_OctCTP_FixList.htm ...Show All
Visual Studio Express Editions Read Serialnumber of Harddrive
Hi, i want to read the serialnumer of hardrive. In 6.0 the it was working with this code Declare Function GetVolumeInformation Lib "kernel32" Alias "GetVolumeInformationA" _ (ByVal lpRootPathName As String, ByVal lpVolumeNameBuffer As String, _ ByVal nVolumeNameSize As Long, lpVolumeSerialNumber As Long, _ lpMaximumComponentLength As Long, lpFileSystemFlags As Long, _ ByVal lpFileSystemNameBuffer As String, ByVal nFileSystemNameSize As Long) As Long : Dim strRootPath As String Dim strVolName As String Dim lngVolSerialNumber As Long Dim lngMaxComp As Long Dim lngFSFlags As Long Dim strFSName As String Dim lngDummy as long strRootPath = "C:\" strVolName = S ...Show All
Visual Studio Using Help Generated by Help Studio 2.1 with my WinForms Application
Hi, I have the September RTM version of the Visual Studio 2005 SDK installed which includes Help Studio 2.1 How do I use the help generated/built by Innovasys Help Studio 2.1 within my C# WinForms application For example, if a user clicks on the help button, I would like the .hxs contents to be displayed for the user. I did a lot of searching, and am on the fence whether this is even possible or not. If it is possible, I would appreciate any pointers. If not, could you provide some alternatives. I have create a bit of help in Help Studio that I would like to use in my WinForms application. Is converting the .hxs to .chm and using that an option If so, how Thanks in advance. To clarify - th ...Show All
Visual C++ Finding if the VC Runtime is installed
I have the task of updating our applications to ensure that the c runtime is installed on machines that run our setup. Currently we use an older version of WISE to do this. I have the vcredist*.exe's embedded in our setups but Im trying to figure out is there a way to detemine if they are already installed I installed it and found lots of registry keys that get added and modified when the install occurs but is there a better way to figure this out than searching for the some reg key like "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VC\Servicing\8.0\RED\1033" Our application is installed via the web so size is a concern for us. We plan to use MSM to install the VC++ DLL if needed but we don't w ...Show All
Visual Studio Team System ERROR: 'WcfSecurityRules' assembly specified in the policy does not exist.
I am receiving the following error when checking in: 'WcfSecurityRules' assembly specified in the policy does not exist. I have installed VSTS for Software Developers as well as VSTS for DB Pros. I've also installed VS SP1. What is going on here FYI... a colleague of mine found the solution to my problem... Looks like these rules are FXCop extensions that you might not have on your machine - they're included in the Web Service Software Factory guidance package (see http://weblogs.asp.net/hernandl/archive/2006/10/03/FxCop-rules-for-securing-WCF-services.aspx for details). If you want to use the extensions, first download the Guidance Automation toolkit prerequisite at http://msdn2.microsoft.com/ ...Show All
Visual Basic Auto Primary Key with fill in
I want to setup a int primary key that auto increases but will fill in any missing numbers EG 1 2 4 5 7 The next primary key should be 3 (NOT 8) SQL Server 2005 VB.NET 2.0 How do I make the sql server do this, so that the data is safe from corruption / data loss. Dick Donny is correct...the idea of a primary key is to never have any duplicates even if the record has been deleted...if you setup a primary key as an auto incrementing integer with a seed of one then by default it will autonumber in sequence...when a record is deleted it is a best practice to never again use that primary key If you want to go against this "best practice" then you will have to code the primary key yourself....This ...Show All
Windows Forms Datagrid Cell return
Can anyone tell me if there is anything wrong with these statements: int _MyRow = this .currentTransactionsDataGridView.CurrentCell.RowIndex; int _MyCell = this .currentTransactionsDataGridView.CurrentCell.ColumnIndex; string _Account = this .currentTransactionsDataGridView.Rows[_MyRow].Cells[_MyCell].Value.ToString(); _Account is always "" - when I know its not. sorry for the previous post. Try this private void dataGridView1_CellLeave(object sender, DataGridViewCellEventArgs e) { string ss= dataGridView1[e.ColumnIndex, e.RowIndex]. .EditedFormattedValue.ToString(); } ...Show All
.NET Development Keep sockets alive when connection is broken
Hi, I have the following issue: I'm using sockets with SSLStream and want to keep the sockets active when an IOException is thrown on a BeginWrite for example. Let's say a client is connected to a server and the client tries a BeginWrite on the ssl network stream and just in that moment the internet connection goes down and an IOException is thrown with a result of the socket being disconnected. Is it possible to "RESUME" this connection on the very same port after the internet connection is reestablished My client/server works over the internet and I need a guarantee that the client received every message the server sent. So I give every message that is being sent a sequence number. If the sequence numbers have a gap, the clien ...Show All
Visual Studio VSS deploy causes client sessions on web server to terminate
Each time I do a Web-->Deploy from Sourcesafe to the web server running the application, all application client sessions on the web server are stopped. Is there are way to Deploy without stopping active sessions on the server I don’t think so. As far as I know, ASP.NET always recycles when you overwrite a file. Maybe there’s a setting somewhere that lets you override this behavior – try asking on the ASP.NET forums. ...Show All
.NET Development Deserialize Classes that inherits from DictionaryBase Class
I have one more queries regarding Deserialize Classes that inherits from DictionaryBase Class I have Customer Class that Contain ContactCollection Class and Occupation Class that again have ContactCollection Class ContactCollection Class inherits from DictionaryBase Class The Structure are as follows public class Customer { public Customer() {} private string _FirstName=null; private string _LastName = null; private ContactCollection _ContactColl = new ContactCollection(); public string FirstName { get { return _FirstName; } set { _FirstName = value;} } public string LastName { get { return _LastName; } set { _LastName = value; } } public ContactCollection ContactColl { get { return _ContactColl; } set { _Cont ...Show All
Software Development for Windows Vista CHttpFile::SendRequestEx ( ) fails on Vista
I'm in the process of making one of our apps Vista-compatible. (Visual C++, compiled with VS6). I've got everything working (Vista Business) except posting to a web server using CHttpFile::SendRequestEx ( ). The function throws a CInternetException with an error code of 12057 (which is not listed in wininet.h error codes, and the exception object contains no description). The code works correctly under XP Pro sp2 with IE7, but fails on Vista, even running as Administrator and XP compatibility mode. Exhaustive web searches have revealed nothing. Peter ...Show All
