j'ai essayé d'inserer dans ma table ,pour vérifier que la connexion est établie mai la meme chose ,aucune erreur mais il n'insere rien:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.ODBC" %>
<script language="VB" Runat="server">
Sub Page_Load(Source as Object, E as EventArgs)
BindData
End Sub
Sub BindData()
Dim nom
Dim prenom
Dim strConn As String
nom = "han"
prenom = "han"
strConn = "DRIVER={MySQLODBC 3.51 Driver};ServerAddress = localhost;DATABASE=hi;" & _
"USER=root;PASSWORD=; OPTION=16386;"
Dim MySQL As String = "INSERT INTO moi (nom,prenom) " & _
"values('" + nom + "','" + prenom + "' )"""
Dim MyConn As New OdbcConnection(strConn)
Dim ds As DataSet = New DataSet()
Dim Cmd As New OdbcDataAdapter(MySQL, MyConn)
Cmd.Fill(ds, "moi")
MyDataGrid.DataSource = ds.Tables("moi").DefaultView
MyDataGrid.DataBind()
End Sub
Sub Page_Change(ByVal sender As Object, ByVal e As DataGridPageChangedEventArgs)
MyDataGrid.CurrentPageIndex = e.NewPageIndex
BindData()
End Sub
</script>
<html xmlns="
[ Lien ]" >
<head id="Head1" runat="server">
<title>MySQL with ASP.Net</title>
<meta name="GENERATOR" content="asp express 4.0"/>
</head>
<body>
<form id="form1" runat="server">
<asp:Datagrid Runat="server"
Id="MyDataGrid">
</asp:Datagrid>
</form>
</body>
</html>