  | 
		 		   | 
	  	    
          
            
			
	
			
			 
                ผมจะนำเอาภาพ ใน database มาแสดงได้อย่างไร  ใครพอจะช่วยได้ใหม่  เป็นภาพที่บันทึกลงในตารางเลย   
Code (C#) 
 private void textBoxID_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (textBoxID.Text.Trim() == "")
                {
                    return;
                }
                
            }
            
            if (comboBoxType.SelectedIndex == 0)
            {
                sb.Remove(0, sb.Length);                
                sb.Append("SELECT IDStudent, PreName, NameFirst, NameLast, Sex, Status, PClass, PRoom");
                sb.Append(" FROM TBStudent");
                sb.Append(" WHERE (Status = '1') AND (IDStudent=@IDStudent)");
            }
            else if (comboBoxType.SelectedIndex == 1)
            {
                sb.Remove(0, sb.Length);
                sb.Append("SELECT IDTeacher, PreName, NameFirst, NameLast, Status, sex, PositionNew, PicPresent");
                sb.Append(" FROM TTeacher");
                sb.Append(" WHERE (Status = 1) AND (IDTeacher=@IDTeacher)");
            }
            string sqlSearch;
            sqlSearch = sb.ToString();
            if (comboBoxType.SelectedIndex == 0)
            {
                         
                dtStudents=new DataTable();
                Comm.Parameters.Clear();
                Comm.Parameters.Add("@IDStudent",SqlDbType.NVarChar).Value = textBoxID.Text.Trim();
                Comm.CommandText = sqlSearch;
                Comm.CommandType = CommandType.Text;
                Comm.Connection = Conn;
                dr = Comm.ExecuteReader();
                if (dr.HasRows)
                {
                    ClearText();
                    ClearBinding();
                    dtStudents.Load(dr);
                    bs.DataSource = dtStudents;
                    txtPreName.DataBindings.Add("Text", bs, "PreName");
                    txtCode.DataBindings.Add("Text", bs, "IDStudent");
                    txtFName.DataBindings.Add("Text", bs, "NameFirst");
                    txtLName.DataBindings.Add("Text", bs, "NameLast");
                    txtRoom.DataBindings.Add("Text", bs, "PRoom");                    
                    txtClass.DataBindings.Add("Text", bs, "PClass");
                    txtGraden.DataBindings.Add("Text", bs, "Sex");
                    if (txtGraden.Text=="1")
                    {
                        txtGraden.Text = "ชาย";
                    }
                    else
                    {
                        txtGraden.Text = "หญิง";
                    }
                }
            }
            else if(comboBoxType.SelectedIndex==1)
            {
                
                
                dtTeacher=new DataTable();
                Comm.Parameters.Clear();
                Comm.Parameters.Add("@IDTeacher",SqlDbType.NVarChar).Value=textBoxID.Text.Trim();
                Comm.CommandText = sqlSearch;
                Comm.CommandType = CommandType.Text;
                Comm.Connection = Conn;
                dr = Comm.ExecuteReader();
                if (dr.HasRows)
                {
                    ClearText();
                    ClearBinding();
                    dtTeacher.Load(dr);
                    bs.DataSource = dtTeacher;
                    txtPreName.DataBindings.Add("Text", bs,"PreName");
                    txtCode.DataBindings.Add("Text", bs, "IDTeacher");
                    
                    txtFName.DataBindings.Add("Text", bs, "NameFirst");
                    txtLName.DataBindings.Add("Text", bs, "NameLast");
                    //txtRoom.DataBindings.Add("Text", bs, "PositionNew");
                    txtClass.DataBindings.Add("Text", bs, "PositionNew");
                    txtGraden.DataBindings.Add("Text", bs, "Sex");
                    if (txtGraden.Text == "1")
                    {
                        txtGraden.Text = "ชาย";
                    }
                    else
                    {
                        txtGraden.Text = "หญิง";
                    }
                   
                }
            }
            else
            {
                ClearText();              
                MessageBox.Show("เงื่อนไขที่คุณป้อน ไม่มี !!!", "ผลการค้นหา", MessageBoxButtons.OK, MessageBoxIcon.Information);
            
                textBoxID.Focus();
                comboBoxType.SelectAll();
                
            }
 
 
 
 
  Tag : .NET, Ms SQL Server 2008, C#, VS 2010 (.NET 4.x)               
                        | 
           
          
            | 
			
                             | 
           
          
            
              
                   | 
                   | 
                   | 
               
              
                   | 
                
                    
                      | Date :
                          2011-08-29 18:31:12 | 
                      By :
                          chowarin | 
                      View :
                          1370 | 
                      Reply :
                          2 | 
                     
                  | 
                   | 
               
              
                   | 
                   | 
                   | 
               
              | 
           
          
            | 
			 | 
           
         
	    
		             | 
		
			  |