SGirase's Q&A profile

• SQL Server How to creat a first DB?

  Hello all, I've Installed VS2005 and MSSQL express with it. I used to work with mssql 2003 enterprise edition where it had "Enterprise Manager" from which I could create and modify my Databases. How do I creat a new database with MSSQL express I've tried to do this via visual studio 2005 "server explorer". I"m entering the "Create new SQL Server Database" dialog, I select my server's name and my new database name and I recive an error message which says "An error has occurred while estabilishing a connection to the server" and it also says that "When connecting to SQL server 2005, this failure may be caused by the fact that under the defult settings SQL sever does not allow rem ...Show All

• Windows Forms Formatting - Alingment Of Data In Cell Of DataGrid

  Is there a way I can align text in a cell for a datagrid control In one column I have a number and I would like to center it. The default is a left justification. I know this can be done on the label and other controls. Below is part of the formatting code that I am using. Thanks Dim grdColStyle3 As New DataGridTextBoxColumn With grdColStyle3 .HeaderText = "Time" .MappingName = "TimeSpent" .Width = 50 .ReadOnly = True End With Dim grdColStyle3 As New DataGridTextBoxColumn With grdColStyle3 .HeaderText = "Time" .MappingName = "TimeSpent" .Width = 50 .ReadOnly = True .Alignment = Ho ...Show All

• Visual Basic SQL Error on my dataset row

  Hi, This is the first time I am running through a dataset the way I am doing it now and I have specific reasons for doing it this way. I am having a issue when I get to the last row of my dataset and was wondering if someone could help my and let me know what I am doing wrong. My error says there is no row after the last row, wich is true, but what do I need to do to correct that Here is my code: Dim ds As New DataSet() Dim rpos As Integer Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con As New SqlClient.SqlConnection con.ConnectionString = [properties goes here] con.Open() Try If con.State = 1 Then MsgBox("Con ...Show All

• Visual C++ Image Cursor

  Hi, I am not sure if i am posting in the right forum, kindly direct me to the correct one if i make a mistake. I am coding in C programming compiled in vs.net 2005. I wanna write a program such that it constantly detect the cursor position by using "GetCursorPos" function. If the cursor is moving upwards, it should display a "compass pointing to north" image. If the cursor is moving left, it should display "compass pointing to west" image and so on. . . I have search through the web and unable to find much examples in C. I managed to find a link http://www.codeproject.com/bitmap/ColorCursorFromBmp.asp which has some information in C++ instead, however, through the demo i realised the image cursor only ...Show All

• Software Development for Windows Vista Notification from a Custom Activity

  I plan to develop a custom activity which basically executes a long running task. During its execution, I also need to display the progress of its execution on the Client (say on a progress bar). How do I go abt this. How about an activity that looks like this public partial class LongRunningActivity : Activity { public LongRunningActivity() { InitializeComponent(); } protected override ActivityExecutionStatus Execute( ActivityExecutionContext executionContext) { for ( short i = 0; i < 10; i++) { short pct = ( short )(i * 10); base .RaiseEvent(ProgressChangedEvent, this , new StatusEventArgs (pct)); Thread .Sleep(10000); } ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Mousewheel weirdness.

  Okay, this doesn't make any sense to me and I'm not seeing any references to it online. When I use the mousewheel I get a sudden position jump, too. When I move the mouse position after, I get another jump followed by smooth movement. Movement without touching the wheel works just fine. It looks like the mousewheel change also changes the reported position of the cursor and keeps it changed until a new mouse movement. That didn't make sense to me, so I started a new XNA Game and made only the following changes. Results are inline. protected override void Update() { // The time since Update was called last float elapsed = ( float )ElapsedTime.TotalSeconds; // TODO: Add your game logic here UpdateMouse(); // ...Show All

• Visual Studio Team System Help! IDE Crashes on Schema Import

  Hello, I'm a brand new VSTS/DBP user...  When I try and create a new project and import an existing DB schema, the IDE crashes about 20 seconds into the process.  I should mention that the DB I'm importing is a very large Database, thousands of tables and thousands of procs.  When I ran the example import (Adventureworks), it worked fine.  I admit, I'm a Microsoft / Sql Server groupie, and I always try and update to the latest tools.  I'm currently on a customer engagement at a very large I.T. Consulting company and I'm trying to convince them to upgrade to Sql 2005 from Sql 2000, as well as trying to convince them to move to Visual Studio from Imceda SQL IDE Pro and TOAD for Sql Server.  So, basicall ...Show All

• Windows Forms Cannot install WSUS (Microsoft SQL Server 2000 Desktop Engine fails to install)

  Hi there, It seems that I cannot install WSUS, for some wierd reason the Microsoft SQL Server 2000 Desktop Engine fails to install: The log: === Verbose logging started: 08-02-2007 18:16:58 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: e:\fdb2914e58e02b2aac2130eb2466\WusSetup.exe === MSI (c) (C0:54) [18:16:58:265]: Resetting cached policy values MSI (c) (C0:54) [18:16:58:265]: Machine policy value 'Debug' is 0 MSI (c) (C0:54) [18:16:58:265]: ******* RunEngine: ******* Product: e:\fdb2914e58e02b2aac2130eb2466\WMSDE\SqlRun03.msi ******* Action: ******* CommandLine: ********** MSI (c) (C0:54) [18:16:58:265]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (C0:54) [18:16:58:265]: Gr ...Show All

• SQL Server Problem conecting to the same DB from two applications

  Hello, I'm new to VB and SQL server. I have a windows forms application and a Web application that need to connect to the same database (Named WebCenter). But when I try to connect to it from the Web app while running the windows forms app this error message apears: Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\WebCenter_Data.MDF". Operating system error 32: "32(The process has no access to the file because is being used by another process). Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\WebCenter_Log.LDF". Operating system error 32: "32(The process has no access to the file because is being used by another process. ...Show All

• Visual Studio Team System bind command

  I was hopefull when I saw the bind command but disappointed when I read it did not support vs2003. Does anyone know of any way to rebind a vs2003 solution (once you've ran the vssconverter and installed the MSSCCI provider) Trying to unbind and rebind in this case does not work. Thanks Could you have a look at this forum post http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1203739&SiteID=1 What does it mea that unbind and rebind doesn't work - what exactly are you doing What happens then Thanks ...Show All

• SQL Server SaveAs/Export

  Is there away with the reports to code to have them export into a excel template (a specific one) and have each report go into a different tab When I run the reports manually I can save to excel put not a pre-existing template. Each report has 3 to 12 stored procedures it needs to run so I am just not sure how to accomplish this task. Thanks in advance! Stokh I will give it a try and see if it works. I am a visual person, so no visual aid isnt helping me :( but I will figure it out. I will let you know if I get stuck. Thanks Geoff! Stokh ...Show All

• SQL Server How to show duplicates in reports

  I'm trying to create a report in Sql Server 2005 Reporting Services where it will display duplicates rows in the reports. I'm unable to find the property that enables this. I would need something like HideDuplicates = false, but that is not the way it is intended to be used. If HideDuplicates is left blank, it seems to still hide duplicate values if the preceding row matches. The report is a crosstab type, so we are using a Matrix for the report item. I'll illustrate with a simple example:  This is what we currently get: Catagory Class Detail Type 1 A Item 1 B Item 2 Item 3 Type 2 A Item 4 B Item 5   This is what we want: Cat ...Show All

• Visual C++ Open a Form from within another Form

  Please can someone help me. I'm using VC++ Express 2005 to develop a windows GUI style application and I'm having a bit of problem. I have a form (form1.h) which has a button in it. When a user clicks on a button I want to call up another window (form2.h) in the style of a pop-up box type thing in which to have more GUI items and features. What code do I need to put between the braces (see below) to run when the button is clicked in order to achieve this Or is there a better way of achieving what I want Any advice would be appreciated - thanks in advance. private : System::Void button4_Click(System::Object^ sender, System::EventArgs^ e) { } ...Show All

• Visual Studio Express Editions missing header files

  hello all.... the master of weird annoying problems is back.   ok heres my problem, wenever i try to compile a programm and include windows.h, i get an error saying that it cannot find windef.h can any body tell me wat happend to it and if i never had it to start out with is there a way i can download it or get it back   thanx, jt Ack, scratch that, read. I just noticed what you wrote. It seems as if you are trying to use the windows libraries and headers by copying the files from one place and putting them elsewhere. That wont work. You need to get the PlatformSDK and install that and then set the paths according to http://msdn.microsoft.com/vstudio/express/visualc/usingpsdk/default.aspx ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. how to set xbox 360 resolution?

  Hello guys! I'm deploying my game to xbox 360. The deploy is perfect, but my game aways presented on 800x600 screen. Graphics.PreferredBackBufferWidth value is 800 Graphics.PreferredBackBufferHeight is 600 Graphics.GraphicsDevice.DisplayMode.Width is 1360 Graphics.GraphicsDevice.DisplayMode.Height is 768 how can I to set the resolution My monitor is an AOC 19" widescreen... Thanks! No, you cannot change the XBOX 360's resolution, as it's defined by the user in the system settings. (or even if there is a way to force it, don't do it !) Your game is automatically scaled to the resolution of the XBOX, so you don't have to do anything about that. But you have to manually stretch the game to fit the user's resolution on W ...Show All