请问各位,从前台用ajax方法传送字符串,接收后利用split分隔出数组,当中有5个值,要怎样放到泛类型中,并且循环插入到数据库中?以下写法报错,请问要怎样写?谢谢!public bool SendPMessage(string SelectValue, string MsgContent)
{
bool sendState = false;
Message message = new Message();
//根据“,”分隔字符串
string[] strArray = SelectValue.Split(','); message.Body = MsgContent; //信息内容
message.CreateDate = Convert.ToDateTime(DateTime.Now.ToString()); //创建时间 for (var i = 0; i < strArray.Length; i++)
{
message.Owner = int.Parse(strArray[i]); //接收者ID
sendState = Dao.SendMsg(message);
}
return sendState;
}以下是SQL语句
public static bool SendMsg(Message message)
{
string sql = @"insert into MESSAGE (Id,Body,CreateDate,Owner) values(:Id,:Body,:CreateDate,:Owner)"; using (DataHelper helper = new DataHelper(CommonData.Conn, CommonData.DBType))
{
return helper.CreateQuery(sql, CommandType.Text)
.SetInt32("Id", Getval())
.SetString("Body", message.Body)
.SetDateTime("CreateDate", message.CreateDate)
.SetInt32("Owner", message.Owner)
.ExecuteNonQuery() > 0 ? true : false;
}
}
{
bool sendState = false;
Message message = new Message();
//根据“,”分隔字符串
string[] strArray = SelectValue.Split(','); message.Body = MsgContent; //信息内容
message.CreateDate = Convert.ToDateTime(DateTime.Now.ToString()); //创建时间 for (var i = 0; i < strArray.Length; i++)
{
message.Owner = int.Parse(strArray[i]); //接收者ID
sendState = Dao.SendMsg(message);
}
return sendState;
}以下是SQL语句
public static bool SendMsg(Message message)
{
string sql = @"insert into MESSAGE (Id,Body,CreateDate,Owner) values(:Id,:Body,:CreateDate,:Owner)"; using (DataHelper helper = new DataHelper(CommonData.Conn, CommonData.DBType))
{
return helper.CreateQuery(sql, CommandType.Text)
.SetInt32("Id", Getval())
.SetString("Body", message.Body)
.SetDateTime("CreateDate", message.CreateDate)
.SetInt32("Owner", message.Owner)
.ExecuteNonQuery() > 0 ? true : false;
}
}
解决方案 »
- 请教一下,Html代码里的数据可否用repeater控件来实现
- PublicKeyToken=b77a5c561934e089”类型的权限已失败
- 写4年代码,做了下基础题。估计只能得10分,为什么,围观一下。大家都什么情况
- 求救 Adobe Reader不能打印问题 急!!!!!!
- 如何在数据访问层调用 ui层中的web.config的数据库连接字符串
- 一个简单页面回调的代码,照书抄的,但怎么也运行不了,错在哪里呢?
- 我在做一个系统,用户是属于某个部门的,登陆的时候要选择某个部门才能登陆。。。。。解答问题马上给分
- .net中传值问题?
- asp.net中windows窗体
- 怎样才能在函数中打开新的窗口?(vb.net)
- vs2010旗舰版菜单栏工具栏全部空白没有文字怎么解决?
- javascript 设置页面高度
myCommand.CommandText = "insert into [tb_cz3] (bianhao,col,leibei,bzr,jiedian) ";
List<string> list = new List<string>();
foreach (RepeaterItem item in Rpt1.Items)
{
DropDownList drpt = item.FindControl("DropDownList6") as DropDownList;
Label lb = item.FindControl("label3") as Label; if (drpt.SelectedItem.ToString() != "请选择")
{ list.Add(lb.Text);
list.Add(drpt.SelectedValue.ToString());
}
}
for (int x = 0; x < list.Count; x += 2)
{
myCommand.CommandText += "select " + i + ",'a9'," + list[x] + "," + list[x + 1] + ",'1' UNION ALL ";
}
myCommand.CommandText = myCommand.CommandText.Substring(0, myCommand.CommandText.Length - 10);
myCommand.ExecuteNonQuery();
哥们,你的写法不太懂啊!我的for循环里数组有5个值。我这样写是不是可以循环inset into到数据库5次?但老报“非并所有值都已绑定”这样的错!