C#

Kwagga wrote:

objRange = objSheet.get_Range("A2", System.Reflection.Missing.Value);

Kwagga wrote:

objRange = objSheet.get_Range("B2", System.Reflection.Missing.Value);

int iR, iC;
iR = 1;//Worksheet RowIndex
iC = 1;//Worksheet ColumnIndex


foreach (ReadFile nomread in res)
{
        //in this you will work direct with worksheet.
        objSheet.Cells[iR, iC] = nomread.CLIENTSURNAME;
        objSheet.Cells[iR, iC+1] = nomread.CLIENTFORENAMES;

        iC = 1; //So your next column will start from 1 which will be A
        iR++; //increment row index by 1 as well.

}

Kwagga wrote:

It doesn't write all the records though. Only writes the last record. I get the jist of it

int iR, iC;
iR = 1;//Worksheet RowIndex
iC = 0;//Worksheet ColumnIndex

for (int i = 0; i <= Globals.Vars.arVbNums.Count - 1; i++)
    {
        iC++;
        //THE FOLLOWING IF STATEMENT USES % MOD OPERATOR
        // BE CAREFUL WHEN EDITING THE CODE.
        if (i % 30 == 0 && i != 0)
        {
            iR++;
            iC = 1;
        }
        oSheet.Cells[iR, iC] = Globals.Vars.arVbNums[i];

    }

using System.Data.SqlClient;

string ConnString = "User id = sa; Password = yourPassword; Initial Catalog = yourDataBaseName; Data Source = computerName";

SqlConnection sqlConn = new SqlConnection(ConnString);
sqlConn.Open();
SqlCommand cmd = sqlConn.CreateCommand();
cmd.CommandText = "SELECT column FROM table";

SqlDataReader reader = cmd.ExecuteReader();

while(reader.Read())
{
     string someVariable = reader[0].ToString();
}

sqlConn.Close();

you.suck = (you.passion != Programming)