For a web form vb.net 2010 application, I want to make a call to the sql server 2012 database from the code listed below. This code is executed when the user clicks on a link in a gridview control. I want to make a call to the database to make certain there is not more than one student record that would be in the database due to a user error. This error can be caused by the user working with the vendor software than I have no control over.
My plan is to display an error message to the user and place a 'return' in the code listed below.
Thus can you show me code and/or point me to a url that will show me how I can connect to the database from the code listed below:
<%@ Page Title="" Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="default.aspx.vb" Inherits="attendanceletters_default" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<asp:Content ID="Content1" ContentPlaceHolderID="MPHead" Runat="Server">
<script src="../scripts/jquery-1.3.2.js" type="text/javascript"></script>
<script src="../scripts/jquery-ui-1.7.2.custom.min.js" type="text/javascript"></script>
<script src="../scripts/site.js" type="text/javascript"></script>
<script src="../scripts/json2.js" type="text/javascript"></script>
<script type="text/javascript">
var _schoolyear;
var _schoolnum;
var _studentlink;
var _language;
function GetSt(schoolyear, schoolnum, studentlink, language) {
if (language == '') {
language = 'EN'
}
else if (language == 'SPA') {
language = 'ES'
}
_schoolyear = schoolyear;
_schoolnum = schoolnum;
_studentlink = studentlink;
_language = language;
$('#<%= txtStuLink.ClientID%>').val(studentlink);
$('#<%= txtLanguage.ClientID%>').val(language);
var strData = "schoolyear: " + JSON.stringify(schoolyear) + ", "
+ "schoolnum: " + JSON.stringify(schoolnum) + ", "
+ "studentlink: " + JSON.stringify(studentlink) + ", "
+ "language: " + JSON.stringify(language) + ", "
+ "semester: " + JSON.stringify(semester) + "";
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: document.location.pathname + "/GetStudentLetter",
data: "{ " + strData + " }",
dataType: "json",
success: function(data) {
LoadEditor(JSON.parse(data.d), milestone);
},
error: AjaxFailed
});
}
</script>