hi.i try delete all data in my database but database size not change.why? please help me to resize my database.

hi.i want copy database files.when i do detach database throw exeption.i search web and find things.but i cant drive result. please help me.thanks.

string ConnStr = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\mydb.mdf"
+";Integrated Security=True;User Instance=True";
SqlConnection mycon = new SqlConnection(ConnStr);
SqlCommand mycom = new SqlCommand("sp_detach_db @d=db_name()", mycon);
mycon.Open();
mycom.ExecuteScalar();
mycon.Close();

hi.tanks for answering. but this again throw exeption.please help me.

hi.please note to my code and help me.source image format is jpeg. below is my code.thanks.

private void Saveimg(Image image)
{
MemoryStream stream = new MemoryStream();
image.Save(stream,System.Drawing.Imaging.ImageFormat.Jpeg);//throw exeption

byte[]imgdata= new byte[stream.Length];
imgdata= stream.ToArray();
string Filename = "c:\\" + Convert.ToString(DateTime.Now.ToFileTime()) +".jpg";

FileStream fs = new FileStream(Filename, FileMode.CreateNew, FileAccess.Write);
fs.Write(imgdata, 0, imgdata.Length);
fs.Close();

}

Hi. i want to display an gif image in picturebox cuncurrent with for().below is my code,but image dont load while for() is running. please help me.thanks.

private void button1_Click(object sender, EventArgs e)
{
PictureBox pic = new PictureBox();
pic.Image = Image.FromFile("c:\\1.gif");
this.Controls.Add(pic);

        for (int i = 0; i < int.MaxValue; i++)
        {
            //my work
        }
        pic.Dispose();
    }