Tryin2Bgood's Q&A profile

• Visual Basic txt files

  How can I access text files in VS2005 and display them in Arrays   Any help or websites containing a "How to" would be greatly appreciated.   Thanks! Also, more information on split() method of the string class It is in my bin folder. As I placed it there. I'm not sure I follow your last post. The file is located in C:\Projects\101\Projects\Project5\bin\Debug\people.txt Do I need to post the whole thing as opposed to just people.txt ...Show All

• SQL Server Degenerate dimension with non-numeric data in SSAS

  Dear, I have the following problem/question: I have a fact table that contains for example all orderline data, with next to that all skey's to my dimension tables (product, customer, date, ...). Next to the measures that are included in my fact table, I was planning to also include a degenerate dimension that contains my ordernumber. So far no problem creating the star schema in a relational database. But trying to set this up in SSAS, the problem comes up that my order number is not a real number but a string (eg 'ABC12345') and as far as I know, the fact table in SSAS cannot contain any string data (or am I wrong ). Any suggestions Thank you in advance for your feedback! Kind regards, Jurgen ...Show All

• Windows Forms SMTP.

  How do I find out what my SMTP is If you do not have a server running on your local machine you’d need to check with your network administrator, ISP or host provider to find out what you should use. To check your local machine the easiest way is to simply open up a command prompt and type in the following and hit enter: telnet localhost 25 If you can successfully connect then you’ve likely got one, if not then you don’t or it’s off (and turning it on would depend on what server it is). ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Triangle strips Vs. ordered index buffers

  Triangle strips are fast, but why exactly Is it because they never have a cache miss, or is it because the cards have some special optimization just for triangle strips (and fans) If I, instead of a triangle strip, have a vertex buffer and en ordered index buffer so that the indices mimics the order of a triangle strip, will this be just as fast as a strip .. or is there something else to it I have a mesh where a triangle strip can not easily be built, but I can however order the indices in such a way that each triangle reuses two vertices of the previous triangle. Each primitive only introduces a single new vertex (index). How would the performance be I could test this, but I would like to have a theoretical answer first and then make ...Show All

• SQL Server Dumb, but necessary, question on SSIS feature completeness

  We have never built a data warehouse. We are not even sure what the required features are to do this. Nontheless, our developers are exploring two ETL tools: SSIS and Sunopsis. They tend to like Sunopsis because it has been around a few years, has the equivalent of source-code modules (libraries) in the tool, has a highly granular security system, has 500 companies using it. and therefore must have survived several ETL projects. (We don't know if, or how many, real-world projects SSIS has been used for.). Sunopsis is Java based and uses its own authentication scheme (no support for Windows Active Directory yet. Bummer) To the best of your knowledge is SSIS, out of the box, missing any of the standard functionalites needed to populate ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Create Flash Light or Car Headlight effect...

  Hi All, Where can I get information on creating a flash light/headlight lighting effect. When the light moves I would like it to light up objects in a scene. Thanks. http://www.riemers.net/eng/Tutorials/XNA/Csharp/series3.php ...Show All

• SQL Server Help Needed in writing a function to help daily nightmare with Debugging.

  I debug SPS on a daily basis and I use SQL profiler to help me trace where the problem is. Once I have established which SP is the main problem I need to debug the line of code. What I do is Cut and Paste the SQL Profiler details and populate all the parameters,sometimes that can be 30 and more.. Now what i thought is to write an SP or Function where I pass : SP name and Parameters that profiler genererates and returns me Declare Statements and Set Statements with parameters filled. EG Profiler Returns Customer_INSERT,20,'JO',BLOGG','5 LONDON ROAD' I would call my new SP =PopulateSPParams and cut and paste the profiler's string PopulateSPParams 'Customer_Insert,20,'JO',BLOGG','5 LONDON ROAD' this will RETURN THE FOLLOW ...Show All

• SQL Server ALTER COLUMN on an XML column type can give error Msg 511 after a few attempts

  Basically I am trying to apply an XML Schema to an XML column after data has been added to the table. I need to do this to generate a computed column for use in an index to improve the access times. While I was playing with the schema getting the format/syntax correct I needed to apply and remove the schema several times and got errors. The following is how the errors can easily be generated rather than how I encountered them initially. Software=Windows 2003 Server, SQL Server 2005 The database table used, without the schema, was... CREATE TABLE [dbo].[EventXML]( [EventID] [INT] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [XMLData] [XML] NULL, [msrepl_tran_version] [UNIQUEIDENTIFIER] NOT NULL DEFAULT (newid()) ) The data com ...Show All

• Software Development for Windows Vista How to enqueue workflow statemachine instances for sqlpersistence

  we are working on windows workflow foundation with asp.net as our host process. we are facing problem in sql persistence of statemachine model approach. I will explain briefly the scenario here. we created custom services implementing the externaldataexchangeeventargs. we are using these events in the statemachine model using external event handlers. we created a statemachine workflow for inquiry process, in this "raiseoffer"  is one state, "CreateCustInquiry" is one state."Approval" as another state. one user raised offer at that instant i am creating the new workflow instance and raising the event "raiseoffer", after that the second user will do customer inquiry. in between first user may logout. at this time the ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. GameComponents controlling GameComponents

  Most XNA game examples I have seen so far load all the game components right away at the beginning of the game no matter what. I looking to setup a GameComponent (GameWorld) which the user will control to load which will subsequently load several other game entities which are inherited from the DrawableGameComponent as well, but they all controlled by the GameWorld as far as enabled/visible. This appears to work fine so far, I'm just curious though if there is anything wrong with this finite number of game entities all having there own SpriteBatch property because of this. Performance issue when GraphicsDevice is recreated Or even if this is a workable practice In other examples, I've seen certain drawable game entities custom created wh ...Show All

• Visual Studio Team System Data Generation pre and post scripts?

  Is there a way to have a pre and post script run for a data generation plan I have the situation where I'd like to disable specific triggers before the data generation plan, and then re-enable them after the data is generated and inserted. If this is possible, I can't find it. We are using this in conjunction with unit testing. We have the data generation plan set to run prior to our unit tests firing. Are you saying that there is a mechanism to allow us to run the data generation plan as part of a "pre-test" scenario Can you elaborate Here is our scenario: We have a DB Project that performs a Build and Deploy. We have a series of unit tests we wish to execute, but we need data in the tables to do this, s ...Show All

• SQL Server There is no direct equivalent to Oracle's rownum or row id in SQL Server

  hi, There is no direct equivalent to Oracle's rownum or row id in SQL Server there is any possiblity are alternate thing is exist then please reply regards santosh Sure, there is a function in SQL Server 2005 called row_number() Here's an example: WITH [EMPLOYEE ORDERED BY ROWID] AS (SELECT ROW_NUMBER() OVER (ORDER BY EMPID ASC) AS ROWID, * FROM EMPLOYEE) SELECT * FROM [EMPLOYEE ORDERED BY ROWID] WHERE ROWID =4 I'd advise looking up the documentation for it, as there are several use cases. ...Show All

• Windows Forms BindingSource.AddNew returning primary key from DB

  I am binding a DataGridView to a BindingSource as follows. myConnection = New SqlConnection(My.Settings.Default.ConnectionString) dset = New DataSet() Dim qry As String = "SELECT * FROM approvals" Try adapter.Fill(dset, "approvals") bsource.DataSource = dset.Tables("approvals") dgv.DataSource = bsource Catch ex As Exception MessageBox.Show(ex.Message) End Try The DGV behaves as normal, except when user adds a new row (either using the DGV or with bsource.AddNew() ) I need the primary key field to auto populate correctly as it does when the DGV is implemented using the "Drag 'n' Drop" method of databinding. When user adds a new row, the ...Show All

• Connected Services Framework OHSBE Message formats

  hi , I am evaluating OHSBE. In completing an order a few important messages are exchanged between the components. For ex. To initiate an order the OMS sends a SubmitOrderRequest message. Where can I get information about the structure of these messages The sample code per se is not useful as the various properties used are not accompanied by comments. thanks OHSBE installer places the OHSBE message schemas under Schemas folder under OHSBE installation directory. Yes, OHSBE supports custom messages also. For details of message exchange, please refer to OHSBE Developers guide ( http://msdn2.microsoft.com/en-us/library/aa439669.aspx ). ...Show All

• Visual C# Any place to view C# code?

  I want to know if anyone knows any place on net where I can download some C# code of some moderate to high complex projects ( it could be sharewares). Ok, not all of them are at the same level but there are some interesting articles to. Here is another good site: http://msdn.microsoft.com/msdnmag/find/default.aspx Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All