数据如下:myreader["t_stylist"].ToString();
t_stylist其中的值:姓名1,姓名2,姓名3我如何把这三个名字加到ListBox中,一个姓名一行,不要中间的","语句应该怎么写,请大家帮帮我撒,谢谢喽
t_stylist其中的值:姓名1,姓名2,姓名3我如何把这三个名字加到ListBox中,一个姓名一行,不要中间的","语句应该怎么写,请大家帮帮我撒,谢谢喽
解决方案 »
- asp.net实现
- 求项目可行性研究报告和项目开发计划
- ajaxpro做这样一个效果,结果滞后了。。。
- 文件上传
- vb.net与c#
- 求biztalk结合ad域开发资料(高分)
- Ajax遇到的问题,为什么插入不到数据库中数据了?在线等!!!!!!
- 请问在asp.net C# 中如何动态改变table 或者是div的可见属性呢?
- 请高人指点,打开,关闭窗口的问题,2K升级后的IE版本和XP是一样的,但是XP运行脚本有问题!!!!!!!!!!!!
- 有关页面访问效率的问题
- 什么情况下会用到虚方法?它与接口有什么不同?
- 急!!!!Treeview控件的实现...................!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
listbox1.DataBind();
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 System.Data.SqlClient;namespace works.manage
{
/// <summary>
/// addWeb 的摘要说明。
/// </summary>
public class edit : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Web.UI.WebControls.TextBox Textbox3;
protected System.Web.UI.WebControls.ListBox ListBox2;
protected System.Web.UI.WebControls.TextBox TextBox2;
protected System.Web.UI.WebControls.Button Button2;
protected System.Web.UI.WebControls.ListBox Listbox3;
protected System.Web.UI.WebControls.DropDownList Dropdownlist1;
protected System.Web.UI.WebControls.TextBox Textbox4;
protected System.Web.UI.HtmlControls.HtmlInputFile small_photo;
protected System.Web.UI.HtmlControls.HtmlInputFile File1;
protected System.Web.UI.WebControls.DropDownList Dropdownlist2;
protected System.Web.UI.WebControls.CheckBox CheckBox1;
protected System.Web.UI.WebControls.CheckBox CheckBox2;
protected System.Web.UI.WebControls.TextBox Textbox5;
protected System.Web.UI.WebControls.DropDownList ListBox1; functions.functions fs = new functions.functions();
protected System.Web.UI.HtmlControls.HtmlInputHidden Dbclickflag;
string sql ="";
SqlDataReader myreader = null;
protected int infoid=0; private void Page_Load(object sender, System.EventArgs e)
{
if(Session["loginid"]==null&&Convert.ToString(Session["loginid"])=="")
{
Response.Write("<script language=javascript>parent.window.location.href='Login.aspx';</script>");
Response.End();
}
if(!IsPostBack)
{
TextBox1.Text="北京分公司";
Textbox4.Text="http://";
TextBox1.ReadOnly=true;
this.addItem();
if(Request.QueryString["infoid"]!="")
{
this.BindData();
}
}
}
public void BindData() //给页面的所要修改的文本框传值
{
myreader = fs.GetDataReader("select * from t_caselist where id="+int.Parse(Request.QueryString["infoid"]));
while(myreader.Read())
{
Textbox3.Text=myreader["clientName"].ToString();
Dropdownlist1.SelectedValue=myreader["inTrade"].ToString();
// string aa = myreader["projectpersib"].ToString().Split(",".ToString());
// Listbox3.Items.Add(new ListItem(aa,aa)); Listbox3.DataSource = myreader["projectpersib"].ToString().Split(",".ToCharArray());
Listbox3.DataBind();
TextBox2.Text=myreader["appTechnique"].ToString();
Textbox4.Text=myreader["clientWebsite"].ToString();
Dropdownlist2.SelectedValue=myreader["commend"].ToString();
if(myreader["caseBal"].ToString() =="1")
{
CheckBox1.Checked=true;
}
if(myreader["caseComm"].ToString() =="1")
{
CheckBox2.Checked=true;
}
Textbox5.Text=myreader["ideas"].ToString();
}
} public void addItem() //读取列表的数据
{
sql = "select Stylist_Name from t_stylist";
myreader = fs.GetDataReader(sql);
while(myreader.Read())
{
ListBox2.Items.Add(new ListItem(myreader["Stylist_Name"].ToString(),myreader["Stylist_Name"].ToString()));
}
sql = "select Calling_Name from t_trades";
myreader = fs.GetDataReader(sql);
while(myreader.Read())
{
Dropdownlist1.Items.Add(new ListItem(myreader["Calling_Name"].ToString(),myreader["Calling_Name"].ToString()));
}
myreader.Close(); } private void Button2_Click(object sender, System.EventArgs e)
{
string str_trades = Dropdownlist1.SelectedItem.Value; //所属行业
string str_tc =ListBox1.SelectedItem.Value; //套餐类型
string str_prop =""; //项目人员
string s_FileName = ""; //缩略图的文件路径
string b_FileName = ""; //扩大图的文件路径
string str_Ballot =Dropdownlist2.SelectedItem.Value; //星级
string image_path ="trans_photos";
string flag_Bal="0",falg_Comm="0";
if(CheckBox1.Checked) flag_Bal="1";
if(CheckBox2.Checked) falg_Comm="1"; DateTime dt=DateTime.Now;
string filename=dt.Year.ToString()+dt.Month.ToString()+dt.Day.ToString()+dt.Hour.ToString()+dt.Minute.ToString()+dt.Millisecond.ToString();
foreach(ListItem dd in ListBox2.Items)
{
str_prop+=dd.Text.ToString()+",";
} if(small_photo.PostedFile != null && small_photo.PostedFile.ContentLength>0)
{
string filePath=small_photo.PostedFile.FileName;
string fileExtName=filePath.Substring(filePath.LastIndexOf(".")+1); s_FileName = "s"+filename+"."+fileExtName;
b_FileName = "b"+filename+"."+fileExtName;
sql="update t_caselist set clientName='"+Textbox3.Text+"',inTrade='"+Dropdownlist1.SelectedItem+"',taocan='"+ListBox1.SelectedItem+
"',projectpersib='"+str_prop+"',appTechnique='"+TextBox2.Text+"',clientWebsite='"+Textbox4.Text+"',s_photos='"+s_FileName+
s_FileName+"',b_photos='"+b_FileName+"',commend='"+Dropdownlist2.SelectedItem+"',caseBal='"+flag_Bal+"',caseComm='"+falg_Comm+"',ideas='"+
Textbox5.Text+"' where id="+int.Parse(Request.QueryString["infoid"]);
try
{
small_photo.PostedFile.SaveAs(Server.MapPath(image_path)+"/"+s_FileName);
File1.PostedFile.SaveAs(Server.MapPath(image_path)+"/"+b_FileName); }
catch
{
}
fs.SqlFunction(sql);
RegisterStartupScript("alert","<script language='javascript'>window.alert('修改成功!');</script>");
}
else
{
RegisterStartupScript("alert","<script language='javascript'>window.alert('上传图片为空!');</script>");
}
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Button2.Click += new System.EventHandler(this.Button2_Click);
this.Load += new System.EventHandler(this.Page_Load); }
#endregion
}
}