returning the value of the last record in a dataset

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Framework
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Use DataView to return the first n rows Can you use a DataView to return only the first say 10 rows of a dataset? If so, how? Thanks, Tag: returning the value of the last record in a dataset Tag: 79547
  - 2
    - How to: listbox scrollbar help Hi, i have tried to put a horizontal scrollbar on a listbox but have had no success following the help from several vb.net sites. I am developing using the vb.net compact framework as I am programming a Pocket PC. It may be possible that the compact framework doesn't allow this feature, anyone have any idea??? Thanks in advance Regenerater Tag: returning the value of the last record in a dataset Tag: 79543
  - 3
    - GPS Hello all, I'm not sure if this is the right place to ask, but I think this is a good place to start. I have been asked to write a small program, to run on a laptop (or perhaps a PDA) that accepts log entries. They want several fields captured, among them lat/long coordinates. Is there a standard API for getting this info or will this need to be written with a specific piece of GPS hardware in mind? I think I'm over my head here. Any help would be appreciated. Bill Tag: returning the value of the last record in a dataset Tag: 79541
  - 4
    - Reference DLL Question Hi, lets say that i have A.DLL and B.DLL. A.Dll hold reference to B.DLL. if i changed the B.DLL should i recompile A.DLL in order to get the new version ? does the A.DLL will Work with the new version of B.DLL without recompile ? how can i prevent this dependency ? one more question, i have some project which hold 1 vb file and 1 aspx file or other type of file. when i build the project it will build the vb and the other files to one dll or it will build just the vb file ? Best Regards , Tiraman :-) Tag: returning the value of the last record in a dataset Tag: 79538
  - 5
    - How to bind to DC depending on site I'm trying to bind to DC by site. The environment is a AD 2K3 domain with multiple sites. For example, when my application is started, it checks for the site of the computer where the application is running. Then, it looks for a DC in the site and then all DirectorySearcher and DIrectoryEntry operations will use a binding string aimed at that DC on the site. If the DC is not available, then a default server, the PDC emulator is used. How would I code in VB .Net the following: 1) Determine which site the current PC running my application is in. 2) Determine which domain controllers are in the site. 3) Bind directly to the domain controller on the site using DirectoryServices.DirectoryEntry or DirectoryServices.DirectorySearcher It's just that I don't trust the automatic DC selection when performing directory operations. Tag: returning the value of the last record in a dataset Tag: 79537
  - 6
    - How to copy an MS Excel graphic from the system clipboard to an image control and obtain its source reference in .Net with either VB.Net or C# Hello, Here is what I'm trying to do: -- Make sure both MS Excel and MS Word are running -- Create an Excel chart -- Save the Excel file -- Copy the Excel chart onto the clipboard using Ctrl + C -- Go to Word and look under Edit > Paste Special -- Note there is a source reference and an option to paste the chart as a metafile, etc. -- I would like to take this same information and make it available in a C# or VB.Net app For example, create a simple Windows application with a userform, an image control, a label and a single command button. Let's say that after the Excel chart is on the clipboard, one clicks the Windows application command button and Voila!, the imate control now contains a copy of the Excel chart and the label contains the reference information. I can make this work utilizing older technologies (i.e. WIN API to access the clipboard, etc.). Currently, when I try to set the image control in C#, I get a "cannot implicitly convert ..." blah blah error. Don't even know where to begin to obtain the source reference. Either I do not understand the currently available clipboard functionality under .Net or this is still only possible via the WIN API. Any assistance would be appreciated. Best Regards, Todd Tag: returning the value of the last record in a dataset Tag: 79535
  - 7
    - No Brain Problem! Have a very simple problem that I'm having a tough time explaining/solving. The problem is that I get different results when I print "?" a variable when using Enterprise Services (ES) than when ES is not included. The code for the 3 classes is below: Class #1 - STARBatchParms.vb =================== This class simply contains the structure that I want to pass from my form to my class: Public Structure BATCH_PARMS Public lLowerLimit As Integer End Structure Class #2 - BatchSimulator ================ This is simply a Form with a Go button. The click event runs the following code to build/load the structure and pass it to the 3rd and final component. Private Sub cmdGo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdGo.Click Dim clsBatchParms As New STARBatchParms.BATCH_PARMS clsBatchParms.lLowerLimit = 123456789 Dim x As New STCI.cExecCl Try x.Execute(clsBatchParms) Catch ex As Exception MsgBox(ex.ToString) End Try End Sub Class #3 - STCl ========== The third and final class receives the parms as an input parameter. I then inspect the same parameter via 2 different techniques and get 2 different results: Imports System.EnterpriseServices Public Class cExecCl Inherits ServicedComponent Private mBatch_parms As STARBatchParms.BATCH_PARMS Public Sub Execute(ByVal clsBatchParms As STARBatchParms.BATCH_PARMS) mBatch_parms = clsBatchParms 'Place a break-point on the following line. to allow you to send the statement '? mBatch_parms.lLowerLimit.ToString to the Immediate window. 'Returns a value different than the following statement gives to 'the OutPut Windows. What Gives??? Debug.WriteLine(mBatch_parms.lLowerLimit.ToString) 'Why didn't "?" and "Debug" produce same results? Exit Sub End Sub Insult to Injury ========= If "Inherits ServicedComponent" is removed from Class #3, everything works as expected in terms of "debug" and "?" producing the same results. Any input will be greatly appreciated!!! Tag: returning the value of the last record in a dataset Tag: 79531
  - 8
    - Secure Scheduling of Remote Tasks Does the .Net framework provide the libraries to enable the ability to schedule tasks on remote machines using the user's credentials? After some research, the following methods were found but none of them fully meets the requirements. 1) Use the Task Scheduler class found here http://www.codeproject.com/csharp/TSNewLib.asp?df=100&forumid=4062&fr=26 Problem is that the class required a username and password and doesn't just pass on the user's credentials. Tag: returning the value of the last record in a dataset Tag: 79530
  - 9
    - Web applications development If I have the following scenario, what should I do? The boss of a small company wants to competerize the daily operations. Say, he has the office in City A, but owns a factory and warehouse in City B. He wants to interconnect these locations by computer. He want to build a database to manage the stock, and query the warehouse status using browser when he goes online. What key issues that he should think of? 1. Database 2. Application server 3. Web server 4. Internet service 5. A main programming language 6. Web page Anything else? He wants the whole system developed by 1. Java in Windows platform or 2. Windows platform (without using Java), then, what are the most i) suitable (easy, convenient) ii) cheapest iii) common choice of above items? Actually, I know something like Oracle, MySQL, ... for database, but do not know which is the most appropriate selection. Thanks for your answers! Tag: returning the value of the last record in a dataset Tag: 79524
  - 10
    - problems with .net after a restore problem Hey I was wondering if anybody could help me with this problem, I cannot get my head around it. Basically I installed a program called editvoicepack that adds callsigns to microsofts flight simulator 2002. It also requires microsofts .net framework 1.1. It ran fine but I had to restore my computer to an earlier time because I lost a bit of work by mistake. Anyway after this the program did not work, I tried reinstalling it, resetting the restore point, completely deleting it from the registry and then resinstalling it and i still get this an unhandled exception. So I downloaded the .net SDK and ran the program through the compiler. I get the following problems. THE FIRST PROBLEM When the program runs the following error message occurs: An unhandled exception of type 'System.InvalidOperationException' occurred in system.xml.dll Additional information: There is an error in XML document (0, 0). Furthermore the output is as follows: 'DefaultDomain': Loaded 'c:\windows\microsoft.net\framework\v1.1.4322\mscorlib.dll', No symbols loaded. 'EditVoicepack': Loaded 'C:\Documents and Settings\John Woodhouse\My Documents\flight sim data\Voice Pack\EditVoicepack22a\EditVoicepack.exe', No symbols loaded. 'EditVoicepack.exe': Loaded 'c:\windows\assembly\gac\system.windows.forms\1.0.5000.0__b77a5c561934e089\system.windows.forms.dll', No symbols loaded. 'EditVoicepack.exe': Loaded 'c:\windows\assembly\gac\system\1.0.5000.0__b77a5c561934e089\system.dll', No symbols loaded. 'EditVoicepack.exe': Loaded 'c:\documents and settings\john woodhouse\my documents\flight sim data\voice pack\editvoicepack22a\datahandler.dll', No symbols loaded. 'EditVoicepack.exe': Loaded 'c:\windows\assembly\gac\system.xml\1.0.5000.0__b77a5c561934e089\system.xml.dll', No symbols loaded. 'EditVoicepack.exe': Loaded 'prz3pleu', No symbols loaded. An unhandled exception of type 'System.InvalidOperationException' occurred in system.xml.dll Additional information: There is an error in XML document (0, 0). Finally when I click break in the disassembly there appears to be a problem with the line, 00000206 mov dword ptr [ebp-8],0 I cannot get my head round any of this I am not good at programming, especiallcy in .net framework language. THE SECOND PROBLEM. This is the error message: An unhandled exception of type 'System.TypeInitializationException' occurred in Unknown Module. Additional information: The type initializer for "EditVoicepack.MainForm" threw an exception. THERE IS APPARANTLY NO COURCE CODE WHICH SEEMS A BIT ODD, the output is An unhandled exception of type 'System.TypeInitializationException' occurred in Unknown Module. Additional information: The type initializer for "EditVoicepack.MainForm" threw an exception. Unhandled Exception: The program '[4008] EditVoicepack.exe' has exited with code 0 (0x0). System.TypeInitializationException: The type initializer for "EditVoicepack.MainForm" threw an exception. ---> System.InvalidOperationException: There is an error in XML document (0, 0). ---> System.Xml.XmlException: The root element is missing. at System.Xml.XmlTextReader.Read() at System.Xml.XmlReader.MoveToContent() at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReader1.Read4_editvoicepack_userpreferences() --- End of inner exception stack trace --- at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle) at System.Xml.Serialization.XmlSerializer.Deserialize(TextReader textReader) at EditVoicepack.UserPreferences.Deserialize() at EditVoicepack.MainForm..cctor() --- End of inner exception stack trace --- at EditVoicepack.MainForm.Main() I am not sure if anyone can help me, but any would be greatly appreciated. I have looked at the system.xml document and it wont open because it has the wrong version attacthed to it, cant understand why. Any soulutions would be good. Thanks, John Tag: returning the value of the last record in a dataset Tag: 79522
  - 11
    - WebBrowser i have a problem i i have build a .net application in whidbey with the web browser control, but i dont able to capture popup openened by a web page beacuse the NewWindow event dont send to me the the opened popup you have an idea for resolve this problem? thanks to all excuse for my bad english Tag: returning the value of the last record in a dataset Tag: 79514
  - 12
    - Dead Socket Detection? Hi, everyone, I am trying to test a client/server solution that uses the .NET Socket class (blocking mode on the server). I need the server to be able to verify that a socket is still valid in case the client app drops the connection (i.e. the client app crashes). The Poll method and the Available and Connected properties always return the same value regardless if the connection is valid or not. Using the Receive(w/ Peek) method also does not work since it waits for incoming data if the connection is valid. Any suggestions on how to efficiently check the connection? Thanks, Bob L. Tag: returning the value of the last record in a dataset Tag: 79504
  - 13
    - Distribution Issues I created some DLL and EXE files in VB.NET to be used on a Windows XP computer. They worked successfully on my laptop where they were written, so I prepared another machine to use them. I installed dotnetfx.exe on the other machine and registered the DLL's. When I tried to run the DLL's, however, I got this message: "Attempt to execute COM object [object name here] failed. Could not create object." When I tried to run the EXE files, this this was the message: "Application has generated an exception that could not be handled. Process id=0xd08 (3336), thread id=0x408 (1032)" Are there certain steps to place .NET DLL's and EXE's on another Windows XP machine? Thanks in advance, Matt Tag: returning the value of the last record in a dataset Tag: 79497
  - 14
    - Howto correctly setup the Visual Web Developer 2005 Beta / WebAdmin I installed the visual web developer 2005 kit from microsoft. Install succeeded: - framework 2.0.... - MSDE 2000 - Visual WebDeveloper2005 ASP.NET 2.0 is running, but... when i try to access the webadmin module e.g. by going http://localhost/sitename/webadmin.axd there is an error saying that: "Unable to serialize the session state. In 'StateServer' and 'SQLServer' mode, ASP.NET will serialize the session state objects, and as a result non-serializable objects or MarshalByRef objects are not permitted. The same restriction applies if similar serialization is done by the custom session state store in 'Custom' mode." Is there any compatibility issue with serialization in dotnet 2.0? my system is as follows: - windows xp pro version 2002 ( sp1 ) - dotnet framework 2.0.40607 Beta - Visual Web Developer 2005 Beta (preview) - MSDE 2000 (local)-instance with sa and set password (not downloaded sqlserver express 2005, since to big/time went by) and nothing else. It's a clean install. I issued 'aspnet_regiis -i' and 'aspnet_regsql -ssadd'. I have not changed anything after install completed. Please give hints and checklists to consider when configuring asp.net 2.0 and session management (sqlstate with msde 2000? possible), howto to make it all run. Thanks in advance, Ole Viaud-Murat Tag: returning the value of the last record in a dataset Tag: 79496
  - 15
    - Bootstrapper Install problem I am using the bootstrapper plug-in from http://msdn.microsoft.com/vstudio/downloads/tools/bootstrapper/ to include .net with my visual studio application. One major problem I am noticing now is when i make a new build, the installer won't let me install over or "upgrade", it makes me physically uninstall my program from Add/Remove Programs. Does anyone know why this happens\? Is there a way around it? Thanks in advance Skylar Tag: returning the value of the last record in a dataset Tag: 79489
  - 16
    - find string if not preceded with @ anywhere in the string we have the html text of an email and wish to search for banned content we use [^@\-\.]\bsomedomain\.com\b this will pick out somedomain.com but not fred@somedomain.com which is correct but it will find fred@sub1.somedomain.com how could you alter the above expression to exclude all words that contain an @ not knowing where it maybe in the string Tag: returning the value of the last record in a dataset Tag: 79488
  - 17
    - Check AD password if "user must change password next login" Hi all, I'm trying to find a way (using C#.NET or COM) to authenticate a user based on his credentials in Active Directory. The problem is that when I manually set "User Must Change Password at Next Logon", or when the password expires, I can no longer bind to AD using this user. Is there a method that checks the password in AD regardless of that flag? What I'm trying to implement is a dialog box prompting a user to change the password if the password has expired. How can I check the old password for validity. Thank you, -Oleg. Tag: returning the value of the last record in a dataset Tag: 79484
  - 18
    - Is Whidbey hardware accelerated for Drawing? Hardware acceleration has been sorely missed from V1.1 for 2D drawing... does anyone know if V2.0 corrects this? Tag: returning the value of the last record in a dataset Tag: 79482
  - 19
    - DirectoryServices Hi, A system that is being designed will use ActiveDirectory to store userinformation for a SQL Server 200 base web app. It was decided that only the windows account username need be stored in the database for authentication by the web app. However I realised that if we chould take this route everytime I wish to display a users name I will have to do a lookup to get the details from the to AD after getting the windwos user account from SQL Server. This sounds rubbish to be frank. Should I just store what I need i.e., First name, surname, email address in the database and us the AD purely for authentication. But then doesn't this loose some of the valu eof the AD and means there are two sources of info to maintain. Does anyone have any metrics on connection/transaction time with an AD, if it is nominal then I will go with the original plan. Also any advice on the topic would be greatly appreciated. MattC P.S. ASP.NET 1.1, C#, SQL SERVER 2000, WindowsServer 2003 Tag: returning the value of the last record in a dataset Tag: 79480
  - 20
    - Regex question - alternation I have a regex that matches nested parens (it's a slightly rewritten version of the one in Friedl's "Mastering Regular Expressions, 2e"): #[IgnorePatternWhitespace] $ # a literal ( (?: # non-capture group \( (?<Stack>) # on nested (, push empty capture | $ (?<-Stack>) # on nested ), pop empty capture | [^()] # anything except ( or ) )* # any number of chars between parens (?(Stack) # if stack not empty: ^ # then, match beginning of string (ie, fail) | \) ) # else, match literal ) Now, this works just fine, even on empty parens "()". What I don't understand is why I have to use /[^()]/ instead of "." in the clause that matches anything except parens. As I understand alternation, the left alternative is matched first. If it matches, the right alternative is skipped. (This certainly seems to explain the capture behavior when I match /that|th([a-z])t/ against "that thought": on the first Match, the second Group fails to match; while on the second Match, the second Group matches "ough".) Why, then, doesn't /./ work instead of /[^()]/? Since a left or right paren should have already been matched .... -- programmer, author http://www.midnightbeach.com and father http://www.midnightbeach.com/hs Tag: returning the value of the last record in a dataset Tag: 79467
  - 21
    - Root transaction wanted to commit, but transaction aborted Hi All, I have a .NET data access class that has TransactionOption.RequiresNew attribute set, and one of the functions has AutoComplete attribute set to True. The class is registered as a COM+ serviced component (through regsvcs). This function runs a stored procedure that takes 5 to 10 minutes. Through the profiler, I am able to trace this stored proc to completion. However, when control returns to the .NET function, an error "The root transaction wanted to commit, but transaction aborted" is raised. 1. The timeout is set to 0 (infinite). 2. The stored procedure uses no TRANSACTION statements. 3. There is no SetComplete()or SetAbort() in the code. 4. It runs fine without any errors if I run it from Query Analyzer. 5. It also runs properly if I use a simple SQLCommand without using this class. Is there anything else I can do to see where the problem is? Other details: I am using Framework 1.1 under Windows 2003. Thanks a ton for your help. Karun. Tag: returning the value of the last record in a dataset Tag: 79456
  - 22
    - Disposing objects Hi, im have a trouble with the memory, my app is to big and it consumes a LOT of memory, i read the posts of dispose in the forum, and all recomends to leave the GC do this work for managed resources, should i dispose the datasets and other graphic objects in my app? Thanks a lot Tag: returning the value of the last record in a dataset Tag: 79448
  - 23
    - FolderBrowserDialog - Disk Error whenever I call the FolderBRowserDialog (Visual studio.net 2003) and if there is no disk in my removable drives , I get the following eror: No Disk There is no disk in the dirve. Please insert a disk into drive \Device\Harddisk1\DR1. I do not why this is happening.can anyone please suggest me a solution?? Thanks and Regards MVB Tag: returning the value of the last record in a dataset Tag: 79444
  - 24
    - Namespace or type '...' for the Imports '...' cannot be found I'm getting the following error in my ASP.NET application: Namespace or type 'DirectoryServices' for the Imports 'System.DirectoryServices' cannot be found. I have added the System.DirectoryServices.dll to my References, and am including the line "<%@ Import Namespace="System.DirectoryServices" %>" at the top of the page. I have checked my global assembly cache (both on the development and the target machine) and both have the correct version of the assembly (1.0.5000.0). The server is Windows Server 2003, with all of the latest patches and updates installed. I've searched the net and newsgroups and have not yet found any solution to this one beyond the ususal "Add a reference to System.DirectoryServices.dll" to your project". Obviously, something deeper is happening here. Anyone have a clue as to why this isn't working? Thanks! Tag: returning the value of the last record in a dataset Tag: 79443
  - 25
    - TCPClient Performance Severly Lags Behind VB6 Winsock I'm writing a connector for a client to replace an old VB6 system. The connector works, but is several times slower than the older VB6 connector. I have isolated the problem to be in the connection to the server. All we are doing is sending a input stream to the server and receiving an output stream in response. The code is below. Can anybody see why this would run so much slower than VB6 using the Winsock ActiveX control? TIA, Matt public string SendMessage(string server, int port, string requestMessage) { TcpClient client = new TcpClient(); client.SendBufferSize = 1024; client.ReceiveBufferSize = 1024; StringBuilder responseData = new StringBuilder(); byte[] data = Encoding.ASCII.GetBytes(requestMessage); client.Connect(server, port); NetworkStream stream = client.GetStream(); stream.Write(data, 0, data.Length); data = new byte[client.ReceiveBufferSize]; int bytes = 0; while(true) { bytes = stream.Read(data, 0, data.Length); if(bytes>0){ responseData.Append(Encoding.ASCII.GetString(data, 0, bytes)); } else{ break; } } stream.Close(); client.Close(); return responseData.ToString(); } Tag: returning the value of the last record in a dataset Tag: 79437
- Next
  - 1
    - Querying IISMimeMap .. Access is denied .. HELP! Code posted below ( I am not sure which group to post to, but I need help) I wrote a Windows Form Application to query the IIS MimeMap on the localhost which worked fine. I ran the same code in asp.net and got "Access is Denied" exception. What is the least permissions set I should grant the aspnet account to avoid the exception. Or any other suggest would be fine Thanks. Private Function CacheMimeMaps() As Specialized.StringDictionary #If DEBUG Then Dim starttime As DateTime = DateTime.Now #End If Dim entry As DirectoryServices.DirectoryEntry Try Dim mimeMaps As New Specialized.StringDictionary entry = New DirectoryServices.DirectoryEntry("IIS://localhost/MimeMap") Dim pvcMimeMap As DirectoryServices.PropertyValueCollection = entry.Properties("MimeMap") For Each o As Object In pvcMimeMap Dim mt As IISOle.IISMimeType = CType(o, IISOle.IISMimeType) mimeMaps.Add(mt.Extension, mt.MimeType) #If DEBUG Then Console.WriteLine("{0} = {1}", mt.Extension, mt.MimeType) #End If Next ' MimeMaps were found If mimeMaps.Count > 0 Then Me.Cache.Add(MIMEMAP, mimeMaps, Nothing, Cache.NoAbsoluteExpiration, Cache.NoSlidingExpiration, Caching.CacheItemPriority.Low, Nothing) Return mimeMaps End If pvcMimeMap = Nothing Catch ex As Exception ' do nothing Stop Finally #If DEBUG Then Dim endtime As DateTime = DateTime.Now Console.WriteLine(starttime.ToString() & "." & starttime.Millisecond.ToString()) Console.WriteLine(endtime.ToString() & "." & endtime.Millisecond.ToString()) #End If If (Not entry Is Nothing) Then entry.Close() entry.Dispose() End If End Try End Function Tag: returning the value of the last record in a dataset Tag: 79433
  - 2
    - Building a "snap-in" framework Hi, My company is building a suite of applications in VB.NET. Ideally, we would like to build a base application framework (like the Windows MMC) that can accept these applications as "snap-ins". This would allow us to then deploy applications as they are developed, and permit the user to add this new functionality without requiring a new build and the headaches associated with an updated application rollout. If anyone has any experience with this kind of application framework, I'd love to hear your thoughts. Links are also welcome, as I am compiling a notebook of ideas and approaches. Please also let me know if you need more information. TIA, Derrick Tag: returning the value of the last record in a dataset Tag: 79428
  - 3
    - GroupBox not showing Controls (sometimes) Sometimes Controls that have been added to a GroupBox do not show up. What I am doing : 1) I am not using the designer, but create all the Controls per hand: groupBoxProdukt_01 = new System.Windows.Forms.GroupBox(); etc. for all other Controls. After setting Font and Text values I then add them to the Panel: pnPanelControls.Controls.Add(groupBoxProdukt_01); pnPanelControls.Controls.Add(groupBoxProdukt_02); pnPanelControls.Controls.Add(groupBoxProdukt_03); pnPanelControls.Controls.Add(groupBoxProdukt_04); pnPanelControls.Controls.Add(groupBoxProdukt_05); groupBoxProdukt_01.Controls.Add(comboBoxProdukt_Art); groupBoxProdukt_01.Controls.Add(textBoxProdukt_Name); groupBoxProdukt_01.Controls.Add(textBoxProdukt_Text); groupBoxProdukt_02.Controls.Add(comboBoxProdukt_Lieferant); groupBoxProdukt_02.Controls.Add(labelProdukt_Preis); groupBoxProdukt_02.Controls.Add(textBoxProdukt_Preis); groupBoxProdukt_02.Controls.Add(labelProdukt_Unit); groupBoxProdukt_03.Controls.Add(textBoxProdukt_Verpackung); groupBoxProdukt_03.Controls.Add(comboBoxProdukt_Verpackung); groupBoxProdukt_04.Controls.Add(textBoxProdukt_Haltbarkeit); groupBoxProdukt_04.Controls.Add(comboBoxProdukt_Haltbarkeit); groupBoxProdukt_05.Controls.Add(labelProdukt_SollMenge); groupBoxProdukt_05.Controls.Add(textBoxProdukt_SollMenge); pnPanelControls.Controls.Add(button_Produkt_Shopping); etc for Controls of other Dialogs. Attribute Visiable is set to false for all Controls. An OnSize Method sets size and Location at run time. and the Controls that should be shown are set to Visiable= true; There are four different types of Dialogs, one of which, will be shown. The above shown "Produkt" is one with 5 GroupBoxes. The other Dialogs have one GroupeBox and show fine, Produkt shows only the first GroupBox with the desigered Controls. The other GroupBoxes are shown but are empty. The Buttons outside the GroupBoxes also show. When I first tried this I placed all Controls on to the Panel and the Controls show up. But if I called another Dialog before "Produkt" and then called Produkt then ALL the GroupBoxes where empty. When setting the GroupBox to visiable=false, the Controls showed in the proper position. I found out that the Controls should be added to the GroupBox hoping this would solve the problem. But it works only with the first GroupBox and not the others that are set to visable. Mark Johnson, Berlin Germany mj10777@mj10777.de Tag: returning the value of the last record in a dataset Tag: 79424
  - 4
    - If... Else or Case? when use one or the other Somebody know when is recommended to use If Else condition and when is recommended to use Case? Thanks a lot AA Tag: returning the value of the last record in a dataset Tag: 79421
  - 5
    - How do I set read timeout value for a socket? If I use TCPClient, it's straightforward to set the read timeout value for reading the associated stream: TcpClient myClient = new TcpClient(myaddr, myport); myClient.ReceiveTimeout = 5000; NetworkStream myClientStream = myClient.GetStream(); myClientReader = new StreamReader(myClientStream ); However, if I've just accepted a socket connection via a listener, the situation is a bit different. I clientSocket = server.AcceptSocket(); NetworkStream myClientStream = new NetworkStream(clientSocket ); myClientReader = new StreamReader(myClientStream); I'd like to do something like this: clientSocket.ReceiveTimeout = 5000; but there is not such method on sockets. So how can I do the equivalent operation of setting the timeout for a socket like I can do with a TcpClient object? Tag: returning the value of the last record in a dataset Tag: 79420
  - 6
    - Encrypt to readable text I want to encrypt something and use the result as a registration key in my program, so it needs to be readable,but all of the encryption methods I have tried return unreadable strings. I need an encryption method that limits the result to chars that can be easily typed in via a standard keyboard. Thanks in advance, ~Logan Tag: returning the value of the last record in a dataset Tag: 79418
  - 7
    - Access data types in collections by reference // Example public struct SomeData { public int X; public int Y; public SomeData(int x, int y) { ... } } ... Hashtable table = new Hashtable(); SomeData sd = new SomeData(1, 2) table.Add(1, sd); // this of course does not work, cause is passed by value // but is there a way, or I need a class to encapsulate data types (stupid solution) ((SomeData)table[1]).X = 2; Tag: returning the value of the last record in a dataset Tag: 79415
  - 8
    - Windows Form Validation On an application, I have several boxes and I want to validate such that someone can't enter a number too big. However, once they do enter a number in that box, I want to immediately do something else (dynamically populate a list box). I have been able to use Text1Validating with e.Cancel=True to stop then from leaving the field, but when I do Text1Changed it is still called. Am I perhaps using the wrong events? Also, I would like to beep and select all text in that textbox or somehow otherwise alert the user that they are attempting something invalid, how best to handle this? Tag: returning the value of the last record in a dataset Tag: 79413
  - 9
    - Custom paging and 190,000 record Hi guys , i'm writing a web applications that search for a word in 190,000 records (very large articles). my database size is ~2 Gb. i used of normal paging and show 10 record in each page but the application was so slow. i search for custom paging and found some articles wich use of this solution : 1.create a temp table and then copy all of the records in that table. 2.select a range of records from this temp table (correspond to the page number) now , i think if i copy all of these records to a temp table and select a range from the temp table , my application will be slower !! so , what's the best solution for my problem? Tag: returning the value of the last record in a dataset Tag: 79411
  - 10
    - XMLSerialization of an object Hi! This has been bugging me for days now... I need to xmlserialize an object which contains a collection/hashtable/array/whatever of childobjects. -ParentObject ---Hashtable/Array/Collection -----ChildObject -----ChildObject -----ChildObject ... I use this code: Dim formatter As New System.Xml.Serialization.XmlSerializer(_databaseSettings.GetType) Dim settingsFile As New System.IO.FileStream("Settings.xml", IO.FileMode.Create) Try formatter.Serialize(settingsFile, _databaseSettings) Catch ex As Exception MessageBox.Show(ex.Message) Finally settingsFile.Close() End Try <Serializable()> _ Public Class DataBaseSettings Public Test As String Public Items As Hashtable End Class When I try to run the code, I get an error when dimming the new formatter. The error is: Additional information: There was an error reflecting type 'MyWinApp.Form1.DataBaseSettings'. If I comment out "Public Items As Hashtable" serialization works just fine, so the hashtable is the problem. What am I doing wrong? Later I need to store objects in the hashtable. These are also serializable individually. Do I need to do more than just add them to the hashtable? Thanks in advance Klaus Tag: returning the value of the last record in a dataset Tag: 79410
  - 11
    - Persisting changes to a data store I am not exactly sure the best way to show my example so please forgive me if this is not typical. I have the following two tables Medications and Perscriptions. Medications: [MedID(table key)] [Name] Perscriptions: [PerID(table key)] [MedID(key to Medications)] [Datefilled] When I go to create a medication for the first time it is also a perscription. My question is how do you get the unique MedID key after the table is updated so that it may be used in creating a new row in the Perscription table? In VB for Acess I was able to do this by making changes to a recordset, updating the recordset and then moving to the lastmodifed row and getting the newly entered MedID from that row. In Visual C#, I believe that a unique key is not created until an Update command is issued to the dataadapter and dataadapters don't have a "move" method. Thank you in advance, Eric Tag: returning the value of the last record in a dataset Tag: 79399
  - 12
    - Validating / enumerating ISO currency symbols Hi, is there a method to validate a given 3-letter ISO currency code, eg AUD,USD etc and retrieve associated data such as symbol ($ etc) and # of decimals? Or a way of enumerating thru the known set of these would be good enough. I can only see these features via a culture, usimg System.Globalization.RegionInfo.CurrentRegion.CurrencySymbol. I suppose that a way of enumerating thru all known cultures would also suffice. Any ideas? TIA Radek Tag: returning the value of the last record in a dataset Tag: 79397
  - 13
    - Add Dotnet Framework to installation package Hi, How to Add Dotnet Framework to the installation package? Thanks KS Tag: returning the value of the last record in a dataset Tag: 79395
  - 14
    - Multiple concurrent asynchronous writes on a Stream (NetworkStream Here's a (I think) simple question: If I issue multiple async writes on a NetworkStream, is the data guaranteed to be sent in the correct order? i.e. stream.BeginWrite(.. data A ...); stream.BeginWrite(.. data B ...); Will data A always be completely sent before B is sent? I figure/guess no, but it would be useful if BeginWrite could be used like this... Thanks for listening Tag: returning the value of the last record in a dataset Tag: 79394
  - 15
    - dataset.readxml performance problem Service Pack 3 beta I have a 100k xml file and I am attempting to read it into a dataset using dataset.readxml My xml file DOES have several nested nodes. However, none of the nodes have more than 10 attributes. I am experiencing 10-12 seconds time to load the xml document into the dataset. Loading the schema first helps--but minimally (approx. 1-2 seconds) We were previously using SP2, however, there is a known bug with SP2 where (under certain circumstances), only every other node is read into the dataset. Are there plans to improve the performance of the dataset.readxml call. Does anyone have thoughts regarding improving this performance issue. Thanks in advance Tag: returning the value of the last record in a dataset Tag: 79390
  - 16
    - Resource manager load resources from multiple satellite assemblies? Is it possible for a resource manager to load resources from more than one satellite assembly at a time? Tag: returning the value of the last record in a dataset Tag: 79389
  - 17
    - String object optimization in Framework 1.1 compared to 1.0 Hi, all... The question I have concerns string objects and how they are executed by CLR. Based on an article written in 2002 (last updated Dec 2003) http://www.codeproject.com/dotnet/strings.asp , it is more advisable to use StringBuilder class than the String object to manipulate strings in Tag: returning the value of the last record in a dataset Tag: 79386
  - 18
    - GetReferencedAssemblies problem Hi, I used that function GetReferencedAssemblies to obtain the referenced assemblies in my vb.net project...But the problem is that I have twice referenced of this libraries... system.windows.forms (1.0.5000.0 and 1.0.3300.00) system.drawing (1.0.5000.0 and 1.0.3300.00) mscorlib (1.0.5000.0 and 1.0.3300.00) Why ? Do you have a solution. Thank in advance. Tag: returning the value of the last record in a dataset Tag: 79383
  - 19
    - Changing FileVersion with build Is there a way to programmatically update the FileVersion (not Assembly Version) with each build TIA Tag: returning the value of the last record in a dataset Tag: 79382
  - 20
    - Storing Photos in Active Directory - jpegPhoto attribute - User class Has anyone tried this in VB .NET or via VBScript? Can it be done? How do we handle retrieving a binary data format (the photo) using ADSI or VB .NET? All my searching on the net yielded no useful results except for a half completed Perl script which claimed to be able to upload and download photos stored in AD as part of the User account. Tag: returning the value of the last record in a dataset Tag: 79377
  - 21
    - Winforms I've read and seem to find support for the notion that winforms is stillborn. Anybody else share the same feeling? ie, it didn't lift off like Asp.net or console apps. Is this (winforms) being used widely in industry. What would make an author stake a claim that winforms was unsuccessful? (can't remember the author btw or the specific article). anybody? -- Regards, Alvin Bruney [ASP.NET MVP http://mvp.support.microsoft.com/default.aspx] Got tidbits? Get it here... http://tinyurl.com/27cok Tag: returning the value of the last record in a dataset Tag: 79373
  - 22
    - Referencing Binaries (Copy Local False) without GACing Hi, Is there a way for a web application (ASP.NET) to reference binaries and use it without having copy local set to true or GACing the binaries. If yes, how would I do it. TIA Tag: returning the value of the last record in a dataset Tag: 79368
  - 23
    - Datagrid Not selecting a the selected row I have a Datagrid and do a databind to populate the grid and have a select button to select a row and It was working fine. Suddenly whenever I do select a row it is not selecting the selected row. meaning the data gets reorganized (example when I first load the data, I want to select the fifth row and after selecting the row eventhough it is selecting the fifth row the data is not the same). I tried redoing the datagrid and it is still not working? I have datagrid on other pages it is working except on one page. It is urgent can anybody help me please. Tag: returning the value of the last record in a dataset Tag: 79367
  - 24
    - iSCSI target implemented in .Net I am interested in developing an iSCSI target component, but instead of writing it as a device driver, I wish to implement it as a Windows service developed in .Net (and C#). I understand that Microsoft provides an iSCSI client, but they do not provide the target code at all. Basically my iSCSI target service, at least in the first version, will simply direct the I/O requests to a local disk partition, permitting the iSCSI protocol to be used to access a remote partition, rather than the Windows 'share' mechanism. I need information on how a .Net/C# service could define itself as an iSCSI target and then ensure that it receives the packets from any iSCSI client that connects to it. I have the iSCSI protocol document, but it is a bit vague in this area. -ken Tag: returning the value of the last record in a dataset Tag: 79366
  - 25
    - Target schema I setup a custom template page for VS.NET 03 (took a little painful tweaking but it works). Only problem is, my template doesn't including the head tag which contains the vs_targetSchema. The reason is become in these pages I only design the middle content, everything else gets layered on at run time since the code behind class inherits from a class that I wrote (which inherits from page) Is there any work around for this? any other way to set the vs_targetSchema without having it in the Html Code? Thanks Tag: returning the value of the last record in a dataset Tag: 79365

I need help with this as i am spending far too much time on it. Moving
across from vba to .net hasnt been easy..

I need to return the value in a field of the last record in a sorted
dataset.

A brief example of anyone would be really helpful..

i would approach this by sorting the records and performing a count on
the records. Then returning the value in:

dataset.tables("MyTable").columns("MyCol")..

and also using (dataset.tables("MyTable").count) to get the last
record

help please!!

Top

Re: returning the value of the last record in a dataset by Ben

Ben
Mon Jul 26 11:36:39 CDT 2004

dim rows as DataRowCollection
rows = dataset.Tables("MyTable").Rows
value = rows(rows.Count - 1)("MyCol")

Ben Lucas
Lead Developer
Solien Technology, Inc.
www.solien.com

"Winshent" <winshent-google@yahoo.co.uk> wrote in message
news:f511cd36.0407260629.5ed326e3@posting.google.com...
> I need help with this as i am spending far too much time on it. Moving
> across from vba to .net hasnt been easy..
>
> I need to return the value in a field of the last record in a sorted
> dataset.
>
> A brief example of anyone would be really helpful..
>
> i would approach this by sorting the records and performing a count on
> the records. Then returning the value in:
>
> dataset.tables("MyTable").columns("MyCol")..
>
> and also using (dataset.tables("MyTable").count) to get the last
> record
>
> help please!!

Top