ALTER PROCEDURE [dbo].[SelectResultAllDatails]

AS
BEGIN
		
DECLARE @query nvarchar(max), @VALUE NVARCHAR(10)

SET @VALUE = 'D013'

SET @QUERY = 'select * from dbo.ResultsDetails where [Student Index] LIKE ''' + @VALUE + '%''' 

SELECT @query

END
GO

foreach (DataRow d in dt.Rows)
            {

                if (d[4].ToString() == "14")
                {
                   dt.rows.remove();

                }
                else if (d[4].ToString() == "24")
                {
                  dt.rows.remove();

package com.java2novice.jdbc;
*
import java.sql.*;

*
public class MyAutoGeneratedKeys {
*
public static void main(String a[]){
********
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

function  operation(name,email,pass){
	 

	  var link = "second.jsp?name="+name;
	  window.open(link);
	
}

function  operation(){
	 
	var frm = document.getElementById("frm"); 
	frm.action="second.jsp?n1="+<%=newname%>;
}



some jsp code
<form name="frm" method="post">
<%=String newname=name[i]%>
.
.
.
</form>