john-wayne-interessierts's Q&A profile

• .NET Development Bulk Insertion in asp net

  I have to insert bulk data in asp.net .......what i do using for loop and insert all data.....but I want to use store procedure and xml for insert this data ....so can any one suggest me necessary step thanksssssssssss ...Show All

• SQL Server processing cube not pumping data

  I am trying to process a cube on a fact query that should return about 600M rows. When I run the processing, all Dimensions are processed successfully, and it starts processing the Facts, but no row count is shown indicating that it does not actually start streaming the data to Analysis Services. It has been running for 30 minutes and no count of processed rows has appeared. When I double-click the query and open the query in SQL Server Management studio it runs fine. Also I tried it with set rowcount 100000 and it starts streaming data to query output right away and gets to 100000 rows within a minute or so. So the query seems optimized and returns the data quickly. Also tempdb seems to be growing slowly. Does Analysis ...Show All

• SQL Server Any other way but Cursors or While loop

  Hi all, I have a bit of a challenging on my hands with this, i have a result set in a table which i am trying to iterate through the rows one by one i.e Values Values Dates 1.10 1.20 1.30 1.40 2006-03-31 00:00:00.000 2006-06-30 00:00:00.000 2006-09-30 00:00:00.000 2006-12-31 00:00:00.000 go to each row get the value and the date perform some calculation with the value and the date and insert it into another table(which sounds easy enough) my problem is how do i iterate through the result set one by one without using a cursor or a while loop do i have any other options at all Hi Thanks, For your reply below is ...Show All

• SQL Server Want to see which queries are executing in SQL Management studio

  Without going to the MDI option and getting SQL 2000 windows, is there anyway to get the tabs to show what queries are running   Obviously, you can open the Window menu to see this, but it would nice to be able to just look at the screen and know what's going on. Also, what happened to SQL 2000 Query Analyzer's CTRL + W shortcut for Windows   ALT+W , W is not too much of an extra step, but it is not as convenient.  It would be nice if the Windows would show a globe instead of a partially obscured Exe...  Has anyone else had trouble with this I would post this on the http://connect.microsoft.com/SQLServer/ , but the option to submit feedback isn't visible, even in Search.   --Andy ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. .X features supported in XNA?

  Hi, I'm currently working on a .x exporter for XSI with shader support. However I have some questions regarding exactly what features are supported in XNA. Setting the technique in the .x file does not seem to work: EffectParamDWord { "technique"; 3; } XNA always renders using the first technique in the shader, unless you manually set it with Effect.CurrentTechnique :( Also what part and version of DXSAS is supported It would be nice if semantics used in e.g. FxComposer just worked with XNA, e.g things like: float4x4 WorldIT : WorldInverseTranspose; float4x4 WorldViewProj : WorldViewProjection; float4x4 World : World ; float4x4 ViewI : ViewInverse ; Or do you have to manually parse all effect param ...Show All

• SQL Server SQL2005 SSIS - won't allow text delimiters

  W2k3 server, SQL 2005. @@version = Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) I'm trying to set up my first SSIS package to import a flat file to a database table. The connection manager will not allow a text qualifier. My data is comma delimited, with doublequotes around each field. If I enter " as the text qualifier, then I get the error "The preview sample contains embedded text qualifiers ("). The flat file parser does not support embedding text qualifiers in data. Parsing columns that contain data with text qualifiers will fail at run time." The data in Columns view shows as just one column rather than multiple columns. If I leave the text ...Show All

• Visual C++ Unable to build in 'Debug' mode

  Hello, I am trying to port a application from VC-6 to Visual Studio-2005. Though I am able to build in release mode, it is failing to build in debug mode. Following error is thrown. C:\Program Files\Microsoft Visual Studio 8\VC\include\strstream(139) : error C2061: syntax error : identifier '_DebugHeapTag_func' Can any one help me to fix this error Thanks Never mind. The cause of the problem has been found. The identifier "_DebugHeapTag_func" is used in the "xdebug" file line 27 to define "_NEW_CRT" as "new(std::_DebugHeapTag_func(), __FILE__, __LINE__)". The problem turned out to be that somewhere else in the project, the "new" function was redefined to a format not compatible with "std::_DebugHeapTag_f ...Show All

• Visual Basic Form & Picturebox sizes

  I am trying to set the sizes for the form and the picturebox to the size of the image displayed.  The picturebox is set to a random varible from a listbox of images.  The code I know that works is below but the problem I'm having is that it sets it to size of the image before the current image and on and on.... Form2.PictureBox1.Size = Form2.PictureBox1.Image.Size Form2.Size = Form2.Picturebox1.Image.Size Here is the code I have so far for the rest of it... Static number As Integer = 1   <-- If Code is inserted here the same problem occurs Try Form2.PictureBox1.ImageLocation = ListBox1.Items(number) <--Inserted here same problem. Catch ex As Exception Timer1.Stop() MessageBox ...Show All

• SQL Server Copying a Datbase between two different servers

  Hello Everyone, I am new to SQl Server 2005. I have created a database on one machine and I tried copying it on to another machine where SQL Server 2005 is installed. Both machines have SQL Server 2005 installed. When I tried copying using copy database wizard its asking for the destination server. I have given the name of the destination server but its giving me error msg saying tht it cant connect. How to chk whether my destination server is online If it is not how to make it online Any help would be appreciated. Srividya. Remote connections are disabled by default for SQL Server. YOu will have to enable them first. For more information see my screencast on my site which covers the ...Show All

• .NET Development encryption decryption in c#.net

  Hi, I have a requirement where in I need to migrate the already available COM component in to .net assembly with C# as the language. This COM component is written in VC++ 6.0 and is responsible for preparing a XML content in the specified format and then encrypt it using MD5 and blowfish symetric algorithm inside COM. How could I write this method using C#.net. Please note that we need the same encrypted format as we get from COM components.we are using public key, symetric key and crypto block. Regards, Parag Dave is there any sample code available, which will demonstrate as to how we can implement our own algorithm by extending the .net security namespace Also can I zip the .xml ...Show All

• Visual FoxPro Hiding deleted items on grid

  Hello What I want to do is to hide deleted items in a grid in real time. I have a grid bound to a PRODUCT table. The grid displays all the products I have. I have SET DELETED ON in the Form's Load event In the grid's INIT event I have SET FILTER TO NOT DELETED() and in the DELETE event I have Thisform.grid.Refresh, to refresh the grid every time I delete an item. In a button called "DELETE PRODUCT" I have the following code DELETE So, when I choose a item in the grid, I click the DELETE PRODUCT button and the grid behaves a little weird, 1- The last record in the grid gets deleted not the one I chose. 2- The grid gets refreshed only when I click in another Item inside the grid. I have tried other ap ...Show All

• Visual Studio 2008 (Pre-release) INotifyPropertyChanged in C++/CLI

  When I implement INotifyPropertyChanged in C++/CLI: (public ref class Task : public INotifyPropertyChanged) A problem comes to me: Error 3 error C3766: 'SomeData' must provide an implementation for the interface method 'void System::ComponentModel::INotifyPropertyChanged::PropertyChanged::add(System::ComponentModel::PropertyChangedEventHandler ^)' I don't know why this error doesn't occur in C# when I implement the INotifyPropertyChanged ,but occur in C++/CLI . Could you so kind to tell me how to resolve it Thank you very much! But this does not work: public ref class Class1 : INotifyPropertyChanged { public : virtual event PropertyChangedEventHandler^ PropertyChanged; ...Show All

• Software Development for Windows Vista Getting TrackingChannel Reference

  Hey all, I have a EXE that calls a WorkFlow. I want the workflow to get updates from the workflow and display the most current Tracking changes to the .exe's form. Every example I have seen for the TrackingService shows writing the Tracking changes that are sent to the Tracking Channel are written to the EventViewer, or to the Console. I may not be going in the right direction, so someone chime in, and let me know where I'm gong wrong. I inherit off the TrackingService abstract class. All of the methods that I need to impliment are protected. I then create a class that impliments the TrackingChannel class. This class overrides and receives the Send(TrackingRecord record) method that gets all of the Tracking events from the workflow ...Show All

• SQL Server VB.Net 2005 Setup creation gets error using Microsoft.SqlServer.Dts.Runtime

  I have a very small project written in VB.Net 2005 using the SQL Server 2005 SSiS DTSx package. I migrated a SLQ 2000 DTS package using the SQL 2005 Legacy tools and saved the package as a local .DTSx package on our file server. I need to run the package from a clients PC. I added the reference Microsoft.SqlServer.ManagedDTS so I could then use the Microsoft.SqlServer.Dts.Runtime so I can execute the commands: Dim oApp As New Application Dim oPkg As New Package oPkg = oApp.LoadPackage(g_DTSx_Directory & "AOC copy Generic1 CSV to AOC_verify_file_1.dtsx", Nothing) Dim oResults As DTSExecResult oResults = oPkg.Execute Ok. That works fine and is basically the entire app. It executes without a hitch in debug and ...Show All

• Software Development for Windows Vista Packaging: "[Content_Types].xml" part?

  I'm messing around with the packaging APIs (my eventual intent is to figure out how to add my own custom parts to an existing XPS file, since MS isn't telling). I started with the PackageRead sample, and made some adjustments to basically take a .XPS input and dump it to a flat-file structure. I'll know when I have it right when I can take any of the sample XPS files, dump to a folder tree, manually re-Zip that back to a .XPS and get a faithful reproduction. It's mostly working, except some sample XPS files have a [Content_Types].xml file in the package root. But for whatever reason, none of the Package collections (Parts & Relationships) seem to recognize the existence of this. So I have two questions: 1) Anybody know how to get at th ...Show All