Yones's Q&A profile

• Architecture Stored procedure vs standard query

  hi, I am in process of evaluating that for simple CRUD operations(select,update,delete,insert), should we use stored procedures or should we fire queries directly from DAL for performance enhancement leaving aside the fact the stored procedure pproach will mix the data access and business logic . If somebody could provide any microsoft URL link giving clearcut recommendation on the same,it would be of great help to me. Regards I do have some remarks on the above, so I'll state them by the numbers used: 2. Yes, SQL Server stores all T-SQL exec plans in cache, but... be aware that SQL server matches the cache based on the exact text that makes up the statement. Therefor, if you use a value of so ...Show All

• Visual Studio Tools for Office how to add smarttag on a chartobject in Excel ?

  we can add the smarttag on the range by setting the SmartTags property . how to add smarttag on a chartobject in Excel Thanks ...Show All

• Visual Studio Team System Does anyone know how to link bugs in VS2005 to MS Projects?

  It seems that "tasks" are linked to MS project but "bugs" are not. What the trick Thanks! You can customize work item type definition for bugs to include fields for remaining work, completed work, start date, and finish date that are referenced in the WIT Task. Once you do that you should be able to track time estimates for bugs in project assuming that you have these fields mapped in the project for tasks (otherwise you will have to update the field mapping). Hope it helps! -Mohammad ...Show All

• .NET Development Can't get past "turn customErrors mode=Off" page.

  I'm getting the infamous runtime error page. I do have customErrors mode set to Off. What else can I try Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" at ...Show All

• SQL Server What decides on the tables available for a partition?

  Hello, I am using the Partition Wizard. On the first screen (Specify Source Information) there are two tables listed. They are called: QMR_610_MembersOther_GrAmountAnalysis QMR_610_MembersOther_ReinsShareAnalysis Only one of those (the first one) is used as the fact table for the measure group that I am creating partitions for. So what I don't understand is why its making these 2 tables available for my partition. Can anyone explain how the Partition Wizard determines which tables are available for the partition Thanks Jamie Hi Markus, You are spot on. They have exactly the same metadata. I obviously need to give the guys who manage the objects (which happen to be views) a nudge It still seems s ...Show All

• Smart Device Development How to Convert Stream to String

  How to Convert a Stream datatype to string.For example Dim path As System.IO.Stream = (Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(AssemblyName)) the path should to converted string. converting a Stream to String Was this post helpful Hi everyone, I'm having the same problem trying to convert a stream to String. But nothing seems to work. Here's my code: void displayImage(IO:tream^ imagePath) { array <Byte>^bytes = gcnew array <Byte>(( int )imagePath->Length); imagePath->Position=0; int n = imagePath->Read(bytes,0,( int ) imagePath->Length); Sys ...Show All

• Windows Forms How (and where) to re-order an object's PropertyDescriptorCollection ?

  Hi, I'm trying different things with binding so that I can gain more than the usual 'passing' knowledge of how it works and have a small question. Say you have an object, a "Customer" object - and you have a list of "Customers", which is a BindingList of Customers. You then have a DataGridView and bind the grid to the binding list. This all works a treat. I have an "IsValid" property on my Customer object, but I don't want it in the grid, so I user the "Browsable" attribute. Still... all looks well. Now... I think to myself, in what order do the columns come out when I AutoGenerate the columns of the grid Ah... things start getting tricky because I decide I don't like the order and want to change it (this is just a learn ...Show All

• .NET Development Client Server Communication

  Hey all, I am investigating a system that will be comprised of two components: a Windows Forms application that will be installed on client machines, a Windows Service application that will be installed on a Windows server. The client will need to poll the service across a standard Windows network to check to see if the service has any data to send. If there is data available, the service must send it to the client so that the client can use it. The question is how do I implement this functionality I am wanting to keep the system complexity low and it needs to be fast. I was thinking about using TCP/IP sockets, but have little knowledge about this so any advice you guys have to offer would be great! Thanks in advance, St ...Show All

• Visual Basic How to convert Coordinates to image?

  Hi, I want draw a image using X,Y coordinates.(Ex- (88,50)(86,49),(87,48)) Can some body give me idea how to draw a bit map using co-cordinates. Thx & best rgrds Roopesh Hi Roopesh Create a new bitmap, get the graphics canvas from it and draw away something like this should do the trick dim bmp as new bitmap(w,h) using g as graphics = graphics.fromimage(bmp) g.drawline(pen, new point(x,y), new point(x1,y1) If x = x1 and y = y1 then you will effectively draw a single pixel point if that is what you are after ...Show All

• Visual C# Exclamation Icon cursor in IDE

  Hi, Anyone know why, when I load my c# project into VS2005, my cursor flashes as a exclamation icon (yellow triangle with black exclamation mark) This is very fast and may (or may not) do it every time. I can't see any obvious warning messages anywhere, everything appears to work. It's a real "did I just see that " thing - it's that fast, but it does happen quite often. Someone, somewhere, coded it to do that. It probably took some time to do. Shame it's not at all apparent why ! My first guess would be, besides the obvious default Windows settings, that this has something to do with an add-in. Do you have any add-ins installed ( Tools > Add-in Manager ) ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XFileLoader.cs

  Hi, I wrote a little class for parsing X-Files (text mode only). It currently reads: - frame hierarchy - frame transforms - meshes (position,normals,texcoords) It's only tested with x-files from the Panda Exporter and 3ds MAX. http://markus.rubicon-net.de/code/XFileLoader.cs and I used this here for test rendering http://markus.rubicon-net.de/code/XFileRenderer.cs Feel free to use it Is it possible to load .x file into the Model class I assume that's what the Content Pipeline would do, so it'd be cool if we could write code now that'd work when that comes along. I'm not sure how well implemented the class is, but I assumed it was the IDE integration part that was missing, since all the contentloader c ...Show All

• Windows Forms what is the proper way to update joined tables without concurrency violation

  hi i had made connection in vb 2005 and add data sources which contain joined tables and dragged this onto my form so when i update data it saves data sometimes and times not due to concurrency violation exception!!! what is the proper way to update data in my situation to avoid concurrency violation exception at all thanks in advance. Hi,seco Have a read at this topic: Concurrency Control And this: Handling Data Concurrency Using ADO.NET ...Show All

• SQL Server Remote Database Management Through LDAP tools

  Hai All How to insert and delete records from a table in the remote database " I want it to be done through a tool that used LDAP Servers. I want tools for the LDAP . Thank u Advance Regards Sunil ...Show All

• SQL Server AMO based C# application: Pre-requisites

  Hi, Okay I am finally done with my AMO application in C#. Here is a brief on what it tries to accomplish: It Creates/synchronizes an existing Oracle OLAP datawarehouse into SSAS. This is done using AMO in C#. I programatically create Dimensions, Cubes, MeasureGroups, Measures,Partitions, Update the DataSourceView and its table references. Finally I process the Cubes. This application is scheduled, where it picks up a list of entities to be created/synchronized to SSAS. I have created a Windows installer setup project for the AMO application. which has added the "Microsoft.AnalysisServices.dll" as a dependency. Now what I need to know is: 1. What are the other pre-requisites that need to be installed for the ...Show All

• Visual Studio Documentation Compiler - Sandcastle

  We did code complete of documentation compiler ( code named "Sandcastle") on June 15th and currently we are testing the tool building our .NetFramework documentation. We would like to release the CTP version of Sandcastle in Microsoft download center by next week. The perf in our testing has been great as we are able to build the entire framework content in less than 1 hour. I am in the process of going through final check and code signing required to post this in our download center. Please expect the CTP in the next week or so and I will provide an update here as soon I post the CTP. Anand.. Will source code be available I know this is a redundant question, but the way in which you've architected the application trou ...Show All