kexh's Q&A profile

• SQL Server Simulate ROW_NUMBER () in SQL 2000

  I would like to generate an incrementing column value to each row found in a query in SQL Server 2000.  My understanding of SQL Server 2005 is that you can accomplish this approximately along these lines:    insert into MyList (myNo, lName)    select ROW_NUMBER() myNo, lName    from Employee    select * from MyList    order by myNo    myNo         lName    -----         ------    1           ...Show All

• Visual Studio Tools for Office strange vsto security issue

  I have a strange security issue using asp.net 2.0 and vsto. I have a web form that launches an excel file with .net code in it. This requires certain .net security settings to be set. The site is at http://localhost/app . So we set FullTrust for http://localhost/app/ *. This does not work however and throws the following exception: Request for permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0,Culture=neutral,publickeytoken=blahhh' failed. The security exception is throw when the app tries to access the following http request: GET /pki/crl/products/CodeSignPCA.crl HTTP/1.1 Accept: */* User- ...Show All

• .NET Development Massive Membership changes in RC? How to open a beta 2 website in beta3?

  So I have a project we've started in beta 2, I've just installed the release candidate on a lap top luckily (so we still have a working version) copied the project over, went to compile.  Fixed a few things that the new version doesn't like such as declaring using System.Windows; tried again.  Compiled and I though great.  Only no ..... All the login functionality appears to have changed   For instance the aspnet_Membership_GetPasswordWithFormat now takes four parameters instead of two.  Trying to open as New Project From Existing Code didnt' seem to apply to Websites, it wanted me to have a console or windows app ...Show All

• Windows Forms Problem with Databound DataGrid on a MDI Child form

  Hello all, I have this problem with a databound datagrid in a MDI child form. When bounding an empty datatable ( filled by a query which doesn't contain any results) to the datagrid, I actually see 2 rows in the MDI child form. 1 of these rows is an empty row and 1 is a new row.  (see code below) But the datagrid should only display 1 row (the new row), because the datatable doesn't contain any rows (results). Before bounding the datable to the datagrid, it still contains zero rows. while a run-time check (with a button) the datatable contains 1 row.This problem does only occur when the form is functioning as a MDI child form(where th ...Show All

• Windows Forms DataGridView , DataSource and myGridView.Rows return null (same for .Columns)

  Well, I was very happy to be able to set up a complex query to fill a DataSet and use that DataSet as a DataSource for a DataGridView. But the issue is that the DataGridView displays the data in a very raw mode and that I need to apply many different style depending on each cell. But the Columns property returns null and the Columns.Count return 0 Same for Rows and Count. I have had to create all the columns manually from code to be able to apply styles to columns, but now I need to apply styles to cells/rows and I can't see any way of getting that Rows collection... Is this my poor knowledge Is this a bug Is there a workaround Thanks f ...Show All

• Windows Forms Rich edit scrolling help

  Hiya Could to with some help. Can anyone tell me how I could get two rich edit boxes next to each other to scroll together. i.e. line n in the left hand box is always in line with line n in the right hand box. Both boxes are the same height. I am completely at a loss about this so any help would be most appreciated. Im using VS 2005 and C# btw. Thanks in advance, Chris p.s. sorry if this is in the wrong forum, thinking about it it should be in a windows forms forum if one exists. You can adjust scroll positions in HScroll/VScroll event handlers. If text is the same you can use Select(start, length) method t ...Show All

• Visual Studio 2008 (Pre-release) Composite xbap on Web?

  In HTML/aspx world, a web application can display content in another web site by just provide a link to that address and host it in a Frame. Could this be achieved in xbap This will change the deployment style of a control or an application. If a WPF control can only as a normal client control(just as today's ocx or WinForm control), it should be distributed with the application. If a xbap could be "composited" from different site, the control vendor only need to put the control on its website, and others could reference it in its own application and the control will be updated at anytime. I don't think you can. You ca ...Show All

• SQL Server Is there any chance to execute or call PL/SQL SP in SQl Server 2000 T-sql

  HI Group, Is there any chance to execute or call PL/SQL Sp in SQL Server 2000 T-Sql If any chance, please kindly sent steps . Regards ravi Shankar. You can call a PL/SQL SP indirectly using an Oracle package wrapper procedure that returns a PL/SQL table as output which can be called via OPENQUERY. I have posted lot of examples that demonstrate this technique 3-4 years back in the public newsgroups. Use link below:   http://groups.google.com/group/microsoft.public.sqlserver.programming/search group=microsoft.public.sqlserver.programming&q=oracle+stored+procedure+call+umachandar&qt_g=1   ...Show All

• .NET Development Threading problem

  Hi, I have a Windows Form and I need to create another thread to wait for an input somewhere else in the program. When this happens, I will have to access the form and modify it. Right now, this creates an error because I can't access/modify the form from a thread that didn't create it. I've searched through the reference and found that the ThreadPool class allows me to "wait on behalf of other threads" but I haven't found a solution with that yet. Does anyone know of a way to solve the problem Thanks in advance, Wing yes in your thread code: yourForm.theUpdateMessage = "My Message"; yourForm.Invoke( n ...Show All

• Windows Forms Help. Port an VB indexer property to C#

  Hi all,  I need to convert this VB  Default Public ReadOnly Property Item(ByVal index As Integer) As SomeObject   Get      Return CType(list.Item(index), SomeObject)   End Get End Property and i think in C# comes to this: public SomeObject this [int index] {     get { return (SomeObject)List[index]; } } Could someone confirm, or remend this, please. Thanks JCasa ...Show All

• Visual Studio 2008 (Pre-release) Problem with Cider and Sparkle on Vista Build 5342

  hi there. I just got Vista Build 5342 and tried to build up a designer toolset on the new OS with Visual Studio, Cider and Sparkle. After a hard time fixing installation of WinFX RunTime Components (Feb CTP), Visual Studio 2005 Team Suite, Windows SDK, Sparkle March CTP, I got all works done useless. XAML Designer in Visual Studio doesn't show anything without any error neither ExprID.Exe shows up even a single pixle and just allocates some amount of memory. I remember I got error messages on ExprID.Exe in first run and DW20 working to find a solution, but nothing! I've checked all the version issues from the site and I'm sure th ...Show All

• SQL Server Sql 2005 SP1 (x86) upgrade failed....

  Installed sql 2005 sp1 on standalone Win 2003 Server box in workgroup. (sql 2000 is default instance, sql 2005 is named instance and sql 2005 Express is floating around somewhere).). Box does not have any prior CTP SP1 versions. When I reach the "Authentication Mode" dialog during the SP1 install, and click Next, I get "Your account information could not be verified for one or more instances. Ensure that you can connect to all the selected instances using the account information provided.." I reset and restarted the sql 2005 database and reporting services using both a local account an t ...Show All

• SQL Server Convert int to ntext

  Hello, I can't convert int data into ntext, how can i do thanks a lot Explicit conversion from int to ntext is not allowed. But you can do something like below: select cast(cast(1 as nvarchar(100)) as ntext) ...Show All

• SQL Server SSIS tasks execution order problem

  Hi, I'm facing a problem with my SSIS package regarding the execution order of tasks. I am using my package for the purpose of loading data from XML to staging tables in the database, and have a loop to process all XML files. As a precondition to the loading action itself, I am running a stored procedure against the database (using the ExecuteSQL task) to check whether all staging tables are empty. The output parameter of that stored procedure is mapped to a variable I have defined in the SSIS package, so I can use it as a basis for the decision whether to run the loading action or not. In order to test my package I added a script t ...Show All

• Visual Studio Express Editions please help a french boy

  hello the forum!! I am a french boy. At the moment, I am traineer in a factory. I have downloaded the Visual Basic 2005 Express Edition. I begin my learning in programmation. I have a problem with my listbox. I have an excel document and I will take 50 lines in the excel sheets and copy in my listbox (my array in excel has two collumns).  I thanks all people who will answers my question. I haven't got Microsoft Access. thank you adrien   Hi, You can do this in ADO.Net by simply changing your connecitonstring. Provider=Microsoft.Jet.OLEDB.4.0;Data Source=ExcelData.xls;Extended Properties=Excel 8.0; Also use the OleDb ...Show All