Member Avatar for 3xxx

I am more interested to know
a site that got sample web access code -- to access SQL server / oracle database
== could include any of the following language
--- c# , vb.net, jsp
--- asp, javascript
-- ajax
answer could be in form of the coolest CMS on earth


-- acutally, I just rephrase and summarise, of what everybody is saying in this thread, heheheheh (but could anyone give us a NAME of the software )

  • 4 Contributors
  • 3 Replies
  • 95 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by Ezzaral

Dani AI

Generated

This thread is asking for concrete examples of how to access SQL Server and Oracle from web code (C#/VB.NET, JSP/Java, classic ASP, client-side AJAX). and were right that the question needed focus; correctly pointed out a web-based management option (MyLittleAdmin) but that doesn't replace sample client/server access code. The pragmatic approach is: pick the server-side stack you will run (ASP.NET or Java servlet/JSP), then use the platform's DB driver (ADO.NET or JDBC) and expose server endpoints for any AJAX clients.

For .NET (C#/VB.NET) use ADO.NET (SqlClient for SQL Server; ODP.NET for Oracle). For Java/JSP use JDBC and the Oracle/SQL Server drivers. Authoritative references: SqlConnection / ADO.NET docs, Oracle JDBC guide, and the OWASP SQL Injection Prevention Cheat Sheet for security best practices.

A minimal safe pattern in C# (ADO.NET) — open, parameterize, dispose — looks like:

using (var conn = new SqlConnection(connString))
{
    using (var cmd = new SqlCommand("SELECT Name FROM Users WHERE Id = @id", conn))
    {
        cmd.Parameters.AddWithValue("@id", id);
        conn.Open();
        var name = (string)cmd.ExecuteScalar();
    }
}

Practical tips: never put DB credentials in client-side code or return SQL errors to users; store connection strings in configuration and use encrypted config sections when needed; install the correct DB driver (ODP.NET / JDBC) and watch 32/64-bit mismatches, listener/port issues, and firewall rules. For ready-made .NET CMS examples that include DB access patterns try Umbraco or DNN; for Java portals consider Liferay.

Recommended Answers

All 3 Replies

Member Avatar for sknake

I don't understand what you're asking or how it relates to MSSQL. You're concerned with the programming languages over SQL so you might want to try another forum and ask a more specific question.

Member Avatar for thewebhostingdi

If you are looking to know the name of the web application that can be used instead of Ms SQL Enterprise Manager then MyLittleAdmin is such a web application.

Member Avatar for Ezzaral

That was the thread he originally post this in. I can't really figure what the heck he is asking either, but he mentioned MS SQL so I dropped it in here.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.