You pass in two parameters but you don't use them in the SQL statement. You then use a parameter (@333) that does not exist. Maybe somthing like this would work: SELECT BName from Borrower WHERE TaxID = @TaxID You can drop the parameter @BName as it is not being used. To get the BName back into your application you can use ExecuteScalar(). "On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog

They count the characters. As that answer was so terribly obvious, it's probably not what you were looking for. Can you be more specific in your question? --- b { font-weight: normal; }

Craster wrote: The items with '@' in front refer to parameters being supplied to a stored procedure. Among other things. See also Guffa's reply to the Original Poster. Craster wrote: The only reason you should ever see this in VB code is if the code is attempting to create the stored procedure on the SQL Server - I can't see that this would ever work if you attempt to run it as an update statement directly from a VB app. This is incorrect. Craster wrote: It's possible that someone's copied and pasted the code from a stored procedure directly into VB as an attempt to do an update, but I don't believe it can possibly work. Yes, it can work. You pass parameters for any SQL Statement through the SqlCommand object. For example. The SQL: SELECT * FROM MyTable WHERE name=@name Can be accessed in VB as: Dim cmd As SqlCommand cmd = New SqlCommand() cmd.CommandText="SELECT * FROM MyTable WHERE name=@name" cmd.Parameters.Add("@name", "John Smith") cmd.Connection = MyConnection Dim reader As SqlDataReader reader = cmd.ExecuteReader() ColinMackay.net Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?

He asked if it was possible. Yep, it is! You're right, though. I didn't mention that it wasn't a good idea! :laugh: RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

OK Tested the email portion of your code... Imports System.Web.mail Dim newMail As New MailMessage Dim SmtpSvr As SmtpMail Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load End Sub Private Sub mySendMail() SmtpMail.SmtpServer = "127.0.0.1" newMail.To = "kne@canon.com.au" '' this is TO Address newMail.From = "japel-xp@localhost" '' this is the From Address newMail.Subject = "Change in Product Rate" newMail.Body = "Dear Ken" SmtpMail.Send(newMail) End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click mySendMail() End Sub Added the (Dim SmtpSvr As SmtpMail) and the rest worked. Please let me know how you go... Also catch the email Exception by putting your code in a try/catch the below will tell you the return smtp server error e.g. 550 No Realy... Catch ex As Exception MessageBox.Show(ex.GetBaseException.Message) End Try When people make you see red, be thankful your not colour blind.

No need to restart IIS daily for purpose of sending mail .Restarting IIS means restarting application . If you want to automatically send email daily , then create a small exe In which can be scheduled to run once in a day .This exe can be created in vb / vb.net . Divya Rathi

Thanks, I found it, I expanded mscorlib and there it was

Thanks, I will go there now

kenn_rosie wrote: I created the sub SortEventHandler as below but I am lost as to what is next to do? You will probally get an answer in the correct form try the Web Devolopment form[^] Good luck :) BTW, if you wanted to sort the data before presenting it to the user use the Order By [column] in your select statement.

You have to put something on the page for it to show up in the browser. You can for an example put a DataGrid on the page, and use the DataTable as DataSource for the grid. --- b { font-weight: normal; }

kenn_rosie wrote: What is a named variable and why use it? It can be used like a variable in a stored procedure, or passed as a parameter to a query. Why use a variable in any programming language? Also, for security in passing data through from client applications. See SQL Injection Attacks and Tips on How to Prevent Them[^] ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Now you are getting the string from the form field, then putting the string into the parameter. After you have gotten the string, try to parse it. If the parsing was successfull, you can continue by converting the double to an int (as I assume that is the datatype in the database) and put it in the parameter. If the parsing fails, you can either set the value to a default value, or display an error message. --- b { font-weight: normal; }