<WebMethod(True)> _
Public Shared Function GetTopicsTable(ByVal strMeetingID As String) As String
Dim strCon As String = System.Configuration.ConfigurationManager.ConnectionStrings("ITDB").ConnectionString
Dim dt As New DataTable
Dim jsonString As String = String.Empty
Try
Using con As New SqlConnection(strCon)
If Not String.IsNullOrEmpty(strMeetingID) Then
Dim cmd As New SqlCommand("SELECT MeetingID, Topic, Task, DateRequired FROM [v_Meeting_Topics_Tasks] WHERE MeetingID = @MeetingID")
cmd.Connection = con
cmd.Parameters.AddWithValue("@MeetingID", strMeetingID)
con.Open()
Dim reader As SqlDataReader = cmd.ExecuteReader
dt.Load(reader)
Dim TopicList = (From row In dt.AsEnumerable() _
Let MeetingID = row.Field(Of Long)("MeetingID") _
Let Topic = row.Field(Of String)("Topic") _
Let Task = row.Field(Of String)("Task") _
Let Required = row.Field(Of DateTime?)("DateRequired") _
Select New Meeting(MeetingID, Topic, Task, Required) _
With {.MeetingID = MeetingID, .Topic = Topic, .Task = Task, _
.DateRequired = Required}).ToList()
jsonString = JsonConvert.SerializeObject(TopicList)
con.Close()
reader.Close()
cmd.Dispose()
End If
End Using
Catch ex As Exception
dt = Nothing
End Try
Return jsonString
End Function
I think I've added all the dependencies. I'm able to add columns etc. Just the population part is throwing the error. When I alert(returnObj) I get this:
grid = new Slick.Grid("#myGrid", returnObj.source, columns, options);
.source is in your JSOn and not mine. Sorry.
My grid is populated now. but the date values aint pulling through
Still a long way to go in terms of what I need but I'm getting there slowly. thanks for all your help
also, howcome I can't do thsi:
Code:
alert(returnObj.MeetingID);
I get undefined
I guess I have to loop through the values because it's an array.
Also, what's the Dataview for? I've seen the example but can't make sense of it. How will I be able to propogate changes in the grid through to my datatbase??
oh no my grid gets populates in FireFox but in IE 8 I get an error seems IE doesn't like my JSON formatting. Do you see any issues with my format?
Last edited by Nitesh; Mar 31st, 2011 at 03:14 AM.
good spot. I'm not sure how I fix this though. My function returns a string. I use a dll called Newtonsoft to serialise the JSON:
Code:
<WebMethod(True)> _
Public Shared Function GetTopicsTable(ByVal strMeetingID As String) As String
Dim strCon As String = System.Configuration.ConfigurationManager.ConnectionStrings("ITDB").ConnectionString
Dim dt As New DataTable
Dim jsonString As String = String.Empty
Try
Using con As New SqlConnection(strCon)
If Not String.IsNullOrEmpty(strMeetingID) Then
Dim cmd As New SqlCommand("SELECT MeetingID, Topic, Task, DateRequired FROM [v_Meeting_Topics_Tasks] WHERE MeetingID = @MeetingID")
cmd.Connection = con
cmd.Parameters.AddWithValue("@MeetingID", strMeetingID)
con.Open()
Dim reader As SqlDataReader = cmd.ExecuteReader
dt.Load(reader)
Dim TopicList = (From row In dt.AsEnumerable() _
Let MeetingID = row.Field(Of Long)("MeetingID") _
Let Topic = row.Field(Of String)("Topic") _
Let Task = row.Field(Of String)("Task") _
Let Required = row.Field(Of DateTime?)("DateRequired") _
Select New Meeting(MeetingID, Topic, Task, Required) _
With {.MeetingID = MeetingID, .Topic = Topic, .Task = Task, _
.DateRequired = Required}).ToList()
jsonString = JsonConvert.SerializeObject(TopicList)
con.Close()
reader.Close()
cmd.Dispose()
End If
End Using
Catch ex As Exception
dt = Nothing
End Try
Return jsonString
End Function
when I hover over the jsonString variable it has those outer quotes what do you use to generate your JSON string?
this is turning into a nightmare. I even tried this function to convert a datatable to JSON but I'm having the same issues:
Code:
Public Shared Function datatableToJSON(ByVal dt As DataTable) As String
Dim jsonStringBuilder As New StringBuilder()
Dim jsonStringWriter As New StringWriter(jsonStringBuilder)
Dim jsonWriter As JsonWriter = New JsonTextWriter(jsonStringWriter)
If dt IsNot Nothing AndAlso dt.Rows.Count > 0 Then
jsonWriter.Formatting = Formatting.None
jsonWriter.WriteStartArray()
For i As Integer = 0 To dt.Rows.Count - 1
jsonWriter.WriteStartObject()
For j As Integer = 0 To dt.Columns.Count - 1
jsonWriter.WritePropertyName(dt.Columns(j).ColumnName.ToString().ToLower())
jsonWriter.WriteValue(dt.Rows(i)(j).ToString())
Next
jsonWriter.WriteEndObject()
Next
jsonWriter.WriteEndArray()
Return jsonStringBuilder.ToString()
Else
Return Nothing
End If
End Function
I'm using this - it's hacked a bit but it's working for me
Code:
Imports Microsoft.VisualBasic
Public Class JsonWriter
Dim JsonString As String = ""
Dim DidStartArray As Boolean = False
'There are objects and arrays
'object has this format "Name":"Value"
'an object can have an array of values, ie ["Val1","Val2","Val3"]
'this function should generate all that
Public Sub StartObject()
JsonString = JsonString + "{"
End Sub
Public Sub EndObject()
JsonString = JsonString + "}"
End Sub
Public Sub StartArray()
JsonString = JsonString + "["
DidStartArray = True
End Sub
Public Sub EndArray()
JsonString = JsonString + "]"
End Sub
Public Sub NameObject(ByVal Name As String)
JsonString = JsonString + Chr(34) + Name + Chr(34) + ":"
End Sub
Public Sub ValueObject(ByVal Value As String)
JsonString = JsonString + Value
End Sub
Public Sub NewObject(ByVal Name As String, ByVal Value As String)
If (Value.ToString.StartsWith("{") And Value.ToString.EndsWith("}")) Or (Value.ToString.StartsWith("[") And Value.ToString.EndsWith("]")) Then
JsonString = JsonString + Chr(34) + Name + Chr(34) + ":" + Value.ToString()
Else
JsonString = JsonString + Chr(34) + Name + Chr(34) + ":" + Chr(34) + Value.ToString() + Chr(34)
End If
End Sub
Public Sub NewObject(ByVal Name As String, ByVal Value As Object, ByVal UseQuotes As Boolean)
If UseQuotes = False Then
JsonString = JsonString + Name + ":" + Value.ToString()
ElseIf UseQuotes = True Then
If Value.ToString.StartsWith("{") And Value.ToString.EndsWith("}") Then
JsonString = JsonString + Chr(34) + Name + Chr(34) + ":" + Value.ToString()
Else
JsonString = JsonString + Chr(34) + Name + Chr(34) + ":" + Chr(34) + Value.ToString() + Chr(34)
End If
End If
End Sub
Public Sub NewArray(ByVal Name As String, ByVal Value As Array)
NewArray(Name, Value, True)
End Sub
Public Sub NewArray(ByVal Name As String, ByVal Value As Array, ByVal UseQuotes As Boolean)
NameObject(Name)
StartArray()
For i As Integer = 0 To Value.Length - 1
If i > 0 Then
JsonString = JsonString + ","
End If
If UseQuotes = False Or (Value(i).ToString.StartsWith("{") And Value(i).ToString.EndsWith("}")) Then
JsonString = JsonString + Value(i).ToString()
ElseIf UseQuotes = True Then
JsonString = JsonString + Chr(34) + Value(i).ToString() + Chr(34)
End If
Next
EndArray()
End Sub
Public Sub PushArray(ByVal Value As String, ByVal UseQuotes As Boolean)
If DidStartArray Then
DidStartArray = False
Else
JsonString = JsonString + ","
End If
If UseQuotes = False Then
JsonString = JsonString + Value.ToString()
ElseIf UseQuotes = True Then
JsonString = JsonString + Chr(34) + Value.ToString() + Chr(34)
End If
End Sub
Public Sub Seperate()
JsonString = JsonString + ","
End Sub
Public Function GetJson() As String
Return JsonString
End Function
Public Sub ResetJson()
JsonString = ""
End Sub
End Class
It's filled like this
Code:
<WebMethod()> _
<ScriptMethod(ResponseFormat:=ResponseFormat.Json, UseHttpGet:=False)> _
Public Function OperatorService(ByVal toddtype As String, ByVal fromddtype As String, ByVal fromwho As String) As String
'Return "<b>This is the content of resource <tt>someResource</tt></b>"
Dim JsonMaker As JsonWriter = New JsonWriter
With JsonMaker
.StartObject()
Dim NeedColsBln As Boolean = True
Dim NeedNameBln As Boolean = True
Dim SettingColsBln As Boolean = False
Try
Using dcn As New SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings("LocalSQLServer").ToString)
Using cmd As New SqlCommand
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "dbo.awc_StudentVisits"
cmd.Connection = dcn
cmd.Parameters.AddWithValue("@StuId", fromwho)
dcn.Open()
Using readerSDR As SqlDataReader = cmd.ExecuteReader
Dim RowCounterInt As Integer = 0
Do
Dim JsonMaker2 As JsonWriter = New JsonWriter
While readerSDR.Read
If readerSDR.GetName(0).StartsWith("acs-") Then
SettingColsBln = True
If NeedColsBln Then
.NewObject(readerSDR.GetName(0), readerSDR(0).ToString)
.Seperate()
NeedColsBln = False
.NameObject("cols")
.StartArray()
Else
.PushArray(readerSDR(1).ToString, False)
End If
Else
SettingColsBln = False
If NeedNameBln Then
.NewObject(readerSDR.GetName(0), readerSDR(0).ToString)
.Seperate()
NeedNameBln = False
End If
With JsonMaker2
If RowCounterInt = 0 Then
.StartArray()
Else
.Seperate()
End If
.StartObject()
For i As Integer = 0 To readerSDR.FieldCount - 1
.NewObject(readerSDR.GetName(i), readerSDR(i).ToString)
If i < readerSDR.FieldCount - 1 Then .Seperate()
Next
.EndObject()
RowCounterInt += 1
End With
End If
End While
If SettingColsBln Then
.EndArray()
.Seperate()
Else
JsonMaker2.EndArray()
.NewObject("rowcount", RowCounterInt.ToString)
.Seperate()
.NewObject("source", JsonMaker2.GetJson())
End If
Loop While readerSDR.NextResult
End Using
End Using
End Using
Catch ex As Exception
.ResetJson()
.StartObject()
.NewObject("%%dalerror%%", ex.Message)
End Try
.EndObject()
End With
Return JsonMaker.GetJson()
End Function
And you spend a lot of time validating the JSON here
Of course this is what it looks like after the JSON validator website both VALIDATES it and RE-FORMATS it for visual review.
Use the link to validate - it saves lots of time.
Keep in mind that I'm crazy - I'm actually passing all the slickgrid info - column names and everything - from my DATABASE. I like to create "extensible" applications - ones that can change with just a tweak to a control table in my DB.
*** Read the sticky in the DB forum about how to get your question answered quickly!! ***
Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".
So, not to hijack the thread too much, but szlamany how are you finding this approach working out for you, rather than using the standard ASP.Net Controls?
Nitesh, from the link I posted in your other thread, here is a complete sample application that might help you:
thanks szlamany and Gary szlamany you have been a great help
guys, my JSON format wasn't the issue. It was actually a slickGrid bug. The last column created has an id attribute which is null. This is in slick.grid.js:
var dateString = returnObj[i].DateRequired;
if (dateString == null)
{
date = '';
}else{
date = isoDateReviver(dateString).toLocaleString();
}
d["Required"] =date;
the only drawback is, I have to use LINQ and then I am able to do this because the SerializeObject Function accepts a converter:
Code:
dt.Load(reader)
Dim TopicList = (From row In dt.AsEnumerable() _
Let MeetingID = row.Field(Of Long)("MeetingID") _
Let Topic = row.Field(Of String)("Topic") _
Let Task = row.Field(Of String)("Task") _
Let Required = row.Field(Of DateTime?)("DateRequired") _
Select New Meeting(MeetingID, Topic, Task, Required) _
With {.MeetingID = MeetingID, .Topic = Topic, .Task = Task, _
.DateRequired = Required}).ToList()
jsonString = JsonConvert.SerializeObject(TopicList, New IsoDateTimeConverter())
con.Close()
I had a the following function to directly convert a datatable to JSON, but I don't know how I can set an ISODateConverter anywhere here as it doesn't use the SerializeObject function
Code:
Public Shared Function Serialize(ByVal value As Object) As String
Dim type As Type = value.[GetType]()
Dim json As New Newtonsoft.Json.JsonSerializer()
json.NullValueHandling = NullValueHandling.Include
json.ObjectCreationHandling = Newtonsoft.Json.ObjectCreationHandling.Replace
json.MissingMemberHandling = Newtonsoft.Json.MissingMemberHandling.Ignore
json.ReferenceLoopHandling = ReferenceLoopHandling.Ignore
If type Is GetType(DataRow) Then
json.Converters.Add(New DataSetConverter())
ElseIf type Is GetType(DataTable) Then
json.Converters.Add(New DataTableConverter())
ElseIf type Is GetType(DataSet) Then
json.Converters.Add(New DataSetConverter())
End If
Dim sw As New StringWriter()
Dim writer As Newtonsoft.Json.JsonTextWriter = New JsonTextWriter(sw)
'If FormatJsonOutput Then
writer.Formatting = Formatting.Indented
'Else
'writer.Formatting = Formatting.None
'End If
writer.QuoteChar = """"c
json.Serialize(writer, value)
Dim output As String = sw.ToString()
writer.Close()
sw.Close()
Return output
End Function
So, not to hijack the thread too much, but szlamany how are you finding this approach working out for you, rather than using the standard ASP.Net Controls?
I believe it is the holy grail.
My HTML is basically 4 divs - a binder, tracker, operator and work space - can't ask for a simpler HTML.
They are empty.
My database actually feeds a boot call to a web service that fills the tracker with an accordion and a variety of lookup panels.
I attached an image of that data at the bottom of the post
These are hidden in a 5th div - basically a repository of html segments that you might want to use. It clones objects from there as it reads the boot JSON that is returned.
And JSON is truly magic - after I parse it into a JS object I can call EVAL() on the values in the text returned by my database and convert some of those values into JS functions - that is magic.
Basically I can serialize both data and functionality in the JSON and have it expand in the DOM.
Does that sound a bit like silverlight?
At any rate the boot JSON also fills the OPERATOR div with a bunch of buttons - that will make calls to fill the WORK div with slickgrids and what not. All of these sitting in a tab panel that is effortless to use.
jQuery has a really incredible drag and drop library that allows me to do things like drag kids names to buttons or drag kids names to existing grids to make that grid switch to a different kid.
This seems to be like writing a winform in a browser - something I thought I would never achieve.
Where exactly is the jQuery section of the forum??
Look at the js code to make the accordion and fill the autocomplete textbox? That autocomplete textbox jQuery plugin doesn't do "tag" values for id - look how easy it was to "extend" it to do so. Just hijack the SELECT function - examples abound on the web. Plus I further "extended" it to do my "drag and drop" page-wide logic.
Take a real close look at the LONG statements - jQuery chains that work the dom effortlessly. Magic!
Code:
case "acs-tracker":
switch (value[0]) {
case "accordion":
$("#acs-panel").clone().appendTo("#acs-tracker").removeAttr("id").attr("id", value[1]).html("").addClass("acs-newaccordion");
break;
}
break;
case "acs-panels":
var newaccordion = $(".acs-newaccordion").attr("id")
for (var i = 0; i < value.length; i++) {
$("#acs-subpanel").clone().appendTo("#" + newaccordion).removeAttr("id").attr("id", value[i].acsid).children().html(value[i].acspanelname);
$("#acs-contentpanel").clone().appendTo("#" + newaccordion).removeAttr("id").attr("id", value[i].acsid).html(value[i].acspanelname).addClass("acs-emptyaccordion").data("ddtype", value[i].acsddtype);
}
break;
case "acs-tracker:autocompleteid":
var newaccordion = $(".acs-emptyaccordion:first").html("").attr("id") + "input"
$("#acs-input").clone().appendTo(".acs-emptyaccordion:first").removeAttr("id").attr("id", newaccordion).parent().removeClass("acs-emptyaccordion");
$('input.#' + newaccordion).attr("name", newaccordion);
$('input.#' + newaccordion).each(function() {
var autoCompleteElement = this;
var formElementName = $(this).attr('name');
var hiddenElementID = formElementName + '_autocomplete_hidden';
/* change name of orig input */
$(this).attr('name', formElementName + '_autocomplete_label');
/* create new hidden input with name of orig input */
$(this).after("<input type=\"hidden\" name=\"" + formElementName + "\" id=\"" + hiddenElementID + "\" />");
$(this).autocomplete({ source: value,
select: function(event, ui) {
var selectedObj = ui.item;
$(autoCompleteElement).val(selectedObj.label);
$('#' + hiddenElementID).val(selectedObj.value);
var parentObj = $(this).parent().data("ddtype")
if (parentObj != "") {
$(window).data("ddtype" + parentObj, selectedObj.value);
$(window).data("lastddtype", parentObj);
}
return false;
}
});
});
$('#' + newaccordion)[0].focus();
break;
*** Read the sticky in the DB forum about how to get your question answered quickly!! ***
Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".
Hmm, to an extent. This can certainly be achieved in Silverlight, although the technique would likely be implemented differently.
Originally Posted by szlamany
Where exactly is the jQuery section of the forum??
I have actually thought about suggesting that. Perhaps as a Sub Forum of JavaScript, or perhaps as a forum in it's own right. Might be worth a suggestion in the Forum Feedback.
wow. szlamany that looks brilliant. I like the look and feel of your site.
I've figured out how to handle dates in my Convert Datatable to JSON function. I just added the line highlighted in red. Now I have to figure out how to format the date to YYYY/MM/DD on the js side. this is much cleaner now. this is a fragment of my json:
Public Shared Function Serialize(ByVal value As Object) As String
Dim type As Type = value.[GetType]()
Dim json As New Newtonsoft.Json.JsonSerializer()
json.NullValueHandling = NullValueHandling.Include
json.ObjectCreationHandling = Newtonsoft.Json.ObjectCreationHandling.Replace
json.MissingMemberHandling = Newtonsoft.Json.MissingMemberHandling.Ignore
json.ReferenceLoopHandling = ReferenceLoopHandling.Ignore
'handle dates
json.Converters.Add(New IsoDateTimeConverter())
If type Is GetType(DataRow) Then
json.Converters.Add(New DataSetConverter())
ElseIf type Is GetType(DataTable) Then
json.Converters.Add(New DataTableConverter())
ElseIf type Is GetType(DataSet) Then
json.Converters.Add(New DataSetConverter())
End If
Dim sw As New StringWriter()
Dim writer As Newtonsoft.Json.JsonTextWriter = New JsonTextWriter(sw)
'If FormatJsonOutput Then
writer.Formatting = Formatting.Indented
'Else
'writer.Formatting = Formatting.None
'End If
writer.QuoteChar = """"c
json.Serialize(writer, value)
Dim output As String = sw.ToString()
writer.Close()
sw.Close()
Return output
End Function
wow. szlamany that looks brilliant. I like the look and feel of your site.
Remember that the "theme" of the site with jQuery is driven by a css that the jQuery community has produced.
They have a dozen default themes and you can alter them with the themeroller.
I had to make the font color for the ACTIVE state BLACK instead of WHITE because SLICKGRID used the "active" state to color a row that you are editing - and the background color didn't match with the WHITE font.
I used the START theme as the base and then rolled my own change into that.
The nice thing about all this is that those BUTTONS and ACCORDIONS and TABS all use this theme CSS in a consistent fashion making your page coherent with "0 effort" - that is productivity handed to you on a silver platter.
Originally Posted by Nitesh
szlamany I need so help again please. I see in the grouping example they use a dataview. I ain't using one, can I still have grouping?
Also, How can I edit a cell then save the information to my database?
I'm as new to the slickgrid as you - so your grouping / dataview question I cannot address...
As for the SAVE info - back in post #2 you can see the onCellChange event that I put in that would eventually lead to a DB update call...
Last edited by szlamany; Apr 1st, 2011 at 04:06 AM.
*** Read the sticky in the DB forum about how to get your question answered quickly!! ***
Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".
thanks for the link. definetely will use it in future. ok cool i understand I noticed the onCellChanged event. I tried adding it in my project and I get this error:
Code:
evt.notify is not a function
http://localhost:50646/OscarVB.Net/Javascript/slick.grid.js
Line 789
I'm sure I've included all the necessary js files:
Well - I just spent an hour trying to "re-do" all of yesterdays work - argh!!
All of a sudden my rows stopped showing - I tried to step into the slick grid and debug it - seeing that one row had made it into the HTML but for some reason not showing...
I usually save "full copies" of the web folder several times a day so that if I break something I can simply revert back and WINDIF my way back to a working app.
Didn't do that all day yesterday and needed to slowly re-do each edit - argh!!
You and I are pretty much at the same point - I'm not ready to do save logic because my build logic needs to mature further...
At any rate - here's the top of my page if you need to see my dep's. The slickgrid css files are required as well...
the ajax call is made to a PageMethod which looks like this:
Code:
<WebMethod()> _
Public Shared Function GetPriorities() As List(Of Priorities)
Dim dt As New DataTable
Dim strCon As String = System.Configuration.ConfigurationManager.ConnectionStrings("DB").ConnectionString
Dim PriorityList
Try
Using con As New SqlConnection(strCon)
Dim cmd As New SqlCommand("SELECT ID, Description FROM [Task_Priority] WHERE Active = 1")
cmd.Connection = con
con.Open()
Dim reader As SqlDataReader = cmd.ExecuteReader
dt.Load(reader)
PriorityList = (From row In dt.AsEnumerable() _
Let Id = row.Field(Of Integer)("ID") _
Let value = row.Field(Of String)("Description") _
Select New Priorities(Id, value) _
With {.ID = Id, .Value = value}).ToList()
con.Close()
reader.Close()
cmd.Dispose()
End Using
Catch ex As Exception
dt = Nothing
End Try
Return PriorityList
End Function
Thank you so much - that is something I'm going to need in the next day or two.
I've spent the past few days getting the "source", "options" and "columns" of my slickgrids to be read from my webservice/json feed. Working nicely.
I am putting several slickgrids in different TAB's. I'm going to have to disable buttons and tabs when in edit mode - seems you can leave grids in a bad state in other tabs - just starting to work through these issues.
Not sure if I want EDIT and SAVE buttons...
*** Read the sticky in the DB forum about how to get your question answered quickly!! ***
Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".
no prob let me know if you hit any snags with the dropdownlist code. Glad to hear you are making progress. I've got my grid displaying, also I grouped the data and I implemented the composite editor like in the composite_editor example.
I've done an AJAX call to save the data as well.
So my rows contain Tasks grouped by Topic. I am able to edit each task. Now I need to be able to add a New Topic. I'm still trying to figure out the best possible route
Well - I've got ADD and EDIT started in my app - pop-up a DIV that "covers" the grid so you have to work the ADD/EDIT until done - then I'll return you to the grid.
Either full grid data refresh or I'll try to surgically get the new row into the grid.
Not sure I'm going to allow "grid edit" - I might leave the grid read-only - or at least maybe the most complicated grids. The will need the "edit" DIV-cover...
At any rate I've got my add and edit webservices functioning and I'm auto-binding the "sql columns" based on the column name matching a "class" I put on the edit fields...
*** Read the sticky in the DB forum about how to get your question answered quickly!! ***
Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".
that sounds good do you know how to Remove All rows in the grid. I have a parent grid and a child grid. When I click the parent row I do an ajax call and then populate the child grid. I need to clear the child grid each time before it populates again. any idea
I'm afarid I've had to abandon this approach. I did everything I needed to like save data oncellchange etc, until I got to the grouping part.
I grouped the data by a field and the grid looked great, until I started clicking on a row and trying to get the row data. The grid was giving me Row 5 data for example if I clicked on Row 1.
And I realised it ain't my mistake cos I even tried it on the slickgrid example and got the same result
I'm afaid I wasted 2 weeks of development and I now have to look for an alternative approach. I did learn quite a bit about JSON though so I guess all is not lost
@nitesh - did you ever go back to the jQuery SlickGrid? I'm having some really good success with this myself and was wondering if you had time to re-look at your approach?
*** Read the sticky in the DB forum about how to get your question answered quickly!! ***
Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".
By the way szlamany, is the site you are creating public facing so that we could take a look at the fruits of your labour? Would be interesting to see.
Reply With Quote
szlamany you have been a great help
Originally Posted by gep13
