string a="2010122545";
string s="01 02 03 04 05";
public void _插入开奖数据(string qihao, string data)
{
System.Data.SqlClient.SqlConnection conn;
System.Data.SqlClient.SqlCommand cmd;
string connectionstring = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["sqli08kingdomConnectionString"].ConnectionString;
string cmdString = "INSERT INTO [开奖数据] (期号,数据) VALUES " + "(" + qihao + "," + data + ")";
conn = new System.Data.SqlClient.SqlConnection(connectionstring);
cmd = new System.Data.SqlClient.SqlCommand(cmdString, conn);
try
{
conn.Open();
cmd.ExecuteNonQuery();
} //cmd.ExecuteNonQuery();
catch (Exception err)
{
Lable1.text=err.Message.ToString();
}
finally
{
conn.Close();
}
}以上代码 运行没有错误
就是插入数据库,lable空间文本提示:02前有语法错误求各位大侠指点一下
把所有"01 02 03 04 05"分开储存public void _插入开奖数据(string qihao, string R1, string R2, string R3, string R4, string R5)
{
System.Data.SqlClient.SqlConnection conn;
System.Data.SqlClient.SqlCommand cmd;
string connectionstring = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["sqli08kingdomConnectionString"].ConnectionString;
string cmdString = "INSERT INTO [开奖数据] (期号,R1,R2,R3,R4,R5) VALUES " + "(" + qihao + "," + R1 + "," + R2 + "," + R3 + "," + R4 + "," + R5 + ")";
conn = new System.Data.SqlClient.SqlConnection(connectionstring);
cmd = new System.Data.SqlClient.SqlCommand(cmdString, conn);
try
{
conn.Open();
cmd.ExecuteNonQuery();
} //cmd.ExecuteNonQuery();
catch (Exception err)
{
ListBox1.Items.Add(err.Message);
}
finally
{
conn.Close();
}
}这次倒是存进去了,可是存入的数据自动去掉了前边的0急急急---
也可以用
string cmdString=string.Format("INSERT INTO [开奖数据] (期号,数据) VALUES('{0}','{1}')",qihao ,data);
用下面的语句看一下存储的长度.
select len(字段名) from 表
长度问题
一是修改数据库字段大小; 二是加强数据强壮性,严格的输入判断。
目前是采用修改数据的方法:alter table alter column caller nchar(50)
运行这句
alter TABLE [开奖数据] alter column 数据 nchar(50)再插入就没问题了
其实是我的插入字符串错了
我用了你的连接字符串