具体代码如下
web.config
<appSettings>
<add key="ConnString" value="uid=sa;password=;database=web2AiYou;server=(local)" />
<add key="Charset" value="gb2312"/>
</appSettings>叶面执行:
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
if(!this.IsPostBack)
{
string strConnection=ConfigurationSettings.AppSettings["ConnString"];
SqlConnection conn = new SqlConnection(strConnection);
string SQLstr="SELECT top 10 * FROM tb_memberinfo order by id desc";
SqlDataAdapter da = new SqlDataAdapter(SQLstr,conn);
conn.Open();
DataSet DS=new DataSet();
da.Fill(DS,"tb_memberinfo");
//向DastaGrid填充数据
userinfo.DataSource=DS; userinfo.DataBind();
}
}
错误信息如下
Exception Details: System.InvalidOperationException: The ConnectionString property has not been initialized.另外求中文版的vs.net2003的下载地址
web.config
<appSettings>
<add key="ConnString" value="uid=sa;password=;database=web2AiYou;server=(local)" />
<add key="Charset" value="gb2312"/>
</appSettings>叶面执行:
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
if(!this.IsPostBack)
{
string strConnection=ConfigurationSettings.AppSettings["ConnString"];
SqlConnection conn = new SqlConnection(strConnection);
string SQLstr="SELECT top 10 * FROM tb_memberinfo order by id desc";
SqlDataAdapter da = new SqlDataAdapter(SQLstr,conn);
conn.Open();
DataSet DS=new DataSet();
da.Fill(DS,"tb_memberinfo");
//向DastaGrid填充数据
userinfo.DataSource=DS; userinfo.DataBind();
}
}
错误信息如下
Exception Details: System.InvalidOperationException: The ConnectionString property has not been initialized.另外求中文版的vs.net2003的下载地址
解决方案 »
- 论坛鼠标悬停显示名片的效果
- 如何在页面加载时,将光标定位到某行模板列中的TEXTBOX中?
- 在.net里怎么用xml和xsl把新闻生成静态页面
- DataList分页(类封装的)
- 如何在客户端实现自定义纸张?(xp/2000)
- 看到一个web 程序,登陆后用cookie 来保存用户的信息, 请问这里用session 不是更好吗?
- TreeView的问题
- 请问"微软.NET官方网站使用的论坛源码"为什么和我们通常的开发方法不同?
- 在Asp.net中,怎么取得javascript:return prompt的返回值啊?
- asp.net mvc简单页面qps只有600
- 关于获得用户的问题??
- 再开一贴:if ((new AccessTask()).CheckUserPwd(YongHuMing.Text.Trim()) == MiMa .Text.Trim ())
地址重新发一次
http://community.csdn.net/Expert/topic/4625/4625761.xml?temp=.3466608没有结帖的是这个,100分
打开以后没有关闭。<add key="ConnString" value="uid=sa;password=;database=web2AiYou;server=(local)" />
server=localhost
试试
Data Source = (local);Integrated Security = SSPI;Initial Catalog = 数据库名
也不能F5来运行,只能生成来运行提示说我什么这个工程没有配置debugging不能调试
myConnection=new SqlConnection("Server=localhost;uid=sa;pwd=;database=bbb");
String mysqlstr="Select * From Table_Money where a1=@a1";
SqlCommand mycom=new SqlCommand(mysqlstr,myConnection);
mycom.Parameters.Add(new SqlParameter("@a1",SqlDbType.VarChar));
mycom.Parameters["@a1"].Value=project;
SqlDataAdapter myDataAdapter=new SqlDataAdapter(mycom);
myConnection.Open();
DataSet myDS=new DataSet();
myDataAdapter.Fill(myDS,"Table_Money");
dg1.DataSource=myDS;
dg1.DataBind();
myConnection.Close();
<add key="ConnectString" value="server=localhost;database=数据库名;uid=用户名;pwd=密码;"/>
</appSettings>using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;namespace PriceChange.Components
{
/// <summary>
/// 通过Ado.net与数据库相连
/// </summary>
public class database
{
private SqlConnection Conn;
private System.Data.SqlClient.SqlTransaction myTransaction;
//打开数据库连接
public void Open()
{
if(Conn==null)
{
Conn=new SqlConnection(ConfigurationSettings.AppSettings["ConnectString"]);
}
if(Conn.State==System.Data.ConnectionState.Closed)
{
Conn.Open();
}
}
//关闭数据库连接
public void Close()
{
if(Conn!=null)
{
this.Conn.Close();
}
}
//释放连接资源
public void Dispose()
{
if(Conn!=null)
{
this.Conn.Dispose();
this.Conn=null;
}
}
//事务开始
public void BeginTransaction()
{
if(myTransaction == null && Conn.State == System.Data.ConnectionState.Closed) Open();
//myTransaction=Conn.BeginTransaction() ;
myTransaction=Conn.BeginTransaction(System.Data.IsolationLevel.RepeatableRead) ;
} public void BeginTransaction(System.Data.IsolationLevel solationLevel)
{
if(myTransaction == null && Conn.State == System.Data.ConnectionState.Closed) Open();
//myTransaction=Conn.BeginTransaction(solationLevel) ;
myTransaction=Conn.BeginTransaction(System.Data.IsolationLevel.RepeatableRead) ;
} //事务提交
public void CommitTransaction()
{
if (myTransaction != null)
{
myTransaction.Commit();
}
}
//事务回滚
public void RollBackTransaction()
{
if (myTransaction != null)
{
myTransaction.Rollback();
myTransaction.Dispose();
myTransaction = null;
}
} //创建一个SqlCommand对象
public SqlCommand CreateCommand(string strsql)
{
Open();
SqlCommand Cmd;
if(myTransaction== null)
{
Cmd=new SqlCommand(strsql,Conn);
}
else
{
Cmd=new SqlCommand(strsql,Conn,this.myTransaction);
}
return Cmd;
} //创建一个SqlDataAdapter对象
public SqlDataAdapter CreateAdapter(string strsql)
{
SqlDataAdapter Adapter=new SqlDataAdapter();
SqlCommand Cmd=CreateCommand(strsql);
Adapter.SelectCommand=Cmd;
return Adapter;
} //创建一个DataTable对象
//参数为 strsql
//返回值为datatable
public DataTable CreateTable(string strsql)
{
DataTable dt=new DataTable();
SqlDataAdapter adp=CreateAdapter(strsql);
adp.Fill(dt);
return dt;
} //返回SQL语句影响的行数
public int RunSql(string strsql)
{
try
{
int num;
SqlCommand Cmd=CreateCommand(strsql);
num=Cmd.ExecuteNonQuery();
Cmd.Dispose();
return num;
}
catch(Exception ex)
{
throw ex;
}
finally
{
//Close();
}
} //返回首行首列
public int Count(string strsql)
{
try
{
SqlCommand Cmd=CreateCommand(strsql);
int num=Convert.ToInt32(Cmd.ExecuteScalar());
return num;
}
catch(Exception ex)
{
throw ex;
}
finally
{
Close();
}
} //返回一个DataReader
public System.Data.SqlClient.SqlDataReader DataRead(string strsql)
{
try
{
SqlDataReader tmpDataRead;//=new SqlDataReader();
SqlCommand Cmd=CreateCommand(strsql);
tmpDataRead=Cmd.ExecuteReader();
return tmpDataRead;
}
catch(Exception ex)
{
throw ex;
}
}
}
}
{
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
SqlCommand myCommand = new SqlCommand("sql_login",myConnection);
myCommand.CommandType = CommandType.StoredProcedure; SqlParameter prmPetID = new SqlParameter("@petID",SqlDbType.VarChar,255);
prmPetID.Value = strPetID;
myCommand.Parameters.Add(prmPetID); SqlParameter prmPassword = new SqlParameter("@password",SqlDbType.VarChar,255);
prmPassword.Value = strPassword;
myCommand.Parameters.Add(prmPassword); SqlParameter prmPetName = new SqlParameter("@petName",SqlDbType.VarChar,255);
prmPetName.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(prmPetName); SqlParameter prmPersonID = new SqlParameter("@personID",SqlDbType.BigInt);
prmPersonID.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(prmPersonID);
PersonDetails myPersonDetails = new PersonDetails(); try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close(); myPersonDetails.petName = prmPetName.Value.ToString();
myPersonDetails.petID = prmPetID.Value.ToString();
myPersonDetails.personID = Convert.ToInt32(prmPersonID.Value);
return myPersonDetails;
}
catch
{
myPersonDetails.petName = "";
myPersonDetails.personID = 0;
return myPersonDetails;
}
}连接字符串:
<appSettings>
<add key="connectionString" value="data source=(local);User ID=sa;Password=;initial catalog=secondhand" />
</appSettings>别说这里的人吝啬
谁能告诉我他的这个类我在代码中应该如何引用阿
SqlConnection conn= DB.database;我再跟目录下建立了一个DB目录然后在这里面建立了一个类文件
然后用的他的代码
使用ConfigurationSettings.AppSettings属性时,要引用System.Configuration命名空间