Bind and Delimit a stringarray property value in web control and Update content

peter liles 556 Reputation points
2021-06-03T00:27:39.417+00:00

I would like to be able to bind and convert a stringarray value property into a list for output in web control like gridview bound to datasource like SqlDatasource and able to perform tasks like add string value,update a string value and delete string value from list and save back to database as a string array property. Can this be done without manipulate in code behind?

ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,263 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,553 questions
{count} votes

6 answers

Sort by: Most helpful
  1. Erland Sommarskog 101.1K Reputation points MVP
    2021-06-08T20:57:06.247+00:00

    You can easily write a function that cracks a comma-separated list into table format.

    On my web site I have an article that shares some simple functions for this purpose, and there is also a section for how to deal with a comma-separated list in a table: https://www.sommarskog.se/arrays-in-sql.html.

    0 comments No comments