C#

string strValue = " ";
for (int i = 0; i < stocksDataGridView.Rows.Count - 1; i++)
{
    for (int j = 0; j < stocksDataGridView.Rows[i].Cells.Count; j++)
    {
        if (!string.IsNullOrEmpty(stocksDataGridView[j, i].Value.ToString()))
        {
            if (j > 0)
                strValue += "," + stocksDataGridView[j, i].Value.ToString();
            else
            {
                if (!String.IsNullOrEmpty(strValue))
                    strValue = stocksDataGridView[j, i].Value.ToString();
                else
                    strValue = strValue + Environment.NewLine + stocksDataGridView[j, i].Value.ToString();
            }
        }
    }
    strValue = strValue + Environment.NewLine;
}

string fileName = @saveFileDialog1.FileName;
if (File.Exists(fileName) && !String.IsNullOrEmpty(strValue))
{
    File.WriteAllText(fileName, strValue);
}

private int callStoredProc(string fullPath, string type)
        {
            // File Type 1
            string connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
            string strRowAffect;
            SqlConnection con = new SqlConnection(connectionString);
            try
            {
                con.Open();
            }
            catch (Exception e)
            {
                this.lstEventsOccurred.Items.Add("ERROR: Database Connection could not be established in callStoredProc(): " + fullPath);
                this.lstEventsOccurred.Items.Add("Exception Produced: " + e.Message.ToString());
                return -1;
            }
            SqlCommand command = new SqlCommand("the_StoredProcedureToCall", con);
            command.CommandType = CommandType.StoredProcedure;

            SqlParameter retVal = command.Parameters.Add("@Return_Code", SqlDbType.Int);
            retVal.Direction = ParameterDirection.ReturnValue;

            SqlParameter inputFileName = command.Parameters.Add("@InputFilePathName", SqlDbType.VarChar, 120);
            inputFileName.Direction = ParameterDirection.Input;
            inputFileName.Value = fullPath;
            
            SqlParameter fileType = command.Parameters.Add("@FileType", SqlDbType.VarChar, 120);
            fileType.Direction = ParameterDirection.Input;
            fileType.Value = type;
            this.lstEventsOccurred.Items.Add("Calling:" + command.ExecuteNonQuery().ToString());

            strRowAffect = command.ExecuteNonQuery().ToString();
            con.Close();
            return (int)retVal.Value;
        }