Issue to project

Peter_1985 2,526

Hi,
The project below is to further put more comment/remark there. How to improve the way to ensure details are saved into table properly?
https://1drv.ms/u/s!Ai8CrEskdewXwwIDrlmSTcZnMvPH?e=wcaPGP

Karen Payne MVP 35,191 Reputation points

2022-03-03T09:52:03.323+00:00

Better to place what is on OneDrive into a GitHub repository which allows those who are interested in helping to easily view code by pressing . which opens VS Code online.
Yijing Sun-MSFT 7,066 Reputation points

2022-03-04T02:36:50.31+00:00

Hi @Peter_1985 ,
I suggest you could post your codes with problems to us on this thread and more experts will help you.
Best regards,
Yijing Sun
Yijing Sun-MSFT 7,066 Reputation points

2022-04-01T05:50:08.01+00:00

Hi @Peter_1985 ,
I find this thread is too long and many people can't know what you want to do now. So,I suggest you could post a new thread and copy your key codes about your problems on it. It will more experts find your problems and helps you solve your problems faster.
Best regards,
Yijing Sun
Peter_1985 2,526 Reputation points

2022-04-01T06:12:21.427+00:00

Hi,
Thanks. I've raised the following one.
https://learn.microsoft.com/en-us/answers/questions/796486/issue-to-commentdescription-field.html

4 answers

Yijing Sun-MSFT 7,066 Reputation points

2022-03-08T05:45:59.917+00:00

Hi @Peter_1985 ,
You could use jQuery AJAX and WebMethod, the records will be fetched using DataSet received as XML string and then the XML string will be used to populate (bind) the ASP.Net Repeater on Client Side using jQuery.

Best regards,
Yijing Sun
Please sign in to rate this answer.

1 person found this answer helpful.
Peter_1985 2,526 Reputation points

2022-03-08T06:54:55.533+00:00

Hi,
Thanks a lot. Can you advise if comment field is one Nvarchar Data type and I'm getting that per one given User ID against the comment table? Can you also share the above code on a text file if possible?

Yijing Sun-MSFT 7,066 Reputation points

2022-03-09T02:50:36.33+00:00

Hi @Peter_1985 ,

Can you advise if comment field is one Nvarchar Data type and I'm getting that per one given User ID against the comment table?

It's ok for any data type in your database. You could use above codes and then it will return json type data. You need convert the json data in the client.

Best regards,
Yijing Sun

Peter_1985 2,526 Reputation points

2022-03-09T09:52:05.263+00:00

Hi,
Can you help if I can pass more parameters to the following SqlCommand?

Yijing Sun-MSFT 7,066 Reputation points

2022-03-10T09:37:46.347+00:00

Hi @Peter_1985 ,
What's meanings of passing more parameters to SqlCommand? Do you want to add parameters in new SqlCommand()? By the way, about the red line of cmd, you have defined SqlCommand cmd, so you aren't necessary write SqlCommand again before cmd.

Best regards,
Yijing Sun

Peter_1985 2,526 Reputation points

2022-03-10T12:42:55.953+00:00

Hi Yijing,
I mean to use cmd.Parameters.Add to pass values to my SqlCommand in above.

Yijing Sun-MSFT 7,066 Reputation points

2022-03-11T08:20:49.75+00:00

Hi @Peter_1985 ,
You could do like this:

command.Parameters.Add("filedname", SqlDbType.VarChar); command.Parameters["filedname"].Value = value;

Best regards,
Yijing Sun

Peter_1985 2,526 Reputation points

2022-03-11T08:39:07.667+00:00

Hi,
Can you help to error below

The type or namespace name 'WebMethodAttribute' could not be found (are you missing a using directive or an assembly reference?)

due to such line?

Peter_1985 2,526 Reputation points

2022-03-15T06:56:24.277+00:00

Hi,
Can you help?

Yijing Sun-MSFT 7,066 Reputation points

2022-03-17T06:31:36.22+00:00

Hi @Peter_1985 ,
Add a reference to System.Web.Services.dll in your project. And add the reference in your page.

using System.Web.Services;

Best regards,
Yijing Sun

Peter_1985 2,526 Reputation points

2022-03-17T06:39:49.743+00:00

Hi,
I have extra parameter to the command and cannot make it work to your given GetData event. Can you help?

Yijing Sun-MSFT 7,066 Reputation points

2022-03-17T08:43:49.147+00:00

Hi @Peter_1985 ,
What's your requirement? Could you tell us what want to do with your project? How do you do? What are the parameters? Please tell us details.
Best regards,
Yijing Sun

Peter_1985 2,526 Reputation points

2022-03-17T09:22:49.823+00:00

Hi,
I try to have the similar approach like yours and got issue to Label value below

Yijing Sun-MSFT 7,066 Reputation points

2022-03-18T08:30:08.713+00:00

Hi @Peter_1985 ,
According to your codes, lb_user_id may be is your control's id in your page. You could check if you have a label control which id is lb_user_id in your aspx page.
Best regards,
Yijing Sun

Peter_1985 2,526 Reputation points

2022-03-20T15:37:27.277+00:00

Hi,
I have the similar code in the project and have re-deployed it already. How to ensure that the relevant event has been triggered well to show the Description field exactly?

Yijing Sun-MSFT 7,066 Reputation points

2022-03-21T08:48:03.327+00:00

Hi @Peter_1985 ,
Your ajax post url must match the webmethod: getDesc. However,in your url is GetDesc.
Best regards,
Yijing Sun

Peter_1985 2,526 Reputation points

2022-03-21T09:47:25.36+00:00

I did put the similar codes like what you posted. Why can't I see that is affecting (or showing) by the previously given URL?

Yijing Sun-MSFT 7,066 Reputation points

2022-03-22T06:21:15.753+00:00

Hi @Peter_1985 ,
Do you have debug your codes? If there are errors? And I find an error that your page name _Default but your url is Default. You need to check carefully.
Best regards,
Yijing Sun

Peter_1985 2,526 Reputation points

2022-03-22T07:28:35.59+00:00

Hi,
Can you refer to the project below? I does prompt "undefined" when running it. I don't know the issue of the similar code like yours.
https://1drv.ms/u/s!Ai8CrEskdewXxS3GeBUQ8q5JJnu6?e=MsA89F

Yijing Sun-MSFT 7,066 Reputation points

2022-03-23T06:45:49.76+00:00

Hi @Peter_1985 ,
According to your codes,I find two problems.
First,you need to change RegisterRoutes. In the App_Start folder, do like this in the RouteConfig.cs file.

public static void RegisterRoutes(RouteCollection routes) { var settings = new FriendlyUrlSettings(); settings.AutoRedirectMode = RedirectMode.Off; //change permanent to off. routes.EnableFriendlyUrls(settings); }

Second, your GetDesc method need to add static. Like this:

[WebMethod] public static string GetDesc() { }

Best regards,
Yijing Sun

Peter_1985 2,526 Reputation points

2022-03-23T06:50:29.987+00:00

Hi,
I do not see RegisterRoutes inside the project.

Peter_1985 2,526 Reputation points

2022-03-25T06:19:10.1+00:00

Hi,
Can you help to my last update in above?

Peter_1985 2,526 Reputation points

2022-03-25T06:19:52.157+00:00

Hi,
Can you help to my last update (posted yesterday) in above?

Yijing Sun-MSFT 7,066 Reputation points

2022-03-28T07:35:44.727+00:00

Hi @Peter_1985 ,
What's your last post?You have deleted too many and this make me can't find your problems. Do you can't find App_Start folder? Do you show all folders?
Best regards,
Yijing Sun

Peter_1985 2,526 Reputation points

2022-03-28T08:56:21.777+00:00

Hi,
Where is your mentioned path? Can you refer to the project below?
https://1drv.ms/u/s!Ai8CrEskdewXxTYbRl0bX5Hbz2rJ?e=C4oOUB

Peter_1985 2,526 Reputation points

2022-03-31T02:51:20.37+00:00

Hi,
Can you refer to project below having App_start path inside?
https://1drv.ms/u/s!Ai8CrEskdewXxTt_Y20A2pIsKuKQ?e=EHFHxH

Yijing Sun-MSFT 7,066 Reputation points

2022-03-31T09:00:47.15+00:00

Hi @Peter_1985 ,
I can't open your package.I suggest you could post a new thread and copy your key codes about your problems on it. It will more experts find your problems and helps you solve your problems faster.
Best regards,
Yijing Sun

Peter_1985 2,526 Reputation points

2022-03-31T12:32:09.507+00:00

Hi,
Can you retry to refer to project below having App_start path inside?

https://1drv.ms/u/s!Ai8CrEskdewXxT3fgUhuc-fZymHv?e=IHWJY6
Sign in to comment
Peter_1985 2,526 Reputation points

2022-03-04T02:50:49.277+00:00

Hi,
To the code example below, I want to know how to improve it to be able to retrieve comments from table, upon refreshing the page? Can you refer to the project?
Please sign in to rate this answer.
Yijing Sun-MSFT 7,066 Reputation points

2022-03-04T06:15:29.73+00:00

Hi @Peter_1985 ,
I want to check your meanings that you want to retrieve data which inside the CKEditor? Why you need to retrieve?
Best regards,
Yijing Sun

Peter_1985 2,526 Reputation points

2022-03-04T06:27:48.38+00:00

Hi,
Yes, to retrieve also any existing comments from the relevant table, upon refreshing the page.

Yijing Sun-MSFT 7,066 Reputation points

2022-03-04T07:43:19.873+00:00

Hi @Peter_1985 ,
I think your requirement is get all value from your relevant CKEditor. Right?
Best regards,
Yijing Sun
Sign in to comment
Peter_1985 2,526 Reputation points

2022-03-04T08:28:06.333+00:00

Hi,
The save event should be able to save all comments (one by one) into the table, and when refreshing the web page, the comments saved inside the table, should be retrieved and put into CK editor (one comment after another).
Please sign in to rate this answer.
Yijing Sun-MSFT 7,066 Reputation points

2022-03-07T08:36:09.457+00:00

Hi @Peter_1985 ,
CKEditor is a pure JavaScript component and it does not offer anything more than JavaScript methods and events to access the data. You could use ajax with CKEDITOR.editor.getData to get and save data. At the same thing,you could use ajax to return the data from your database.
Best regards,
Yijing Sun

Peter_1985 2,526 Reputation points

2022-03-07T09:01:16.857+00:00

Hi,
Is there any other better approach to retrieve the saved remark/comment, and show it on the ASP page, other than using CKeditor? For instance that remark/comment could be originally edited/input by CK Editor.

Yijing Sun-MSFT 7,066 Reputation points

2022-03-08T03:30:23.857+00:00

Hi @Peter_1985 ,
CKEditor is a text editor.If you just want to show comment on the page,you could use any controls, such as labels,Repeaters, Listview and so on. About how to show data from your database,I suggest you could use ajax to return the value.
Best regards,
Yijing Sun

Peter_1985 2,526 Reputation points

2022-03-08T03:44:59.977+00:00

Hi,
Can you share with the concrete example way to this?
Sign in to comment
Ashraf Abo elnassr Abo elmagd 1 Reputation point

2022-03-21T08:49:02.237+00:00

I suggest you could post your codes with problems to us on this thread and more experts will help you.
Best regards,
Please sign in to rate this answer.
Peter_1985 2,526 Reputation points

2022-03-21T12:38:54.117+00:00

Can you help to it below

https://1drv.ms/u/s!Ai8CrEskdewXxSuyEwSXhgUGW4Ow?e=iJ3qAT
Sign in to comment