急急 在线等 .NET sql查询语句怎么取消某个字段的值

[qq_28051245]

我用.NET sql查询语句绑定下拉的时候，想取消绑定自己，有session["name"]，就是取消session的值
不知道要怎么写，replace好像指定一个值去修改，而我的是动态的，求教 代码 红色字体那里

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.Security;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.IO;
using System.Data.SqlClient;
using System.Collections;
using System.Configuration;
using System.Data;

public partial class Common_Chat_Send : System.Web.UI.Page
{
public DBConnection conn = new DBConnection();
public String sql, id, name, role, AccepterRole, Tid, group, AccepterId, AccepterName;

protected void Page_Load(object sender, EventArgs e)
{
this.Title = "公共-发送信息";
id = (string)Session["id"];
name = (string)Session["name"];
if (Session["id"] == null)
{
Response.Redirect("~/login.aspx?URL=" + Request.Url.ToString());
}
role = (string)Session["RoleName"];
TextBox_Time.Text = DateTime.Today.Year + "年" + DateTime.Today.Month + "月" + DateTime.Today.Day + "日" + DateTime.Now.ToShortTimeString(); ;
if (!IsPostBack)
{
M_Accepter_RoleBand();
M_AccepterBand();
}
}
//if (MassCB.Checked){
//}
protected void M_Accepter_RoleBand()
{
if (role == "老师")
{
//姓名下拉框
//默认显示全部
M_Accepter_Role.Items.Add(new ListItem("全部"));
}
else if (role == "学生") {
M_Accepter_Role.Items.Add(new ListItem("全部"));
M_Accepter_Role.Items.Add(new ListItem("导师"));
M_Accepter_Role.Items.Add(new ListItem("学生"));
M_Accepter_Role.Items.Add(new ListItem("队员"));
}
}
//下拉的触发事件
protected void M_Accepter_Role_SelectedIndexChanged(object sender, EventArgs e)
{
this.AccepterRole = this.M_Accepter_Role.SelectedValue;
M_AccepterBand();
}
protected void M_AccepterBand()
{
if (role == "老师")
{
this.AccepterRole = this.M_Accepter_Role.SelectedValue;
if (AccepterRole.ToString() == "全部")
{
sql = "Select S_name,S_id from S_Teacher Where T_id='" + id.ToString() + "'";
SqlDataReader dr = conn.ExecuteReader(sql);
this.M_Accepter.DataSource = dr;//设置数据源，用于填充控件中的项的值列表
this.M_Accepter.DataTextField = "S_name";//下拉显示出来的值
this.M_Accepter.DataValueField = "S_id";//取到的值
this.M_Accepter.DataBind();//将控件及其所有子控件绑定到指定的数据源
dr.Close();
}
}
else if (role == "学生")
{
sql = "Select * from S_Teacher Where S_id='" + id.ToString() + "'";
SqlDataReader dr = conn.ExecuteReader(sql);
if (dr.Read())
{
Tid= dr["T_id"].ToString();
}
dr.Close();
M_AccepterStudentBand();
}
}
protected void M_AccepterStudentBand()
{
this.AccepterRole = this.M_Accepter_Role.SelectedValue;
if (AccepterRole.ToString() == "全部")
{
sql = "Select S_id as ids,S_name as names from S_Teacher Where T_id='" + Tid.ToString() + "' union all Select T_id as ids,T_name as names from S_Teacher Where S_id='" + id.ToString() + "'";
SqlDataReader dr = conn.ExecuteReader(sql);
this.M_Accepter.DataSource = dr;
this.M_Accepter.DataTextField = "names";
this.M_Accepter.DataValueField = "ids";
this.M_Accepter.DataBind();
dr.Close();
}
else if (AccepterRole.ToString() == "导师")
{
sql = "Select T_id,T_name from S_Teacher Where S_id='" + id.ToString() + "'";
SqlDataReader dr = conn.ExecuteReader(sql);
this.M_Accepter.DataSource = dr;
this.M_Accepter.DataTextField = "T_name";
this.M_Accepter.DataValueField = "T_id";
this.M_Accepter.DataBind();
dr.Close();
}
else if (AccepterRole.ToString() == "学生")
{
sql = "Select S_name,S_id,T_id,T_name from S_Teacher Where T_id='" + Tid.ToString() + "'";
SqlDataReader dr = conn.ExecuteReader(sql);
this.M_Accepter.DataSource = dr;
this.M_Accepter.DataTextField = "S_name";
this.M_Accepter.DataValueField = "S_id";
this.M_Accepter.DataBind();
dr.Close();
}
else if (AccepterRole.ToString() == "队员")
{
sql = "Select * from S_Teacher Where S_id='" + id.ToString() + "'";
SqlDataReader dr = conn.ExecuteReader(sql);
if (dr.Read())
{
group = dr["S_group"].ToString();
}
dr.Close();
M_AccepterStudentTeamBand();
}
}
protected void M_AccepterStudentTeamBand()
{
sql = "Select S_name,S_id from S_Teacher Where T_id='" + Tid.ToString() + "' and S_group='" + group.ToString() + "'";
SqlDataReader dr = conn.ExecuteReader(sql);
this.M_Accepter.DataSource = dr;
this.M_Accepter.DataTextField = "S_name";
this.M_Accepter.DataValueField = "S_id";
this.M_Accepter.DataBind();
dr.Close();
}

protected void confirmButton_Click(object sender, EventArgs e)
{
if (M_Title.Text.ToString() == "")
{
Response.Write("<script>alert('" + "标题不能为空！" + "');</script>");
}
else if (M_Content.Text.ToString() == "")
{
Response.Write("<script>alert('" + "内容不能为空！" + "');</script>");
}
//else if (M_Accepter.SelectedValue.ToString() == "")
//{
// Response.Write("<script>alert('" + "请选择接收者！" + "');</script>");
//}
else if (M_Accepter.Text.ToString() == "")
{
Response.Write("<script>alert('" + "请选择接收者！" + "');</script>");
}
//待处理，没读运行到，FileUpload1.XX.ToString()
else if (FileUpload1.PostedFile.ToString() == "")
{
Response.Write("<script>alert('" + "不需要上传文件吗？" + "');</script>");
}
else
{
AddUnit();
}
}
protected void M_Accepter_SelectedIndexChanged(object sender, EventArgs e)
{
this.AccepterId = this.M_Accepter.SelectedValue;
this.AccepterName = this.M_Accepter.SelectedItem.Text;
}
public void AddUnit()
{
this.AccepterId = this.M_Accepter.SelectedValue;
this.AccepterName = this.M_Accepter.SelectedItem.Text;
SqlConnection connection = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
sql = "Select * from C_Message where M_S_id='" + id.ToString() + "'and M_S_name='" + name.ToString() + "' and M_M_time='" + TextBox_Time.Text.ToString() + "'";
SqlDataReader dr = conn.ExecuteReader(sql);
//if (dr.Read())
if(Session["id"] == "")
{
Response.Write("<script>alert('" + "对不起您还没登录！" + "');</script>");
Server.Transfer("~/login.aspx");
}
else
{
dr.Close();
string state = "未读";
sql = "insert into C_Message(M_S_id,M_S_name,M_M_accepter_id,M_M_accepter_name,M_M_title,M_M_content,M_M_state,M_M_time,M_M_file) values('" + id.ToString() + "','" + name.ToString() + "' ,'" + AccepterId.ToString() + "' ,'" + AccepterName.ToString() + "' , '" + M_Title.Text.ToString() + "' , '" + M_Content.Text.ToString() + "' ,'" + state.ToString() + "' , '" + TextBox_Time.Text.ToString() + "' , '" + FileUpload1.FileName + "')";
Session["time"] = TextBox_Time.Text;
conn.Update(sql);
if (FileUpload1.HasFile == true)
{
FileUpload1.SaveAs(Server.MapPath(("~/MessageFile/") + FileUpload1.FileName));

}
Response.Write("<script>alert('" + "发送成功！" + "');</script>");
Server.Transfer("Chat_Send_Look.aspx");
}
dr.Close();
}
protected void cancelButton_Click(object sender, EventArgs e)
{
this.M_Title.Text = "";
this.M_Content.Text = "";
}
}

[qq_28051245]

引用 1 楼 qq_29198233 的回复:

你可以在SQL里面的条件写上and id不同于自己的ID 就行了啊

不会写这种select语句啊，早就忘记了，大神能留一下代码吗

[欧皇神降术]

and S_Name <> Session["name"]

[qq_28051245]

引用 3 楼 qq_29198233 的回复:

and S_Name <> Session["name"]

在sql = "Select S_name,S_id,T_id,T_name from S_Teacher Where T_id='" + Tid.ToString() + "'";哪个位置加呢

[qq_28051245]

可以啦，谢谢你

[EnForGrass]

这样

sql = "Select S_name,S_id,T_id,T_name from S_Teacher Where T_id='" + Tid.ToString() + "' and S_name <> '"+Session["name"].ToString()+"'";

[欧皇神降术]

你可以在SQL里面的条件写上and id不同于自己的ID 就行了啊