表中一个Select和一个textbox控件,这样可以进表中的一个字段dz
cmd.CommandText = "INSERT INTO tb(dz) VALUES('"+Select.SelectedItem.Text.ToString()+ textbox.Text + "')"; 但下面的为什么不能?(其他地方没有问题,已经测试过) cmd.Parameters.Add("@jtzz", SqlDbType.VarChar).Value = Select.SelectedItem.ToString()+TexJtzz.Text.ToString().Trim();
cmd.CommandText = "INSERT INTO tb(dz) VALUES('"+Select.SelectedItem.Text.ToString()+ textbox.Text + "')"; 但下面的为什么不能?(其他地方没有问题,已经测试过) cmd.Parameters.Add("@jtzz", SqlDbType.VarChar).Value = Select.SelectedItem.ToString()+TexJtzz.Text.ToString().Trim();
解决方案 »
- page_load中设定DropDownList选中项的问题
- 有关判断的问题
- 新手c#程序问题,如何在副窗口关闭的同时更新主窗口的listbox控件
- 用C#2005自带的WEBBROWSER控件打开一个已知位置的WORD文档,不知如何保存.帮帮忙????
- 在C# windows中对图片的处理
- 设计UI的时候经常会遇到的问题,问了很多人都没解决的问题.但是觉得并不属于疑难问题的.只有10分了.对不起...
- 请问朋友们,回到主窗口问题,试了好多方法,望能帮助
- 数组排序问题。。。新手
- 如何拖动多个ListViewItem到TreeView?
- 请问用.net水晶报表开发的报表在用户机器上如何配置环境才能使用?
- xml修改
- 求高手翻译一段VBA的代码
jtzz.Value=Select.SelectedItem.ToString()+TexJtzz.Text.ToString().Trim();
cmd.CommandText = "INSERT INTO tb(dz) VALUES(@jtzz)"; 然后:
cmd.Parameters.Add("jtzz", SqlDbType.VarChar).Value = Select.SelectedItem.ToString()+TexJtzz.Text.ToString().Trim();
cmd.Parameters.Add("@jtzz", SqlDbType.VarChar).Value = Select.SelectedItem.ToString()+TexJtzz.Text.ToString().Trim();
cmd.Parameters.Add(new SqlParameter("@jtzz", SqlDbType.VarChar));
cmd.Parameters["@jtzz"].Value = ""
单步跟踪看看Select.SelectedItem.ToString()+TexJtzz.Text.ToString().Trim();
值
单独的 cmd.Parameters.Add("@jtzz", SqlDbType.VarChar).Value = TxtJtzz.Text.ToString().Trim();也没问题,
而单独的 cmd.Parameters.Add("@jtzz", SqlDbType.VarChar).Value = Select.SelectedItem.ToString();却提示:编译器错误消息: CS0103: 当前上下文中不存在名称“Select”可是是有的啊
:<select id="Select" onchange="ChangeSelect(this.value,'xq2','',Office,'请选择')" style="width:76px"></select>
:<select id="Select" onchange="ChangeSelect(this.value,'xq2','',Office,'请选择')" style="width:76px"></select>
<script language="JavaScript" type="text/javascript">
//ChangeSelect(上一级的值,下一级Select控件的ID值,下一级Select控件要选中的值(即value而非text),数据源数组名),第一级的上级值为0
function ChangeSelect(ParentValue, NextId, NextSelectedValue, ArrObj)
{
StrObj = eval(document.getElementById(NextId));
StrObj.length = 0;
//判断它是二维数组数据源,还是三维数组数据源
if (ArrObj.length > 0)
{
if (ArrObj[0].length == 2)
{ArrNum = 0;}
else
{ArrNum = 2;}
}
//显示所有列表
for (i = 0; i < ArrObj.length; i++)
{
if (i == 0)
{
StrObj.options[StrObj.length] = new Option("- 请选择 -", "");
}
if (ArrObj[i][1] == ParentValue)
{
StrObj.options[StrObj.length] = new Option(ArrObj[i][0],ArrObj[i][ArrNum]);
}
}
//选中列表内某一项
for (i = 0; i < StrObj.length; i++)
{
if (StrObj.options[i].value == NextSelectedValue)
{
StrObj.options[i].selected = true;
}
}
//激发下一级的onchange事件以实现多级级联
StrObj.onchange();
}//公司二维数组数据源
Office = [
["CategoryName","ParentCategoryName"],
["业务部","0"],
["技术部","0"],
["市场部","0"],
["业务部小柳","业务部"],
["业务部小杨","业务部"],
["业务部小菜","业务部"],
["技术部老柳","技术部"],
["技术部老杨","技术部"],
["技术部老菜","技术部"],
["市场部柳先生","市场部"],
["市场部杨先生","市场部"],
["市场部菜鸟","市场部"]
]//省市二维数组数据源
City2 = [
["CategoryName","ParentCategoryName"],
["山西省","0"],
["河北省","0"],
["太原市","山西省"],
["运城市","山西省"],
["石家庄","河北省"],
["廊房","河北省"]]
//省市三维数组数据源
City3 = [
["CategoryName","ParentId","Id"],
["北京","0","010"],
["山西","0","0359"],
["朝阳区","010","001"],
["海淀区","010","002"],
["豆各庄","001","101"],
["十里堡","001","102"],
["中关村","002","201"],
["上地","002","202"],
["运城地区","0359","301"],
["太原市","0359","302"],
["永济市","301","311"],
["小区","302","312"]
];
</script>
<select id="office1" onchange="ChangeSelect(this.value,'office2','',Office)" style="width:100px"></select>
<select id="office2" onchange="" style="width:100px"></select>
<script language="JavaScript" type="text/javascript">ChangeSelect('0','office1','',Office) </script>
<br /><select id="City001" onchange="ChangeSelect(this.value,'City002','',City2)" style="width:100px"></select>
<select id="City002" onchange="" style="width:100px"></select>
<script language="JavaScript" type="text/javascript">ChangeSelect('0','City001','',City2) </script>
<br /><select id="City3001" onchange="ChangeSelect(this.value,'City3002','',City3)" style="width:100px"></select>
<select id="City3002" onchange="ChangeSelect(this.value,'City3003','',City3)" style="width:100px"></select>
<select id="City3003" onchange="" style="width:100px"></select>
<script language="JavaScript" type="text/javascript">ChangeSelect('0','City3001','0359',City3) </script>
<br />