Comments by Thiyagu Arockiasamy (Top 83 by date)

5

Thanks a lot. i got output....

Thanks a lot sir

Dear sir its working for me. Thanks for your article

Incorrect syntax near '*'.

In this Error is occured

okay sir

yes sir

for example i have
371
382
371
371,382
382,380 records but its only search on

371
382
371

sir its only find the values in 371 and 382 Not like '371,382' or '382,380' values

Topic is string field in database

yes its correct sir but not working for me

Database also string in Topic. Topic (varchar(250),not null) its my database field.

its a comma separated values

String field in Topic sir

yes sir kindly help

its not working sir. there is no one records search it.

dear sir i changed my insert method its work fine sir. Thanks a lot

dear sir i changed my insert method its work fine sir. Thanks a lot

<p></p> tag is applicable for me sir after close </p> tag next paragraph start

dear sir after '.' is not a correct way for me sir. if i give Rs.120 Crore. It will take two spaces of two paragraph sir. please help

its only working for first paragraph sir . separated in lot of paragraphs sir. help me sir

dear sir not working for me sir . please help

Thanks a lot sir its Working for me

sir i declare but its showing all records, for example
SET @count = 'SELECT COUNT(CompanyID) FROM MulitSearch_Portal

EXEC ( ' select CAST(ROW_NUMBER() OVER(ORDER BY PrjInfoAsOfDate) AS INT) AS Row ,TotalRecords,CompanyID,CompanyName,AliasName,CompanyCategoryID,LegalTypeID,IncorpYear,CompanyCategory,LegalType,
IndstryID,IndstryName,SubIndstryID,SubIndstryName,ProductID,ProductName,ProjectID,ProjectTitle,ProjTypeID,ProjectType,PrjStatusID,ProjectStatus,
EstimateCost,GuesstimateCost,ActualCost,PrjInfoAsOfDate,ProjRegionID,ProjectRegion,PrjStateID,ProjectState,PrjDistrictID,PrjDistrict from ( SELECT ROW_NUMBER() OVER(ORDER BY CompanyID ) AS Row, ('+@count+') AS TotalRecords , * from ( '+@sql+' ) as T ) as pageResult where ( Row between (('+@pageno+' -1)* '+@pagesize+'+1) AND '+@pageno+' * '+@pagesize+' )' );

only 40 records are available in companyId based but display output is Fully records count. i want to specific parameters count values sir

Hi sir I want to need above procedure count sir . please help me sir

My friend also said thanks to you . thanks a lot....

Thanks sir its working.

Its very important that's why i am asking sorry

Thanks a lot Madhu....

Thanks for your help bro . thanks a lot

Thanks a lot :-)

Thanks a lot . Its Work Fine for me.

i finished this work. its work fine thanks

i want to load data while scrolling page down with jquery and html page

Thanks a lot F-ES Sitecore. It's work fine for me. Thank yo very much.

Thanks ji i finished

thanks thala i got it

i have one more doubt how to search particular textbox or dropdownlist list id via in dynamic binding pls tell

its fine ji. but i have one more doubt how to search particular textbox or dropdownlist list id via in dynamic

Thanks ji its fine

no

http://localhost:25012/NewsRestService.svc/NewsById/4

its work fine i want to dynamic search NewsID have anyone for example(1,2,3,4,..).
how can i get particular record passed dynamic id

ya its fine my question is if i give any one of if for example 2 or 3 how can i get the values. in my procedure id field is NewsID. pls tel

ok boss thanks

unga mail id enaku neenga tharave illa

.

iruku

thanks thala

thala mail id thanga . i would like to asked some questions on jquery ji.

okay mail id tharalame .

mail id ? thala

berakpoint does not read(go) in ajax. its only read function()

i'm use in this method

<script type="text/javascript">
$(document).ready(function () {
debugger;
$.ajax({
type: "GET",
url: 'http://localhost:25012/NewsRestService.svc/WrappedNewsById/4',
data: "{}",
contentType: "application/json; charset=utf-8",
dataType: "json",
cache: false,
}).success(function (data) {
$('#data').append(JSON.parse(data));
alert(data);
});
})
</script>

please tell me ajax call service method . i'm struggle

<script type="text/javascript">
$(document).ready(function () {
debugger;
$.ajax({
type: "GET",
url: 'http://localhost:25012/NewsRestService.svc/WrappedNewsById/4',
data: "{}",
contentType: "application/json; charset=utf-8",
dataType: "json",
cache: false,
}).success(function (data) {
$('#data').append(JSON.parse(data));
alert(data);
});
})
</script>

Another Type of Code is:

<script type="text/javascript">
debugger;
var service = 'http://localhost:25012/NewsRestService.svc/NewsById/';
$(document).ready(function () {
jQuery.support.cors = true;
$.ajax(
{
type: "GET",
url: service + '4',
data: "{}",
contentType: "application/json; charset=utf-8",
dataType: "json",
cache: false,
success: function (data) {
alert(data);
var trHTML = '';
$.each(data.newsid, function (i, item) {
'<div class="blog-post-content-desc">'
+ '<div class="blog-post-content">'
+ '

' + listvalues.newsid[0].NewsTopic + '

'
});
$('#blog-post-content-desc').append(trHTML);
},
error: function (msg) {
alert(msg.responseText);
}
});
});
</script>

Uncaught TypeError: Cannot read property 'toLowerCase' of undefined

its my error message. yes i serialised json format.i got output http://localhost:25012/NewsRestService.svc/NewsById/4 but i did not read in url using jquery.,

does not read it. not getting

I'm working in asp.net wcf rest service. below code is my service

public List<newss> NewsById(string NewsID)
{
string Status = TokenHelper.IsValidateToken();
using (DbConnection con = db.CreateConnection())
try
{
con.Open();List<newss> Lstnews = new List<newss>();
DbCommand cmd = db.GetStoredProcCommand("spNews_GetValues", NewsID);
cmd.CommandTimeout = int.MaxValue;
SqlDataReader objnewsRead = (SqlDataReader)db.ExecuteReader(cmd);
while (objnewsRead.Read())
{
Lstnews.Add(new Newss()
{
NewsID = objnewsRead.GetInt32(objnewsRead.GetOrdinal("NewsID")),
NewsCompId = objnewsRead.GetInt32(objnewsRead.GetOrdinal("NewsCompId")),
CompanyId = objnewsRead.GetInt32(objnewsRead.GetOrdinal("CompanyIds")),
CompanyLegalName = objnewsRead.GetString(objnewsRead.GetOrdinal("CompanyLegalName")),
});
}

return Lstnews;
}
finally
{
con.Close();
}
}

IService code:

[OperationContract]
[WebGet(UriTemplate = "WrappedNewsById/{NewsID}", ResponseFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.Wrapped)]
List<newss> NewsById(string NewsID);

Thanks A Lot sir, really you save my lot of time sir..... Thank You very much sir........ It's working fine to me sir.

Thanks a Lot sir . IT's working fine to me. Thanks again

dear sir if i deserialize this JSON the array. "[{.....}]" is displayed. how to remove " " sir. code below

var JsonNews = Newtonsoft.Json.JsonConvert.SerializeObject(Lstnews);
var jobject = sonConvert.DeserializeObject<List<newss>>(JsonNews);
return JsonNews;

i am using wcf rest service WEB API

my rest service code is

[OperationContract]
[WebGet(UriTemplate = "NewsById/{NewsID}", ResponseFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.Wrapped)]
string NewsById(string NewsID);

And my Jquery code of Html page :

<script type="text/javascript">
$(document).ready(function () {
debugger
$.ajax({
crossDomain: true,
async: true,
cache: false,
type: "GET",
url: 'http://localhost:25012/NewsRestService.svc/NewsById/4',
data: JSON.stringify(),
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (response) {
alert(response.d);
},
failure: function (response) {
alert(response.responseText);
}
});
}
);
</script>

i am using wcf rest service sir.

Dear sir, i check it, you demo output is fine its a valid joson. but my output of json is

{"NewsByIdResult":"[{\"NewsID\":4,\"CompanyId\":160,\"NewsCompId\":7,\"CompanyLegalName\":\"TCS BUSINESS INFORMATION\"}]"}

please how can i remove array of "". if i remove " " its work fine. please help me sir

okay sir thanks a lot.And one more question , How to get json data in html page using jquery.

I get raw data in below code.

public string NewsById(string NewsID)
{
string Status = TokenHelper.IsValidateToken();
using (DbConnection con = db.CreateConnection())
try
{
con.Open();
List<newss> Lstnews = new List<newss>();
DbCommand cmd = db.GetStoredProcCommand("spNews_GetValues", NewsID);
cmd.CommandTimeout = int.MaxValue;
SqlDataReader objnewsRead = (SqlDataReader)db.ExecuteReader(cmd);
while (objnewsRead.Read())
{
Lstnews.Add(new Newss()
{
NewsID = objnewsRead.GetInt32(objnewsRead.GetOrdinal("NewsID")),

NewsCompId = objnewsRead.GetInt32(objnewsRead.GetOrdinal("NewsCompId")),
CompanyId = objnewsRead.GetInt32(objnewsRead.GetOrdinal("CompanyIds")),
CompanyLegalName = objnewsRead.GetString(objnewsRead.GetOrdinal("CompanyLegalName")),


}
var JsonNews = Newtonsoft.Json.JsonConvert.SerializeObject(Lstnews);
return JsonNews;

}
finally
{
con.Close();
}
}

Its my service code


Please help me

Sir, i implement joson data with HTML page using jquery its not work.i added my HTML page jquery code please help me

<script type="text/javascript">
$(document).ready(function () {
debugger
$.ajax({
crossDomain: true,
async: true,
cache: false,
type: "GET",
url: 'http://localhost:25012/ProjectRestService.svc/NewsById/4',
data: JSON.stringify(),
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (response) {
alert(response.d);
},
failure: function (response) {
alert(response.responseText);
}
});
}
);
</script>

Okay sir but its not working. i implement joson data with HTML page using jquery its not work.i added my HTML page jquery code please help sir

<script type="text/javascript">
$(document).ready(function () {
debugger
$.ajax({
crossDomain: true,
async: true,
cache: false,
type: "GET",
url: 'http://localhost:25012/ProjectRestService.svc/NewsById/4',
data: JSON.stringify(),
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (response) {
alert(response.d);
},
failure: function (response) {
alert(response.responseText);
}
});
}
);
</script>

How can i remove "" . please tell me

Its not a smile Its "CompanyID\":0, In this ID No need

CompanyID No need sir

i only got output in raw data i want to need joson data. i used code

var JsonNews = Newtonsoft.Json.JsonConvert.SerializeObject(Lstnews);
return JsonNews;

its only get raw data, but i need json data

{"NewsByIdResult":"[{\"NewsID\":4,\"CompanyID\"Blush | :O ,\"CompanyIds\":null,\"CompanyId\":160,\"CompanyIdVal\":null,\"Topic\":\"280\",\"Industry\":83,\"CompanyLegalName\":\"TCS BUSINESS INFORMATION\"}]"}

Okay, then how can to remove the \ symbol in raw data. i couldn't able to bind the value.