rick_james's Q&A profile

• SQL Server Finding all views with a specific name, in all databases

  Hi, We are migrating to SQL Server 2005 from 2000 and we have a view created in many of our databases. That view must be changed after the migration because it uses system tables and does not return the correct information in SQL Server 2005. To do that, I want to create an SSIS-package that loops through all the databases on a particular server. If that view exists in the database, I want to run a script that change the view. What I try to do: Set up a For Each Loop container with Foreach SMO Enumerator Set the connection to my server Set the Enumerate property to "SMOEnumObj[@Name='Databases']/SMOEnumType[@Name='Names']" On the Variable Mapping page, place Index 0 in Variable User::dbName In the For E ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. issue about DrawIndexedPrimitives

  hi. one of the DrawIndexedPrimitives method parameters is NumVertices that specify number of vertices during the call as all you know. but i faced a problem that this parameter reads vertices that are one after anothe in the vertexbuffer. let me explain my problem on a picture: for example i have such vb: 1 5 9 13 2 6 10 14 3 7 11 15 4 8 12 16 and i need to draw triangles that uses 1, 2, 5 and 6 vertices i.e. 4 vertcices at all. but as you may guess if i will pass 4 as numvertices function will only read 1, 2, 3, 4 verts. my question is: what is better 1. to pass whole (or for example bigger part of vb) to function 2. fill my vb in block-style, i.e.: 1 2 3 4 5 6 7 8... where 3 and 4 are equal to ...Show All

• Visual Basic datagridview row edit mode

  I've got a btnEdit that I'd like to use to enable edit mode for an entire row. I tried using BeginEdit but it only put the current cell in edit mode and not the rest of the row. I want the user to be able to select a row, click btnEdit , and then edit all the columns in the row without clicking on btnEdit again. But when the user presses the ENTER key on the keyboard (which will save the changes), all the rows should be uneditable until the user clicks btnEdit again. In summary, I want btnEdit to enable edit mode for an entire row, and the ENTER key to disable it for all the rows in the datagridview. Note: the edit mode property of the datagridview is set to editprogrammatically . Please help! ...Show All

• SQL Server Dynamic columns for Flat File destination?

  I have a database app, and we're implementing various data export features using SSIS. Basically, it's a couple of straight extracts of various recordsets/views, etc. to CSV (flat files) from our SQL Server 2005 database, so I'm creating an SSIS package for each of these datasets. So far, so good, but my problem comes here: My requirements call for users to select from a list of available columns the fields that they want to include in their exported file. Then, the package should run, but only output the columns specified by the user. Does anyone have any idea as to the best way to accomplish this To recap, at design time, I know which columns the users will have to choose from, but at run time, they will specify the columns t ...Show All

• Software Development for Windows Vista TransactionScope, State Machine, and Oracle DB

  Background: I have a web app (ABC), a state machine workflow (XYZ) and using Oracle DB (ORA). ABC is using ORA using iBatis.Net, which uses Microsoft's provider for Oracle (and not Oracle's ODP.Net). ABC also uses XYZ to store the states of its transaction. XYZ only contains states and events, there are no codes inside. Problem: In one page of ABC, there a process who do the following: - update table 1 - insert table 2 - send event to workflow XYZ to move from state X1 to state X2 - update table 3 All these steps are within TransactionScope. The problem is, if the transaction fails (let's say, update table 3 fails), the entire transaction is rolled back EXCEPT for the workflow. The state of the workflow is still X2, not rolled-back to X1. ...Show All

• SQL Server VS 2005 Report Designer

  Somethings seems to have happened to my toolbox items. Under Report Items they all say "Toolbox". How can I correct this Thanks, Trish I fixed it: (with the help of another forum post) I had to delete the hidden toolbox items in the following folder: C:\Documents and Settings\<profilename>\Local Settings\Application Data\Microsoft\VisualStudio\8.0 VS had to be closed when I did this.  Then reopen VS and it will reinitialize the toolbox items. ...Show All

• Software Development for Windows Vista Sate machine workflow

  Hi, I have a simple state machine workflow with three states. I would like to put a timeout on the final state.(ie final state approver didn't approves this within the specified time, the state should go back to previous state). Is there any way to implement this thanks -Abraham Abraham - since each state can have multiple eventdriven activities - the way to implement this is to add an additional eventdriven to your final state - and then have a delay activity as the first activity inside of that eventdriven. ...Show All

• Internet Explorer Development How to control a explorer bar in extension?

  I wrote a IE extension include a toolbar and a explorer bar, how to control the explorer bar from toolbar show or hide it, set URL, etc ... Have a look at: http://msdn.microsoft.com/library/default.asp url=/workshop/browser/ext/tutorials/button.asp Let me know if you get it working...I couldnt. ...Show All

• .NET Development event log class

  I have an evet log code in my forms which connects to my evetlog database and add the log. Currently I am copying the same code to each and every form. i need to keep in a common class and use it whenever and whereever i need but i never tried to that before.. can you please guide add a new class in your project (right click project in solution, add > new item) then code in this class. then to call this class from other forms, create an instance of it, or pass it around: Class1 myClass = new Class1(); myClass.DoSomeMethod(args); etc... http://www.aspfree.com/c/a/C-Sharp/C-Sharp-Classes-Explained/ http://www.learnvisualstudio.net/videos/2308_CSharp_Classes.htm ...Show All

• Visual Studio Express Editions Form scroll bar visible

  Hey, When I have my form on the screen I want that only the form vertical scroll bar to be visible when the form contents are larger than its visible area. I have tried settings as: Me .AutoScroll = False Me .VScroll = True Me .HScroll = False Me .VerticalScroll.Visible = True Me .HorizontalScroll.Visible = False …in several scenario, but they seem to have no effect. Both scroll bar shows up. How do I get around this one Best Regards Cathrine spotty, Thank you for your patience. I have it now. Cath ...Show All

• Windows Live Developer Forums System.Data.DataTable 2 GeoRSS

  Hello out there... I’m developing a VE Server Control for ASP.NET 1.1 and have a question related pretty much to ASP.NET and XML, but somehow should fit also in this forum here. I have lots of contacts (with LatLong information) stored in my database and would like to add them via a GeoRSS layer to my map. Nothing special! My question is: How to best transform a DataTable (the result of my db query) to a GeoRSS conformant XML file Right now I’m trying to use the DataSet.WriteXml() function. Is it possible to combine this with the DataSet.ReadXmlSchema() function Or is it really necessary to build the XML-tree element by element from each row of the DataTable ! Appreciate any help or suggestion!! Cheers hafi XSLT. Here are some examp ...Show All

• Microsoft ISV Community Center Forums Reactivate embedded chart and make it the ActiveChart in excel

  Hi all, I can't make this work for embedded charts in excel. It only works for charts that are on an own sheet. Can someone tell me what to do to make it work for embedded charts as well. Dim Ch As Chart Set Ch = ActiveChart ''' Code that reads in input data... Ch.Activate With ActiveChart ''' Fill chart with input data .ChartType = xlXYScatterSmoothNoMarkers .SetSourceData Source:=myDataRange, PlotBy:=xlColumns .HasTitle = False .Axes(xlCategory, xlPrimary).HasTitle = True .Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = _ "Displacement [mm]" .Axes(xlValue, xlPrimary).HasTitle = True .Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "Force " End W ...Show All

• Visual C++ Should generate C4407 warning in VC++ 2005??

  Consider the following code: #include <iostream> class CVA { public : }; class CVB : virtual public CVA { public : }; class CB0 { public :    CB0() {}    void TestFunc() {       std::cout << _T( "In CB0::TestFunc" ) << std::endl;    } }; class CB1 : public CB0 { public :    CB1() {}    void TestFunc() {       std::cout << _T( "In CB1::TestFunc" ) << std::endl;    } }; class CD : public CB1, public CVB { public :    CD() {}    void TestFunc() {       std::cout << _T( ...Show All

• Visual Basic .net framework not referenced (even though it is)?

  I am having an unusual error. I have added reference to .net framework and imported system system.object system.windows.forms etc... But my problem is that suddenly my project cannot be compiled anymore. It says errors like: Class frmNewTaskWizard Inherits System.Windows.Forms.Form sais: Type 'System.Windows.Forms.Form' is not defined. Other errors: Type 'System.Windows.Forms.Label' is not defined. Type 'System.Drawing.Point' is not defined. etc... Even system.object is not defined My error list is full - what is the issue here Any ideas I think I've found out what's wrong (<Banging my head into a door> )... I have made a new class and I called it - yes you guessed it - I called it: "System& ...Show All

• Visual C# report logging

  hey guys, i'm relatively new to c# and i've got a important project using c#.. why blame my school.. anyway, the project i'm working on, involves the saving of Logs.. for reference.. however, these logs only store 1 entry at any given time. should there be more than one user accessing the database at one time, it might cause the system to crash. it'll be so darn helpful if anyone can tell me what method i should do and stuff. or perhaps a certain phrase i can use to search up on relevant information. i'm in need of help badly.. thanks in advance. you can probably easily create the methods to insert data into the database.... create a method that splits the entries into fields by the comma seperator for exampl ...Show All