 |
|
ผมจะนำเอาภาพ ใน 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 :
1329 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
 |