C#

pyde wrote:

default.aspx

Ian Uy wrote:

The problem with the above code is it consumes too much memory

Ian Uy wrote:

I can't inform the user of the progress of the file reading.

Ian Uy wrote:

such a way that I can get the progress of the reading?

Christian Graus wrote:

Only if your file is huge

Christian Graus wrote:

Do it the old way, open the file, create a byte array and read a section at a time, but you'll need to do it on a thread or use Application.DoEvents for your UI to update during the process.

Ian Uy wrote:

I usually read 500mb to 1gb of data.

Ian Uy wrote:

But can please point me to an article on how do it the "old way" using buffers, loops and stuff.

public static byte[] ReadFully (Stream stream, int initialLength)<br />
{<br />
    // If we've been passed an unhelpful initial length, just<br />
    // use 32K.<br />
    if (initialLength < 1)<br />
    {<br />
        initialLength = 32768;<br />
    }<br />
    <br />
    byte[] buffer = new byte[initialLength];<br />
    int read=0;<br />
    <br />
    int chunk;<br />
    while ( (chunk = stream.Read(buffer, read, buffer.Length-read)) > 0)<br />
    {<br />
        read += chunk;<br />
        <br />
        // If we've reached the end of our buffer, check to see if there's<br />
        // any more information<br />
        if (read == buffer.Length)<br />
        {<br />
            int nextByte = stream.ReadByte();<br />
            <br />
            // End of stream? If so, we're done<br />
            if (nextByte==-1)<br />
            {<br />
                return buffer;<br />
            }<br />
            <br />
            // Nope. Resize the buffer, put in the byte we've just<br />
            // read, and continue<br />
            byte[] newBuffer = new byte[buffer.Length*2];<br />
            Array.Copy(buffer, newBuffer, buffer.Length);<br />
            newBuffer[read]=(byte)nextByte;<br />
            buffer = newBuffer;<br />
            read++;<br />
        }<br />
    }<br />
    // Buffer is now too big. Shrink it.<br />
    byte[] ret = new byte[read];<br />
    Array.Copy(buffer, ret, read);<br />
    return ret;<br />
}

cmd.commandtext = "sp_someStoredProcedure " + myDateTime.ToString();

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

HarveySaayman wrote:

is there a better way of sending sql this dateTime?

cmd.CommandType = CommandType.StroredProcedure<br />
cmd.CommandText = "sp_someStoredprocedure";<br />
cmd.Parameters.Add(new SqlParameter("@myDate",SqlDbType.Date));<br />
cmd.Parameters["@myDate"].Value = myDateInstance;

<sqlcommand insertcommand="new" sqlcommand(="sp_InsertIntoAccessPunches" ,="" newsqlconn);<br="" mode="hold" />insertCommand.CommandType = CommandType.StoredProcedure;

insertCommand.Parameters.Add("@dateTime", SqlDbType.DateTime);
insertCommand.Parameters["@dateTime"].Value = DateTime.Parse(dateTime); //dateTime is the string

insertCommand.Parameters.AddWithValue("@empNo", empNo);

insertCommand.Parameters.AddWithValue("@TerminalID", terminalID);

cmd.ExecuteNonQuery();

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

sarilee wrote:

A pencil icon appears in datagrid whenever we edit any of its column.

sarilee wrote:

I need to perform insertion of data in database using datagrid.