using System.Data.SqlClient; using System.Configuration; public static readonly string sqlcon = ConfigurationManager.ConnectionStrings["xsConnectionString1"].ConnectionString; DataSet ds = new DataSet(); private void Databind() { SqlConnection con = new SqlConnection(sqlcon);
1.连接数据库
(1)在web.config文件中添加连接字符串
<configuration>
<connectionStrings>
<add name="连接字符串" connectionString="Data Source=.; Initial Catalog=数据库;uid=sa;pwd=;" providerName ="System.Data.SqlClient" />
</connectionString>
</configration>
(2)在使用页面创建连接字符串
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["连接字符串"].ConnectionString);
2.访问和操作数据库(SqlCommand对象)
(1)普通SQL访问和操作
conn.Open(); //打开数据库连接,conn为数据库连接字符串对象,同1中的conn
SqlCommand cmd=new SqlCommand("delete from employees where eID="+eid, conn);
cmd.ExecuteNonQuery();
conn.Close();
(2)执行存储过程
conn.Open();
SqlCommand cmd = new SqlCommand(proc, conn); //执行存储过程,proc为存储过程名
cmd.CommandType = CommandType.StoredProcedure;//cmd命令类别
cmd.Parameters.Add("@eid", SqlDbType.Int).Value = u.eID; //为存储过程 添加参数
cmd.Parameters.Add("@ename", SqlDbType.VarChar, 10).Value = u.eName;
cmd.ExecuteNonQuery(); // 执行cmd命令
using System.Configuration;
public static readonly string sqlcon = ConfigurationManager.ConnectionStrings["xsConnectionString1"].ConnectionString; DataSet ds = new DataSet();
private void Databind()
{
SqlConnection con = new SqlConnection(sqlcon);
你上面写得不错,支持下楼上的,但好像是连接到Oracle数据库,你写成Sql数据库啦
哦,就是!
Oracle数据库连接楼主应该会吧,这是小问题了。
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
OracleConnection conn;
try
{
conn = new OracleConnection(ConnectionStringForOracle);
}
catch (Exception)
{
return -1;
} PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
int val = 0;
try
{
val = cmd.ExecuteNonQuery();
conn.Close();
conn.Dispose();
}
catch (Exception ex)
{
conn.Close();
val = -1;
}
return val;
public OracleConnection OpenCnn()
{
//string conn1 = ConfigurationSettings.AppSettings["Oracle"]; //OracleConnection conn = new OracleConnection(conn1);
OracleConnection conn = new OracleConnection(ConfigurationSettings.AppSettings["Database"]);
conn.Open(); //提示ConnectionString 属性尚未初始化
return (conn);
} app.config:<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add name="Database" connectionString="User ID=pacs31;Password=pacs31;Data Source=pacs;"/>
</connectionStrings>
</configuration>调用时老是提示:ConnectionString 属性尚未初始化
string constring = "Data Source=myoracle;User Id=sys;Password=123;"
using(OracleConnection conn = new OracleConnection(constring ))
{
conn.Open();
}