Sorin Sandu's Q&A profile

• Visual Studio Express Editions More on Random Numbers

  Here's a good one for you. I have 5 variables, let's call them 'a', 'b', 'c', 'd', and 'e' Each will be assigned a number RANDOMLY from 0 through 4. However, each will hold a unique value. Only one variable can be 0, only one can be 1, etc. and so-on. How do I do this Thanks Ted The larger your list, the slower your routine will be. Here is perhaps a better routine. It just creates an array of letters and then shuffles them. You don't have to worry about keeping track of whether there are unique values, because they are already unique! Public Sub CreateUniqueArray() 'Create an array of letters Dim aChars As String() = "A,B,C,D,E,F,G,H,I,J,K,L,M,N,O, ...Show All

• Visual Studio Tools for Office Activate an already open Excel workbook

  Hi I am using VB .net 2005 and Office 2007. When I execute the following line Dim workbook As Excel.Workbook = excel.Workbooks.Open( "c:\temp\test.xlsx" ) I get a message from Excel saying that the workbook is already open and if I want to open a read-only version of it. I would like to be able to open it if it is closed and activate it if it is already open. Is there way to check if it is already open, and if so, how would I go about activating it Thanks. HI there, I have a VB.NET 2005 windows appliaction that has a few links to open excel workbooks. I need to check if a workbook is already open on the users machine, if it is then throw a message that it is otherwise open ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 1 question...

  Hi. My question: Will finall release of xna include some physics engine Im very interested in it. Thx for any response. Thx for response, but notice that i just want to know that i dont waste my time to do my own phisycs engine (I know that it is fun to do it, but why do it, if its already done ). Now I'm waiting for finall release to write my games in 3d. ...Show All

• .NET Development VWD Express-Accessing the SqlDataSource: Can not open user default database. Login failed.

  Hi all, In my VWD 2005 Express program, I created a website "DobsonCh11" that had (1) Norwind.mdf file in my SQL Server Management Studio Express(SQL Server Express), (2)  Northwind.mdb and Northwind mdf files in the App_Data folder, and (3) the following default.aspx.vb:  Imports System.Data.OleDb Imports System.Data.SqlClient Partial Class _Default Inherits System.Web.UI.Page Protected Sub form1_Load( ByVal sender As Object , ByVal e As System.EventArgs) Handles form1.Load If Not Me .IsPostBack Then Me .Title = "Connect/query local databases" Me .Button1.Text = "Query Access" Me .Button2.Text = "Query SQL Server" Me .Button1.Width = 125 ...Show All

• Visual Studio Express Editions your sql server installation is eaither corupt or has been tampered with (could not open SQLEVN70.RLL)

  i have tried un installing it and re-installing it over and over and there is no change! please help me! Ummmm......what did the post advise Am I really going to have to pay $15.00 to find out I sent a request to Dell for tech support and they told me to just DISABLE the function. I'm not sure if I want to do that. Thanks, Rita ...Show All

• .NET Development Upload Data To HTTPS via Proxy problems

  ok.. I've seen quite a few questions about this issue but no responses, so let me try again. I'm trying to upload some data via the request headers to a page on a secured site, the page is accessed through the office proxy. Through IE and the appropraite proxy settings I can browse to the page just fine. When I use a webclient to call downloaddata on the page I get the webexception "The underlying connection was closed: Unable to connect to the remote server." which has an inner IOexception of "The operation is not allowed on non-connected sockets." from what I could trace out of the headers I can see that IE sets this when requesting the page Proxy-Connection: Keep-Alive But when I call it th ...Show All

• SQL Server Access read only variables in Script Component in a Dataflow

  I have a set of comma separated variables in a Script Component list. I want to access them in Script code and use them to build string in the code. Script Component ...Show All

• Visual Studio Express Editions Multiextend List Box and Text box Display

  Hey All, I am trying to get the following to work: Private Sub btnAnother_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAnother.Click lblSelectionText.Text = Me .lstbox1.SelectedItem.ToString() & vbCrLf & Me .lstbox2SelectedItem.ToString() _ & vbCrLf & Me .lstbox3.SelectedItem.ToString() & vbCrLf & Me .lstbox4.SelectedItem() Now everything displays upto the lstbox4. ListBox4 allows the user to select multiple items...But everytime i make it: Me.lstbox4.SelectedItems () I get the following error: Operator '&' is not defined for types 'String' and 'System.Windows.Forms.ListBox.SelectedObjectCollection'. As is obvious I am trying to ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Whats finaly in and out?

  Hellooo there... Anyone have an Idea which features are finaly in or out with the upcomming GSE What about fonts and ui, are there more api changes. I found an post to give a wishlist at connect for the next release but how could we do that without to know whats in this time... Oke... to say the truth: i'm just excited... I can't see anything being added that's not in the current beta, as it wouldn't be properly tested. There's a couple of font rendering classes that the community has released. I'd bet a GUI library would pop up soon (not that I'm working on one or anything ). I'm sure the XNA team is going to put out ver. 1.1 with all kinds of new stuff soon after the RTM. ...Show All

• Visual Basic Posing equations

  Hi I run into trouble when I wanted to test equations. Having an array of equations e.g. {"2X+3Y<=20","5Y+7X<10"....} I like to pick the equations out and test them like Dim X As Integer = 5 Dim Y As Integer = 7 Dim Eqation() As Integer = {"2X+3Y<=20","5Y+7X<10"....} if 2X+3Y<=20 and 5Y+7X<10 then .... Question: How can I pick out the equations and make VB understand that its a equation and not a text file and put it in the If function I would appriciate all help I can get, Thanks, Tomas You need an expression parser, .NET doesn't have one in the box. Consider starting with this project... ...Show All

• SQL Server Question On How to get the Table object to filling blank space on page???

  Greetings, I have reports which use a table object with various groupings and this table object has a footer row w/ a sub report that displays dynamic address information based on the groupings. I would like to have the address information located at the bottom of each page. Based my interpretation of following solution taken from the RDL Specification {see bellow excerpt} I have moved my table object within a rectangle object which is sized the page size but the table does not grow to the rectangle size…Can anyone tell me what I am missing here RDL Specification (2003) excerpt: Q: How can I indicate that my table should grow to fill the blank space below it (rather than preserving the blank space) A: Group the tabl ...Show All

• .NET Development RowUpdated event for Provider Independent DataAdapter

  I am attempting to move to the Provider Independent classes for Data access. Mostly it is going well but I have hit a wall trying to setup the RowUpdated event on a DataAdapter. Using the OleDb classes I would use: System.Data.OleDb. OleDbDataAdapter da; // set up dataset and read table etc...... da.RowUpdated += new System.Data.OleDb. OleDbRowUpdatedEventHandler (My_RowUpdated); Unfortunately the System.Common.DbDataAdapter class does not appear to have a public RowUpdated event handler and so I have to use some casting to make it work: ((System.Data.OleDb. OleDbDataAdapter )da).RowUpdated += new System.Data.OleDb. OleDbRowUpdatedEventHandler (My_RowUpdated); Am I missing something here Is there a way to achieve th ...Show All

• .NET Development Change Connection String based on checkbox

  Hello everyone, I'm working on a VB application in VS 2005. The application was originally built in 2003 (1.1) but I'm starting afresh - I did not want to migrate / upgrade. The application is used for 3 sites, and each site has it's own backend SQL database (all on the same central server) and all databases are set up exactly the same - it's set this way to split the data, as certain lookups and tables are site specific. On the original application, I have 3 radioboxes - Site1, Site2, Site3 appear on a form that is first loaded. Only one of these checkboxes can be checked, and when one is, a global variable is set to true, and another two to false - i.e If me.rbSite1.checked = true then varSite1 = true varSite2 = f ...Show All

• SQL Server Run Subreport according to condition.

  Hi all, in my report, I am using a subreport which takes two parameters and in my main report there is a filed named "ProcessCode". My problem is that, this subreport should be only run if ProcessCode is 11 oder 29. Otherweise there is no need to run subreport. the column of subreport will be shown as emtpy. I know, I can return empty string from my stored procedure if the processcode is not 11 or 29, but I would like to learm, is it possible to not render subreport according to condition Thanks in advance.     that means the query or stored procedure in the subreport will be run in any condition but if processcode is 11 or 29, subreport will be visible, otherwise invisible. it ...Show All

• Visual Basic Operation must use an updatable query

  I have an app that shares a mdb in a shared folder at the windows server 2003. After instalation i get this message... Operation must use an updatable query I have checked everything and even given total control to authenticated users but yet got the same error. I works fine on other servers with the same deployment. Any help please Jorge Laines There are several things to look into for an access database. 1) Have you given the users rights to the mdf file or the folder Access requires a second log file to be dynamically created and destroyed when you open it. If you don't have create and remove rights on the folder, it might not work properly. 2) Make sure your table data is coming from a single table with no ag ...Show All