Hans_Schmucker's Q&A profile

• SQL Server Is it possilbe to load my data directly?

  I have thousands of records, which are .txt format, to be loaded to the DB and need to mining them. The only way for that is to write a program and read them to the DB or can I load them directly And also I have to design the tables based on these data myself, right Thank you. Thank you. I am now investigating the Importing wizard(but the server is not ok..), but I still have a question about the data structure shown as follows: Test Record Number: 1 Prospect ID = 254065363128601034074140572161982 ---(This should be the primary key) Match Score = 90 Input Record Fielding ( eg wordnumber[Field] ) : 1[1] 2[1] 3[1] 4[11] 5[11] 6[11] 7[11] Prospect Word = 1 type = 1 match level = 4 input word = 1 inpu ...Show All

• SQL Server SQL Server 2005 Install Hangs - Does MS Plan to fix?

  I am experiencing extremely slow behavior (no activity for > 30 mins) during a SS 2005 Dev Edition install on XP SP2 on various steps during the SQL Server Database Services step - e.g. during "Setting File Security". This is very annoying. I've found many postings on this issue indicating that OS calls in this part of the install (e.g. LookupAccountName()) are network speed dependent. Does Microsoft have any plans to rework this part of the install to rid the need of these calls I really wish the install would be possible without these calls - it's driving me crazy monitoring this for hours. We've got to roll SS2005 out to a couple hundred developers eventually and this isn't going to cut it. Thanks for your tim ...Show All

• Visual C# best practices to secure c# applications

  Hi, I'm starting this thread to hear your experience on the best practices of securing c# applications and code from being reverse engineered and generally jimmied with. Thanks for your input. I think before one can really discuss this topic, you need to clarify what you mean by securing an application. If all you mean is that you don't want someone to reverse engineer the application and reuse your code for their own purposes, thats one thing. If you mean to "secure" it in order to protect the private information that is handled or made available to authorized users through your application, then this becomes an entirely different discussion. I bring this up because, contrary to what many ...Show All

• .NET Development Assembly.Load(): Fails once, fails always ?

  Scenario: Dynamic assembly loading: If an assembly does not exist, install it from the network. Consider the following code: 1: Assembly oAssembly; 2: try 3: { 4: oAssembly = Assembly .Load( "ClassLibrary1" ); // Will fail since assembly is not available. 5: } 6: catch ( Exception ex) 7: { 8: // Copy ClassLibrary1 to AppPath\ClassLibary1 folder 9: } 10: oAssembly = Assembly .Load( "ClassLibrary1" ); If you run the code above it fails at line 10, although the assembly is available at that time. It seems that when an assembly can't be loaded the 1st time, the application will not try to load it the 2nd time, even when it is available at that time. Is it possible to force the application to try to load it the 2nd ti ...Show All

• Visual Basic convert into .NET 'Any' datatype from vb6 to char *szFilename in C++

  Moving vb6/C++ into .NET 2.0 and using upgrade wizard as place to start. What do I do with this 'ByVal szFilename As Any' to 'char *szFilename' conversion in .NET I will be wanting to leave the c++ dll as is. It's the 'Any' datatype I am puzzling over. What do I change that to Thanks. -greg ********vb6 interface code**************** Public Declare Function foo _ Lib "foo.dll" _ (ByVal szFilename As Any) As Long ******** C++ dll **************** int EXPORTED foo(char *szFilename); You need to do: Public Declare Function foo Lib "foo.dll"(<MarshalAs(UnmanagedType.LPStr)> ByVal szFilename as String) As Integer Hope this helps, ...Show All

• .NET Development asynchronous call to SerialPort class

  I write to confirm if the System.IO.Ports.SerialPort class supports asynchronous method calls. - Jeremy I believe any method support asynchronous calls. You just have to have a matching delegate and call BeginInvoke, provide a callback delegate, and you're away. There's plenty of patterns for using asynchronous delegates. Cheers, Paul ...Show All

• Gadgets saveAs dialog

  Hi again, seeing that the documentation is still not updated, how it is with the save file as dialog I've discovered that I have to separate the file types by \0 instead of :. I wonder if I can leave the code with this null char or if this would be unexpectly fixed And how should I use the first parameter Is there any way how to suggest the file name for user That's a nice bug! I'll have to document that one - well done for spotting it. Tricky one to answer as should MS now fix it, all existing code will not work correctly. I'd go with the \0 and should it get fixed, just put out an update to your Gadget. For the first parameter, you can either force it open in "My Documents", or leave it blank to o ...Show All

• SQL Server Custom Security w/ Standard Edition/

  Hello... I am trying to verify that the ability to use the security extension to use Forms based authentication is available (or not) with SQL 2005 Standard. I have read a few books and articles that state that only the Enterprise edition will allow us to use the security extensions to customize authentication and authorization. But a few recently have told me otherwise. Does anyone know for sure We use Standard edition...and would like to customize our security. thanks - will SQL Server 2005 Reporting Services Standard edition allows custom security :-) http://msdn2.microsoft.com/en-us/library/ms143761.aspx Features/Reporting Services Enhancements EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit) ...Show All

• SQL Server Creating database

  I have been using microsoft office access to create database and connect to application built. This is the first time trying to create database using the sql server. How do i create a database using this Do i use the sql server management to create it Is there any step by step tutorials How do i connect the database to the web developer   takkyangel wrote: I have been using microsoft office access to create database and connect to application built. This is the first time trying to create database using the sql server. How do i create a database using this Do i use the sql server management to create it Is there any step by step tutorials How do i connect the database to ...Show All

• Visual Basic Stopping Alt+Ctrl+Del

  Hi all I'm writting a program for public payable networked computers for playing games. I've got the server/client billing and other stuff like that done. Problem is, when my program boots up, it displays a full screen form (on top of everything), which holds the login/programs they can use/play. I've managed to remove the Alt+Tab, Alt+F4 and other key combinations like that.  Although, i'm finding that Alt+Ctrl+Del still brings up task manager no matter what i do. I have a solution, that on program startup, it renames taskmgr.exe, (and the backup in dllcache), and it works (Doesn't launch taskmgr),  however, there is a windows warnign saying files are missing. (No big deal, i rename on program shutdown). Is there a way aro ...Show All

• Visual Basic component to select a file?

  If i want to prompt out a dialog box to let user select the database file(.mdb), what component or method should i use I would like to get the path of the selected file as i know the browsefolderdialog only let user to choose folder not file.....so what should i use to select a file You can look in the help file - its amazing what it tells you. http://msdn2.microsoft.com/en-us/library/system.windows.forms.openfiledialog.aspx ...Show All

• Visual Studio Express Editions How do I at Run time add the mousehover elements to a picturebox

    The code below is what I am useing to add pictureboxs to a form. What do I need to add the mousehover to them. Thanks   Private Sub InitializePictureBox()         Dim e As EventArgs = Nothing         PictureBox1 = New PictureBox         ' Set the location and size of the PictureBox control.         Me.MyText.Text = "Sample"         Me.PictureBox1.Location = New System.Drawing.Point(x, y)         Me.PictureBox1.Size = New System.Drawing.Size(8, 8)         Me.PictureBox1.Tab ...Show All

• Visual Basic how to show form using a string

  Dear Expert, I store all of form's name into a table, the form names will be listed in a listbox when my MDI started, user should select from the list if he/she wants to run it. I store selected form's name into a string .. but I don't know how to show the form using the string .. could any body please help.. Thanks a lot in advance ps. I am using VB.NET 2005, please don't suggest me to use select case statement .. Regards Winanjaya i will do it like this import system.refrlection Dim strName As String = "<Application Name>.<form name>" Dim frmType As Type = Type.GetType(strName) Dim cinfo As ConstructorInfo = frmType.GetConstructor(System.Type.Emp ...Show All

• Windows Forms DataGridview

  i need an event in datagridview that will be called for every row that is binded to the grid in windows application. Is there an event ...Show All

• SQL Server Are these queries possible without cursors or a while loop?

  I appreciate any help or advise! Thanks assuming the contents of the table are: 1 52 PUERTO RICO 2 52 PUERTO RICO 3 10 MA 4 52 PUERTO RICO 5 5 NY 6 10 MA 7 5 NY 8 52 PUERTO RICO 9 10 MA 10 11 RI 11 12 PA 12 13 CT 13 14 GA (1) detect if there are duplicates and select those records create table twoCol ( id int identity(1,1), colOne int, colTwo varchar(30), modified_last datetime ) I would like to detect all duplicate rows based on colOne and Col2 e.g(all three of these rows have same colOne and Col2) 3 10 MA 6 10 MA 9 10 MA e.g(all four of these rows have same colOne and Col2) 1 52 PUERTO RICO 2 52 PU ...Show All