bentran's Q&A profile

• SQL Server [rsAggregateReportItemInBody] The Value expression for the textbox 'textbox6' uses an aggregate function on a report item.

  I put this into a textbox, why isn't this possible =SUM(ReportItems!GrossGoal1.Value) I need to do this!!!! [rsAggregateReportItemInBody] The Value expression for the textbox 'textbox6' uses an aggregate function on a report item. Aggregate functions can be used only on report items contained in page headers and footers. [rsMissingAggregateScope] The Value expression for the textbox ‘textbox6’ uses an aggregate expression without a scope. A scope is required for all aggregates used outside of a data region unless the report contains exactly one data set. Build complete -- 2 errors, 0 warnings Is there another way to g ...Show All

• Windows Forms DataGridView CurrentCell Border

  I'm using a DataGridView and want to control the display of row borders based on special criteria. My stuff is providing satifactory results, however, it seems that the CurrentCell always has a dotted border, regardless of my actions. This border distracts from my changes. Can someone tell me how to suppress the dotted border for the grid's CurrentCell Thanks. The only way to supress the dotted focus rectangle is to handle the RowPrePaint and "and" out the focus PaintParts. Here is how I would do this in C#: e.PaintParts = e.PaintParts & ~DataGridViewPaintParts.Focus;     -mark Program Manager Mic ...Show All

• Visual C++ calling a WINAPI function from a managed main creates linker error

  OK, here is the latest saga from this newbie: Whenever I try to call EnumDesktopWindows or GetWindowsText the linker vomits out the following: LocateWindow.obj : error LNK2028: unresolved token (0A00000D) "int __stdcall EnumDesktopWindows(struct HDESK__ *,int (__stdcall*)(struct HWND__ *,long),long)" ( EnumDesktopWindows@@$$J212YGHPAUHDESK__@@P6GHPAUHWND__@@J@ZJ@Z) referenced in function "public: void __thiscall LocateWindow::setPopulateWindowArray(void)" ( setPopulateWindowArray@LocateWindow@@$$FQAEXX Here is the code: (Yeah, its ugly. I am coming at this slow so I get as much of the concepts down as I can) // LocateWindow.cpp : main pr ...Show All

• Visual Studio schedule for beta and V1 releases?

  Hi, I would like to know if there is a (rough, approx.) schedule for the release of a beta and the final release of V1 of the DSL Tools. A brief summary of the features can be found in my blog entry at: http://blogs.msdn.com/stuart_kent/archive/2005/12/13/503090.aspx and in my reply to the following post, which also comments on the schedule: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=225280&SiteID=1 ...Show All

• .NET Development Cannot find member name System.Data.SqlClient.SqlError

  [reposted from newsgroups] Hello, We've got a WinForm application that uses remoting to connect to our servers. Fairly recently, we've started seeing the above error instead of the SqlException we should be getting. I've found one thread through google that seems to be about this problem, but the post that supposedly solves it is no longer available and the KB article for hotfix 887549 doesn't mention this particular error. The problem appears to be that Windows Server 2003 SP1 installs a newer version of System.data.dll than XP has. XP: 7/15/2004 - 1.1.4322.2032 Server: 3/24/2005 - 1.1.4322.2300 Any suggestions ...Show All

• .NET Development Copy table from MS Access 2000 Database to MS Access 1997 Database2 using C# and ADO.NET

  MS Access 2000 Database MS Access 1997 Database Table 1 Copy Table 1 How Table 2 & Table 2 to How MS Access 1997 Database I have situation where I have to perform operation of copying table from MS Access 2000 Database to MS Access 1997 Database2 using C# and ADO.NET. Is there anyway to this operation fast and efficiently. Please Let me know Thank you You can do it with SQL ... using System; namespace JetDDL { class JetDDL { [STAThread] static void ...Show All

• Visual Studio Team System Use TFS with our DataBase functions, SP's etc.

  WE release our software once a week. In 1 months time we will have over 500 stored procedures in our DataBase. What we do for releases is when a stored procedure is changed, we put the Drop and Create parts of that script in our SQL Update Script. A problem comes up when Developer A changes My_StoredProc and then developer B changes the same stored procedure. Sometimes it works ok (the developer B will run the update script before changing his stored procedure. HOwever, it can happen where one Update script file has the same SP 5 times (5 drops 5 creates)... especially if over 300 SP's are getting updating in 1 release. We will alwa ...Show All

• Visual C# file properties - security

  Hi, I have a web application which a some point "formats" a csv file. Is there a way to add programaticly an user name with full control for the respective file "ids.csv". Please help, i have no ideea how to do it. Any input is appreciated. Thank you. While it might be possible to do this using C#, I would strongly suggest looking at some of the Windows Shell (WSH) scripts that are available to accomplish this. I'd also question whether this is something you should be doing from within your application. It is not considered good form for an application to add an arbitrary user and associate permissions with that new user. Leave it up ...Show All

• Visual Studio 2008 (Pre-release) Serialize a Visual Brush

  Hey, I was just wondering if it is at all possible to serialize a visual brush either by serializing the object itself (which i believe it is not serializeable) or by converting it to another object type and serializing that. I was hoping to use WCF to send a visual brush over the network to display the contents of it on another computer, perhaps in a rectangle control. I am not sure if it is possible or not.  I am thinking it isn't, but perhaps there is a way I don't know about.  Thanx for the help. ~ Stargex Why not just render the visual contained in the VisualBrush to a Bitmap and shovel that ...Show All

• .NET Development Read/Write XML file from windows application

  I have created an ASP website that reads contact information from an XML file. I used a Repeater to display the contact information in a table. When I update the data in the XML file manually (editing it with Notepad or something) , I can see that the information displayed in the web page is automatically updated when I refresh the page. BUT I like to design a Windows application through which I can update the XML file instead of editing it manually. This application will be designed specifically for this website so I will be knowing the structure of information in the XML file. The problem is, I don't know how to read or write d ...Show All

• Visual Studio Team System Should I get this (VSTS)?

  My buddie and I like making programs together or trying to beat each others projects. What I would like to know is would VSTS really be worth it Ok. I just ordered the BETA but seriously... Hi Jason, from what you described I don't think that VSTS is the right version of Visual Studio for you.  If you classify yourself as a hobbyist (or a student ... or someone who doesn't code all day every day), you may want to check out the Express Edition tools instead ... http://msdn.microsoft.com/express/ They allow you to create .NET applications with all the functionality you probably need ... the exception being the ability to manage co ...Show All

• Visual Studio 2008 (Pre-release) DataGridview with DLINQ

  Using Visual C# Express in a Windows Application I write with ADO.Net: SqlDataAdapter sql_adapter = new SqlDataAdapter("Select * from Customers", "Data Source=.\\SQLEXPRESS;AttachDbFilename=northwnd.mdf"); DataSet ds = new DataSet(); sql_adapter.Fill(ds); dataGridView1.DataSource= ds; dataGridView1.DataMember="Table"; May somebody translate previous sentences used in a WinForm to show in the datagridview the customers rows, for similar using DLINQ Thanks in advance Roberto Hello Roberto. Just for suggestion for you, I recently w ...Show All

• Visual Studio Express Editions How to.... make database changes without destroying datasets and related forms

  Hi there, I have created an application using SQL and VB express.  I have invested quite some effort into getting all the forms, datasets and overall application logic into shape.  My application is now up and running BUT.... I need to make some low level changes to the database. e.g. add some additional fields and change a primary key relationship on one of the child tables. Is there a logical way to proceed I have tried the following (with disastrous consequences)... a) deleting the datasets, with a view to installing a new datasets pointing to the new database,  (the form designer does not like this and can't recover) b) ...Show All

• Visual Studio Team System Data source-based web test does not run with test load agent

  I have made a Web test based on a database table where information such as userid and passwords are fetched to simulate several users. This works fins on my machine, and also when running a load test. Now I am trying to make a real test using the test load agent, but the test fails with an exception on the agent. This is from the log file on the agent. [E, 224, 10, 2006/05/18 07:37:38.222 109036049731] QTAgent.exe: WebLoadTestAdapter: Shutting down test due to exception: Could not access table 'Detaljdata' in data source 'PerfTestDB1' of test '4093edf8-674a-4952-b8fa-85b60e83d838': Invalid object name 'Detaljdata'. Stack trace: at Mic ...Show All

• Visual Basic Bug in For .. Next with Single data type

  Try the following simple code, by stepping through: Dim S As Single, T As Single For S = 16777214 To 16777218     T = S - 16777214 Next S Once S reaches 16'777'216 (hex FFFFFF) it will stop incrementing in the for..next loop, consequently T will remain at 2 I have the following System: Windows XP Professional, Version 2002, Service Pack 1, CPU is Pentium 4 CPU 2.4 GHz,  CPU-Driver Microsoft processr.sys Version 5.1.2600.1106 and Visual Basic 6 Version 8176. The same behaviour occurs with my office computer and laptop. Where is the problem Glad to get feedback at net dot meier @ bluewin dot ch ...Show All