![]() |
#2
jalonlovesja2011-10-10 08:52
|
using System.Data.oracleClient;
namespace first
{
public partial class login : System.Web.UI.Page
{
private void Page_Load(object sender, EventArgs e)
{
string userName = Request.Form["username"].ToString();
string userPwd = Request.Form["userpwd"].ToString();
oracleConnection con =new oracleConnection("Provider=MSDASQL.1;Password=zyytcy06;Persist Security Info=True;User ID=cy06dba;Data Source=cy06dba;");
//string ConnectionString = "Data Source=cy6;user=cy06dba;password=zyytcy06;";//写连接串
//OracleConnection conn = new OracleConnection(ConnectionString);//创建一个新连接
con.open();
//OracleCommand cmd = conn.CreateCommand();
错误语句: OracleCommand cmd=new OracleCommand("select count(*) from dbausr where name='"+userName+"' and pwd='"+userPwd+"'",con);
int count=Convert.Toint32(cmd.ExecuteScalar());
if (count>0)
{
Response.Redirect("main.aspx");
}
else
{
Response.Redirect("loginFail.htm");
}
}
}