Error importing xml file

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Mike Collins
    #1

    Error importing xml file

    I am trying to export data from multiple tables in SQL Server to an XML file
    so I can then import it to another database. It seems to be working fine for
    exporting, but I am having trouble importing the file. I am getting the
    following error trying to import the same xml file I just exported.
    "System.Data.Sq lClient.SqlExce ption: Line 1: Incorrect syntax near
    'GetTprsForExpo rt'. Can someone show me where I am going wrong. Even though I
    say the export is working, I am including it below in case there is something
    in there that needs to be changed. Also, the code I am including is VERY
    rough right now and will
    change quite a bit once I figure out what I am doing. For the import, If I
    understand it correctly, which I don't since I'm here :), I am supposed open
    a dataset and then update it. Is that correct? If someone can show me where
    I am going wrong and explain it, that would be great. Thanks in advance.

    public static int Export()
    {
    string databaseName = HttpContext.Cur rent.Session["DatabaseNa me"].ToString();
    string connectionStrin g =
    ConfigurationSe ttings.AppSetti ngs["DatabaseConnec tionString"] + databaseName;
    DataSet ds;

    using (SqlConnection conn = new SqlConnection(c onnectionString ))
    {
    DataTable dt = new DataTable();
    SqlDataAdapter adapter = new SqlDataAdapter( );

    adapter.SelectC ommand = new SqlCommand("Get TprsForExport", conn);
    adapter.SelectC ommand.CommandT ype = CommandType.Sto redProcedure;

    ds = new DataSet("TPRS") ;
    adapter.Fill(ds , "Tprs");
    }

    DataRelation dr;
    DataColumn parentCol;
    DataColumn childCol;

    parentCol = ds.Tables["Tprs"].Columns["TprID"];
    childCol = ds.Tables["Tprs1"].Columns["TprID"];

    dr = new DataRelation("T prAssociatedDat a", parentCol, childCol);

    // Add the relation to the DataSet.
    ds.Relations.Ad d(dr);

    ds.WriteXml(@"D :\Data\test.xml ", XmlWriteMode.Wr iteSchema);

    return ds.Tables[0].Rows.Count;
    }


    public static int Import()
    {
    string databaseName = HttpContext.Cur rent.Session["DatabaseNa me"].ToString();
    string connectionStrin g =
    ConfigurationSe ttings.AppSetti ngs["DatabaseConnec tionString"] + databaseName;

    using (SqlConnection conn = new SqlConnection(c onnectionString ))
    {
    SqlDataAdapter adapter = new SqlDataAdapter( );
    adapter.SelectC ommand = new SqlCommand("Get TprsForExport", conn);
    SqlCommandBuild er builder = new SqlCommandBuild er(adapter);

    DataSet ds = new DataSet("TPRS") ;
    adapter.Fill(ds , "Tprs");

    DataSet ds1 = new DataSet("TPRS") ;
    ds1.ReadXml(@"D :\Data\test.xml ", XmlReadMode.Rea dSchema);

    adapter.Update( ds1, "Tprs");
    }

    return 1;
    }

    Tags: None
    • Cor Ligthert [MVP]
      #2
      Re: Error importing xml file

      Mike,

      I hope that you don't mind that I check completely your code, it is to long
      for me, as far as I can see do I miss the line of code about this property.

      DataAdapter.AcceptChangesDuringFill Property (System.Data.Common)
      http://msdn2.microsoft.com/en-us/library/system.data.common.dataadapter.acceptchangesduringfill.aspx
      Gets or sets a value indicating whether AcceptChanges() is called on a DataRow after it is added to the DataTable during any of the Fill operations.


      That is mostly the first problem in this kind of situations.

      I hope this helps,

      Cor


      "Mike Collins" <MikeCollins@di scussions.micro soft.comschreef in bericht
      news:DA5641B4-F06C-418C-93E7-5CEF90BE7A71@mi crosoft.com...
      >I am trying to export data from multiple tables in SQL Server to an XML
      >file
      so I can then import it to another database. It seems to be working fine
      for
      exporting, but I am having trouble importing the file. I am getting the
      following error trying to import the same xml file I just exported.
      "System.Data.Sq lClient.SqlExce ption: Line 1: Incorrect syntax near
      'GetTprsForExpo rt'. Can someone show me where I am going wrong. Even
      though I
      say the export is working, I am including it below in case there is
      something
      in there that needs to be changed. Also, the code I am including is VERY
      rough right now and will
      change quite a bit once I figure out what I am doing. For the import, If I
      understand it correctly, which I don't since I'm here :), I am supposed
      open
      a dataset and then update it. Is that correct? If someone can show me
      where
      I am going wrong and explain it, that would be great. Thanks in advance.
      >
      public static int Export()
      {
      string databaseName =
      HttpContext.Cur rent.Session["DatabaseNa me"].ToString();
      string connectionStrin g =
      ConfigurationSe ttings.AppSetti ngs["DatabaseConnec tionString"] +
      databaseName;
      DataSet ds;
      >
      using (SqlConnection conn = new SqlConnection(c onnectionString ))
      {
      DataTable dt = new DataTable();
      SqlDataAdapter adapter = new SqlDataAdapter( );
      >
      adapter.SelectC ommand = new SqlCommand("Get TprsForExport", conn);
      adapter.SelectC ommand.CommandT ype = CommandType.Sto redProcedure;
      >
      ds = new DataSet("TPRS") ;
      adapter.Fill(ds , "Tprs");
      }
      >
      DataRelation dr;
      DataColumn parentCol;
      DataColumn childCol;
      >
      parentCol = ds.Tables["Tprs"].Columns["TprID"];
      childCol = ds.Tables["Tprs1"].Columns["TprID"];
      >
      dr = new DataRelation("T prAssociatedDat a", parentCol, childCol);
      >
      // Add the relation to the DataSet.
      ds.Relations.Ad d(dr);
      >
      ds.WriteXml(@"D :\Data\test.xml ", XmlWriteMode.Wr iteSchema);
      >
      return ds.Tables[0].Rows.Count;
      }
      >
      >
      public static int Import()
      {
      string databaseName =
      HttpContext.Cur rent.Session["DatabaseNa me"].ToString();
      string connectionStrin g =
      ConfigurationSe ttings.AppSetti ngs["DatabaseConnec tionString"] +
      databaseName;
      >
      using (SqlConnection conn = new SqlConnection(c onnectionString ))
      {
      SqlDataAdapter adapter = new SqlDataAdapter( );
      adapter.SelectC ommand = new SqlCommand("Get TprsForExport", conn);
      SqlCommandBuild er builder = new SqlCommandBuild er(adapter);
      >
      DataSet ds = new DataSet("TPRS") ;
      adapter.Fill(ds , "Tprs");
      >
      DataSet ds1 = new DataSet("TPRS") ;
      ds1.ReadXml(@"D :\Data\test.xml ", XmlReadMode.Rea dSchema);
      >
      adapter.Update( ds1, "Tprs");
      }
      >
      return 1;
      }
      >

        Comment

        • Mike Collins
          #3
          Re: Error importing xml file

          Thanks, but one thing I found out is that I cannot expect to update the
          database with the xml file when it contains multiple files. I believe I have
          to enumerate through the file and call an update stored procedure for each
          line. Is that correct?

          "Cor Ligthert [MVP]" wrote:
          Mike,
          >
          I hope that you don't mind that I check completely your code, it is to long
          for me, as far as I can see do I miss the line of code about this property.
          >
          DataAdapter.AcceptChangesDuringFill Property (System.Data.Common)
          http://msdn2.microsoft.com/en-us/library/system.data.common.dataadapter.acceptchangesduringfill.aspx
          Gets or sets a value indicating whether AcceptChanges() is called on a DataRow after it is added to the DataTable during any of the Fill operations.

          >
          That is mostly the first problem in this kind of situations.
          >
          I hope this helps,
          >
          Cor
          >
          >
          "Mike Collins" <MikeCollins@di scussions.micro soft.comschreef in bericht
          news:DA5641B4-F06C-418C-93E7-5CEF90BE7A71@mi crosoft.com...
          I am trying to export data from multiple tables in SQL Server to an XML
          file
          so I can then import it to another database. It seems to be working fine
          for
          exporting, but I am having trouble importing the file. I am getting the
          following error trying to import the same xml file I just exported.
          "System.Data.Sq lClient.SqlExce ption: Line 1: Incorrect syntax near
          'GetTprsForExpo rt'. Can someone show me where I am going wrong. Even
          though I
          say the export is working, I am including it below in case there is
          something
          in there that needs to be changed. Also, the code I am including is VERY
          rough right now and will
          change quite a bit once I figure out what I am doing. For the import, If I
          understand it correctly, which I don't since I'm here :), I am supposed
          open
          a dataset and then update it. Is that correct? If someone can show me
          where
          I am going wrong and explain it, that would be great. Thanks in advance.

          public static int Export()
          {
          string databaseName =
          HttpContext.Cur rent.Session["DatabaseNa me"].ToString();
          string connectionStrin g =
          ConfigurationSe ttings.AppSetti ngs["DatabaseConnec tionString"] +
          databaseName;
          DataSet ds;

          using (SqlConnection conn = new SqlConnection(c onnectionString ))
          {
          DataTable dt = new DataTable();
          SqlDataAdapter adapter = new SqlDataAdapter( );

          adapter.SelectC ommand = new SqlCommand("Get TprsForExport", conn);
          adapter.SelectC ommand.CommandT ype = CommandType.Sto redProcedure;

          ds = new DataSet("TPRS") ;
          adapter.Fill(ds , "Tprs");
          }

          DataRelation dr;
          DataColumn parentCol;
          DataColumn childCol;

          parentCol = ds.Tables["Tprs"].Columns["TprID"];
          childCol = ds.Tables["Tprs1"].Columns["TprID"];

          dr = new DataRelation("T prAssociatedDat a", parentCol, childCol);

          // Add the relation to the DataSet.
          ds.Relations.Ad d(dr);

          ds.WriteXml(@"D :\Data\test.xml ", XmlWriteMode.Wr iteSchema);

          return ds.Tables[0].Rows.Count;
          }


          public static int Import()
          {
          string databaseName =
          HttpContext.Cur rent.Session["DatabaseNa me"].ToString();
          string connectionStrin g =
          ConfigurationSe ttings.AppSetti ngs["DatabaseConnec tionString"] +
          databaseName;

          using (SqlConnection conn = new SqlConnection(c onnectionString ))
          {
          SqlDataAdapter adapter = new SqlDataAdapter( );
          adapter.SelectC ommand = new SqlCommand("Get TprsForExport", conn);
          SqlCommandBuild er builder = new SqlCommandBuild er(adapter);

          DataSet ds = new DataSet("TPRS") ;
          adapter.Fill(ds , "Tprs");

          DataSet ds1 = new DataSet("TPRS") ;
          ds1.ReadXml(@"D :\Data\test.xml ", XmlReadMode.Rea dSchema);

          adapter.Update( ds1, "Tprs");
          }

          return 1;
          }
          >
          >
          >

            Comment

            • Cor Ligthert [MVP]
              #4
              Re: Error importing xml file

              Mike,

              If you are updating with the update, than you are in fact only using an
              insert. As soon as there is than a row that exist, than you are in problem,
              because in your datarowstate is set that it is about a new row and than you
              can have concurrency error or errors because that some fields have to be
              unique in your database.

              How to solve that is in my idea based on the solution that you want to
              achieve.

              Your dataset has to have of course exactly the same schema as the database
              table.

              Cor

              "Mike Collins" <MikeCollins@di scussions.micro soft.comschreef in bericht
              news:664F697D-1281-4A29-B5FF-3FFEA992ED26@mi crosoft.com...
              Thanks, but one thing I found out is that I cannot expect to update the
              database with the xml file when it contains multiple files. I believe I
              have
              to enumerate through the file and call an update stored procedure for each
              line. Is that correct?
              >
              "Cor Ligthert [MVP]" wrote:
              >
              >Mike,
              >>
              >I hope that you don't mind that I check completely your code, it is to
              >long
              >for me, as far as I can see do I miss the line of code about this
              >property.
              >>
              >http://msdn2.microsoft.com/en-us/lib...uringfill.aspx
              >>
              >That is mostly the first problem in this kind of situations.
              >>
              >I hope this helps,
              >>
              >Cor
              >>
              >>
              >"Mike Collins" <MikeCollins@di scussions.micro soft.comschreef in bericht
              >news:DA5641B 4-F06C-418C-93E7-5CEF90BE7A71@mi crosoft.com...
              >I am trying to export data from multiple tables in SQL Server to an XML
              >file
              so I can then import it to another database. It seems to be working
              fine
              for
              exporting, but I am having trouble importing the file. I am getting
              the
              following error trying to import the same xml file I just exported.
              "System.Data.Sq lClient.SqlExce ption: Line 1: Incorrect syntax near
              'GetTprsForExpo rt'. Can someone show me where I am going wrong. Even
              though I
              say the export is working, I am including it below in case there is
              something
              in there that needs to be changed. Also, the code I am including is
              VERY
              rough right now and will
              change quite a bit once I figure out what I am doing. For the import,
              If I
              understand it correctly, which I don't since I'm here :), I am supposed
              open
              a dataset and then update it. Is that correct? If someone can show me
              where
              I am going wrong and explain it, that would be great. Thanks in
              advance.
              >
              public static int Export()
              {
              string databaseName =
              HttpContext.Cur rent.Session["DatabaseNa me"].ToString();
              string connectionStrin g =
              ConfigurationSe ttings.AppSetti ngs["DatabaseConnec tionString"] +
              databaseName;
              DataSet ds;
              >
              using (SqlConnection conn = new SqlConnection(c onnectionString ))
              {
              DataTable dt = new DataTable();
              SqlDataAdapter adapter = new SqlDataAdapter( );
              >
              adapter.SelectC ommand = new SqlCommand("Get TprsForExport", conn);
              adapter.SelectC ommand.CommandT ype = CommandType.Sto redProcedure;
              >
              ds = new DataSet("TPRS") ;
              adapter.Fill(ds , "Tprs");
              }
              >
              DataRelation dr;
              DataColumn parentCol;
              DataColumn childCol;
              >
              parentCol = ds.Tables["Tprs"].Columns["TprID"];
              childCol = ds.Tables["Tprs1"].Columns["TprID"];
              >
              dr = new DataRelation("T prAssociatedDat a", parentCol, childCol);
              >
              // Add the relation to the DataSet.
              ds.Relations.Ad d(dr);
              >
              ds.WriteXml(@"D :\Data\test.xml ", XmlWriteMode.Wr iteSchema);
              >
              return ds.Tables[0].Rows.Count;
              }
              >
              >
              public static int Import()
              {
              string databaseName =
              HttpContext.Cur rent.Session["DatabaseNa me"].ToString();
              string connectionStrin g =
              ConfigurationSe ttings.AppSetti ngs["DatabaseConnec tionString"] +
              databaseName;
              >
              using (SqlConnection conn = new SqlConnection(c onnectionString ))
              {
              SqlDataAdapter adapter = new SqlDataAdapter( );
              adapter.SelectC ommand = new SqlCommand("Get TprsForExport", conn);
              SqlCommandBuild er builder = new SqlCommandBuild er(adapter);
              >
              DataSet ds = new DataSet("TPRS") ;
              adapter.Fill(ds , "Tprs");
              >
              DataSet ds1 = new DataSet("TPRS") ;
              ds1.ReadXml(@"D :\Data\test.xml ", XmlReadMode.Rea dSchema);
              >
              adapter.Update( ds1, "Tprs");
              }
              >
              return 1;
              }
              >
              >>
              >>
              >>

                Comment

                • Mike Collins
                  #5
                  Re: Error importing xml file

                  I tried what you said, but I still get "Incorrect syntax neat
                  'GetTprsForExpo rt'". I'm pretty stuck here.

                  "Cor Ligthert [MVP]" wrote:
                  Mike,
                  >
                  If you are updating with the update, than you are in fact only using an
                  insert. As soon as there is than a row that exist, than you are in problem,
                  because in your datarowstate is set that it is about a new row and than you
                  can have concurrency error or errors because that some fields have to be
                  unique in your database.
                  >
                  How to solve that is in my idea based on the solution that you want to
                  achieve.
                  >
                  Your dataset has to have of course exactly the same schema as the database
                  table.
                  >
                  Cor
                  >
                  "Mike Collins" <MikeCollins@di scussions.micro soft.comschreef in bericht
                  news:664F697D-1281-4A29-B5FF-3FFEA992ED26@mi crosoft.com...
                  Thanks, but one thing I found out is that I cannot expect to update the
                  database with the xml file when it contains multiple files. I believe I
                  have
                  to enumerate through the file and call an update stored procedure for each
                  line. Is that correct?

                  "Cor Ligthert [MVP]" wrote:
                  Mike,
                  >
                  I hope that you don't mind that I check completely your code, it is to
                  long
                  for me, as far as I can see do I miss the line of code about this
                  property.
                  >
                  DataAdapter.AcceptChangesDuringFill Property (System.Data.Common)
                  http://msdn2.microsoft.com/en-us/library/system.data.common.dataadapter.acceptchangesduringfill.aspx
                  Gets or sets a value indicating whether AcceptChanges() is called on a DataRow after it is added to the DataTable during any of the Fill operations.

                  >
                  That is mostly the first problem in this kind of situations.
                  >
                  I hope this helps,
                  >
                  Cor
                  >
                  >
                  "Mike Collins" <MikeCollins@di scussions.micro soft.comschreef in bericht
                  news:DA5641B4-F06C-418C-93E7-5CEF90BE7A71@mi crosoft.com...
                  I am trying to export data from multiple tables in SQL Server to an XML
                  file
                  so I can then import it to another database. It seems to be working
                  fine
                  for
                  exporting, but I am having trouble importing the file. I am getting
                  the
                  following error trying to import the same xml file I just exported.
                  "System.Data.Sq lClient.SqlExce ption: Line 1: Incorrect syntax near
                  'GetTprsForExpo rt'. Can someone show me where I am going wrong. Even
                  though I
                  say the export is working, I am including it below in case there is
                  something
                  in there that needs to be changed. Also, the code I am including is
                  VERY
                  rough right now and will
                  change quite a bit once I figure out what I am doing. For the import,
                  If I
                  understand it correctly, which I don't since I'm here :), I am supposed
                  open
                  a dataset and then update it. Is that correct? If someone can show me
                  where
                  I am going wrong and explain it, that would be great. Thanks in
                  advance.

                  public static int Export()
                  {
                  string databaseName =
                  HttpContext.Cur rent.Session["DatabaseNa me"].ToString();
                  string connectionStrin g =
                  ConfigurationSe ttings.AppSetti ngs["DatabaseConnec tionString"] +
                  databaseName;
                  DataSet ds;

                  using (SqlConnection conn = new SqlConnection(c onnectionString ))
                  {
                  DataTable dt = new DataTable();
                  SqlDataAdapter adapter = new SqlDataAdapter( );

                  adapter.SelectC ommand = new SqlCommand("Get TprsForExport", conn);
                  adapter.SelectC ommand.CommandT ype = CommandType.Sto redProcedure;

                  ds = new DataSet("TPRS") ;
                  adapter.Fill(ds , "Tprs");
                  }

                  DataRelation dr;
                  DataColumn parentCol;
                  DataColumn childCol;

                  parentCol = ds.Tables["Tprs"].Columns["TprID"];
                  childCol = ds.Tables["Tprs1"].Columns["TprID"];

                  dr = new DataRelation("T prAssociatedDat a", parentCol, childCol);

                  // Add the relation to the DataSet.
                  ds.Relations.Ad d(dr);

                  ds.WriteXml(@"D :\Data\test.xml ", XmlWriteMode.Wr iteSchema);

                  return ds.Tables[0].Rows.Count;
                  }


                  public static int Import()
                  {
                  string databaseName =
                  HttpContext.Cur rent.Session["DatabaseNa me"].ToString();
                  string connectionStrin g =
                  ConfigurationSe ttings.AppSetti ngs["DatabaseConnec tionString"] +
                  databaseName;

                  using (SqlConnection conn = new SqlConnection(c onnectionString ))
                  {
                  SqlDataAdapter adapter = new SqlDataAdapter( );
                  adapter.SelectC ommand = new SqlCommand("Get TprsForExport", conn);
                  SqlCommandBuild er builder = new SqlCommandBuild er(adapter);

                  DataSet ds = new DataSet("TPRS") ;
                  adapter.Fill(ds , "Tprs");

                  DataSet ds1 = new DataSet("TPRS") ;
                  ds1.ReadXml(@"D :\Data\test.xml ", XmlReadMode.Rea dSchema);

                  adapter.Update( ds1, "Tprs");
                  }

                  return 1;
                  }

                  >
                  >
                  >
                  >
                  >
                  >

                    Comment

                    • Cor Ligthert [MVP]
                      #6
                      Re: Error importing xml file

                      Mike,

                      Without that renewed code we can do nothing for you.

                      Cor

                      "Mike Collins" <MikeCollins@di scussions.micro soft.comschreef in bericht
                      news:1B1765D2-E530-40E3-BFCC-260086EBE135@mi crosoft.com...
                      >I tried what you said, but I still get "Incorrect syntax neat
                      'GetTprsForExpo rt'". I'm pretty stuck here.
                      >
                      "Cor Ligthert [MVP]" wrote:
                      >
                      >Mike,
                      >>
                      >If you are updating with the update, than you are in fact only using an
                      >insert. As soon as there is than a row that exist, than you are in
                      >problem,
                      >because in your datarowstate is set that it is about a new row and than
                      >you
                      >can have concurrency error or errors because that some fields have to be
                      >unique in your database.
                      >>
                      >How to solve that is in my idea based on the solution that you want to
                      >achieve.
                      >>
                      >Your dataset has to have of course exactly the same schema as the
                      >database
                      >table.
                      >>
                      >Cor
                      >>
                      >"Mike Collins" <MikeCollins@di scussions.micro soft.comschreef in bericht
                      >news:664F697 D-1281-4A29-B5FF-3FFEA992ED26@mi crosoft.com...
                      Thanks, but one thing I found out is that I cannot expect to update the
                      database with the xml file when it contains multiple files. I believe I
                      have
                      to enumerate through the file and call an update stored procedure for
                      each
                      line. Is that correct?
                      >
                      "Cor Ligthert [MVP]" wrote:
                      >
                      >Mike,
                      >>
                      >I hope that you don't mind that I check completely your code, it is to
                      >long
                      >for me, as far as I can see do I miss the line of code about this
                      >property.
                      >>
                      >http://msdn2.microsoft.com/en-us/lib...uringfill.aspx
                      >>
                      >That is mostly the first problem in this kind of situations.
                      >>
                      >I hope this helps,
                      >>
                      >Cor
                      >>
                      >>
                      >"Mike Collins" <MikeCollins@di scussions.micro soft.comschreef in
                      >bericht
                      >news:DA5641B 4-F06C-418C-93E7-5CEF90BE7A71@mi crosoft.com...
                      >I am trying to export data from multiple tables in SQL Server to an
                      >XML
                      >file
                      so I can then import it to another database. It seems to be working
                      fine
                      for
                      exporting, but I am having trouble importing the file. I am getting
                      the
                      following error trying to import the same xml file I just exported.
                      "System.Data.Sq lClient.SqlExce ption: Line 1: Incorrect syntax near
                      'GetTprsForExpo rt'. Can someone show me where I am going wrong. Even
                      though I
                      say the export is working, I am including it below in case there is
                      something
                      in there that needs to be changed. Also, the code I am including is
                      VERY
                      rough right now and will
                      change quite a bit once I figure out what I am doing. For the
                      import,
                      If I
                      understand it correctly, which I don't since I'm here :), I am
                      supposed
                      open
                      a dataset and then update it. Is that correct? If someone can show
                      me
                      where
                      I am going wrong and explain it, that would be great. Thanks in
                      advance.
                      >
                      public static int Export()
                      {
                      string databaseName =
                      HttpContext.Cur rent.Session["DatabaseNa me"].ToString();
                      string connectionStrin g =
                      ConfigurationSe ttings.AppSetti ngs["DatabaseConnec tionString"] +
                      databaseName;
                      DataSet ds;
                      >
                      using (SqlConnection conn = new SqlConnection(c onnectionString ))
                      {
                      DataTable dt = new DataTable();
                      SqlDataAdapter adapter = new SqlDataAdapter( );
                      >
                      adapter.SelectC ommand = new SqlCommand("Get TprsForExport", conn);
                      adapter.SelectC ommand.CommandT ype = CommandType.Sto redProcedure;
                      >
                      ds = new DataSet("TPRS") ;
                      adapter.Fill(ds , "Tprs");
                      }
                      >
                      DataRelation dr;
                      DataColumn parentCol;
                      DataColumn childCol;
                      >
                      parentCol = ds.Tables["Tprs"].Columns["TprID"];
                      childCol = ds.Tables["Tprs1"].Columns["TprID"];
                      >
                      dr = new DataRelation("T prAssociatedDat a", parentCol, childCol);
                      >
                      // Add the relation to the DataSet.
                      ds.Relations.Ad d(dr);
                      >
                      ds.WriteXml(@"D :\Data\test.xml ", XmlWriteMode.Wr iteSchema);
                      >
                      return ds.Tables[0].Rows.Count;
                      }
                      >
                      >
                      public static int Import()
                      {
                      string databaseName =
                      HttpContext.Cur rent.Session["DatabaseNa me"].ToString();
                      string connectionStrin g =
                      ConfigurationSe ttings.AppSetti ngs["DatabaseConnec tionString"] +
                      databaseName;
                      >
                      using (SqlConnection conn = new SqlConnection(c onnectionString ))
                      {
                      SqlDataAdapter adapter = new SqlDataAdapter( );
                      adapter.SelectC ommand = new SqlCommand("Get TprsForExport", conn);
                      SqlCommandBuild er builder = new SqlCommandBuild er(adapter);
                      >
                      DataSet ds = new DataSet("TPRS") ;
                      adapter.Fill(ds , "Tprs");
                      >
                      DataSet ds1 = new DataSet("TPRS") ;
                      ds1.ReadXml(@"D :\Data\test.xml ", XmlReadMode.Rea dSchema);
                      >
                      adapter.Update( ds1, "Tprs");
                      }
                      >
                      return 1;
                      }
                      >
                      >>
                      >>
                      >>
                      >>
                      >>
                      >>

                        Comment

                        Previous template Next
                        Working...