how to retrieve entire row data from datarow based on one column value
<p>I am new in C#.. struggling to learn it.. I want to know how can I retrieve entire row data based on one column value in datarow.. Let me be clear by giving an example..</p>

<pre><code>MerchantNo  TerminalNum CardType  Date
110033445   770010449    Amex    5/09/2011
</code></pre>

<p>Now I want to retrieve this row based on merchant number and then insert it into sql table..</p>

<p>What I am thinking is:</p>

<pre><code>if(MerchantNo!="")
 then retrieve the row
       and insert data in sql table..
</code></pre>

<p>Actually I am working on importing excel file..Hope u understood my question</p>

<pre><code>    string Mno = "";
           foreach (DataRow rowExcel in dtExcel.Rows)
           {

               foreach (DataColumn colExcel in dtExcel.Columns)
               {
                   Mno = rowExcel[colExcel].ToString().Trim();
                   if (Mno != "")
                   {
                       string Mno1 = Mno.Substring(16, 10);
                       Mno =Mno1.ToString();
                       //Int32 MerchNo = Convert.ToInt32(Mno);
                   }
                   break;
               }
               if(Mno!="")// Mno contains the exact MerchantNo.
               {


               }

               //break;

           }
</code></pre>
