Sayhan's Q&A profile

• SQL Server importing and exporting tables

  Hello Everybody, Not sure if this is the correct Forum, anyway lemme me know your views. I have SQL Server running in two remote machines (in different geographical locations). I need to import a database from one SQL Server installation to another installation. What is best possible solution: 1) Transfering the .mdf and .ldf file from one installation to another installation 2) Generating the records of all the tables in the database to a common file format CSV and then loading it in destination database. If this is ok then how to generate import and export data using CSV format 3) Any other options S ...Show All

• Smart Device Development How to Implement Cut, Copy & Paste Funcationality *** urgent

  Hello all I am using .NET Compact FW 2.0, and in my smartDevice application. I have 2 textboxes in my form, I implemented context menu i.e having cut, copy and paste options. my problem is how to implement cut copy paste funcationality using comapact framewrok 2.0, What are the classes are providing these functionality or any default windows is providing this. anybody anysounds, any solution. plz help me will be appriciated. regards GV Ramana Hi! There is Clipboard class. It can be used to copy data to clipboard and get data from clipboard. Copy is simple. Cut = Copy & Delete from source. Paste = ...Show All

• Smart Device Development Windows Mobile 5.0 with MSFP Emulator Images

  Hi, After installing VS2005, Virtual Machine, 5.0 SDK, I tried to install "Windows Mobile 5.0 with MSFP Emulator Images for Device Emulator 1.0" from this URL ( http://msdn.microsoft.com/mobility/downloads/Emulator/default.aspx ) but I don't see them in Emulator Manager in VS2005 Dev Ed (I see only the one from 5.0 SDK). FYI, after launching from the shortcut in Programs menu, I see it running in the "Others" category of the Emulator Manager Question : how to see the images from MSFP package listed in the Emulator manager TIA, They will show up in the manager only while they are running: launch the imag ...Show All

• SQL Server Modify SSIS package saved on server

  I have saved an SSIS pacakage on my sql server. I am able to see and run the package through Integrations services. My question is, is there a way to edit the package through Management studio Thanks Jim I really miss good ole DTS packages. The old days when you could write a process and edit it without running through a ton of unnecessary hoops. Microsoft is a tools provider. It is NOT Microsoft's place to say HOW we use the tools. Keeping a clear distinction between development and product is something that I am supposed to make decisions on without being told that I have to do it a certain way. Your response to & ...Show All

• .NET Development retreiving updated row in storedProc using "refresh data set" option

  I have generated the stored procedures for database using data adapter wizard.  I selected the "refresh data set" option in the advanced sql generation options screen. This puts a select statement at bottem of the update statment in the stored procedure. How do I call this stored procedure and get the returned row into a dataset   Could you show me the code for calling this sp since I usually use the .ExecuteNonQuery() on the command object which doesnt' generate a dataset Thanks Hi, Is it possible that a Stored Procedure to return a value directly Is it a User Defined Function (UDF) that you ...Show All

• Visual Studio Express Editions assetion faileed

  been using kazaa for long time, windows autamatically upgraded and now assertion failed, tried uninstalling both microsoft visuall c++ studio and kazaa, downloaded express version of c++ visuall studios and redownloaded kazaa. still get same assertion failed. program: c:\program files\kazaa\kazaa.exe, file: esctype.c, line 68, expression: (unsigned)(c+1)<= 256. completely lost in visuall c++ studio, pretty smart but construction worker not computer expert with a lil help i can prob figure it out please help i miss kazza well i tried finding all that assertion stuff but got lost, i tried debuggin kazaa in microsoft visual studios but ...Show All

• Software Development for Windows Vista Free MPEG-2 Encoder Filter

  Hi all, I want to create an application for converting wmv video to MPEG-2 movie using Direct Show anyone know where to find free MPEG-2 filter Thanks. It present as directshow filter and appears as "MPEG-2 Encoder by EP" you can use it as direct show filter in your application. ...Show All

• Visual Studio Tools for Office Creating a custom reference number in InfoPath from database fields

  I'm looking to create a custom reference number such as P06-200001 where 06 is the fiscal year based on the list box entry the user selects in My InfoPath form and 200001 is an auto-generated number that is a primary key from a sql table.  What is the easiest way to auto-create this number in InfoPath For InfoPath-related questions, please post your question on the InfoPath newsgroup. http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.infopath&lang=en&cr=US Thanks! Darryn Lavery VSTO Team ...Show All

• Visual C# Getting the user's location (country) in C#?

  How can I find the user's (client computer's) location (country) in a C# Windows Application I want to get their country and filter the items in a combobox to the determined country as default. I have the comboboxes set up corretly in Visual C# Beta 1 are getting the cities from my database. Basically the first combobox is full of Countries and the second is full of cities (filtered for the selected country). Best Regards, Dean Krause   Dean Krause wrote: Thanks a lot for the help, works great Where could I find a list of all the possible returns (e.g. Australia.....). Dean,     ...Show All

• SQL Server how can i sort my fieldnames alphabetically

  I want to use a "select into" command to sort the fields alphabetically into a new table. any help pls > The columns can be returned in *any* order Interesting.  Is the same true for TVF and VIEW 'select *' has limited usage for me, since I almost always have some design-time commitment to structure. For ad-hoc, I find it informative (even if someone put in 'open table' in the gui), but order of columns does not matter. BTW: To me this is an exercise. I see no use for this. My code (which I agree is worthless for any *practical* purpose) is no more than a way to learn myself about cursors. BTW2: Congratulation ...Show All

• SQL Server Can't play files: Video Series: SQL Server 2005 Express Edition for Beginners

  I cannot play any of these video files in RealPlayer or in Windows Media Player. Any suggestions Anyone else having this problem Thanks, Brian Video Series: SQL Server 2005 Express Edition for Beginners C00D1199: Cannot play the file Could you give me a pointer to where you got this file Regards, Mike Wachal SQL Express team ---- Please mark your thread as Answered when you get your solution. ...Show All

• Visual Studio Express Editions FORM inside height

  How do you retrieve the inside height of a form so that it takes into account of the form bar Mark Hi, Do you mean to get the location of the client (inside where you place your controls) area If so try use the Form.ClientRectangle property to get the client size. If you want to put into consideration the titlebar then use Form.Bounds property. cheers, Paul June A. Domag ...Show All

• Visual C# Installation - keeps asking for vcssetup.msi when I run Excel

  I installed C# Beta 2 from the web. It went fine. I am following some Bob Tabar lessons and all well and good. However when I run Excel I get a dialog box that pops up entitled Visual C# 2005 Express Edition Beta 2 - English The feature you are trying to use is on a network resource that is unavailable Click OK to try again, or enter an alternate path to a folder containing the isntallation package 'vcssetup.msi in the box below Use Source C:\Documents and Settings\myusername\Local Settings\Temp\SIT34737.tmp\ Now, I could not find this, and so what I did was to run installation again - selecting repair. No luck. Then I tried downloading ...Show All

• Visual Studio Express Editions Newb Question: Opening Forms inside main form

  I'm completely new to programming, my knowledge only goes as far as html, css and light php so I'm way in over my head. :) I've been through the tutorials but all the teach is how to pop open a form in a new window. I need it to display as though it was seamless. I've created Form1 and I want to use that as the main design of everything. What I need to do is open up all other forms created inside of Form1. For instance, if someone clicks on the button Add New Customer, it opens up ( inside the main window to the right) the New Customer Input box to start them on the process of adding information to the db. If they click "Pay on Account ...Show All

• Visual Basic Photo Matching Database

  User selects a picture and querys the database for a match. How do I write the Code for this SELECT id, image, description FROM pictures [database] WHERE image EQUALS picturebox1.image I am concerned that the "image" format stored in the db will not match  picturebox1.image and that I probably will have to convert picturebox1 into a binary array to match the format already in the database.  Furthermore, I might have to compare byte for byte for both image.  This would be too slow. I need the best (speed) way to match an picturebox with a stored image in the database.  Thanks. ...Show All