110,533
社区成员
发帖
与我相关
我的任务
分享
String sql = "insert into Addressee values(@add_id,@add_name,@add_number,@add_num,@add_type,@add_image)";
SqlParameter sp_id = new SqlParameter("@add_id", SqlDbType.VarChar);
SqlParameter sp_name = new SqlParameter("@add_name", SqlDbType.VarChar);
SqlParameter sp_number = new SqlParameter("@add_number", SqlDbType.VarChar);
SqlParameter sp_num = new SqlParameter("@add_num", SqlDbType.VarChar);
SqlParameter sp_type = new SqlParameter("@add_type", SqlDbType.VarChar);
SqlParameter sp_image = new SqlParameter("@add_image", SqlDbType.Image);
sp_id.Value = vo.Id;
sp_name.Value = vo.Name;
sp_number.Value = vo.Number;
sp_num.Value = vo.Num;
sp_type.Value = vo.Type;
sp_image.Value = vo.Img;
List<SqlParamter> paramArray = new List<SqlParamter>();
paramArray.Add(sp_id);
paramArray.Add(sp_name);
paramArray.Add(sp_number);
paramArray.Add(sp_num);
paramArray.Add(sp_type);
paramArray.Add(sp_image);
int intResult = Execute(sql, paramArray);
-------------------------------------------------------------
public int Execute(String sql, List <SqlParamter> paramArray)
{
SqlConnection con = null;
try
{
con = Getcon();
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = sql;
for (int i=0; i <paramArray.Length; i++)
{
cmd.Parameters.Add(paramArray[i]);
}
return cmd.ExecuteNonQuery();
}
finally
{
if(con != null)
con.Close();
}
}
if (bts is byte[])
{
ImageConverter imc = new ImageConverter();
Image _img = imc.ConvertFrom(null, null, bts) as Image;
if (_img != null)
{
tmpObj = _img;
}
}