I am a beginner to ASP.NET, using C#. I have set myself a project to develop a 'mini' applications that does the basic functions, list, search, add, update and delete.
I am having a problem with the add part. I have a stored procedure called AddJob which takes in the parameters from the form.
The code us as follows:-
<%@ Page Language="C#" Debug="true" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">
void btnAdd_Click(object sender, EventArgs e)
{
string connectionString = "PROVIDER=SQLOLEDB.1;Data Source=MULTIMEDIA2;Initial Catalog=nkonye_test;Integrated Security=SSPI;";
// Create new SQL command named sqlInsert
System.Data.SqlClient.SqlCommand myCmd = new System.Data.SqlClient.SqlCommand("AddJob", connectionString);
// Set the command type property to StoredProcedure
myCmd.CommandType = CommandType.StoredProcedure;
// @Title should have the value inside txtTitle
myCmd.Parameters.Add ( "@Title", SqlDbType.VarChar ).Value = txtTitle.Text;
myCmd.Parameters.Add ( "@Description", SqlDbType.Text ).Value = txtDetails.Text;
myCmd.Parameters.Add ( "@Location", SqlDbType.VarChar ).Value = txtLocation.Text;
myCmd.Parameters.Add ( "@Start", SqlDbType.DateTime ).Value = Convert.ToDateTime(txtStart.Text);
myCmd.Parameters.Add ( "@End", SqlDbType.DateTime ).Value = Convert.ToDateTime(txtStart.Text);
myCmd.Parameters.Add ( "@Type", SqlDbType.VarChar ).Value = Type.SelectedItem;
myCmd.Parameters.Add ( "@Salary", SqlDbType.VarChar ).Value = txtSalary.Text;
// Open the connection
connectionString.Open();
// Execute the query
myCmd.ExecuteNonQuery();
// Close the connection
connectionString.Close();
// return to record listing
Response.Redirect ("list.aspx");
}
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<table cellpadding="0" width="750" align="center" cellpsacing="0">
<tbody>
<tr>
<td align="middle" colspan="2">
<a href="list.aspx">List</a> | <a href="search.aspx">Search</a> | <a href="index.aspx">Log
out</a>
</td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<td colspan="2">
<h2>Add a new job
</h2>
</td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<td>
Job title:</td>
<td>
<asp:textbox id="txtTitle" runat="server" size="45px"></asp:textbox>
<asp:RequiredFieldValidator id="RequiredFieldValidator1" runat="server" ControlToValidate="txtTitle" ErrorMessage="Job title required"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
Location:</td>
<td>
<asp:textbox id="txtLocation" runat="server" size="20px"></asp:textbox>
<asp:RequiredFieldValidator id="RequiredFieldValidator2" runat="server" ControlToValidate="txtLocation" ErrorMessage="Job location required"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
Type:</td>
<td>
<asp:dropdownlist id="Type" runat="server">
<asp:listitem id="Permanent">Permanent</asp:listitem>
<asp:listitem id="Contract">Contract</asp:listitem>
</asp:dropdownlist>
</td>
</tr>
<tr>
<td>
Salary:</td>
<td>
<asp:textbox id="txtSalary" runat="server" size="20px"></asp:textbox>
</td>
</tr>
<tr>
<td>
Details:</td>
<td>
<asp:textbox id="txtDetails" runat="server" TextMode="MultiLine" rows="5" cols="40"></asp:textbox>
</td>
</tr>
<tr>
<td>
Start date:</td>
<td>
<asp:textbox id="txtStart" runat="server" size="20px"></asp:textbox>
<asp:RequiredFieldValidator id="RequiredFieldValidator3" runat="server" ControlToValidate="txtStart" ErrorMessage="Start date required in dd/mm/yyyy format"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
End date:</td>
<td>
<asp:textbox id="txtEnd" runat="server" size="20px"></asp:textbox>
<asp:RequiredFieldValidator id="RequiredFieldValidator4" runat="server" ControlToValidate="txtEnd" ErrorMessage="Expiry date required in dd/mm/yyy format"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td colspan="2">
<asp:button id="btnAdd" onclick="btnAdd_Click" runat="server" Text="Add"></asp:button>
</td>
</tr>
</tbody>
</table>
</form>
</body>
</html>
Inserting data into a SQL Server database.
