using System.Data; using System.Data.OleDb; //使用web.config里面的设置提取 数据 位置. string constr = System.Configuration.ConfigurationManager.ConnectionStrings["dbConnectionString"].ConnectionString; OleDbConnection conn = new OleDbConnection(constr); conn.Open(); //string commandName = "[ZhuCe]"; OleDbCommand cmd = new OleDbCommand("[ZhuCe]", conn); //设置为存储过程,而不是SQL语句. //必须加上 using System.Data; 否则出错. cmd.CommandType = CommandType.StoredProcedure; //添加第一个参数 OleDbParameter name = new OleDbParameter("?", OleDbType.VarChar); name.Value = ZhangHao_TextBox.Text; cmd.Parameters.Add(name); //第二个参数 OleDbParameter pass = new OleDbParameter("?", OleDbType.VarChar); pass.Value = MiMa_TextBox.Text; cmd.Parameters.Add(pass); //执行,关闭 cmd.ExecuteScalar(); conn.Close();