//            Set up command for reuse in loop just change the customer id
           SqlConn1.Cmd = new SqlCommand();
           SqlConn1.Cmd.Parameters.Clear();
           SqlConn1.Cmd.CommandText = "Select Top 1
t1.SomeID1,t1.SomeID2,t2,UserId,fp From Database1.dbo.t1 c WITH (NOLOCK) " +
                                      "left Join database2.DBO.somtable2 t2
WITH (NOLOCK) on fp.FileId=c.FileId "+
                                      "where CustID=@CustId";
           SqlConn1.Cmd.Connection=SqlConn1.Conn;
           SqlConn1.Cmd.CommandType = CommandType.Text;  //
.StoredProcedure;
           SqlConn1.Cmd.Parameters.Add("ClaimID", SqlDbType.Int).Value = 0;
//Direction = ParameterDirection.Input;
           SqlConn1.Open();

           int ID1=0;
           int ID2=0;
           int UserID = 0;
           //oserver is local offline table of parsed data from text file
1000 0r 10000 rows
           //oTable is "Select top 0 from Database..sometable" the empty
table in dataset is the table i will be updating from parsed data
           while (oServer.RowPos<20) //(oServer.Eof==false)
           {

               otable.AppendRow();
               //add columns to the row
               otable,.ColumnPut("FileID", FileId); //File of parent table
Identity key Incomming Parameter
               CustID=Convert.ToInt32(oServer.ColumnGet("CustID")); // get
cust id from local table of parsed data
               oTable.ColumnPut("ClaimId",ClaimID);
               //Area In Question Below is this the proper way or should i
persist the open connection
               // get the tthe other information from the server using
SqlDataReader
                SqlConn1.Cmd.Open();  // in queston lots of opens for a
Single Run
                SqlConn1.Cmd.Parameters["CustID"].Value=CustID;
                Reader =
SqlConn1.Cmd.ExecuteReader(CommandBehavior.SingleRow);
                ClaimFileID = 0;
                MemberID = 0;
                UserID = 0;
                FormTypeID = 0;
                if (Reader.HasRows == true)
                {
                    while (Reader.Read())
                    {

                        if (Reader[0].GetType()!=typeof(System.DBNull)) ID1
= Convert.ToInt32(Reader[0].ToString());
                        if (Reader[1].GetType()!=typeof(System.DBNull)) ID2
= Convert.ToInt32(Reader[1].ToString());
                        if (Reader[2].GetType()!=typeof(System.DBNull))
UserID = Convert.ToInt32(Reader[2].ToString());

                    }
                }

this is looping through a local table that holds parsed data
i place the parsed data into another table with dataset and sqldataadapter
the avove sqldatareader gets some more information from the database that is
required
then i do a batch update with sqladapter

the question is the open connection where the Datareader is used insid the
loop could be 10000 loops
would it be better to open before the loop and close after the loop
or is the opening of the connection ok inside the loop

Thanks
DaveP