k_Prasad's Q&A profile

• SQL Server what are the different ways of comparing Sql Server databases

  Hi can anybody tell how to compare two databases on sql server thank u vizai That depends on what you want to compare: schema / data / metadata. There are tools for comparing SQL Server database which might fit your need (if we would know more in detail what you need), one of them is the Data Dude which is called Visual Studio for Database professionals. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Windows Forms DataGrid and DataGridView issue?

  I am trying to use either a DataGrid or a DataGridView to list records that could later be edited through the click even of a row. My problem is this: while I am developing, I have to basically re-create the control by editing the designer generated code if changes are made to the control after compiling the app. Is there a way to get around this, or am I doing something wrong I understand that, and even as we speak, I have made some changes in the properties window, and when I compiled the app again, I got a an error that tesst me that the datadrig control does not exist.  However, when i look at the designer code, the Datagrid is there as a private variable, and is not available to the UI th ...Show All

• Visual C# Combobox

  Hi What i would like to know is the following. With a combo box by default you would be able to type in the box. I do not want the user to be able to type. They must be only able to select from the drop down. The selected value is highlighted in a dark blue. Is it possible to change it to another colour. Thanks in advance Louis, Sorry, my bad. The DrawItemState is a Flag enumeration, so you need to use a bitwise comparison for the Selected test: if ((e.State & DrawItemState.Selected) == DrawItemState.Selected) That should work now. One other thing: you need to wrap the whole thing in an "if (e.Index > -1)" test, otherwise you'll get an OutOfRangeException. ...Show All

• SQL Server Delete Snapshot Replication

  When I try to drop the publication in this order: exec sp_dropsubscription @publication = @publicName , @subscriber = @servName , @article = N 'all' exec sp_droppublication @publication = @publicName I am getting the following error after dropping the publication Msg 16943, Level 16, State 4, Procedure sp_MSrepl_changesubstatus, Line 1271 Could not complete cursor operation because the table schema changed after the cursor was declared. Msg 16943, Level 16, State 4, Procedure sp_MSrepl_changesubstatus, Line 1271 Could not complete cursor operation because the table schema changed after the cursor was declared. Could anyone give me a suggestion about how to avoid this error Thanks! ...Show All

• Visual Studio Express Editions Porting C functions included with 'ioctl.h' header to VC 2005 Express

  I recently found an old C console program that was originally Unix-based that I wanted to play with using VC++ 2005 Express.  the program is actually a game, but being so old, I thought it would be easier to learn something by playing around with it to try to figure out what is going on behind the scenes. However, the source code calls for a header file named 'ioctl.h' to be included, which does not appear to be part of the available header files in VC++ Express.  Nor does the latest PSDK contain such a file.  I vaguely remember reading that there is a substitute header file along with it's functions that Microsoft uses that do the same thing, but they are called by different names. The ...Show All

• Visual C# DirectX to Bitmap

  I am currently generating an image in DirectX using things such as Line.Draw() etc. and I need to get the image out as a bitmap. I Have managed to accomplish it using SurfaceLoader .SaveToStream( ImageFileFormat .Bmp, _surface0) ; however, this is too slow, I need something I can do in real time. Does any one have any suggestions for another way to get the image from a DirecX surface to a bitmap ...Show All

• SQL Server Not Able to create database in SQL CE

  Hi all, i am developing a project in Visual Studio 2005, which requires SQL CE database, i have installed SQL CE on my PC and trying to create one database <anyname>.sdf, but at the time of copilation the following errors are coming: " error CS0012: The type 'System.Data.Common.DbConnection' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' ". can anybody help me. Thanks in advance Amit Hi, I think you are missing some references like: 1. System.Data.SqlClient & 2. System.Data.SqlServerCe Regards Amit ...Show All

• Visual Studio Express Editions Hide console window launched by application

  Hi all, I need to make an application that will launch a console application with different user account and hide that console windows. So the code is: Process itFPS = new Process(); itFPS.StartInfo.FileName = "snetcfg.exe" ; itFPS.StartInfo.Arguments = " -l \"" + libPath + "netserv.inf\" -c s -i MS_Server" ; itFPS.StartInfo.WorkingDirectory = libPath; itFPS.StartInfo.UserName = uid; itFPS.StartInfo.Password = spass; itFPS.StartInfo.UseShellExecute = false ; itFPS.StartInfo.WindowStyle = ProcessWindowStyle.Hidden; itFPS.StartInfo.CreateNoWindow = true ; itFPS.Start(); But with "UseShellExecute" set to false and username, password specified, neither "StartIn ...Show All

• Visual Studio Tools for Office Word Combining Several Documents into a single Doc

  I have created the following sub procedure, which takes all the documents in a directory and combine them into a new directory. The problem is I put a page break after inserting each document so I am ended up having a blank last page. Is there a way to delete last page Private Sub CombineDocument() WordApp = New Word.Application WordDoc = New Word.Document Try WordApp.Visible = True WordDoc = WordApp.Documents.Add() For Each foundFile As String In My.Computer.FileSystem.GetFiles _ ("c:\test\", FileIO.SearchOption.SearchTopLevelOnly) With WordApp.Selection .InsertFile(foundFile) .InsertParagraphAfter() .InsertBreak(Word.WdBreakType.wdPageBrea ...Show All

• Visual C# cannot find table 0

  Hi, I have had a problem two days and still no solution. I have a web method within a web service that returns a DataSet. When I test it by hitting F5 everything goes well and my DataSet contains the dat. but if I browes to the Web Service the dataset is empty it does not return anything. and if i call it from another application it gereates following: Cannot find Table 0 .... here is my Web Method: [ WebMethod ] public DataSet GetMyContactsForSmartTag() { Guid MySiteGuid = new Guid("8FADE524-C5AF-4AC5-A5B4-181A4E8077D2"); SPSite MySite = new SPSite(MySiteGuid); SPWeb MyWebSite = MySite.OpenWeb(); SPListItemCollection MyContactsItems = MyWebSite.Lists["MyContacts"].Items; DataTable DT = new DataTable("MyDT"); DT ...Show All

• Visual Basic name "SqlHelper" is not declared

  Hi, all, I need your help on upgrading my DAAB from 1.1 to 2.0. (Or do I need to upgrade ) I have converted my win app from vs2003 with Data Access Application Block 1.1 to vs2005. I got multiple instances of this error on build. I have tried following 3 approaches, but they all failed. 1) reset ref to DAAB 1.1 On my vs03, under primary proj, I had a reference node, and I had added the DAAB project as a ref there. In vs05, I tried to add ref. (Right click on proj), but it wouldn't allow me to add DAAB, saying it could cause circular dependency SQLHelper is declared as public sealed class SqlHelper in its own project. 2) use a converted DAAB1.1 After I installed vs2005 and converted the proj, the DAAB became "u ...Show All

• Visual Studio Team System FXCOP XML is not getting generated properly

  Hi all I am facing an issue with fxcop, whenever i will try to generate a XML with XSL i am getting an unformatted xml getting opened after all. i have pasted the same here. Kindly let me know what is going wrong... < xml version="1.0" encoding="utf-8" ><html xmlns=" http://www.w3.org/TR/xhtml1/strict"><head><title>Analysis Report</title></head><style> #Title {font-family: Verdana; font-size: 14pt; color: black; font-weight: bold} .ColumnHeader {font-family: Verdana; font-size: 8pt; background-color:white; color: black} .CriticalError {font-family: Verdana; font-size: 8pt; color: darkred; font-weight: bold; vertical-align: middle; } .Error ...Show All

• SQL Server Problems with Linked Server to ORACLE (on SQL 2005 64bit)

  Hi all I have a big problem with creating a linked server to ORACLE database! - I have installed ORACLE Client 10g on my server (Windows Server 2003 64 bit) - With ORACLE Tools I am able to connect to the ORACLE Server - When I try to connect in SQL Server I get the following error: Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "MISPROD.WORLD". I have tried I guess all combinations of getting data out of ORACLE ... :-( For example: - SELECT * FROM OPENQUERY ( [MISPROD.WORLD] , 'SELECT * from ORACLE_TABLE ' ) - SELECT * FROM [MISPROD.WORLD] ... ORACLE_TABLE I allways get the same error and I dont know what to do ... Would by very very happy for any comment. ...Show All

• Visual Studio Tools for Office Menu Bar - Horizontal Divide

  Hey, should be a fairly easy solution, and its not a life saver, but i've got a customer menu bar in outlook, and i just want to divide buttons, like buttons are divided in other menu bars, such as file and edit. Just can't seem to find it! Thanks ...Show All

• Community Chat My creation: Galaxy war (2D game using DirectX)

  Hello there. This is my game: Screens: Selecting a map, lets start on Easy Shooting stars in game, fun multiply backgrounds Lets see my score Download game: Galaxy war Official website (for more information) The game saves progress as you advance (the save is encrypted so forget cheating ;) There are multiply backgrounds and multiply ships. The design of the game is so good that the user can create ships himself. It takes about 2 second to add another level on the map, the information is kept in an array inside the program. I have created a version containing songs in the background (the ending background music was set to Back to the Future theme song) but first: It was a .wav file over 30 mb and I still haven't learned how to play m ...Show All