Autofreak's Q&A profile

• Visual Studio Express Editions commandline compilation

  Hi! I have a visual studio C++ 2005 project. Is there any way to compile it in commandline without using the IDE http://msdn2.microsoft.com/en-us/library/ms235639(VS.80).aspx That should help you. ...Show All

• SQL Server Emailing long messages from SQL2000

  Hello! The problem is this. I have many short messages in a table. I need to tigh them together in one long email message and email to the users. But xp_sendmail is limited to 7,790. How could I send longer messages Or how could I devide the long message and send it in parts (i.e. separate consequtive emails) This doesn't work, it still cuts the messages off at around 7,790: E. Send messages longer than 7,990 characters This example shows how to send a message longer than 7,990 characters. Because message is limited to the length of a varchar (less row overhead, as are all stored procedure parameters), this example writes the long message into a global temporary table consisting of a single text column. The contents of this tem ...Show All

• Visual Studio Why is VS2005 (pro) taking 1,5 gb of my c: partition before installing

  hi when i want to install visual studio 2005 professional, the setup requires 1.5 gb of my c:/ partition. Why is this And is there a remedy against it Well to be honest (sorry for the late reply), I did change the filedirectory to a partition which way well goes over 1.5 gig. ...Show All

• SQL Server Grantor Question

  I use SQL Server 2005. I log in using windows authentication. When I grant alter any database to server securable the grantor is sa, while when I grant connect to certain endpoint the grantor is the windows account by which I log in. Why is the grantor different in every case Thank you. Bishoy When you grant a permission on a securable, the permission is granted as if the grant was made by the securable owner. If the securable is the server itself, then the grantor will appear as sa. Thanks Laurentiu ...Show All

• Internet Explorer Development Documentation for BHOs and Toolbars

  I have a BHO and custom toolbar that works with IE6. Where can I find developer documentation for converting these to work with IE7 Has the IE7 developer documentation been released Is there a BHO upgrade (IE6 to IE7) guide Thanks, Frank Sorry, I oversimplified a bit too much. Yes, in IE6 you can have frames with their own document. But if I have the 'main' window and document, I can find my way from there. In IE7, the main window has several 'TabWindowClass' childwindows, with a ShDocView window underneath. My BHO wants to know which tab window fired the OnDocumentComplete event. Still, the real question is, in IE7 behavior must have changed for things like IWebBrowser2 - where can I fi ...Show All

• SQL Server trouble with trigger

  having trouble with my trigger, I'm sure it's totally logical behaviour but need help making it do what I want. FOR INSERT AS /* IF UPDATE () ...*/ insert into Account1 (CustomerID,[transaction],[date],total) SELECT i.CustomerID, i.paymenttype, i.paymentdate, i.payment FROM inserted AS i LEFT OUTER JOIN Account1 AS a ON i.CustomerID = a.CustomerID WHERE (i.CustomerID = a.CustomerID) This trigger inserts info into "Account1" table, and is fired on insert into "payments" table. Unfortunately it's doing something I don't understand. For example, Say I have an invoice that equals 4.20. with invoiceid 1 and Customerid 1. If I add payment to invoiceid1 customerid1 in the amount ...Show All

• .NET Development Issue with culture settings in IIS

  Having converted a .NET vs 1.1 website to 2.0, and having deployed it to an XP machine, everything seemed to work fine. So, we deployed the new software to a Windows Server 2003 machine. We noticed that we kept getting dates displayed in US format where the local C# code was not culture specific. The website is fairly large (4,500 files) and is one I inherited so I was a bit put-out that I might have to code culture specific processing of every date in the system. So, I started to look for a global solution. After much testing and experimenting, I discovered that when I used the IIS configuration tool to set the culture and I specified "en-GB", the globalization setting was removed from web.config, otherwise the setting was placed in ...Show All

• Visual Studio Team System Opening WI Attachments Requires Username/Password

  When attempting to open a work item attachment, we get prompted for credentials each time. Is this expected or something not set correctly Is there some permissions setting that will prevent this All the users involved are in the project's contributors group in VSTF, in the contributors group of the sharepoint portal, and are browsers of the reporting services. Have you verified your User Authentication settings in Internet Explorer (Tools -> Internet Options -> Security -> Local Intranet -> Custom Level -> User Authentication). Automatic logon should be enabled. Have you tried adding your TFS url to your trusted sites list ...Show All

• Windows Forms Combo box did not pick up the selection

  Hi, all, I have a win form app in vs03. One of the combo box has a bug. If the user click and scroll down to select from the dropdown list, then click a save button, every thing is fine. But if they type the first couple letters to bring up the selection, then tab away to Save, the selection did not get saved. Here is how I populated it: Dim dsDropdowns As DataSet = SqlHelper.ExecuteDataset(cn_Pro, CommandType.StoredProcedure, "CT_getCLGDefault") dsDropdowns.Tables(0).TableName = "LogType" cboNoteType.DataSource = dsDropdowns.Tables(0) cboNoteType.DisplayMember = "TypeName" cboNoteType.ValueMember = "TypeId" And here is how I retrieve the selection Dim arParms() ...Show All

• Visual Basic converting date to a number in VB.net

  hi... wut is the easiest way to convert something in the format of date like 03/18/2007 into 031807 and use that 031807 to read the file 031807.mdb Dim Thedate As Date = #3/18/2007# Dim datestring As String = Thedate . ToString ( "MMddyy" ) Dim DataFileName As String = datestring & ".mdb" Dim cnxn As New OleDb . OleDbConnection ( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\" & DataFileName & ";User Id=admin;Password=;" ) ...Show All

• Visual Studio Express Editions Visual Web Developer 2005 Express Edition hangs while opening a site from a remote FTP

  I have Visual Studio 2005 and had this problem so I thought I'd download VWD 2005 EE to see if I could get it to work. Here's the deal when I go to open a site on my remote FTP server I enter my FTP login information and hit open... it can take up to 10 minutes for it to finish loading/opening and when it does intellisense is really buggy and doing a save all can sometimes lock up the application. This goes for both VS 2005 and VWD 2005 EE. If anyone has heard of this or has any ideas please let me know, thanks! -Chad Chad, Did you ever solve this issue I have VS2005 Pro and have the same problem. It worked fine yesterday. Today it hangs every time. I haven't done anything different. I can't find an answer anywhere on ...Show All

• Visual C# GetEnumerator question

  I have a class that has a list containing another class. I need to get at the data members inside of the class inside of the class. I didn't think this would be a problem a simple foreach should take care of this right Wrong! I have the following for each foreach ( FileList F in driverEntry) { FileName = F.Name; } and I get this error foreach statement cannot operate on variables of type '_Default.DriverEntry' because '_Default.DriverEntry' does not contain a public definition for 'GetEnumerator' I have never written a GetEnumerator function before and frankly I don't know where to start. Could some one help give me a head start or is there a easier way to get at this P.S. If you need to see me class definitio ...Show All

• Software Development for Windows Vista DirectShow with Managed C++

  Hi, I am trying to use DirectShow with Managed C++ and have compile errors. When including <dshow.h> I get the following error C:\Program Files\Microsoft DirectX SDK (February 2006)\Include\strsafe.h(221) : error C3641: 'StringCchCopyA' : invalid calling convention '__stdcall ' for function compiled with /clr:pure or /clr:safe Therefore I have some questions... a) Is it possible to use DirectShow with Managed C++ b) Is there a Managed C++ sample c) Is there a simpler way to just playback video from my app I am using the following... 1) Visual C++ Express Edition 2) Platform SDK " Windows Server 2003 SP1 SDK Release Notes" 3) Sample from "C:\Program Files\Micro ...Show All

• SQL Server putting data into table B from table A without using a cursor

  on SQL Server 2005, no SP. Currently using a cursor in a stored procedure to retrieve data from one table and to put it into another table. like so: declare @HTR money declare @Uniqueid varchar(15) declare cur_HTR cursor for select uniqueid, sum(hours_to_resolve) as thtr from com_trail_helpdesk_module group by uniqueid open cur_htr fetch next from cur_HTR into @Uniqueid, @HTR while @@fetch_status = 0 begin update com_hpd_helpdesk_history set total_hours_to_resolve = @HTR where case_id_ = @Uniqueid and dateasat = @dateasat fetch next from cur_HTR into @Uniqueid, @HTR end close cur_htr deallocate cur_htr ... This is taking about 45 minutes each time to do 21k records. Is there a faster, better way to do this ...Show All

• Visual Basic Run as administrator

  Can I write code to make an app run itself as administrator in vb2005. And is it possible to write code to reboot in vb. Thanks for any help To reboot the machine To restart windows: Shell("shutdown -r -t 00") You could use Process.Start instead of shell. Or maybe try using the approach in the following thread. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=86783&SiteID=1 ...Show All