C#

<br />
<br />
using System.Data;<br />
using System.Data.SqlClient;<br />
<br />
SqlConnection objConnection = null;<br />
SqlCommand objCommand = null;<br />
<br />
//Set up your SqlConnection object<br />
objConnection = new SqlConnection(YOUR_CONNECTION_STRING);<br />
<br />
//Set up your SqlCommand object<br />
objCommand = new SqlCommand();<br />
objCommand.CommandType = CommandType.StoredProcedure;<br />
objCommand.Connection = objConnection;<br />
objCommand.Connection.Open();<br />
<br />
//Add in any parameters<br />
objCommand.Parameters.Add("@MyParam", MyParamValue);<br />
<br />
objCommand.ExecuteNonQuery();<br />
<br />
if (objCommand.Connection != null)<br />
{<br />
	objCommand.Connection.Close();<br />
	objCommand.Connection.Dispose();<br />
}<br />
<br />
if (objCommand != null)<br />
{<br />
	objCommand.Dispose();<br />
        objCommand = null;<br />
}<br />
<br />

SqlConnection connection = new SqlConnection("someConnectionString");
			SqlCommand command = new SqlCommand();
			command.Connection = connection;
			command.CommandType = System.Data.CommandType.StoredProcedure;
			command.CommandText = "stored procedure name");

			SqlParameter parameterCustomerId = command.CreateParameter();
			parameterCustomerId.DbType = System.Data.DbType.Int64;
			parameterCustomerId.Direction = System.Data.ParameterDirection.Output;
			
			command.ExecuteNonQuery();

<br />
bool uploadCompleted = false;<br />
do<br />
{<br />
     try<br />
     {<br />
          File.Open("yourFileName", FileMode.Open, FileAccess.Read).Close();<br />
          uploadCompleted = true;<br />
     }<br />
     catch<br />
     {<br />
     }<br />
}<br />
while (uploadCompleted != true)<br />