Adnan Khan

Under your .js file you need something like this:

//————————————————————————————————–
//TABLE
//—————————————————————————————————

function DisplayTablesList() {

//get selected ddname
var mydd = GetDDNameAllTables();

//empty div contents
EmptyDivData(‘#tbllist-div’);

//show loading image
showLoadingImage(‘#tbllist-div’);

$.ajax({
url: “webservices/ServiceSearch.asmx/GetAllTableNames”,
data: “{‘myddname’:'” + mydd + “‘}”,
dataType: “json”,
type: “POST”,
contentType: “application/json; charset=utf-8”,
async: true,
success: function (data) {

var obj = jQuery.parseJSON(data.d);
//obj[0][“ColumnName”]
var returnlist = new Array();
var $table = $(‘<Table class=”table table-condensed” ></Table>’);

for (var i = 0; i < obj.length – 1; i++) {

var rownumber = i + 1;
//alert(obj[i][“ColumnName”]);
returnlist.push(obj[i][“ColumnName”].toString());
$table.append(‘<tr><td>’ + rownumber.toString() + ‘. ‘ + ‘<a href=”Table.aspx?name=’ + obj[i][“ColumnName”].toString() + i + ‘”>’+ obj[i][“ColumnName”].toString() + i + ‘</a>’ + ‘</td></tr>’);
}

$table.append(‘(<a href=”#top-filter-a-z”>Go to Top</a>)’);
$(‘#tbllist-div’).append($table);

//hide loading image
hideLoadingImage();

}, error: function (result) {
//alert(“Error: Please contact administrator for help: ” + result.responseText);
}
});
}

Under your .asmx file (web service file) you need to declare a method to return JavaScriptSerializer().Serialize(e)

‘—————————————————————————————————

‘METHOD TO GET ALL TABLE NAMES FULL LIST
‘—————————————————————————————————
<WebMethod()> _
<ScriptMethod(ResponseFormat:=ResponseFormat.Json)> _
Public Function GetAllTableNames(ByVal myddname As String) As String

Dim result As New List(Of String)()
LoadOracleSettingsFromWebConfig(myddname)

Dim oradb As String = “Data Source=(DESCRIPTION=” _
+ “(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=” + _oraclehost + “)(PORT=” + _oraclehostport + “)))” _
+ “(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=” + _oracleservicename + “)));” _
+ “User Id=” + _oracleuserid + “;Password=” + _oracleuserpassword + “;”

Dim conn As New OracleConnection(oradb)
Dim i As Integer = 0
Dim return_max_count As Integer = 0

Try

Using con As New OracleConnection(oradb)
Using cmd As New OracleCommand(“select DISTINCT table_name from mytblnamehere order by table_name”, con)
con.Open()
Dim dr1 As OracleDataReader = cmd.ExecuteReader()
Dim dr As OracleDataReader = cmd.ExecuteReader()

While dr1.Read()
Try
return_max_count = return_max_count + 1
Catch ex As Exception
‘dont’ do anything
End Try
End While

Dim e As TableClass() = New TableClass(return_max_count) {}
While dr.Read()
e(i) = New TableClass()
e(i).ColumnName = dr(“table_name”).ToString
i = i + 1
End While

Return New JavaScriptSerializer().Serialize(e)

End Using
End Using
Catch ex As Exception
Console.WriteLine(ex.Message)
End Try
End Function