第ä¸ç§æ¹æ³ï¼
//建ç«ASP.NET Web åºç¨ç¨åºï¼ç´æ¥å¨Page_loadå½æ°ä¸å å
¥ä¸ä¸ä»£ç ï¼è²ä¼¼å°±å¯ä»¥ç¨äº
public void Page_Load(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection("Data Source=.;uid=sa;pwd=sa;Database=NorthWind"))
{
string username = "forever";
string strSQL = "select * from table where name='" + username + "'";
SqlDataAdapter adapter = new SqlDataAdapter(strSQL, con);
DataSet ds = new DataSet();
adapter.Fill(ds);
foreach (DataRowView drv in ds.Tables[0].DefaultView)
{
Response.Write(drv["第ä¸ä¸ªå段"]+"|"+drv["第äºä¸ªå段"]);
}
}
}
第äºç§æ¹æ³è¯´çæ¯è¾å®å
¨ï¼å°±æ¯æ¯è¾éº»ç¦
//1ãä¿®æ¹Web.configé
ç½®æ件
<configuration>
<connectionStrings>
</connectionStrings>
//ä¸é¢ä¸è¡æ¯æ·»å çå
容ï¼å³è¿æ¥æ°æ®åºçä¿¡æ¯
<appSettings>
<add key="connect" value="server=.;database=NorthWind;uid=sa;pwd=sa;"/>
</appSettings>
<system.web>
//2ãè¿æ¥æ°æ®åº
sCon = ConfigurationManager.AppSettings["connect"];
if (string.IsNullOrEmpty(sCon))
{
Response.Write("è¿æ¥å符串为空ï¼");
}
con = new SqlConnection(sCon);
//3ãæå¼æ°æ®åº
if (con.State == ConnectionState.Closed)
con.Open();
//4ãæ¥è¯¢å½æ°
public SqlDataReader ExcuteDataReader(string strTxt, CommandType cmdType, SqlParameter[] Params)
{
SqlDataReader dr = null;
if (con.State == ConnectionState.Closed)
{
Response.Write("æ°æ®åºçè¿æ¥æ²¡ææå¼ï¼");
return dr;
}
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = strTxt;
cmd.CommandType = cmdType;
if (Params != null)
{
foreach (SqlParameter param in Params)
{
if (param != null) cmd.Parameters.Add(param);
}
}
#if NOTALLOWEXCEPTION
try
#endif
{
if (cmd.ExecuteScalar() != null)
{
dr = cmd.ExecuteReader();
}
}
#if NOTALLOWEXCEPTION
catch(SqlException se)
{
_objToShowErr = se;
_sError = se.Message;
return null;
}
finally
#endif
{
cmd.Dispose();
}
return dr;
}
//5ãæ§è¡æ¥è¯¢
//SQLè¯å¥ï¼id=N'id',å 个Næ¯ä¸ºäºè½è¯å«ä¸æå符ã
string s = "select * from table where id=N'" + id + "'";
SqlParameter[] Params1 = null;
//ä¿åç»æ
SqlDataReader select_result = null;
select_result = a.ExcuteDataReader(s, CommandType.Text, Params1);
string ss = "";
while (select_result.Read())
{
//æ ¹æ®èªå·±çå段æ°å
ss = ss + "第ä¸ä¸ªå段ï¼" + select_result[0] + ", 第äºä¸ªå段ï¼" + select_result[1] + "; ";
}
//æµè¯è¾åº
Response.Write(ss);