Dogbrain's Q&A profile

• Visual C# Timeout expired in SqlCommand.ExecuteNonQuery (insert) for SQL Server 2005

  Hi, I am upgrading from VS2000 & SQL Server 2000 to VS2005 & SQL Server 2005. One of my massive programs has an exception after a lot of inserts to a certain table during insert via SqlCommand.ExecuteNonQuery: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) ...Show All

• Visual FoxPro How to check if an Array exists?

  Select * from myTable where isnull(myTable.keyField) = .f. into array myArray if alen(myArray) > 0 ** Loop through array and Do processing end if In a situation where records selected by the query are 0 then the array is not created and thus the next statement gives an error. How can I check if myArray exists before doing any further processing Thanks for the indepth explanation CetinBasoz. I see your point and I think I am going to try to incorporate type('alen(arrMyArray)') = 'N' in my code. ...Show All

• Visual Studio Team System When do reverse deltas take place?

  The TFS FAQ mentions that the server creates "reverse delta" of both binary and text files "asynchronously as a background task". I'm unable to find any other information on how or when this reverse delta creation happens, what factors affect how long it takes, and if it can be controlled.  Is there any documentation on this In addition to just wanting to know, I'm interested in understanding reverse delta creation as I am experimenting with using TFS as a large binary data file version control system. I'm working with a company that has to manage large binary data files  (not documents and which cannot be easily convert ...Show All

• Visual Studio Team System NUnit or VSTS Team Test

  Discuss.... We have mstest.exe for running tests from the command line (in case you're not using MSBuild.exe) and we also work with msbuild's "tasks" where you can specify which tests you'd like to run.  These are authored from the UI when you're creating a new "build type" as part of VSTS. Tom ...Show All

• Visual C# multiple pages in windows form

  you saw the book view in Ms Word for sure.(multiple pages not in print or report) how we can create this kind of view in Visual Studio .net which container control must be edit Virtual Studio .net Whats this. Can you explain your question in more detail. Are you talking about TabControl ...Show All

• Visual FoxPro VFP linked server issue

  We're using SQL Server for the majority of our applications, but our accounting package is still in VFP 8.0.  I need to make some costing adjustements from our inventory program.  I have linked the VFP database to SQL Server just fine and, using OPENQUERY, I can SELECT data without a hitch.  Performing an UPDATE or INSERT, however, is a different story.  I get the following error: "Server: Msg 7301, Level 16, State 2, Line 1 Could not obtain a required interface from OLE DB provider 'VFPOLEDB'." Scouring the internet wasn't very helpful on this.  Can anyone offer me any suggestions ...Show All

• .NET Development Batch update not executing according to SQL Profiler

  For some reason, that I don't see, this code is not updating the storedprocedure. When I step through the .update line there is not trace in profiler. Additionally, the data is not saved in the table. Do you see a syntax error Thanks. using ( SqlConnection cn = new SqlConnection (DBConnectionString)) { using ( SqlCommand updCmd = new SqlCommand ( "sp_web_edit_manager_update" , cn)) { SqlDataAdapter adpt = new SqlDataAdapter (updCmd); updCmd.CommandType = CommandType .StoredProcedure; updCmd.CommandTimeout = Convert .ToInt32( ConfigurationSettings .AppSettings[ "dbCommandTimeout& ...Show All

• Visual Basic How do you make a text in a console application?

  Please help. Do you mean how to output text in a console app easiest way: console.WriteLine("Hello World"); Hope this helps, Josh Lindenmuth ...Show All

• Visual Studio Express Editions What should be written in order to randomize movement of a picturebox ?

  If i want to make a picturebox move either to the left by 3 pixels or more wot should i write Is there an appropriate random function When it comes to generating random numbers, look no farther than the Random class (System.Random). To create an instance (with a changing seed value to ensure more randomness), we simply instantiate a copy: Random rand = new Random(DateTime.Now.Millisecond); To get a random integer value you need only call the Next() method, and to specify upper and lower bounds, just pass them in as arguments: rand.Next(1,3); When moving the PictureBox either right or le ...Show All

• Visual Studio Team System Unit Testing Web Service created from Appliction Diagram

  Scenario . (Simple File based Web Service created from Application Diagram)   1. Create a Distributed System Solution.   2. Add a Web Service to the Application Diagram (Leaving the Project property as default so a Cassini file based web app will be created)   3. Right Click - Implement All from Application Diagram. (This creates the file based Web App with a single empty web service)   4.Add a simple hello world method to the Web service. (including the WebMethod attribute)   5. Right click on the new hello world method and select Create Tests.   6. Select option to create a new projec ...Show All

• Visual Studio Express Editions Splash Screen Delay

  I'm following along in the "Build a Program NOW" tutorial and on page 100 it states that a code snippet is available to set the dealy of a splash screen. I can't find the snippet. More importantly I can't find anything on the msdn site telling how to accomplish this. This seems like an issue that would be VERY common. Why no help Can the screen be made to stay untill a condition is met - for example untill a sub has completed execution and returned a variable Thanks in advance for the help! See if the following thread helps: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID= ...Show All

• Visual Studio 2008 (Pre-release) Internal Server Error when accessing MEX

  Hi, I have installed January version of WCF and I have problems accessing Metadata Exchange in the simplest scenario (which used to work in Beta 1). The code is extremally basic - hello world code. Just to eliminate potential problems. When I access: http://localhost:8080/Service1/mex I get internal server error. I've tried also to use directly MetadataResolver to fetch data from this url, but it failed. I also tried to manpulate with metadata publishing behavior, but I couldn't succeed. Any hints App.config: < xml version = " 1.0 " encoding = " utf-8 " > < configuration > < syst ...Show All

• Visual Studio 2008 (Pre-release) WindowState.Maximized hides the TaskBar

  Hi, I was wondering if this was intended or not, but when you set a WPF Window's WindowState property to WindowState.Maximized, it hides (overlays) the taskbar. In WinForm's, when you set the WindowState property to WindowState.Maximized, the taskbar is still visible. If this is the way WindowState.Maximized is supposed to operate, how would I go about retrieving the position and the size of the taskbar, so that I can adjust the size of the Window appropriately Thanks. Kevin I had more or less the same problem http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=336542&SiteID=1 I fixed ...Show All

• SQL Server varible passing

  Hi: When i try to execute the following stmt using sqlcmd, it is giving me error. c:\>sqlcmd -i "c:\sql\config\DDLLogging.sql" -v LogDir='c:\sctclogs\' the error is Sqlcmd: ':\sctclogs\'': Invalid argument. Enter '- ' for help. but when i pass just -v LogDir='c\sctclogs\' it work fine. The problem is with ":" when i put colon it throws error. Any help to execute the above command would great. Thanking you, Best regards, Kumar If you have a question, please choose an appropriate forum, and ask it there. Don't spam the whole site. Please LMK which forum you ...Show All

• SQL Server Accessing the Report Builder Application

  Hi, Report Builder Application can be accessible only through Administrator previleged users or any user can access the report builder application If it possible then how do we access it . Here we have a list of domain users, I have given the Report Builder rights to all domain users in the properties window in Report manager. When the domain user logging into the report manager, they can not able to see the report builder icon. Once I add my domain users into my server's administrator group they able to see the report builder icon as well as they can work with the application. Expecting your answer in this. Thanks in advance ...Show All