How to execute a query in Vb.net

strSQL="delete or insert or update * from tablename where condition"

Try
            cnSQL = New OleDbConnection(ConnectionString)
            cnSQL.Open()
            cmSQL = New OleDbCommand(strSQL, cnSQL)
            cmSQL.ExecuteNonQuery()
            drSQL.Close()
            cnSQL.Close()
            cmSQL.Dispose()
            cnSQL.Dispose()
        Catch Exp As OleDbException
            MsgBox(Exp.Message, MsgBoxStyle.Critical, "Oledb Error")
        Catch Exp As Exception
            MsgBox(Exp.Message, MsgBoxStyle.Critical, "General Error")
End Try

Comments

Http 500.50 URL Rewrite Error

Symptoms: HTTP Error 500.50 - URL Rewrite Module Error. Error Information Module- RewriteModule Images are broken and not displayed in wordpress, Images are displayed when you edit them,Wordpress Images Broken, Wordpress Images Upload Issue This post if for the people who are searching all the pages over internet for " HTTP Error 500.50 - URL Rewrite Module Error". You might be searching for the pages which will give you solution to install/uninstall the url rewrite module.When you are running Wordpress on Windows server 2008 these types of error pops up. So I scratched my head and started searching and found out one website which is useful in this type of error. Then I filtered everything and prepared a process for this.This will reduce your turn around time. Step-1: Open PHP.ini and search for "upload_tmp_dir" and change the value to windows temp directory "C:\Windows\Temp" Step-2: Right click On the Windows/Temp folder and assi...

DotNetNuke

What is DotNetNuke ? DNN (DotNetNuke) is the leading web Content Management System (CMS) for Microsoft, powering over 700,000 production web sites worldwide. DotNetNuke was written in VB.Net. It is distributed under both a Community Edition MIT license and commercial proprietary licenses i.e., Professional and Enterprise Editions. You can download the DotNetNuke Trial Edition from the below link http://www.dotnetnuke.com/Products/Professional-Edition-Trial.aspx Below link provides a quick overview of how to get up and running with DotNetNuke. http://www.dotnetnuke.com/Resources/Video-Library/Viewer/Video/449/View/Details/DotNetNuke-6-2-Getting-Started.aspx

Usage of Ternary Operator

You can optimize the code by using the ternary operator, pass a parameter to this function it will compare the salary with the given value and if the condition satisfied It will print the value before the colon and if not satisfied it will print the value after colon. Ternary Operator (?:) condition ? condition satisfied : Condition not satisfied string TernaryOperatorUsage(int Salary) { return salary >= 5000 ? "Congratulations! You are eligible for a pay hike." : "Sorry! You're not eligible for a pay hike."; } The above example illustrates the use of ternary operator in your code.

Programming is my life

Search This Blog