|In a vb.net 2010 web form application, there is the following line of code in a
<asp:TemplateField HeaderText="Student Name" ItemStyle-HorizontalAlign="Center"
GetStudentLetterTemplate('<%# Eval("schoolyear") %>', '<%# Eval("schoolnum")
%>', '<%# Eval("milestone_code") %>', '<%# Eval("stulink") %>', '<%#
Eval("HOMELNGCOR") %>', '<%# Eval("semester") %>');"
saying basically saying there is duplicate data in the database. I want to then
want the function to 'return' so no processing by the user can occur. Note: the
duplicate data is created by the user by them using vendor software that I have
no control over.
The sql that I want to use is something like the following:
#Region "Public Shared Function GetDupScoolYear"
Public Shared Function GetDupScoolYear() As DataTable
Dim _dt As DataTable = New DataTable()
Dim Query As String = "SELECT [personID],value, count(*) as Count FROM
[t].[dbo].[CustomStudent] where attributeID = 2775 and [personID] = 97366 group
Using con As SqlConnection = DB.OpenConnection()
Using da As SqlDataAdapter = New SqlDataAdapter(Query, con)
Catch ex As Exception
Thus can you tell me or show me what I can do to solve the problem? Is there
possibly someway that I could call the code I listed above or similar code
before the java script code is called?
Basically would you tell me what I can do to solve this issue?
modified 23-Aug-16 22:22pm.