Comments by Member 11266319 (Top 2 by date)

public class DALClass
{
public void OpenConnection(SqlConnection cn)
{
if (cn.State == ConnectionState.Closed)
cn.Open();
}
public void CloseConnection(SqlConnection cn)
{
if (cn.State != ConnectionState.Closed)
cn.Close();
}
//public static string constr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
public string NoneQueryCommand(SqlConnection cn, string ProcedureName, params SqlParameter[] SP)
{
//SqlConnection cn = new SqlConnection(DataBase.constr);
SqlCommand cmd = new SqlCommand(ProcedureName, cn);
cmd.CommandType = CommandType.StoredProcedure;

for (int i = 0; i < SP.Length; i++)
{
cmd.Parameters.Add(SP[i]);
}

if (cn.State == ConnectionState.Closed)
cn.Open();
try
{
cmd.ExecuteNonQuery();//my problem is here
//

#region UploadPicture
string result1= db.ValidateUploader(FUPic);
string result2 = db.ValidateUploader(FUPic1);
if (result1 == "OK" && result2=="OK")
{

string Url = "~/Slider/data1/images" + DateTime.Now.Second + FUPic.FileName;
FUPic.SaveAs(Server.MapPath(Url));
string TipUrl="~/Slider/data1/tooltips" + DateTime.Now.Second + FUPic1.FileName;
FUPic.SaveAs(Server.MapPath(TipUrl));
#region InsertPicture
//this is my parameters lblMsg.Text = db.NoneQueryCommand(cn, "sp_gallery_insert",
new SqlParameter("@ImageUrl",Url),
new SqlParameter("@tipUrl",TipUrl),
new SqlParameter("@Title",txtTitle.Text),
new SqlParameter("@alt",txtAlt.Text),
new SqlParameter("@TitleText",txtTitleText.Text),
new SqlParameter("@Text",txtText)
);
GridView1.DataBind();
#endregion




//
return "Sucssfuly !";

}
catch (SqlException ex)
{
return "Faild !!!";
}
finally
{
if (cn.State != ConnectionState.Closed)
cn.Close();
}
}

public SqlDataReader SelectCommand(SqlConnection cn, string ProcedureName, params SqlParameter[] SP)
{

SqlCommand cmd = new SqlCommand(ProcedureName, cn);
cmd.CommandType = CommandType.StoredProcedure;
for (int i = 0; i < SP.Length; i++)
{
cmd.Parameters.Add(SP[i]);
}

if (cn.State == ConnectionState.Closed)
cn.Open();
SqlDataReader sqldr = cmd.ExecuteReader();
return sqldr;
}
public DataTable SelectCommand(string ProcedureName, SqlConnection cn, params SqlParameter[] SP)
{

//SqlConnection sqlcn = new SqlConnection(DataBase.constr);
SqlDataAdapter sqlda = new SqlDataAdapter(ProcedureName, cn);
sqlda.SelectCommand.CommandType = CommandType.StoredProcedure;
for (int i = 0; i < SP.Length; i++)
{
sqlda.SelectCommand.Parameters.Add(SP[i]);
}
DataTable Result = new DataTable();
sqlda.Fill(Result);
return Result;
}
public DataSet SelectCommand(SqlConnection cn,bool flag, string ProcedureName, params SqlParameter[] SP)
{

//SqlConnection sqlcn = new SqlConnection(DataBase.constr);
SqlDataAdapter sqlda = new SqlDataAdapter(ProcedureName, cn);
sqlda.SelectCommand.CommandType = CommandType.StoredProcedure;
for (int i = 0; i < SP.Length; i++)
{
sqlda.SelectCommand.Parameters.Add(SP[i]);
}
DataSet Result = new DataSet();