shekhar saran's Q&A profile

• SQL Server RaiseError inside stored procedure

  I want to execute some insert statements within a stored procedure and commit those changes regardless of any raiseerror that occurs later in the stored procedure. My difficulty is that I am forced to use raiseerror with severity 16 in order to send a message through the powerbuilder application interface (compiled vendor code). I have tried save points but can't get that to save my insert and still present an error to the user about something else that happens later. here is an example BEGIN procedure Insert something and save it even if error is raised below RaiseError('you made a mistake and need to do this.',16,-1) END procedure I suspect (since I don't have the ...Show All

• Smart Device Development compact framework activex

  hi i want to use windows activex on pocket pc or smartphones if it's not possible please help me and if it's possible ,please help me for helpful information thank you very much Here's how to host ActiveX control in NETCF application: http://msdn.microsoft.com/windowsmobile/reference/netcf/default.aspx pull=/library/en-us/dnnetcomp/html/host_activex_controls.asp Don't know if you can host Flash or not. Please contact Adobe and ask them if it’s technically and legally possible. ...Show All

• Visual C# Error Loading Project SOLVED

  Just come into work today tried loading up my work and get the following error message. http://uk.geocities.com/sr_burrows/error.bmp I have tried creating new sollutions but get the same message can anyone please help!!! Yes the project reference the file you mention but if you take a look at the file it reference the file i'm after [quote taken from Microsoft.CSharp.targets] <!-- *********************************************************************************************** Microsoft.CSharp.targets WARNING: DO NOT MODIFY this file unless you are knowledgeable about MSBuild and have created a backup copy. Incorrect changes to this file will make it impossible to load or build your p ...Show All

• Visual C# Can a Class Object be converted to DataSet object?

  Hi, Suppose I have got the following class: public class PurchaseOrder { public Item [] ItemsOrders } public class Item { public string ItemID public decimal ItemPrice } Is it possible to create a DataSet of the above class's object and generate following XML Like: dsDataSet.WriteXml(...) <PurchaseOrder xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <Items> <Item> <ItemID>aaa111</ItemID> <ItemPrice>34.22</ItemPrice> <Item> <Item> <ItemID>bbb222</ItemID> <ItemPrice>2.89</ItemPrice> <Item> </Items> </PurchaseOrder> Is ...Show All

• Software Development for Windows Vista Workflow Serialization

  Hello, i know that to exchange data between the host and the workflow it must be serialized but is it serialized by default even if i didn't add the serialize attribute or i have to put it and this mean that i can create object in my classes as long as it's not serializable Thanks, Tamer At the heart of WF there is only one mechanism for inbound data and one mechanism for outbound data. Inbound data comes through the WorkflowQueue object. WorkflowQueues are created by the workflow instance through the WorkflowQueuingService. Queues are not ever shared between workflow instances and the name must only be unique inside that specific workflow instance. WorkflowInstance.EnqueueItem boils ...Show All

• Visual Studio how can i solve multiple checkout problems?

  Hi all, In my team we use source safe 2005 with vs.net 2005 with multiple checkouts enabled.. the problem is when some one checkout a file and then another one checkout the same file and both the two make their modifications then one of them checkin the file and after that the other checkin the file ... when the one who first checkin the file checkout the file again after that, he did't find his last modification in the file as the last version was made by the other person who checked in the file later ..... how can i force merging the two modifications !! to be the last version is the version that combine both the two modification thanks The 2nd person to checkin will be prompted to merge his changes with those from the ser ...Show All

• Commerce Server creating catalogs

  I cannot create a catalog for either the CSharp or StarterSite from the CS Catalog Manager on my development server. In Tasks there is no option to create a new catalog and the menu item under File..New is grayed out even though the connection was opened successfully Here's what I did (e.g. for Catalog Service-did same for Orders,Marketing and Profiles). This was not the ideal security scenario but I am just trying to get this product up and running so I can show my boss how it works. Installed MSCS2K7 pre-requisites installed SQL2k5 Installed MSCS2K7 on my windows 2K3 box unpacked both the CSharp and StarterSite Created a local admin acct for MSCS2K7 (call it locadmin) which I used for all 4 services Assigned w ...Show All

• Visual C# webBrowser1.Font = button1.Font; NOT working :(

  Hello, I'm wondering why the following code is accepted by the compiler but there's no effect in run-time. Set browser url to about:blank at design time & make button1 font a little big then... private void button1_Click( object sender, EventArgs e) { webBrowser1.Document.Body.InnerHtml = "Test only" ; } private void button2_Click( object sender, EventArgs e) { webBrowser1.Font = button1.Font; } Why it's not working Your help would be greatly appreciated. THANKS. You cannot adjust the existing font at runtime you have to generate a new font. For example: button1.Font = new Font("Courier New", 14F ...Show All

• Software Development for Windows Vista Converting existing workflow from code based definition to xoml

  Hi, is there a way to convert an existing workflow that is code based to a xoml based definition Thanks -- Nuno Well, the post you referred to basically says that what I want is impossible, so yes, I'm still stuck... I made a bad decision at the start of the project (using a code based workflow) and now there is no automated way to convert the workflow. Not a critical problem, more of an annoyance. Thanks -- Nuno ...Show All

• SQL Server ClusterDistance value

  Can somebody please define the result of the ClusterDistance() function for me.  BOL and MSDN are vague about what the output means and I am getting some cases that have a value of zero and sometimes there are more than one per cluster.  Thanks in advance, Dan Meyers It does make sense. I just wanted to make sure that I was understanding everything correctly and I was not sure because the documentation is a bit vague in its definition of the function. Thanks Jamie. ...Show All

• SQL Server Union and Rank have dupliacted records

  Hi Everyone. I have a problem that I could not figure out what to do with it. I have a couple of tables and views. All have the same unique ID. When a user try to do a search on our web site we want to try to look in multiple tables and views, Rank the results and aggregate the results back (remove any duplicates). Part of the search is a Full Text Index search. I created already the following query that seems to be working ok except for one problem, some of the results are duplicated because the Rank is unique. select rank,[key],PL From freetexttable (dbo.items,*,'Key Words') as ft join Items as I on ft.[Key] = I.ItemNumber LEFT OUTER JOIN dbo.IM_90_UDF_IMMasterfile ON ft.[K ...Show All

• SQL Server MDX Query never finishes

  I am populating flatfiles from MDX queries run i SSIS against AS databases. I have ran in to problems with MDX queries returning large resultsets that never finishes. The query performed is purchase calculations over different time periods for each member in the customer dimension. There are 6-8 calculated members created and the customer dimension contains about 3,5 million members. When query is run, after 1-2 hours the server stop allocating memory and starts to get data from cache in intervals. In the end of each interval, memory is dropped. In perfmon it seems to be no activity during long periods I have given it as long as over 3 days without any result. Server is 8 x 64bit cpu with 16 gig memory. Some help in this ...Show All

• SQL Server matrix: more than 1 column in static rowgroups ?

  Hello, I am working with a matrix report item and would like to display something like that : DataGroup1 DataGroup2 StaticText11 StaticText12 Data1 StaticText21 StaticText22 Data2 StaticText31 StaticText32 Data3 But I cannot find a simple way to have 2 columns of static text on the left. The only way I've found is inserting a table report item in the matrix cells, but it cannot be exported in Excel. The only samples I found do'nt have multiple colums in the static rowgroup. Is it possible Kind regards, Xavier Miller. Hi, I'll try to give an example. I'm using the following query on the AdventureWorks db: SELECT Production.Product.Name, Production.ProductSubca ...Show All

• Visual Studio Express Editions About NEtFrameWork

  I am using win. visual studio 2005 and i am trying to do an application. But my application doesnt work without Netframework 2.0 How can my application works in all computer without netframework. Please reply.its very important Sorry for my bad english. It cannot work without the framework. it must be installed on all of the machines your projet is unstalled on. Generally this is part of the installation of your project. ...Show All

• Windows Forms Problem using Invoke to update UI from secondary thread

  Hi all, I have a small application that performs a time consuming process (resizing multiple images in a directory) so i am executing in a separate thread but i want to update the UI thread with the status of the process. I'm trying to do this in the standard way of defining a delagate and a method in the UI thread but i'm getting the following error messages: Error 1: An object reference is required for the nonstatic field, method, or property 'ImageResizer.Form1.listbox_delegate' C:\...\Projects\ImageResizer\ImageResizer\Form1.cs Error 2: An object reference is required for the nonstatic field, method, or property 'System.Windows.Forms.Control.Invoke(System.Delegate, params object[])' C:\...\Projects\ImageResizer\ImageResizer\Form1 ...Show All