how I can connect website to database (read and write)?

Answer 1

it depends on which webhost you are using
you can create a database, username and password
from control panel and then write php code to read/write on the database

Answer 2

Database is a science in itself. If you go with a real database such as Derby, then you will be using some language, like MySQL, to work the database and then a programming language to display the results and query back and forth to MySQL. Programming languages would include Java, C# (for .NET) or PERL script to tie it all together. PHP is another popular script language.

XML offers the most dynamic flexibility both for data storage and web page display. XML is plain text. The same XML would not only offer web pages, but also be useful for .PDF, and word processing docs. XML is whole other approach to the same DB problem. XML manipulation has many tools and that is the problem, wading through what approach offers the most convience methods.

The other choices you make include if the server you will be using runs WIN-based or Linux-based. WinServer2003 will probably run .NET. A Linux server will probably run Apache/java.

Either way, the software has to convert the data into a web page. The web page has to have software to record changes to send back to the server.

All of the DB/web stuff is a Server-side application.

Answer 3

If you intend on using the access database, you have no choice but to get windows hosting. Then you connect to the database via php or asp.

Answer 4

this is a real code in vs2005 C#.net
install vs2005 and install vs2005 asp.net SDK
you can see more sample in sdk for using and learning
other solution is avalible but ms-vs2005.net have more userfrendly and have more technical help in sdk and msdn





using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
ConnectionStringSettings settings;
settings = ConfigurationManager.ConnectionStrings["IccimTirDataConnectionString"];
SqlConnection myCon = new SqlConnection(settings.ConnectionString);

string strSql = "SELECT * FROM News ";

string strScrolling = "";

HtmlTableCell cellScrolling = new HtmlTableCell();

SqlCommand myComd = new SqlCommand(strSql, myCon);

SqlDataReader sqlRdr;

try
{
myCon.Open();
sqlRdr = myComd.ExecuteReader();
strScrolling = "";
while (sqlRdr.Read())
{

strScrolling = strScrolling + " ">" +
sqlRdr.GetValue(2) +
"  ";

}

strScrolling = strScrolling + "";
sqlRdr.Close();
DIV_MarqueeTop.InnerHtml = strScrolling;

}

catch (Exception msg)
{

Response.Write(msg.Message);

}

finally
{

//close sql connection

myCon.Close();

}

}
}

Answer 5

depends on which language u r using .net? php? java?
and what is the database type?