Scott Coffey's Q&A profile

• SQL Server EXPORT REPORT IN TXT FORMAT. POSSIBLE???

  HELLO FRIENDS, CAN I EXPORT REPORT IN TEXT FORMAT IF YES THEN HOW OR EXPORT AS CSV IS ONE TYPE OF EXPORT AS TXT OR NOT WHAT IS DIFFERENCE BETWEEN CSV AND TEXT FORMAT. THX IN ADVANCE. Plain text format is not supported, although you can create your own redering extension for that. The difference between CSV and TEXT is that CSV os comma separated whereas Text is normall in a huma readbale format, but this also can be just a flavour of mine, because I already also saw txt files with comma separated values. HTH, Jens K. Suessmeyer --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Express Editions Minimize to system tray

  Hi, Im looking for a solution to minimize my form in the system tray and restore it from the tray. I found alot of sites that use the 'DrawAnimatedRects' function that windows use to minimize and maximize window-forms. All this codes were in c++ or vb6. Is there anyway to use this function in vb2005 Here is an Example that i found at http://www.activevb.de/tipps/vb6tipps/tipp0182.html Option Explicit Private Declare Function SetRect Lib "User32" (lpRect _ As RECT, ByVal X1 As Long , ByVal Y1 As Long , ByVal _ X2 As Long , ByVal Y2 As Long ) As Long Private Declare Function DrawAnimatedRects Lib "User32" _ ( ByVal hWnd As Long , ByVal idAni As Long , lprcFrom _ As RECT ...Show All

• Visual Studio Team System Process template editor

  Hi If any one can let me know from where i can download process template editor Regards It's in the v1.2 version of the Team Foundation Power Tools. http://blogs.msdn.com/jmanning/archive/2007/02/21/version-1-2-of-team-foundation-power-tools-now-available.aspx So the download location is: http://www.microsoft.com/downloads/details.aspx familyid=7324c3db-658d-441b-8522-689c557d0a79&displaylang=en ...Show All

• SQL Server How to send the SQL Reports via email.

  Hi Everybody can somebody please help in finding how to mail the sql server reports via email. Thanks alot Nee123 Please refer to the following link for the problem: http://msdn2.microsoft.com/en-us/library/ms159155.aspx ...Show All

• Windows Forms Data-binded combobox and items set

  Hi all, I'm using a "data-binded" combobox. The user should be allowed only to select one of the items that I specified in the "Items" combobox property. How could I prevent the user from specifying a value into the combobox by his/herself Thanks in advance. I reviewed so many times the properties window but I did not see this property... Thank you very much Andrej! It works. - ...Show All

• .NET Development The problem "MSDatasetGenerator failed" with System.Guid DefaultValue

  Hi, I create Dataset with field of "System.Guid" type in VS2005. Then I put down the "DefaultValue" for the field equals to "00000000-0000-0000-0000-000000000000". When I click to build the project with this Dataset, so AFAIK VisualStudio makes my Dataset but fails and gives me the following error message: "Error 1 Custom tool error: Failed to generate code. Failed to generate code. Object of type 'System.Guid' cannot be converted to type 'System.String'. Object of type 'System.Guid' cannot be converted to type 'System.String'..." Notice if I put down the "DefaultValue" equaled to <DBNull> then everything goes fine and the project is bult OK. SO something wrong with my def ...Show All

• Visual Studio Express Editions FontStyle

  Here is what I am using Dim font_style As FontStyle = FontStyle.Regular and here is the errorr that I am getting Font 'Monotype Corsiva' does not support style 'Regular'. My question is how do I tell the program to load the font in it's default style You may have edited your last post to remove this question, but anyway, to set the richtextbox just: Private Sub Cbo_SelectionChangeCommitted( ByVal sender As Object , ByVal e As System.EventArgs) _ Handles Cbo.SelectionChangeCommitted RichTextBox1.SelectionFont = New Font( New FontFamily(Cbo.SelectedItem.ToString), Me .Font.Size, _ CType (ht.Item(Cbo.SelectedItem.ToString), FontStyle)) End Sub ...Show All

• SQL Server Booi.ini switch

  Hello, I read a lot of artical but still can't understand. I have SQL 2005 ent edition 32BIT on Windows 2003 Ent R2 32 bit. I have 4GB on my machine. What switch I need ton the boot.ini /3GB /Userva=2900 /PAE (is this only if I have more than 4GB ) Thanks PAE is only required for SQL Server to use more than 4 GB of physical memory - you don't need it Generally, for a standalone SQL Server, AWE is preferable to 3GB as it allows only SQL Server to take advantage of more than 2GB of RAM The account used for SQL services will have to be given Windows " lock pages in memory " administrative credentials. and then running this query to set AWE ...Show All

• Windows Forms INI files

  Hey, I searched MSDN for this but I could not find anything on it... How do you have the program recongnize a .ini file I have called it load.ini and this is what it is inside of it: [firstload] firsttime = 1 I am trying to make it so that in the Private Sub Form_Load it will look for the ini file and read it, is firsttime = 1 then it is going to open up a dialog, otherwise it will do nothing, I can do all of that, I just need to know how to have it find the ini file... I placed the ini file in the project's folder... Thanks :) The keywords and phrases. As for broadening my horizons...lol.  I know html, c++ and C#.  I am teaching myself asp .net as well....  not to mention i ...Show All

• Visual Studio Team System How to publish (clickonce) a solution

  Hi, I havent been able to find anything to help me to do this. I can do this manually thru the IDE, but not thru the Build Types. What do I have to place in the Build Type to get the program and its files published to our website I tried the following with no luck I just get an Entry Point error and I dont understand why. Please help. ======== < GenerateApplicationManifest AssemblyName = " AdminUtilGUI.exe " AssemblyVersion = " 1.28.1.0 " EntryPoint = " @(EntryPoint) " OutputManifest = " \\dalxpdss\DMDB_CODE\MARS Branch Project\DailyBuild2\Sources\daily build\MARS_Platform\Tools\MarsServerAdmin\SysAdminTools\obj\Release\AdminUtilGUI.exe.manifest " > < ...Show All

• Visual Studio Express Editions How can I show part of a picture(*.bmp) in a PictureBox?

  Hi, I have a BMP file that I scanned and now I want to show only part of this picture(file) in a picturebox. how can I do this Regards, yaniv pinhas Private Sub PictureBox1_Paint(ByVal sender As Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles PictureBox1.Paint Dim bmp As Image = Bitmap.FromFile("c:\temp\test.jpg") Dim rc As New Rectangle(100, 100, PictureBox1.Width, PictureBox1.Height) e.Graphics.DrawImage(bmp, 0, 0, rc, GraphicsUnit.Pixel) End Sub You probably want to keep "bmp" as a class variable so it doesn't get reloaded on every paint event. Adjust "rc" to show a specific portion of your scanned image... ...Show All

• .NET Development Code access security question

  I am helping a friend who has a .NET 2.0 Windows forms application that generates an error when installed on our Intranet. I'll paste the error at the end of this message. I can solve the problem by installing the .Net Framework 2.0 SDK on the client machine and running the .NET Framework 2.0 Configuration tool and getting into Configure Code Access Security Policy/Adjust Zone Security and setting the Intranet Zone to Full Trust. This is OK for us to do, but I'd like to find out if there's a simpler way to implement this setting using caspol or something like that without having to install the SDK on client machines, or maybe we can modify all machines on our network to have this setting by default. Thanks for any help, errors below.. john ...Show All

• Visual Studio Tools for Office Outlook attachment file name change

  Hi All, I am using outlook 2000. While i open attachment with a click in outlook 2000, the file name will change. Example i receive a mail with attachment and attachment name MKM-100189 but when i open the file (just double click the icon of attachment bottom of mail) , the file name change to MKM-1001891. Why this case will happen Thanks Kendy Hi Anthony, Oops, sorry for my mistaken. Anyway thanks for the link given. Thanks Kendy ...Show All

• Visual C# System.Threading.Threadstart question...

  Im not sure that this is the correct forum for this but it was the closest that I could find for this particular question. I apologize in advance if this is a newbie question. Im still getting my feet wet in the .Net environment. I wrote a windows service today ( a particularly easy task now with VS 2005 ) and I used a thread to do the work in the service. things work fine when the method that I use in the ThreadStart creation doesnt take any paramaters, but I couldnt figure a way to use a method that takes a paramater. I tried aThread = new Thread ( new ThreadStart (<class> .method(arg))); aThread = new Thread ( new ThreadStart (<class> .method)); But both of those lines would give me compiler errors. I c ...Show All

• SQL Server Non deterministic function?

  Gentlemen What is "Non_Deterministic" about the function below I pass DATETIME Column and a DECIMAL column ti the function. It keeps yelling at me saying it is a non-deterministic function. I am using this function to PERSIST a Computed Column. I have tried converting all NVARCHARs to VARCHARs. Tredi returning a VARCHAR instead of a DATETIME, but still did not succeed. Am I doing something wrong, I must be..... CREATE FUNCTION [dbo] . [udf_GetDateTime] ( @Date DATETIME , @TimeDecimal DECIMAL ) RETURNS DATETIME AS BEGIN DECLARE @DateStr NVARCHAR ( 23 ) DECLARE @TimeStr NVARCHAR ( 12 ) DECLARE @DateTimeResult DATETIME SET @TimeStr = RIGHT( '000000' + CONVE ...Show All