[Vodstok]

i'll give you a sample of what i have been doing with my life lately:

/// <summary>
/// Uses stored Procedure to upload a file to a SQL DB
/// </summary>
/// <param name="name">Name of uploader</param>
/// <param name="file">Byte data for the file to be uploaded</param>
/// <param name="fname">Name of the file</param>
/// <param name="fsize">Size of the file</param>
/// <param name="img">File Type</param>
/// <param name="num">Request or release the file belongs to</param>
/// <param name="proc">The name of the stored procedure to run, either usp_filup, or usp_XmlSave</param>

public void Upper(string name,byte[] file,string fname,int fsize,string img,string num,string proc)
{
cmrsdb = new SqlCommand(proc, connec());
cmrsdb.CommandType = CommandType.StoredProcedure;
try
{
cmrsdb.Parameters.Add("@fileid", SqlDbType.NVarChar);
}
catch
{
cmrsdb.Parameters.Add("@fileid", SqlDbType.Int);
}
cmrsdb.Parameters.Add("@pfile", SqlDbType.Image);
cmrsdb.Parameters.Add("@filname", SqlDbType.NVarChar);
cmrsdb.Parameters.Add("@filesize", SqlDbType.Int);
cmrsdb.Parameters.Add("@imgtype", SqlDbType.NVarChar);

cmrsdb.Parameters.Add("@cmnum", SqlDbType.NVarChar);
cmrsdb.Connection.Open();
cmrsdb.Parameters["@fileid"].Value = name;
cmrsdb.Parameters["@pfile"].Value = file;
cmrsdb.Parameters["@filname"].Value = fname;
cmrsdb.Parameters["@filesize"].Value = fsize;
cmrsdb.Parameters["@imgtype"].Value = img;
cmrsdb.Parameters["@cmnum"].Value = num;
cmrsdb.ExecuteNonQuery();
cmrsdb.Connection.Close();
}

That's just a little Method for uploading a file to a database. it is one of the simpler things i have done lately.
I have earned being a lightweight in the thinking department.


Plus i wanted to show off :D