Balamurali Krishnan's Q&A profile

• Visual Studio Express Editions remove all but numbers

  This is the sort of data that i have; chris - 0400423068 tom - 0400987389 Heidi - 0412139864 and what i want to do is remove all but the numbers. dont worry i got it my self. Dim extract As String Dim start, finish As Integer extract = nameslist.SelectedItem MsgBox(extract) extract = extract.Replace( "-" , ">" ) MsgBox(extract) extract = extract + "<" MsgBox(extract) start = extract.IndexOf( ">" , 1) + 1 finish = extract.IndexOf( "<" , start) extract = extract.Substring(start, finish - start) MsgBox(extract) ...Show All

• SQL Server Multiple Cross Apply

  Good Afternoon, I'm attempting to leverage SQL's new 'APPLY" operator and I guess I don't fully understand it proper usage. This is a relatively simple request, first i want to count the models produced within a valid period of time. The first 'Cross Apply' gets the valid starting and ending dates and looks ups the number of models produced for the period of time. This section of code works perfectly fine. The problem appears to be with the second "Cross Apply".  What I'm attempting to accomplish is to count all models produced, regardless of time frame. When executed the query appears to go into an loop and I end up canceling out the request. Any ideas where I went wrong Any help is greatly appreciated!   s ...Show All

• Visual Studio XY Scatter Chart - Y value appearance with expressions

  I want to know if there is anyway to force report control to evaluate an expression for the "marker" size and shape, as opposed to use the "Marker size" selection under the "Appearance" tab. There is no "fx" button next to this menu item. I have successfulyy set a function for the color of the markers using a function expression in the "Fill" tab of the Series Style. Also, an attempt to substitute an expression inside the rdl xml entry for the size / shape tags did not work. Is the scarcity of display attributes with expression evaluation capabilities just due to the control being in its first incarnation, or am I wrong in assuming this can't be done now ...Show All

• Visual Studio Tools for Office Is VSTO-enabled protection of an Excel workbook stronger than regular Excel/VBA?

  I have a complex financial model in Excel that I have password-protected and I give users access to it through an Excel Addin - VBA opens the file and custom commandbar buttons enable subs that manipulate some of the data, allow the user to save certain data, etc. Sheets that I don't want users to see are hidden, other sheets are visible but cells are locked and input sheets have unlocked cells. Also the VBA code in the Addin is password-protected. I know that Excel and VBA security are weak so my existing setup, summarized above, will only prevent casual users from not accessing my model. So I am researching VSTO as a more secure alternative. I know that the VB programming code will be safe, but what about the Excel workbook If I creat ...Show All

• Visual Studio Team System Build notes - how do you create them?

  I was hoping users on this forum could share ideas on how best to create release notes and if it possible to automate part of that. Although work items are generated as part of every build we'd need an aggregation of WIs from say build 1-15 if that were the interval between builds that were deplyoed in the QA environment. Creating a utlity/web site that uses the TFS object model to extract WIs is a possibility but I don't want to run this as some kind of a report. I think a good approach would be to have the notes published on Sharepoint, i.e. you don't have to generate them every time. Anybody have thoughts around this Unfortunately, there's no way to do it without some effort. If you know the range of builds for which you want t ...Show All

• .NET Development Uninstalled IIS due to corruption then reinstalled IIS - What issues may I encounter Please Help!

  I have Uninstalled IIS due to corruption then reinstalled IIS. Currently I have Microsoft.Net FrameWork 1 + 2 installed on my system, as well as Visual Studio 2005 Pro and SQL Server 2005 Express Edition. Also I have Borland Delphi 7 and Coldfusion MX 7. Coldfusion has already problems, and wont load the .cfm extensions so I have had to Uninstall and reInstall this to get it to work correctly. I have noticed that some of the Quickstart pages associated with .Net Framework 2.0 and ASP.net wont load - when their web address points to my localhost already. Is there a way to repair these installations. Can I expect more troubles with my other Microsoft Installations because Of the uninstallation, Reinstallation of IIS . Please any ...Show All

• Visual Studio Team System Cannot get the target machine's performance.

  Hi, I am a newer using Load Agent to do performance test. when I did a tst , I could not get the target machine's performance counter. I had turned of the firewall but there is not the name of target machine in the computerlist. One thing of note that I learned is to be aware of permissions. I had the same issue doing a load test across networks.. VS was on one network hitting a KB server and I could not collect performance data since I had no permissions to gather data from the server box. I was unable to find a 'connect.. as' so I moved VS into the network, logging in as the test lab's domain administrator. Once I did this, my counters worked. It would have been nice if VS came out and told me "cannot connect t ...Show All

• Visual Studio Express Editions Visual web asp 2.0 build to a dll

  Howdy, This will most likely be a complete newb question but: How do i compile an entire asp 2.0 project to a dll. I was using visual studio 2003 and it did it automatically. It was a student version and now that I am no longer in school, i thought i would try to be legal and use Visual Web Developer 2005 Express Edition. I would even be willing to read up, but when i searched the help tools, i didnt find much in the way of a guide in how to compile all the .vb files into a nice dll i can put in my bin folder like i use to. any help would be greatly appreciated. thanks! I would try posting you question in the asp.net VWD Group on http://forums.asp.net as this is where the web developers hang ...Show All

• SQL Server Subtotal by page

  Dear guru! How I can define subtotal by page in the table Is it possible Thanks in advanced. Yes, you are right, use the second approach. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio 2008 (Pre-release) Linq to Entities and Linq to SQL

  I've just about finished reading the ADO.NET Entity Framework Overview document and have been playing with Linq, Xlinq, Dlinq (apologies for no political correctness in what these are all called now). One thing i don't quite get is why the distinction between ADO.Net entities (Linq to Entities) and Linq to SQL - other than for historical reasons. Now i think i grasp the intentions and purposes of both (disclaimer : i haven't read all the docs about dLinq quite yet!), but why they are defined as being different is a little confusing for me. Would Linq to SQL not be regarded as conceptual "Linq to Entity" - that is ADO.Net entity over a single table In other words, although they operate on a slightly different basis, should I ...Show All

• Windows Forms How to set scrollable TextBox into bottom position if it has multiple lines.

  I use a multi-line scrollable (vertical) Textbox to display some error messages during processing. I append error message into Textbox one by one. But the Textbox always display the top 10 messages when error messages are more than 10 lines. How can I set to the button line Thank you very much~ I guess you could do something like : TextBox1.SelectionStart = TextBox1.TextLength TextBox1.ScrollToCaret() ...Show All

• SQL Server Vista IIS7 and asp.net reporting services wont deploy

  I am using vista, iis7 sql server 2005 sp2, vs 2005. i first noticed that i could not deploy to the localhost server after upgrading to vista. i installed sql server sp2 and configured the iis7 using the control panel. Everything i needed to check off got loaded exept the asp.net check box in the ApplicationDevelopmentFeatures subcategory under the iis configuration section. It errored out when i clicked apply. there was no specific error just that it did not get added. Controlpanel> Programs>T urnWindowsFeaturesOnAndOff> InternetInformationServices> WorldWideWebServices> ApplicationDevelopmentFeatures> Asp.net (check box) When i click OK, afte a few minutes, i get a message: "An error has occur ...Show All

• SQL Server retry component

  Hi, I am trying to do a retry component. My idea is to create a custom code that that should be place on the event handler - on error of every task. The code should be able to identify which task failed, then retry X number of times after Y time interval based on package variables. Do you think this is possible How ...Show All

• .NET Development Filling a DataAdapter with Datareader

  Hi. I am developing in Visual Studio.NET 2005 I am trying to fill a Dataset object with SqlDataReader object. Is there a way to fill a Dataset object with SqlDataReader object , similar when you fill a Dataset object with a SqlDataAdapter object: SqlDataAdapter.Fill(DataSet) Thank you and best regards. Christian. Dim Table As New DataTable("MyTable") Dim reader As IDataReader = GetReader() Table.Load(reader) Regards: Jesus ...Show All

• SQL Server Create Customer Ranking in Cube

  Hey guys, is there a way i can create a Rank Member or measure in my cube based on sales for that customer, no matter what time heirarchy we are looking at. I have reporting requirements where they want to see all customers, ordered by Sales Amount. It could be at a year level, month level, or even a week/day level.. Im new to SSAS and MDX, i have looked at a few examples posted here, but cannot work out where i put the script in my cube. Is it a measure or do i do it as a calculated column in the DSV. Any help is much appreciated. Thanks Scotty > You're right in the strict sense - the reason I added NON_EMPTY_BEHAVIOR was to remove rows with no sales for this specific query (ie. a query ranking only among cu ...Show All