Enzima's Q&A profile

• Visual Studio 2008 (Pre-release) Problem in listview sorting

  Hi All i have a listview control in my application where i display the search results. to allow sorting i have the following procedure [VBCODE] Public Function Compare(ByVal x As Object, ByVal y As Object) _ As Integer Implements System.Collections.IComparer.Compare Dim lv1 As ListViewItem = x Dim lv2 As ListViewItem = y If mNumeric Then If m_bAltSort = True Then Return CLng(lv1.SubItems(mColumn).Text) + CDbl(lv2.SubItems(mColumn).Text) Else Return CDbl(lv1.SubItems(mColumn).Text) - CDbl(lv2.SubItems(mColumn).Text) End If ElseIf mDate Then Dim firstDate As ...Show All

• Windows Forms Prohibit resizing of child windows??? C#

  I have a parent window and two child window tiled horizontally. How can I prohibit to resize and move this child windows inside the parent window except for one thing: I need to allow to move the bottom line of the upper window up or down and allow to move the upper line of the bottom window up or down  Maybe somebody knows   ...Show All

• SQL Server Unable to complete login process due to delay in login response

  I receive this error message occasionally in my ETL - usually when trying to pull data from our source system: An OLE DB error has occurred. Error code: 0x80004005.  An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80004005  Description: "Login timeout expired".  An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80004005  Description: "Unable to complete login process due to delay in login response".  An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80004005  Description: "TCP Provider ...Show All

• Visual Studio 2008 (Pre-release) Uninstalling LINQ Preview from VS Beta 2

  I made the mistake of uninstalling the LINQ Preview from Add/Remove Programs before running that "Uninstall Visual Studio IDE Support" file, so VS still gives me warnings whenever I start it. I read another post suggesting to download the preview again and install it to get those files.. but MS has taken down the download for LINQ Preview that works with Beta 2. Now they only have one for the RTM release (whatever that is). I can install that one, but I can't run the files it installs because I have the wrong version of the framework. Where can I get uninstall files that'll let me remove LINQ IDE support from VS 2005 Beta 2 ...Show All

• .NET Development Saving User Preferences

  I am writing a piece of software in VB .NET 2002 and I need to save user settings. I want the settings to be accessible (read) by any account (Administrator -> Guest). I do not need all accounts to be able to modify the preferences. I have tried the Registry but only certain users can access the variables. I have used .txt/.dat/.xml files in the C:\Documents and Settings\All Users\Application Data\MYCOMPANY\MYSOFTWARE\ folder but the files cannot be read by all users. I can make it so that each users has their own preferences but I do not want to do that. Any advice would be great. Thanks I’d wager that ...Show All

• .NET Development can we use stored procedurem to return several results (accessing SQL server)

  Can I use sqlDatareader with a stored procedure to return more than one reultset that I ll be accessing through MyDatareader.MoveNext Any Little example on both the stored proc and the .Net side Thanks Stored Procedure: CREATE PROCEDURE DISPLAYDETAILS AS SELECT * FROM EMPLOYEES SELECT * FROM CUSTOMERS VB.net code Dim con As New SqlConnection Dim da As SqlDataAdapter Dim com As SqlCommand Dim dr As SqlDataReader Dim sConnectionString As String Try sConnectionString = "User Id = sa; Password =sa; Data Source = bng-fnfsn9190; Initial Catalog = Northwind;" con.Co ...Show All

• .NET Development Transaction

  Hi everyone, I have a function where i make 3 updates to 3 tables, I want to use a transaction but i don't know how to write a transaction for the three update statements. can anyone help me by a transaction example Thanks OleDbConnection dbConn = new OleDbConnection("{myconnectionstring}"); OleDbTransaction transaction = null ; try { // Open connection and begin transaction. dbConn.Open(); transaction = dbConn.BeginTransaction(); // Initialize needs and execute the 1st query. string query = "UPDATE Table1 SET Field1 = 'myvalue'"; OleDbCommand dbCommand = new OleDbCom ...Show All

• Visual Studio List All Available Snapshots of a Report in Report Viewer

  Dear Anyone, Is it possible to list all available snapshots of a particular report using report viewer We're looking for the same feature of report manager when a use clicks on the history tab of a report. Thanks, Joseph We are aware of a bug in this area that is exposed by setting the history id in a specific order relative to other properties. Are you setting the history ID before the report path Be sure to set the HistoryId property after ReportPath but before calling any other methods on ReportViewer.ServerReport. ...Show All

• Visual Studio 2008 (Pre-release) ListView

  Hi, I would like to know how to get different views with the ListView control. I know to get the a details view you set the ListView.View = GridView. How do I get the small/large icons view How many views are by default available Thank you, Jaco I don't know what default views are available. But you can use DataTemplates to make what ever kind you would want. Best regards, Thomas S. Andersen ...Show All

• Visual Studio Express Editions Help on C# for Rich Text Box

  Hi all, I been trying how to get the Rich Text Box to wrap after the user input. For example, when a user click on a check box that said order a mouse , I want the word mouse appear in the Rich Text Box. After the that, if the user click on the check box order a keyboard , I want it to have a carriage return onto the next line and the word keyboard should appear on the second line. But somehow, I got keyboard to overwrite my previous word Mouse . Any help would appreciated. Thank you all Jason hi, in your checkbox checked event handler you can do something like this RichTextbox.text += "mouse " or RichTextbo ...Show All

• Visual C# Checking for file extension

  Hey guys, I have a class that allows certain types of files to be uploaded. Currently, it checks the files ContentType, however for example I want to allow .csv files to be uploaded and it's ContentType is:  application/octet-stream   but so is .ini and .dbo files (which I don't want) they all the same ContentType. I would like to check for file extension as well. But FileUpload.PostedFile doesn't have that property. Any suggestions Thanks! I got it!! Here's what I used: string fileExtension = Path.GetExtension(_fileUpload.FileName); if (fileExtension == ".csv") {  blah } ...Show All

• SQL Server unexpected result from LOOKUP

  I have a look up transformation in Advanced TAB, I modified SQL like SQL 1 and the output from the look up sub-query. The query is right but the result I got from the look up transformation is not. SQL 1 select top 1 * from (select distinct STG.emplid,cast(STG.EFFDT as varchar) as Next_EffDT, MonthFirstDay as Next_MonthFirstDay , MonthLastDay as Next_MonthLastDay FROM dbo.STG_ERT_PS_JOB STG,vw_DIM_Time_Month WHERE STG.std_hours > 1 and len(STG.location) >3 and STG.EFFDT between MonthFirstDay and MonthLastDay) as refTable where [refTable].[emplid] = and [refTable].[Next_EffDT] > ...Show All

• Visual Studio Team System Scheduling Daily Builds

  Is there a way to schedule a daily build in TFS The only way that I've found so far is to run it manually, it would seem to be a very common scenario. Brad Raulston How about continuous integration instead http://weblogs.asp.net/dr.netjes/archive/2005/07/20/419957.aspx ...Show All

• Windows Forms Unauthorized access exception

  Hi, I have a remoting object deployed on IIS. Whenever an exception occurs in it, I am trying to write it in a log file. The log file exists on the machine. The Username under which it is being run is ASPNET and I have given enough rights for it to create, write and read a file. Whenever, I try to create a StreamWriter for the file, I am getting a UnauthorizedAccessException : "Access to the path 'C:\\Exceptions.log.2005-09-26.log' is denied." How can I write into this file in such cirmumstance Thanks, Kunal Found the solution, have to give write access to the particular folder for the ASPNET account ex ...Show All

• SQL Server Execution of Package failed

  I am trying to design package which would copy all tables and stored procedures from one server to another. It used to be simple task in SQL 2000, there was wizard. However the new wizard does not work... I wrote SSIS package, but when I execute I get the following error: "Can not apply value null to property Login..." Any idea It seems to me that this new SQl2005 is not that simple to use like 2000. 2000 was a great product. I am considering to rollback to 2000. Very frustrated with the new one...          There should be more to the error message than that. Please can you copy the ...Show All