quwiltw

I've got Enterprise Architect edition and it came with an example for both WinForm and WebForms. Check here or the equivelent location on your box: C:\Program Files\Microsoft Visual Studio .NET\Crystal Reports\Samples\Code\WinForms\VB

At the risk of offering an insulting answer... have you tried cd.CommandText = "SELECT * FROM Result WHERE User_ID=" & name ??? We can start with that and go from there.

Have you downloaded the ODBC.Net Provider? http://msdn.microsoft.com/downloads/default.asp?url=/downloads/sample.asp?url=/msdn-files/027/001/668/msdncompositedoc.xml

what is the data type in the database for PartNumber. You'll get this error if the partnumber column is really varchar and you try to select it as if it's an int. Obviously you'll need to surround it with single quotes if it's a varchar.

Thanks, I guess I could have just jumped over to evbf to find my answers:)

Anyone got any thoughts on setting their object references to nothing? I've found conflicting information on the subject: some say that the garbage collector is smart enough to clean up our mess and others say to use the old Set objXXX = Nothing like VB6. So far I've been safely assuming the former is correct, but just wondered if anyone has found different?

I've just done a couple searches and it says displaying results 1-3 of 3 results, but no topics are listed. Anyone else noticed this?

What is an "Embedded XML file"? and more importantly (if it's what I might imagine) why would you want it? A use-case please?

If you have all the commands set up on your data adapter, then it's Update() method that you're calling will handle the inserts/updates/deletes as necessary. Have you set all four commands on the dataadapter?

Maybe you could describe a little more of what's going on. I don't see a reason why your code you stop unless you showDialog(). As far as passing variables from one form to another, just remember forms are classes and you pass variables the same as you would with any other class. You'll need a reference from one to the other then create a property to set on the class.

Your evaluation version should do the trick. What version of VB.NET do you have? I've got enterprise sql server but I'm pretty sure there was a developer edition that came with my visual studio.net. Otherwise, there's always MSDE.

I just did this and, while I'm no assembly expert, there doesn't seem to be any difference. //000059: Dim s1 As New SimpleTest() IL_0001: newobj instance void WithTest.SimpleTest::.ctor() IL_0006: stloc.0 //000060: //000061: s1.FName = "Hello" IL_0007: ldloc.0 IL_0008: ldstr "Hello" IL_000d: callvirt instance void WithTest.SimpleTest::set_FName(string) IL_0012: nop //000062: s1.LName = "World" IL_0013: ldloc.0 IL_0014: ldstr "World" IL_0019: callvirt instance void WithTest.SimpleTest::set_LName(string) IL_001e: nop //000063: s1.Email = "tim@mailbox" IL_001f: ldloc.0 IL_0020: ldstr "tim@mailbox" IL_0025: callvirt instance void WithTest.SimpleTest::set_Email(string) IL_002a: nop //000064: s1.Phone = "88888" IL_002b: ldloc.0 IL_002c: ldstr "88888" IL_0031: callvirt instance void WithTest.SimpleTest::set_Phone(string) IL_0036: nop //000065: //000066: With s1 IL_0037: ldloc.0 IL_0038: stloc.1 //000067: .FName = "test" IL_0039: ldloc.1 IL_003a: ldstr "test" IL_003f: callvirt instance void WithTest.SimpleTest::set_FName(string) IL_0044: nop //000068: .LName = "again" IL_0045: ldloc.1 IL_0046: ldstr "again" IL_004b: callvirt instance void WithTest.SimpleTest::set_LName(string) IL_0050: nop //000069: .Email = "email" IL_0051: ldloc.1 IL_0052: ldstr "email" IL_0057: callvirt instance void WithTest.SimpleTest::set_Email(string) IL_005c: nop //000070: .Phone = "9999" IL_005d: ldloc.1 IL_005e: ldstr "9999" IL_0063: callvirt instance void WithTest.SimpleTest::set_Phone(string) IL_0068: nop //000071: //000072: End With IL_0069: ldnull IL_006a: stloc.1 //000073: End Sub IL_006b: nop IL_006c: ret } // end of method Form1::Button1_Click I left the source lines in so you can see the bottom set is using the with block. No apparent difference.

I was thinking that that's a compiler optimization and that the compiler should probably be smart enough to detect such a situation without having explicitly putting it in a With block. Guess Not?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcn7/html/vaconUsingWith.asp This link and a "Practical Standards" book I've got both say that using With... End With makes code faster/more efficient. Anyone got any idea why? Of course, they implemented it so I believe them, I'd just like to know why. It seems to me that a compiler would easily be able to recognize this and optimize just the same with direct property access.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemSerializableAttributeClassTopic.asp

Hmmm... Must be an XML thing. It serializes in binary fine.

Yep, I think I'm doing what I've read, and dumbed it down to be a fairly simple test. It has problems with any of my custom objects being in the arraylist. Public Class Form1 Inherits System.Windows.Forms.Form Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim cfl As New ArrayList() cfl.Add(New SimpleDate()) cfl.TrimToSize() Dim ser As XmlSerializer = New XmlSerializer(GetType(ArrayList)) Dim writer As TextWriter = New StreamWriter("adminSettings.xml") ser.Serialize(writer, cfl) writer.Close() End Sub End Class <Serializable()>Public Class SimpleDate Public SimpleDate As DateTime End Class

When I choose to Break, the locals screen highlights {Length=4} in red, if that helps...

Speaking of serialization, I'm having trouble serializing collections. I've got a custom object that inherits an arraylist which is filled with custom objects, I can serialize the single object fine but the custom collection gives me the following exception. Any ideas? An unhandled exception of type 'System.InvalidOperationException' occurred in system.xml.dll Additional information: There was an error generating the XML document.

Some of the best tutorials I've seen in .NET have been with C#, I can't believe you can't find some with a Google search. It seems that C# is so widely popular that I'm doing to mental conversion alot nowadays. This site has some pretty good ones. http://www.csharpfriends.com/Members/Main/Tutorials/get_letter.aspx?letter=d

Ahhh... the beauty of high speed access. The speed difference is negligible for me. I still think my lowest common denominator point is valid.

Is there anything that's available in the ms-help pages that aren't also available in the MSDN library online? If not, what's the benefit of doing this (which targets a smaller audience) over just pointing to the MSDN library (which seems like the lowest common denominator)?

You're correct that it's not exposed via a help button on the toolbar. But when you said... ... I switched to talking about "What's This?" as functionality rather than how you get to it. In that same response, you talked about Help->Contents, which I took you as talking about the regular old help (which I also have to support)

Yeah, I've got a requirement for tooltips too:) My customer was very active in the requirements analysis process, which I'm beginning to think was a bad thing:) My app is designed for internationalization too so the resource files will be there. BTW, Word, Outlook, Project, and TextPad, which are all targeted at dumb end users all have "What's This?" help on the main app level available. I tried your argument in the requirements gathering process and after getting a list of these sorts of apps that are examples, it's hard to argue.

"shouldn't require "What's This?""?, why not? Anyway, I think I will just look at putting it under the Help menu along with "Contents" I'll have to look at how to do that.