Chuck Berg's Q&A profile

• SQL Server Autocomplete combobox

  Dear all, I have a parametrized report which displays the available values for the parameter in a combobox (dropdownlist). I need to make that combobox autocomplete what the user types. Is there any way for that ! Thank you. There is no way out of the box to do this.  You would have to write your own code to accomplish this.  You could use the .Net 2.0 ReportViewer control to display the report and then handle the parameters yourself. Hope that helps. -Daniel ...Show All

• Windows Forms Why didn't DataView.Sort support Expression like Parent.Price ?

  Why didn't DataView.Sort support DataColumn.Expression like Parent.Price   :( Explain me pls.  Subject. (And you can add that column to your table using an expression, like    MyDataSet.Tables["childTableName"].Columns.Add("newColumnName", typeof(string), "Parent.parentColumnName"); ) ...Show All

• Visual Basic Config files with VB6

  Hi, I'm using a VB6 + SP5 enviroment, and I need to read a configuration file where exists too many sections (like setup.lst files). In first time I have tried with basic I/O file routines (Open, Read,....) but this method isn't useful because sometimes the information can be on the middle of file. The file like this [1st section] key=value key=value key=value [2nd section] key=value key=value Does anyone can suggest another way to do this without read all file until find the information. Tks Marcos Barbosa Hi Apologies for being negative but this forum is only for VB2005 qu ...Show All

• SQL Server Improving Cursor Performance

  Hello Can we use rowsets in sql server triggers and stored procedures for improving cursor performance. Any other solution in this context is welcome Chikuu Why are you using cursors There are very few problems that require use of cursors. And using them within triggers is even more of a performance hit. Try to use set-based operations inside triggers so it can execute quickly and reduce blocking issues which can otherwise happen due to long running trigger code. Maybe if you post a simple example of what you are trying to do with the cursor it will be easier to suggest a set-based alter ...Show All

• Windows Forms SqlClientPermission

  OK.....I have been searching and haven't found much helpful info on this topic.  I am hosting a winform (user control) on a website.  The form makes a call to a stored procedure...:     Public Function getxxxxx() as dataset         Dim sqlCmd As New SqlCommand         Dim da As New SqlDataAdapter       ...Show All

• SQL Server Management Studio doesn't run!

  Hi, I recently installed SQL Express Edition on a completely clean installation of Windows XP SP2 with all updates until yesterday. I use default instance name (SQLExpress) and tested the instance in many ways; all seems to be cool.   But, when I installed Management Studio CTP Nov, installation process finiched without any proble, bu when traying to tun the application either from Start Menu or installation program files folder, it doesn't work!  None dialogs, console windows and even no processes on task list. Can anybody helpme Erik Castaneda segersall@hotmail.com Hi, I am having the same prob ...Show All

• .NET Development All Windows Applications Under .Net

  I am imagining a system where all the software running on it has been built on the .Net framework. Is that likely Found my answer http://channel9.msdn.com/ShowPost.aspx PostID=68302 ...Show All

• SQL Server Object Explorer/Server Explorer Error

  I have just installed the released VS2005 as well as the released SQL2005.  When ever I try to browse my SQL Server with either the Object Explorer in MS SQL Server Management Studio or the Server Explorer in VS2005 I get the following error: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{6D5140C1-7436-11CE-8034-00AA006009FA}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). Does any one ...Show All

• Visual C++ Can't add variable

  I cannot add a new variable with the wizard into the class CChildView. The new variable appears in the classview for a moment, but in the source never. The MFC project was created with the wizard: Single document, without document/view architecture, everything else default. I can add new variables into the other classes, but not into CChildView... Is this a bug Thanks. Version: VS 2005 beta2, 8.0.50110.28 I just tried the exact same steps using the Beta2 bits and I get the source code as expected after adding the int variable anything: class CChildView : public CWnd { // Construction public : CChildV ...Show All

• SQL Server SQL 2005 Enterprise June CTP Installation Error

  Tried to install several times (on Win2003 Ent. SP1) but I always get the following error: Failure adding user NT AUTHORITY\NETWORK SERVICE to local group SQLServer2005MSSQLServerADHelperUser (1388) The user varies (sometimes NT AUTHORITY\SYSTEM) and so does the local group (sometimes SQLServer2005SQLBrowserUser). Any tips Regards Roger I have tried to install SQLDEV ,But got the same error mesage. ...Show All

• .NET Development updating records

  I am trying to update a record using one of samples provided and I always have the following error: "Reference to a non-shared member requires an object reference" The code I use is as follows: Dim totalsRow As mdstats1DataSet.TotalsRow totalsRow = mdstats1DataSet.Totals.FindByRecordID(1) totalsRow.smtpin = smtpin totalsRow.smtpout = smtpout The error is on the "mdstats1DataSet.Totals" Can anyone help me BTW, I am using VB Express and SQL Express Assuming that I'm reading your issue correctly, you need an instance of mdstats1DataSet . (In order to a ...Show All

• Windows Forms Can one use glyphs to manage user-interface with something other than a full-feldged control

  Hi -- I'm going to be drawing a bunch of shapes on a form surface with GDI+ and will be wanting to associate behavior with these objects. Is it at all possible to use glyphs, adorners and a BehaviorService to manage user interaction with these objects even if they don't implement full-fledged control behavior (I'm hoping to make my objects more lightweight than controls and will want to redraw tand reposition hem quickly without the overhead of individal component event handlers.) Any help on this question would be greatly appreciated. Regards, Mike Hi Again -- Just wanted to add on to my ...Show All

• SQL Server how to make report parameter value change dynamic when run time?

  Dear all, i have 2 parameter [startDate] [endDate]. startDate will basic on the day run report to get the start date from system(follow the store procedure) as below. CREATE PROCEDURE [dbo].[CFSRep_spGetLastWeekMonDate] AS BEGIN DECLARE @dtStart DATETIME -- SET @dtStart = GetDate() --Set Date to Todays Date --Set Start Date to 6 days before. If its a Sunday it will get this weeks Monday Date, else any day before will get the past weeks Monday Date SELECT @dtStart = dateadd(dd, -6, Getdate()) WHILE (datepart(dw, @dtStart) != 2) --While its not Day 2 (Monday) BEGIN SELECT @dtStart = dateadd(dd, -1, @dtStart) --Set t ...Show All

• Visual Studio Team System TF80071 connecting MPP to Team project

  I have an MPP in my Team project. I have checked out the MPP file and opened it. When I click the Choose Team Project button and select my project, I get an error "TF8001: Team Foundation encountered an error while accessing the work item database.  Please contact the Team Foundation Server administrator." Any clues TIA, Doug Hi there! I'm getting this error and the workaround posted here is not working with me. I can't find MUI for portuguese office! In fact I've got MSProject 2003 with SP2 wich is supposed to have MUI allready installed! In Team Foundation Server application server computer ...Show All

• Windows Forms A question about smart client's deployment.

  I published a smart client in the web server which was inside domain, the IIS' security policy was integrated windows. After having published the application, it was able to run and auto-update by computers which were inside domain - computers which were outside the domian counldnot run the application and throwed the error as below: The following properties have been set: Property: [AdminUser] = true {boolean} Property: [ProcessorArchitecture] = Intel {string} Property: [VersionNT] = 5.1.2 {version} Launching Application. URLDownloadToCacheFile failed with HRESULT '-2147024891' Error: 下 “http://XXXX.XXXX.com/deploy/WindowsApplication1.app ...Show All