pavel989's Q&A profile

• Windows Forms Use of DataGrid to make updates to SQL Server DB

  I am using a DataSet and DataGrid to update a database with C#.Net. I can get everything to work except the Delete. It is giving me the message that it can get access to row information and won't allow the delete. I am reading the dataset and updating some key information for records being inserted. When I started this, I could no longer delete. Is there something else that I need to do Am I accidentally wiping out some info when I update the origonal and changed datasets If you could post some code we could look at it might be a bit more helpful. Also, identify the specific error that is being generated. ...Show All

• Visual Studio Team System Accessing work item history from API

  How do I access the work item history from the API I want to traverse the history of the work item by entry if possible. If it is not possible, a string with all the history will help too. Thanks Hello You can fetch the work item of a particular revision from Work Item Store and then access the History Field to get the History. A sample code is here: WorkItem wi1 = WIStore.GetWorkItem(wi.Id); wi1.Open(); wi1.Title = testTitle + "Random Text"; wi1.Description = testDesc + "Random Text"; wi1.History = "Random Text"; int revisionNumber = wi1.Revision; wi1.Save(); WIStore.RefreshCache(); WorkItem wi2 = WIStore.GetWorkItem(wi.Id, revisionNumber + 1) ...Show All

• SQL Server Division in a precedence constraint expression does not work properly - huh?

  Greetings, I have an expression in a precedence constraint that is returning false when it should return true. This is the expression that returns false: ((5500 / 9990) * 100) > 10 The following expression returns true. I did the division (5500 / 9990) myself and substituted the resulting value: ((0.55055055055055055055055055055055) * 100) > 10 Why is the first expression returning false I'm stuck in the mud up to my axles on this and I know I'll probably feel like a fool when I learn the answer... Thanks, BCB Hello jaegd, Thanks for putting me wise on this one. Regards, Black Cat Bone ...Show All

• .NET Development VA Error please contact site Administrator

  Hi Friends I got a error in mcms db.( VA Error Please Contact site Administrator ) In my application, i am using Sharepoint 2003, mcms 2002 and SQL server 2000. I using mcms placeholder in portal and retrriving the data's from mcms. in production i got a VA Error some times. Once this error comes full production haveing problem. we doing a temperature solution. i.e, There were two process on the mcms db that were bloked. These two were both owned by vzh/rc_admin - one was select command and other a DBCC. When the two processes were killed, the application retured to normal functioning. i need a permanant solution. Please do the needfull Thanks Jenkins ...Show All

• Windows Forms Taskbar Problem

  When application startup, the application taskbar button doesn't appear on the task bar, any suggestion to fix it Sorry, I'm refer to general application like excel or winword. They never show the taskbar button when it start up. Any suggestion ...Show All

• SQL Server Train mining model - more info

  hi, I newly Installed my SQL 2005.When I try to train my Model its giving me " Key not valid for use in specified state. " Can anyone help me how to figure it out Thanks, Karthik when i rename the hkey_current_user/software/8.0 it to hkey_current_user/software/8.0back and restart the m/c its working.but after sometime i face the same error. Is there any relation with the assembly I am registering an assembly created in vs2005. Thanks, Karthik. ...Show All

• Visual Studio Express Editions SQL Commands?

  Anyone Please help me converting this sample add,edit delete to sql commands,. This uses a MS Access database. Thanks a lot Imports System.Data Public Class frmDB2 'Declarations Dim con As New OleDb.OleDbConnection Dim ds As New DataSet Dim da As OleDb.OleDbDataAdapter Dim sql As String Dim kulaloy As Integer Dim maxrows As Integer Private Sub frmDB2_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Try con.ConnectionString = "Provider = Microsoft.Jet.Oledb.4.0;Data Source = D:\vb.net project\AddressBook.mdb" sql = "SELECT * FROM Contacts" con.Open() da = New OleDb.OleDb ...Show All

• Windows Forms Enabling/Disabling ToolStripMenuItem objects

  Hi, I have a big MenuStrip and I want to create a Sub to enable or disable each ToolStripMenuItem, where the Item name and the status are parameters for the Sub. The Sub can be something like: Sub SetMenuEnable(ByRef MenuName As String, ByRef Status As Boolean) myMenu.Items(MenuName).Enabled = Status End Sub Any idea how to do it in vb.net 2005 Thanks Cristian That was great saved me a lot of pain while programming for setting user menu priveledges. Thanks. Great Work. ...Show All

• Silverlight (formerly WPF/E) Text alignment?

  Is there a reason TextAlignment isn't supported for the TextBlock element If so, I hope the reason is simply a matter of "not yet implemented", since I believe this to be an important feature that needs to be supported for the first release. Particularly when wrapping is involved, this is something that needs to be provided by the basic text rendering functionality. Our philosophy is to enable as broad a set of customers scenarios as possible with the smallest runtime and exposing the smallest surface are possible. For reach scenarios, we have to be small and agile to be successful and as such, we can release minimal broad surface area quicker, get feedback, and add layers on top of the mini ...Show All

• .NET Development .Net Remoting And ReaderWriterLock

  Hi, I am working on a .Net Remoting program. In side the remoting class, I need to use a ReaderWriterLock object. But it seems that all method calls from remoting client can easily acquire the writer lock on that object regardless the lock has been acquired before. Here is the code sample public class RemotingExampleService : MarshalByRefObject {     private ReaderWriterLock lockObj = new ReaderWriterLock();     public void  LockObject()     {         Console.WriteLine(lockObj.IsWriterLockHeld); //return true except the first call         lockObj.AcquireWriterLock(-1);     } } I used Singleton r ...Show All

• SQL Server Looking for sqlrun_tools.msi

  Today my computer started doing something strange when trying to compile a setup&deployment project. This project doesn't contain anything related to sql server whatsoever. When i compile, it pops up a windows installer dialog that starts doing something. Eventually it asks me for my Sql Server 2005 Tools disc, specifically looking for sqlrun_tools.msi. I tried putting in the disc that i'm pretty sure it was installed from (my MSDN disc) but it told me that the sqlrun_tools.msi on that disc wasn't the right one. I have no idea why its asking me for this at this time, nor do i know to do to get it to stop. Thanks in advance for any help. I am having the same problem. Whenever I try and b ...Show All

• Visual Studio 2008 (Pre-release) WCF + MSMQ + Large Data

  Is it a sutable approach to transfer a large amount of data via WCF using MSMQ Certainly we know such limitation of MSMQ as 4Mb. The core of the question is whether to use WCF or not Thank you. Sorin, >You will have to send the messages as datagrams and have some kind of processing logic on the service side >that will group the messages together. The best way to do this is to pass some kind of identifier as part of >the contract. speaking of; do you know if the WCF team plans to-do an implementation of the ws-enumeration[1] specification if not, then perhaps a custom channel that supports sql2005 broker architecture. regards Allan [1] http://www.w3.org/Submi ...Show All

• Visual Basic Missing Components after installing Speech SDK5.1

  Hello again. I just recently installed Speech SDK5.1 in my computer. The problem is, whenever I look in the COM components of VB2005 or in the components of VB6, I can't find where the components are. If I'm not mistaken, the missing components start with "Microsoft Voice...". Can anyone help here, please Thanks very much ...Show All

• Visual Studio 2008 (Pre-release) what would "C" be called in the following code snippet?

  string [] str = {"abcd","edfe","asdfasd"}; var q = from c in str select c; foreach(var val in c) Console.WriteLine(val); First off, there is a bug in your code. Since you are projecting the results of the query into a variable called "q", you should iterate over q rather than c in your foreach loop in the subsequent code. In the query, c is essentially a local variable just as you would have in a standard foreach loop. Indeed, we could easily accomplish the same basic thing as you did with the following syntax: foreach(var c in str) Console.WriteLine(c); Now, substitute "from" for "foreach" and you get the que ...Show All

• SQL Server How to refer to the whole cube while using the filter of the cube browser?

  Hello! I've got an accounting cube with balances as measures and amongst others a time dimension. There's also a calculated member which should show the balance of the previous year. This calculated member uses the PARALLELPERIOD-function. So far everything works fine! But while using the filter of the cube browser and selecting a certain year, I can't refer to other years than the selected year. So how can I get the balance of the previous year Thanks for any help! Ok, there seems to be no solution which makes my calculated measure working properly. Right now I'm testing a beta version of Excel 2007 as BI frontend tool to see how it deals with this problem. Thank you very much for help! ...Show All