karinne
07-04-2003, 03:00 PM
Here's my code:
<%@ Page Language="VB" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script runat="server">
Sub InsertBtn_Click(sender As Object, E As EventArgs)
dim DS as DataSet
dim conn as SqlConnection
dim input as SqlDataAdapter
conn = new SqlConnection("server=(local)\VSdotNET;database=WebTeam;trusted_connection=yes")
input = new SqlDataAdapter("insert into employees (FName, Initials, LName, PhoneNo) values ('" + FName.Text + "', '" + Initials.Text + "', '" + LName.Text + "', '" + PhoneNo.Text + "')", conn)
DS = new DataSet()
input.Fill(DS, "FName")
FNameList.DataSource = DS.Tables("FName").DefaultView
FNameList.DataBind()
End Sub
</script>
<html>
<head>
<title>WebTeam employees : insert</title>
<link href="/webteam/styles.css" type="text/css" rel="stylesheet" />
</head>
<body>
<form action="/webteam/insert.aspx" method="post" runat="server">
<table align="center" width="700" cellpadding="3" cellspacing="1" border="0">
<tbody>
<tr style="color: #fff; background-color: #036;">
<td colspan="2" align="center"><strong>- Insert Employee Info -</strong></td>
</tr>
<tr style="color: #fff; background-color: #69c;">
<td align="right"><strong>First Name</strong></td>
<td align="left"><asp:TextBox class="formfld" id="FName" size="40" runat="server" /></td>
</tr>
<tr style="color: #fff; background-color: #369;">
<td align="right"><strong>Initials</strong></td>
<td align="left"><asp:TextBox class="formfld" id="Initials" size="10" runat="server" /></td>
</tr>
<tr style="color: #fff; background-color: #69c;">
<td align="right"><strong>Last Name</strong></td>
<td align="left"><asp:TextBox class="formfld" id="LName" size="40" runat="server" /></td>
</tr>
<tr style="color: #fff; background-color: #369;">
<td align="right"><strong>Phone No.</strong></td>
<td align="left"><asp:TextBox class="formfld" id="PhoneNo" size="30" runat="server" /></td>
</tr>
<tr style="color: #fff; background-color: #036;">
<td colspan="2" align="center"><asp:button class="formbtn" id="InsertBtn" onclick="InsertBtn_Click" text="Insert" runat="server" /></td>
</tr>
</tbody>
</table>
<p><asp: DataGrid id="FNameList" HeaderStyle-BackColor="#aaaadd" BackColor="#ccccff" runat="server"/></p>
</form>
</body>
</html>
And when I fill in the textbox and click submit I get this error: Object reference not set to an instance of an object. Help! I'm lost! :confused:
TIA
<%@ Page Language="VB" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script runat="server">
Sub InsertBtn_Click(sender As Object, E As EventArgs)
dim DS as DataSet
dim conn as SqlConnection
dim input as SqlDataAdapter
conn = new SqlConnection("server=(local)\VSdotNET;database=WebTeam;trusted_connection=yes")
input = new SqlDataAdapter("insert into employees (FName, Initials, LName, PhoneNo) values ('" + FName.Text + "', '" + Initials.Text + "', '" + LName.Text + "', '" + PhoneNo.Text + "')", conn)
DS = new DataSet()
input.Fill(DS, "FName")
FNameList.DataSource = DS.Tables("FName").DefaultView
FNameList.DataBind()
End Sub
</script>
<html>
<head>
<title>WebTeam employees : insert</title>
<link href="/webteam/styles.css" type="text/css" rel="stylesheet" />
</head>
<body>
<form action="/webteam/insert.aspx" method="post" runat="server">
<table align="center" width="700" cellpadding="3" cellspacing="1" border="0">
<tbody>
<tr style="color: #fff; background-color: #036;">
<td colspan="2" align="center"><strong>- Insert Employee Info -</strong></td>
</tr>
<tr style="color: #fff; background-color: #69c;">
<td align="right"><strong>First Name</strong></td>
<td align="left"><asp:TextBox class="formfld" id="FName" size="40" runat="server" /></td>
</tr>
<tr style="color: #fff; background-color: #369;">
<td align="right"><strong>Initials</strong></td>
<td align="left"><asp:TextBox class="formfld" id="Initials" size="10" runat="server" /></td>
</tr>
<tr style="color: #fff; background-color: #69c;">
<td align="right"><strong>Last Name</strong></td>
<td align="left"><asp:TextBox class="formfld" id="LName" size="40" runat="server" /></td>
</tr>
<tr style="color: #fff; background-color: #369;">
<td align="right"><strong>Phone No.</strong></td>
<td align="left"><asp:TextBox class="formfld" id="PhoneNo" size="30" runat="server" /></td>
</tr>
<tr style="color: #fff; background-color: #036;">
<td colspan="2" align="center"><asp:button class="formbtn" id="InsertBtn" onclick="InsertBtn_Click" text="Insert" runat="server" /></td>
</tr>
</tbody>
</table>
<p><asp: DataGrid id="FNameList" HeaderStyle-BackColor="#aaaadd" BackColor="#ccccff" runat="server"/></p>
</form>
</body>
</html>
And when I fill in the textbox and click submit I get this error: Object reference not set to an instance of an object. Help! I'm lost! :confused:
TIA