GoPro's Q&A profile

• SQL Server How to use t-sql to email and attachment

  I am new to sql and want to write a stored procedure to email a database group an attachment of a report that was created. Can someone please point me in the write direction thanks. I want to send an export via smtp using sql 2005. Is there a built-in stored procedure that will allow me to send an smtp message, and attach my export csv. ...Show All

• Visual Studio How follow writing code while debugging??

  Hi! I want follow writing code while VS2005 is debugging, but in cant find the right option in tools-options-debugging, which is Regards. ...Show All

• Visual C# can i create a new object using a variable?

  for example.. i want to create a new Panel everytime i click on the "next button" .. but each time i want its name to be different,, like for example onButton_Click(...) { Panel panel(here i want to add a variable or whatever to make it unique) = new Panel(); } I dont think you can. you could create an instance of it, and then change the name of the control using the Control.Name property I believe. Perhaps even store it into an Array and then find a panel using the Name property ...Show All

• SQL Server How to set Identity_Insert in dynamic sql?

  Hi there, I need to temporary set identity_insert off on a table in dynamic sql. Here is a sample from my stored procedure: Create t_Table Table4test ( ColID Int Not Null Identity(1,1) , ColContent varchar(30) Not Null ) Insert t_Table4test Values ( 'Test1' ) Insert t_Table4test Values ( 'Test2' ) Insert t_Table4test Values ( 'Test3' ) Declare @cCmd nvarchar(3000) , @cTableName nvarchar(15) -- So far all is fine... Select @cTableName = 't_Table4test' /* Now I need to insert a new record, BUT this time WITH ColID so I have to set Identity_Insert to On */ Select @cCmd = 'Set Identity_Insert GateKeeper.dbo.' + @cTableName + ' On' Execute( @cCmd ) -- Now the insert part Select @cCmd = 'Insert t_Table4test Values ( 4, ' + Char(39) ...Show All

• SQL Server no luck w/ execute sql task and assigning variable

  Hello, I've asked this question before and I've read the answers before and I still cannot get it to work. My task is simple, I want to use the execute sql task container to grab a value from a database and put it in a variable. I've done all the preliminary stuff such as running profiler to make sure that the package is getting the call to the database, setting up the ResultSet to be "single row" in the general tab, mapped the Result Set correctly, but nothing works. I get the same error every time. This is my sql command: select output_location as output_location from script_master Result Set is set up like this: Result Name: output_location ; Variable Name: User::output_location Here is the error I get: ...Show All

• .NET Development Close or Prevent Hidden Message Box

  I have a VB.NET 2005 application that uses the process object to start another application. I redirect the output, and also do not show the other application window. (It is hidden to the user). Everything has been fine except now I have instances where the application that i start might throw a message box. So now what happens is after I start this other application my application will hang because there is a message box (that is hidden) and is waiting to have someone click ok. Is there a way to prevent message boxes from being spawned from this other application, or is there a way to programmically close the message box when it appears, so that the application will continnue on. Any other suggestions are welcome. Thanks ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Gray Polygon (DrawPrimitives)

  Hi, I'm currently using DrawIndexedPrimitives with data of type VertexPositionColor, and I've clearly set the colours but I always get a gray shape instead of the blend that I ought to see. Any ideas here please Thanks in advance. i already asked bout vertex colours & basiceffect http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=777762&SiteID=1 "The version of BasicEffect we shipped in the beta doesn't support vertex color, but we're hoping to add that for the final release." use custom shaders and everything will be fine :) ...Show All

• Windows Forms Could not load file or assembly Interop.SHDocVw

  I get the below error when loading the windows form designer in Visual Studio 2005. It only happens on forms that include an undocked MS word preview section. It worked fine when I had the project in VS2003. Has anyone had this problem before Does anyone know how to fix it Cheers Paul. Could not load file or assembly 'Interop.SHDocVw, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) Hide at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stack ...Show All

• Windows Forms Put a glass panel over form while processing?

  Dear all What i would like to achieve is placing something like a glass panel over the form while is doing some processing and show a proress bar. Little something like that , which would informa the user that something is happening:) Any ideas or advice Is there any code examples Cheers (1) 0x20 is WS_EX_TRANSPARENT (from C's "WinUser.h" file) (2) It should be cp.ExStyle |= 0x20; (ie use the OR operator rather than adding it.) ...Show All

• SQL Server 2005 SP2 Install Failed, and Now SQL Server is Unusable. - (SQL9_Hotfix_KB921896_sqlrun_sql.msp.log)

  Hi, I have a problem with my SQL Server 2005 instance after trying to install SP2. My machine has a default instance of SQL server 2005, and 2 instances of SQL 2005 express. I installed Express SP2 and this installed without a hitch. Then I installed SP2 for SQL Server 2005. After the install, all the components had installed correctly except the Database Engine, which had a status of failed. I did not investigate why, I simply re-ran the install. It failed again, so I investigated further and I found out it failed because it had not been able to start the service VSS Writer. I looked at the service, and found I had changed the user which gives the service rights to start. I changed this back to Local System so the service c ...Show All

• Visual Studio Team System HOW TO GET VARIABLES'S TYPE

  Hi: I use fxcop for check variables's name,so met some trouble ask for help.I use fxcop create a rule for check variables's name. for example(C#):int intCount=9;string strName="Tiny";DataTable dtEmployee=new DataTable; in my rule I use string strFieldType=member.DeclaringType.GetField(member.Name).Type.ToString() strFieldType is like System.String,System.Int16,etc; get variables's type,fxcop add the rule can check; but when I change to the FxCopSdk.dll and Microsoft.Cci.DLL from the VS2005 .compile my rule to DLL,copy the rule.DLL to D:\Program Files\Microsoft Visual Studio 8\Team Tools\Static Analysis Tools\FxCop\Rules when I compile analysis my test'programe.the rule is not right check variables's name.I find th ...Show All

• Windows Forms Stopping long running SQL in OleDb

  I have a program that will execute various SQL statements and return their results to the user. On occasion the user will enter a SQL statement that will cause them to sit for a while waiting. In such cases I want to give them the option to cancel the request that they made. Is there a way to get a OleDbConnection object to cancel all its requests I have tried doing a simple [Close()] on the connection object but it will throw an error saying that the connection is in use. Figo Fei: I am create a windows form application. I do have the query running in a separate thread, however if I abort the thread it won't actually abort until the query has finished. I have looked into ways to kill the thread instant ...Show All

• .NET Development Change Connection String based on checkbox

  Hello everyone, I'm working on a VB application in VS 2005. The application was originally built in 2003 (1.1) but I'm starting afresh - I did not want to migrate / upgrade. The application is used for 3 sites, and each site has it's own backend SQL database (all on the same central server) and all databases are set up exactly the same - it's set this way to split the data, as certain lookups and tables are site specific. On the original application, I have 3 radioboxes - Site1, Site2, Site3 appear on a form that is first loaded. Only one of these checkboxes can be checked, and when one is, a global variable is set to true, and another two to false - i.e If me.rbSite1.checked = true then varSite1 = true varSite2 = f ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Live vision camera

  Will it be possible to use this new peripheral into an XNA application Not in v1.0. However its already been suggested in connect - you can vote for it there. https://connect.microsoft.com/feedback/ViewFeedback.aspx FeedbackID=213188&SiteID=226 (you need to be logged into connect before this link will work!) ...Show All

• Windows Forms System.Windows.Forms.Timer not firing

  I have a C# Windows application which displays a status window. I'm trying to use a timer to close the window a given number of minutes after a certain message is displayed in that window. I've set up a timer control as shown below, but it never fires. Does anyone have a clue as to why Note that the same thing happens when, trying to emulate examples I've seen, I change the declaration from: private System.Windows.Forms.Timer tmrCloseTimer; to: private System.Windows.Forms.Timer tmrCloseTimer = new System.Windows.Forms.Timer(); Thanks in advance for any help you can give. ***************************************** public class StatusBar : System.Windows.Forms.Form { ... private System.Windows.Forms.Time ...Show All