Manoj Verma's Q&A profile

• SQL Server problem with convertion of datatypes from Derived column to Slowly changed dimensions

  Hi, I am facing the problem with datatype conversions, the scenario is using derived column transformation for add additional columns and then later i am trying to impliment Slowly changing dimensions(SCM) in my job, while mapping the columns at SCM from Input to Output it gave the error like suppose if i am using the numeric(3,0) at SRC system then i converted it into single byte unsigned at derived column and it recognized at SCD but the job fail while run the package it gave the error as task can not able to conversted given data type to target system dtata type.. ifi am not given the single byte unsigned data type at dervied column at the level of SCD mapping the input to output its not accapring this mapping and return the error as ...Show All

• SQL Server How to automatic update view when table's structure has changed

  For example: Create view View_AutoUpdate as ( select a.*,b.[name] from User as a,Company as b where a.CompanyID=b.CompanyID ) Done,but when i do it follow: Alter table User add UserAddress nvarchar(50) null Done. finally,i type "select * from View_AutoUpdate ",the list column is not right. thanks After you alter the table, exec sp_refreshview 'view_name'. This should update the view definition to include the newly added table column. HTH ...Show All

• Windows Forms How to add an existing object to the design surface

  This is my first crack at using the DesignSurface and related objects to build my own design environment. I have opened and pretty much understand most of the sample at http://msdn.microsoft.com/msdnmag/issues/06/03/DesignerHosting/ along with a couple of others I have found. The problem I'm having right now is I don't know how to add an existing user control to the design surface. For example here is some pseudo code explaining what I'm trying to do. MyUserControl muc = new MyUserControl(); muc.BackColor = Color.Blue; //modify a few more properties here. NOW ADD THIS CONTROL to the design surface. Can I add an already instantiated control to the design surface (or whatever) or do I have to create a new control and ...Show All

• .NET Development problem with XmlWriter

  Hi everyone, When I use XmlWriter to write XML file, I've encountered a problem: what I need to write is something like: <MyNS:MyControl>bluabluablua</MyNS:MyControl> I've tried to use XmlWriter.WriteStartElement method to accomplish this, but I'll get a runtime exception said: "Invalid name character in 'MyNS:MyControl'. The ':' character, hexadecimal value 0x3A, cannot be included in a name." So I could use the overloaded with namespace one WriteStartElement("MyControl", "MyNS"), but only got: <MyControl xmlns="MyControl">bluabluablua</MyControl> this is definitely not what I want! If I can't do this with XmlWriter, does anyone know another way ...Show All

• Windows Forms from string to form

  Suppose you have the name of the form : string fname = "FormSomething"; How do I create a form object with fname as name Apparently this is not enough: Form f = new Form(); f.Name = fname; Also tried: f.CreateControl(); Can anyone please tell me how to get the form object Thanks!!! Assuming you know the full name of the form (namespace & class name) and what assembly it is in you can do something like this: Type t = Assembly .GetExecutingAssembly().GetType( "MyTestApp.FormSomething" ); Form f = ( Form ) Activator .CreateInstance(t); This code does three things. First, it located a specified assembly, in this case the main executing one, you could a ...Show All

• Visual Studio Visual Studio 2005 SP1 doesn't support pre SP1 projects?

  After upgrading to Visual Studio 2005 SP1 I get the following error when I try to open up any existing solution: "The project file '<project>.csproj' cannot be opened. The project type is not supported by this installation. This is the second machine that I have screwed up by performing the SP1 install with identical behavior (It was an independant download of SP1 code.) VS05 with SP1 seems to be able to create new projects fine and it does seem to like its new projects, but doesn't seem to like any pre SP1 projects. Not after installing SP1. Yes before then. I upgraded the 2nd machine because I really couldn't imagine that this would be a real problem and thought the first w ...Show All

• .NET Development Differences in Threading

  hello there! im very confused in threading topics even if im looking and reading at MSDN libraries. the authors just give too much code on their samples. i just need straight-to-the-point explanations. so heres what im asking. hope somebody can answer this. Q: What are the differences of Monitor, Mutex, AutoResetEvent, Semaphores ok, this it. so hope somebody answer this question. thanks! ;-) Hi, JerberSoft I recommend you read the whitepaper that Albahari Joseph wrote on Thread Programming in C#. You will find a lot of information about the different lock mechanisms and more background information: http://www.albahari.com/threading/threading.pdf Thank you ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA certification exam

  I apologize if this is not the right place to ask, but I've seen some requests for DirectX certification, for which there were(/are) no plans, and I've been wondering this about XNA since I first noticed it on the Startpage of VB express: Is there going to be an XNA certification exam, as part of a current development cert, or a MCGD cert for example (covering Net2.0 framework + C# + XNA ) It would justify spending some more time on learning all the ins-and-outs rather than 'just' what I need, and I'd love to see some MS Training Kits on XNA... If there is, can we expect to see a beta around the holidays or is this something for on the long term  I'm sure there will be a demand for such a cert from students, professi ...Show All

• SQL Server Problems Creating Report

  Hi, I have only recently started playing around with Reporting Services (2005), and I am having some problems creating a basic report. What I want to display is a table which shows product names in the first column, sales for a specific period this year in the second column, and sales for the same period last year in the third column. The 'specific period' is determined by specifying a start week and an end week which I have set up as parameters. I have managed to produce the first 2 column with no trouble. However, for the third column I need to subtract 52 weeks from the parameters and use them as new parameter in the third column. Can anyone offer any suggestions Dave Hi Adam, Aga ...Show All

• Software Development for Windows Vista "bindingRedirect" does not work, same error occurs

  Hello, I'm using the "bindingRedirect" element in my web.config to allow updates of my workflow DLL without recompiling the website. But I still receive the same error: Could not load file or assembly 'TestWorkflowLibrary, Version=1.0.0.0, Culture=neutral, PublicKeyToken=c417d4d39ba0d6b2' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) I built my website with version 1.0.0.0 of "TestWorkflowLibrary". After that I created a version 1.1.0.0 of "TestWorkflowLibrary" which I placed in the "bin" folder of my website. When accessing the website, the above error is shown. I read that it's poss ...Show All

• Visual C# Difference between - 'static public' and 'public static'

  Hi all, I have noticed code here and there that put the static keyword in front of the method accessor, like, 'static public' is there a difference between 'public static' or are they the same Tryst Actually, according to MSDN : Yeah, I read that too, before I posted ... Static is disqualified as a "access modifier" because when applied to a data member, it's modifying storage, not access --- However, when applied to a class or a method, it is modifying access, making it an access modifier in those cases ---- However (part II), it's still different from public/private/et al because they modify who can access the method, while static modifies how the method is accessed ...Show All

• Smart Device Development Idle functions

  Hello I wonder how to implement an idle function I searched the SDK but couldn't find any appropriate functions. I only found .net Application.Idle but since I don't use .net it's not for me. Could anyone please give me some pointers Many thanks, Martin Malek Thanks Avinash I'm not familiar with MFC. I'm currently in a native C++ Smartphone project and I'm not able to find any references to WM_IDLE in the SDK. Any way for me to use MFC with my Smartphone project Many thanks, Martin Malek ...Show All

• .NET Development Deploying a Web Service (VS 2005 Beta 2) Problem

  Hello, I am having the most difficult time trying to deploy a web service created with Visual Studio 2005, Beta 2.  I'm hoping that I'm just missing one small detail and that someone can point it out to me. I have stripped this down to the most basic "Hello World" web service.  In fact, all I did for this was create a new web site, ASP.NET web service and left everything as is.  Here are the steps to reproduce: 1) In Visual Studio 2005 beta 2, create a new web site, ASP.NET web service and leave everything as is.  The HelloWorld web method will work fine. 2) Compile the application/Build the website.  Right click on the service.asmx file in the Solution Explorer and select View in Browser.  Verify that ev ...Show All

• Windows Search Technologies WDS 3.0 Beta 2- Rebuilding index by itself and more

  Hey Guys, Brandon pointed this as the right place to post some concerns/issues with the WDS 3.0 beta 2 Few issues with WDS 3.0 beta 2: - When adding a new file extension to be indexed, WDS prompts to full rebuild of the index. This is a very bad behaviour especially, like me that has more than 100,000 indexable items. (anyway to avoid that ) - The WDS is rebuilding the index itself without any user intervention - The current pdf I-filter are not capable to index within the pfd files. - The configuration GUI interface still very rough, clearly need some refining. That's it for now. Thanks, Marcus   Thanks Paul. If you need I can send you a copy of the .xlsx files that are not being indexed. Plea ...Show All

• Windows Forms newbie: binded data for date and change the datetime format

  Elo... i have a column in dataset with format mm/dd/yyyy 12:00AM (hmm from wat i've read so far mayb this is US format). When i do this... DateTime date = Convert.ToDateTime(dataset.Tables["master_table"].Rows[CurrentRowIndex].ItemArray[15].ToString); xrBill_Date.Text = date.Day + "/" + date.Month + "/" + date.Year; The output is what i wanted ---> eg. 18/1/2007 but the prob is the date is repeated (eg. there are 5 bills...the date from the 1st bill is repeated from 1st bill to last bill) So..i do this... xrBill_Date.DataBindings.Add(new XRBinding("Text", dataset.Tables["master_table"], ColumnName_Master[15])); DateTime date = Convert.ToDateTime(xrBill_Date.ToString( ...Show All