Ashish Kaila's Q&A profile

• SQL Server Comparing differences in database structure between databases

  I am trying to find a way to easily compare the difference in table/column structure between two SQL server databases. I am doing this since I need to document the foreign key relationships between a database schema that is currently under development. The foreign keys are not defined as constraints in the database, but are controlled through the application. The current naming conventions make it easy to see what the relationships are ( ...Show All

• SQL Server error creating named calculation

  I'm new to MS DM and am using the book "Data Mining with SQL Server 2005" by Wiley. On page 95 I try to follow the procedure for creating a named calculation, but I get this error: IErrorInfo.GetDescription failed with E_FAIL(0x80004005). Any ideas what's wrong Jamie, Thanks for the help. I'm using the Access MovieClick DB that I downloaded from the Wiley web site. Also, I can create other named calculations just fine, such as ad ...Show All

• Visual Studio Express Editions Problem with Excel since loading VS express

  I have a spreadsheet that I have been using for over a year that has a lot of coding behind it using VB. Since I loaded Visual Studio Express the spread sheet throws errors in funny places. For instance now I get an error when I try to add a date to the spread sheet using the Calendar control. The line that throws the error follows: Me.Calendar1.Value = Date (It doesnt like Date) another line that errors is a simple line of code vRow ...Show All

• Windows Forms MultiColumn ComboBox Column in datagridview

  Hi all I have to show a column in the datagrid view which is having a combobox with the multiple columns So how should i start Make a user control of multicolumn combo box ]then add  that in tha column of the datgridview How to craete that control (MultiCOlumn COmbo)   Any source ,link,help, direction is highly appreciated   Thanks a lot I don't know of any sample code for this. I guess the first ...Show All

• SQL Server regarding datamigration using ssis packages

  hai, Currently i am working with data migration using SSIS packages. i would like to load the data from the flat file to database(siebel). But i need three extra columns which are not there in flat file to load into the database. the columns are as follows. 1.ROW_BATCH---fixed value(eg:100) 2.ROW_ID----(should be unique just like a sequence) 3.ROW_STAT---fixed value(string) The flatfile columns along with the above specif ...Show All

• Visual C++ Help Needed : Error using a DLL after compiling with /CLR

  I'm trying to take an old(er) C Win32 app and move towards managed C++ (C++/CLI). I have successfully made the modifications to the code to bring it up to C++ specs. I will compile/link and run just fine as C++. I can compile it as C++ code, but when I make the move to managed (via the /CLR) compiler switch I have *one* problem. The program uses many dll's.. some written in house some 3rd party. All the inhouse and most of the 3rd party dll's wo ...Show All

• Visual Studio Team System Backup you data with Team Foundation Server Beta 3

  Since the documentation looks to be outdated: What are the steps to take to backup all the data within TFS3. It should be a backup of all tables (including SharePoint Services and Reporting Serves data) from SQL Server and a backup of Windows SharePoint Services. Is that it Are the attachements now stored within the database Thanks, Neno That's the version control file cache, as Bill mentioned.  The version control caching proxy is bo ...Show All

• Visual Studio Recommendations & examples of setting-up a directory structure

  i need to setup a VSS environment consisting of: development, test, production and different versions 1.x, 2.x (C# development of Win/Web/Mobile apps) Are there any books, or recommendations / examples of good practices on doing this thanks Guy danadanny wrote: Hi Dimitris, Are there any similar documents that talk about Visual FoxPro 8.0 development Regards, Danny. I'm not familiar w ...Show All

• SQL Server Error{no row is was updated}

  hey expert out ther.. i have encounter this error ..and i dont know what is the wrong with it.. the error goes: No row was updated Error source: .net SQLClient Data provider Error Message:string or binary data would be trancated. plz help me to slove this prob. thanks in advance!!!!!!! Hi I guess you mean, that you see this error, when you put in data in tht sql management programm to the opended database ta ...Show All

• Visual C++ Function pointers and delegates

  I'm trying to build a managed wrapper in C++/CLI for an existing static library written in C. I have a class where a few callbacks are needed. In the static library you have a function called "set" which registers the callback. However I'm strugling with some managed vs. unmanaged type problems. Lets say you have a callback with the following prototype: void f1proc(char *szString, int nSomeOtherData); Since I want to use String ^ instead of char ...Show All

• Visual Basic Where put initialization code in 2005

  In VB 2003, when creating a winform, there was always a section that read like this: 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call In VB 2005 there is no such concept, so where do you put initialization code in VB 2005   WoodrowS wrote: In VB 2005 there is no such concept, so where do y ...Show All

• Visual Studio Express Editions Trying to send a mail via SMTP in VB 2005 - Authorization problem

  Hey guys, this is the first time a try to get help from a forum with alot of experts... But i can't handle the problem alone... I try to write a program which sends mails from the users computer but over my account to me... so to the same account.. sound weird i know.. First: The provide is using port 587 Seconde: I need to enter the auhorization, but i don't know how. Here is the code i'm using so far: Imports System.Web.Mail Public ...Show All

• Visual Studio SourceSafe setup fails, exits in an unusual way

  I'm trying to install Visual SourceSafe 2005 but the setup fails with: Runtime error! Program: D:\Setup.exe The application has requested the runtime to terminate in an unusual way. Please contact the application's support team for more information. There's a message in the event log that says: Faulting application setup.exe, version 8.0.50727.42, faulting module setup.exe version 8.0.50727.42, fault address 0x000170ad. Any ideas Thanks, John ...Show All

• Visual C++ circular reference in parent/child classes

  I have been trying to understand some code that another guy wrote, and though his code compiles and runs, it seems like it should never have compiled. He has 2 classes. One class is basically the parent, and it includes a pointer to the child it creates. As the child is being created, the parent passes the constructor a "this" pointer, so the child can later access variables in the parent. When I try to duplicate this logic, ...Show All

• Visual C# Saving/Loading a List<> to file.

  I’m in need of a good way to save load a generic List<> to a file, XML, txt or whatever. How should you do that in an easy way All tips are welcomed!! if u want in xml use [Serialize] like this i use Class using System; using System.Collections.Generic; using System.Text; using System.Xml.Serialization; using System.Xml; using System.IO; namespace AVUK.BusinessEntities { [ Se ...Show All