using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;

public partial class resim : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //SqlConnection baglanti = new SqlConnection();
        //baglanti.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        //SqlCommand cmd = new SqlCommand();
        //cmd.CommandText = "INSERT INTO Resimler(resim,a,b,c,d,e,cvp) VALUES (@resim,@a,@b,@c,@d,@e,@cvp)";
        //cmd.CommandType = CommandType.Text;
        //cmd.Connection = baglanti;

        //string[] cvp = new string[6];
        //cvp[0] = TextBox1.Text.ToString();
        //cvp[1] = TextBox2.Text.ToString();
        //cvp[2] = TextBox3.Text.ToString();
        //cvp[3] = TextBox4.Text.ToString();
        //cvp[4] = TextBox5.Text.ToString();
        //cvp[5] = TextBox6.Text.ToString();

        //SqlParameter a = new SqlParameter("@a", SqlDbType.Char, 10);   a.Value = cvp[0].ToString();  cmd.Parameters.Add(a);
        //SqlParameter b = new SqlParameter("@b", SqlDbType.Char, 10);   b.Value = cvp[1].ToString();  cmd.Parameters.Add(b);
        //SqlParameter c = new SqlParameter("@c", SqlDbType.Char, 10);   c.Value = cvp[2].ToString();  cmd.Parameters.Add(c);
        //SqlParameter d = new SqlParameter("@d", SqlDbType.Char, 10);
        //d.Value = cvp[3].ToString();       cmd.Parameters.Add(d);
        //SqlParameter ee = new SqlParameter("@e", SqlDbType.Char, 10);  ee.Value = cvp[4].ToString(); cmd.Parameters.Add(ee);
        //SqlParameter dogruc = new SqlParameter("@dogru_cevap", SqlDbType.Char, 10);  dogruc.Value = cvp[5].ToString();
        //cmd.Parameters.Add(dogruc);

        //string imgpath = "upload/" + FileUpload1.FileName;
        //SqlParameter UploadedImage = new SqlParameter("@resim", SqlDbType.VarChar, 50);
        //UploadedImage.Value = imgpath;
        //cmd.Parameters.Add(UploadedImage);
        //baglanti.Open();
        //int result = cmd.ExecuteNonQuery();
        //baglanti.Close();
        //if (result > 0)             Label1.Text = "File Uploaded";
        //GridView1.DataBind();
        //Label2.Text = imgpath;

        //SqlConnection baglanti = new SqlConnection("Data Source=.;AttachDbFilename=http://localhost:1233/proje/App_Data/DbResim.mdf ;Integrated Security=True;User Instance=True");
        //SqlDataAdapter adp = new SqlDataAdapter("SELECT * FROM Resimler", baglanti);
        //DataTable Tablo = new DataTable();
        //adp.Fill(Tablo);
        //Random ran = new Random();
        //int deger = ran.Next(0, Tablo.Rows.Count);
        //Image2.ImageUrl = Tablo.Rows[deger]["resim"].ToString();
    }
}