vannielou's Q&A profile

• Visual C# Delegate quandary

  In my Class Form1 a delegate DoMyWork object is declared as follows: public delegate void DoMyWork ( Cdelegate cDelegate, string sss); Cdelegate is a Class. It looks like this: public class Cdelegate { public void openCSVfileAndDumpToSQL ( string symbol ) { Class2 class2 = new Class2 ( ); string csvFile = ""; DataSet dataSet = new DataSet ( ); DataTable dataTable = new DataTable ( "temp_" + symbol ); // etc., etc., etc. } } Then in Class Form1 I have a Click method: private void pushCSVtoSQLserver_Click ( object sender, System.EventArgs e ) { Cdelegate cDelegate = new Cdelegate ( ); char[] delim = { ',' }; string[] symbols = Globals.cumSy ...Show All

• Windows Forms How do I disable the AddNewItem button on the bindingNavigator control ?

  I have a simple form with a DataGridView, a BindingNavigator and BindingSource allowing me to view the contents of a table called 'RUN'. I have included the DataSource in my project so a runTableAdapter and myDataSet.Run has been created automatically for me. The problem is that on this particular form I don't want the user to be able to add new items using the BindingNavigator control. I could just delete the 'AddNewItem' control from the navigator but for a consistent look and feel I would rather just disable it. I can disable it at design time which works to begin with. Then at run time, the user can select some 'filtering criteria' using other controls on the form and then press a button. I then fill the table using the following: ...Show All

• Visual Studio Express Editions Crystal Report Hassles.

  Hi All, I have the dataset, with one table in it. The table contains 4 rows, but when i bind my dataset to the crystal report, it shows only one page and one records. Any pointers on what should i do Now the problem is that, if there are 3 records, CRViewer displays the 3 pages, but when i scroll to the next page the page is blank without any record. Any pointers on that ...Show All

• SQL Server How can I format the Date in the SQL Table using a SQL query

  Hi I have a SQL table that contains date in this format :- 2006-07-02 16:20:01.000 2006-07-02 16:21:00.000 2006-07-02 16:21:01.000 2006-07-02 16:22:00.000 2006-07-02 16:22:02.000 2006-07-02 16:23:00.000   The date above contains seconds that I dont want, how can I remove those seconds so that the output looks like :- 2006-07-02 16:20:00.000 2006-07-02 16:21:00.000 2006-07-02 16:21:00.000 2006-07-02 16:22:00.000 2006-07-02 16:22:00.000 2006-07-02 16:23:00.000   Your help will be highly appreciated. Rod Colledge wrote: That will change the data. If you only want to change the display, then try this ; select replace(convert(varchar(20), columnName, 102), '.', '-') + ' ' + left(convert(var ...Show All

• Visual Studio Express Editions Which book is best for learning C#?

  Hi, I was wondering if anyone could recommend a good book for learning C#. I already know ANSI C++, which means I don't know MFC programming. I'm very good at the language level (OOP an' all), but I couldn't decide which book would be best for me. Any advice will be appreciated. The books which I short-listed are : 1) MicrosoftR Visual C#R 2005 Step by Step (by John Sharp) http://www.microsoft.com/MSPress/books/7655.asp 2) Programming MicrosoftR Visual C#R 2005: The Language (by Donis Marshall) http://www.microsoft.com/MSPress/books/7219.asp Which do you think is better Or if you have a better book in mind, please tell me. Thanks! Thank you everyone, for your replies. But I still can't decide. I know, when I started off with learnin ...Show All

• Visual Studio Express Editions Unable to register

  I just downloaded VB 2005 Express edition and now am trying to register it. The only problem is I can't! I fill out the one page online and when I submit it tells me that I have an invalid email address. I've checked it over multiple times and my email address is correct. Does anyone know what is wrong Or how to contact Microsoft about this Every support page I've found is charging $99 atleast, which I don't feel like paying since its their problem, not mine. there are many topics about this:   http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=335745&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=574062&SiteID=1 http://forums.microsoft.com/MSDN/Sho ...Show All

• Smart Device Development SIP - How to get Edit Control Handle ?!

  I'm writing an SIP and i need to get the value of the Edit Control ... Scenario: The User select my SIP and use my SIP to process the text in the Edit Controls, Rich Edit Controls and etc. How can i get the handle of Text Controls in my SIP ! Regards, Hadi ...Show All

• SQL Server SSIS Newbie - ETL question....

  I am tasked with loading the data from one SQL Server 2005 database into another of the same type and schema on the same server. I'd like to use this task to get my feet wet in terms of using SSIS. Can someone suggest a way of doing this Thanks in advance I am not sure I understood correctly. But if you have Identity columns in your source tables; and you want to keep those values in the target; all you need to do is to drop the Identity column definition in the target tables(Set identity insert property OFF may also work). Does this answer your question ...Show All

• Visual FoxPro Not able to run foxpro exe file (urgent)

  Hi , I have a foxpro forms and reports. when i run from desktop . it is showing 'CANNOT LOCATE THE MICROSOFT VISUAL FOXPRO LIBRARY' I got these files from client. i have installed my visual studio in 'C:\Program Files\Microsoft Visual Studio' So I have to anything in my WZSETUP file , In this file they have mentioned everything. Like source and destination. i have dbf files and forms and reports in this folders. Now i am not able to my client exe file. Kindy anyone tell me the solution Thanx and Regards Selva.R Hi Selva, I think the exe is not built as 'stand-alone'. Then opening the fxp main-page...what are you doing with fxp. Please let me know in detail so that I can try to ...Show All

• SQL Server Visibility

  Hi, In my report body i have the number of text box and i have the one parameter i.e id.If id is not available then i want to display a message "ID doesn't exist".and also want to hide all the textboxes and these textboxes are not part of the table.in my dataset the fields are "CaseExist,number...." if case id is available the caseExist contain some value otherwise it is null.How to hide all the textboxes which are not in Table. Please help me. Tahnks in advance within the textbox properties you have an option visibility.....within this you can build an expression and use something along the lines of iif(expression.tostring = "", false, true) This should sort y ...Show All

• SQL Server SQL License and Pricing Question

  Hello, We currently are running SQL 7 Enterprise Edition on a Windows 2000 server. We are looking to move upto the 2005 edition but do not see the need for Enterprise edition as we use the database server for websites only. We currently have about 60 databases and 60 users on our server. Connecting are 5 web servers. So for the licensing and what not would I need to get 5 devices cals Or is my only option the CPU license with the Enterprise edition Thanks, Ryan Commonly spoken: If you can determine the number of individual users you will need a CAL you can buy the appopiate CALs for the users,e.g. 100000 Users connecting ot the server will need 100k Cals, that for the most internet presences not adequate. ...Show All

• Visual Basic Seeing the registered sql server databases in XP

  Hello guys! How can i see what databases are registered in XP, how can i do in VB to get that information on a textbox, for example thks in advance. To list the servers/Instances installed on the server/desktop you can use the sqlcmd command line tools with the -L switch. If you want to do this in code you could wrap it up in a process class. For example 'sqlcmd -L' To list the databases installed on the database instance you could use the following code, now I am sorry that I only have vbscript or C# Code but you should be able to convert it or use on of the Converters on the net. VB Script. Dim smoSvr Dim svrName Dim smoDB svrName = "DDGXP\YUKON" Set smoSvr = Create ...Show All

• Visual Basic Nooby here again. Handle the keyDown event.

  Eh i cant believe i forgot this lol... How do you make a PictureBox move with Arrow Keys I keep trying this ... But, it doesn,t seem to work :( Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) Select Case KeyCode Case vbKeyUp: Picture1.Top = Picture1.Top - 50 Case vbKeyDown: Picture1.Top = Picture1.Top + 50 Case vbKeyLeft: Picture1.Left = Picture1.Left - 50 Case vbKeyRight: Picture1.Left = Picture1.Left + 50 End Select End Sub Thank you, Moveit Private Sub Form1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles Me.KeyDown Select Case e.KeyCode Case Keys.Up Picture1.Top = Picture1.Top - 50 Case Keys.Down Picture1.Top ...Show All

• Windows Forms Automatic code for Properties Generation

  One Feature missing in vs is to have getter and setter methods (property) automatically generated Would you also like to have it https://connect.microsoft.com/vbasic/feedback/ViewFeedback.aspx FeedbackID=214750 ...Show All

• Smart Device Development Error 183 vb 2003 Compact framework

  Hi I have been working on a project and once completed I went to deploy it. I built the cabs, tried installing and the program would not work. I then tried to deploy via studio as if I was debugging and got a message box with #183:. Nothing came after the 183, so I tried to run the app on the device and this time I got a message box with nothing more than: Exception. I then started putting in message boxes and discovered than the program will error out only when it tried to load an image, all forms without images work fine, but those with images do not work The project is quite large and has been working fine until now. The last few weeks have been spent testing and debugging with only minor changes. It is written in VB and uses S ...Show All