Aneel's Q&A profile

• SQL Server How can I convert an sql2005 database to Access

  Hi, I am running an sql database that uses tables and views. I need to convert this to an access database for portability. I've tried using the "export data" wizard which created the tables and copies over the data, but the views are copied over as tables as well. I don't know access very well but I'm assuming that I need the sql views converted to access queries. ...Show All

• Visual Basic problem of controls array in Visual Basic 2005

  Hi: I wrote a project in vb6.   That project contains controls array and I want to upgrade this project to vb2005 but I have some problems. In vb6:       I have array of checkbox When the user check the checkbox   It's index = I as integer   then Create 3 elements in 3 arrays of combobox All this elements have the same index     When I want to determine any combobox by the index of checkbox I will write code like this:       For i = 0 To Check1.UBound         If Check1(i).Value = vbChecked Then              &nb ...Show All

• Windows Forms dataGridView Formatting Question

  Dear All,  I want that myDataGridView be that like http://srdo.org/question/gridNumbers.JPG Thanks  (so i completed 100 posts) This should center the line numbers Imports System.Data.SqlClient Public Class Form1 Dim dt As New DataTable Private Sub Form1_Load( ByVal sender As System. Object , ByVal e As System.EventArgs) Handles MyBase .Load Dim pt As New Point Dim strConn As String = _ "Server = .\sqlexpress;Database = NorthWind; Integrated Security = SSPI;" Dim conn As New SqlConnection(strConn) Dim da As New SqlDataAdapter(" Select * from products", conn) da.Fill(dt) DataGridView1.DataSource = dt End Sub Private Sub DataGridVie ...Show All

• Windows Live Developer Forums BOTs not receiving status events.. (or why WebIM isn't working at this moment)

  So, finally LiveBot has been added to the RobotInvaders gallery. But what happened Suddenly the WebIM feature isn’t working properly anymore, even though it worked fine during development / beta. Registering for WebIM makes LiveBot monitor your messenger-status. Then you can show your status on a web page, and allow visitors to chat with you directly from your website/blog/space when you’re online (without them needing to log in somewhere). In my opinion this is one of the most exciting features of LiveBot, so why doesn’t it work at this moment After a successful submission of a BOT, Microsoft registers the BOT’s IM address as a ‘provisioned bot’. This makes the Messenger-servers treat your bot a little bit differently than normal Mess ...Show All

• Visual C# creating arrays

  i need to create an array of objects to act as a simple database. So the task is to: Create an array of Student objects called Students that can store: Name, Course and Email of up to 50 students. i am having a little bit of trouble though with the actual array. this is what I have done so far: public class student { student[] students = new student[50]; //an array with 50 elements { new string name[50]; new string email[50]; new string course[50]; } } the details that the user inputs will be via 2 text box and one combo box. I think my syntax is badly wrong. could anyone point me in the right direction, thanks. I am also using MS visual studio .net 2003 ! i think ...Show All

• SQL Server partitioned views Explain Plan

  Hello I created a partitioned view on my database db1 and It comes from the UNION ALL of 2 tables (I split 1 very big table in 2 smaller tables... Horizontal partition!!) that are on the same db1. When I query them I receive in the EXECUTION PLAN an Item called CONCATENATION of both input tables, This seems to be more expensive than using only one big table so partitioning the big one gets none sense.. I would like to know if this is normal and If I'm doing well with partitioning. Please see the script below: CREATE TABLE [dbo].[TREP_NOVEDADES_2006] ( [NMSEC_NOVEDAD] [numeric](12, 0) NOT NULL , [CDCONCEPTO] [varchar] (12) NOT NULL , [CDTIPO_VALOR] [char] (1), [CDPRECIO] [varchar] (12), [CDTIP_HECT_DTO_PAG] [varchar] (2), [FEG ...Show All

• Visual Studio 2008 (Pre-release) Custom extentions

  Here the code // XAML of MyWindow.xaml //1//<Window> //2//<Menu> //3//<MenuItem Command="{x:Static custom:MyWindow.SomeRoutedCommand}"> //4//</Menu> //5//<Window.CommandBindings> //6//<CommandBinding Command="{x:Static custom:MyWindow.SomeRoutedCommand}" Executed="SomeCommandExecutedHandler" /> //7//</Window.CommandBindings> //CS of MyWindow.xaml.cs public partial class MyWindow { public static RoutedCommand SomeRoutedCommand= new RoutedCommand(); private void SomeCommandExecutedHandler(Object sender, ExecutedRoutedEventArgs e) {} All this stuff returns following errors: Error 1 Unknown build error, 'Key cannot be null. Parameter name: key Line 3 Position 96.' Error ...Show All

• Visual Studio Team System Workspace is already mapped problem

  I just installed TFS (beta 2) and I get the following error message when opening a solution from source control using VS 2005 beta 2 : The path 'd:\temp\xxx' is already mapped in workspace PCMRE\Disney\JMP. PCMRE is the workstation having this problem, Disney is the domain where TFS is installed and JMP is my own user account. The guy using this workstation has the MRE account. Due to security misconfigurations on the TFS server (my fault), MRE could not use TFS, so we used my user account on this machine to test TFS. Now that the TFS server is configured well, MRE can use TFS but something's wrong with the workspace configuration. Getting the solution on a folder on the c: drive is OK, but anywhere on the d; drive causes this error. Go ...Show All

• Visual C# Using File.Copy() Correctly

  I have been trying to use File.Copy to copy a file from a z drive that I made to a location in my C drive. The problem is I will get the error of "Could not find a part of the path 'z:\New Text Document.txt'" and I do not know what that means. This is the line I have been using, but let me know if I am wrong: File .Copy("z:\New Text Document.txt", "C:\AAAWorkspace\FTPProgramWinApp2\bin\Debug\New Text Document.txt"); I am 100% sure that both of these places (the z and c drives) exist at the time the code is executed. If it matters, I made the z drive via: sdps = System.Diagnostics. Process .Start( "net" , @"use z: \\" + downloadLocation + " " + pswd + @" /user:" ...Show All

• Visual C++ How do I set nCmdShow parameter in WinMain()?

  Hello, I am new to windows programming and have a question. How can I set the parameter for the "int nCmdShow" argument in the WinMain function. The function definition on MSDN gives the list of possible parameters but I cant figure the syntax to put them in the function Like how can I use SW_MAXIMIZE as an argument in place of int nCmdShow to specify I want the window to show maximized initially This is the test program I am trying to work with: #define WIN32_LEAN_AND_MEAN #include <windows.h> #include <windowsx.h> int WINAPI WinMain(HINSTANCE hinstance, HINSTANCE hprevinstance, LPSTR lpcmdline, int nCmdShow) { MessageBox(NULL, L"What's up world!", L"My First Windows Program", MB_O ...Show All

• Internet Explorer Development Sessions in IE7

  Hi I am pulling my hair out over this problem, and am getting to the stage where I'm gonna scream. All these pages work perfectly on IE6, Firefox, Netscape etc, but I have come across a problem when testing them on IE7. Here's the problem: I have a web based system where a user logs into the site. Upon signing in, a number of PHP $_SESSION variables get populated with data, so that the subsequent pages know that he is allowed to visit them, and who he is. One of these variables is: $_SESSION['username'] At the top of all subsequent pages, the php script reads: < php session_start(); if (!isset($_SESSION['username'])) { header("Location:unauthorised.php"); exit; } > This effectively checks to see if the user is lo ...Show All

• Windows Forms How proctect my application with a key like Windows xp

  How i can protect my application with a key like in Windows xp .... with a serial Securing your application is always difficult. 1st problem, how do you verify that the key the user enters is correct. 2nd problem, how do you make sure this key is only used once by one user and not given to their mates to use on a pirated copy of your app You might want to consider using a website to store the valid keys that then issue a machine specific activation key. When the app is uninstalled, add a custom action to unregister this key so it can be transfered to another user. That way when a user buys a copy (say off the web), you can email them their product key (which you can generate yourself) and the ...Show All

• SQL Server "Hang" when deploying SSAS solution?

  I've noticed that BI Studio seems to 'hang' when I do a Build -> Deploy Solution. The output window will just say "Sending deployment script to the server" and the Deployment Progress window will just churn, with no commands listed. It's been running for nearly ~ 1 hr without feedback - how can I tell if AS is working or not CPU on the AS instance is idle. The one workaround I've noticed is to open the database directly in BI Studio, and make the changes there, but this is obviously less than ideal for multiple reasons. Ok. I created a fresh, new, import from 9.0 project, and made my changes there. Now when I tried to deploy it actually looks like it's doing something (i.e. there's activity ...Show All

• Visual Studio Express Editions Help with code plz, copy paste sendinput coding

  I finally was able to get code I thought would work. I use dragon naturally speaking and in some nonselect and say text area (that means cant use voice dictation there) I wanted to open a dictationbox dictate into it, then transfer the text from it into the nonselect and say fields. After I made the app, if i manually copy and past ctrl a or ctrl c or ctrl v that works fine. its my auto code thats amiss. Am trying to avoid sendkeys aws vista is coming and i hear wont support them, plus they have issues with use. I get an error when run it that says to large or to small for Int16 no idea what that means. here is the code. Imports System.Runtime.InteropServices Public Class Form1 Private Sub DoKeyBoar ...Show All

• Visual C++ Is Vista Manifest required for non-admin apps?

  Hi, My VC++ 2005 application does NOT require Admin privileges – default user rights are ok. Can you please tell me, do I need to embed Vista Manifest anyway to make sure that my program will work under the Windows Vista and “Unidentified program wants to access your computer” warnings will not appear If yes, can you please give me the example (or link to the sample manifest) that I need to add to my program. And tell me please, is it possible to add this manifest with VStudio’s Manifest Tool and do not use any external programs Thank you very much!!! You should embed a Vista manifest to avoid any unwanted/unneeded file or registry virtualization. Just set the reque ...Show All