datasetshelp's Q&A profile

• Visual C# how do i prevent "show desktop" or "windows key+m" from minimizing my program?

  hi, i don't want my program to be on "TopMost" but i also don't want it to minimize. Never. even if i disable the minimize feature, the program can still be minimized by clicking on the "show desktop" icon or pressing Windows Key+M. I'd like to prevent that. Can someone tell me a possible way to do it btw, the "show desktop" button doesn't trigger the 'resize' or 'changesize' event in the form. Thanks, For the ...Show All

• Visual Basic how to find default email client

  how to find default email client and invoke corresponding app. i have outlook ,netscape,outlook express, incredimail are the email clients available in my os and need to find out the default one and send the mail through it from vb regards Process.Start is used to run a program. I believe if you pass it an email address, it will start your default mail app. ...Show All

• .NET Development DataAdapter.Fill() is necessary?

  Hi all, In ADO.NET 2.0, there's a new method called DataTable.Load (DataReader) method, so is it necessary to use DataAdapater.Fill(DataSet) anymore I think all developers don't mind to write a few more line to change .Fill() to .Load() if the performance can be improved greatly after moving from DataAdapter to DataReader (as DataReader is native and fastest approach in retrieving record). Thanks, Fill() ...Show All

• SQL Server Example of merge ,hash and nested join

  Could Any body Please give me one example of each of three types of joins that is Merge Join Hash Join Nested join    I am not quite sure if I understood you right. You can force the join algorithm by specifying a join hint. For example, the join: /*Nested loop join*/ select * from Orders O  inner loop join Customers C on  C.fCUSTOMER = O.fCUSTOMER will be inner loop join, regardless of whether the optimizer consi ...Show All

• SQL Server DTS in SQL 2005 Standard

  I'm using SQL 2005 Standard Edition with the Management Studio Console CTP but I can't seem access DTS functions. Is DTS available in this edition of SQL I just got through the same issue. I upgraded from 2000 to 2005 and could no longer find DTS. It is now SSIS in 2005. I can point you in the right direction but thats it. I am still figuring it out in the new edition. -M ...Show All

• SQL Server Logging Issue (BUG), Need Workaround!!

  We are running into a wierd problem where the "UseParentSetting" LoggingMode only works for the immediatelly called (child) package - the one right after the package that defines (enables) the log. So say you had three packages: Pkg1 enables logging and calls Pkg2, Pkg2 inherits the logging by setting LoggingMode=UseParentSetting and calls Pkg3, and finally Pkg3 inherits logging from Pkg2... In this scenerio Pkg3 would not ...Show All

• Visual Basic MultiLine ToolTips

  Somewhere in the Help I happened to notice that ToolTips can be customized to show multiline text. Now, when I need it, I can't find the appropriate help text. How can this be done Thanks for the answers! It was just too obvious for me to see. Now I have implemented a version that matches my needs; I just set the controls ToolTipText = "This is a" & Environment.NewLine & "multiline tooltip" ...Show All

• Visual Studio Express Editions a minor problem

  whenever i change the graphics of a cursor, as soon as it goes over a picture box the graphic changes back to the pointer. How do I make it so that the graphic i set stays the same I have minor problems too, hanging out at my house at late hours drinking all my liquor, sheesh. Dumb minors! hehe ...Show All

• Windows Forms AddArc to round top corners of form1 only left arc works

  New to GDI+, when I build the rectangle (form1) and add the first AddArc (leftside) : p.AddArc(0, 0, 10, 10, 180, 90) it works, The second AddArc (RightSide): p.AddArc(Me.Width - 10, 0, Me.Width, 10, -180, 90) produces an angle starting on the top left (close to where the first X was placed) and stretches across to the right and (down maybe 15 pixels at end) it looks like to where the right side X is located. I think it has so ...Show All

• Visual C++ Question about functions

  Alright, i thought i knew the function concept by now... but.... there is this constructor, in a class, class CMyLogicalEntity : public CLogicalEntity { public : CMyLogicalEntity ( void ) : m_nCounter( 0 ) {} now my question, what is that function doing, normally i make a function ( or in this case constructor ) like: CMyLogicalEnity( void) { codehere }; so what does the : mean, and where is the code.... thanks already! ...Show All

• SQL Server Excel Source: not to import blank rows

  I am trying to load data from an excel file, how do I use SSIS so that it won't import blank rows in the source excel file Thanks in advance! As with other databases, you'll need to use a WHERE clause to exclude rows that you don't want. There is no such option available on the driver, the connection manager, or the Excel source or destination. -Doug   ...Show All

• Software Development for Windows Vista Setting correlation reference in a replicator instance

  Hiya guys. I have a replicator that contains a sequence that in turn contains some correlated activities. I want to set the CorrelationReference in my activites from inside my ChildInitialized event. Current code looks something like this. private void NotifyPeersReplicator_Initialized( object sender, ReplicatorEventArgs e) { e.Children = LookupApplicantPeers.QueryResults; e.ExecutionType = ExecutionType .Parallel; } private void ...Show All

• Visual Basic generic error occured in GDI+ (drawline)

  I've just converted my program from VB 6 to VB 2005. There is a lot of graphics involved, drawing lots of lines to make models. The lines were all formerly drawn with the Line command on the forms, but now that that is gone i have run into problems switching to the new commands. My program is fairly large with many forms and modules so I was unsure about some of the things i did. I declared all the graphics in one module as follows: "Public ...Show All

• Visual Studio Very large file size for .rpt files

  My application has a couple of simple .rpt files that I have created with the Crystal Reports bundled with Visual Studio 2003.  These reports read from an Access database file and contain a single 12kb image in the header.  My concern is that the .rpt files are 3.5mb in size each and I cannot find an explaination.  Has anybody else encountered this problem before   Any suggestions on how to trim the fat from my report files ...Show All

• SQL Server DBCC Daily commands

  Can anyone tell me what are the daily DBCC commands they run and if they run it as a job and how you can capture the result of those commands for further analysis. I am switching from a development role to a DBA role and i can never find such a sugestion anywhere online or in books. So more than 1 openion would be greatly appreciated. Hi, you can read this article at http://www.sql-server-performance.com/d ...Show All