vivek_pon's Q&A profile

• Visual C# Double trouble - Numbers gain fractions

  This piece of code looks pretty simple: double num1 ; num1 = 10.72 ; But after num1 has been assigned it holds the value of 10.720000000000001. If I change to float it's 10.7200003. I know you're supposed to use decimal if you want better precision but this loss of precision seems very unnecessary. Can anyone offer an explanation /David The problem is that floats and doubles are binary representations of numbers, and not decimal ones. The numbers you've seen are simply the closest they can get to the decimal number we think of as 10.72. Read this article for more info on the subject. ...Show All

• Visual Studio 2008 (Pre-release) Possible to remote an Expression tree into Yukon?

  So this crazy idea came to me over lunch. Yukon hosts the CLR.  It can also host a web service.  Provided that the CLR hosted has access to all the stock .NET framework, I wonder how worthwhile it would be to: 1. Create an expression tree at the client side. 2. Transmit the tree to a service on Yukon. 3. Have Yukon execute the tree in the context of the database (security being managed, of course). 4. Transmit the results back to the client. This would be an interesting way to solve the problem of SQL not supporting many of the things we should like, and no simple means to create ad hoc CLR procedures.  It's generally a bonus ...Show All

• Visual Studio Express Editions BalloonTipText on NotifyIcon1 Hover over?

  I've been looking at how to use BalloonTipText, and I found this small section of code: NotifyIcon1.BalloonTipTitle = "Balloon Tip Title" NotifyIcon1.BalloonTipText = "Balloon Tip Text." NotifyIcon1.BalloonTipIcon = ToolTipIcon.Error That isn't working for me though, in the test app I made to try it out. I put it in the NotifyIcon1_Click event and nothing showed up. I'd really like to be able to display something when the user hovers over the notify icon too, and I couldn't find a hover over event. Also, can I use a variable for the text in the balloon tip Any help would be appreciated. ...Show All

• SQL Server Add member failed for DatabaseRole 'db_datareader'

  I tried to give myself datareader and datawriter for my domain login and got this error below.  I'm logged into the server with my domain account which has admin rights.   TITLE: Microsoft SQL Server Management Studio ------------------------------ Add member failed for DatabaseRole 'db_datareader'.  (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Add+member+DatabaseRole&LinkId=20476 ------------------------------ ADDITIONAL I ...Show All

• Windows Forms How to refresh or rest a dataset

  Hi, In my application I use a dataset and populate a datagrid. there is a drop down list where I choose clients and it'll fill the dataset with a sqldataadapter.Fill() customers related to that client. But when i change the client it adds the next set of customer but won't clear the previous. How can I avoid this. Many thanks, -VJ hi, Sorry if my question was not clear. I didn't know how to clear the dataset before filling it again. Therefor when ever I refil it the datagrid showed me the old records. Many thanks for all the help. -VJ ...Show All

• Visual Basic mscomm vb6 --> vs2005

  I have a very simple vb6 program I want to convert to VS2005.  MSComm is nolonger available and I don't understand how to receive data without the mscomm_OnComm() event. Please advise.  Also, can this be implemented so that the code is exposed to MSAccess 2000   Ultimately I need to communicate to a piece of Lab equipment connected to the serial port using a production application written in MSAccess. Thanks *VB6 Code* Dim Buffer As String Private Sub MSComm1_OnComm()     If Me.MSComm1.CommEvent = 2 Then         Buffer$ = Me.MSComm1.Input      & ...Show All

• Visual Studio Tools for Office Reading Excel From C#

  You can read data from Excel using the JET OLEDB provider. See the URL below for the necessary connection string, and a link to a KB article with further information ... http://www.carlprothman.net/Default.aspx tabid=87#OLEDBProviderForMicrosoftJetExcel -- Brendan Reynolds wrote in message news:9226766e-a1d5-400c-8d3c-8ffc566bec50@discussions.microsoft.com... > Hi > > Can anyone help me how to read values in Excel in C# . So that Once I > read I can send them to DataBase. My excel file Test.xls in ("C:\") > > Thanks > Doss > Hi Can anyone help me how to read values in Excel i ...Show All

• SQL Server Database locking issue

  We have a table with an update trigger that we seem to be having unintended deadlock issues. The trigger, among other things, updates the same row that was updated to spawn the trigger. In our examples where we are encountering the deadlocks we are always doing single row updates on a unique clustered index. Originally, we seemed to be having a lot of unnecessary lock escalation occurring to the page and table level. We added a lock hint to the table to prevent page locks ( sp_indexoption 'osc_play.cylmas.uq_cylmas_barcod', 'disallowpagelocks',TRUE ). This has helped minimize the deadlocks on that table considerably.   Howeve ...Show All

• Windows Forms when i menimised the form it should not appear in the toolbar

  i have form which calls another form when the object of the form is created the the form is show in the toolbar of the window i doesnot want it to show it in the tool bar when it open the form is there any sol to it other than using MDI container regards RpM ...Show All

• Windows Forms is MDI application the best solution?

  Hello, I need to develop one application that contains a few of controls all the time (a graphical menu  in the left of the form, a counter of coins at top, as well as a big bunner on the top.  The rest of the screen will be a sequence of definied forms, with one back button and one next button (maybe in the bottom of the ...Show All

• Windows Forms How do I NOT include the .NET Framework in my Setup & Deployment package?

  I decided I needed to have my setup project include the .NET Framework so I installed the "Microsoft Visual Studio .NET 2003 Bootstrapper Plug-in".  So it works great and all but now I don't know how to have my Setup project NOT include the .NET Framework.  How do I turn it off   Thanks in advance!!! - Thanks That doesn't work!  When I do it that way, I only get a single .msi file.  But when I uninstall the Bootstrapper Plugin and build, I get a setup.exe, settings.ini AND the .msi file.  Do you see what I mean by that   Thank you for your help! - Sean ...Show All

• Windows Forms How to capture double click event on a datarow in the grid

  Hi,    I need to capture double click event on the rows of a datagrid in winforms application. I could not find anything for this. I would appreciate any help to achieve this. Thanks... System.Windows.Forms.DataGrid inherits from System.Windows.Forms.Control, which exposes a DoubleClick event. You can then grab the currently selected row via grid.CurrentRowIndex. You have to double click on the row header for this technique to work. ...Show All

• Visual Studio 2008 (Pre-release) serviceType information

  Why is the serviceType specified to the WCF infrastructure in two places a) ServiceHost creation - constructor parameter b) An attribute of the service element in the config Am i missing something very basic here -Sendhil this is another example of declarative vs imperative... the infrastructure gives you the flexibility either to host the service declaratively, through IIS, for example, or host the service programmatically David Pallmann's book "Programming Indigo" has more on this, see http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnlong/html/progindigoch3.asp ...Show All

• Windows Forms Passwords in DataGridView

  I need to display usernames and passwords in a DGV, and I have 2 questions : How do I display the password as a string of asterisks Right now, I am storing them in a List<string>, and then doing something like this foreach ( DataGridViewRow row in dataGridView.Rows) { string s = "" ; for ( int i = 0; i < passwordList[row.Index].Length; i++) s += "*" ; row.Cells[ "passwordColumn" ].Value = s; } Is there a better way to do this When the user sorts by a column, and then "unhides" the passwords, the order of the passwords is incorrect. This is because upon unhiding, ...Show All

• Visual Studio Team System VS help urgent!

  I currently use the VB.NET Standard Edition. I am unable to connect to a SQL server Database  using the Data Form Wizard or the Data Link.  I get this error message: Unable to connect to database. It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access databases with this version of visual studio.  If I upgrade my Visual Studio will this solve this issue Thank you Hi Toodie, I think you might have posted in the wrong spot in the forums (which is why you didn't receive a quick response).  This would probably be a better spot for this question: http:/ ...Show All