Data not insert into Database table after sqldataadapter.update()
<p>First sorry for my English.</p>

<p>Actually I want to insert data into database table using sqldataadapter from one datatable to another data table but no effect after import rows from other table</p>

<p>Code</p>

<pre><code>        DataTable table1 = objDataset1.Tables[0];
        DataTable tb = table1.Clone();
        DataSet ds = new DataSet();


        string ConnString = @"DataSource=.\SQLExpress;Database=WICC;Trusted_Connection=true;Connection Timeout=180;";

        SqlConnection con = new SqlConnection(ConnString);
        SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM tblSitePMRDetail", con);
        SqlCommandBuilder build = new SqlCommandBuilder(adapter);



            adapter.Fill(tb);
            con.Open();


            foreach (DataRow dr in table1.Rows)
            {
                tb.ImportRow(dr);
            }

            adapter.Update(tb);

            con.Close();
</code></pre>
