Raghavendra Prabhu's Q&A profile

• SQL Server beta3

  Does beta3 work with vs2005 beta2 Are there any special rules for uninstalling the april ctp first dennist First, through Add or Remove Program, remove all of the SQL Server components (SQL Server Setup Support Files will removed automatically so you shouldn't have to touch this component. Don't forget to remove SQL Native Client as well). Second, through Add or Remove Program, remove .Net Framework 2.0 Third, install the SQL Server 2005 June CTP Dan ...Show All

• Microsoft ISV Community Center Forums Excel Data Read

  Hey people. I still can not find anything that directly explains yet how I can get a value in column D in an Excel File that I have linked, to a VB string, based on a selection of a value in column A. I am dealing with metal gauges and cost for metal I have a listbox pulling data through databinder from column A in my excel sheet. Now I need to assign the value cost of metal for that gauge to a variable. As easy as this sounds to me explaining it, I am missing something here. In Excel, I would simply use a vlookup command. In SQL I would use a select cost from materialcosttable where gauge = [gavariable] But I need to write this natively in ...Show All

• .NET Development Problem with web service that involve entity.

  I have the following error when I call my web method which have entities as parameters or return value. What is wrong with my call I have no problem with web methods which don't have entities involved. All the related code are shown below: Thank a lot. Error System.ApplicationException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> There was an error generating the XML document. ---> The type Entity.eWarehouse was not expected. Use the XmlInclude or SoapInclude attribute to specify types that are not known statically. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadRespon ...Show All

• Visual Basic Transparency seems impossible in Visual Basic 2005 :..(

  Hi, I've been using VB 6.0 in the past, but .gif transparent images were too limited in colors, and .png seems so much better. So I got the beta 2 edition of Visual Basic 2005 (free off Microsoft's website, nice surprise!). The thing is though, transparency like on the image I attached above doesn't seem possible. The transparent pixels just show the form background, not the other image below. Am I missing something here I was wondering what the best way (that's still simple for someone who hasn't programmed in a while, hehe) to make it work In VB 6 a transparent text layer worked perfectly. So for example I could have giant "RELOAD" te ...Show All

• Visual C# Is it possible to swap in DataGrid?

  Hi, Can you help me to switch the mode so that display of the data grid is swapped. say the given titles in column header has to be in the corresponding row header i.e. in column zero(vertically not horizontally). Is it possible to swap rows to columns and columns to rows in DataGrid A quick response will be helpful. Thanks in advance, ...Show All

• Windows Forms Windows installer and self updates

  How can I create a Setup project for a VB.Net 2005 Windows Forms application with self-updating capabilities. The app needs to be installed in the Program Files folder for all users. Any advice/help will be appreciated. There's nothing built in to do it. You have to do it by writing self-udating code. There's some you can use, the AppUpdater component, at: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnpag2/html/UABch1.asp ...Show All

• Windows Forms Control Array sorta. How can I do this in .Net.

  For i  = 0 to 3     Me.Control & i &.Text = i Next i Obviously this example wont work, but how can I duplicate the logic. I have two rows of labels that are named similar to this below and I want to populate them by using the label name + counter to specify the name. Im open to other options if this technique doesnt&nbs ...Show All

• Windows Forms Font Change

  How can you automatically change the font size according to your screen resolution Public ReadOnly Property FontSize() As Integer Get Return SystemInformation.PrimaryMonitorSize.Height \ 60 End Get End Property ...Show All

• SQL Server How to sum all footers?

  I am doing a CountDistinct(JobItems) in one of my list groups. In the footer I want to have the sum of each of the CountDistinct I calculated above. I can't do a count distinct for the entire dataset because the JobItem I'm counting can repeat across groups and that would produce the incorrect number. Note: I'm trying to avoid writing custom code because I have a lot of things similar to this. Thanks for any help. If you need example data please ask. This is a classic aggregate-of-aggregate problem.  Unfortunately, aggregates of aggregates is not yet supported in SQL 2005.  The only thing you c ...Show All

• Visual Studio T-SQL Debugging on VS2005/SQL2005

  Hello, I can't seem to debug an SQL stored procedure using VS .Net's 2005 debugger. When I Step into stored procedure the breakpoint turns to a question mark and  says "The breakpoint will not currently be hit.  Unable to bind SQL breakpoint at this time.  Object containing the breakpoint not loaded". VS2005/SQL2005 are on the same machine running Win2003 Sp1/R2 Thanx for the help ...Show All

• Visual Studio mscorsvw will not stop running

  I installed .net 2.0 beta 2.  After 2 days, mscorsvw continues to dominate the CPU.  Other process such as logon and Oracle DB take about 3 times longer to execute. This is not a bug please read the following blog post http://blogs.msdn.com/davidnotario/archive/2005/04/27/412838.aspx ...Show All

• Visual C++ Managed COM

  Hi, i wanted to expose some application COM classes written in C++ to other COM capable languages so i tried to write some test classes and exported a *.tlb with regasm.exe. But it doesn't work cause neither interfaces with id's nor class id's are defined in the *.tlb So there is some kind of a exporting problem. Heres the code: // Class interface AppInterface [Guid( "4F588E58-C85C-4b8c-A831-CDE454B5C218" ), InterfaceType(ComInterfaceType::InterfaceIsIUnknown)] interface class AppInterface {   String^ GetAppVersion();   void Initialize(); }; // Events interface AppInterfaceEvents [Guid( "57EA6615-5526-42d4-9039-2A0FC ...Show All

• Windows Forms datagrid header alignment

  Hi. Is there any way to center-align columnheaders in a datagrid while the text in the rows of the column is still rigth-aligned I found out using datagridTextBox.Alignment, but this aligns both header AND text in the rows... any help   I have the same problem. In fact, header alignment is by default left-aligned, the center-alignment option does not&nb ...Show All

• System Center The outgoing agent queue is full

  HI, I can't find the agente queue to verify if it is getting full or if it is already working fine. How can i know if the queue is normal Thanks, Belmiro Hi Belmiro - if you're referring to our modeling of MOM queues, we don't directly expose that in the interface (although we do account for it under the hood). Let me know if you need more help. ...Show All

• Visual Studio Programattically render pdf from ReportViewer

  I have created several embedded ReportViewer reports in asp.net 2.0 (using VB). Love the ReportViewer. Used Cognos SDK up to 3 wks ago, but not any more! When my app's user pushes a button, 8 diferent reports come up in separate browser windows (e.g. Response.Write("<script>window.open('../Reports/rptOversale_Compare.aspx ','_OverSaleCompare');</script>")). What I want to do is have the reports come up in pdf format. Is this possible The ideal objective for this app would be to have the 8 reports come up as pdf inside a tab control, but I can't find any code or direction anywhere on how to programmatically spit ...Show All