连接前台和后台数据库是一样的,问题是你想采用哪种技术连接数据库,每种连接都有所差别
1.C#连接连接Access
程序代码:
------------------------------------------------------------------------------- using System.Data;
using System.Data.OleDb;
..
string strConnection=Provider=Microsoft.Jet.OleDb.4.0;;
strConnection+=@Data Source=C:BegASPNETNorthwind.mdb;
OleDbConnection objConnection=new OleDbConnection(strConnection);
..
objConnection.Open();
objConnection.Close();
2.C#连接SQL Server
程序代码:
--------------------------------------------------------------------------------
using System.Data;
using System.Data.SqlClient;
..
string strConnection=user id=sa;password=;;
strConnection+=initial catalog=Northwind;Server=YourSQLServer;;
strConnection+=Connect Timeout=30;
SqlConnection objConnection=new SqlConnection(strConnection);
..
objConnection.Open();
objConnection.Close();
3.C#连接Oracle
程序代码:
--------------------------------------------------------------------------------
using System.Data.OracleClient;
using System.Data;
//在窗体上添加一个按钮,叫Button1,双击Button1,输入以下代码
private
void Button1_Click(object sender, System.EventArgs e)
{
string ConnectionString=Data Source=sky;user=system;password=manager;;//写连接串
OracleConnection conn=new OracleConnection(ConnectionString);//创建一个新连接
try
{
conn.Open();
OracleCommand cmd=conn.CreateCommand();
mandText=select * from MyTable;//在这儿写sql语句
OracleDataReader odr=cmd.ExecuteReader();//创建一个OracleDateReader对象
while(odr.Read())//读取数据,如果odr.Read()返回为false的话,就说明到记录集的尾部了
{
Response.Write(odr.GetOracleString(1).ToString());//输出字段1,这个数是字段索引,具体怎么使用字段名还有待研究
}
odr.Close();
}
catch(Exception ee)
{
Response.Write(ee.Message); //如果有错误,输出错误信息
}
finally
{
conn.Close(); //关闭连接
}
}
取消
评论