Juda o que é isso, aiaiaiai
Sou iniciante em .net e estou tentando fazer um insert mas ta dando esse erro não estou sabendo onde é
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: BC30456: 'Text' is not a member of 'String'.
Source Error:
Line 22: Dim SQL as String
Line 23:
Line 24: SQL = "INSERT INTO usuario (nome, email) VALUES ('"& nome.Text &"', '"& email.Text &"')"
Line 25: comando.CommandText = SQL
Line 26: comando.Connection = conexao
Source File: D:\ASPX\banco_dados\inserir.aspx Line: 24
Meu script
<%@ Page Language="VB" %><%@ import NameSpace="System.Data" %><%@ import NameSpace="System.Data.OleDb" %><script runat="server"> Dim strconexao as String = "Provider=Microsoft.Jet.OLEDB.4.0;"& _ "Data Source =D:\ASPX\banco_dados\bd.mdb" Dim SQL as String Dim conexao as New OleDbConnection() Dim comando as New OleDbCommand () Dim tabela as OleDbDatareaderSub Click_incluir(obj as object, e as eventargs)conexao.ConnectionString = strconexaoDim nome as StringDim email as StringDim SQL as StringSQL = "INSERT INTO usuario (nome, email) VALUES ('"& nome.Text &"', '"& email.Text &"')"comando.CommandText = SQLcomando.Connection = conexaoconexao.open()comando.ExecuteNonQuery()conexao.close()respo.Text = "Dados Gravados com sucesso!!!"end sub</script><html><head></head><body><form runat="server">Nome: <asp:TextBox ID="nome" runat="server"/><br />Email: <asp:TextBox ID="email" runat="server" /><br /><asp:Button ID="btincluir" Text="Incluir" OnClick="Click_incluir" runat="server" /><br /><asp:Label ID="respo" runat="server" /></form></body></html>Ai valeus pel aajuda
Discussão (1)
Carregando comentários...