Erik Porter's Q&A profile

• SQL Server Providing Report Descriptions (for the users) from within the report

  All, We need to provide our report users with information what a report contains and the meaning of the columns on the report. It is too detailed for the report description area. I'm interested in any methods or suggestions that you have to integrate this type of documentation within the report services. Many thanks Ayla Do you have your own customer interface for viewing published reports If so, you can take advantage of custom properties when publishing the report to preserve whatever metdata you need and then presenting it to the user in your UI. http://msdn.microsoft.com/library/d ...Show All

• Visual C# Help~~! How could I encode the Chinese chararcter from the Web?

  How could I encode the Chinese chararcter from the Web As I'm working on the search engine that could only return the word which is only in UTF8. I would like to fetch more information from the Internet rather that discard the GB3121 code. Please Help ME~~~~~ Thanks to your kindness. Fundamentally, the architecture of the search engine is based on the "Spider", which is intended to parser the html or any other kind of text from the Internet. But the only functioning encoding method I had tried to employ in this project is to get the byte from ASCII code, and then translate them into Chiness character. I would like to try the I ...Show All

• SQL Server How to capture the entire DML statement in a DML trigger?

  Hi, In Yukon, is it possible to capture the entire DML statement with the parameter values that triggered the DML trigger inside the trigger body Basically trying to see the equivalent as the eventdata() in a DDL trigger, that provides the CommandText() Rgds SMO cannot be used within CLR trigger right now. It is not supported. Also, using profiler to do these type of actions from trigger code is not ideal. Triggers should usually be very light weight and efficient. The more complex logic that you put inside your trigger the harder it is in terms of performance, development and management. Also, I am not sure how useful it will be to k ...Show All

• .NET Development Go Live

  I am wrapping up developing an ASP .Net application with the GoLive license.  Choosing ASP .Net 2.0 was an error in this case. The databinding in ASP .Net is significantly harder to work with for anything sufficiently complicated.  Its great for binding to single tables and modifying reference data, but you end up working around the formview when doing anything complicated.  Figuring out how to do this took a little while.  There is no option for doing the databinding the old way, at least not with the designers, so you basically have to figure ways around the form databinding.  Ultimately this made the app ...Show All

• Visual Basic Unicode question

  After I have compiled my application are there ANY possible ways that UNICODE can affect the running of the application in any way at all For example (run on these systems characters typed and entered into fields will they be 4 byte characters ) If there is any possibility of any problems at all then how do I know when this is happening and how do I resolve the problems Michael J. Dyrnaes I keep asking you ... HOW do I know when I need to look for that "An example of the answer that I would have perhaps expected would have been that need to string comparison on every single data field every single time I have a use ...Show All

• Visual Basic Property not visible

  I have created a form with a defined property called InputSpread. Imports System.Drawing Public Class ImageForm     Inherits System.Windows.Forms.Form     Private cr As FarPoint.Win.Spread.Model.CellRange     Private bmap As FarPoint.Win.Picture     Private MyBitmap As Bitmap     Private myInputSpread As FarPoint.Win.Spread.FpSpread      Private ptStart As Point     Private recCrop As New Rectangle(0, 0, 0, 0)     Private EstablishCrop As Boolean = False     Property InputSpread() As FarPoint.Win.Spread ...Show All

• Visual Basic Generic Collections In vb.net 2005 Help

  Hi, Getting to grasp with Generics.Could somebody help as follows: In vs 2003 I used to write strongly typed collections now I could simplify it all with generic. I am trying to write some base collections What is the difference between inheriting from collectionbase  and list I have tried to implement the IEnumerator in my collection but the for each still doesnt work Can somebody provide a good example of collections using generics implementing Ienumerator,and explaining the diff between List and collectionBase Possibly in vb.net 2005 beta 2 Also some example of dictionary could help thanks a lot ...Show All

• SQL Server How to set Parameters with ExecutionService??

  Hello, I havent been able to set parameters with the reportexecutionservice. I also need to send a multivalue parameter, any ideas ExecutionInfo execInfo; execInfo = rs.LoadReport(path, null ); ReportParameter pEmpresa = new ReportParameter () pEmpresa = ( ReportParameter )DropDownList1.SelectedValue; execInfo.Parameters[0] = pEmpresa; execInfo.Parameters[1] = DropDownList2.SelectedValue; //rs.SetExecutionParameters(); StringBuilder selectected = new StringBuilder (); for ( int i = 0; i < CheckBoxList1.Items.Count; i++) { if (CheckBoxList1.Items .Selected) { selectected ...Show All

• Visual Studio Team System Remote Access Without DC

  Hi, I have configured TFS in a WIN2003 STD machine. I can correctly connect from computers inside my network, but when I connect form a remote client (outside my network), the reports and documents links doe not work because they point to http://machinename What can I do so remote clients get the IP address and also that the computers inside the network can connect Thanks in advance I did a little cheat, maybe it will work for others and it is easier than the URL suggested. I added tha machine name to the hosts file and that way the machine name is resolved to the IP. cheers ...Show All

• SQL Server Need help in grouping ....

  I want to display car reviews by authors.... a car may be reviewed by multiple authors.... but the latest entry should be displayed... the older enteries will not be displayed.... the following is the query [code] SELECT     CarReviews.Date AS Date, CarReviews.Company AS Company, CarReviews.Name AS Reviewer, CarMake.MakeName, CarModel.ModelName,                       CarModel.YearName, CarMake.KeyName + '/' + CarModel.Image AS Image, CarReviews.Id AS Id FROM         CarRe ...Show All

• SQL Server Parse error

  Can anyone tel lme why this does not parse in 2000 but works fine in 2005 ALTER TABLE Segments ADD CONSTRAINT PK_Segments PRIMARY KEY CLUSTERED ( SegmentsUniqueID ) WITH ( STATISTICS_NORECOMPUTE = OFF , IGNORE_DUP_KEY = OFF , ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY] thanks The WITH options cannot be set like this in SQL Server 2000. The ALLOW_ROW_LOCKS and ALLOW_PAGE_LOCKS options for example cannot be used like this, you need the sp_indexoption for that (however these are on by default). ...Show All

• Visual Basic Work with multiple projects

  I have a question regarding the "integration" of different projects: Firstly I would like to know if the beta2 version of visual basic express exports the forms in a way I can then use their design in other projects. I tried the wizard but doesn't seem to work. Basically what I need is import a form, previously designed in a project, in another project. I tried adding the project, that works although I don't know how to refer to the forms in the added project. If I use: My.Forms.Form1.Show()   It doesn't work as I cannot see the forms in the added project so I cannot refer to them. Thanks Leo ...Show All

• Windows Forms How to make a datagridview row "un-dirty"?

  Hi All, I have a datagridview. When a new row is added (by user) and has data, I insert a new record into the database table. My question is how do I mard the row un-dirty so that it will not be update/insert into the table again when user leaving the datagridview Thanks in advance Call AcceptChanges on the row after insertion, or AcceptChangesDuringUpdate = true On the data adapter ...Show All

• SQL Server XML Bulk Load schema question

  I was wondering if someone could point me in the right direction with a schema file for importing XML into a DB - the XML file has multiple sublevels, all of which need to be imported into a single table. I have it functioning "to an extent", meaning part of the file is imported - however, some of the sublevels have been driving me nuts, and I am not sure how to get it to work for all of the columns. ANY HELP WOULD BE GREATLY APPRECIATED - I've searched high and low for any documentation that would explain how to write up the schema to be able to import. Testing the schema I have created so far works - however, it does not import all of the ...Show All

• Visual C++ Error 4 fatal error C1001: An internal error has occurred in the compiler.

  Hi, I am trying to update an application from VS2003 to compile under VS 2005 Pro. Works fine under VS 2003. At the following line ======= template < class BASE> BOOL (WINAPI CDialogMinTrayBtn<BASE>::_TransparentBlt)(HDC, int , int , int , int , HDC, int , int , int , int , UINT)= NULL; ======= I get: Error 4 fatal error C1001: An internal error has occurred in the compiler. c:\projects\emuleplus\src\DialogMinTrayBtn.hpp 66  There seesm to be a lot of reports of a similar problem from the days of Vc6 or 2002 but it was fixed in VS 2003. I have tried most of the suggested fixed (optimization f ...Show All