ExtinctPencil's Q&A profile

• SQL Server How to Give Parameter Value at Runtime in SSIS Package

  Hi i am develope package using Oracle DataBase My Logic is INSERT NEw Reocrds And Updated Existing Records With Some Condiotion . In Source query Some select Columns with Where Condiotion .This Where Condition Field value should pass at that time of Runtime Parameter. How to Achieve Parameter value pass in OLEDB Source at run time. Please any one give me the Solution. I am struggling with INSERT , UPDATE Records With Paramet condiotion, Any one give Sample Insert and Update with Parameter using Oracle Database Thanks & regards, Jeyakumar .M Follow the advice given here: http://blogs.conchango.com/jamiethomson/archive/2005/12/09/2480.aspx -Jamie ...Show All

• Windows Forms How to change the selected value

  I need to change the selectedvalue, of the comboBox by passing in the new value in a fucntion but i keep getting object ref not set to instance of an object.....If I change the selected value in the combobox will it change the Display member based on what selected value i pass it...check out my code and see if you can tell me where i am going wrong... public static void DisplayStopDetails( int StopID, string TypeOfStop) { Tracking.UI.MainWindows.StopOrderLegDetailsForm frmStopDetails = new StopOrderLegDetailsForm(); frmStopDetails._StopDetail.StopID = StopID; frmStopDetails.cboStartingPoint.SelectedValue = frmStopDetails._StopDetail.StopID; //frmStopDetails._StopDetail.StopID = ( int )frmStopDetails.cboStarti ...Show All

• Windows Forms DataGridView AutoFilter whitepaper and sample

  Are you spoiled by the AutoFilter feature in Excel Do you want the same functionality in the DataGridView control Then my new whitepaper and sample are for you. See: http://msdn.microsoft.com/netframework/windowsforms/default.aspx pull=/library/en-us/dnwinforms/html/DtGrdVwAF.asp The DataGridViewAutoFilter library provides a custom DataGridViewColumnHeaderCell with a drop-down filter list that displays each unique value in a column, and updates the filter of the bound data source when a value is selected from the list. A custom DataGridViewColumn is also provided to make using the AutoFilter header cell easier, particularly in the Windows Forms Designer. Customizing DataGridView column header cells is not as easy as customizi ...Show All

• SQL Server Installtion failed

  Hi, I failed to install SQL Server 2005 to my Win2003 server which has AVG antivirus/firewall installed. It still not work even I disable the firewall. Please advice Here is the error log 2006-11-17 13:45:12.25 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1) 2006-11-17 13:45:12.25 Server (c) 2005 Microsoft Corporation. 2006-11-17 13:45:12.25 Server All rights reserved. 2006-11-17 13:45:12.25 Server Server process ID is 3300. 2006-11-17 13:45:12.25 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. 2006-11-17 13:45:12.26 Ser ...Show All

• Visual Studio Express Editions [2005] NotifyIcon's BalloonToolTip

  Hi, I'm using NotifyIcon in my application. It displays a balloon tooltip containing quote of the day according the current date at determined frequencies (i.e. every five minutes). I wanted to be able to display this ballontooltip when user moves the mouse cursor over the NotifyIcon on the tray. Therefore I’ve used the NotifyIcon1_MouseMove event and it works. But the balloontooltip needs user activity in order to disappear either by clicking on it or other mouse move/keyboard input. So here is my question: How can I force the BalloonTooltip disappear when user moves the cursor away from the NotifyIcon I thought the possibility to use a Timer in order to make it disappear but I have no idea on hiding BalloonTooltip manually: there is ...Show All

• Windows Forms Only the last value is sent???

  I was wondering if anyone could tell me why it only appends the last row of data in my listbox to my xmlserializer to write it to my xml file....the infomation comes in the listBox but only the last row of data is written to the xml file.....why is that and how would i go about fixing that...any help would be great! empinfo info = new empinfo(); string connect = System.Configuration.ConfigurationSettings.AppSettings["connstring"]; SqlConnection sql = new SqlConnection(connect); string cmd = "Select * From Employees"; SqlCommand scmd = new SqlCommand(cmd, sql); sql.Open(); SqlDataReader dr = scmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { //s ...Show All

• SQL Server Slow Query Analyzer

  Hi Folks when running query analyzer against two different server. the first server only need 1-2 secs to return the query result, while the other return 7-8 secs for the query result. plz advice what could cause this slow performance Thx in adv. ...Show All

• SQL Server question about different query results with wildcard

  Hi, I'm working with a third party app on SQL Server 2000, and from what I can gather, programmed in C# & VisualFoxPro. When we search with Note contains 94949 we get 571 results, when we search with Note contains 94949* we get 575 results. There should be at least a hundred different entries that start with "94949-1" so I expected the query with the wildcard to return something like 680 results, not an additional four rows. Searching with Note contains 94949-1* got 483 results Note contains 94949-10* got 0 results Could someone explain or point me to more documentation on the difference results we get Thanks To see the 'wildcards' used with T-SQL, look up topic: LIKE in Books O ...Show All

• Visual Studio Unable to Install Visual Studio 2005 Professional Edition 90-Day Trial

  I downloaded the trial version file(En_vs_2005_Pro_90_Trial.img) for Visual studio 2005 Professional Ed and burnt it to a DVD. Tried to install using ISOBuster trial version, but its asking to order the key.Is there any free software to open and install the file. My OS is windows 2000 ServicePack4 Microsoft .net Framework version 2.0 Redistributable package(x86) I also downloaded it on a laptop with OS-windows XP Professional SP-2 and .net Framework 1.1 Can any one let me know how to install the file. Thanks. you havent explained the problem you are having. In the mean time, read this http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=778624&SiteID=1 ...Show All

• Visual Studio Express Editions visual studio w32 application not working

  hi i've installed visual studio in my pc and then the sdk package but when i try to make a w32 application it says only console application help me please The express editions only provides console application for win32 dev. Nevertheless, you can still make suse of win32 non console application by setting your environment manually as described at http://msdn.microsoft.com/vstudio/express/visualc/usingpsdk/ Thanks, Ayman Shoukry VC++ Team ...Show All

• Windows Forms Databind DataGridView HELP.....

  Hello, I have a DataGridView in a form which gets populates data programmatically from an Access Database. What i want to do is the following: I want to make certain columns to be of combobox style such that when the user edits the information, it will be provided with more information, and other columns to be of textbox style. Is this possible and how can i achieve this Thank you. Well I am pretty new to VS 2005 but I'll try to help here. Select the grid in the design.cs. When the grid is selected there is a small arrow at the top right. Click that then click edit columns. Select the column you want to change on the left. Then On the right click Column Type there are a few choi ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Subscription not available on my Xbox!

  Hi! Is there any reason why the Creators Club Subscription is not showing up on my Xbox I live in Norway, but I've not read anything about any region restrictions on this download. I want in on the fun too! Thanks everyone, but I have read the guides out there. Problem is that there is _no_ "XNA Creators Club" item available. Here is a picture of my TV/Xbox as proof Is there any caching of content items locally that perhaps is not updated If so, is there any way to force the dashboard to refresh ...Show All

• Visual Studio Team System Outlook 2003

  Hello! Is ther VS TFS Plugin for Outlook 2003 I found it only for Word and Excel Regards Simon No there is not one built in, but there is Teamlook that does a nice job with workitems in Outlook. Depending on the level of complexity you ar looking at you could do a custom VSTO solution. ...Show All

• .NET Development How to write Client-Server Application in VB.NET/2005

  I am a VB6 prgmr learning VB.NET. In VB6 I implement server side apps as Active-Server project. I then reference the file in my VB6 project. I also use DCOM to remote the server side. How do I achieve similar structure in .NET Million thanks. Vie EGBE Thanks for the prompt assistance. However I believe the way I framed my question misled you. I already have been reading stuff about tcpClient and tcpListener. These work like Winsock in VB6. The TcpClient class provides simple methods for connecting, sending, and receiving stream data over a network in synchronous blocking mode. What I need is to development a server that implements the business layer of my project. It is to be remoted and has methods that can ...Show All

• Visual C++ Dependency checking is confused by $(CPU) in the internal directory name

  When I set internal build directory in VS.NET C++ as Debug$(CPU), instead of Debug, the $(IntDir) properly changes to Debug or DebugAMD64, depending on the value of environment variable CPU. However, this change causes VS.NET to rebuild each C file of the project as with Rebuild command. Is this a known bug If so it's a pitty one because this is the strategy I chose to use the same project file targeting Win32 and Win64. This happens with and without SP1 beta on Win32 and Win64. Any advise is greatly appreciated. Are there other methods to use the same project file without cloning Debug/Release configurations for both Win32 and Win64 build targets Thank you. A similiar issue was discussed here . ...Show All