<%@ Page Language="VB"
<%@ import Namespace="system.data.sqlclient"
<script runat="server">
Sub Button1_Click(sender As Object, e As EventArgs)
Dim conPubs As SqlConnection
Dim cmdSelect As SqlCommand
Dim dtrAuthors As SqlDataReader
dim test as string
test = textbox1.text
conPubs = New SqlConnection( "server='Merlin'; trusted_connection=true; database='Solotest'" )
cmdSelect = New SqlCommand( "Insert into student (name) values ('test') ") <====im not sure if this is correct
conPubs.Open()
dtrAuthors = (cmdselect, conPubs) <====im encountering errors here..
dtrAuthors.executequery() <=====same with here
End Sub
</script>
<html>
<head>
</head>
<body background="images/rmclogofade.gif">
<form runat="server">
<p align="left">
<asp:TextBox id="TextBox1" style="Z-INDEX: 100; LEFT: 220px; POSITION: absolute; TOP: 37px" runat="server"></asp:TextBox>
<asp:Button id="Button1" style="Z-INDEX: 101; LEFT: 118px; POSITION: absolute; TOP: 248px" onclick="Button1_Click" runat="server" Text="Add"></asp:Button>
<asp:Label id="Label1" style="Z-INDEX: 100; LEFT: 113px; POSITION: absolute; TOP: 40px" runat="server">User
Id</asp:Label>
</p>
<!-- Insert content here -->
</form>
</body>
</html>