Hi,
I posted to the site before I realized that you already posted here, sorry about that. I tried taking out the @fileUrl and it then states that it is not receiving my next variable. My problem is that I'm not passing nay of the arguments. Here is the code that calls the procedure:
public static File GetItem(Guid fileId)
{
File myFile = null;
using (SqlConnection mySqlConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
SqlCommand myCommand = new SqlCommand("sprocFilesInsertSingleItem", mySqlConnection);
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter prmId = new SqlParameter("@id", SqlDbType.UniqueIdentifier);
prmId.Value = fileId;
myCommand.Parameters.Add(prmId);
mySqlConnection.Open();
using (SqlDataReader myReader = myCommand.ExecuteReader())
{
if (myReader.Read())
{
myFile = new File(myReader);
}
myReader.Close();
}
mySqlConnection.Close();
}
return myFile;
}
/// <summary>
/// Saves a file to the database.
/// </summary>
/// <returns>Returns true when the file was stored succesfully, or false otherwise.</returns>
public bool Save()
{
return Save(DataStoreType.Database, String.Empty);
}
/// <summary>
/// Saves a file to the file system.
/// This method also saves the meta data of the file to the database.
/// </summary>
/// <param name="filePath">The location and name of the file that is to be saved.</param>
/// <returns>
/// Returns true when the file was stored succesfully, or false otherwise.
/// </returns>
public bool Save(string filePath)
{
return Save(DataStoreType.FileSystem, filePath);
}
/// <summary>
/// Saves a file to the database and optionally to disk.
/// </summary>
/// <returns>Returns true when the file was stored succesfully, or false otherwise.</returns>
private bool Save(DataStoreType dataStoreType, string filePath)
{
using (SqlConnection mySqlConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
// Set up the Command object
SqlCommand myCommand = new SqlCommand("sprocFilesInsertSingleItem", mySqlConnection);
myCommand.CommandType = CommandType.StoredProcedure;
// Set up the ID parameter
SqlParameter prmId = new SqlParameter("@id", SqlDbType.UniqueIdentifier);
prmId.Value = id;
myCommand.Parameters.Add(prmId);
// Set up the FileUrl parameter
SqlParameter prmFileUrl = new SqlParameter("@fileUrl", SqlDbType.NVarChar, 255);
// If we need to store the file on disk, save the fileUrl.
if (dataStoreType == DataStoreType.FileSystem)
{
prmFileUrl.Value = fileUrl;
}
else
{
prmFileUrl.Value = DBNull.Value;
}
myCommand.Parameters.Add(prmFileUrl);
// Set up the FileData parameter
SqlParameter prmFileData = new SqlParameter("@fileData ", SqlDbType.Image);
// If we need to store the file in the database,
// pass in the actual file bytes.
if (dataStoreType == DataStoreType.Database)
{
prmFileData.Value = fileData;
prmFileData.Size = fileData.Length;
}
else
{
prmFileData.Value = DBNull.Value;
}
myCommand.Parameters.Add(prmFileData);
// Set up the OriginalName parameter
SqlParameter prmOriginalName = new SqlParameter("@originalName", SqlDbType.NVarChar, 50);
prmOriginalName.Value = originalName;
myCommand.Parameters.Add(prmOriginalName);
// Set up the ContentType parameter
SqlParameter prmContentType = new SqlParameter("@contentType", SqlDbType.NVarChar, 50);
prmContentType.Value = contentType;
myCommand.Parameters.Add(prmContentType);
// Execute the command, and clean up.
mySqlConnection.Open();
bool result = myCommand.ExecuteNonQuery() > 0;
mySqlConnection.Close();
// Database update is done; now store the file on disk if we need to.
if (dataStoreType == DataStoreType.FileSystem)
{
const int myBufferSize = 1024;
Stream myInputStream = new MemoryStream(fileData);
Stream myOutputStream = System.IO.File.OpenWrite(filePath);
byte[] buffer = new Byte[myBufferSize];
int numbytes;
while ((numbytes = myInputStream.Read(buffer, 0, myBufferSize)) > 0)
{
myOutputStream.Write(buffer, 0, numbytes);
}
myInputStream.Close();
myOutputStream.Close();
}
return result;
}
}
#endregion
#region Constructor(s)
/// <summary>
/// Initializes a new instance of the <see cref="File"/> class with the data from the SqlDataReader.
/// </summary>
/// <param name="myReader">A SqlDataReader that contains the data for this file.</param>
public File(SqlDataReader myReader)
{
id = myReader.GetGuid(myReader.GetOrdinal("Id"));
// dateCreated = myReader.GetDateTime(myReader.GetOrdinal("DateCrea ted"));
originalName = myReader.GetString(myReader.GetOrdinal("OriginalNa me"));
contentType = myReader.GetString(myReader.GetOrdinal("ContentTyp e"));
if (!myReader.IsDBNull(myReader.GetOrdinal("FileData" )))
{
fileData = (byte[])myReader[myReader.GetOrdinal("FileData")];
containsFile = true;
}
else
{
fileUrl = myReader.GetString(myReader.GetOrdinal("FileUrl")) ;
containsFile = false;
}
}
/// <summary>
/// Initializes a new instance of the File class with the data from the incoming parameters.
/// </summary>
/// <param name="contentType">The content type of the file, like image/pjpeg or image/gif.</param>
/// <param name="originalName">The original name of the uploaded file.</param>
/// <param name="fileData">A byte array with the actual file data.</param>
public File(string contentType, string originalName, byte[] fileData)
{
this.id = Guid.NewGuid();
this.contentType = contentType;
this.fileData = fileData;
this.originalName = originalName;
string extension = Path.GetExtension(originalName);
string fileName = this.Id.ToString() + extension;
this.fileUrl = fileName;
}
#endregion
}
I think it is just like the code that you had with only a few changes. Can you see something small I just forgotten? Thanks for helping me.
xml href from sql server
