为什么在下面的条件就不起作用?

flashasp 2004-06-29 03:11:35

现有RadioButton1,和RadioButton2

<asp:RadioButton id="RadioButton1" runat="server" Text="个人会员" GroupName="sex" Runat=server></asp:RadioButton>
<asp:RadioButton id="RadioButton2" runat="server" Text="公司会员" GroupName="sex" Runat=server></asp:RadioButton>
---------------------------------------------------------------------------------
为什么在下面的条件就不起作用?
private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
string sql="";

if (RadioButton1.Checked==true)//为什么这个条件不起作用?
{
sql="select username,password from person order by id desc";
}
else

{
sql="select UserName,Password from company order by id desc";
}

if(!Geonado_Data.datareader(sql))
{
Response.Write("<script>alert('用户名未注册！')</script>");
return;
}
sql="select id from person where username='"+UserName.Value+"'and password='"+password.Value+"' ";
if(!Geonado_Data.datareader(sql))
{
Response.Write("<script>alert('密码错误！')</script>");
return;
}
else
{
Session["UserName"]=UserName.Value;
Response.Redirect("index.asp");

}

}

...全文

179 18 打赏收藏转发到动态举报

写回复

用AI写文章

18 条回复

切换为时间正序

请发表友善的回复…

发表回复

flashasp 2004-06-29

打赏
举报

这样修改就对拉^_^
private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
string sql="",url="";
if (RadioButton1.Checked==true)
{
sql="select id from person where username='"+UserName.Value+"'and password='"+password.Value+"' ";
url="person/index.asp";
}
else

{
sql="select id from company where username='"+UserName.Value+"'and password='"+password.Value+"' ";
url="company/index.asp";
}
if(!Geonado_Data.datareader(sql))
{
Response.Write("<script>alert('用户名未注册！')</script>");
return;
}

if(!Geonado_Data.datareader(sql))
{
Response.Write("<script>alert('密码错误！')</script>");
return;
}
else
{
Session["UserName"]=UserName.Value;
Response.Redirect(url);

}

}

flashasp 2004-06-29

打赏
举报

晕哦,重要看出来拉,问题在这里:
sql="select id from person where username='"+UserName.Value+"'and password='"+password.Value+"' ";
刚开始的两个判断对这个SQL语句根本就不起作用^_^
我知道怎么改拉,粗心的家伙!

flashasp 2004-06-29

打赏
举报

SQL语句string sql1="select top 8 id,biaoti,data from [gonggao] order by id desc";
^_^与我的登陆程序是无关的1!
要不我把
select UserName,Password from company order by id desc改为

select UserName,Password from company 测试一哈^_^

exboy 2004-06-29

打赏
举报

代码看上去没有什么问题，把

this.RadioButton1.CheckedChanged += new System.EventHandler(this.RadioButton1_CheckedChanged);
this.RadioButton2.CheckedChanged += new System.EventHandler(this.RadioButton2_CheckedChanged);

两行去掉试试

zljblue 2004-06-29

打赏
举报

请注意你的SQL语句string sql1="select top 8 id,biaoti,data from [gonggao] order by id desc";永远都是按这个条件查询，怎么可能会改变查询的结果呢

flashasp 2004-06-29

打赏
举报

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using geonado_space;//引用class类的命名空间geonado_space

namespace WebAppPowerDataGridTest
{
public class _default : System.Web.UI.Page
{

data Geonado_Data=new data();
protected System.Web.UI.WebControls.ImageButton ImageButton1;
protected System.Web.UI.HtmlControls.HtmlInputText UserName;
protected System.Web.UI.HtmlControls.HtmlInputText password;
protected System.Web.UI.WebControls.RadioButton RadioButton2;
protected System.Web.UI.WebControls.RadioButton RadioButton1;
protected System.Web.UI.WebControls.DataGrid DG_board;
protected System.Web.UI.HtmlControls.HtmlInputImage Image1;

public void bind()//绑定所有的DATAGRID
{
string sql1="select top 8 id,biaoti,data from [gonggao] order by id desc";
DataSet ds_board=Geonado_Data.dbbind(sql1);
DG_board.DataSource=ds_board.Tables["mytable"].DefaultView;
DG_board.DataBind();
}
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!this.IsPostBack)
{
bind();

}
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.RadioButton1.CheckedChanged += new System.EventHandler(this.RadioButton1_CheckedChanged);
this.RadioButton2.CheckedChanged += new System.EventHandler(this.RadioButton2_CheckedChanged);
this.ImageButton1.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton1_Click);
this.DG_board.SelectedIndexChanged += new System.EventHandler(this.DG_board_SelectedIndexChanged);
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion

private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
string sql="";
if (RadioButton1.Checked==true)
{
sql="select username,password from person order by id desc";
}
else

{
sql="select UserName,Password from company order by id desc";
}
if(!Geonado_Data.datareader(sql))
{
Response.Write("<script>alert('用户名未注册！')</script>");
return;
}
sql="select id from person where username='"+UserName.Value+"'and password='"+password.Value+"' ";
if(!Geonado_Data.datareader(sql))
{
Response.Write("<script>alert('密码错误！')</script>");
return;
}
else
{
Session["UserName"]=UserName.Value;
Response.Redirect("index.asp");

}

}

}
}
-----------------------------------------------全部代码就这些,各位帮我看看

flashasp 2004-06-29