RobertDufur's Q&A profile

• SQL Server Is it possible to have more than one table footer rows ?

  Well, we can add another table footer row by right-clicking on the footer row of the table and select, Inser Row Above, or, Insert Row Below. But, I want to set different values to same properties of rows. Such as; Row3.RepeatOnNewPage = False Row4.RepeatOnNewPage = True What do you say -SMang the Frustrated Developer SMang, You can't hide your table rows independently with the RepeatOnNewPage, but you can set the rows "hidden" property to true or false. The catch here is that you will need to tie it to a toggle item. Ham ...Show All

• Visual C# "Search" webpage can not be displayed after moving to webhost server

  Hello: I'am having a weir problem right now. I just recently moved my webapplication from local server to a web hosting server(which supports asp.net 2.0 and sql 2005). My search engine(which works perfect when it was hosted on local machine) seems getting problems. After I input the searching key words and hit on enter, normally I supposed to be redirected to the searching result page, and now I dont even get any error message(since in some other cases, I would get error message such as "error codeXXX," ) it just simply says "Internet explorer can not display this webpage". I checked all my code, I dont see any error there(since the same code works fine on my local machine). And the weird thing is as fol ...Show All

• Windows Forms Update

  I make a database connection with using properties( not with writing code, only using the visual studio's wizards). And I control this databsase with this codes. But this can't update the database. How can I do for Update my database. //------------------------------------------------------------------------------- using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace WindowsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load( object sender, EventArgs e) { ...Show All

• Visual Studio Team System CTP7 CPU Very Busy

  On several occasions Data Dude has stopped responding while using from 50 to 90% of the cpu. It's happened while performing a data compare, while unloading a project or while trying to close a project. Some times I see the error message " Failed to retrieve msbuild property DBProduct from the project file ." Sometimes it comes back, and others it will run for hours if I let it. Has anyone seen this issue before Richard, It is happening with me. I am using the RTM version. It is not unusual for me to attempt to close my project and have VS seemingly hang up. My project has about 3200 objects in it. The 'devenv.exe' process is usually at about 50%. Sometimes it comes back, often times, after ...Show All

• Windows Forms Smart Client - Data Centric - SQL 2K to SSE local

  Smart Client - Data Centric - SQL 2K to SSE local Trying to develop a smart client which will have data centric approach for storage of local data. The server is SQL Server 2000 and foot print database is going to SQL Server Express 2005. Is Merge replication a vaiable option. Can somebody guide me on this approach Thanks! ...Show All

• Visual Studio Team System CTP7: Schema Comparison - DEFAULT ((0)) versus DEFAULT (0)

  A user imports a db schema and then compares the imported schema with the current database. Differences are reported related to DEFAULT. The user clicks "write updates", then "refresh" -> Differences are reported related to DEFAULT. Hi Rlaph, Schema compare always ignores the extra parenthesis in default, and must not be the actual cause of the difference, irrespective of the option "ignore whitespace" set to true or false. I have confirmed it again at our end by comparing the pubs database VS its imported schema into the database project.. If you scroll further in the object definitions window, I am positive that there will be other differences which are causing the ...Show All

• Visual Studio Generate C# 2005 project files

  Hello, I am looking forward to manage some C# projects programatically. Precisely, I am generating C# files and I want them to be added and removed from their projects on-the-fly. It would be very useful to add VSS checkin and checkout compatibility in the process. To achieve this, I think have to be able to at least generate C# projects as well. What is the most efficient way to write these files Is VS 2005 SDK suitable for that task It would be very nice if I could use a method that offers maximal compatibility with future versions of Visual Studio. Thanks! Marc Lacoursiere RooSoft Computing As of now, I have not written anything related to csproj file modification or msbuild ...Show All

• SQL Server How to I run a DTS package from a stored procedure? thank

  I created a DTS package to transfer data from a remote database into my local database, I want to run this DTS in my stored procedure, can I do that Please help me, thanks a lot Another method would be to use the system OLE automation SPs and use the DTS object model to invoke the package. Please search the web for several examples. Btw, this question is more suited for the SQL Server Integration Services newsgroup so I will move the thread there so someone there can point you to appropriate resources/links. ...Show All

• Software Development for Windows Vista User Accounts in Windows XP

  I use Windows XP and I have 3 accounts set up on my computer one for myself and one for each of my two sons. I wanted to set the accounts for the boys up as a limited account, however when I do their games will not work their accounts have to be set as computer administrator. Is their anything I can do to get their games to work under a limited account I would really appreciate any help! Unfortunately this forum is dedicated to Windows and Vista programming and not general Windows troubleshooting and I must ask that you direct your question to one of the more relevant Windows XP Newsgroups . ...Show All

• Windows Forms Validation for E-mail address

  ================================================================ Development Environment: VS2005 Language: VB.NET ================================================================ What are the best ways to check an entry to see if it is an e-mail address The masked textbox doesn't appear to have an option for email and the custom settings I have applied limit the user to only a set amount of characters before the "@" sign and "." In the background I currently create a variable to hold the original entry value, then I remove the "@", finally I compare that variable to the updated field. If it matches, then it goes on. Well, as many of you can tell, there are easy ways to get around this validation. Can someone ...Show All

• Visual Studio Team System Prompting to save changes to query when user does not have permissions

  Minor grumble on my part If you modify a team query format (e.g Right click header and select Column options) you are prompted to save query on closing but if you choose OK and you are not an admin you receive a security warning. It would be nice if you were not prompted to save unless you have permissions. (Saves a click to get rid of the MB) Not really expecting a resolution of this one. I guess the workaround is just create your own queries and modify them as you like since you can save them. Maggie You can actually select File\"Save as" and save your changes into a private query or a file. So you can use team queries as a starting point and the prompt will help ...Show All

• SQL Server OpenQuery() to Linked Server hangs, leaving SPID with open tran, then templog.ldf grows without limit.

  Hi, We have a customer that is using SQL Server 2000, and experiencing the following intermittent problem -- occasionally templog.ldf will grow and grow until it fills the entire disk. This is a rare problem, it has happened less than 10 times in the past two years, for a job that runs once a minute. But it has happened on 3 different SQL Servers, (two production servers, and one test server). Our suspicion is that the root cause is an OPENQUERY() to pull data from a linked server (Oracle database on Unix). We have seen that these OPENQUERY() statements occasionally hang and cannot be killed. The OPENQUERY() is used to populate a local table, and when we originally populated permanent tables with OPENQUERY(), then there would be a ...Show All

• .NET Development Serialization issues with Nullable Datetime

  I'm the consumer of a webservice from another company. In one function I need to pass a complex type wich contains an element which takes a nullable datetime value. Whenever I pass a value, only the date is serialized and the time is not. Unfortunatly the webservice needs the time to be passed as well and will raise an error. Datetime values that are not nullable are serialized correctly. ...Show All

• Visual Studio endless loop while debugging in Visual Studio 2005

  Problem with debugging exceptions in Visual Studio 2005 When we are running our winform application and an exception occurs, Visual Studio 2005 breaks in debug mode. Of course this is normal, but somehow we end up in some kind of endless loop. This behavior occurs when we make a call from our client to our server using remoting hosted in the "ASP.NET development server". Client side we catch exceptions this way: AppDomain .CurrentDomain.UnhandledException + = ... and Application .ThreadException += ... What happens is that VS breaks and displays a yellow line on the line catching the exception, and then we hit F10 to continue step by step and all of a sudden automatically the call to the server ...Show All

• Visual C++ png lib linking

  I have a C++ main project which is a 3D editor, much like Quake Radiant. One of it's child projects is a texture manager in a static lib, called texure.lib texure.lib links to two other static libs(I have built separately) - tga.lib & jpg.lib. This works fine. The main project builds, and I can display the textures. I have now built zlib.lib as a static and used it to build a static png.lib. I used png.lib with zlib.lib to build the test program that comes with the png download, and it runs fine. When I add png.lib & zlib.lib to the texture.lib, it rebuilds just fine. But when I rebuild the main project I get link errors like these: 2>Texture.lib(pngread.obj) : error LNK2001: unresolved external symbol ...Show All