62,046
社区成员
发帖
与我相关
我的任务
分享
string strConnection = "";
strConnection = ConfigurationSettings.AppSettings["connString"];//连接字符串
SqlConnection objConnection = new SqlConnection(strConnection);
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Clear();
cmd.CommandText = "News_S";//查询新闻
cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;//传递新闻ID参数
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = objConnection;
cmd.Connection.Open();
SqlDataReader dr = cmd.ExecuteReader();
try
{
if (dr.Read() == false)
{
//如果没读到记录就什么都不做
}
else
{
string strID=dr["ID"].ToString();//读取新闻ID
string author = dr["author"].ToString();//读取作者信息
string source = dr["source"].ToString();//读取来源
string title = dr["title"].ToString();//读取文章标题
string content = dr["content"].ToString();//读取文章内容
string newsurl;
newsurl="show.aspx?ID="+strID;
}
dr.Close(); //关闭记录集
}
catch (SqlException ex)
{
Response.Write(ex.ToString());//输出异常信息
}
finally
{
cmd.Connection.Close();//关闭连接
objConnection.Close();//关闭连接,这里好像前后关闭的都是objconnection,用一个就好了,是不是需要加上cmd.Dispose();objConnection.Dispose();?疑惑…
}
}
<connectionStrings>
<add name="Northwind" connectionString="Server=localhost;
Integrated Security=True;Database=Northwind;Persist Security Info=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
string connectionString =ConfigurationManager.ConnectionStrings["Northwind"].ConnectionString;