xml导入sql server 2005 急!!!

Question

是啊  这是我的导出代码
            SaveFileDialog saveFile = new SaveFileDialog();
            saveFile.InitialDirectory = Application.ExecutablePath;
            saveFile.Filter = "XML Files(*.xml)|*.XML";
            saveFile.OverwritePrompt = true;
            saveFile.FileName = currentTable;
            if(saveFile.ShowDialog()==System.Windows.Forms.DialogResult.OK)
            {
                string theFile = saveFile.FileName;                try
                {
                    fileStream = new FileStream(theFile, FileMode.Create);
                    tableDataSet.WriteXml(fileStream, XmlWriteMode.WriteSchema);
                    fileStream.Flush();
                    fileStream.Close();
                  
                    MessageBox.Show("Export "+currentTable+"success!","information",MessageBoxButtons.OK,MessageBoxIcon.Information);
                }
                catch (Exception error)
                {
                    MessageBox.Show(error.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
已经导出成xml了   现在再导回去

Answer 1

可能在于
XmlWriteMode.DiffGram 和
 XmlReadMode.DiffGram);

Answer 2

你的daAdapter也没有指定InsertCommand呀

Answer 3

 dataAdapter.SelectCommand = command;
 SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);因为我指定了selectcommand    commandBuilder 会为我自动生成另外的sql
哪位知道怎么办啊
问题在于 xml的读写模式 XmlWriteMode   XmlReadMode   有问题    用diffGram  xmlDataSet到的是空数据(我用DataGridView绑定了xmlDataSet,可以看到增加了空行)   用别的干脆没变化

Answer 4

关注中.....我现在也面临XML文件导入的问题!