Answers

• bindrid Posts: 730Questions: 0Answers: 119

  April 2017 Answer ✓

  Need to see your datatable definition but my guess is that you are not return data or your table is expecting an array of object but you are sending it an array of arrays.
• AbuMaizar Posts: 14Questions: 6Answers: 1

  April 2017 edited April 2017

  Thank you ,
  I m posting the whole method as below,

  $(document).ready(function () {
  var $table = $('#RegSrc2');
  $table.dataTable({
  bProcessing: true,
  "serverSide": true,
  "sAjaxSource": $table.data('../CONFIG/WebSerTblsSearch.asmx/SrcTblRegx'),
  "columns": [
  {
  "data": "Filenum",
  "width": "10%"
  },
  {
  "data": "FullName",
  "width": "10%"
  }
  ]
  })
  });

  File Number	Patient Name	DOB
  File Number	Patient Name	DOB

  <WebMethod()> _
  

  <ScriptMethod(ResponseFormat:=ResponseFormat.Json)> _
  Public Function SrcTblRegx()
  Dim constr As String = ConfigurationManager.ConnectionStrings("ARTSQLConStrng").ConnectionString
  Using con As New SqlConnection(constr)
  Using cmd As New SqlCommand("TblRegSearchx", con)
  cmd.CommandType = CommandType.StoredProcedure
  cmd.Connection = con
  Dim ds As New DataSet()
  Using sda As New SqlDataAdapter(cmd)
  sda.Fill(ds)
  End Using
  Dim MArray()() As String = New String(ds.Tables(0).Rows.Count)() {}
  Dim i As Integer = 0
  For Each rs As DataRow In ds.Tables(0).Rows
  MArray(i) = New String() {rs("Filenum").ToString(), rs("FullName").ToString()}
  i = i + 1
  Next
  Dim js As JavaScriptSerializer = New JavaScriptSerializer()
  Dim sJSON As String = js.Serialize(MArray)
  Return sJSON
  'Dim jsondata As String = JsonConvert.SerializeObject(ds)
  'Return jsondata
  End Using
  End Using
  End Function
• AbuMaizar Posts: 14Questions: 6Answers: 1

  April 2017 Answer ✓

  Bindrid answer is here,

  http://stackoverflow.com/questions/43645019/datatable-jquery-plugin-implementation?noredirect=1#43648097

  thanks a lot Bindrid