GiriKrishna's Q&A profile

• SQL Server READ_COMMITTED_SNAPSHOT

  READ_COMMITTED_SNAPSHOT in 2005 is what I wanted. However, I am still using 2000. READ_COMMITTED in 2000 is different. Can anyone give me advice on this issue (or there is no way in Sql Server 2000 to handle the following scenario: Process One UPDATE tableA SET fieldB = 'testing' WHERE fieldA = 1; Process Two SELECT * FROM tableA WHERE fieldA = 1; While Process One is working, Process Two will fail. But I just want to allow Process Two to read the data (i.e. the version that before Process One is working). This is what READ_COMMITTED_SNAPSHOT do in Sql Server 2005. ) Thanks for any advice. Hi Wilson. There is no automatic method to allow this type of read i ...Show All

• Visual Studio Team System Baseless merge No Content changes not auto merging...

  We are trying to do a baseless merge and the conflict resolution comes up and when we select a file that has not conflicts it is not giving us any auto merge option. If we try to do the auto merge all, it fails because it says we cannot merge them because the two files have changes but we verified that they don't. Now if this was one file it would be no big deal but we are talking about thousands of files and there is no way we are going to resolve each file manually....if this is how baseless merging works, how useful is it  Also, when I execute "tf resolve /auto:acceptmerge" I get the following error TF10010: Source control unexpectedly encountered the end of the stream: The char acter was incomplete at stream offset 3841. ...Show All

• SQL Server Problem on comparing strings

  Hi All, I've problem on comparing strings with the following SQL statement: select * from events where venue = 'myhome' where venue is of type varchar(50) The above SQL should return something (i.e. I've 3 events hold at my home!) but it return 0 rows. Please kindly help. Thanks, stard may be your column valeus have carrage return (ascii 13+10 = \r\n) character.. When you see the result in GRID VIEW on Query Analyzer you wont find this character.. You can apply the following statement on select.. select * From  Events Where replace(Venue,char(13)+Char(10),'')= 'MyHome' or select * from events where venue LIKE  '%myhome%' -- It may return unexpected additio ...Show All

• Visual Basic No Code is Executing on any event!

  I was working happily away on a project and all of a sudden, I ran it the form load event didnt fire. So I went to close the app with the close button on the form and that wouldn't work either. After adding a load of break points, I found that absolutely no code is being executed. I have tried deleting all the code from events and recreating them by double clicking the controls. But still no code is firing. I have tried cleaning the project and rebuilding, and I have tried deleting the debug directory to force it to recreate the build. I'm not getting any build errors and there are no errors in my code. My deadline is approaching! I hope someone can help, thanks! All the code have the event handlers on the ...Show All

• SQL Server Help with finding last record!

  I have two columns - code (nvchar) and date (datetime) within an sql 2005 table. The code contains a list where the items are duplicated and I need to search for each item for the newest date and if the date is older than 180 days to display that record. Was relatively easy using the Last function but this does not exist now. Any help would be appreciated. TIA Try something like this: select Code , max ( date ) - ( This will give you the most recent date) from table_1 (- Your table) where date <= 01 / 01 / 2006 - (make this date 180 days ago) group by Code ...Show All

• Windows Forms Directory chooser

  I've a new question today, which should be quite simple for people who know how. How do i get a folder version of the openfiledialog that is so useful i want to select a folder to be set as default in one of my small programs, but all i can do atm is use openfiledialog to save a file, get the address, then delete the file, which is very long winded, and doesn't look good for the user. how can i get a directory viewer that lets the user just select a directory Thanks for your help. It'd be useful if there was a site that actually showed all of the really useful bits of code that i'm likely to need, because I'm asking on here a lot, and don't want to be a burden. Well, if you drag it from the toolbox, then t ...Show All

• .NET Development merging contextmenu strips

  Hi, I have a list of context menu strips which I need to merge as one, but the individual menus must remain unch ange d. I try to do that as follows: ContextMenuStrip contextMenuMerged = new ContextMenuStrip (); foreach ( ContextMenuStrip menu in m_contextMenuList) { for ( int i = menu.Items.Count - 1; i >= 0; --i) { contextMenuMerged.Items.Insert(0, menu.Items ); } } But once the item is inserted in the contextMenuMerged menu, that item is removed from the original menu. Is there any way to merge the context menus without modifying the original menus Thanks, Manju You'll need to clone the sub-items too for the same reason. Just call CloneItem recu ...Show All

• Visual Studio Express Editions Visual Basic 2005 Express help

  ok i have visual basic 2005 express installed and that is all no other programing software on either of my pcs. I am just starting to learn vb. and i am watching these video tutorials and reading these books. it says go to add new item then click inheritance form.. well that option is not availible in 2005 express. So can someone talk to me like i am stupid and tell me how to fix this. and also will inheritance form pull information from form 1. like num1 = whatever and i just reference num1 on the inherited form and it pull the information Thank you for the all the help is this right [code] Public Class Form2 Inherits System.Windows.Forms.form1 Private Sub Form2_Load( By ...Show All

• Visual Basic Code sample for dialing up in VB 2005

  Help : Need how to program a dial-up connection in VB 2005 to access a network You can try using the InternetDial win32 api function. You can find its documentation here: http://msdn.microsoft.com/library/default.asp url=/library/en-us/wininet/wininet/internetdial.asp -Scott Wisniewski ...Show All

• Visual C# Closing files (without saving) is slow

  I've seen other posts about the VS 2005 C# IDE being slow for typing or when saving files, but for me both of these cases are ok. But *everytime* I close a file (whether or not it needs saving), it takes several seconds. If I open up the "Windows" dialog to close several windows, it can take minutes. I've tried the obvious like defragmenting the HD, not having too many files open at once -- doesn't matter. Any suggestions Thanks! >8:02:48 AM devenv.exe:2008 IRP_MJ_CREATE  [localpath]\InvestmentMonitor.suo SUCCESS Options: Open  Access: 0012019F Devenv.exe either creates the file InvestmentMonitor.suo if it doesn't exist or opens the file and returns a handle to the file ...Show All

• Smart Device Development Assembly Permissions

  Hi, I am using third party dlls, whenever I deploy my application I get if I want to use that assembly or not, how can I avoid it You (or 3 rd party) need to sign that assembly with appropriate certificate. ...Show All

• Visual Studio Syntax error when using Online MSDN

  Hi, I have a problem with the Visual Studio 2005 help. Every page that loads i get a "line 1 syntax error" message box. It is DRIVING ME INSANE! I have tried to repair of the Document Explorer tool. I have looked for updates or KB articles and i can't find anything. I have tried turning off IE debugging but just the shape of the message box changes (and it doesn't ask me to debug), and the syntax error moves to line 2. A sample source for the page starts with XML so i thought that might be the cause but I am running the latest updates. Has anyone else had this problem Thanks in advance for any tips, Nathan The problem seems to occur when using Online MSDN. 1. Search for listbox. 2. Resul ...Show All

• Visual Studio Team System project alert email subject line

  My group's project alert e-mails are working well but do not come across with any subject line in the e-mail. The alert we have selected is the "my work items are changed by others". How/Where do I configure the subject line being sent in the e-mails Even having it use the message body's title would be better than nothing. The dll that would not load for us is Microsoft.TeamFoundation.WorkItemTracking.Server.EventFilter.dll. The event log should hopefully show the error message with more detail. ...Show All

• Visual Studio 2008 (Pre-release) Enumerating client connections on WCF server

  Is there a way to enumerate connections on a WCF server I have a scenario where I'd like some code on the server to be able to get a list of all the connected clients, e.g. to display which clients are connected. But more than that, I'd like to be able to add custom state information to connected client channels and have a service method then have access to all the other client channels which are connected to the server. I've looked at the IExtensibleObject<T> but it's not clear from the channel extensibility example how this should be used. Any suggestions anyone Cheers, MikeS. -------------------------------------------------------------------------------- MikeS Are you using InstanceContextMode.Session The ...Show All

• Windows Forms Custom Action does not run

  I am setting up my first deployment project on VB.NET 2005, and I'm running into a problem with custom actions. I have a test custom action that puts up a msgbox. I added that to the Commit phase, built the solution, then ran the install. The custom action did not work. Somewhere I read that is a known bug, and you have to also add the same action to the Install phase, but that it is not active. So I tried that, still it does not run. Thinking maybe you cannot show anything to the user with custom actions, I took out the msgbox, and added a file append. Still nothing. The custom action project runs fine if I run it on it's own (outside of install). I have the custom action project in the current solution. A ...Show All