2：然后使用INSERT INTO 语句用于向数据库表中插入新记录。
很明显是字符集的问题，你数据库的字符集跟你插入时设置的字符集不匹配。要么在config中连接数据库字段中进行设置
<appSettings>
<add key="Connection" value="Server=127.0.0.1User ID=rootPassword=Database=数据库CharSet=gb2312"/>
</appSettings>
要么在程序中指定
MySQLCommand mCommand = new MySQLCommand("set names gb2312", Connection)
<!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/htmlcharset=utf-8" />
<title></title>
<script src="js/Jquery1.7.js"></script>
<script src="js/MyAdd.js"></script>
<link href="css/MyPages.css" rel="stylesheet" />
</head>
<body>
<div >
<div id="divInsert">
<div id="divBtn">
<input id="btnDelete" type="button" value="删除行" />
<input id="btnData" type="button" value="插入行" />
<input id="btnInsert" type="button" value="添加行" />
</div>
</div>
<table id="tab" cellpadding="0" cellspacing="0">
<tr>
<td rowspan="2">姓名</td>
<td rowspan="2">年龄</td>
<td colspan="2">血压</td>
</tr>
<tr>
<td>高压</td>
<td>低压</td>
</tr>
</table>
</div>
<div id="mydiv"></div>
</body>
</html>
JS文档
/// <reference path="../WebService1.asmx" />
/// <reference path="../WebService1.asmx" />
$(function () {
//定义一个全局变量i,用来标识添加了几行
var row = 0
var strValue = ""
//将一行添加到table中去
$('#btnInsert').click(function () {
row++
//字符串拼接tr一行中的内容
var tr = "<tr>"
for (var i = 0i <3i++) {
tr += "<td><input id='" + row + "text'" + i + "+' type='text' value=" + row +""+ i + " /></td>"
}
tr += "<td><input class='txt' id='" + i + "text4'+ type='text' value=" + row + "" + 4 + " /><input id='Checkbox1' class='ck' name='ckb' type='checkbox' /></td></tr>"
$("#tab").append(tr)
})
//删除添加的行，先判断checkbox是否选中，然后删除
$('#btnDelete').click(function () {
$("input[name=ckb]:checked").each(function () { $(this).parent().parent().remove()})
})
//将i遍历，判断是否存有值，如果有将数据插入数据库
$('#btnData').click(function () {
$('table input').each(function () {
strValue += $(this).val() + ","
})
$.ajax({
type: 'post',
contentType: 'application/json',
url: "../WebService1.asmx/InsertInfo",
data: "{valuesStr:'" + strValue + "'}",
success: function (result) {
$('#mydiv').html(result.d)
}
})
})
})
CSS文档
table tr td{border:1px solid #eeetext-align:centerwidth:80px}
#divInsert{width:100%height:25px}
#btnInsert{width:50pxheight:25pxbackground-color:#eeeborder-style:noneposition:absoluteleft:185px}
#btnData{width:50pxheight:25pxbackground-color:#eeeborder-style:noneposition:absoluteleft:235px}
#btnDelete{width:50pxheight:25pxbackground-color:#eeeborder-style:noneposition:absoluteleft:285px}
input{width:70px}
.txt{width:35pxfloat:leftposition:relativeleft:5px}
.ck{width:10pxfloat:right}
PersonInfo类文件
namespace ASPOilfiled
{
public class PersonInfo
{
public string Name { getset}
public int Age { getset}
public int Hblood { getset}
public int Lblood { getset}
}
}
WebService1.asmx 文件
[System.Web.Script.Services.ScriptService]
public class WebService1 : System.Web.Services.WebService
{
public static string sqlstr = ConfigurationManager.ConnectionStrings["sqlstr"].ConnectionString
[WebMethod]
public string InsertInfo(string valuesStr)
{
string result = "插入失败！"
string asd = valuesStr.Replace("on,", "")
string[] str2 = System.Text.RegularExpressions.Regex.Split(asd, ",")
//for (int i = 0i <str2.Lengthi++)
//{
//result += str2[i] + "<br/>"
//}
for (int i = 0i <str2.Lengthi++)
{
PersonInfo info
if (i % 4 == 0)
{
info = new PersonInfo()
info.Name = str2[i]
info.Age = Convert.ToInt32(str2[i + 1])
info.Hblood = Convert.ToInt32(str2[i + 2])
info.Lblood = Convert.ToInt32(str2[i + 3])
result = InfoToSql(info).ToString()
}
}
return result
}
public int InfoToSql(PersonInfo info)
{
string instSql = "insert into PersonInfo values(@name,@age,@Hblood,@Lblood)"
SqlConnection con = new SqlConnection(sqlstr)
con.Open()
SqlCommand cmd = con.CreateCommand()
cmd.CommandText = instSql
cmd.Parameters.Add("@name", SqlDbType.VarChar, 32).Value = info.Name
cmd.Parameters.Add("@age", SqlDbType.Int).Value = info.Age
cmd.Parameters.Add("@Hblood", SqlDbType.Int).Value = info.Hblood
cmd.Parameters.Add("@Lblood", SqlDbType.Int).Value = info.Lblood
int i = cmd.ExecuteNonQuery()
cmd.Dispose()
con.Dispose()
return i
}
}
欢迎分享，转载请注明来源：内存溢出
微信扫一扫
支付宝扫一扫
评论列表（0条）