GRiNSER's Q&A profile

• Visual Basic How To Return records from database a to Array() Get

  So I have a code And I want to return records from Datase Northwind Employees Table FirstName Column to array Save. But an occur error. Thanks for Help. Dim Con As SqlClient.SqlConnection = New SqlClient.SqlConnection Con.ConnectionString = "Server=.;Database=Northwind;Integrated Security=SSPI" Try Con.Open() Dim Com As SqlClient.SqlCommand = New SqlClient.SqlCommand("Select FirstName From Employees", Con) Dim Dr As SqlClient.SqlDataReader Dr = Com.ExecuteReader Do While Dr.Read Dim FirstName() As String = {Dr(0)} ReDim FirstName(CInt(Dr(0))) ...Show All

• Visual Studio 2008 (Pre-release) XPath replacement?

  I saw in the channel9 a video with Anders H.  talking about Linq, DLinq, and XLinq and how these are able to query anything that implements ienumerable. This looks really great, but at some point in the video Anders talking about XLinq said that this may become the next generation of XPath (or something like that, don't recall the exact comment). Could anybody explain how exactly this is going to work All the examples we saw in this video related to XML were for generating XML from in-memory data or from a relational DB, but what about querying an existent XML file to do a transformation, for example Is the syntax i ...Show All

• Visual Studio Team System IDE crashing after profiling

  I have Visual Studio Team Edition for Software Developers installed, which was upgraded to from 2005 Professional. Whenever I launch a performance session (either using the performance wizard or by creating it manually) the IDE crashes as soon as I exit the program that I am profiling. I've tried this with a few projects and get the same problem - they are all C# windows forms applications. The programs run fine but when I close them, VS shows a brief flash of a progress bar on a gray background and the IDE simply exists, without leaving any processes running. When this occurs I get the following event in application log (event ID 1023 ...Show All

• Visual Studio 2008 (Pre-release) Go live for LINQ/DLINQ before Orcas?

  There seems to be a lot of activity on this forum and it has me wondering...are all these questions coming from applications that aren't going to launch until after Orcas ships OR is it "OK" to create apps today that are targetting .NET 2.0 using LINQ/DLINQ :) Is there any chance there will be a Go Live license for LINQ/DLINQ before Orcas ships Whats the latest on when Orcas is expected to ship Basically, when can we expect that we'll be able to use LINQ for real ...Show All

• Visual Studio Express Editions What is the current build of beta 2?

  Hello, What is the current build of beta 2 I have beta2.050215-4400, is that the most recent one. Where in Microsoft site I can find numbers of latest builds, to be up to date Regards,ProJester. i installed some beta versions and now I can't seem to uninstall them, because it can't find some version of 2.0. do you have links to download these, especially Beta1 - 2.0.40607.16 Beta1(Refresh)- 2.0.40607.85 thanks much, ...Show All

• Visual Studio DependentUpon

  I have two t4 templates that generate two partial class files. Is there any action in the Recipe Framework Library that can make one file DependentUpon the other one Just like windows form, Form1.designer.cs is DependentUpon Form1.cs in the solution view. Thanks, Eric The Services Factory (http://www.gotdotnet.com/codegallery/codegallery.aspx id=6fde9247-53a8-4879-853d-500cd2d97a83) comes with a library (Microsoft.Practices.RecipeFramework.Extensions.dll) that contains several additional actions for adding items from T4 content. Specifically, you have AddItemFromStringAction , which gives you a ...Show All

• Windows Forms Send URL querystring from Windows Form

  Hi, I have a small application I am trying to get done, and I can't seem to figure out how to do something.  I have a timer that runs, and every (x) amount of seconds I need it to send a querystring via http to a video server that resides on the LAN.  (ie - http://192.168.1.66/axis-cgi/ptz.cgi gotoserverpresetname=frontdesk).    The "gotoserv ...Show All

• Windows Forms pressing arrow keys as hot-keys changes control focus

  I want to define the Left and Right arrow keys as "hot keys" in my form. I've handled KeyDown, and I set the Handled property of the event, but if the current focus is on a button, radio, check box, etc, then the arrow keys cycle the input focus through controls on the form, or within the same group box. How can I disable this& ...Show All

• .NET Development FtpWebRequest question

  Can anybody please help me I am trying to write a code to uplode or delete file on ftp server. A problem is that I don't know how to set up Method property for ftpwebrequest class, so sample code like this would work. Dim serverUri As String = "ftp://ftp.contoso.com/file.txt" Dim request As FtpWebRequest = CType(WebRequest.Create(serverUri), FtpWebRequest) request.Method = WebRequestMethods.Ftp.DeleteFile request.EnableSsl = True Dim response As FtpWebResponse = CType(request.GetResponse(), FtpWebResponse) Thank you the sample code you have posted looks correct. what doesn't work ab ...Show All

• Visual Basic DataSet wizard and Connection String

  I used the Dataset wizard of VB NET 2005 to map an Access database. All works fine but with the database selected at design time. How can I modify the Connection string at runtime I need to plug different instances (in different files) of the same database at runtime. It is possible to change all TableAdapters at once if you are using the settings file to store your connection string. There is a Smart Client Data blog post at  https://blogs.msdn.com/smartclientdata/archive/2005/07/25/443034.aspx  that should get you started and includes a code sample. Jay Hickerson Visual Basic Team ...Show All

• Visual Basic Links

  hi everyone, can i link to asp.net page from a vb.net program for an instance, i click on a button in a vb.net form and it will link and open up internet explorer (an asp.net page). Sure, put this in the button click event Process.Start( "http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=388338&SiteID=1" ) ...Show All

• SQL Server Lookup including looking up on null values possible?

  In order to insert datekey values in I lookup datekey in the datedimension table. I join on the 'Date' column that contains dates. The datedimension contains one record for 'unknown date' for which the value of the 'Date' column is null. The behavior that I desire from my lookup transformation is that for input records with a date the corresponding datekey from the datedimension is looked up and for records with date = null, the datekey for 'unknown date' is looked up. The first part works well but the looking up on null fails, apparently because you can not say null == null. Does anyone know whether there is a setting in the lookup transfor ...Show All

• Microsoft ISV Community Center Forums Please Help with Access 2003 and ActiveX Controls

  Hello everyone, I am having a major problem and I can not find a resonable answer any where, so I hope some one here can help me out. I have been working with Access 2000 for a long time and have always been able to Insert the ActiveX control "Microsoft Common Dialog control, version 6.0". I now have made the jump into Office 2003 and Access 2003 which when I try to Insert the ActiveX control "Microsoft COmmon Dialog control, version 6.0" I get the following error: "You dont' have the license required to use this ActiveX control." Can I assume that Office 2003 Professional does not have the Design Time ...Show All

• SQL Server Slowly Changing Dimension with 600,000 rows

  Hi, We have been using tasks generated from the SCD wizard. We have smaller dimensions (< 30,000 rows) that work well. Our Product Dimension package is giving us performance problems (taking 7 hours to do 600,000 rows when 80,000 records are updated; the rest new inserts). It is similar to the smaller dimensions. Several columns are type 1 and are doing update statements; several are type 2 doing updates and inserts. The package had a complicated view as the initial task, but we have since modified to use a SQL command with variable and now the initial read appears quick, but is chunking in 10,000 record increments and taking the 7 h ...Show All

• Visual C# Console key reader

  Hi guys, I'm looking for something like _kbhit in C++ bye Console.ReadKey is a blocking method, which is not the same as_kbhit, since the C++ method is checking the buffer and returning inmediately. The Console.KeyAvailable propery returns true if there is a pending key in the buffer. Good luck, ...Show All