GeneralSQL's Q&A profile

• Visual Basic Calling local parameters from subroutine

  I'm not sure whether it's possible to call local parameters from a subroutine. Anyway, e.g. Module Test dim z! public sub equation (x , y) as single z = x + y console.writeline("{0},{1},{2},{3}", x , y, z) End Sub '------Try-out using property Public ReadOnly Property testval() As Single Get Return z End Get End Property End Module For some reasons, when I call the "Test.testval" in another Class/sub it always returns "zero" instead of "x + y" valve. Any helps on how to get this to work would be very appreciated. First of all your code here doesn't compile. I had to change it to: Module Test Dim z! Public Sub equation(ByVal x, ByVal y) ...Show All

• SQL Server SqlHelper.cs for SQL Server Everywhere

  Hi, my application work with the SQLHelper class. This works fine for the MSDE/SQL Server 2005 Express Edition. Now I want that my application work with the SQL Server Everywhere DB. Is there an SQLHelper class out there for SQL Server Everywhere Thanks Gunter Hubmann Check this blog entry out: http://www.distribucon.com/blog/PermaLink,guid,1655.aspx If you have any problems with it, let me know, but things are running smoothly here. Dan Miser ...Show All

• .NET Development Interfacing Web Apps with Windows Apps

  How can I get a .Net web forms application to interface and interact with a .Net windows forms application I ask because I am planning a web based application that will allow users to create custom .Net code to extend their site and compile it via a Win32 application that accesses the proper compiler and saves the DLL to the proper /bin folder, etc. Any advice on how to do this I'm sorry but I think I posted this in the wrong forum. I saw "Communication" and thought it would be the right place but after thinking about it for a minute I think I made a mistake. Would a moderator please move this to the correct forum if this isn't the correct one, please Thanks. ...Show All

• Visual Basic How to compare text between two text boxes

  I am trying to write a typing program which allows users to copy text from one text box into another. After a certain time the program calculates how fast they typed and also how many errors they made. I have completed everything except how to compare the two text boxes so it tells me how many characters dont match. Can anybody help with this. if all you need to know is if there is a difference then you can use the string.compare method...if you are wanting to display the differences then you must iterate through the strings... Private Sub Button1_Click ( ByVal sender As Object , ByVal e As System . EventArgs ) Handles Button1 . Click Dim counter As Integer = 0 For ...Show All

• Gadgets Launching a page in the default browser

  window.open() opens IE, how do I open the default browser (ie opera or firefox) Do I need to use an ActiveX control Thanks for your help Andy Thanks to both of you for your help. Tom's way was much shorter because I don't actually need to find out what the default browser is, just launch it. Worked a treat. Thanks again, Andy ...Show All

• SQL Server help me!beginner create database password

  I've learn DotNetNuke.I don't know how to create passID and userID for database sqlserver2005 express.someone help me.Thanks!thanks! You can do that by using the appropiate TSQL command, like sp_AddLogin and so forth, but as a beginner I would suggest you to use the SQL Server Management Express which has a graphical interface to administer the server instance. You will have to create a user and map the user to the appropiate database. There you will have to either grant him a role or dedicated permissions on the securables (objects) within the database. http://msdn.microsoft.com/vstudio/express/sql/download/ HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Basic Setup Produced By "Build, Publish" Gives Error After I Uninstalled VB With CD And 'Removed' All Installation CD Programs

  Hello, I created a setup file from my application. I did this because I want to put my application on other PCs without installing Visual Basic. I basically want to just run the applicatoin on other PCs. What I did to create the setup file was within VB I clicked "Build" then "Publish." I then wanted to test the setup file on my PC, so I removed everything given to me by the VB installation CD! So, I uninstalled VB using the installation CD. But, I also had to go to the control panel to remove some of the programs that the installation CD gave me. I did this because the uninstall via the CD left things on my system that the installation CD gave me. When I was done, the control panel, remove programs listing ...Show All

• Visual Basic How do you direct 'PrintPreviewDialog1' print output to 'PrintDialog1.ShowDialog'

  My PrintPreviewDialog1 works fine, also my PrintDialog1 where I can specify the usual printer, copies etc. and work with the result to access eg. the Copies. However - the PrintPreviewDialog1 'Print' button simply prints one copy to the default printer ... how do I set this button to link to PrintDialog1 instead The usual If PrintPreviewDialog1.ShowDialog = (the items available) then ..... etc. doesn't intercept if the user has clicked the Print button, this action just fires-up the print routine direct. Any clues Nick B What you describe sounds like the mouse is captured by the "Print" button in the preview control. You can't get to that button to cancel the capture. A work-ar ...Show All

• Visual Basic How can I tell when a series of events has completed firing?

  I have a bunch of business rules that I am applying to data in DataTable's and writing error information to the DataColumn(s) when they are in violation. Well because a DataColumn can only handle a single error string via SetColumnError(), and there may be multiple business rules that are in violation simultaneously on the same column I have run into quite a dilemma. I cannot simply clear the SetColumnError when one business rule checks out ok, because other rules that just ran previously may have had errors as well. Anyway, the way I have structured my program, each business rule is tied to the datatable via an AddHandler to the datatables RowChanging() event. When the row changes, all my rules fire off and check the data. How ...Show All

• Visual C++ VS2K5 SP1 Beta bugs!!!???

  I installed the beta to get around a merge problem with TFS and it worked. However, I create the installer for our product on that machine. When I released daily installer the code started breaking because the actual code was compiled with RTM VS2K5(this is expected) However, our previously released products running on MFC 8.0 all started breaking after installing the daily build. Why would already installed products on a system break if a product installed with the beta MFC merge modules start to break Is this what will happen when the SP ships And more importantly, how do I scrape the unwanted SP1 Beta DLLs from these now "infected" test machines Thanks, This bug is already reported on connect.microso ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Xbox Live Stats/Gamertag Webservice?

  Is there any means to access the Xbox Live webservice to read gamer related stats so as to create a custom stats program in .NET Is there a published API for this I've seen may websites doing mashups of gamer info and was interesting in trying it out if its possible. That, no. You can get the GamerTag, which is what I thought you meant - http://www.xbox.com/en-US/MyXbox/embedgamercard.htm You'd need to be a registered 360 developer to have access to the Live data and API. edit: Hmmm, I did find this . ...Show All

• Visual C# Changing Type during runtime

  In response to my previous thread which can be read here , I've decided to create a new thread because although I mention this problem in my previous thread, this is a different subject. To recap, I have a class Shape, which will have many inherited types. In a class Physical, I have a Property which returns a Shape object. Many classes inherit from Physical, and each inherited class will need the capability of allowing the user to change the Shape Type during runtime. I came up with a decent solution, but was wondering if anybody knows, or can think of a better way(s) to solve this: [ BrowsableAttribute ( true ), ReadOnly ( false ), TypeConverter ( ty ...Show All

• Visual Studio 2008 (Pre-release) MEX Security Requirements

  I have a WCF service that works fine with svcutil when I hit the mex url and it generates everything like I want it. However, if I change the application pool for the website that is hosting the service it breaks the mex. Everything else works, the service page and the wsdl page both load. But I can't use the mex with svcutil. What are the security requirements for setting the application pool identity to an account other than the Network Service account Thanks! -- Bryant as i know,mex binding should not depend on what account host process is running under can you please enable WCF trace(verbose mode) on service side,trace will provide more info about actual error message -Thank you M ...Show All

• SQL Server How to format prediction Expression

  hi, when i make use of predicton functions, the output is formatted in its own.But I want to format that.How to do that Thanks, Karthik. hi Shuvro, Thanks For your reply.Is it possible to format the resultset returned from a prediction function. For Example,In this query, select PredictTimeSeries(Performance,5) FROM [Stud_Model] I am getting the resultset as Expression.$Time Expression.Performance 200611 90 200612 95 like that. I want to give my own columnnames as Year and performance.how to do that Thanks, Karthik. ...Show All

• SQL Server Spurious Errors With Package Execution on Local Machine

  I am having strange errors with a package when running locally that has not been an issue before. The main symtom is that several Data Flow Tasks are either not inserting records on the destination or are only inserting 1 single record before the package errors with the error shown below. Strangely, the debugger will show X # of records from source and destination, but either no records are actually written or, again, in many cases, only 1 single record is written. This is very strange. App, System and Security logs yield no indication of security or other errors. All I have to go on is the above anomolies and the error message provided below. Below is the error message, can someone help me decrypt it Many thanks, Rick ...Show All