运行报错为: '(' 附近有语法错误。
标签 'xs' 已声明。标签名称在批查询或存储过程内部必须唯一。
标签 'xs' 已声明。标签名称在批查询或存储过程内部必须唯一。
急求大家帮助 谢谢
if(this.comboBox1.Text=="sql server 2000")
{
string tableNameC;
tableNameC = m5_Form.textBox1.Text.ToString(); XmlTextReader objTxtRd;
objTxtRd = new XmlTextReader(fileName); string strsql1 = "CREATE TABLE "+tableNameC+" (";
int j1 = 0, j2 = 0;
string abcd = " ";
while (objTxtRd.Read())
{
string lieming;
if (j1 == 4) abcd = Convert.ToString(objTxtRd.Name) + " " + "varchar(80),";
if (j1 % 4 == 0 && j1 > 4)
{
lieming = Convert.ToString(objTxtRd.Name) + " " + "varchar(80),";
if (lieming == abcd) break;
strsql1 = strsql1 + lieming;
j2++;
}
j1++;
} strsql1 = strsql1 + "mycount varchar(80))";
DataSet xDataSet = new DataSet();
xDataSet.ReadXml(fileName, XmlReadMode.ReadSchema);
//得到xml中的第一行
DataTable xTable = xDataSet.Tables[0];
DataSet DS = new DataSet();
string one = "select * from ";
one += tableNameC;
string dstri;
dstri = textBox2.Text; //XmlDocument doc = new XmlDocument(); SqlConnection Conne = new SqlConnection(dstri);
//Conne.Open();
SqlCommand Comma = new SqlCommand(strsql1, Conne);
Comma.Connection.Open();
Comma.ExecuteNonQuery();
SqlDataAdapter objAdapter1 = new SqlDataAdapter(one, Conne);
//填充数据
objAdapter1.Fill(DS, tableNameC);
//Conne.Close(); DataTable objTable = DS.Tables[tableNameC];
for (int i = 0; i < xTable.Rows.Count; i++)
{
DataRow xrow = xTable.Rows[i];
DataRow objNewRow = objTable.NewRow(); for (int j = 0; j < j2; j++)
{
objNewRow[j] = Convert.ToString(xrow[j]);
} objTable.Rows.Add(objNewRow);
}
//创建命令
new SqlCommandBuilder(objAdapter1);
//更新数据库
objAdapter1.Update(DS, tableNameC); Comma.Connection.Close();
MessageBox.Show("导入成功", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
} 运行报错为: '(' 附近有语法错误。
标签 'xs' 已声明。标签名称在批查询或存储过程内部必须唯一。
标签 'xs' 已声明。标签名称在批查询或存储过程内部必须唯一。
下面是从ACCESS转化出来的XML文档
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="student">
<xs:complexType>
<xs:sequence>
<xs:element name="sid" type="xs:string" minOccurs="0" />
<xs:element name="sname" type="xs:string" minOccurs="0" />
<xs:element name="ssex" type="xs:string" minOccurs="0" />
<xs:element name="sage" type="xs:string" minOccurs="0" />
<xs:element name="sbirth" type="xs:string" minOccurs="0" />
<xs:element name="sclass" type="xs:string" minOccurs="0" />
<xs:element name="smajor" type="xs:string" minOccurs="0" />
<xs:element name="sdepart" type="xs:string" minOccurs="0" />
<xs:element name="sparty" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<student>
<sid>2 </sid>
<sname>李 </sname>
<ssex>女 </ssex>
<sage>20 </sage>
<sbirth>1985-10-12 </sbirth>
<sclass>02 </sclass>
<smajor>计算机 </smajor>
<sdepart>计算机 </sdepart>
<sparty>团员 </sparty>
</student>
</NewDataSet>
标签 'xs' 已声明。标签名称在批查询或存储过程内部必须唯一。
标签 'xs' 已声明。标签名称在批查询或存储过程内部必须唯一。
急求大家帮助 谢谢
if(this.comboBox1.Text=="sql server 2000")
{
string tableNameC;
tableNameC = m5_Form.textBox1.Text.ToString(); XmlTextReader objTxtRd;
objTxtRd = new XmlTextReader(fileName); string strsql1 = "CREATE TABLE "+tableNameC+" (";
int j1 = 0, j2 = 0;
string abcd = " ";
while (objTxtRd.Read())
{
string lieming;
if (j1 == 4) abcd = Convert.ToString(objTxtRd.Name) + " " + "varchar(80),";
if (j1 % 4 == 0 && j1 > 4)
{
lieming = Convert.ToString(objTxtRd.Name) + " " + "varchar(80),";
if (lieming == abcd) break;
strsql1 = strsql1 + lieming;
j2++;
}
j1++;
} strsql1 = strsql1 + "mycount varchar(80))";
DataSet xDataSet = new DataSet();
xDataSet.ReadXml(fileName, XmlReadMode.ReadSchema);
//得到xml中的第一行
DataTable xTable = xDataSet.Tables[0];
DataSet DS = new DataSet();
string one = "select * from ";
one += tableNameC;
string dstri;
dstri = textBox2.Text; //XmlDocument doc = new XmlDocument(); SqlConnection Conne = new SqlConnection(dstri);
//Conne.Open();
SqlCommand Comma = new SqlCommand(strsql1, Conne);
Comma.Connection.Open();
Comma.ExecuteNonQuery();
SqlDataAdapter objAdapter1 = new SqlDataAdapter(one, Conne);
//填充数据
objAdapter1.Fill(DS, tableNameC);
//Conne.Close(); DataTable objTable = DS.Tables[tableNameC];
for (int i = 0; i < xTable.Rows.Count; i++)
{
DataRow xrow = xTable.Rows[i];
DataRow objNewRow = objTable.NewRow(); for (int j = 0; j < j2; j++)
{
objNewRow[j] = Convert.ToString(xrow[j]);
} objTable.Rows.Add(objNewRow);
}
//创建命令
new SqlCommandBuilder(objAdapter1);
//更新数据库
objAdapter1.Update(DS, tableNameC); Comma.Connection.Close();
MessageBox.Show("导入成功", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
} 运行报错为: '(' 附近有语法错误。
标签 'xs' 已声明。标签名称在批查询或存储过程内部必须唯一。
标签 'xs' 已声明。标签名称在批查询或存储过程内部必须唯一。
下面是从ACCESS转化出来的XML文档
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="student">
<xs:complexType>
<xs:sequence>
<xs:element name="sid" type="xs:string" minOccurs="0" />
<xs:element name="sname" type="xs:string" minOccurs="0" />
<xs:element name="ssex" type="xs:string" minOccurs="0" />
<xs:element name="sage" type="xs:string" minOccurs="0" />
<xs:element name="sbirth" type="xs:string" minOccurs="0" />
<xs:element name="sclass" type="xs:string" minOccurs="0" />
<xs:element name="smajor" type="xs:string" minOccurs="0" />
<xs:element name="sdepart" type="xs:string" minOccurs="0" />
<xs:element name="sparty" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<student>
<sid>2 </sid>
<sname>李 </sname>
<ssex>女 </ssex>
<sage>20 </sage>
<sbirth>1985-10-12 </sbirth>
<sclass>02 </sclass>
<smajor>计算机 </smajor>
<sdepart>计算机 </sdepart>
<sparty>团员 </sparty>
</student>
</NewDataSet>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货