Jahangir's Q&A profile

• Visual Basic VB / Excel dyanmically filling a list box in a cell

  Silly question I know, but it has been forever since I coded and I am desparate.  I have a spreadsheet in which I want to dynamically fill a (cell) list box based on a value selected in another (cell) list box.  I am calling it a cell list box because I am not actually using a vb control but instead have a cell list box (via the cell validation) method.  I can get the correct position of the cell and I can add a value to the correct cell based on an "If" statement but I can't seem to dynamically fill the same cell via a range of values versus just a singular value.  Help!  Hey there... Right.... ...Show All

• Windows Live Developer Forums And the winner is...

  Within a few weeks, the winner of the Worlds best app contest will be anounced, so I think it's an interesting question to ask: Who (or which app) will win   My guess:   In the Games section I think somebody from the netherlands will win... There are a few good games (actualy a lot of good games, but these are the best in my opinion): - Hangman (very basic and simple, doesn't require a fast pc, everybody knows how to play it - Tankwars (the one with the most launches, I like it, but it get's kind of boring after a few times... But it's still a good 2 player game! - Pool (nice graphics, very smart use of MSN Ear ...Show All

• SQL Server Analysis Services Project Template Failed installation... a "Project Template" issue

  I installed SQL 2005 AS (Analysis Services Proj.) and it's installation failed on the moment of adding VS2005 support therefore it failed to properly add the project template resources into VS.  I remove and reinstalled VS2005 and SQL2005 various times (including all related resources and directories) trying to get the issue resolved and still I am getting the same issue. I am using another approach now, how can I setup the SQL 2005 integration tools into VS2005 When I try to create a new AS project it tells me that it can't find the ".pwproj" file and shows me the path where it is located, still even that ...Show All

• Visual C# Timer_Tick Event

  Ok. I want to create a Timer at runtime, and how do add its event handlers and all of that Someone please help. Ok. I am getting in the habit of finding out answers to my own questions, which I consider to be great! . So I decided to go ahead and post the answer to this question, just in case someone else is wondering. I have created a label in a button_Click event, then also create the Timer_Tick event. private void button1_click (object , sender, EventArgs e ) {    Timer timer1 = new Timer();    timer1.Tick += new EventHandler(timer1_Tick)    (You can also add the properties of the timer ...Show All

• .NET Development ShareValues Between ApplicationDomains

  Is there any way in which I can share values between ApplicationDomains. I create the SecondApplication Domain using Dim appDm As AppDomain = AppDomain.CreateDomain("ABCD") Now I want to share values between the two Application Domains. Hi Stephen I am struggling to get a PlugIn architecture working and thought that you may be able to shed some light on whats going wrong. The test (VS) Solution I have is essentially three Projects: 1) ClientSide - which plays the role of the main "application" (currently driven by NUnit) 2) Shared - contains Plugin Interface definition and a (tes ...Show All

• .NET Development Thread corruption issues with 64 bit framework?

  Anybody else having troubles with multiple threads running in the .NET 2.0 framework in a 64 bit app   I have an application that queries a server, then reads the results back on a seperate thread. Each chunk received is doled out to yet another set of threads before using Control.Invoke to resync to the UI thread. This model works perfectly in the 1.1 framework, and in fact works fine in the 2.0 framework when run as a 32 bit app. But when run as a 64 bit app, it pulls access violations constantly. When run under the debugger, the debugger reports the access violations yet when it looks at the data, its fine! For instance, I'll get an ...Show All

• Visual Studio Express Editions Publishing multi-project solution

  First of all, I would rather prefer to use .msi package creation instead of publishing in Visual Basic 2005 Express using ClickOnce. But, as it seems to me that's unavailable, let's go on. Using ClickOnce deployment, I want to publish a 32 project solution, where one of the projects is a "menu" start project. This one, after installation, allows the user to invoke each of the other 31 projects, by using a single nice icon on his desktop. So, my menu is the solution's startup project. If I include in this project the dependencies to the other 31 projects, the result is that when I build the menu project, all the others get ...Show All

• Windows Forms Custom displaymember and valuemember in a bound Combobox?

  I have created a form with a combobox that is bound to the database table field "State". The State field use numeric values 0,1,2,3,4 according to the state. The problem is that i don't want to show the exact same values it retrieves from DB, i rather want to display a list of possible "States", with custom text corresponding to the value. Example: The value 0 actually means "Stopped". So i want it to add the option "Stopped" (displaymember) in the list, with value 0. Whenever i select "Stopped" in the list and save the form, i want the value "0" to be saved in the database. How do i do this I k ...Show All

• .NET Development No connection could be made because the target machine actively refused it

  Trying to connect to a local host TCP port 3380 (the port number chosen arbitrarily): 10.1.10.176:3380 I got this error message: No connection could be made because the target machine actively refused it What shall I do to convince the target machine not to refuse it the next time I used a sock.Connect(serverEndPoint); statement. Thanks This means that there is no TCP Port *LISTENING* for requests at the port 3380 you mentioned. It could also mean that there is a firewall of some sorts that is not allowing incoming connections on that port eventhough you might have a server listening on that port ...Show All

• Visual Studio Team System VS 2005 RC aligns with what version of TFS?

  There is no TFS beta 3 posted yet--which version of TFS does the VS RC work with Visual Studio 2005 RC is intented to work with the September CTP of SQL Server 2005 and Visual Studio Team Foundation Server Beta 3. TFS Beta 3 should be available at the end of this week or early next week. Thanks, Ajay ...Show All

• Windows Forms Windows Forms User Authentication.

  Hi, I'm new winforms. My application has a user login system and depending on the user level they get different access to differant options I'm going to give in the application. What is the best way of keeping track of the level of the user logged in. any Advice is appriciated. Many thanks, -VJ Are you using a database If so, create a UserRoles table, and create different roles based on the roles that you have (eg. "Administrator", "Power User", "Guests" etc., similar to the way Windows groups work). Then, for each group, you can define the permissions. When you want to ...Show All

• Visual C# Checking values of variable at runtime.

  I have created a C# project using Visual Studio 2003. I have declared a string variable 'strTest'. I want to check the values of strTest.Substring(0, 2) at runtime. I tried checking its value in quickwatch window but getting the following error: error: 'strTest.Substring' does not exist I get the same error for strTest.ToUpper() etc. but its working fine in vb.net. Can anyone plz suggest a solution. Thanks. Ashok Make sure the variable strTest is in the current scope. Where do you declare it and where is the current statement when you try to check the value You can also try the immidate w ...Show All

• .NET Development How can we read field name from an access table

  Anybody know how to read the table structure (i.e filed name. type , size etc) from an access table What is the sql command Ronald Look at the 'getschema' and the 'getoledbschematable' method of the oledbconnection object...you can retrieve the entire db schema using those methods...FYI the same methods will work with sql...the sql connection object does not have those methods. ...Show All

• Windows Forms Advice: User controls or not...

  Hi. Iam working on my and my colleagues final exsam (administrative panel, windows app for colleagues web portal administation). I have devided administrative sections with tab pages and for every that section (14 of them) I have bunch a controls on main form and codes for that sections to work as they should. My question is: Is it better to create 14 user controls for each section and just to load them on to the panel (for exsample) Then I'll be completely remove the tab pages and create a vertical navigation through this 14 sections (like you can see on Microsoft Money 2006 on the left side) and comunicate with events and delegates if any ...Show All

• Visual Studio Project developed with Crystal Reports for VS 2003 does not convert to VS 2005

  I used the Visual Studio Conversion Wizard to convert a VS 2003 project to VS 2005 I get the following 2 errors when I build the converted project: The type 'CrystalDecisions.Enterprise.InfoObject' is defined in an assembly that is not referenced. You must add a reference to assembly 'CrystalDecisions.Enterprise.InfoStore, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304'. The type 'CrystalDecisions.Enterprise.EnterpriseSession' is defined in an assembly that is not referenced. You must add a reference to assembly 'CrystalDecisions.Enterprise.Framework, Version=10.2.3600.0, Culture=neutral, P ...Show All