zhishan's Q&A profile

• Visual Studio Version control plugin makes vs2005 crash on vista

  Hey All I am running Vista and have installed vs2005( with SP1 and the vista patch ) in hopes to do all of my developing on that platform now. But I am having problems with using a source control plugins. I use SVN, and have therefore installed AnkhSVN which is a great SVN plugin for vs2005. It works fine when I am working in vs2005. But every time I close vs2005, it crashes, and devenv.exe stalls, and cannot be stopped through task manager. I have tried to debug problem, and it looks like it tries to access some memory it does not have rights to. I don't understand this, as I am running vs2005 as administrator. It should be noted that this problem only occurs when the plugin is installed. If I uninstall it, vs2005 works fine and closes ...Show All

• SQL Server Losing config file between child packages and *$##@!- Passwords!

  I have a parent package that uses Execute Package Task against three child packages. They are all setup to use the same configuration file, and the packages are all located in the same folder. Purpose of the configuation is to use the same connection strings for each child package. I removed the path from the config. file specification to facilitate deployment. During debugging, the child packages cannot find the config file when they are run via the parent unless the full path is specified. If run standalone, a child package can find the config. file without the path. As I said, all dtsx filaes and the config file is in the same folder. Also, the password-removal issue is killing me in development. Everytime I touch the config. f ...Show All

• SQL Server vb code in ssis

  HI, I have a function written in vb and want to know if there is a way to use it in an ssis package Is there a task that I can paste this function in and execute it Like the vbscript task or T-sql task The function opens up 2 tables and updates table1 recordset with data from table2 if the (if statement) is correct and It uses 2 do loops. Any ideas Thanks Roughly: database : SqlConnection recordset: Dataset/DataTable/DataRow I think you must read up on this on your own since this is well documented all over the web, just google vb.net and you should find something. ...Show All

• SQL Server Getting the place number for a specifik ID, from a select list

  Heres the thing Im making a booking application where it is possible to be put on standby. When you book more than there is room fore, you will be put on standby. At the same time there should be a field in the databaserow that will be set to true if you start out with being put on standby. The order of the bookings is being set by the logdate, the one who books first gets the higher place. When you book, my idea was to first insert the data, then check to see if the place of the booking has exceeded the maximum number Im coding in vb2005 and can easily make it by coding with the sql: Sql= "Select nr from booking where date=@date and ClassID=" & theID And then make a loop with a reader ( I havent inserted any o ...Show All

• Visual C# Problem with textbox ?

  I am using an invoice system . I am having lot of textbox in my page . When my pointer is in textbox . Suppose if the user uses enter key in the keyboard my mistake . My page automatically redirects to some other page . Even if the user presses enter key by mistake in any of the textbox nothing should happen .How to do it . any one pls Sounds like you're using ASP.NET. If so, you need to ask at www.asp.net , web dev questions are off topic here. If not, then you've got a default button that's being pushed and navigating to another form in your app, you can get rid of the default button, or just catch the key press within the control and ignore it. LMK if this is not a web app, and I'll explain further if need be. ...Show All

• Windows Forms How to set the forecolor/backcolor in the row/col headers in a Data Grid View?

  This code in a form's constructor: Controls.Add( new DataGridView ()); DataGridView newDataGrid = ( DataGridView )Controls[0]; newDataGrid.Dock = DockStyle .Fill; DataTable Moose = new DataTable (); Moose.Columns.Add( "Col1" , typeof ( String )); Moose.Columns.Add( "Col2" , typeof ( Int32 )); Moose.Rows.Add( new object [] { "Value1" , 1}); Moose.Rows.Add( new object [] { "Value2" , 2}); Moose.Rows.Add( new object [] { "Value3" , 3}); newDataGrid.DataSource = Moose; newDataGrid.DefaultCellStyle.ForeColor = Color .Green; newDataGrid.DefaultCellStyle.SelectionForeColor = Color .Green; newDataGrid.DefaultCellStyle.BackColor = Color ...Show All

• Windows Forms how to prevent the user to open the application more than once

  Hi, I have a problem. once i run a vb.net application,while running if i click the exe the application is again opening so as it is opening as many times as i click.I want my application to be opened only once ,that means if the application already running then how to prevent it from opening again when the user clicks on the exe. I hope I conveyed my question. -regards GRK HI ahmedilyas, thank you verymuch the first one is working but in the second one i dnt find any application tab in the properties.and make single instance application. anyway thanks for the solution. -regards GRK ...Show All

• .NET Development Help finding out what user the web server is running under

  Is there any way to figure out what user the web server is currently running in It seems like it should be IUSR_*COMPUTER*, but I'm having permission problems and want to make sure that is really what the web server is running under. Thanks. ...Show All

• Visual Studio 2008 (Pre-release) The handle is invalid. (Exception from HRESULT: 0x80070006 (E_HANDLE))

  I am having "one of those issues", IIS is randomly failing with an "The handle is invalid. (Exception from HRESULT: 0x80070006 (E_HANDLE))" error. The error is literally random. All I can say is that if I do an iisreset it works for a while until it fails with the exact same error again. Here's some information I am getting from IIS Health Checks: Application information: Application domain: /LM/W3SVC/1/Root/EModServices-5-128008423022079854 Trust level: Full Application Virtual Path: /EModServices Application Path: C:\Program Files\Oxford Media\Accounting & Support System\Services\EModServices\ Machine name: OMASSSERVICES Process information: Process ID: 5540 Process name: w3wp.exe Account ...Show All

• Windows Forms drag user controls to winform(VS2005)

  Hi: When I used vs2003, it works nicely that once a new user control created, it will show on toolbox and I can drag it into any winform, but in VS2005, it doesn't show in toolbox, and I even cannot drag it into any winform from soluction explorer, the only thing I can do is to right click toolbox and add the dll file of the control to toolbox, it is really annoying and inconveient, so any one can figure out the best way to drag user control like VS2003 into a winform Cheers HanJ srinivasintouch wrote: Hi, Do like this, Right click on toolbox, ---> choose items --->Browse --->select the dll of ur usercontrol, now it will added to ur toolbox. Now u can Dr ...Show All

• Visual C++ Is it possible to consume a VB.Net .dll from C (unmanaged not c++)

  I have a VB.Net dll that contains functionality I need to access from a C program. As GetProcAddress won't get me where I need to go (right ) and I cannot create an instance of anything (C not C++) is there a route possible to loading this library I looked at a few places but couldn't find a ready example of this, so I just did a simple case using static linking to an export library based on a VB code example in the MSDN docs. Obviously, it could get a lot more complicated if the wrapper has to maintain state and do a lot of data marshaling. array_search.vb: Imports System Imports Microsoft.VisualBasic Public Class SamplesArray Public Shared Sub Main() ' Creates and initializes a n ...Show All

• SQL Server OPENROWSET Vs Linked Server

  Hi all, OPENROWSET Vs Linked Server Which method is better than other in terms of performance Thanks, Sourabh It really depends. Both allow pass-through query. So, performance wise, the same query would cost you the same. However, Openrowset/datasource is really meant for one time ad-hoc query. You should consider using linked server which provides much more functionalities. ...Show All

• Commerce Server PayPal payments in CS 2007

  Hi, I am new to commerce server. I have a question about acceting 3rd party payment. We are planning to use PayPal. Has anybody used Paypal to accept payment from CS. Also can anyone explain what are the advantages or disadvantages of using third party tool like Paypal. Thanks. Granada, Commerce Server can be implemented to use any number of third party payment methods. As to the pros and cons of PayPal versus other payment service providers you should contact the PayPal developer community . Cheers, Colin ...Show All

• Visual C# issue converting generics list to array and back

  I'm new to generics and they are being a real pain when it comes to my web services. I've got a winforms app that uses a proxy web class which invokes methods on a web service. The web method "RemoveRole" takes a parameter of List<Guid>. It throws up saying it could not convert object[] to List<Guid> so I'm trying to figure out how to put the plumbing in place to make the conversion happen. Currently the code below throws " Cannot implicitly convert type 'System.Collections.Generic.List<object>' to 'object[] ". 1. How do i get the following to work and.. 2. What plumbing do I need in the web service code to convert from object[] back to List<Guid> public void RemoveRole(List<Gu ...Show All

• SQL Server OnInformation event on SSIS execution

  Hi everyone,   I'd like to alter OnInformation event in order to add more parameters (as TaskHost). Is it possible I've tried but appears an error:   OnInformation' cannot to implement OnInformation' because of it doesn't exists on the Microsoft.SqlServer.Dts.Runtime.IDTSEvents'   Sub OnInformation( ByVal taskHost As TaskHost , ByVal [source] As DtsObject, ByVal informationCode As Integer , ByVal subComponent As String , ByVal description As String , ByVal helpFile As String , ByVal helpContext As Integer , ByVal idofInterfaceWithError As String , ByRef fireAgain As Boolean ) Implements IDTSEvents.OnInformation   I suppose that I must add an overload method but how     ...Show All