public bool EditStudent(int id, string firstname, string lastname, DateTime birthday, string gender,
string address, string phone, MemoryStream picture)
{
SqlCommand command = new SqlCommand("UPDATE Add_Student" + " SET " +
"firstname = @Fname," +
"lastname = @Lname," +
"birthday = @Bdate," +
"gender = @Gender," +
"address = @Address," +
"phone = @Phone," +
"picture = @Picture" +
" WHERE id = @ID", data.GetConnection);
command.Parameters.Add("@ID", SqlDbType.Int).Value = id;
command.Parameters.Add("@Fname", SqlDbType.NChar).Value = firstname;
command.Parameters.Add("@Lname", SqlDbType.NVarChar).Value = lastname;
command.Parameters.Add("@Ddate", SqlDbType.DateTime).Value = birthday;
command.Parameters.Add("@Gender", SqlDbType.VarChar).Value = gender;
command.Parameters.Add("@Phone", SqlDbType.VarChar).Value = phone;
command.Parameters.Add("@Address", SqlDbType.VarChar).Value = address;
command.Parameters.Add("@Picture", SqlDbType.Image).Value = picture.ToArray();
data.Openconnection();
if (command.ExecuteNonQuery() == 1)
{
data.Closeconnection();
return(true);
}
else
{
data.Closeconnection();
return(false);
}
}
public bool InsertSelectedCourse(string id, int course)
{
My_Database db = new My_Database();
try
{
SqlCommand command = new SqlCommand("Insert into Course (Student_id, Course_id) " +
"values (@stdId, @courseId)", db.GetConnection);
command.Parameters.Add("@stdId", SqlDbType.Int).Value = id;
command.Parameters.Add("@courseId", SqlDbType.Int).Value = course;
db.Openconnection();
if (command.ExecuteNonQuery() == 1)
{
db.Closeconnection();
return(true);
}
else
{
db.Closeconnection();
return(false);
}
}
catch (Exception)
{
throw;
}
finally
{
db.Closeconnection();
}
}
public int IsExistId(int id)
{
My_Database dataBase = new My_Database();
try
{
SqlCommand command = new SqlCommand(
"SELECT id, firstname, lastname, birthday, gender, phone, address, picture FROM Add_Student WHERE id = @ID", dataBase.GetConnection);
command.Parameters.Add("@ID", SqlDbType.NVarChar).Value = id;
dataBase.Openconnection();
DataTable table = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter()
{
SelectCommand = command
};
adapter.Fill(table);
return(table.Rows.Count);
}
catch (Exception)
{
return(0);
throw;
}
finally
{
dataBase.Closeconnection();
}
}
private bool ShowList()
{
try
{
My_Database dataBase = new My_Database();
dataBase.Openconnection();
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM Course", dataBase.Getcon);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet, "Course");
dataGridView_Course.RowTemplate.Height = 80;
DataTable table = dataSet.Tables["Course"];
dataGridView_Course.DataSource = table;
dataGridView_Course.ReadOnly = true;
dataGridView_Course.AllowUserToAddRows = false;
dataBase.Closeconnection();
return(true);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(false);
throw;
}
}
public DataTable FindByHint(string hint)
{
My_Database dataBase = new My_Database();
try
{
SqlCommand command = new SqlCommand(
"SELECT * FROM Add_Student WHERE CONCAT(firstname, lastname, address) LIKE '%" +
hint
+ "%'", dataBase.GetConnection);
dataBase.Openconnection();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
DataTable table = new DataTable();
adapter.Fill(table);
// table = StudentsTableNaming(table);
dataBase.Closeconnection();
return(table);
}
catch (Exception)
{
dataBase.Closeconnection();
throw;
}
finally
{
dataBase.Closeconnection();
}
}
public DataTable GetTable(string query)
{
My_Database db = new My_Database();
try
{
db.Openconnection();
SqlCommand command = new SqlCommand(query, db.GetConnection);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
DataTable table = new DataTable();
adapter.Fill(table);
db.Closeconnection();
return(table);
}
catch (Exception)
{
throw;
}
finally
{
db.Closeconnection();
}
}
public DataTable GetAll_ID_label()
{
My_Database dataBase = new My_Database();
try
{
SqlCommand command = new SqlCommand("Select id, label From Course", dataBase.GetConnection);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
DataTable table = new DataTable();
dataBase.Openconnection();
adapter.Fill(table);
return(table);
}
catch (Exception)
{
throw;
}
finally
{
dataBase.Closeconnection();
}
}
public bool DeleteCourse(int id)
{
My_Database db = new My_Database();
try
{
SqlCommand command = new SqlCommand("DELETE FROM Course " +
"where id=@id",
db.GetConnection);
command.Parameters.Add("@id", SqlDbType.Int).Value = id;
db.Openconnection();
if (command.ExecuteNonQuery() == 1)
{
db.Closeconnection();
return(true);
}
else
{
db.Closeconnection();
return(false);
}
}
catch (Exception)
{
return(false);
throw;
}
finally
{
db.Closeconnection();
}
}
public bool RemoveThisCourse()
{
My_Database dataBase = new My_Database();
try
{
SqlCommand command = new SqlCommand(
"DELETE FROM Course" +
" WHERE Id = @id", dataBase.GetConnection);
command.Parameters.Add("@ID", SqlDbType.Int).Value = Id;
dataBase.Openconnection();
if (command.ExecuteNonQuery() == 1)
{
dataBase.Closeconnection();
return(true);
}
else
{
dataBase.Closeconnection();
return(false);
}
}
catch (Exception)
{
throw;
}
finally
{
dataBase.Closeconnection();
}
}
public bool UserNameExist(string username, string operation, int userid = 0)
{
string query = "";
if (operation == "register")
{
query = "SELECT * FROM New_User WHERE username = @un";
}
else if (operation == "edit")
{
query = "SELECT * FROM New_User WHERE username = @un and Id <> @id";
}
SqlCommand command = new SqlCommand(query, data.GetConnection);
command.Parameters.Add("@un", SqlDbType.NVarChar).Value = username;
command.Parameters.Add("@id", SqlDbType.Int).Value = userid;
SqlDataAdapter SDA = new SqlDataAdapter();
DataTable table = new DataTable();
SDA.SelectCommand = command;
SDA.Fill(table);
data.Openconnection();
if (table.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public DataTable GetCourseBySemester(string semester)
{
semester = semester.Trim();
My_Database db = new My_Database();
try
{
db.Openconnection();
SqlCommand command = new SqlCommand()
{
Connection = db.GetConnection,
CommandText = "SELECT * FROM Courses WHERE semester = @semester"
};
command.Parameters.Add("@semester", SqlDbType.NVarChar).Value = semester;
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
DataTable table = new DataTable();
adapter.Fill(table);
db.Closeconnection();
return(table);
}
catch (Exception)
{
throw;
}
finally
{
db.Closeconnection();
}
}
public DataTable GetAllBriefInfo()
{
My_Database db = new My_Database();
try
{
db.Openconnection();
SqlCommand command = new SqlCommand()
{
Connection = db.GetConnection,
CommandText = "SELECT ID, firstname, lastname FROM Add_Student"
};
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
DataTable table = new DataTable();
adapter.Fill(table);
db.Closeconnection();
return(table);
}
catch (Exception)
{
throw;
}
finally
{
db.Closeconnection();
}
}
public void LoadImageManager()
{
Contacts contact = new Contacts();
Users user = new Users();
My_Database data = new My_Database();
SqlCommand command = new SqlCommand("SELECT Id, firstname, lastname, username, password, picture, role FROM New_User WHERE username = @name AND password = @pass", data.GetConnection);
command.Parameters.Add("@name", SqlDbType.NVarChar).Value = User_tb.Text;
command.Parameters.Add("@pass", SqlDbType.NVarChar).Value = Pass_tb.Text;
data.Openconnection();
DataTable table = user.GetUser(command);
if (table.Rows.Count > 0)
{
SqlDataAdapter SDA = new SqlDataAdapter();
SDA.SelectCommand = command;
DataSet set = new DataSet();
SDA.Fill(set, "New_User");
data.Closeconnection();
byte[] pic1 = (byte[])table.Rows[0]["picture"];
MemoryStream picture1 = new MemoryStream(pic1);
contact.Picture_User.Image = Image.FromStream(picture1);
contact.Wellcome_LabelControl.Text = "Wellcome back " + table.Rows[0]["firstname"].ToString().Trim() +
" with username: "******"username"].ToString();
contact.LabelControl_ID.Text = table.Rows[0]["Id"].ToString();
contact.Show();
}
}
public bool ShowList()
{
try
{
My_Database dataBase = new My_Database();
dataBase.Openconnection();
SqlCommand command = new SqlCommand("SELECT * FROM Add_Student", dataBase.GetConnection);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
DataSet dataSet = new DataSet();
adapter.Fill(dataSet, "Add_Student");
dataBase.Closeconnection();
DataSource_Student.RowTemplate.Height = 40;
DataTable table = dataSet.Tables["Add_Student"];
DataSource_Student.DataSource = table;
DataSource_Student.ReadOnly = true;
DataGridViewImageColumn imageColumn = new DataGridViewImageColumn();
imageColumn = (DataGridViewImageColumn)DataSource_Student.Columns[7];
imageColumn.ImageLayout = DataGridViewImageCellLayout.Stretch;
DataSource_Student.AllowUserToAddRows = false;
return(true);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(false);
throw;
}
}
private void Remove_bt_Click(object sender, EventArgs e)
{
try
{
DialogResult delete = MessageBox.Show("Are you sure delete student with id: " + Id_Student_TB.Text, "",
MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (delete == DialogResult.Yes)
{
My_Database dataBase = new My_Database();
SqlCommand command = new SqlCommand(
"DELETE FROM Add_Student" +
" WHERE ID = @id", dataBase.Getcon);
command.Parameters.Add("@ID", SqlDbType.Int).Value = Id_Student_TB.Text;
dataBase.Openconnection();
if (command.ExecuteNonQuery() == 1)
{
MessageBox.Show("Complete", "Delete complete", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("ERROR", "Delete fails", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
dataBase.Closeconnection();
}
}
catch (Exception E)
{
Console.WriteLine(E.Message);
throw;
}
}
void GetTable(string MY_SQL)
{
My_Database data = new My_Database();
richTextBox1.Clear();
SqlCommand command = new SqlCommand(MY_SQL, data.Getcon);
data.Openconnection();
SqlDataReader read = command.ExecuteReader();
try
{
while (read.Read())
{
//int dataid = (int)read[0];
//richTextBox1.Text += " " + dataid;
//continue;
for (int i = 1; i < 3; i++)
{
string datafname = (string)read[i];
richTextBox1.Text += " " + datafname;
}
}
}
catch (Exception a)
{
MessageBox.Show(a.Message);
}
}
public string Role()
{
string role = "";
Users user = new Users();
My_Database data = new My_Database();
SqlCommand command = new SqlCommand("SELECT Id, firstname, lastname, username, password, picture, role FROM New_User WHERE username = @name AND password = @pass", data.GetConnection);
command.Parameters.Add("@name", SqlDbType.NVarChar).Value = User_tb.Text;
command.Parameters.Add("@pass", SqlDbType.NVarChar).Value = Pass_tb.Text;
data.Openconnection();
DataTable table = user.GetUser(command);
if (table.Rows.Count > 0)
{
SqlDataAdapter SDA = new SqlDataAdapter();
SDA.SelectCommand = command;
DataSet set = new DataSet();
SDA.Fill(set, "New_User");
data.Closeconnection();
role = table.Rows[0]["role"].ToString().Trim();
return(role);
}
else
{
return(role = "");
}
}
public bool AddStudent(int id, string firstname, string lastname, DateTime birthday, string gender,
string phone, string address, MemoryStream picture)
{
SqlCommand command = new SqlCommand("INSERT INTO Add_Student (id, firstname, lastname, birthday, gender, phone, address, picture)" +
"VALUES (@id, @fn, @ln, @bday, @gen, @add, @ph, @pic)", data.Getcon);
command.Parameters.Add("@id", SqlDbType.Int).Value = id;
command.Parameters.Add("@fn", SqlDbType.NChar).Value = firstname;
command.Parameters.Add("@ln", SqlDbType.NVarChar).Value = lastname;
command.Parameters.Add("@bday", SqlDbType.DateTime).Value = birthday;
command.Parameters.Add("@gen", SqlDbType.VarChar).Value = gender;
command.Parameters.Add("@add", SqlDbType.VarChar).Value = address;
command.Parameters.Add("@ph", SqlDbType.VarChar).Value = phone;
command.Parameters.Add("@pic", SqlDbType.Image).Value = picture.ToArray();
data.Openconnection();
if (command.ExecuteNonQuery() == 1)
{
data.Closeconnection();
return(true);
}
else
{
data.Closeconnection();
return(false);
}
}
public bool DeleteContacts(int uid)
{
try
{
My_Database data = new My_Database();
SqlCommand commnad = new SqlCommand("DELETE FROM Contact WHERE ID = @id", data.GetConnection);
commnad.Parameters.Add("@id", SqlDbType.Int).Value = uid;
data.Openconnection();
if (commnad.ExecuteNonQuery() == 1)
{
data.Closeconnection();
return(true);
}
else
{
data.Closeconnection();
return(false);
}
}
catch
{
XtraMessageBox.Show("The format is incorrect, please check again!");
return(false);
}
}
public DataTable GetAvgScoreByCourse()
{
My_Database db = new My_Database();
try
{
db.Openconnection();
SqlCommand command = new SqlCommand()
{
Connection = db.GetConnection,
CommandText = "SELECT Course.label, AVG(score.student_score) As AverageGrade " +
"FROM Course, Score " +
"WHERE Course.Id = Score.Course_id " +
"GROUP BY Course.label"
};
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
DataTable table = new DataTable();
adapter.Fill(table);
db.Closeconnection();
return(table);
}
catch (Exception)
{
throw;
}
finally
{
db.Closeconnection();
}
}
public DataTable GetAvg_byStudent()
{
My_Database db = new My_Database();
try
{
db.Openconnection();
SqlCommand command = new SqlCommand()
{
Connection = db.GetConnection,
CommandText = "SELECT Score.Student_id, AVG(Score.Student_score) " +
"FROM Add_Student inner join Score on Add_Student.ID = Score.Student_id " +
"Group by Score.Student_id " +
"order by Score.Student_id "
};
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
DataTable table = new DataTable();
adapter.Fill(table);
db.Closeconnection();
return(table);
}
catch (Exception)
{
throw;
}
finally
{
db.Closeconnection();
}
}
public DataTable AllLabel_IdOrder()
{
My_Database db = new My_Database();
try
{
db.Openconnection();
SqlCommand command = new SqlCommand()
{
Connection = db.GetConnection,
CommandText = "select Course.Id, Course.label " +
"from Course " +
"order by Course.Id"
};
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
DataTable table = new DataTable();
adapter.Fill(table);
db.Closeconnection();
return(table);
}
catch (Exception)
{
throw;
}
finally
{
db.Closeconnection();
}
}
public List <int> GetAllId()
{
List <int> result = new List <int>();
My_Database dataBase = new My_Database();
try
{
SqlCommand command = new SqlCommand("Select Id From Course", dataBase.GetConnection);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
DataTable table = new DataTable();
dataBase.Openconnection();
adapter.Fill(table);
foreach (DataRow row in table.Rows)
{
result.Add(Convert.ToInt32(row[0].ToString()));
}
return(result);
}
catch (Exception)
{
throw;
}
finally
{
dataBase.Closeconnection();
}
}
public bool Add_Score(int student, int course, float score, string description)
{
SqlCommand command = new SqlCommand("INSERT INTO Score (Student_id, Course_id, Student_Score, Description) VALUES (@sid, @cid, @sc, @des)", data.GetConnection);
command.Parameters.Add("@sid", SqlDbType.Int).Value = student;
command.Parameters.Add("@cid", SqlDbType.Int).Value = course;
command.Parameters.Add("@sc", SqlDbType.Float).Value = score;
command.Parameters.Add("@des", SqlDbType.Text).Value = description;
data.Openconnection();
if (command.ExecuteNonQuery() == 1)
{
return(true);
}
else
{
return(false);
}
}
public object TotalMaleStudent()
{
My_Database data = new My_Database();
SqlCommand command = new SqlCommand(@"select count(*) from Add_Student where gender = 'male'", data.Getcon);
data.Openconnection();
command.CommandText = @"select count(*) from Add_Student where gender = 'male'";
return(command.ExecuteScalar());
}
private void Find()
{
if (Id_Student_TB.Text.Trim() == "")
{
MessageBox.Show("Error", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
My_Database dataBase = new My_Database();
SqlCommand command = new SqlCommand(
"SELECT id, firstname, lastname, birthday, gender, phone, address, picture FROM Add_Student WHERE id = @address or firstname = @address or lastname = @address", dataBase.Getcon);
command.Parameters.Add("@address", SqlDbType.NVarChar).Value = Id_Student_TB.Text;
dataBase.Openconnection();
Student student = new Student();
DataTable table = student.getStudents(command);
if (table.Rows.Count > 0)
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
DataSet dataSet = new DataSet();
adapter.Fill(dataSet, "Add_Student");
dataBase.Closeconnection();
//dataGridView1.RowTemplate.Height = 80;
//DataTable table1 = dataSet.Tables["Add_Student"];
//dataGridView1.DataSource = table1;
//dataGridView1.ReadOnly = true;
//DataGridViewImageColumn imageColumn = new DataGridViewImageColumn();
//imageColumn = (DataGridViewImageColumn)dataGridView1.Columns[7];
//imageColumn.ImageLayout = DataGridViewImageCellLayout.Stretch;
//dataGridView1.AllowUserToAddRows = false;
Id_Student_TB.Text = table.Rows[0]["id"].ToString();
Firstname_TB.Text = table.Rows[0]["firstname"].ToString();
Lastname_TB.Text = table.Rows[0]["lastname"].ToString();
dateTime.Value = (DateTime)table.Rows[0]["birthday"];
if (table.Rows[0]["gender"].ToString() == "Female")
{
radioMale.Checked = true;
}
else if (table.Rows[0]["gender"].ToString() == "Male")
{
radioFemale.Checked = true;
}
Phone_TB.Text = table.Rows[0]["phone"].ToString();
Address_TB.Text = table.Rows[0]["address"].ToString();
byte[] pic = (byte[])table.Rows[0]["picture"];
MemoryStream picture = new MemoryStream(pic);
pictureBox.Image = Image.FromStream(picture);
}
else
{
MessageBox.Show("not found", "Find Student", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
public bool InsertGroup(int id, string nid, int userid)
{
SqlCommand command = new SqlCommand("INSERT INTO Group1 (Group_id, Group_name, User_id) VALUES (@id, @name, @uid)", data.GetConnection);
command.Parameters.Add("@id", SqlDbType.Int).Value = id;
command.Parameters.Add("@name", SqlDbType.NVarChar).Value = nid;
command.Parameters.Add("@uid", SqlDbType.Int).Value = userid;
data.Openconnection();
if (command.ExecuteNonQuery() == 1)
{
data.Closeconnection();
return(true);
}
else
{
data.Closeconnection();
return(false);
}
}
private void Edit_bt_Click(object sender, EventArgs e)
{
try
{
My_Database data = new My_Database();
SqlCommand command = new SqlCommand("UPDATE Add_Student" + " SET " +
"firstname = @Fname," +
"lastname = @Lname," +
"birthday = @Bdate," +
"gender = @Gender," +
"phone = @Phone," +
"address = @Adress," +
"picture = @Picture" +
" WHERE id = @ID", data.Getcon);
command.Parameters.Add("@Fname", SqlDbType.NVarChar).Value = Firstname_TB.Text;
command.Parameters.Add("@Lname", SqlDbType.NVarChar).Value = Lastname_TB.Text;
command.Parameters.Add("@Bdate", SqlDbType.DateTime).Value = dateTime.Value;
command.Parameters.Add("@Phone", SqlDbType.NVarChar).Value = Phone_TB.Text;
command.Parameters.Add("@Adress", SqlDbType.NVarChar).Value = Address_TB.Text;
ImageConverter converter = new ImageConverter();
byte[] image = (byte[])converter.ConvertTo(pictureBox.Image, typeof(byte[]));
command.Parameters.Add("@Picture", SqlDbType.Image).Value = image;
command.Parameters.Add("@ID", SqlDbType.Int).Value = Id_Student_TB.Text;
if (radioMale.Checked)
{
command.Parameters.Add("@Gender", SqlDbType.NVarChar).Value = "Male";
}
else if (radioFemale.Checked)
{
command.Parameters.Add("@Gender", SqlDbType.NVarChar).Value = "Female";
}
else
{
command.Parameters.Add("@Gender", SqlDbType.NVarChar).Value = "Male";
}
data.Openconnection();
if (command.ExecuteNonQuery() == 1)
{
MessageBox.Show("Complete", "Edit completed", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("ERROR", "Edit failed", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
data.Closeconnection();
}
catch (Exception E)
{
Console.WriteLine(E.Message);
throw;
}
}
public void SavePicture()
{
My_Database data = new My_Database();
data.Openconnection();
SqlCommand command = new SqlCommand("SELECT picture FROM Add_Student", data.Getcon);
ImageConverter convert = new ImageConverter();
Image image = (Image)convert.ConvertFrom(command.ExecuteScalar());
image.Save(@"D:\picture.jpg");
image.Save(@"D:\picture.docx");
image.Save(@"D:\picture.pdf");
data.Closeconnection();
}
public bool Find()
{
if (ID_student.Text.Trim() == "")
{
MessageBox.Show("Error", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
else
{
My_Database dataBase = new My_Database();
SqlCommand command = new SqlCommand(
"SELECT id, firstname, lastname, birthday, gender, address, phone, picture FROM Add_Student WHERE id = @address or firstname = @address or lastname = @address", dataBase.GetConnection);
command.Parameters.Add("@address", SqlDbType.NVarChar).Value = ID_student.Text;
dataBase.Openconnection();
Students student = new Students();
DataTable table = student.GetStudents(command);
if (table.Rows.Count > 0)
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
DataSet dataSet = new DataSet();
adapter.Fill(dataSet, "Add_Student");
dataBase.Closeconnection();
ID_student.Text = table.Rows[0]["id"].ToString();
Firstname.Text = table.Rows[0]["firstname"].ToString();
Lastname.Text = table.Rows[0]["lastname"].ToString();
Birthday_picker.DateTime = (DateTime)table.Rows[0]["birthday"];
if (table.Rows[0]["gender"].ToString() == "Female")
{
Check_female.Checked = true;
}
else if (table.Rows[0]["gender"].ToString() == "Male")
{
Check_male.Checked = true;
}
Address_student.Text = table.Rows[0]["address"].ToString();
Phone_student.Text = table.Rows[0]["phone"].ToString();
byte[] pic = (byte[])table.Rows[0]["picture"];
MemoryStream picture = new MemoryStream(pic);
Picture_Student.Image = Image.FromStream(picture);
return(true);
}
else
{
XtraMessageBox.Show("Not found", "Find Student", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(false);
}
}
}
