Hi,
I am working with a web application with MySQL as the backend in asp.net. I need to insert values in a table called ACS. The code is working fine and i am able to insert values. But the problem i am facing is the values are getting stored as dupliate ones. I have enclosed the code that i have used.
My ACS_Details.aspx page
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="ACSPopup.aspx.vb" Inherits="Company" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title ="PopUp"></title>
<style type="text/css">
.style2
{
text-align: center;
}
.style4
{
text-align: center;
width: 5px;
}
.style5
{
text-align: center;
width: 5px;
height: 36px;
}
.style6
{
text-align: center;
height: 36px;
}
.style7
{
text-align: center;
width: 5px;
height: 26px;
}
.style8
{
text-align: center;
height: 26px;
}
.style10
{
text-align: center;
width: 5px;
height: 30px;
}
.style11
{
text-align: left;
width: 135px;
height: 30px;
}
.style12
{
width: 174px;
height: 30px;
}
.style13
{
height: 193px;
}
</style>
</head>
<body bgcolor="#666666">
<form id="form1" runat="server"
style="font-family: Tahoma; font-size: small; font-weight: normal; font-style: normal; color: #FFFFFF"
class="style13">
<br />
<table>
<tr>
<td class="style10"></td>
<td class="style11">ACS Accrediation :</td>
<td class="style12" style="text-align: left">
<asp:TextBox ID="txtACS"
runat="server" Font-Names="Tahoma"
Font-Size="Small" Width="95%"></asp:TextBox></td>
</tr>
<tr>
<td class="style10"></td>
<td class="style11">Description:</td>
<td class="style12" style="text-align: left"><asp:TextBox ID="txtDescription"
runat="server" Font-Names="Tahoma"
Font-Size="Small" TextMode="MultiLine"
Width="95%"></asp:TextBox></td>
</tr>
<tr>
<td class="style7"></td>
<td class="style8" colspan="2">
<asp:Label ID="lblMessage" runat="server"></asp:Label>
</td>
</tr>
<tr>
<td class="style5"></td>
<td class="style6" colspan="2">
<asp:ImageButton ID="bttnInsertRecord" runat="server" BackColor="#666666"
BorderColor="#666666" Height="30px" ImageAlign="Baseline"
ImageUrl="~/images/Update_over.gif"
onclick="bttnInsertRecord_Click1" Width="74px" />
</td>
</tr>
<tr>
<td class="style4"> </td>
<td class="style2" colspan="2"> </td>
</tr>
</table>
<br />
<br />
</form>
</body>
</html>My Codebehind page
Imports System.Data.Odbc
Imports System.IO
Imports MySql.Data.MySqlClient
Partial Class Company
Inherits System.Web.UI.Page
Protected Sub bttnInsertRecord_Click1(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles bttnInsertRecord.Click
Dim ConnString As String = ConfigurationManager.ConnectionStrings("UKGasConnString").ConnectionString
Using con As New OdbcConnection(ConnString)
con.Open()
Using cmd As New OdbcCommand("INSERT INTO tbl_ACS" & "(ACS, Description) VALUES (?,?)", con)
cmd.Parameters.Add("@ACS", OdbcType.VarChar, 255).Value = txtACS.Text.Trim()
cmd.Parameters.Add("@Description", OdbcType.VarChar, 255).Value = txtDescription.Text.Trim()
cmd.ExecuteNonQuery()
End Using
End Using
End Sub
End ClassThe ConnectionString
<connectionStrings> <add name="UKGasConnString" connectionString="Driver={MySQL ODBC 5.1 Driver};Server=localhost;Port=3306;Database=db_UKGas;Uid=root;Pwd=password;pooling=false;" providerName="MySql.Data.MySqlClient" /> </ connectionStrings>I am really in need of help in this. I need to complete this project for my college work. Looking forward for your help in this.
Regards,
Karthik Venkatraman
