how to insert tags into json format in sql server using webapi

Rupesh N

5y755.NET

Hi,

I am developing a small web application.

but, i struck in two place in our application.

1. insert JSON format.

2. insert title with replace space to "-"

1. problem:

actually, I write a form. and one tags textbox there. enter below format.

ex. tags : r, u,p,e,s,h

it's converted into JSON string by using angular.

ex: ["r","u","p","e","s","h"]

But, it is not inserted in json formate. only inserted into normal format(r,u,p,e,s,h).

2. problem:

actually, i have two textboxs. both are title based. but, first text box is user enter the title. and second textbox will convert automatically replace space to hyphen (-). basically, i want convert in webapi controller file. but, not converted.

i am using this syntax:

post.postTitle.Split(new string[] { "-", " " }, StringSplitOptions.RemoveEmptyEntries).

but, not converted.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kiran Mohanty5y ago
Below code should solve your first problem .
var input = "r, u,p,e,s,h";
var arr=input.split(',');

console.log(arr)
0
Rupesh N5y ago
Sachin Singh, thank you . it working for 2nd problem.
1st problem:: how to dynamically converted. baz, user will enter the input.
ex: r,u,p,e,s,h.
so, it's converted json format
0
Sachin Singh5y ago
1.use formatted string

string myString = @""r","u","p","e","s","h"";



SqlCommand cmd = new SqlCommand(sql, conn);

cmd.CommandType = CommandType.Text;

SqlParameter p1 = cmd.Parameters.AddWithValue("@p1", myString);

cmd.ExecuteNonQuery();

2.use replace method

string output = post.postTitle.Replace(" ", "-");
0

how to insert tags into json format in sql server using webapi

Sachin Singh, thank you . it working for 2nd problem.