web 2.0

ASP.NET(vb.net) & MySQL Transaction (BeginTransaction,Commit,Rollback)

ASP.NET(vb.net) & MySQL Transaction (BeginTransaction,Commit,Rollback) - This is  example scripts how to use ASP.NET and transaction mode in MySQL database (MySql.Data.MySqlClient)

ShotDev Focus:
- ASP.NET(vb.net) & MySQL Transaction (BeginTransaction,Commit,Rollback)

Example

AspNetMySQLTransaction.aspx

<%@ import Namespace="System.Data" %>
<%@ import Namespace="MySql.Data.MySqlClient" %>
<%@ Page Language="VB" %>
<script runat="server">

Sub Page_Load(sender As Object, e As EventArgs)

End Sub

Sub btnSave_Click(sender As Object, e As EventArgs)
Dim objConn As New MySqlConnection
Dim objCmd As New MySqlCommand
Dim strConnString,strSQL As String
Dim Trans As MySqlTransaction

Me.pnlAdd.Visible = False

strConnString = "Server=localhost;User Id=root; Password=root; Database=mydatabase; Pooling=false"
objConn.ConnectionString = strConnString
objConn.Open()

Trans = objConn.BeginTransaction(IsolationLevel.ReadCommitted)  '*** Start Transaction ***'

With objCmd
.Connection = objConn
.Transaction = Trans  '*** Command & Transaction ***'
End With

Try
'*** Query 1 ***'
strSQL = "INSERT INTO customer (CustomerID,Name,Email,CountryCode,Budget,Used) " & _
" VALUES " & _
" ('" & Me.txtCustomerID.Text & "','" & Me.txtName.Text & "','" & Me.txtEmail.Text & "', " & _
" '" & Me.txtCountryCode.Text & "','" & Me.txtBudget.Text & "','" & Me.txtUsed.Text & "')"

objCmd.CommandText = strSQL
objCmd.CommandType = CommandType.Text
objCmd.ExecuteNonQuery()
'*** End Query 1 ***'

'*** Query 2 ***'
strSQL = "INSERT INTO customer (CustomerID,Name,Email,CountryCode,Budget,Used) " & _
" VALUES " & _
" ('" & Me.txtCustomerID.Text & "','" & Me.txtName.Text & "','" & Me.txtEmail.Text & "', " & _
" '" & Me.txtCountryCode.Text & "','" & Me.txtBudget.Text & "','" & Me.txtUsed.Text & "')"

objCmd.CommandText = strSQL
objCmd.CommandType = CommandType.Text
objCmd.ExecuteNonQuery()
'*** End Query 2 ***'

Trans.Commit()  '*** Commit Transaction ***'

Me.lblStatus.Text = "Record Insert Sucessful."
Me.lblStatus.Visible = True
Catch ex As Exception
Trans.Rollback() '*** RollBack Transaction ***'

Me.lblStatus.Visible = True
Me.lblStatus.Text = "Record Cannot Insert : Error ("& ex.Message &")"
End Try

objConn.Close()
objConn = Nothing

End Sub

</script>
<html>
<head>
<title>ShotDev.Com Tutorial</title>
</head>
<body>
<form id="form1" runat="server">
<asp:Panel id="pnlAdd" runat="server">
<table width="353" border="1">
<tbody>
<tr>
<td width="102">
&nbsp;<asp:Label id="lblCustomerID" runat="server" text="CustomerID"></asp:Label></td>
<td width="235">
&nbsp;<asp:TextBox id="txtCustomerID" runat="server" Width="79px"></asp:TextBox>
</td>
</tr>
<tr>
<td>
&nbsp;<asp:Label id="lblName" runat="server" text="Name"></asp:Label></td>
<td>
&nbsp;<asp:TextBox id="txtName" runat="server" Width="177px"></asp:TextBox>
</td>
</tr>
<tr>
<td>
&nbsp;<asp:Label id="lblEmail" runat="server" text="Email"></asp:Label></td>
<td>
&nbsp;<asp:TextBox id="txtEmail" runat="server" Width="155px"></asp:TextBox>
</td>
</tr>
<tr>
<td>
&nbsp;<asp:Label id="lblCountryCode" runat="server" text="CountryCode"></asp:Label></td>
<td>
&nbsp;<asp:TextBox id="txtCountryCode" runat="server" Width="38px"></asp:TextBox>
</td>
</tr>
<tr>
<td>
&nbsp;<asp:Label id="lblBudget" runat="server" text="Budget"></asp:Label></td>
<td>
&nbsp;<asp:TextBox id="txtBudget" runat="server" Width="76px"></asp:TextBox>
</td>
</tr>
<tr>
<td>
&nbsp;<asp:Label id="lblUsed" runat="server" text="Used"></asp:Label></td>
<td>
&nbsp;<asp:TextBox id="txtUsed" runat="server" Width="76px"></asp:TextBox>
</td>
</tr>
</tbody>
</table>
<br />
<asp:Button id="btnSave" onclick="btnSave_Click" runat="server" Text="Save"></asp:Button>
<br />
</asp:Panel>
<asp:Label id="lblStatus" runat="server" visible="False"></asp:Label>
</form>
</body>
</html>

Screenshot

ASP.NET(vb.net) & MySQL Transaction (BeginTransaction,Commit,Rollback)

.
.
.
Download this script.
Download

1 Star2 Stars3 Stars4 Stars5 Stars6 Stars7 Stars8 Stars9 Stars10 Stars (1 votes, average: 10.00 out of 10)
Loading ... Loading ...

Leave a Reply

You must be logged in to post a comment.