ASP.NET
ASP/SQL binding
Gravatar is a globally recognized avatar based on your email address. ASP/SQL binding
  n/a
  All
  Oct 17, 2014 @ 02:42pm
I am quite new to ASP and I am trying to repair an ASP.NET website that is bound to and SQL database. I have a link that when clicked says "no records found"; however, there are records. My question is how can I determine which table(s) in the database the webform is pulling data from?

Thanks so much for any help.

Rick

<%@ page title="" language="VB" masterpagefile="~/MainMaster.master" autoeventwireup="false" inherits="DatasheetList, App_Web_datasheetlist.aspx.cdcab7d2" enableviewstatemac="false" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder2" runat="Server">

<script src="js/Validation.js" type="text/javascript"></script>

<script type="text/javascript">
$(function() {

$("#dialog").dialog({
autoOpen: false,

show: "blind",
hide: "clip"
});


})
</script>

<script type="text/javascript">
$(function() {

// Dialog
$('#dialog').dialog({
autoOpen: false,
resizable: false,
width: 800,
buttons: {
"Apply": function() {
$("#ctl00_ContentPlaceHolder1_hidtxtCRNo").val($("#ctl00_ContentPlaceHolder1_txtdiCRNNo").val());
$("#ctl00_ContentPlaceHolder1_hidtxtCourseName").val($("#ctl00_ContentPlaceHolder1_txtdiCourseName").val());
$("#ctl00_ContentPlaceHolder1_hidtxtCourseType").val($("#ctl00_ContentPlaceHolder1_txtdiCourseType").val());
$("#ctl00_ContentPlaceHolder1_hidtxtStatus").val($("#ctl00_ContentPlaceHolder1_txtdiStatus").val());
$("#ctl00_ContentPlaceHolder1_btnFilter").click();
},
"Cancel": function() {
$(this).dialog("close");
$("#ctl00_ContentPlaceHolder1_hidtxtCRNo").val('')
$("#ctl00_ContentPlaceHolder1_hidtxtCourseName").val('')
$("#ctl00_ContentPlaceHolder1_hidtxtCourseType").val('')
$("#ctl00_ContentPlaceHolder1_hidtxtStatus").val('')
}
}
});

$('#ctl00_ContentPlaceHolder1_btnpopup').click(function() {
$('#dialog').dialog('open');

$("#ctl00_ContentPlaceHolder1_hidtxtCRNo").val('')
$("#ctl00_ContentPlaceHolder1_hidtxtCourseName").val('')
$("#ctl00_ContentPlaceHolder1_hidtxtCourseType").val('')
$("#ctl00_ContentPlaceHolder1_hidtxtStatus").val('')
return false;
});
// // Textbox Keyup Event
// $("#ctl00_ContentPlaceHolder1_txtdiCRNNo").keyup(function() {
// $("#ctl00_ContentPlaceHolder1_hidtxtCRNo").val(this.value);
// });
// $("#ctl00_ContentPlaceHolder1_txtdiCourseName").keyup(function() {
// $("#ctl00_ContentPlaceHolder1_hidtxtCourseName").val(this.value);
// });
// $("#ctl00_ContentPlaceHolder1_txtdiCourseType").keyup(function() {
// $("#ctl00_ContentPlaceHolder1_hidtxtCourseType").val(this.value);
// });
// $("#ctl00_ContentPlaceHolder1_txtdiStatus").keyup(function() {
// $("#ctl00_ContentPlaceHolder1_hidtxtStatus").val(this.value);
// });

var AG = $("#ctl00_ContentPlaceHolder1_hidName").val();
var AGList = AG.split(",")
var x = [];
for (var i = 0; i < AGList.length; i++) {
if (i == 0) {
x.push(AGList[0]);
}
else { x[x.length] = AGList[i] }
}
$("#ctl00_ContentPlaceHolder1_txtdiCourseName").autocomplete({ source: x, minLength: 2 });

var AG = $("#ctl00_ContentPlaceHolder1_hidType").val();
var AGList = AG.split(",")
var x = [];
for (var i = 0; i < AGList.length; i++) {
if (i == 0) {
x.push(AGList[0]);
}
else { x[x.length] = AGList[i] }
}
$("#ctl00_ContentPlaceHolder1_txtdiCourseType").autocomplete({ source: x, minLength: 2 });

var AG = $("#ctl00_ContentPlaceHolder1_hidStatus").val();
var AGList = AG.split(",")
var x = [];
for (var i = 0; i < AGList.length; i++) {
if (i == 0) {
x.push(AGList[0]);
}
else { x[x.length] = AGList[i] }
}
$("#ctl00_ContentPlaceHolder1_txtdiStatus").autocomplete({ source: x, minLength: 2 });


Gravatar is a globally recognized avatar based on your email address. Re: ASP/SQL binding
  FoxInCloud Support - Thierry N.
  RC
  Oct 20, 2014 @ 04:52am
Hi Rick
the code you posted is only JavaScript (client side)
where is the server-side code?


I am quite new to ASP and I am trying to repair an ASP.NET website that is bound to and SQL database. I have a link that when clicked says "no records found"; however, there are records. My question is how can I determine which table(s) in the database the webform is pulling data from?

Thanks so much for any help.

Rick

<%@ page title="" language="VB" masterpagefile="~/MainMaster.master" autoeventwireup="false" inherits="DatasheetList, App_Web_datasheetlist.aspx.cdcab7d2" enableviewstatemac="false" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder2" runat="Server">

<script src="js/Validation.js" type="text/javascript"></script>

<script type="text/javascript">
$(function() {

$("#dialog").dialog({
autoOpen: false,

show: "blind",
hide: "clip"
});


})
</script>

<script type="text/javascript">
$(function() {

// Dialog
$('#dialog').dialog({
autoOpen: false,
resizable: false,
width: 800,
buttons: {
"Apply": function() {
$("#ctl00_ContentPlaceHolder1_hidtxtCRNo").val($("#ctl00_ContentPlaceHolder1_txtdiCRNNo").val());
$("#ctl00_ContentPlaceHolder1_hidtxtCourseName").val($("#ctl00_ContentPlaceHolder1_txtdiCourseName").val());
$("#ctl00_ContentPlaceHolder1_hidtxtCourseType").val($("#ctl00_ContentPlaceHolder1_txtdiCourseType").val());
$("#ctl00_ContentPlaceHolder1_hidtxtStatus").val($("#ctl00_ContentPlaceHolder1_txtdiStatus").val());
$("#ctl00_ContentPlaceHolder1_btnFilter").click();
},
"Cancel": function() {
$(this).dialog("close");
$("#ctl00_ContentPlaceHolder1_hidtxtCRNo").val('')
$("#ctl00_ContentPlaceHolder1_hidtxtCourseName").val('')
$("#ctl00_ContentPlaceHolder1_hidtxtCourseType").val('')
$("#ctl00_ContentPlaceHolder1_hidtxtStatus").val('')
}
}
});

$('#ctl00_ContentPlaceHolder1_btnpopup').click(function() {
$('#dialog').dialog('open');

$("#ctl00_ContentPlaceHolder1_hidtxtCRNo").val('')
$("#ctl00_ContentPlaceHolder1_hidtxtCourseName").val('')
$("#ctl00_ContentPlaceHolder1_hidtxtCourseType").val('')
$("#ctl00_ContentPlaceHolder1_hidtxtStatus").val('')
return false;
});
// // Textbox Keyup Event
// $("#ctl00_ContentPlaceHolder1_txtdiCRNNo").keyup(function() {
// $("#ctl00_ContentPlaceHolder1_hidtxtCRNo").val(this.value);
// });
// $("#ctl00_ContentPlaceHolder1_txtdiCourseName").keyup(function() {
// $("#ctl00_ContentPlaceHolder1_hidtxtCourseName").val(this.value);
// });
// $("#ctl00_ContentPlaceHolder1_txtdiCourseType").keyup(function() {
// $("#ctl00_ContentPlaceHolder1_hidtxtCourseType").val(this.value);
// });
// $("#ctl00_ContentPlaceHolder1_txtdiStatus").keyup(function() {
// $("#ctl00_ContentPlaceHolder1_hidtxtStatus").val(this.value);
// });

var AG = $("#ctl00_ContentPlaceHolder1_hidName").val();
var AGList = AG.split(",")
var x = [];
for (var i = 0; i < AGList.length; i++) {
if (i == 0) {
x.push(AGList[0]);
}
else { x[x.length] = AGList[i] }
}
$("#ctl00_ContentPlaceHolder1_txtdiCourseName").autocomplete({ source: x, minLength: 2 });

var AG = $("#ctl00_ContentPlaceHolder1_hidType").val();
var AGList = AG.split(",")
var x = [];
for (var i = 0; i < AGList.length; i++) {
if (i == 0) {
x.push(AGList[0]);
}
else { x[x.length] = AGList[i] }
}
$("#ctl00_ContentPlaceHolder1_txtdiCourseType").autocomplete({ source: x, minLength: 2 });

var AG = $("#ctl00_ContentPlaceHolder1_hidStatus").val();
var AGList = AG.split(",")
var x = [];
for (var i = 0; i < AGList.length; i++) {
if (i == 0) {
x.push(AGList[0]);
}
else { x[x.length] = AGList[i] }
}
$("#ctl00_ContentPlaceHolder1_txtdiStatus").autocomplete({ source: x, minLength: 2 });


-- thn (FoxInCloud)

© 1996-2024