This becomes a very strange problem to me. from my sp i am returning like
Declare @NewTable as table(ID bigint,
LoginName nvarchar(500),
Password nvarchar(200),
FirstName nvarchar(50),
MiddleName nvarchar(500),
LastName nvarchar(500),
UserPicture Image,
Address nvarchar(1500),
City nvarchar(100),
State nvarchar(100),
MobileNo nvarchar(50),
LandLineNo nvarchar(100),
EmailAddress nvarchar(50),
DateOfBirth nvarchar(50),
IsActive bit,
Country nvarchar(100));
Insert @NewTable EXEC(@Query)
select ID,LoginName,Password,FirstName,MiddleName,LastName,UserPicture,Address,City,IsActive from @NewTable
Previously Addresss column written in last so Kendo Grid was showing blank but when i move it in between the Kendo Grid Showing data with adress column as well as. Now whats happening that due to IsActive column Kendo Grid not showing when i removed IsActive column Kendo grid showing data.
when I adjust IsActive column in between LastName,*Middlename* or so on... in my Query then Kendo Grid shows data. so I believe that data type is not a matter. This is becoming very tough for me that what actually creating the problem. For more info Please see the link i posted here but didn't found answer
