title: How to copy DataTable from Database without changing the RowState Property Using LINQ
body: <p>I am filling my datatable from databse sa </p>
  
  <pre><code>var z = from ins in cstmrDC.customersCntcts_rd(101)
          select ins;
  foreach (var dtbl in z)
  {
      DataRow drDtls;
      drDtls = dtDtls.NewRow();
      drDtls[0] = dtbl.cust_Slno;
      drDtls[1] = dtbl.cust_Cntctnm;
      drDtls[2] = dtbl.cust_Cntctdesig;
      drDtls[3] = dtbl.cust_Cntctmobl;
      drDtls[4] = dtbl.cust_Cntctmail;
      //drDtls.RowState = DataRowState.Unchanged; 
      dtDtls.Rows.Add(drDtls);
  }
  </code></pre>
  
  <p>In this way I can fill my <code>DataTable</code>, but the <code>RowState</code> of the <code>DataTable</code> is set to <code>Added</code> by default. But I want to manipulate these records from <code>DataGridView</code>. </p>
  
  <p>Without changing the <code>RowState</code>, how can I insert, delete and update my <code>DataGridview</code>? Help me to fill the data table directly from the database. </p>
  
  <p>I tried using <code>CopyToDataTable()</code> that is apperaring in my IntelliSense box. Maybe this is because I am using .Net 3.5. </p>
  
  <p>Please Help me..</p>