Many said about PHP here, so I'll say something about MySQL. Guys, I can't imagine a database that has NO support for stored procedures (which is MySQL). All it gives you is tables and that's all. Phhhhh. Yes, PHP is very powerful scripting language, but has a lack of OOP support. Well yes, you can create kinda "classes" in PHP, but is this ALL you need in OOP? Where is inheritance? Where is protected/private/public members? This is not OOP. Maybe they added it in latest version (5 I guess), I dunno, the last one I worked with was PHP4 Philip Patrick Web-site: www.stpworks.com "Two beer or not two beer?" Shakesbeer

You should use the parameters collection to submit your parameters to the stored proc. SqlCommand cmd = new SqlCommand("mystoredproc"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@param1", "blahblah"); //replace @param1 with the name of your parameter cmd.Parameters.Add("@param2", "jamie's"); //replace @param2 with the name of your parameter cmd.ExecuteNonQuery(); Then the necessary convertions will be done automagically for you.

:confused: System.IO.DirectoryInfo.GetFiles() returns an array of FileInfo. You should be able to use the Length property of the array to find out how many there are. GetLength() is for multi-dimensional arrays; you can specify 0 for the dimension to get the length of a single-dimension array. -- Mike Dimmick

nevermind i got it

this should help , make sure to put your text file's location where it currently says C:\mytest.txt . VbCode: Imports System.IO '/// at the top of your form's code window ^^^^. '///////////////////////////////////////////// Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Dim sReader As StreamReader = New StreamReader(New FileStream("C:\mytest.txt", FileMode.Open, FileAccess.Read)) Dim x As Integer = sReader.BaseStream.Length MessageBox.Show("The Length of the text file is: " & x & " Characters") While Not sReader.Peek Console.WriteLine(sReader.ReadLine) End While sReader.Close() End Sub hope that helps:) Vb: Public Function TwinsOnWay(ByVal twins As String) As String Select Case twins Case "Gender" Return "Two Girls" End Select End Function

nevermind i got it fixed

Look at the help: osql -? Examples: osql -S_myserver_ -U_myusername_ -P_mypassword_ for supplying username and password or osql -E to use a trusted connection. Then you can also specify the scriptfile to be executed by adding the -i_scriptfile_ parameter. These options are case-sensitive.

With the latest SqlServer (sp3), If no instance name is specified, the default instance name MSSQLSERVER is used. However, the location will always be MyComputersName\MySqlServerName. This enables you to access the server across a network and is standard format for network connections like mapping drives etc. Why is this a problem? Regards Wayne Phipps Time is the greatest teacher... unfortunately, it kills all of its students

thats not exactly what im looking for. it is vb6 and the reason i came here was to find some help normally i would just use this one sort function but the problem is the elements in the array are all instances of the player class so not only do i need to find out the 1st 2nd and 3rd place winners but i need to know the names of them which makes it a little more noodle scratching than a normal array and the thing that sucks most is i can see the solution on the back of my brain well anyways if anyone has any ideas