Transpose 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
    - sql2comega & System Tables Hi, Does anybody know how to generate (sql2comega.exe) wrapper DLL for System tables (for example for sysobjects) ? -- Thanks, Maxim Tag: Transpose Dataset? Tag: 95027
  - 2
    - Is there a max limit on the number of Managed Windows Services that can be run on Win 2000 server? We have a situation where we keep hitting below error 1053 The .......... service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion. whenever we try to start managed windows service above a specific number. On one server (SERVER1) it is 25, on another (SERVER2) it is 27. There are 9 different services, each 9 constitutes a release version. Were are trying to use the same server to handle multiple versions, however, we have this limitation where we can only get a max of 3 sites (3 x 9services) at best running. It does not matter which services are running, when we reach this limit no other managed service will start. If I stop one, I can start another. I don't believe it is a licensing issue, we do use Crystal however, the same issue occurs if I do not start those services that use the Crystal dll's. The environment is Windows 2000 server. Framework is 1.0. Any help on this is much appreciated. Rgds Yucel Tag: Transpose Dataset? Tag: 95025
  - 3
    - Why does aspx pages crash my machine? I'm WinXP Pro. When I reference http://127.0.0.1/mysite/webform1.aspx (newly created page in VS.NET), IE stalls then everything freezes. I can click the title bar of applications but that is all. If I move beyond the title bar, I get the hour glass. Nothing responsds except the mouse. I have to turn the machine off at this point. Running .NET 1.1. I can't find any one that knows why this happens. Any suggestions? Thanks, Brett Tag: Transpose Dataset? Tag: 95020
  - 4
    - Custom counters file view is out of memory. We are using Microsoft's Enterprise Instrumentation Framework. The TraceSessions.config file just started logging this error in the Application Log when it gets saved. It didn't do this until about two days ago. Unable to read and validate the configuration file C:\Inginix\Logs\TraceSessions.config. The following errors were returned: Custom counters file view is out of memory. Can someone explain to me what this is and how to fix it? I can post the file if that would help. Thanks, John Tag: Transpose Dataset? Tag: 95019
  - 5
    - C# Language Chat next Thursday, 4/21 @ 1pm Pacific Time C# Chat: The C# Language "Want to know more about anonymous delegates in C# 2.0, or our design rationale for them? Perhaps you have some great ideas you'd like to share with other C# users or the C# language team. Join the C# team for all that and more - it's all up to you!" C# Team members will be there. We're there predictably - every two weeks. Hopefully that means we'll be better able to be there when you need questions answered. :0) Mark your calendars for this chat and other future C# chats! This chat's entry on the schedule: http://msdn.microsoft.com/chats/#05_0421_VB_CCL Add this chat to your calendar: http://msdn.microsoft.com/chats/outlook_reminders/05_0421_VB_CCL.ics The chatroom itself: http://msdn.microsoft.com/chats/chatroom.aspx Other upcoming developer chats: http://msdn.microsoft.com/chats/ Scott Nonnenberg Program Manager Visual C# Team Tag: Transpose Dataset? Tag: 95018
  - 6
    - Help with Addin I am trying to create an addin that will loop through all my projects in a solution and all the forms with in a project to set a form property. How can I test the project item to see if it is a form? foreach (ProjectItem p in theProject.ProjectItems) { System.Diagnostics.Trace.WriteLine("ProjectItem = " + p.Name); // Check to see if its a c# file Is there a better way if (p.Name.Substring(p.Name.Length - 3, 3) == ".cs") { } } Tag: Transpose Dataset? Tag: 95016
  - 7
    - Printing and drawer information When printing in .NET, is there any way to determine if a particular drawer is out of paper, and if so, halt printing until the user puts paper in that drawer? -- Todd Acheson Tag: Transpose Dataset? Tag: 95011
  - 8
    - Regex parsing e-mail question. I basically am trying to match something like keyword: (the : and space is a marker. I want everything after that all the way up to the next Keyword: (where keyword HAS to begin a new line. I want everything before the next keyword. (\: ).*(\n[a-zA-z]) comes extremely close except for 2 things. The most important is that it is unable to match patterns where the "content" that I want spans multiple lines . For example in an e-mail it would skip over Received: from unknown (HELO barracuda.domain.com) (127.0.0.1) by 192.168.2.195 with SMTP; 24 Feb 2005 19:16:52 -0000 Also I am wondering if there is a way to specify that I want everything "after" the \: and before the \n . Any help would be greatly appreciated. Below are sample regex and sample input that I am trying to use. and yes google may have bastardized some of the input Regex that I have tried. The first one has produced the closest results. (\: ).*(\n[a-zA-z]) (\: ).*[(\n\s)].*(\n[a-zA-z]) (\: ).*[(\n\s)].*[^\n[a-zA-Z]]*(\n[a-zA-Z]) ---------------------------------------- Input ------------------------------------------- Return-Path: <u...@domain.com> Delivered-To: u...@domain.com Received: (qmail 21118 invoked from network); 16 Mar 2005 20:41:33 -0000 Received: from unknown (HELO barracuda.domains.com) (192.168.192.194) by 192.168.2.195 with SMTP; 16 Mar 2005 20:41:33 -0000 X-ASG-Debug-ID: 1111005918-25079-3-0 X-Barracuda-URL: http://barracuda.domains.com:8000/cgi-bin/mark.cgi X-ASG-Whitelist: Sender X-ASG-Whitelist: Sender X-ASG-Whitelist: Sender Received: from domaindev1.domain.local (192-168-1-100.generator.isp.com [192.168.1.100]) by barracuda.domains.com (Spam Firewall) with ESMTP id AFE2D20A2F39; Wed, 16 Mar 2005 14:45:18 -0600 (CST) Received: from tetco634 ([192.168.5.193]) by domaindev1.domain.local with Microsoft SMTPSVC(6.0.3790.211); Wed, 16 Mar 2005 14:45:44 -0600 From: "user bleah" <u...@domain.com> To: <u...@domain.com> Cc: <user.not...@domain.com>, <user.supp...@domain.com>, <anotherper...@somebodyelse.com> X-ASG-Orig-Subj: New User Signup Subject: New User Signup Date: Wed, 16 Mar 2005 14:45:44 -0600 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00100_01C52A36.D545F720" X-Mailer: Microsoft Office Outlook, Build 11.0.6353 Thread-Index: AcUqaR/LUDk7Lu7bQdu3vY6SjqLPAQ== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 Message-ID: <domainDEV1RapPodByDl00000...@domaindev1.domain.local> X-OriginalArrivalTime: 16 Mar 2005 20:45:44.0462 (UTC) FILETIME=[1FDFCAE0:01C52A69] X-Virus-Scanned: by Barracuda Spam Firewall at domains.com X-Barracuda-Spam-Score: 0.00 X-Barracuda-Spam-Status: No, SCORE=0.00 using global scores of TAG_LEVEL=3.5 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=6.0 This is a multi-part message in MIME format. ------=_NextPart_000_00100_01C52A36.D545F720 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Transfer-Encoding: 7bit Tag: Transpose Dataset? Tag: 95000
  - 9
    - MVP please help - WSAENOBUFS problem Hi, My application uses System.Net.Sockets.Socket class (asynchronously) to implement record sharing. There is a central task that accepts two way connections from multiple clients. There are usually 20-30 sockets open at a given time, but possibly as may as 50-60. As the client uses the software, it usually works fine for several hours, then slows down and eventually generates a WSAENOBUFS error (An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full.) Pertinent information: 0) WSAENOBUFS is always reported by client task and never server task. 1) When a client shuts down, it does: Socket.Shutdown( SocketShutdown.Both ); Socket.Close(); 2) Sockets are opened by client and kept open for the life of the client. 3) Messages sent back and forth are always quite small, usually 40-160 bytes. An average of 40-50 messages in total per minute are sent at peak usage. 4) Maximum number of connecting tasks ranges from 4-25 or so. 5) Server task is always OK. This feels like a resource leak of some sort on the client side, but it seems as though the code is as per the documentation. Can anyone suggest what might be wrong or think of further investigation to undertake? Thanks in advance. Brian Hough Tag: Transpose Dataset? Tag: 94993
  - 10
    - Is sqldmo.dll freely redistributable? I am making a SQL Server management tool and I want to know if I can use SQLDMO and redist or if I have to do things the "hard" way. Thanks for the help, Tom P. Tag: Transpose Dataset? Tag: 94991
  - 11
    - Setup Error Failed to lad resources from resources file Please check your setup Hello I need some help, I have a multi threads graphic application, with dataset, data binding, sockets. Some time and each time on the same 3 computer the message (total computer around 15) : Setup Error Failed to lad resources from resources file Please check your setup Arrived randomly. I have a try catch that around the application.Run But my "try catch" catch nothing I will try to see the problem with remote debbuging, but if anyone can tell me a tips It was great Thanks Tag: Transpose Dataset? Tag: 94989
  - 12
    - MenuItem Name I need to find the Name of a MenuItem. Does anyone know how that is done? Thore Berntsen Tag: Transpose Dataset? Tag: 94987
  - 13
    - Exe launch it automatically when windows start I've an exe created with vb .net and i want to launch it automatically when windows start Do you know if there are alternative way to do it instead of put it in "automatic execution" or in the "run" Key? Thank You Tag: Transpose Dataset? Tag: 94986
  - 14
    - Converting enum Keys value to string I am saving the enum value of specific keys to an xml file which i then need to get the string representation. I believe KeysConverter is there for that but i have trouble using it for my purpose. i want to give it a value and have it spit out its Keys equivilancy for example. 121 -> Keys.F10 I am not sure if i am playing with the right function or not but any advise or suggestions would be appreciated :) Tag: Transpose Dataset? Tag: 94983
  - 15
    - Register ocx Hello I want to write code in dotnet which register an ocx (I don't want to use this ocx in dotnet). Exist a class in dotnet for this or have someone an example to do this? Thanks Albert Krüger Tag: Transpose Dataset? Tag: 94978
  - 16
    - When would XQuery be available in the .Net framework? If the W3C recommendation status for XQuery won't be established until 2006, how will that impact the release of XQuery (System.Xml.Query namespace)? I understand that the namespace has been withdrawn from VS2005/beta 2. Is there a release plan for XQuery in the framework. Also, how will this impact SQL Server 2005? Thanks, -Hal hal.hayes@REMOVE_CAPS_AND_INVALIDacritech.com (www.caparea.net) Tag: Transpose Dataset? Tag: 94968
  - 17
    - Crystal Report Deployment After installing my application, I get the following exception when trying to run an embedded report: System.TypeInitializationException: The type initializer for "CrystalDecisions.CrystalReports.Engine.ReportDocument" threw an exception. ---> System.Runtime.InteropServices.COMException (0x80040154): COM object with CLSID {CF76A644-314B-404D-8D45-F08B51FF990B} is either not valid or not registered. Sounds like the installation didn't work correctly, although there were no errors. Any clues appreciated, particularly definitive documentation for Crystal deployment. A lot of it is fragmented and contradictory. Tag: Transpose Dataset? Tag: 94967
  - 18
    - VC6 - .net class browsing Hello, I recently switched from VC6 to .net 2003. In the class browsing window I miss the 2 options (in the contest menu) "called by" and "calls" referred to any member function. They are very useful to quicky search where are the calls to a certain function and vice versa. They are present by default in VC6 can you tell me where to find/how to activate in .net? is this feature still present?? thanks ricky Tag: Transpose Dataset? Tag: 94965
  - 19
    - whidbey beta 2 informations I've read that the beta 2 of whidbey will be disponibile at the end of this mounths Is it true??? Where Can I find more informations about this?? Thanks Tag: Transpose Dataset? Tag: 94962
  - 20
    - CreateInstance OK but calling dynamic method fails I am trying to create a class at runtime from some library and call its method dynamically but it keeps failing when calling the method... In a separate DLL, I have a class as follows namespace MyClassLibrary { public class SimpleClass { public string SayHello() { return "Hello"; } } } In a console app, I load an assembly from my DLL file, create a SimpleClass object myAssembly = Assembly.LoadFrom(MyDLLFilename); object someObject = myAssembly.CreateInstance("MyClassLibrary.SimpleClass"); so far so good, it looks like someObject is created but then it fails if I try to cast my object to a SimpleClass in order to call its properties... string MyString = ((MyClassLibrary.SimpleClass) someObject).SayHello(); Either there is a bug or I don't understand (I suspect the second!) Thanks for any help Eric Tag: Transpose Dataset? Tag: 94959
  - 21
    - What is the correct conection string for MSaccess? Hi. What is the correct connection string, for Msaccess Databases in Ado.Net? The Databases have Password, and locate in my PC. Thanks for all begin 666 dtto086.vcf M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..CMD='1O,#@V#0I&3CID='1O M,#@V#0I%34%)3#M04D5&.TE.5$523D54.F1T=&\P.#9 <')O9&EG>2YN970N E;7@-"E)%5CHR,# U,#0Q,U0Q-C(U-#-:#0I%3D0Z5D-!4D0-"@`` ` end Tag: Transpose Dataset? Tag: 94958
  - 22
    - Bug in ActiveDirectory access of .NET Framework Hi, I have an application in C# that manages users, shares and printers in the AD. This application sometimes runs on an error accessing the AD. This is not really reproducable, it happens often, but not always. Sometimes it runs on an error and later goes over the same code again and works. The error message is always a NullReferenceException on System.DirectoryServices.Interop.IAds.GetEx, for example: at System.DirectoryServices.Interop.IAds.GetEx(String bstrName) at System.DirectoryServices.PropertyValueCollection.PopulateList() at System.DirectoryServices.PropertyCollection.get_Item(String propertyName) at amt.user.UserManagement.getUserByDirectoryEntry(DirectoryEntry ADEntry) in c:\inetpub\wwwroot\amt\sharp\user\UserManagement.cs:line 2098 at amt.user.UserManagement.getUserByProperty(String Property, String domain) in c:\inetpub\wwwroot\amt\sharp\user\UserManagement.cs:line 1900 at amt.user.UserManagement.getUserBySAM(String SAM, String domain) in c:\inetpub\wwwroot\amt\sharp\user\UserManagement.cs:line 576 at replication.RootDSEReplicator.checkUserReplicationStatus(AddEntry entry) in c:\inetpub\wwwroot\amt\sharp\replication\RootDSEReplicator.cs:line 284 at replication.RootDSEReplicator.checkReplicationStatus(Object state) in c:\inetpub\wwwroot\amt\sharp\replication\RootDSEReplicator.cs:line 244 I haven't seen any pattern when this happens. The NulRef obviously doesn't happen in my code. It seems to happen in one case on this action: if(ADEntry.Properties["distinguishedName"].Value != null){ newUser.DN= ADEntry.Properties["distinguishedName"].Value.ToString(); } Any ideas what can cause this? What surprises me is, that the NullRef isn't thrown by my code, but from inside IAds. Regards Marco Tag: Transpose Dataset? Tag: 94955
  - 23
    - Install Framework I'm trying to install Framework in Removable Compact Flash, but the instalation ask to input Microsoft .NET Framework 1.1. What Can I do? Thanks Tag: Transpose Dataset? Tag: 94954
  - 24
    - Webpage Authoring Currently authoring with Frontpage 2002 on Windows XP Pro. I have been using Visual Basic.net (because I can afford it) for desktop applications, but do not own the whole VS.net suite. I would like to author, and manage if possible, my website in the Visual Studio.net environment primarily because I have issues with Frontpage. Is it possible to build the whole site in the VS.net environment? I would rather remain with Microsoft than switch to Macromedia Dreamweaver and Homesite for web authoring tasks. What other VS.net products should I be looking at in order to build a slick, fastloading, and fully interactive website that includes XHTML code, XML and RSS feeds, and web based applications, or do I already have the resources I need? Thank you, Dennis D., Webmaster, http://www.dennisys.com/ Tag: Transpose Dataset? Tag: 94953
  - 25
    - USB port Is it possible work with USB port directly with .NET ? Tag: Transpose Dataset? Tag: 94951
- Next
  - 1
    - DataBinding - null values if controll not touched Hello I'm binding untyped DataSet field to checkbox "Checked" property. (dataset is filled with data from MSSQL database, DB_FIELD can not be NULL) Here is the code snippet: b = new Binding("Checked", this.dataSet.Tables[0], DB_FIELD"); b.Format += new ConvertEventHandler(dbnull2null_checked); b.Parse += new ConvertEventHandler(dbnull2null_checked); this.myCheckbof.DataBindings.Add(b); and dbnull2null_checked is following: protected void dbnull2null_checked(object sender, ConvertEventArgs cevent) { if (cevent.Value.Equals(DBNull.Value)) cevent.Value = false; if (cevent.Value == null) cevent.Value = 0; } Unfortunetly, if the user did not changed value of the checkbox, database gets null (and throws an exception). If value is changed (to whatever value) everything is fine. How to fix it? I'm desperate :( -- Semper Fidelis Adam Klobukowski atari@gabo.pl Tag: Transpose Dataset? Tag: 94950
  - 2
    - Namespace usage I'm trying to figure out the best way to structure my code and how to use namespaces to organize it. I'm working on an application that will have a plugin architecture. It will have a main frontend application and some shared interfaces and utility classes. Then there will be the plugins themselves. The plugins will be standalone, so I don't need to include them in a namespace. However, I am thinking that I need a namespace for the main app and the shared assemblies. I've read through several books, and done some googling, but I haven't found anything that does much more than explain what namespaces are and then go on to describe the .NET namespaces. Nothing seems to explain the strategies of using namespaces in my own applications. Can anyone point me to some source of info on this? Thanks! Tag: Transpose Dataset? Tag: 94947
  - 3
    - HELP! Timeout when accessing Webservice. I have a solution that contains a web service and a web site. I was working on it all day Monday with no problems. Tuesday morning it stopped working, but ONLY when run from inside Visual Studio (VS). Now, when I run it from inside VS, my web site times out when trying to access the web service. The initial login page comes up OK so I enter my user name and password and hit enter, at that time the web site attempts to contact the web service, and that is when the time out error occurs. If I compile the solution and then load IE and access the website OUTSIDE of VS, everything works fine. After the timeout occurs my machine behaves very strangely. Applications that were already running continue to run, but I am unable to start any new applications even though the Start button continues to function. I cannot bring up the windows task manager and I cannot shut down windows. Ctrl-Alt-Del does nothing. My only option is to power the machine down. Here is what I have done so far to try to diagnose the problem (Note: nothing has helped!)... 1 - Restored a source backup from the weekend. 2 - Restored a source backup from last week. 3 - De-installed IIS and VS 2003, re-installed IIS and VS 2003. Because none of that helped, I then created a new solution. The first project was a web service called TestService with the following web method... <WebMethod()> _ Public Function TestMethod(ByVal YourName As String) As String Return "Hello " & YourName End Function ...and an asp web site with one page with one label with the following code... Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim WS As New localhost.TestService Me.Label1.Text = WS.TestMethod("Bob") End Sub After building the solution I load IE and go to http://localhost/testsite/webform1.aspx I get what I expected, a message saying "Hello Bob". But, from inside VS, I set the startup project to the web site and run it I STILL get a timeout accessing the web service. Any ideas? I can only think of one final option, and that is to rebuild the entire machine! RichardF Tag: Transpose Dataset? Tag: 94945
  - 4
    - ADO 2.8 Slow Update Problem with VB.NET 2003 and Access2003 This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C53F6E.7EBC4FB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Everyone, I am having a problem using ADO 2.8 with VB.NET. I have one function = that opens an Access 2003 recordset and updates it. Then the next = function queries the same table to decide what the next id should be, = but the new record is not there. If I slow down execution by stepping = through the program then I can find the new record. These two actions = occur in separate functions and I have done everything I can think of to = force the update to occur immediately.. including, closing the recordset = and setting the variable to nothing. I stuck this into a VB6 app and it = ran perfectly. What is taking the update so long to complete? How can = I fix this problem? Thanks, Tony Here is the code: As you can see the two action occur in a loop. Private strData() as String Private TransNum as string Private Sub DoMain() ts =3D New StreamReader(GetAppPath() & "upload.txt") Do While ts.Peek >=3D 0 strData =3D Split(ts.ReadLine, ",") TransNum =3D GetTransNum(strData(8)) AddRecord() Loop End Sub Private Function GetTransNum(ByVal TransDate As String) As String Dim aConn As New ADODB.Connection, aRS As New ADODB.Recordset, = TransNum As Integer =20 aConn.Open(strConn) strSQL =3D "select max([Transaction Number]) as Trans from = transactions where " & _ "left([Transaction Number],8) =3D '" & TransDate & "' and = [Transaction Number] is not null" aRS.CursorLocation =3D ADODB.CursorLocationEnum.adUseServer aRS.Open(strSQL, aConn, CursorTypeEnum.adOpenStatic, = LockTypeEnum.adLockOptimistic) If aRS.EOF =3D True Then TransNum =3D 1 Else TransNum =3D VBS.Right(aRS("Trans").Value, 4) TransNum =3D CInt(TransNum) + 1 End If =20 GetTransNum =3D TransDate & Format(TransNum, "0000") End Function Private Sub AddRecord() Dim aConn As New ADODB.Connection, aRS As New ADODB.Recordset, strSQL = As String aConn.Open(strConn) strSQL =3D "select * from transactions order by [transaction number], = [line number]" aRS.CursorLocation =3D CursorLocationEnum.adUseServer aRS.Open(strSQL, aConn, CursorTypeEnum.adOpenStatic, = LockTypeEnum.adLockOptimistic) =20 aRS.AddNew() aRS("Item Number").Value =3D strData(0) aRS("Serial #").Value =3D strData(1) aRS("P O #").Value =3D strData(2) aRS("Account Number").Value =3D strData(3) aRS("Received").Value =3D strData(4) aRS("Returned").Value =3D strData(5) aRS("Issued").Value =3D strData(6) aRS("Job #").Value =3D strData(7) aRS("DateTime").Value =3D strData(8) & " " & strData(9) aRS("Transaction Number").Value =3D TransNum aRS.Update() aRS.Close() End Sub ------=_NextPart_000_0008_01C53F6E.7EBC4FB0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1491" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff background=3D""> <DIV><FONT face=3D"Courier New" size=3D2>Hi Everyone,</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Courier New" size=3D2>I am having a problem using ADO = 2.8 with=20 VB.NET.  I have one function that opens an Access 2003 recordset = and=20 updates it.  Then the next function queries the same table to = decide what=20 the next id should be, but the new record is not there.  If I slow = down=20 execution by stepping through the program then I can find the new = record. =20 These two actions occur in separate functions and I have done everything = I can=20 think of to force the update to occur immediately.. including, closing = the=20 recordset and setting the variable to nothing.  I stuck this into a = VB6 app=20 and it ran perfectly.  What is taking the update so long to = complete? =20 How can I fix this problem?</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Courier New" size=3D2>Thanks,</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2>Tony</FONT></DIV> <DIV><FONT face=3D"Courier New"></FONT><FONT size=3D2> </DIV> <DIV><BR><FONT face=3D"Courier New">Here is the code:  As you can = see the two=20 action occur in a loop.<BR><BR>Private strData() as String<BR>Private = TransNum=20 as string<BR><BR></FONT></DIV></FONT> <DIV><FONT face=3D"Courier New" size=3D2>Private Sub = DoMain()<BR>   ts =3D=20 New StreamReader(GetAppPath() & "upload.txt")<BR><BR>   Do = While=20 ts.Peek >=3D 0<BR>      strData =3D = Split(ts.ReadLine,=20 ",")<BR>      TransNum =3D=20 GetTransNum(strData(8))</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2>     =20 AddRecord()<BR>   Loop<BR><BR>End Sub<BR><BR></DIV></FONT> <DIV><FONT face=3D"Courier New" size=3D2>Private Function = GetTransNum(ByVal=20 TransDate As String) As String<BR>   Dim aConn As New=20 ADODB.Connection, aRS As New ADODB.Recordset, TransNum As=20 Integer<BR>   <BR>   = aConn.Open(strConn)<BR>  =20 strSQL =3D "select max([Transaction Number]) as Trans from transactions = where "=20 & _<BR>   "left([Transaction Number],8) =3D '" & = TransDate &=20 "' and [Transaction Number] is not null"<BR><BR>   = aRS.CursorLocation=20 =3D ADODB.CursorLocationEnum.adUseServer<BR>   = aRS.Open(strSQL, aConn,=20 CursorTypeEnum.adOpenStatic, LockTypeEnum.adLockOptimistic)<BR></DIV> <DIV><FONT face=3D"Courier New" size=3D2>   If aRS.EOF =3D = True=20 Then<BR>      TransNum =3D 1<BR>  =20 Else<BR>      TransNum =3D = VBS.Right(aRS("Trans").Value,=20 4)<BR>      TransNum =3D CInt(TransNum) +=20 1<BR>   End If<BR>   <BR>   GetTransNum = =3D=20 TransDate & Format(TransNum, "0000")</FONT></DIV><FONT = face=3D"Courier New"=20 size=3D2> <DIV><FONT face=3DArial></FONT><FONT face=3DArial></FONT><FONT=20 face=3DArial></FONT><FONT face=3DArial></FONT><FONT = face=3DArial></FONT><FONT=20 face=3DArial></FONT><BR>End Function</DIV></FONT> <DIV><FONT face=3DArial></FONT><FONT face=3DArial></FONT><FONT=20 face=3DArial></FONT><FONT face=3DArial></FONT><FONT = face=3DArial></FONT><FONT=20 face=3DArial></FONT><BR> </DIV> <DIV>Private Sub AddRecord()<BR>   Dim aConn As New = ADODB.Connection,=20 aRS As New ADODB.Recordset, strSQL As String<BR><BR>  =20 aConn.Open(strConn)<BR>   strSQL =3D "select * from = transactions order=20 by [transaction number], [line number]"<BR>   = aRS.CursorLocation =3D=20 CursorLocationEnum.adUseServer<BR>   aRS.Open(strSQL, aConn,=20 CursorTypeEnum.adOpenStatic, = LockTypeEnum.adLockOptimistic)<BR>  =20 <BR>   aRS.AddNew()<BR>   aRS("Item Number").Value = =3D=20 strData(0)<BR>   aRS("Serial #").Value =3D = strData(1)<BR>  =20 aRS("P O #").Value =3D strData(2)<BR>   aRS("Account = Number").Value =3D=20 strData(3)<BR>   aRS("Received").Value =3D = strData(4)<BR>  =20 aRS("Returned").Value =3D strData(5)<BR>   aRS("Issued").Value = =3D=20 strData(6)<BR>   aRS("Job #").Value =3D = strData(7)<BR>  =20 aRS("DateTime").Value =3D strData(8) & " " & = strData(9)<BR>  =20 aRS("Transaction Number").Value =3D TransNum<BR>  =20 aRS.Update()<BR>   aRS.Close()<BR><BR>End = Sub<BR></DIV></FONT><FONT=20 face=3D"Courier New" size=3D2> <DIV><FONT face=3DArial></FONT> </DIV> <DIV><FONT face=3DArial></FONT> </DIV> <DIV><FONT face=3DArial></FONT> </DIV> <DIV><FONT face=3DArial></FONT></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0008_01C53F6E.7EBC4FB0-- Tag: Transpose Dataset? Tag: 94935
  - 5
    - Enterprise Library Configuratiion Hi, I have a specific problem to store all configuration data in one central store I am currently using the Enterprise Library Framework but it needs a local config file to operate. Does anyone know a way I can store this config file in a central store that follows the configuration block design pattern? -- John Tag: Transpose Dataset? Tag: 94921
  - 6
    - Closing handle Hi, I've got the following problem: My current project consists of several clients and all of them use(read) a file, that is placed on a shared hard disk on one of my file servers (windows2k). So, every user that is logged on a computer the client software runs on needs access (exclusive) to this file. Now, the problem is, that sometimes the users leave the file in an open state - and do not close their handle - so no other client can access the file any longer. That's why I'm looking for a way to close all handles (even of remote clients) to a specific file "by violance". Is this possible? Thanks Peter Tag: Transpose Dataset? Tag: 94918
  - 7
    - Process.Start("http://www.microsoft.com") fails under Win2k Hi, I am trying to open a web page with the default browser from within a C# program. The code I am using is very simple: System.Diagnostics.Process.Start("http://www.microsoft.com"); This works fine in WinXP, but not on Win2k. On Win2k this line throws an exception: "the system cannot find the file specified" (or something along these lines). The above code also work fine on Win2k if the default browser is NOT MSIE. I have also tried to run Windows Explorer instead of IE with the URL as a parameter. This works on Win2k, but surprisingly not always, and gives the same exception occasionally. Is there a workaround? Thanks, Vlad Tag: Transpose Dataset? Tag: 94915
  - 8
    - Load Assembly From Windows Service I'm trying to Load an assembly from windows service. The Assembly is in GAC and I'm using the command ; Assembly.Load(assemblyName); But I'm getting the error: The assembly ... or one of its dependencies, was not found. I don't want to copy the required dlls to the path where windows service executable resides. Any Solutions? Tag: Transpose Dataset? Tag: 94914
  - 9
    - TcpClient Help!!! Hi! I made a connection through an object TcpClient (i'm using vb .net) So far so good... but when i want to close the connection, method close() doesn't work. I tried everthing!! Because this object is called into other class, i implemented Idisposable method.. and also nothing, i abort the thread and the result was the same. Some one knows how to kill the connection some other way, maybe using a shell command if know how to get the process id?... This is an example to show the problem... Dim GDFC As New GetDataFromClocks(Terminal, IPAddress, Port) Dim thGDFC As New Thread(AddressOf GDFC.getData) thGDFC.Start() While Not thGDFC.ThreadState = ThreadState.Stopped System.Threading.Thread.Sleep(250) End While 'GC.Collect() GDFC.Close() 'Inside GDFC dim mobjClient22 as new TcpCLient mobjClient22.Connect(IpAddress, CType(Port, Integer)) Tag: Transpose Dataset? Tag: 94913
  - 10
    - Reflection and XMLSerialization I have a C# App that allows users (other programmers) to load assemblies dynamically and invoke methods. The app itself uses a generic tools assembly (Tools.dll). If the user then uses the app to load the tools.dll assembly, any XML Serialization eventually called through Method.Invoke fails. I have verified this by simply removing Tools.Dll from the application and XML Serialization in the dynamically loaded tools.dll succeeds. The exception message is "Specified cast has failed." in the dynamically generatic XML serialization assembly. I expected the Assembly.LoadFrom might fail because the assembly was already loaded - however, tools.dll isn't loaded yet because it hasn't been used at that point in the program flow. I am confused as to why a reference to a DLL that isn't even loaded yet would cause XMLSerialization to fail. The pseudo code is as follows: // (Main app includes a reference to tools.dll - which is never loaded until this call:) Assembly assembly = null; try { assembly = Assembly.LoadFrom( "tools.dll" ); } catch( BadImageFormatException ) { // a regular DLL not an assembly - so skip it continue; } // blah blah blah - get the method the user wants to invoke from the assembly methodInfo.Invoke( assembly, null ); // if the method above calls Serialize or Deserialize, and exception is thrown. Simply removing tools.dll from the references list solves the problem - obviously however I need to use the tools provided in tools.dll so i can't do that. Somehow the reference to the assembly changes something however, I am lost and my google / usenet searches have failed me this time. Thanks, Todd Tag: Transpose Dataset? Tag: 94912
  - 11
    - datagrid column question is there a way to make an if statement for a datagrid column? i am currently filling a dataset from a mysql database and then putting it into the datagrid. one of the fields is "Status" and it has a 0 for Active and a 1 for Inactive. is there any way to make the datagrid display Active or Inactive instead of 0 or 1 without creating a datatable and importing the dataset to a datatable? the dataset has about 5,000 records and takes to long to create a datatable. thanx in advance. Tag: Transpose Dataset? Tag: 94910
  - 12
    - DirectX interferes with ODBC? I have noticed a very strange effect that DirectX has on ODBC data storage. Storing a DateTime object in a database is normally not a problem, but once a Direct3D device is created the stored times only have a 5 minute resolution! A few steps are required to reproduce the problem. First create a Microsoft Access ODBC data source. Connect to it in the following way: OdbcConnection connection = new OdbcConnection( "DSN=TestDB" ); connection.Open(); Add a table with a single DateTime column: OdbcCommand cmd = new OdbcCommand( "CREATE TABLE TestData ( Stamp DATETIME )", connection ); cmd.ExecuteNonQuery(); Insert the current time: OdbcCommand cmd = new OdbcCommand( "INSERT INTO TestData(Stamp) VALUES (?)", connection ); cmd.Parameters.Add( new OdbcParameter( "Stamp", OdbcType.DateTime ) ); cmd.Parameters["Stamp"].Value = DateTime.Now; cmd.ExecuteNonQuery(); So far everything works as expected. Now create a Direct3D device: PresentParameters para = new PresentParameters(); para.Windowed = true; para.SwapEffect = SwapEffect.Discard; Device dev = new Device( 0, DeviceType.Hardware, this, CreateFlags.SoftwareVertexProcessing, para ); Insert a new date/time in the database and you will notice that the stored time is no longer correct. Does anyone have a clue about what is going on? For the record: I'm using Framework 1.1 and DirectX 9.0c. Tag: Transpose Dataset? Tag: 94909
  - 13
    - No touch deployment through ISA server 2004 I have a problem with a no touched deployed application. When I deploy the application normally internally on a network it functions correctly. However when I place IIS behind a ISA server 2004 firewall the application doesnâ??t work. I can access web services, none .Net exe's, ASPX pages etc through the firewall but I can't use No touch deployment. The application partially gets through to the client, (580k or 3MB) end up in IEâ??s cache but then doesnâ??t start IEExec. Any ideas? Thanks Alec Tag: Transpose Dataset? Tag: 94907
  - 14
    - DataView Hi, is it possible to add a column to a DataView with includes the sum of two other columns? Thanks Tag: Transpose Dataset? Tag: 94906
  - 15
    - How to read a partially locked file Hi! I'm having problems reading a partially locked file. The writer app (a 3rd party app) writes new data at the end of the file every second and sets a file lock for the last record which could be 160 bytes. My app (the reader app) tries to read the new data but since FileStream is buffered I get IOException "the portion is locked by another process" when trying to read an unlocked area of the file. It seems that the buffer size is 4kb. The result is a lock exception when I try to read 1 byte that is within 4 kb before the real lock and that is not nice! Of course the FileStream should not throw a lock exception when reading an unlocked byte with a lock 3-4 kb ahead. Using an unbuffered FileStream should propably solve the problem, but I cannot find such stream in .NET. The nearest I can get is to specify the buffer size when creating the FileStream, but when specifying 0 it well be set to 8 automatically which means that I cannot read the last 8 bytes before the lock. And of course using unbuffered stream slows down a bit. Obviously there is a bug in the buffered stream, it should not throw when reading ahead. Any ideas someone ? Some code: Dim fInfo as New FileInfo(filename) Dim fs as FileStrem fs = fInfo.Open(FileMode.Open, FileAccess.Read, FileShare.ReadWrite) Dim br as New BinaryReader(fs) br.BaseStream.Position(<an unlocked address>) br.ReadByte() ==> IOException: "The process cannot access the file because another process has locked a portion of the file." -- Regards, Lars JÃ¶nson Tag: Transpose Dataset? Tag: 94902
  - 16
    - VB.Net and Sage Dear friends, I have a client which would like us to post data into SAGE Line 50. Are there any API or Controls or methods out there that you know off which would help us achieving the task Thanks Duncan Tag: Transpose Dataset? Tag: 94898
  - 17
    - Exception in Devenv.exe module ntdll.dll Hi, Recently my Visual Studio environment has been crashing very often (every 10 minutes or so) I have uninstalled and reinstalled VS2003 (7.1.3088) and still get a problem. Other components I have installed and use in my project are Active Reports, Janus Grid and DotNetBar. My version of DotNetBar is just a trial one. Don't know if any of these other products are causing problems or whether it's just within the standard environment. Please let us know if you can HELP! Tag: Transpose Dataset? Tag: 94893
  - 18
    - New Website Covering .Net Technologies Visit http://www.dotnetmatters.com - DotNet Matters - for articles on ASP.Net and other Microsoft.Net Technologies. Tag: Transpose Dataset? Tag: 94890
  - 19
    - Using winforms to update a server object to play tic tac toe I am writing an application to play tic tac toe using two winforms that access a game object on the server. I want the forms to be able to update the game object and poll the game object to see if it is that forms turn. Once it is a players turn, I would like that form to have focus to start it all over again until the game over flag is set. I have done some work with .NET Remoting, and Web Services but I'm a little stumped on how to best update the server object and poll it for changes from the two winforms. Once I have it working I would like to play this game on two computers. Any advice or pointers would be appreciated. Thanks -- Even the oldest books are still just out to those who have not read them Tag: Transpose Dataset? Tag: 94878
  - 20
    - .Net 2.0 B1 Serial port problem? Anyone had this problem? It seems IO.Ports.SerialPort generates an "The I/O operation has been aborted because of either a thread exit or an application request" exception if you try to close it when it's receiving lots of data. The following VB.Net console program reliably fails if there's a device sending full speed serial data at it. It works fine if the data is being sent more slowly. (less often) --------------------------------------------- Imports System.Threading Imports System.IO.Ports Module Module1 Sub Main() Dim comPort As System.IO.Ports.SerialPort Console.WriteLine("Creating new serial port") comPort = New IO.Ports.SerialPort("COM1", 9600, Parity.None, 8, StopBits.One) Console.WriteLine("Opening") comPort.Open() Thread.Sleep(1000) Console.WriteLine("Closing") 'The following line often fails with: The I/O operation has been aborted because of either a thread exit or an application request. comPort.Close() End Module Tag: Transpose Dataset? Tag: 94875
  - 21
    - Re: Returning a char* from a C++ DLL to C# Hello all, I have a problem in that I am trying to get a dynamically allocated char * that is returned via a parameter in a C++ DLL to C#. In other words in C++ I have: void foo(char *bar) { bar = new char[10]; } In C#, I haven't been able to decipher how to translate this char* into a string past using the prototype: // ... [DllImport("foo.dll", EntryPoint="foo", ExactSpelling=false,CallingConvention=CallingConvention.Cdecl)] private static extern void unsafe foo(char* bar); // ... Thanks so much for your help, Mark Tag: Transpose Dataset? Tag: 94874
  - 22
    - ANN: Reminder NetCF Online chat tomorrow Just a reminder that we'll be hosting an online chat tomorrow concerning Smart Device Programming with Visual Studio .NET 2003. We will be on hand ready to answer your questions, so bring 'em on! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Title: MVP chat: .NET Compact Framework and Smart Device Programming Chat Date: April 12th 10:00am - 11:00am Pacific Time Additional Time Zones: http://www.timeanddate.com/worldclock/fixedtime.html?year=2005&month=2&day=8&hour=10&min=0&sec=0&p1=234 Description: You know them from the newsgroups! You love them for their deep technical answers and charming wit! Please join these amazing Microsoft MVPs in this live chat regarding the .NET Compact Framework and the Smart Device Programming features of VS.NET. Please feel free to bring along your Smart Device Framework questions as OpenNETCF.org will be well represented in this chat. To join this chat, please log on via the main MSDN chat page at: http://msdn.microsoft.com/chats ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~-- -- Thanks! Michael Fosmire Community PM/MVP Lead, Windows Embedded This posting is provided AS IS with no warranties, and confers no rights. Tag: Transpose Dataset? Tag: 94863
  - 23
    - Object reference not set to an instance of an object. CAUSED BY..... I am saving pictures and files to a directory using VB.NET web pages. On my development machine everything works fine. Development machine is running XP Pro, VS.NET, .Net 1.1. When I post the pages on my web server I get the following errors. Object reference not set to an instance of an object. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. Server is running 2000 server, Vs.Net not installed, and .Net 1.0. What I have come to the conclusion is this code is throwing the error: strFileName = File1.PostedFile.FileName strFileName = Path.GetFileName(strFileName) I have System.IO declared. Any ideas as to why will work on my development machine and not from a client running off the server. Thanks you much, Brett Tag: Transpose Dataset? Tag: 94859
  - 24
    - User Controls don't appear in toolbar (solved) What is the magic incantation to get user controls to appear in the toolbar? I recently had to recreate my solution file because the IDE kept crashing while loading the solution. Ever since I did that, my controls have disappeared from the toolbar. When I add the project with the control's .dll, I can still get all the components to appear on the toolbar, but sadly all the controls are gone. I've tried all sorts of things - manually deleting and adding all sorts of files from my project - starting up NET many, many times. I remember reading somewhere that you had to have the source code open. AAAAAAARRRRRRRGGGGGHHHH OK, after trying with the source code open, I tried recompiling with the designer view open (rather than code view) and ... problem solved. I'm so glad that .NET makes sense. Anyway, I thought I would post this message - maybe it can save somebody else from wasting half a day while under a deadline. I'm finally back to .NET actually loading my project without crashing and even have access to my controls. Yippee. Tag: Transpose Dataset? Tag: 94857
  - 25
    - How to publish Interface? I've written an Interface, and am now ready to start using it in some classes. How do I compile/share the interface between projects? Tag: Transpose Dataset? Tag: 94856

Hi,

I have an aspx page that queries and displays data from an Excel file.
However, the entries inside this Excel file are in columns instead of rows.
Is there anyway I can "transpose" the dataset with ASP.Net?

I know I can transpose the Excel file before uploading it, but I'd just like
to find out if it can be done in ASP.Net.

Thank you.

Regards,
WB

Top

Re: Transpose Dataset? by Miha

Miha
Fri Apr 15 07:24:08 CDT 2005

Hi,

You probably mean to transpose dataset using ado.net.
No, it is not possible out of the box.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
SLODUG - Slovene Developer Users Group www.codezone-si.info

"WB" <WB@discussions.microsoft.com> wrote in message
news:5AB173C8-B393-4144-AE0F-92DBD8EA3CBC@microsoft.com...
> Hi,
>
> I have an aspx page that queries and displays data from an Excel file.
> However, the entries inside this Excel file are in columns instead of
> rows.
> Is there anyway I can "transpose" the dataset with ASP.Net?
>
> I know I can transpose the Excel file before uploading it, but I'd just
> like
> to find out if it can be done in ASP.Net.
>
> Thank you.
>
> Regards,
> WB

Top