ImagesSQLHandle.cs
public bool AddImages(Images images)
{
SQLHelper helper = new SQLHelper();
SqlDataReader dr = null;
SqlParameter[] parms ={
new SqlParameter("@CategoryId",SqlDbType.Int,8),
new SqlParameter("ImageName",SqlDbType.NVarChar,100),
new SqlParameter("ImageInfo",SqlDbType.Image,10000000),
new SqlParameter("ImageDate",SqlDbType.DateTime,8)
};
parms[0].Value = images.CategoryId;
parms[1].Value = images.ImageName;
parms[2].Value = images.ImageInfo;
parms[3].Value = images.ImageDate;
int i;
i = helper.ExecuteNonQuery("Images_Add",parms);
if (i == 0)
return true;
else
return false;
}
Images.cs
namespace Graduation.Model.Images
{
public class Images
{
private int _CategoryId;
public int CategoryId
{
get
{
return _CategoryId;
}
public bool AddImages(Images images)
{
SQLHelper helper = new SQLHelper();
SqlDataReader dr = null;
SqlParameter[] parms ={
new SqlParameter("@CategoryId",SqlDbType.Int,8),
new SqlParameter("ImageName",SqlDbType.NVarChar,100),
new SqlParameter("ImageInfo",SqlDbType.Image,10000000),
new SqlParameter("ImageDate",SqlDbType.DateTime,8)
};
parms[0].Value = images.CategoryId;
parms[1].Value = images.ImageName;
parms[2].Value = images.ImageInfo;
parms[3].Value = images.ImageDate;
int i;
i = helper.ExecuteNonQuery("Images_Add",parms);
if (i == 0)
return true;
else
return false;
}
Images.cs
namespace Graduation.Model.Images
{
public class Images
{
private int _CategoryId;
public int CategoryId
{
get
{
return _CategoryId;
}
