asp.net open source solution to "Adding a row to a specific SQL table"? [closed]

Closed. This question is seeking recommendations for books, tools, software libraries, and more. It does not meet Stack Overflow guidelines. It is not currently accepting answers开发者_StackOverflow.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 7 years ago.

Improve this question

I'm doing a web interface using asp.net, where user can add a row to a table in a SQL database. It's the same as add a row directly in MS access. It seems I'm reinventing the wheels.

So is there any open source solutions or classes that can reduce my work? Like the validation part..

---

I am not exactly sure if that fits your needs, but I would recommend you to have a look at the Stack Exchange Data Explorer by Sam Saffron. Technically you can send any kind of SQL statements and therefore also add rows. It does not have a strict validation implemented but it uses CodeMirror for syntax highlighting.

To get an idea about it you can check it out here. Hope that helps.

Update

If it's an "Access like" interface I would recommend you to have a look at the ASP.NET's DataGrid or the newer DataView.

---

please correct me if i'm wrong. I do remember SQL server having a web management tool that allows you to modify SQL databases like an installed management component.