C#

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)