C#

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.

George_George wrote:

I must make Foo implements IDisposable and in the Dispose method of class Foo, invoke Dispose method of the StreamWriter object instance to release resource properly

George_George wrote:

what is the relationship between Finalize method and destructor?

class Program
{
    static void Main(string[] args)
    {
    }
    ~Program()
     {
        // clean resources
     }
}

//IL CODE

.class private auto ansi beforefieldinit Program
        extends [mscorlib]System.Object
    {
        .method public hidebysig specialname rtspecialname instance void .ctor() cil managed
        {
        }

        .method family hidebysig virtual instance void Finalize() cil managed
        {
        }

        .method private hidebysig static void Main(string[] args) cil managed
        {
            .entrypoint
        }

    }

N a v a n e e t h wrote:

GC will maintain a separate queue for items that need finalization. So you should implement the Dispose() pattern and clean all your resources. Also call GC.SuppressFinalize() from dispose which will suppress the finalization.

George_George wrote:

Which tool are you using to check IL code?

George_George wrote:

GC may have some smarter ways to treat all the to be finalized resources altogether?