Tan Phan's Q&A profile

• SQL Server Recompiling Views

  Say I changed code inside a view using e.g. 'alter view' statement and then the view gets executed. Is it executed with the new code or I have to recompile it first Thanks Kris I have several views that are based on other views. At runtime we allow users to add a new field to a form, and we use a stored proc to add a corresponding field to the table that the form's view is based on. Is there a way in SQL 2005 to discover which views are based on my base view and then to recompile them Thanks in advance. ...Show All

• Windows Forms why is this wrong

  try { SqlConnection ListTick = new SqlConnection(SQL_CONNECTION_STRING); string SQL_List = "SELECT * FROM Support"; // initialize dataadapter with query SqlDataAdapter myAdapter = new SqlDataAdapter (SQL_List, ListTick); // initalize and fill dataset with query results DataSet myData = new DataSet(); myAdapter.Fill (myData); DataTable table; table = myData.Tables["Support"]; foreach(DataRow myRow in table.Rows) { Tickets.Items.Add(myRow); } ...Show All

• Visual Basic Cursor in a textbox window

    I have a complex class full of controls including a Rich Text box and a regular textbook. The class is designed as a tab page to be added once or multiple time to a tab control. This class inherits Windows.Forms.Form.   When the page is added, I want the cursor to be in the ordinary text box.     It isn’t. There is a prescribed way to do this:   To programmatically click the right mouse button 1.          Create a MouseEventArgs whose Button property is set to the System.Windows.Forms.MouseButtons.Right value. 2.   &n ...Show All

• Visual Basic Trouble with Forms

  Hello, I'm about to start working my way through a two O'Reilly books; Learning Visual Basic .NET and Programming .NET Windows Applications. I was playing with the latter this afternoon using the new VB Express Beta 2. The following code I could not get to work and I think it is something to do with the difference between .NET 1 and 2. The book examples are in .NET 1. Imports System.Windows.Forms Namespace ProgrammingWinForms    Public Class HelloWorld        Inherits System.Windows.Forms.Form        Public Sub New ()         ...Show All

• Software Development for Windows Vista Customised State Designer?? - possible??

  Hi folks, What I am wanting to do is........ 1. when you drop my customstate activity onto the workflow, it 'automagically' creates a stateinitialization activity I've tried creating a custom designer (deriving from ActivityDesigner) and when I use this, my CustomState is not appearing on the design surface of the State Workflow (I've tried recreating brand new workflow + dropping the custom state shape in) Looking at the StateActivity, it has a 'StateDesigner' class associated with it....guess what....it's sealed. . So if anyone has any thoughts on how to do this - I'd love to hear them. I just want to do something across ...Show All

• Visual Studio Express Editions ActiveForm question

  Ok, I know that the ActiveForm object returns the, well, active form. But what about the active form's controls I can't access those because they don't appear as one of the ActiveForm's objects, and when I try to compile like that it says that the property doesn't exist. So how can I access the controls of the active form Please help! The ActiveForm property returns a Form reference because it can be any type of form.  You need to cast that reference to the appropriate type to be able to access the members of that type.  If the ActiveForm may be any of several types then you're going to need to test what type it ...Show All

• Visual Basic VB2005 and API "GetShortPathName Problem

  Hi All, I found yet another problem. I am wondering if VB2005 Express has some "built-in" way to get the short name of a file I have a procedure that I have been using for a long time in VB4, VB5, and VB6 and it has worked fine. However, when I try to upgrade the code in VB2005 Express "Update VB6 code", the procedure totally stops working! Here is how I have it setup: In My Module, I have this: Public Declare Function GetShortPathName Lib "kernel32" Alias "GetShortPathNameA" ( ByVal lpszLongPath As String , ByVal lpszShortPath As String , ByVal cchBuffer As Integer ...Show All

• SQL Server Changes not replicated to subscriber

  Hi, I hope you can help me with this. I am setting up a tranasctional publication with updateable subscriptions using: use [LIMS_PUBLISHER_TEST] exec sp_replicationdboption @dbname = N'LIMS_PUBLISHER_TEST', @optname = N'publish', @value = N'true' GO -- Adding the transactional publication use [LIMS_PUBLISHER_TEST] exec sp_addpublication @publication = N'LIMS_PUBLISHER_TEST', @description = N'Transactional publication with updatable subscriptions of database ''LIMS_PUBLISHER_TEST'' from Publisher ''RIVIERA''.', @sync_method = N'concurrent_c', @retention = 0, @allow_push = N'true', @allow_pull = N'true', @allow_anonymous = N'true', @enabled_f ...Show All

• Visual Studio Publishing a ClickOnce project with command-line MSBuild

  You can build the Publish target of a .csproj with the command-line MSBuild.exe, but when the Visual Studio IDE publishes a project it also copies it to a designated location and in Beta 2 appears to do something clever with preserving old .application manifests. Is there a way to have MSBuild.exe perform these extra steps from the command line Perhaps I'm building the wrong target Graeme, MSBuild won't actually perfom the publish (i.e. the physical transfer of files etc) when building from the command-line - as you've discovered. The simple reason is that the functionality to do that is in the IDE itself. ...Show All

• Visual Studio Team System Check for throw or rethrow in a try block

  Thank you David ...I have another question.... How can I check if there is any sentence in a block ... for example i want to check an empty catch and I do this: public override ProblemCollection Check( Member member) { Method method = member as Method ; bool isCatchExists = false ; bool isThrowExists = false ; if (method == null ) return null ; InstructionList iList = method.Instructions; for ( int i = 0; i < iList.Length; i++) { if (iList .OpCode == OpCode ._Catch) { isCatchExists = true ; } if (isCatchExists) { if ((iList .OpCode == OpCode .Throw) ...Show All

• .NET Development Inserting a New Record with FormView in ASP.NET 2.0

  In the insert mode of form view, the primary key is hidden from the user. In the underlying access database, the primary key is autonumber. Clicking the autogenerated insert button causes the error: "You tried to assign the Null value to a variable that is not a Variant data type." Do you have to programmatically set the unique ID key, and if so how would you do that in Visual Web Developer The form view is linked to an access datasource with appropriate autogenerated insert clause. INSERT INTO [xcrlog] ([rowID], [Date], [Distance], [Rowed By]) VALUES ( , , , ) Thanx, Jim Hey this worked great, thanks! ...Show All

• SQL Server Management Studio and Enterprise Manager on Same Machine?

  Greetings! Do any of you know whether or not it's possible to install Enterprise Manager onto a box with SQL Server 2005 installed I've come across a couple of problems when trying to admin some SQL 2000 servers, so I need EM somewhere. Also, it's incompatable with SQL Server 7.0, of course, and I've got two of them to admin as well. Thanks! Yes, it's OK, I've done it. But it's not recommended for a production machine. Uninstalling either may cause either to not function properly. ...Show All

• Visual Basic DataGrid Cell Value ???

  Dear Team   i want to capture the Pk value into a variable taken from textbox    to put it in a certain Cell in a datagrid its width = 0 cause it is a forign key Dear Man  this point is very important    I am realy thank you very much for your help....and i hope to be Patient with    me ......i tried to use the code but i discuverd that i need a certain cell like    me.datagrid1.currentcell(10)=a......   somthing like that but this is not working    or  tablestye1.datgridtextboxcoulmn10     a  is an integer ...Show All

• Visual Studio Team System Web Service test with datasource

  I found the documentation on writing a web service test using a data source. This appears helpful when you use thee data source for generating data to send to the data source. ( I will try that shortly)   Once I have that working I need to verify the data returned from the web service against the data source. Can this be done Thanks, Tomk Yes you can verify the data returned from the data source using the validation rules.  You can use on of the built in rules such as find text or you can write your own custom rule.  The Xml document is exposed in the validation rules, so you can use that to find what y ...Show All

• SQL Server Error 29503 - SQL Server 2005 DB Engine install Fails

  Hi, I've just tried to install SQL Server 2005 Standard and I'm getting an error that I can't find any information on.  In the log, I find Error 29503.  A message after it indicates that it couldn't start the server.  In the setup, I'm getting the error when it is trying to start SQL Server and it can't.  I've tried to go to the services window to manually start the engine, but immediately after it starts, it shutsdown again.  I read the help file in MSDN that is also included in the error details regarding manually starting the service.  It indicates to use the Configuration Manager, but at this point in ...Show All