Judyt's Q&A profile

• Visual Basic Design question reading data

  Hi I sometimes include reports and charts in my apps. If I need fast cube like functionality I load lots of data into memory from the db. Then I use nested For Each... to read the data form the objects. Sometimes I have 4-5 levels (first object have a collections and each object in that collection have their own collections and etc....) I have never had any problems doing this, but clearly this is not best practise (first of all since the number of transactions is unknown). I have tried to find a vb.net sample code on this but no luck. Could someone point me in the right direction. Thank you. Hi James Thank you. I have some books on db apps in .net (eg. Wrox. vb.net beginning databases) they are all great at telling me how t ...Show All

• SQL Server Calculated Members

  I have a reporting services report that I'm creating from an Analysis Services cube.  I created two calculated memebers.  When I put either one of the calculated members in the report and try to render the query or generate the report, I get an error: Memory Error: Allocation Failure: Not enough storage is avaliable to process this command.   I have 21 GB of hard drive space.  I do only have 1 GB or RAM, put I thin that should be enought.  Any ideas as to why I get this problem when I run the report including a calculated member   BTW, the report works okay (not great in regards to timing) when I don't include the calculated memebers. Thanks, When i Run the MDX Expression direcly against the cube wit ...Show All

• SQL Server Sql query for Master Detail Record in One Row

  I am having a table contains Nurse Detail like nurseid 1 address fname last name phone another table contains the exp detail in 28 different type of speciality nurseid specialiity year Exp. 1 icu 4 1 ccu 5 1 OPD 2 i need to display the record in datagrid as nurse Name ExamPassed Address MostExp SecondMostExp 1 toefl abc, india ccu icu if i use the select query to find the top two inside a datareader which collect the info. about each nurse this takes lot of time to complete this and many times gives Timeout error about(50%) is there any code to combine with the urse detail records as a column for speciality one and two. any stored procedure / se ...Show All

• Visual Studio Team System Jumping to a location in the source thru VS 2003 doesn't work with 1.35

  Hello, I have FxCop 1.35 and VS 2003. When click on a <location> link, get a "can not start microsoft visual studio" message. The $(file) /command $Edit.Goto$(Line) workaround helps. Previously i had 1.32 and it was the same story, but I expected it to go in 1.35. It didn't work when both 1.32 and 1.35 were side by side, still doesn't work when I deinstalled 1.32 Thanks, Oleg This should work. Can you provide more information regarding your setup Do you have any other version of Visual Studio installed What versions of the .NET Framework do you have installed Regards David ...Show All

• Visual Studio Express Editions cl : Command line error D8003 : missing source filename

  I use VC++ 2005 Express and the output to the command 'cl /Bv' is Microsoft (R) 32-bit C/C++ Optimizing Compiler Version 14.00.50727.42 for 80x86 Copyright (C) Microsoft Corporation. All rights reserved. Compiler Passes: D:\Program Files\Microsoft Visual Studio 8\VC\BIN\cl.exe: Version 14.00.50727.42 D:\Program Files\Microsoft Visual Studio 8\VC\BIN\cl.dll: Version 14.00.50727.42 ... cl : Command line error D8003 : missing source filename. So what does the last line mean Leo ...Show All

• Visual Studio Express Editions communication between programs

  Hey, I have two C# apps. One makes some calculations and should send the results to the other app... how can this communication be done Files dont count... Thanks .NET remoting offers many ways for applications to communicate http://msdn2.microsoft.com/en-us/library/kwdt6w2k.aspx ...Show All

• Visual Studio 2008 (Pre-release) Blend modes not supported in WPF?

  Are blend modes not supported in WPF With the recent release of WPF/E and the new CTP's for the Expression tools, my interest in WPF has rekindled.  However, after searching the Web and Newsgroups it seems that blend modes are not supported in the WPF.  I'm not quite sure what the rationale behind leaving this feature out of WPF was. (Purhaps time constraints )   I'm sure the developers on the WPF team know how to program support for blend modes.   It's pretty much well documented on the Web.   I've even written a few for a custom layering application I wrote for .Net 1.1. a year or so ago.   It's odd that they took the time to program support for filters such as drop shadow, blur, and reflection, but not ...Show All

• Windows Forms Possible DataSources for a TextBox (Help Please)

  My question is this: What can be used as a DataSource for Formatting Text a Certain way The type of Text Formatting i'm working on in my project is a Casscading Style Sheet Generator,for a Site already In use(sorta like myspace.com)... Can you have a TextBox Read & Apply the text on a StyleSheet (CSharp) or would it have to be say a XML file Than the Form Controls will Edit the right sections of the CSS Example : table.user_aboutme { border:2px dashed #6694cf; <----------- Auto Insert of Color from CSS Supplied to the program text-align:left; padding: 2px; } td.user_aboutme_hdr { text-align:left; color:#2d7bbb; <------------------- In Every Spot threw out the CSS Supplied(DataSource) background-color:transparent; ...Show All

• Windows Forms resize the datagrids?

  I have two datagrids on a form. Sometimes the top one contains for rows, sometimes the bottom one. Is there a way that the user can grab the bottom of the top datagrid and move it up so that it becomes a smaller window, then grab the top of the bottom datagrid and slide it up so it becomes a larger window Thanks If you're using .NET 2.0, the SplitContainer would be the right tool for the job. Put it on the form, set its Dock property to Fill an Orientation property to Horizontal. Put the first grid in the upper panel and second grid in lower one. Set both grid's Dock panel to Fill. If you're using .NET 1.x, the Splitter control will help you achieve a similar solution. Just dock it between both grids. ...Show All

• Visual C++ question about dlls

  hey all i am using visual studio express and i was wondering if it was possible to creat dll files. i am putting a hook procedure in it. if it is please tell me thanx. There's no dll express. If you tell me exactly how it is not working, I can maybe help further. (For example, instead of saying "my bike's not working" you can say "my tire's flat"). ...Show All

• .NET Development Serialization problem after migration to .net 2.0

  Hi, i have problems de-serializing objects (saved by .net 1) with .net 2.0. The project was recompiled for .net 2 and it seems that it searches for old assemblies. I migrated to .net 2 and won't use .net 1 anymore. Is there an easy way to fix this problem I don't need do use .net 2 objects with .net 1.1. So I don't need a patch for 1.1. I haven't istalled 1.1 at all. Only .net 2.0 ist installed on the server. I have to read the objects saved by .net 1.1 back with 2.0 ...Show All

• Windows Forms .Net Control inside ATL AxWindow

  Hi, I created .net control which is exposed to COM. In another part of the application I created ATL AxWindow and loaded the control into it via the CreateControl method call. The call succeeded, however, the control is not shown in the window. Using Spy++ I can see child window with the "WindowsForms10.Window.8.app.0.378734a" class has been created inside the window. The constructor of my .net control is not called. Am I missing something Iam new to .Net/C# programming and I am little bit confused about the integration with COM. Could anybody help Thanks. ...Show All

• SQL Server How to modify the query string of a dataset?

  Hi, I have a few questions. Suppose that i have a report based on this sql: Select * from table1 Now I want to be able to add a Where clause on that sql command programmatically. Like: Where name = 'Max' How can I do that Listen Ham, May be I wasn't clear about my concern. I'm using reporting services and I have an app written in VB.NET that accesses some reports from the report server. In my app, it's possible to select a report name( on Report server), select the table where data come from for that report and set a condition on one or more columns. Now I want to be able to include that condition on the report before processing without permanently afffecting the .rdl file. ...Show All

• .NET Development Error "ExecuteScalar requires an open and available connection..."

  H all, I have an application that retrieves data from a local SQL2005 (Standard edition) database frequently (e.g. more than 10 times/second normally). It usually works fine. However, if the program was paused for a while (e.g. for a few hours) by a pop-up error message box or an Sleep() statement, it generates the following error message when its data processing resumes: " ExecuteScalar requires an open and available connection. The connection's current state is closed ." The application is coded with C# using ADO.Net. The connection is OleDbConnection. It seems there is some timeout process that I do not know. Could anyone offer any hint Thanks, hz Thank you all for the information! Firstly, let ...Show All

• Visual Basic How Do I implement an effective search method?

  Hi, I am trying to create a search method where i can enter search text for a number of fields, indluding wildcard characters, and then click a button. a subform shound then show all of the record that match the text entered. my current code is shown below. i am using microsoft access Dim thisDB As Database rst As Recordset Private Sub Command2_Click() Dim strsql As String Set thisDB = CurrentDb thisDB.Execute ("DELETE * FROM TempTable") strsql = "INSERT INTO TempTable SELECT * FROM Table0 WHERE CODE LIKE '" & codeEnterBox.Value & _ "' And DESCRIPTION LIKE '" & descriptionBox.Value & "'" thisDB.Execute (strsql) 'this is just a label that prov ...Show All