示例#1
0
 public Puzzle(string Title, string Image)
 {
     InitializeComponent();
     strTitle        = Title;
     strImage        = Image;
     objQuestion     = new QuestionVO();
     ImagesDirectory = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "Images");
 }
示例#2
0
        private void Form1_Load(object sender, EventArgs e)
        {
            tooltip         = new ToolTip();
            LocalPictureBox = new PictureBox();
            objQuestion     = new QuestionVO();
            ImagesDirectory = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "Images");
            //SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename='c:\users\arif\documents\visual studio 2010\Projects\Medical Training Center\Medical Training Center\MedicalDB.mdf';Integrated Security=True;User Instance=True");
            string        DBPath = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location)) + @"\MedicalDB.mdf";
            SqlConnection con    = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=" + DBPath + ";Integrated Security=True;User Instance=True");

            con.Open();

            SqlCommand cmd = new SqlCommand("Select * from QuestionTB", con);

            ds = new System.Data.DataSet();
            SqlDataAdapter adapter = new SqlDataAdapter();

            adapter.SelectCommand = cmd;
            cmd.ExecuteNonQuery();
            adapter.Fill(ds);

            GlobalData.dtQuestionData = ds.Tables[0];

            objQuestion.QuestionID    = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
            CurrentQuestionID         = objQuestion.QuestionID;
            objQuestion.QuestionType  = Convert.ToString(ds.Tables[0].Rows[CurrentQuestionID][1]);
            objQuestion.QuestionTitle = Convert.ToString(ds.Tables[0].Rows[CurrentQuestionID][2]);
            objQuestion.QuestionName  = Convert.ToString(ds.Tables[0].Rows[CurrentQuestionID][3]).Split('~');
            string strOptions = Convert.ToString(ds.Tables[0].Rows[CurrentQuestionID][4]);

            objQuestion.QuestionOptions = strOptions.Split('~');
            objQuestion.QuestionAnswer  = Convert.ToString(ds.Tables[0].Rows[CurrentQuestionID][5]).Split('~');

            lblQuestionTitle.Text = objQuestion.QuestionTitle;

            pictureBox1.Image       = Image.FromFile(ImagesDirectory + @"\" + objQuestion.QuestionName[0] + ".jpg");
            pictureBoxOption1.Image = Image.FromFile(ImagesDirectory + @"\" + objQuestion.QuestionOptions[0] + ".jpg");
            pictureBox3.Image       = Image.FromFile(ImagesDirectory + @"\" + objQuestion.QuestionOptions[1] + ".jpg");
            pictureBox4.Image       = Image.FromFile(ImagesDirectory + @"\" + objQuestion.QuestionOptions[2] + ".jpg");
            pictureBox5.Image       = Image.FromFile(ImagesDirectory + @"\" + objQuestion.QuestionOptions[3] + ".jpg");


            // setting tool tip
            tooltip.SetToolTip(this.pictureBoxOption1, "Click to select option");
            tooltip.SetToolTip(this.pictureBox3, "Click to select option");
            tooltip.SetToolTip(this.pictureBox4, "Click to select option");
            tooltip.SetToolTip(this.pictureBox5, "Click to select option");

            con.Close();
        }