PaulMCiti's Q&A profile

• SQL Server Schedulling Jobs on SQL 2005

  I am changing the SQL 2000 to 2005 but i dont know how I can do the configuration of the schedule for each DTS that migrated The scheduling mechanism has been changed in 2005 to something that IMO makes a lot more sense. You would need to create a schedule that can then be reused as many times as you want to for multiple jobs. Alternatively, you can create a schedule on the fly when you are creating a job. (The schedule is still saved sepa ...Show All

• Visual Basic Designing cells for spreadsheet program

  I am going to develop a spreadsheet program. For now, it will only accept string data into cells, save them to and open them from file. My question is, what approach should I take to display the cells Should I use common controls like TextBox for each cell or should I store the contents, size and location of the cell in an object and use GDI to display them I have this confusion because, either approach has its own advantages and disadvantages ...Show All

• SQL Server Database is read-only.

  Hi I have been learning on how to use the new features of the .NET 2.0, and Well I using VS2005 and everything is pretty straight foward. I did a Membership webform where you log in and create users and roles etc. I installed the SQL Server 2005 express as my Data provider and thats where my Tables are. I used the aspnetsql_reg comand to integrate the server to this application. Anyway my problem started when i decided to copy my project to my ...Show All

• .NET Development Problems with SQlDataReader

  Guys, Hope you can help me. I have one application that is basically divided on two parts First One: Creates records on one table (Gets info from different tables) Second One: Reads the records one by one from the table and send mails with that info (for this part I use a SqlDataReader) One important thing to mention here is that we are talking about huge amount os info (200 000,  500 000) and this process is running every ha ...Show All

• Visual Studio Team System How to run ordered tests?

  Hi, This might be a very basic question, but I can't figure out how to run an ordered test. How do I run an ordered test without having to run everything else (like I can run individual web tests) Thank you. Hi Yulia You run an ordered test the same way you would run any other test, either from test view window, test manager window or through the commandline using mstest. An ordered test is used to ...Show All

• Visual Studio Express Editions Beginner, need help

  I am just getting started with learning the C++ language. I have downloaded the Visual C++ express edition and set it up with the instructions on this page: http://msdn.microsoft.com/vstudio/express/visualc/usingpsdk/ Now to test the installation I am trying to compile the simplest of programs: // hello!.cpp #include <iostream> int main() { cout << "Hello!"; return 0; } and get this error: Error1 fatal error C1010: unexp ...Show All

• SQL Server datatype casting in derived column

  Here is my expression in a derived component: "Failed insert into PONL_WELL. WELL_NO=" + (DT_WSTR,10)PROP_NO PROP_NO comes from ms sql server , and the derived component datatype for this column is DT_WSTR. The destination will be ms sql server, and i have a data conversion after the derived component to cast from DT_WSTR to DT_STR. However, the derived component failed everytime giving me Error: 0xC0049064 at Load Ponl ...Show All

• Smart Device Development SD Card Question- URGENT!!! New Question

  When using a SD card for data storage does .net cache the data and write it later or does it write as used   I am losing data and have no reason for this to happen.  It is as though the user never wrote to the SD card.  I had a user bring in his device.  I looked at the screen that displayed his orders.  They were there...clear as day..., orders 1-4.  This meant that the user had saved 4 orders.  As each ord ...Show All

• SQL Server Transform data to excel sheet or xml

  Does SQL 2005 Express have standard functionality on board to export data as an excel sheet or as XML in a specified format Hi Philip, SQL Express doesn't include the export functionality as in other Editions as that functionality relys on Integrations Services, which is not included in Express. You can however product XML using the FOR XML clause in a SELECT statement and then pushing the results to a file. ...Show All

• Smart Device Development Using Unmanaged(evc ++ 4.0 sp4) dll in vs.net 2005 (compact framework 2.0)

  hi folks, iam devloping application for pocket 2003 2nd edition. for this we are using vs.net 2005 . My problem is when i call a evc++ 4.0 (also installed SP4) dll it throws MissingMethodExcepion. but the same code is working in vs.net 2003. my code look like this.. <DllImport("testDLL.dll")> _ Private Shared Function fnTest() As Integer End Function sub callDll() Dim i As Integer i = fnT ...Show All

• Visual Studio Express Editions Problem with sample MessageBox

  Excuse me, Ihave a problem, i try to digit this simple code from the Petzhold book on a Visual c++ express project. #include <windows.h> int WINAPI WinMain (HINSTANCE hInstance, HINSTANCE hPrevInstance, PSTR szCmdLine, int iCmdShow) { MessageBox (NULL, TEXT ( "Hello, Windows 98!" ), TEXT ( "HelloMsg" ), 0) ; return 0 ; }   The compiler send me this message: ------ Build started: Project: prova, Configuratio ...Show All

• Windows Forms How to add custom column style to add button in DataGridCollumnStyle Collection Editor dialog?

  To open "DataGridCollumnStyle Collection Editor dialog" you need to follow these steps: 1)Open datagrid properties, 2)Click at "..." button of TableStyle property of grid - DataGridtableStyle Collection editor will appear. 3)Click on "Add" button - the dataGr ...Show All

• Visual C++ rand() not being random!!!

  OK An other problem which I really need assistance with I'm using srand to generate random numbers out of a range BUT i always get the same sequence of numbers!! But I notice the problem come from rand() i tried to create a new project with only this : #include <ctime> #include <iostream> using namespace std; void main() { srand(time(NULL)); cout << rand() << endl; cin.get(); cin.ignore(); } ...Show All

• Visual C# Password?

  Is it possible to password protect a program Hi, That makes sense and it does, but I would like my password character to be like which is used for most internet logins like the Window Live ID login. Is making these passwordChar characters allowed Thanks. Eragon. ...Show All

• Windows Forms BackColor Property for TabControl

  Wouldn't it be nice if THIS property worked You're exactly right. I do understand that I have the option of using the paint, GDI, or graphics but the precision required to make it look good is higher than my abilities or pati ...Show All