左侧的LISTBOX中的数据是绑定数据库读出来的
右边的LISTBOX中的数据是左边LISTBOX选择后添加出来的我现在需要将右边的LISTBOX中的多项内容添加到另外一个表的某一字段中,如何进行?点击代码如下:
protected void ButtonAdd_Click(object sender, EventArgs e)
{
int count = this.PatrolListInfo.Items.Count;
int index = 0;
for (int i = 0; i < count; i++)
{
ListItem item = PatrolListInfo.Items[index];
if (PatrolListInfo.Items[index].Selected == true)
{
TaskListInfo.Items.Add(item);
//index--;
}
index++;
}
} protected void ButtonRemove_Click(object sender, EventArgs e)
{
int count = this.TaskListInfo.Items.Count;
int index = 0;
for (int i = 0; i < count; i++)
{
ListItem item = TaskListInfo.Items[index];
if (TaskListInfo.Items[index].Selected == true)
{
TaskListInfo.Items.Remove(item);
index--;
}
index++;
}
}更新数据库public void TaskInfo()
{
int count = this.TaskListInfo.Items.Count;
for (int i = 0; i < count; i++)
{
string item = TaskListInfo.Items[i].ToString();
string sql = string.Format("UPDATE taskbrowse SET TaskPatrolInfo='{0}' WHERE TaskId='{1}'",item.Trim(),this.TextTaskId.Text.Trim());
MySqlConnection conn = new MySqlConnection("server=192.168.0.254;user id=root;password=110120110;database=dlxj;charset=gb2312");
conn.Open();
MySqlCommand myCommand = new MySqlCommand(sql, conn);
myCommand.ExecuteNonQuery();
conn.Close();
}
}请大家帮忙看下代码
右边的LISTBOX中的数据是左边LISTBOX选择后添加出来的我现在需要将右边的LISTBOX中的多项内容添加到另外一个表的某一字段中,如何进行?点击代码如下:
protected void ButtonAdd_Click(object sender, EventArgs e)
{
int count = this.PatrolListInfo.Items.Count;
int index = 0;
for (int i = 0; i < count; i++)
{
ListItem item = PatrolListInfo.Items[index];
if (PatrolListInfo.Items[index].Selected == true)
{
TaskListInfo.Items.Add(item);
//index--;
}
index++;
}
} protected void ButtonRemove_Click(object sender, EventArgs e)
{
int count = this.TaskListInfo.Items.Count;
int index = 0;
for (int i = 0; i < count; i++)
{
ListItem item = TaskListInfo.Items[index];
if (TaskListInfo.Items[index].Selected == true)
{
TaskListInfo.Items.Remove(item);
index--;
}
index++;
}
}更新数据库public void TaskInfo()
{
int count = this.TaskListInfo.Items.Count;
for (int i = 0; i < count; i++)
{
string item = TaskListInfo.Items[i].ToString();
string sql = string.Format("UPDATE taskbrowse SET TaskPatrolInfo='{0}' WHERE TaskId='{1}'",item.Trim(),this.TextTaskId.Text.Trim());
MySqlConnection conn = new MySqlConnection("server=192.168.0.254;user id=root;password=110120110;database=dlxj;charset=gb2312");
conn.Open();
MySqlCommand myCommand = new MySqlCommand(sql, conn);
myCommand.ExecuteNonQuery();
conn.Close();
}
}请大家帮忙看下代码
{
int count = this.TaskListInfo.Items.Count;
for (int i = 0; i < count; i++)
{
string item = TaskListInfo.Items[i].ToString();
string sql = string.Format("insert into taskbrowse(TaskPatrolInfo) values='{0}' ",item.Trim());
MySqlConnection conn = new MySqlConnection("server=192.168.0.254;user id=root;password=110120110;database=dlxj;charset=gb2312");
conn.Open();
MySqlCommand myCommand = new MySqlCommand(sql, conn);
myCommand.ExecuteNonQuery();
conn.Close();
}
}
一点击添加就提示这个错误。
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '='检查3201刀闸闭合状态'' at line 1楼上的不行呀,这个LISTBOX里面不止一条记录呢,是要全部添加进数据库的一个字段的一行里面。
数据库里面的这个字段我设置的VARCHAR(100)
方法如下:
string TaskInfo="";
for (int i = 0; i < this.TaskListInfo.Items.Count; i++)
{
TaskInfo += this.TaskListInfo.Items[i].Value + ';';
}然后SQL插入
winform中this.TaskListInfo.Items[i].Value + ';';
没有Items[i].Value只有Items[i]