Sweeps78's Q&A profile

• SQL Server Restart package automatically

  Hi there, I would like to be able to automatically restart a package if it fails with a certain error. This is due to a job that fails every now and then due to a loss in connectivity to the database (when run again no issues). I know how to catch the message, but is there i way that i can in a script task or some other task restart the whole package when moving into the OnError event for the whole package. I know this isn't a great way to do it, but its just temporary until we can isolate the network issue that is causing the loss in connectivity. Thanks You would have to restart the packge host, not from within the package itself. A quick way of doing this would be to use a SQL Agent Job ...Show All

• Smart Device Development "No usable controls"

  I have created a C# project in VS 2005 of the type: A project for creating a .NET Compact Framework 2.0 forms application for Pocket PC 2003 and later. I get the skin and the window, but I can't add any controls. There are NO controls in the toolbox. If I try right click and choose Items..., I see a whole list of checked items, but still nothing in the toolbox itself. I have imported a file from VS 2003 that already contains some controls. I can click on them in the form and change their properties, I can compile, debug and they work as expected. I just can't add any new controls to my forms because nothing is appearing in the tool box. If I create a new Windows C# project, the tool box is fine. I get the form and all of the tools in the ...Show All

• Visual Basic Vb.net General tutorials

  Where can i find some general tutorials(Video Prefered, But its OK) on Visual Basic 2005. I am just looking for tutorials on just general vb.net or tutorials just to increase my skill in vb.net. A simple search on the keyword Learning in both this forum and the VB Forums will reveal many interesting learning resources. http://forums.microsoft.com/MSDN/Search/Search.aspx words=learning&localechoice=9&SiteID=1&searchscope=forumscope&ForumID=159 http://forums.microsoft.com/MSDN/Search/Search.aspx words=learning&localechoice=9&SiteID=1&searchscope=forumgroupscope&ForumGroupID=10 This will detail, Web links/books/videos etc. all sorts of learning resources ...Show All

• Visual Studio 2008 (Pre-release) Custom TreeView Layout [Article]

  Hey all, I just posted an article to the CodeProject which shows how to turn the TreeView into something like an org chart. I'm pretty happy with the results, so if you are interested in checking it out: http://www.codeproject.com/useritems/CustomTreeViewLayout.asp ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Only 32 primitives drawing correctly.

  I've made a program that draws multiple triangles on the x-z plane. My eventual goal is a hight map but I'm having a problem with the DrawUserPrimitives call. It works fine if I set the number of primitives to draw up to a maximum of 32, but any greater number and I get some very strange random triangles all on top of one another. I looked through the API and found that there was a MaxPrimitiveCount method but that returns 1048575 so I don't think thats a problem. All the values in my array seem fine, if I copy the end triangles to the beginning of the array they display fine (until 33). If I put the loop that fills the array in my draw method and draw one primitive at a time (by just writing to position 0, 1 and 2 of the array) it works ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Integrating Joystick

  Hello, I am fairly new to the .NET platform and currently using VB.NET to read joystick input. I am using DirectX 8 and following a reference I found on MSDN. However, this piece of code is generating a run time. EventHandle = inp_device.CreateEvent( Me ) EventHandle of type long, inp_device is of type DxVBLibA.DirectX8. The exception generated reads as follows: Cannot cast windowsApplication1.joystick_controller to a DirectXEvent8 object. I would appreciate any direction in this matter. Thank you, Nath I'm really susprised you could find good DX8 documentation. You should be using ManagedDirectX 1.0 or XNA (which is the only other managed alternative). Right now though XNA is only supported with ...Show All

• SQL Server two measures with the same dimension but with differents values

  hello at every body.. well i have a problem. i want to create a report which will present two measures vued with the same dimsneion but with different values.for example i want to present sales bu country and i want to present at the report the sales for the US and the sales for UK at the same time indicator1=([Measures].[sales],[country].[UK]), indicator2=([Measures].[sales],[country].[US]). Further more i want to create two parameters which take the same values in order to change the values of indicators.. i have creted the datasets for the parameters and the parameters but i don't know how to code the main data set in order to change the values of indicator 1 with the values of parameter 1 and the values of indicator 2 with ...Show All

• SQL Server join statement

    when I am trying to optimize a proc, I saw one code which I don't know select  a.col1, b.col1 from  tbl1 a, tbl2 b where a.col2*=b.col2   what does this mean ( what will be the result set) how can I write it in different way Thanks   This is an old-style outer join which is actually deprecated in sql server 2005. Your code can be written this way select a.col1, b.col2 from tbl1 a left join tbl2 b ON a.col2 = b.col2 ...Show All

• .NET Development UIPermission on a 3rd Party DLL

  Im using a 3rd party DLL to create a graph. When calling some methods within this DLL i get exceptions because the control is running in a internet trusted zone. I do not have access to the 3rd party DLLs code so i cant add 'new UIPermission().Assert();' statements within the DLLs. Is there a tool/way of signing a DLL so it will be trusted i already sign the DLLs with my certifcate. Regards, Gareth. Try using the caspol.exe utility to explicitly assign trust, check this thread ... ...Show All

• Windows Forms Getting a value from a control at another form

  Hi My problem: lets suppose that we have a form called Form1 and has a textbox control called textBox1 and another form called Form2 that has a label control called Label1 and I want to set the content of Label1 with the same content of the textBox1 in Form1 what is the suitable code for such a purpose. Thanks Hi Ranadheer, in the previous code example there is a property called UserEnteredValue which returned the string entered by the user in the textbox. In your case you will create a property which will return the listbox's SelectedObjectCollection i.e. public SelectedObjectCollection UserSelectedItems { get { return this.myListBox.SelectedItems; } } ...Show All

• SQL Server Backup Maintenance PLan on sql2005

  Good day community, I have a list of plans of maintenance in a server and want to put these plans exactly in another server, someone can indicate me as extract a copy of the plans of mantenimeinto and I load them in another server Thank you. Very good, Thank you for the help, the problem is that it could not open the node of msdb, checking the documentation it was because in the file: MsDtsSrvr.ini.xml, was: <ServerName>.</ServerName> and the correct is: <ServerName> INVENT\SQL_DEVELOPER </ServerName>, bears in mind that the server is local. ...Show All

• Visual Studio GDI+ Image control

  Hi, Can I draw a bitmap with GDI+ and the use as a field of my object to put it into the report. Something like this... private Bitmap bmp; bmp = new Bitmap(100, 100); Graphics g = Graphics.FromImage(bmp); g.FillRectangle(Brushes.Red, new Rectangle(0, 0, 10, 10)); g.FillRectangle(Brushes.Blue, new Rectangle(10, 0, 10, 10)); g.FillRectangle(Brushes.Green, new Rectangle(0, 10, 10, 10)); public Bitmap Imagen { get{return bmp;} } and then use Imagen property in the rdlc file in a Image control with Fields!Imagen.value and setting the MIMEType to bmp I tried but it doesn’t work. Any idea thanks Hi piccolo, Would you mind to share your experienc ...Show All

• .NET Development sproc to determine if query will produce Invalid SqlNotificationEventArgs event

  I'm using an SqlDependency so I'll get an alert when the data under a query changes. When the query does not meet the criteria spelled out here http://msdn2.microsoft.com/en-us/library/aewzkxxh.aspx then I immediately get a SqlNotificationEventArgs event with the "Invalid" note. This is good. I would like to know that a query is invalid before I try it with my ASP.NET application. Is there a sproc I can give to my SQL developers so they can test that they haven't used any stuff that would invalidate SqlDependency What I'm hoping is that there's already a system sproc which could be called... exec sp_QueryInvalidForNotification "exec myTestSproc 99" Does such a sproc exist Or does anyone know how to write one ...Show All

• Visual C# DateTime.ToShortDateToSting()

  protected DateTime _CreatedOn = Convert .ToDateTime( DateTime .Now.ToShortDateString()); I thought this method return the date in this format 10/12/2005 but mine is giving me the time too....I just want the date and thats all...is there something wrong with how I am doing this to just get the date, try specifying the format in the ToString() overload: DateTime.Now.ToString("dd/MM/yyyy"); http://msdn2.microsoft.com/en-gb/library/zdtaw1bw.aspx http://msdn2.microsoft.com/en-gb/library/8kb3ddd4.aspx ...Show All

• Visual Studio Team System Time out issue when importing data

  We are currently using CPT5. We created scripts that are executed by the post deployment script to DROP_CONSTRAINTS, TRUNCATE_DATA, IMPOT_DATA, ADD_CONSTRAINTS, and ADD_extended_properties. We build the script to import the schema with CPT5 then deploy the buil and our scripts run from the post deployment script. I recieve a timeout error when I try to deploy but when I run the scripts seperatly in the T-SQL editor after the DB is built they work fine. We are trying to make it an automated easy proccess to pull databases locally and we were wondering if there know issues like this with the current version of CPT5 or if this won't be an issue with future releases Good to hear. Let me know if you are e ...Show All