学步园

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data.SqlClient;using System.Data;public partial class ADO_SqlParameter : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(); SqlCommand cmd = new SqlCommand(); string sqlText = ""; sqlText = "select count(*) from tbAdmin where adminName=@adminName and adminPwd=@adminPwd"; conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ADO"].ToString(); cmd.Connection = conn; cmd.CommandText = sqlText; cmd.Parameters.Add(new SqlParameter("@adminName",SqlDbType.VarChar,50)); cmd.Parameters.Add(new SqlParameter("@adminPwd",SqlDbType.VarChar,50)); cmd.Parameters["@adminName"].Value = "admin"; cmd.Parameters["@adminPwd"].Value = "admin"; conn.Open(); int count = int.Parse(cmd.ExecuteScalar().ToString()) ; Response.Write(count); conn.Close(); }}