Sterling Swartwout's Q&A profile

• .NET Development DataTable Stripping time from DateTime

  Hi all, I have a problem that I can't figure out again and need some help. I import data into a DataTable and I need a tool to remove the time (ie set all to midnight) from the dates in the DataTable to help with grouping after it has been populated. Inside a loop I do this DateTime dtmBuffer = DateTime .Parse(dtbDataGrid.Rows[intLoopY].ItemArray[intLoopX].ToString()); and then I set the DataTable to just the date part dtbDataGrid.Rows[intLoopY].ItemArray[intLoopX] = dtmBuffer.Date; but the new value doesn't seem to be put into the DataTable - the time portion remains at whatever it was before! Can anyone help with any ideas Justine Hi Ilya, Thanks very much for your help - please understand that I was ...Show All

• SQL Server Report pagination for charts

  Hi, We have developed few reports displaying data using chart layout. In the Data tab, we have specified MDX query that will return top 10 records. But now, instead of restricting to just top 10 records, we would like to display all records and go in for pagination. Is there some setting in the chart properties, where in I can display the first n records in first page, and the next n records( if available) in the next page and so on Can I specify the value of n somewhere in the propeties I read through many posts regarding pagination but those couldn't help me much. Please help me in solving this problem. Any help would be appreciated. Thanks in advance! Thanks a lot Robert! ...Show All

• .NET Development No row at position 0.

  I am trying to show/hide a control based on the value of a boolean DB field with the code below: Dim dsAdmin As New DataSet Try DBCon.ConnectionString = csWBoard DBCon.Open() userAdpt.SelectCommand = New OleDbCommand _ ( "SELECT admin FROM [User] WHERE (userID = '" & userName & "')" , DBCon) userAdpt.Fill(dsAdmin, "User" ) If dsAdmin.Tables( "User" ).Rows(0).Item( "admin" ) = True Then mnuAdmin.Visible = False Else mnuAdmin.Visible = True End If DBCon.Close() DBCon.Dispose() Catch ex As Exception MsgBox(ex.Message) End Try The field is of type Yes/No in my MS Access DB and the format property ...Show All

• Visual Studio Team System Cannot edit TFS Reports with Visual Studio Report Designer

  Hi you all, I'm having a problem while opening Reports provided by TFS (such as WorkItems.rdl) with visual studio. When I try to "Preview" the report I get the error: An error occurred during local report processing. Query execution failed for data set 'IterationParam'. Incorrent syntax near 'Measures' I get the same report for different datasets if I try to check other reports. The datasources (TfsOlapReportDS and TfsReportDs) are well configured in both the report server and the visual studio project. These reports work well on the report server, but I need to edit them. Any suggestions Many thanks in advance.   Hi Nick! I've still problems with the default value for ExplicitPro ...Show All

• Visual Basic HTML/HTTP Guidance needed.

  I am looking to create a small app which will send info to a web site and return info back. Specifically trying to track packages via ups/Fedex/Dhl/USPS. Can anybody point me in the right direction for some basic info on web programming. Jake JohnWilliams, I don't know whether you're familiar with the .NET Framework and ASP.NET web development. There are so many scripts to sovle your problems except the .NET framework or other platforms. Here I will give you an example on ASP and hope that can help you: Create the Active Server Page. Our Active Server Page will retrieve a single value posted by Excel 97 and create a SQL statement using that value as criteria. In an Application (or Virtual Dir ...Show All

• Visual Studio Changes or Fixes in VS 2005 SP1 Beta?

  Does anyone have the release notes of the new beta service pack I'm trying to find out if any fixes have been made to ReportViewer control Kevin We have made a number of fixes to both the winforms and webforms report viewer controls. I don't have a complete list compiled yet, but I will be publishing one when we get closer to the final release. If there is a specific bug/feature you are curious about, let me know. ...Show All

• Software Development for Windows Vista Workflow With Asp.net Sample

  i need samples for reject and approval using asp.net: such as page Default.aspx get the user ability to request vacation and Manager.aspx approval or reject the vacation.   can any one help me please. thanks. thanks mr.Vignesh Kannappan, but i dont need the same examples my problem that when hosting the workflow from one page, in the middle of my workflow I need to get manager approval but when open the Manager.aspx page and fire the event will not get the manager approval. Oka , will discuss it in more now: In my project I have three project with one solution The first one: WebSiteHost that contains Default.aspx page that gets the user ability to host the workflow, and the Manager.aspx page. The Glob ...Show All

• Visual Studio vss & vs2005: error when check in, check out, read last version...

  hello world, i'm using vss in vs2005, but when i try to check out, check in a file or make any operation involving source control i get this error: all ok: i simply have overwrited oledb32.dll with this one http://www.dlldump.com/download-dll-files_new.php/dllfiles/O/oledb32.dll/2.81.1117.0/download.html and then i have registered it ...Show All

• Software Development for Windows Vista How to Serialize individual Ink Strokes?

  Hello, I am just wondering how to serialize individual ink strokes. When I attempt to I catch an exception stating that the Ink.Stroke object is non-serializable. I would love to not have to save the Ink object and serialize the entire thing, but instead simple grab a single stroke and serialize it. Does anyone have any information that may help with this Thanks again! Now that we have an Ink object with just one stroke, how do we transfer that stroke to an already existing Ink object hat has strokes I'm running into a few issues and was just wondering if there was something straightforward that I'm simply missing ...Show All

• .NET Development best practice for accessing mysql 4.1?

  i wanto to run some inserts,deletes,updates and selects against a mysql 4.1 database since c# 2.0, so i d like to know whats the best practice, should I use just oledb provider or u suggest me some connector or driver to download from internet This web app (asp.net 2.0) will be hosted in a hosting that supports asp.net 2.0 and mysql 4.1 Hope find a good suggest. Best Regards Joseph Hi, Of course u can work with oledb or odbc providers but always native access is always better specially in performance. Mysql drivers for .net 2.0 are available here . They just work fine. HTH ...Show All

• Visual Studio VS2005 SP1 on Vista RTM

  Aagh. I installed Visual Studio 2005 on Vista Ultimate RTM. It said there were known compatibility issues. I installed the SP1 beta. It said Visual Studio should be run with elevated permissions. I set the "Run this program as an administrator" checkbox in the Compatibility tab for devenv.exe. Now, every time I run Visual Studio, I get the "An unidentified program wants access to your computer" popup, because the SP1 devenv.exe is from an "Unidentified publisher". Is there any Vista trick I can use to permanently trust the executable (aside from turning UAC off) NB: the VS version number is 8.0.50727.363 (SP.050727-3600) When ever you run a program as Administrator you will get a UAC unless you tell the TOTAL system to su ...Show All

• Windows Forms Validated event close button

  In window form application for controls (e.g. textbox) I have implemented validating event and validated event for validation. But these events doesn't invoke for current selected textbox control when I click close button ("X" )on top of Window form. How can I force to invoke it when user click on close button. Thanks Hi, try calling ValidateChildren method on your Form_Closing event: private void Form1_FormClosing( object sender, FormClosingEventArgs e) { if ( e.CloseReason == CloseReason .UserClosing) { e.Cancel = !ValidateChildren(); } } Andrej ...Show All

• Visual Studio 2008 (Pre-release) Security problem in calling wcf service from other machine

  Hi all, I was trying to call my wcf service (in machine with os XP sp 2) from a client in other machine (Win Server 2003). What I did is just change the address in config file. But it generated error message related to security issue. My question is how to make the security low so I could call my service from another machine Since the security issue could be ignored in my case. What changes should I make on the config file I've seen some threads before related to using wcf in different machine, I tried to change the setting in <security> part in config file. I used the credential type = basic. But it then generated the error that username and password is not defined.So how to provide username and password in clientcredential ...Show All

• Visual Studio How to erase a dataset in the website data sources?

  How do I erase the dataset I created in the website data sources I can only refresh it in my view. Any ideas Thanks These topics are covered at www.asp.net where you will have access to more expertise than exists here. OTP ...Show All

• Visual Studio Team System MS Project 2003 Dates not retrieved from TFS

  When retrieving work items using MS Project, dates are not retrieved correctly. The dates can be viewed using Excel or Team Explorer. Any ideas Alyaru, Thanks for the additional information. Regarding other fields being refreshed even though attribute PublishOnly="true" is a bug. I will log a bug regarding this issue. Regarding the old issue(Dates not getting refreshed) MS Project does scheduling on all the tasks automatically based on certain fields including "Remaining Work" and "Completed Work".This is the reason we made the date fields "Publish only" in MS Project and not editable outside MS Project. So that users edit these fields in MS Project and all the scheduling fiel ...Show All