Comments by Member 10518995 (Top 8 by date)

Thanks soooooooooooooooooooooooooooooooo much :)

Thanks for your help really i appreciate ur efforts can i ask u how to i can change the location when it comes to the next loop which shouldn't be the same each time
but i can't

DBClass db = DBClass.GetInstance();
string str = @"INSERT INTO [Picture_upload].[dbo].[Pictures]
([cont_id]
,[path])
VALUES
(" + obj + ",'" +
openFileDialog1.FileName + "')";
db.ExecuteNonQuery(str, CommandType.Text);

i don't know what you mean ?
i get the pic from openfiledialog , and saved under openfiledialog.filname and sved in database in entity called path varchar type in a table called pictures



class DBClass{
public void ExecuteNonQuery(string Query, CommandType type)
{

OpenConnection();
cmd.CommandText = Query;
cmd.CommandType = type;
try
{
cmd.ExecuteNonQuery();
}
catch(Exception ex)
{

}
finally
{
ReleaseResource();
}
private void OpenConnection()
{
try
{
this.connection.Open();
}
catch
{ }
}

}