title: asp.net insert dataset to other database
body: <p>I want to put dataset inside of the data to same database in the other datatable</p>
  
  <p>here is my code</p>
  
  <pre><code>Dim Conn As SqlConnection = New SqlConnection("server=localhost;database=MSDSS;Integrated Security=True")
      Dim urltext = "Select JournalName, IndexDB, Lang, Category From SJournal where JournalName is not null" + " And IndexDB='" &amp; indexdb &amp; "' And Lang='" &amp; lang &amp; "' And [Impact Factor] Between " &amp; ImpactFactorBegin &amp; " And " &amp; ImpactFactorEnd
      Dim Ad As SqlDataAdapter = New SqlDataAdapter(urltext, Conn)
      Dim D As DataSet = New DataSet()
  
      Ad.Fill(D, "SJ")
      D.Tables(0).Columns.Add(New DataColumn("STV"))
      Dim journallist() As String = journalname.Split("()")
      For i As Integer = 0 To D.Tables(0).Rows.Count - 1 Step 1
          D.Tables(0).Rows(i)("STV") = GetSimilarityWith(D.Tables(0).Rows(i).Item(0).ToString, journalname)
  
      Next i
  </code></pre>
  
  <p>how can I put this data to other database?</p>
  
  <p>have any idea ?</p>