Just be sure to run those commands in an elevated command prompt --Mike-- Visual C++ MVP :cool: LINKS~! Ericahist | PimpFish | CP SearchBar v3.0 | C++ Forum FAQ Ford, what's this fish doing in my ear?

You have to use objectdatesource or sqldatasoruce or accessdatasouce which will make your life easy. Naveed Kamboh Complexity kills, Write easy code for your self. isolutionteam

But please keep in mind postbackurl post back main page again. So if you need to transfer values use Server.transfer and get the values thru properties. In general, if it is straight forwrd transfer tehn user PostBackUrl or response.redirect. Amit

Your code should use: ... " WHERE " & FieldHead & " LIKE '" & Replace(TextBox, "'", "''") & "%' Instead of: ... " WHERE " & FieldHead & " LIKE '" & TextBox & "%'" Otherwise it will break if the user enters a single-quote into his search value. The normal way to show the results is to iterate through each row and column in the result set. However, you might find the following faster: 'Open the recordset and render the data in HTML format. For Each objField In objRS.Fields Call Response.Write("<td nowrap><b>" & _ Server.HtmlEncode(objField.Name) & "</b></td>" & vbCRLF) Next Call Response.Write("</tr>" & vbCRLF) Call Response.Write("<tr>") If Not objRs.eof Then strData = objRS.GetString( , , "#<#/td#>##<#td#>#", _ "#<#/td#>##<#/tr#>##<#tr#>##<#td nowrap#>#", "#&#nbsp;") strData = Replace(Replace(Replace(strData, "#&#", Chr(1)), "&", "&amp;"), Chr(1), "&") strData = Replace(Replace(Replace(strData, "#<#", Chr(1)), "<", "&lt;"), Chr(1), "<") strData = Replace(Replace(Replace(strData, "#>#", Chr(1)), ">", "&gt;"), Chr(1), ">") strData = "<td>" & Replace(Left(strData, Len(strData) - 15), "</tr>", "</tr>" & vbCRLF) Call Response.Write(strData) Else Call Response.Write("<td colspan=""" & objRs.Fields.Count & """>No records found.</td></tr>" & vbCRLF) End If Call Response.Write("</table>" & vbCRLF) The funny replace stuff is a quick way to get it to render each field as a separate HTML table cell. Andy

What language is this? Perl? Jon Sagara I controlled my laughter and simple said "No,I am very busy,so I can't write any code for you". The moment they heard this all the smiling face turned into a sad looking face and one of them farted. So i had to leave the place as soon as possible. --Mr.Prakash Blog | Site | Articles

Dear Tyrone_whitey, Remove the Dim statement and Execute. This solves your problem. Regards, Manowj

converts to single data type chatura

It's pretty close. It doesn't quite draw corner to corner on my form. And there is a slight white gap between the 2 triangles. My form is a different size than yours. But it is really close. Good job so far. Two things... 1) I had a compile error on your ToInt32() calls. I had to change them to Convert.ToInt32(). 2) You need to Dispose your pens at every pass of your loop. Both loops really. Do it like this... penCurrent.Dispose Next LineLoop

What you want is called a "gradient". There are a lot of articles written here on how to do this. Some provide form controls that'll do the work for you. See the below links. http://www.codeproject.com/cs/miscctrl/gradientlabel.asp[^] http://www.codeproject.com/cs/miscctrl/labelgradient.asp[^] http://www.codeproject.com/csharp/gradientforms_easyway.asp[^] http://www.codeproject.com/vb/net/custompanel.asp[^]