Binu Jeesman's Q&A profile

• SQL Server Integrating data from two Tables into one

  Hi all, In case I have two tables. In them there is data and I want to integrate all this data into one table. that is to say Table A and Table B has data (Both A and B are from the same database) I want to integrate all this data into Table c. How do i go about this Regards, Ronaldlee My god this is like pulling teeth!!!!! What transformation do you want to perform on TableA & TableB in order to get the data into tableC Do you want to do a JOIN, or perhaps a UNION What is the structure of TableC Which columns in TableA & TableB map to the columns in TableC (i.e. What is the source-to-target mapping) Do tableA and TableB join together If so, how I don't wish to appear rude b ...Show All

• Smart Device Development How to get vga device emulation

  none of the shortcuts emulate a hidpi device, i.e. vga. i created my own shortcut using the command line args, set video to 480x640x16 and it gave a vga screen, but it was not 'hidpi', it was the same as running sevga on a true vga device, i.e. not what the user normally sees. anyone got proper emulation of a wm2003se vga device With Visual Studio 2005 Beta 2, you have an entry called "Pocket PC 2003 SE VGA Emulator".  This will load a Hi DPI 2003 SE VGA image and will behave exactly the same way as a VGA device.  There is a similar entry for the Smartphone emulator. ...Show All

• Visual Studio Express Editions How could I turn, String __gc* ,to BSTR in managed C++?

  Dear everyone, I am writing a managed C++ program. I get string from a text file. The StreamReader return String __gc* data type. I need to convert the "String __gc*" to BSTR before I could put into the function "hr = pDet->put_Filename". How could I turn "String __gc*" to BSTR Thank you. CComPtr<IMediaDet> pDet; CoInitialize(NULL); hr = CoCreateInstance( CLSID_MediaDet, NULL, CLSCTX_INPROC_SERVER, IID_IMediaDet, (void**) &pDet ); IntPtr ptr; String __gc* str; if(System::IO::File::Exists("directory.txt")){ printf("The file exist\n"); System::IO::StreamReader* strd = new System::IO::StreamReader("directory.txt"); str = strd->ReadLine(); //this->dir ...Show All

• Visual Studio MPF GetFileNamespace method contains a bug

  Hi there, In MPF file <VSSDK>\2006.09\VisualStudioIntegration\Common\Source\CSharp\Project\TokenProcessor.cs there is a line of code (313) : string projectPath = Path .GetDirectoryName(node.ProjectFile); This line returns an empty string. I think there shoud be a following line instead: string projectPath = node.ProjectFolder; From my point of view that is a bug. Isn't it Hi Ole, Thank you for the tip – I‘ve found this problem too. I have implemented following logic of AddFileFromTemplate method (see below). As you can see, I use my own private GetNamespace method because of GetFileNamespace one of TokenProcessor class does absoutelly strange things. J Also I recreate a new instance every tim ...Show All

• Visual Studio Express Editions Currency Textbox Like In Visual Foxpro

  I Want a Currency Text Box Line In Visual Foxpro That only Accept Numeric Values in Visual Foxpro Numeric Textbox Has Fixed 0.00 how do like this in vb.net 2005 if you want to accept numeric values, on the keypress event of the textbox, check the values using a Char.IsNumber/Char.IsDigit method. example: //keypress event: if Char.IsNumber(e.KeyChar) = false then e.Handled = true next To have a fixed format, you would have to do this yourself, perhaps again in the keypress or textchanged event of the textbox. I hope this helps! ...Show All

• Visual C# How to use GC.Collection() and Dispose()

  In my application, it use 10.000 files. And every files have 5000 lines. My application openning the shown folder and scaning the files. Well then, it is reading all lines and write them to database. It takes 30-40 hours. Time is not our problem. The problem is "Memory". I am using "GC.Collection(); dispose();" lines ending all methods. But memory useage increasing. I can not stop it. Someone could give me an idea using Something; namespace SomeName; { public partial class Report : Form // Starting the program { string connectionString = "Driver={PostgreSQL Unicode};database=dbname;server=localhost;port=5432;uid=username;PWD=password" ; OdbcCo ...Show All

• Visual Studio Team System List of Check-in Policies enforced by administrator

  I need to find out programatically the list of check-in policies (policy name) enforced by administrator. Is there an API to do this Thanks, Srikanth You can do something like the following: TeamFoundationServer tfs = TeamFoundationServerFactory .GetServer(url); VersionControlServer vcServer = ( VersionControlServer )tfs.GetService( typeof ( VersionControlServer )); PolicyEnvelope [] policies = m_vcServer.GetCheckinPoliciesForServerPaths(paths); For more questions about version control you can contact the version control forum here: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=478&SiteID=1 mauli ...Show All

• Visual Studio 2008 (Pre-release) InvalidOperationException as FaultException - channel in faulted state

  Hi, my WCF service has some methods throwing different exceptions. These exceptions are catched and thrown as FaultExceptions (so that the channel won't be faulted - I thought). But in some cases the channel will be faulted. Here's an example of my implementation: -> service interface [ServiceContract(CallbackContract = typeof(IClientService))] public interface IWorkflowService { [OperationContract] [FaultContract(typeof(ArgumentNullException))] [FaultContract(typeof(InvalidOperationException))] List<string> GetPossibleTransitions(Guid instanceId); } -> service implementation public List<string> GetPossibleTransitions(Guid instanceId) { try { StateMachineWorkflowInstance instance = new ...Show All

• Windows Forms Concurrency violation

  hi, i am new in visual studio and i try to make a program but i have a problem: i use an access database and i have 2 tabels in relation and when i try to delete a row from one i receive msg " Concurrency violation: the DeleteCommand affected 0 of the expected 1 records." this is my code Private Sub BindingNavigatorDeleteItem_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BindingNavigatorDeleteItem.Click Dim gol = Me .DataGridView1.RowCount() If gol = 0 Then Exit Sub End If dim msj msj=MsgBox( " Soll es wirchlich geloscht werden " , MsgBoxStyle.OkCancel, "A C H T U N G !" ) If msj <> vbOK Then Exit Sub ...Show All

• Visual Studio Team System Test Manager dropping and duplicating tests from the list

  After having some serious problems with Test Manager spontaneously dropping and adding test (for example, tests will suddently show a "Test [TestName] does not exist in the test list" I tried to find anyone else that had a similar problem. After some searching, I came across http://kjellsj.blogspot.com/2006/04/vsmdi-file-weak-spot-of-vsts-test.html which describes the problem we're having to a tee: In particular, Kjell-Sverre's describes the problem that they [...] from time to time get "The test 'TestName' does not exist in the test list. It may have been moved, renamed or deleted". Yesterday, the 'Test Manager' showed all tests duplicated in the test lists. Today, another developer saw just some chinese characters when openin ...Show All

• SQL Server SSIS Error message

  I have an input text file on my local box and the SSIS package runs there. I am reading the first 24 characters of each row and populating a single-column table on a remote sql 2005 server. Her'es the werror message I get:   "Could not bulk load because SSIS file mapping object 'Global\DTSQLIMPORT              ' could not be opened. Operating system error code 2(The system cannot find the file specified.). Make sure you are accessing a local server via Windows security.". I certainly do have Windows access to the remove server as well as the local server. (and I test out all my SSIS connections before using them). Can anyone clarify the me ...Show All

• SQL Server Accelerate Sql Express?

  Hi, we're planning to migrate an existing dataset cache mechanism to Sql Server Express. The dataset isn't really able to handle and search one million recordsets any more :-) Once a day the Cache Sql Database wil be filled with fresh data. In comparison with the dataset takes up to fourty times longer to build the cache on the same machine!! Ok, I expected that i will take longer than creating the objects in a database with all its "overhead" like atomic transactions etc. But not so much. The current throughput on SQL Server ist nearly 400 inserted records per second in the same table. The dataset stores up to 17.000 of the same data. I'm wondering about the the following fact. Allthough I'm testing the Mass-Inserts ...Show All

• SQL Server Sharing remotely

  Can you use SQL Express remotely instead of locally. I have been told that I might be able to use SQL Express as my network server for sharing files. Is this possible, or do I need a different version of SQL to do this I have been reading the VBE forums and from what I gathered was that SQL Express is only for a local table only, is this true If not, what is the work around, and how do I go to another pc to find out if it is sharable I would hate to get several months in my app design and learn that I was headed in the wrong direction. Thanks David Hi David, You can use SQL Express as a remote server. You will need to configure it to accept remote connection and ensure that the firewa ...Show All

• Visual Studio Express Editions VC++2005 Express Edition problem

  I have a serious issue with my registered and perfectly legitimate copy of Visual C++ 2005 Express Edition (I got it from MSDN). When I try to build a project, I find the build always fails because the manifest cannot be embedded. Is this a bug Can this be resolved I want to know how I can enter to take the microsoft exams for beginners in Visual C++. How to get learning kit study manuals, classroom based learning if possible or e learning, as well as information on exam centers in London UK. Please note that I have never studied C, C++ or Visual C++. I can however programme in Java and now want to learn Visual C++ ...Show All

• .NET Development Reflection

  Hi, What is Reflection What is use and where i can use it Any example pls Thanks Seshu Reflection is a fature of .Net through which you can find information about assemblies. Get types contained in the assembly, Get Meta data embedded in that assembly etc. Reflection is achieved through a huge number classes present in System.Reflection namespace for different purposes. Reflection is also used to refrence and use assembly programmatically at run time. You can load an assembly at run time using Assembly.Load and then we can get Attributes of loaded assembly, access meta data, List all classes in the assembly then methods in each assembly etc. Its a huge huge topic to cover here. It was just a definition of Reflection and yo ...Show All