وبلاگ رسمی علیرضا شهامت در بلاگ اسکای
وبلاگ رسمی علیرضا شهامت در بلاگ اسکای - تأسیس شده در سال 1396
وبلاگ رسمی علیرضا شهامت در بلاگ اسکای
وبلاگ رسمی علیرضا شهامت در بلاگ اسکای - تأسیس شده در سال 1396کدهای دیتابیس - 14001213
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Test_DB_Prj_01
{
//public partial class Form1 : Form
public partial class Form1 : DevComponents.DotNetBar.Office2007Form
{
public Form1()
{
InitializeComponent();
}
SqlConnection connection_1;
SqlCommand command_1;
string Table_Name = "[Table_Students]";
int selected_row_index = -1;
int selected_column_index = -1;
int Selected_Student_Code;
bool Search_Mode = false;
DataSet obj_DataSet;
SqlDataAdapter obj_SqlDataAdapter;
bool before_first_click_on_average_field = true;
string where_clause = "";
string where_clause_average = "";
string where_clause_first_name = "";
string where_clause_last_name = "";
string where_clause_student_code = "";
string where_clause_Maghta_ = "";
string where_clause_Reshte = "";
private void button1_Click(object sender, EventArgs e)
{
Form2 f2;
f2 = new Form2();
f2.Show();
}
private void Form1_Load(object sender, EventArgs e)
{
this.MaximizeBox = false;
//this.MaximizeBox = true;
//this.Font = new Font("Tahoma", 14);
/*
MessageBox.Show(
this.GetColorScheme().ToString()
);
*/
string connectionString;
//connectionString = "data source = (local) ; initial catalog = Test_DB_001 ; integrated security = true;";
connectionString =
"Data Source=" +
"SHPC_14000702A\\SQLEXPRESS_2008" +
";" +
"Initial Catalog=" +
"Test_DB_14001122_b" +
";" +
"Integrated Security=True";
connection_1 = new SqlConnection(connectionString);
command_1 = new SqlCommand();
}
private void Display_DataBase()
{
dataset_etc( out obj_DataSet,out obj_SqlDataAdapter);
obj_SqlDataAdapter.SelectCommand.CommandText = " select * from " + Table_Name;
data_fill_etc();
set_DGV();
}
private void auto_resize_loops()
{
for (int i = 0; i < dataGridViewX_Students.Columns.Count; i++)
{
dataGridViewX_Students.AutoResizeColumn(i);
}
for (int i = 0; i < dataGridViewX_Students.Rows.Count; i++)
{
dataGridViewX_Students.AutoResizeRow(i);
}
}
private void auto_resize()
{
dataGridViewX_Students.AutoResizeColumnHeadersHeight();
// Error 2 Argument 1: cannot convert from 'int' to 'System.Windows.Forms.DataGridViewRowHeadersWidthSizeMode' G:\a\a\L\L\b\g\DS\b\q~t\b-r\Crt\mm\VS\13\2t\DB\1400 11 27\0719\Test_DB_Prj_13\Test_DB_Prj_01\Form1.cs 142 62 Test_DB_Prj_01 ******** \\
dataGridViewX_Students.AutoResizeRowHeadersWidth(DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders);
dataGridViewX_Students.AutoResizeColumn(0, DataGridViewAutoSizeColumnMode.AllCells);
}
private void Set_columns_width()
{
dataGridViewX_Students.Columns[0].Width = 150;
dataGridViewX_Students.Columns[1].Width = 80;
dataGridViewX_Students.Columns[2].Width = 120;
dataGridViewX_Students.Columns[3].Width = 60;
dataGridViewX_Students.Columns[4].Width = 80;
dataGridViewX_Students.Columns[5].Width = 150;
}
private void Set_HeaderTexts()
{
if (dataGridViewX_Students.Columns.Count > 0)
{
dataGridViewX_Students.Columns[0].HeaderText = "کد دانشجویی";
dataGridViewX_Students.Columns[1].HeaderText = "نام دانشجو";
dataGridViewX_Students.Columns[2].HeaderText = "نام خانوادگی دانشجو";
dataGridViewX_Students.Columns[3].HeaderText = "معدل";
dataGridViewX_Students.Columns[4].HeaderText = "مقطع تحصیلی";
dataGridViewX_Students.Columns[5].HeaderText = "رشته ی تحصیلی";
}
}
private void groupPanel1_Click(object sender, EventArgs e)
{
}
private void buttonX_Search_Click(object sender, EventArgs e)
{
empty_TextBoxes();
Search_Data();
}
private void Search_Data()
{
//throw new NotImplementedException();
checkBox_Student_Code.Visible = !checkBox_Student_Code.Visible;
checkBox_Student_FName.Visible = !checkBox_Student_FName.Visible;
checkBox_Student_LName.Visible = !checkBox_Student_LName.Visible;
checkBox_Student_Average.Visible = !checkBox_Student_Average.Visible;
checkBox_Maghta_.Visible = !checkBox_Maghta_.Visible;
checkBox_Reshte.Visible = !checkBox_Reshte.Visible;
Search_Mode = !Search_Mode;
if (!Search_Mode)
{
before_first_click_on_average_field = true;
}
Display_DataBase();
}
private void buttonX_Exit_Click(object sender, EventArgs e)
{
Application.Exit();
}
private void buttonX_Show_All_Records_Click(object sender, EventArgs e)
{
Display_DataBase();
}
private void buttonX_Save_Click(object sender, EventArgs e)
{
Save_Data();
}
private void Save_Data()
{
//throw new NotImplementedException();
Display_DataBase();
Boolean code_tekraari_ast = false;
if (textBoxX_Student_Code.Text == "")
{
msg_code_elzaamist();
return;
}
else
{
code_tekraari_ast = Set_Var_code_tekraari_ast(code_tekraari_ast);
if (code_tekraari_ast == false)
{
Save_Data_Part_1();
}
else
{
msg_code_tekraari_ast();
}
Display_DataBase();
}
}
private void msg_code_tekraari_ast()
{
MessageBox.Show(this,
"کد دانشجویی ای که وارد کرده اید، از قبل در دیتابیس موجود است." +
"\n" +
"لطفاً یک کد غیر تکراری وارد نمایید یا اینکه اگر می خواهید" +
//"\n"+
" اطلاعات یک دانشجو را بر اساس کد دانشجویی اش پیدا کنید،" +
"از دکمه ی جستجوی اطلاعات استفاده نمایید."
,
"کد تکراری است",
MessageBoxButtons.OK,
//MessageBoxDefaultButton
MessageBoxIcon.Warning,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.RtlReading | MessageBoxOptions.RightAlign
);
}
private bool Set_Var_code_tekraari_ast(Boolean code_tekraari_ast)
{
for (int i = 0; i < dataGridViewX_Students.Rows.Count; i++)
{
if (dataGridViewX_Students.Rows[i].Cells[0].Value != null)
{
if (dataGridViewX_Students.Rows[i].Cells[0].Value.ToString() == textBoxX_Student_Code.Text)
{
code_tekraari_ast = true;
break;
}
}
}
return code_tekraari_ast;
}
private void msg_code_elzaamist()
{
MessageBox.Show(this,
"وارد کردن کد دانشجویی الزامی است." + "\n" + "لطفاً کد دانشجویی را وارد کنید.",
"فیلد الزامی",
MessageBoxButtons.OK,
//MessageBoxDefaultButton
MessageBoxIcon.Warning,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.RtlReading
);
}
private void Save_Data_Part_1()
{
set_command_insert();
connection_1.Open();
command_1.ExecuteNonQuery();
msg_saving_was_successful();
// empty_values();
connection_1.Close();
}
private void set_command_insert()
{
command_1.Parameters.Clear();
command_1.Connection = connection_1;
command_1.CommandText = "insert into " + Table_Name +
"(Student_Code, [First Name], [Last Name], Average, Maghta_, Reshte)" +
"values(@a,@b,@c,@d,@e,@f)";
command_Parameters_AddWithValue();
}
private void command_Parameters_AddWithValue()
{
command_1.Parameters.AddWithValue("@a", textBoxX_Student_Code.Text);
command_1.Parameters.AddWithValue("@b", textBoxX_Student_FName.Text);
command_1.Parameters.AddWithValue("@c", textBoxX_Student_LName.Text);
command_1.Parameters.AddWithValue("@d", textBoxX_Student_Average.Text);
command_1.Parameters.AddWithValue("@e", comboBoxEx_Maghta_.Text);
command_1.Parameters.AddWithValue("@f", comboBoxEx_Reshte.Text);
}
private void msg_saving_was_successful()
{
MessageBox.Show(this,
"عملیات ذخیره ی اطلاعات ، با موفقیت انجام شد.",
"موفقیت در ذخیره",
MessageBoxButtons.OK,
//MessageBoxDefaultButton
MessageBoxIcon.Warning,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.RtlReading
);
}
private void empty_TextBoxes()
{
textBoxX_Student_Code.Text = "";
textBoxX_Student_FName.Text = "";
textBoxX_Student_LName.Text = "";
textBoxX_Student_Average.Text = "";
comboBoxEx_Maghta_.Text = "";
comboBoxEx_Reshte.Text = "";
}
private void buttonX_Edit_Click(object sender, EventArgs e)
{
Edit_Data();
}
private void Edit_Data()
{
Display_DataBase();
set_command_update();
connection_1.Open();
command_1.ExecuteNonQuery();
msg_editing_was_successful();
connection_1.Close();
Display_DataBase();
}
private void set_command_update()
{
command_1.Parameters.Clear();
command_1.Connection = connection_1;
// command_1.CommandText = "";
command_1.CommandText = " update " + Table_Name + " set " +
" [First Name]=@b , " +
"[Last Name]=@c , " +
" Average=@d , " +
"Maghta_=@e , " +
"Reshte=@f " +
// ""+, [First Name], [Last Name], Average, Maghta_, Reshte)" +
" where Student_Code = @a ";
/*
////command_1.CommandText = "insert into " + Table_Name +
//// "(Student_Code, [First Name], [Last Name], Average, Maghta_, Reshte)" +
//// "values(@a,@b,@c,@d,@e,@f)";
*/
command_Parameters_AddWithValue();
}
private void set_command_Search()
{
}
private void msg_editing_was_successful()
{
MessageBox.Show(this,
"عملیات ویرایش اطلاعات ، با موفقیت انجام شد.",
"موفقیت در ویرایش",
MessageBoxButtons.OK,
//MessageBoxDefaultButton
MessageBoxIcon.Warning,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.RtlReading
);
}
private void buttonX_Empty_Fields_Click(object sender, EventArgs e)
{
empty_TextBoxes();
}
private void dataGridViewX_Students_Click(object sender, EventArgs e)
{
if (dataGridViewX_Students.SelectedCells.Count == 0)
{
}
else if (dataGridViewX_Students.SelectedCells.Count == 1)
{
selected_row_index = dataGridViewX_Students.SelectedCells[0].RowIndex;
selected_column_index = dataGridViewX_Students.SelectedCells[0].ColumnIndex;
Fill_txts_and_combos_with_dgv_values();
}
else if (dataGridViewX_Students.SelectedCells.Count > 1)
{
selected_row_index = dataGridViewX_Students.SelectedRows[0].Index;
//selected_column_index = dataGridViewX_Students.SelectedColumns[0].Index;
Fill_txts_and_combos_with_dgv_values();
}
}
private void Fill_txts_and_combos_with_dgv_values()
{
textBoxX_Student_Code.Text = dataGridViewX_Students.Rows[selected_row_index].Cells[0].Value.ToString();
textBoxX_Student_FName.Text = dataGridViewX_Students.Rows[selected_row_index].Cells[1].Value.ToString();
textBoxX_Student_LName.Text = dataGridViewX_Students.Rows[selected_row_index].Cells[2].Value.ToString();
textBoxX_Student_Average.Text = dataGridViewX_Students.Rows[selected_row_index].Cells[3].Value.ToString();
comboBoxEx_Maghta_.Text = dataGridViewX_Students.Rows[selected_row_index].Cells[4].Value.ToString();
comboBoxEx_Reshte.Text = dataGridViewX_Students.Rows[selected_row_index].Cells[5].Value.ToString();
if (textBoxX_Student_Code.Text != "")
{
Selected_Student_Code = int.Parse(textBoxX_Student_Code.Text);
}
else
{
Selected_Student_Code = -2;
}
}
private void buttonX_Delete_Click(object sender, EventArgs e)
{
Delete_record();
}
private void Delete_record()
{
Display_DataBase();
if (
textBoxX_Student_Code.Text == "" &&
textBoxX_Student_FName.Text == "" &&
textBoxX_Student_LName.Text == "" &&
textBoxX_Student_Average.Text == "" &&
comboBoxEx_Maghta_.Text == "" &&
comboBoxEx_Reshte.Text == "" &&
dataGridViewX_Students.Rows.Count == 1
)
{
msg_nothing_to_delete();
}
else if (
textBoxX_Student_Code.Text == "" &&
textBoxX_Student_FName.Text == "" &&
textBoxX_Student_LName.Text == "" &&
textBoxX_Student_Average.Text == "" &&
comboBoxEx_Maghta_.Text == "" &&
comboBoxEx_Reshte.Text == "" &&
dataGridViewX_Students.Rows.Count > 1
)
{
msg_nothing_is_selected();
}
else
{
//Selected_Student_Code = (int)(dataGridViewX_Students.SelectedCells[0].Value);
set_command_delete();
connection_1.Open();
command_1.ExecuteNonQuery();
msg_deleting_was_successful();
connection_1.Close();
}
Display_DataBase();
}
private void msg_nothing_is_selected()
{
//throw new NotImplementedException();
MessageBox.Show(this,
"هیچ رکوردی انتخاب نشده است؛" +
"\n" +
"لطفاً برای ادامه، یک رکورد را انتخاب نمایید.",
"چیزی انتخاب نشده.",
MessageBoxButtons.OK,
//MessageBoxDefaultButton
MessageBoxIcon.Warning,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.RtlReading
);
}
private void msg_nothing_to_delete()
{
//throw new NotImplementedException();
MessageBox.Show(this,
"چیزی در جدول برای حذف کردن وجود ندارد.",
"جدول خالی است.",
MessageBoxButtons.OK,
//MessageBoxDefaultButton
MessageBoxIcon.Warning,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.RtlReading
);
}
private void msg_deleting_was_successful()
{
MessageBox.Show(this,
"عملیات حذف اطلاعات ، با موفقیت انجام شد.",
"موفقیت در حذف رکورد",
MessageBoxButtons.OK,
//MessageBoxDefaultButton
MessageBoxIcon.Warning,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.RtlReading
);
}
private void set_command_delete()
{
command_1.Parameters.Clear();
command_1.Connection = connection_1;
command_1.CommandText = " delete from " + Table_Name +
" where Student_Code = @code_to_delete_record ";
command_1.Parameters.AddWithValue("@code_to_delete_record", Selected_Student_Code);
}
private void dataGridViewX_Students_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
private void textBoxX_Student_FName_TextChanged(object sender, EventArgs e)
{
Search_method_2();
}
private void Search_method_2()
{
works_before_search_query();
if (
Search_Mode &&
checkBox_Student_FName.Checked &&
!checkBox_Student_Code.Checked &&
!checkBox_Student_LName.Checked &&
!checkBox_Student_Average.Checked &&
!checkBox_Maghta_.Checked &&
!checkBox_Reshte.Checked
)
{
where_clause = where_clause_first_name;
}
if (
Search_Mode &&
!checkBox_Student_Code.Checked &&
!checkBox_Student_FName.Checked &&
checkBox_Student_LName.Checked &&
!checkBox_Student_Average.Checked &&
!checkBox_Maghta_.Checked &&
!checkBox_Reshte.Checked
)
{
where_clause = where_clause_last_name;
}
else if (
Search_Mode &&
checkBox_Student_Code.Checked &&
!checkBox_Student_FName.Checked &&
!checkBox_Student_LName.Checked &&
!checkBox_Student_Average.Checked &&
!checkBox_Maghta_.Checked &&
!checkBox_Reshte.Checked
)
{
where_clause = where_clause_student_code;
}
else if (
Search_Mode &&
checkBox_Student_Code.Checked &&
checkBox_Student_FName.Checked &&
!checkBox_Student_LName.Checked &&
!checkBox_Student_Average.Checked &&
!checkBox_Maghta_.Checked &&
!checkBox_Reshte.Checked
)
{
where_clause = where_clause_student_code + " AND " + where_clause_first_name;
}
else if (
Search_Mode &&
!checkBox_Student_Code.Checked &&
!checkBox_Student_FName.Checked &&
!checkBox_Student_LName.Checked &&
checkBox_Student_Average.Checked &&
!checkBox_Maghta_.Checked &&
!checkBox_Reshte.Checked
)
{
if (where_clause_average == "")
{
where_clause = " Average = 20";
}
else
{
where_clause = where_clause_average;
}
}
else if (
Search_Mode &&
!checkBox_Student_Code.Checked &&
!checkBox_Student_FName.Checked &&
!checkBox_Student_LName.Checked &&
!checkBox_Student_Average.Checked &&
checkBox_Maghta_.Checked &&
!checkBox_Reshte.Checked
)
{
if (where_clause_Maghta_.Trim() == "")
{
where_clause = " Maghta_ Like N'%کار%'";
}
else
{
where_clause = where_clause_Maghta_;
}
}
else if (
Search_Mode &&
!checkBox_Student_Code.Checked &&
!checkBox_Student_FName.Checked &&
!checkBox_Student_LName.Checked &&
!checkBox_Student_Average.Checked &&
!checkBox_Maghta_.Checked &&
checkBox_Reshte.Checked
)
{
if (where_clause_Reshte.Trim() == "")
{
where_clause = " [Reshte] Like N'%برق%'";
}
else
{
where_clause = where_clause_Reshte;
}
}
works_after_search_query();
}
private void calc_average_clause()
{
float Average_1, Average_2;
string str1 = "", str2 = "", str3 = "";
str1 = textBoxX_Student_Average.Text;
str1 = str1.Trim();
string operator_1 = "", operator_2 = "";
if (
str1.Contains("AND") ||
str1.Contains("and") ||
str1.Contains("OR") ||
str1.Contains("or")
)
{
for (int i = 0; i < str1.Length; i++)
{
str2 += str1.Substring(i, 1);
}
}
else
{
if (str1.Contains(">="))
{
str1 = str1.Substring(2);
operator_1 = ">=";
if (str1 != "" && str1.Length > 2)
{
Average_1 = float.Parse(str1);
where_clause_average = " [Average] " + operator_1 + Average_1;
}
}
else if (str1.Contains("<="))
{
str1 = str1.Substring(2);
operator_1 = "<=";
if (str1 != "" && str1.Length > 2)
{
Average_1 = float.Parse(str1);
where_clause_average = " [Average] " + operator_1 + Average_1;
}
}
}
}
private void works_before_search_query()
{
dataset_etc(out obj_DataSet, out obj_SqlDataAdapter);
obj_SqlDataAdapter.SelectCommand.CommandText = " select * from " + Table_Name;
set_where_clauses();
}
private void works_after_search_query()
{
if (
Search_Mode &&
(
checkBox_Student_Code.Checked ||
checkBox_Student_FName.Checked ||
checkBox_Student_LName.Checked ||
checkBox_Student_Average.Checked ||
checkBox_Maghta_.Checked ||
checkBox_Reshte.Checked
)
)
{
obj_SqlDataAdapter.SelectCommand.CommandText +=
" where " + where_clause;
data_fill_etc();
set_DGV();
}
}
private void set_where_clauses()
{
where_clause_student_code = " [Student_Code] like ";
where_clause_student_code +=
"N'%" + textBoxX_Student_Code.Text + "%'";
where_clause_first_name = " [First Name] like ";
where_clause_first_name += "N'%" + textBoxX_Student_FName.Text + "%'";
where_clause_last_name = " [Last Name] like ";
where_clause_last_name += "N'%" + textBoxX_Student_LName.Text + "%'";
calc_average_clause();
where_clause_Maghta_ = " [Maghta_] like ";
where_clause_Maghta_ += "N'%" + comboBoxEx_Maghta_.Text + "%'";
where_clause_Reshte = " [Reshte] like ";
where_clause_Reshte += "N'%" + comboBoxEx_Reshte.Text + "%'";
}
private void set_DGV()
{
Set_HeaderTexts();
Set_columns_width();
dataGridViewX_Students.Rows[0].Height = 50;
auto_resize();
auto_resize_loops();
}
private void data_fill_etc()
{
if (obj_SqlDataAdapter != null)
{
try
{
obj_SqlDataAdapter.Fill(obj_DataSet, Table_Name);
dataGridViewX_Students.DataSource = obj_DataSet;
dataGridViewX_Students.DataMember = Table_Name;
}
catch (Exception xcp)
{
//throw;
msg_Error_on_Filling_Dataset(xcp);
}
}
}
private void msg_Error_on_Filling_Dataset(Exception xcp)
{
MessageBox.Show(this,
"مشکلی در پرکردن dataset به وجود آمده است." +
"\n"
+ xcp.Message + "\n\n" + xcp.ToString()
,
"مشکل در پر کردن dataset",
MessageBoxButtons.OK,
//MessageBoxDefaultButton
MessageBoxIcon.Error,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.RtlReading | MessageBoxOptions.RightAlign
);
}
private void dataset_etc(out DataSet obj_DataSet, out SqlDataAdapter obj_SqlDataAdapter)
{
obj_DataSet = new DataSet();
obj_SqlDataAdapter = new SqlDataAdapter();
obj_SqlDataAdapter.SelectCommand = new SqlCommand();
obj_SqlDataAdapter.SelectCommand.Connection = connection_1;
command_1.Connection = connection_1;
}
private void command_Parameters_AddWithValue_2()
{
//throw new NotImplementedException();
command_1.Parameters.AddWithValue("@a", textBoxX_Student_Code.Text + "%");
command_1.Parameters.AddWithValue("@b", textBoxX_Student_FName.Text + "%");
command_1.Parameters.AddWithValue("@c", textBoxX_Student_LName.Text + "%");
command_1.Parameters.AddWithValue("@d", textBoxX_Student_Average.Text + "%");
command_1.Parameters.AddWithValue("@e", comboBoxEx_Maghta_.Text + "%");
command_1.Parameters.AddWithValue("@f", comboBoxEx_Reshte.Text + "%");
}
private void textBoxX_Student_Code_TextChanged(object sender, EventArgs e)
{
Search_method_2();
}
private void textBoxX_Student_LName_Click(object sender, EventArgs e)
{
}
private void textBoxX_Student_Average_Click(object sender, EventArgs e)
{
if (Search_Mode && before_first_click_on_average_field)
{
textBoxX_Student_Average.Text = " >= 17.2 ";
textBoxX_Student_Average.RightToLeft = RightToLeft.No;
Search_method_2();
before_first_click_on_average_field = false;
}
}
private void textBoxX_Student_Average_TextChanged(object sender, EventArgs e)
{
Search_method_2();
}
private void checkBox_Student_Code_CheckedChanged(object sender, EventArgs e)
{
Search_method_2();
}
private void checkBox_Student_FName_CheckedChanged(object sender, EventArgs e)
{
Search_method_2();
}
private void checkBox_Student_LName_CheckedChanged(object sender, EventArgs e)
{
Search_method_2();
}
private void checkBox_Student_Average_CheckedChanged(object sender, EventArgs e)
{
Search_method_2();
}
private void checkBox_Maghta__CheckedChanged(object sender, EventArgs e)
{
if (comboBoxEx_Maghta_.Text != "")
{
Search_method_2();
}
}
private void checkBox_Reshte_CheckedChanged(object sender, EventArgs e)
{
if (comboBoxEx_Reshte.Text != "")
{
Search_method_2();
}
}
private void textBoxX_Student_LName_TextChanged(object sender, EventArgs e)
{
Search_method_2();
}
private void comboBoxEx_Maghta__SelectedIndexChanged(object sender, EventArgs e)
{
Search_method_2();
}
private void comboBoxEx_Maghta__TextChanged(object sender, EventArgs e)
{
Search_method_2();
}
private void comboBoxEx_Reshte_SelectedIndexChanged(object sender, EventArgs e)
{
Search_method_2();
}
private void comboBoxEx_Reshte_TextChanged(object sender, EventArgs e)
{
Search_method_2();
}
}
}
/////////////////////////////////////////////////////
namespace Test_DB_Prj_01
{
partial class Form1
{
/// <summary>
/// Required designer variable.
/// </summary>
private System.ComponentModel.IContainer components = null;
/// <summary>
/// Clean up any resources being used.
/// </summary>
/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}
#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
this.button_Go_To_Form2 = new System.Windows.Forms.Button();
this.groupPanel1 = new DevComponents.DotNetBar.Controls.GroupPanel();
this.groupPanel4 = new DevComponents.DotNetBar.Controls.GroupPanel();
this.dataGridViewX_Students = new DevComponents.DotNetBar.Controls.DataGridViewX();
this.groupPanel3 = new DevComponents.DotNetBar.Controls.GroupPanel();
this.buttonX_Exit = new DevComponents.DotNetBar.ButtonX();
this.buttonX_Search = new DevComponents.DotNetBar.ButtonX();
this.buttonX_Delete = new DevComponents.DotNetBar.ButtonX();
this.buttonX_Edit = new DevComponents.DotNetBar.ButtonX();
this.buttonX_Show_All_Records = new DevComponents.DotNetBar.ButtonX();
this.buttonX_Save = new DevComponents.DotNetBar.ButtonX();
this.groupPanel2 = new DevComponents.DotNetBar.Controls.GroupPanel();
this.checkBox_Reshte = new System.Windows.Forms.CheckBox();
this.checkBox_Maghta_ = new System.Windows.Forms.CheckBox();
this.checkBox_Student_Average = new System.Windows.Forms.CheckBox();
this.checkBox_Student_LName = new System.Windows.Forms.CheckBox();
this.checkBox_Student_FName = new System.Windows.Forms.CheckBox();
this.checkBox_Student_Code = new System.Windows.Forms.CheckBox();
this.buttonX_Empty_Fields = new DevComponents.DotNetBar.ButtonX();
this.comboBoxEx_Reshte = new DevComponents.DotNetBar.Controls.ComboBoxEx();
this.comboItem_Bargh_Ghodrat = new DevComponents.Editors.ComboItem();
this.comboItem_Computer_Software = new DevComponents.Editors.ComboItem();
this.comboItem_Mechanic_Manufacturing = new DevComponents.Editors.ComboItem();
this.comboItem_M_Tabii = new DevComponents.Editors.ComboItem();
this.comboBoxEx_Maghta_ = new DevComponents.DotNetBar.Controls.ComboBoxEx();
this.comboItem_KaarDaani = new DevComponents.Editors.ComboItem();
this.comboItem_KaarShenaasi = new DevComponents.Editors.ComboItem();
this.comboItem_KaarShenaasiye_Arshad = new DevComponents.Editors.ComboItem();
this.comboItem_Doktoraa = new DevComponents.Editors.ComboItem();
this.labelX4 = new DevComponents.DotNetBar.LabelX();
this.textBoxX_Student_Average = new DevComponents.DotNetBar.Controls.TextBoxX();
this.labelX3 = new DevComponents.DotNetBar.LabelX();
this.textBoxX_Student_LName = new DevComponents.DotNetBar.Controls.TextBoxX();
this.labelX2 = new DevComponents.DotNetBar.LabelX();
this.textBoxX_Student_FName = new DevComponents.DotNetBar.Controls.TextBoxX();
this.labelX6 = new DevComponents.DotNetBar.LabelX();
this.labelX5 = new DevComponents.DotNetBar.LabelX();
this.labelX1 = new DevComponents.DotNetBar.LabelX();
this.textBoxX_Student_Code = new DevComponents.DotNetBar.Controls.TextBoxX();
this.button_Maximize_DGV = new System.Windows.Forms.Button();
this.groupPanel1.SuspendLayout();
this.groupPanel4.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGridViewX_Students)).BeginInit();
this.groupPanel3.SuspendLayout();
this.groupPanel2.SuspendLayout();
this.SuspendLayout();
//
// button_Go_To_Form2
//
this.button_Go_To_Form2.Location = new System.Drawing.Point(28, 31);
this.button_Go_To_Form2.Margin = new System.Windows.Forms.Padding(3, 4, 3, 4);
this.button_Go_To_Form2.Name = "button_Go_To_Form2";
this.button_Go_To_Form2.Size = new System.Drawing.Size(94, 36);
this.button_Go_To_Form2.TabIndex = 0;
this.button_Go_To_Form2.Text = "Go To Form2";
this.button_Go_To_Form2.UseVisualStyleBackColor = true;
this.button_Go_To_Form2.Click += new System.EventHandler(this.button1_Click);
//
// groupPanel1
//
this.groupPanel1.BackColor = System.Drawing.Color.Transparent;
this.groupPanel1.CanvasColor = System.Drawing.SystemColors.Control;
this.groupPanel1.ColorSchemeStyle = DevComponents.DotNetBar.eDotNetBarStyle.Office2007;
this.groupPanel1.ColorTable = DevComponents.DotNetBar.Controls.ePanelColorTable.Yellow;
this.groupPanel1.Controls.Add(this.button_Maximize_DGV);
this.groupPanel1.Controls.Add(this.groupPanel4);
this.groupPanel1.Controls.Add(this.groupPanel3);
this.groupPanel1.Controls.Add(this.groupPanel2);
this.groupPanel1.Controls.Add(this.button_Go_To_Form2);
this.groupPanel1.DisabledBackColor = System.Drawing.Color.Empty;
this.groupPanel1.Dock = System.Windows.Forms.DockStyle.Fill;
this.groupPanel1.Location = new System.Drawing.Point(0, 0);
this.groupPanel1.Name = "groupPanel1";
this.groupPanel1.Size = new System.Drawing.Size(823, 525);
//
//
//
this.groupPanel1.Style.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(243)))), ((int)(((byte)(178)))));
this.groupPanel1.Style.BackColor2 = System.Drawing.Color.FromArgb(((int)(((byte)(250)))), ((int)(((byte)(217)))), ((int)(((byte)(69)))));
this.groupPanel1.Style.BackColorGradientAngle = 90;
this.groupPanel1.Style.BorderBottom = DevComponents.DotNetBar.eStyleBorderType.Solid;
this.groupPanel1.Style.BorderBottomWidth = 1;
this.groupPanel1.Style.BorderColor = System.Drawing.Color.FromArgb(((int)(((byte)(238)))), ((int)(((byte)(147)))), ((int)(((byte)(17)))));
this.groupPanel1.Style.BorderLeft = DevComponents.DotNetBar.eStyleBorderType.Solid;
this.groupPanel1.Style.BorderLeftWidth = 1;
this.groupPanel1.Style.BorderRight = DevComponents.DotNetBar.eStyleBorderType.Solid;
this.groupPanel1.Style.BorderRightWidth = 1;
this.groupPanel1.Style.BorderTop = DevComponents.DotNetBar.eStyleBorderType.Solid;
this.groupPanel1.Style.BorderTopWidth = 1;
this.groupPanel1.Style.CornerDiameter = 4;
this.groupPanel1.Style.CornerType = DevComponents.DotNetBar.eCornerType.Rounded;
this.groupPanel1.Style.TextAlignment = DevComponents.DotNetBar.eStyleTextAlignment.Center;
this.groupPanel1.Style.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(63)))), ((int)(((byte)(63)))), ((int)(((byte)(0)))));
this.groupPanel1.Style.TextLineAlignment = DevComponents.DotNetBar.eStyleTextAlignment.Near;
//
//
//
this.groupPanel1.StyleMouseDown.CornerType = DevComponents.DotNetBar.eCornerType.Square;
//
//
//
this.groupPanel1.StyleMouseOver.CornerType = DevComponents.DotNetBar.eCornerType.Square;
this.groupPanel1.TabIndex = 0;
this.groupPanel1.Click += new System.EventHandler(this.groupPanel1_Click);
//
// groupPanel4
//
this.groupPanel4.BackColor = System.Drawing.Color.Transparent;
this.groupPanel4.CanvasColor = System.Drawing.SystemColors.Control;
this.groupPanel4.ColorSchemeStyle = DevComponents.DotNetBar.eDotNetBarStyle.Office2007;
this.groupPanel4.ColorTable = DevComponents.DotNetBar.Controls.ePanelColorTable.Magenta;
this.groupPanel4.Controls.Add(this.dataGridViewX_Students);
this.groupPanel4.DisabledBackColor = System.Drawing.Color.Empty;
this.groupPanel4.Location = new System.Drawing.Point(28, 265);
this.groupPanel4.Name = "groupPanel4";
this.groupPanel4.Size = new System.Drawing.Size(786, 226);
//
//
//
this.groupPanel4.Style.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(239)))), ((int)(((byte)(145)))), ((int)(((byte)(180)))));
this.groupPanel4.Style.BackColor2 = System.Drawing.Color.FromArgb(((int)(((byte)(230)))), ((int)(((byte)(104)))), ((int)(((byte)(150)))));
this.groupPanel4.Style.BackColorGradientAngle = 90;
this.groupPanel4.Style.BorderBottom = DevComponents.DotNetBar.eStyleBorderType.Solid;
this.groupPanel4.Style.BorderBottomWidth = 1;
this.groupPanel4.Style.BorderColor = System.Drawing.Color.FromArgb(((int)(((byte)(177)))), ((int)(((byte)(39)))), ((int)(((byte)(83)))));
this.groupPanel4.Style.BorderLeft = DevComponents.DotNetBar.eStyleBorderType.Solid;
this.groupPanel4.Style.BorderLeftWidth = 1;
this.groupPanel4.Style.BorderRight = DevComponents.DotNetBar.eStyleBorderType.Solid;
this.groupPanel4.Style.BorderRightWidth = 1;
this.groupPanel4.Style.BorderTop = DevComponents.DotNetBar.eStyleBorderType.Solid;
this.groupPanel4.Style.BorderTopWidth = 1;
this.groupPanel4.Style.CornerDiameter = 4;
this.groupPanel4.Style.CornerType = DevComponents.DotNetBar.eCornerType.Rounded;
this.groupPanel4.Style.TextAlignment = DevComponents.DotNetBar.eStyleTextAlignment.Center;
this.groupPanel4.Style.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(142)))), ((int)(((byte)(38)))), ((int)(((byte)(72)))));
this.groupPanel4.Style.TextLineAlignment = DevComponents.DotNetBar.eStyleTextAlignment.Near;
//
//
//
this.groupPanel4.StyleMouseDown.CornerType = DevComponents.DotNetBar.eCornerType.Square;
//
//
//
this.groupPanel4.StyleMouseOver.CornerType = DevComponents.DotNetBar.eCornerType.Square;
this.groupPanel4.TabIndex = 1;
//
// dataGridViewX_Students
//
this.dataGridViewX_Students.BackgroundColor = System.Drawing.Color.DodgerBlue;
this.dataGridViewX_Students.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
dataGridViewCellStyle1.BackColor = System.Drawing.SystemColors.Window;
dataGridViewCellStyle1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(178)));
dataGridViewCellStyle1.ForeColor = System.Drawing.Color.Black;
dataGridViewCellStyle1.SelectionBackColor = System.Drawing.SystemColors.Highlight;
dataGridViewCellStyle1.SelectionForeColor = System.Drawing.Color.Black;
dataGridViewCellStyle1.WrapMode = System.Windows.Forms.DataGridViewTriState.False;
this.dataGridViewX_Students.DefaultCellStyle = dataGridViewCellStyle1;
this.dataGridViewX_Students.GridColor = System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(215)))), ((int)(((byte)(229)))));
this.dataGridViewX_Students.Location = new System.Drawing.Point(14, 13);
this.dataGridViewX_Students.Name = "dataGridViewX_Students";
this.dataGridViewX_Students.Size = new System.Drawing.Size(753, 191);
this.dataGridViewX_Students.TabIndex = 0;
this.dataGridViewX_Students.CellContentClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dataGridViewX_Students_CellContentClick);
this.dataGridViewX_Students.Click += new System.EventHandler(this.dataGridViewX_Students_Click);
//
// groupPanel3
//
this.groupPanel3.BackColor = System.Drawing.Color.Transparent;
this.groupPanel3.CanvasColor = System.Drawing.SystemColors.Control;
this.groupPanel3.ColorSchemeStyle = DevComponents.DotNetBar.eDotNetBarStyle.Office2007;
this.groupPanel3.ColorTable = DevComponents.DotNetBar.Controls.ePanelColorTable.Orange;
this.groupPanel3.Controls.Add(this.buttonX_Exit);
this.groupPanel3.Controls.Add(this.buttonX_Search);
this.groupPanel3.Controls.Add(this.buttonX_Delete);
this.groupPanel3.Controls.Add(this.buttonX_Edit);
this.groupPanel3.Controls.Add(this.buttonX_Show_All_Records);
this.groupPanel3.Controls.Add(this.buttonX_Save);
this.groupPanel3.DisabledBackColor = System.Drawing.Color.Empty;
this.groupPanel3.Location = new System.Drawing.Point(28, 190);
this.groupPanel3.Name = "groupPanel3";
this.groupPanel3.Size = new System.Drawing.Size(786, 69);
//
//
//
this.groupPanel3.Style.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(250)))), ((int)(((byte)(192)))), ((int)(((byte)(143)))));
this.groupPanel3.Style.BackColor2 = System.Drawing.Color.FromArgb(((int)(((byte)(247)))), ((int)(((byte)(150)))), ((int)(((byte)(70)))));
this.groupPanel3.Style.BackColorGradientAngle = 90;
this.groupPanel3.Style.BorderBottom = DevComponents.DotNetBar.eStyleBorderType.Solid;
this.groupPanel3.Style.BorderBottomWidth = 1;
this.groupPanel3.Style.BorderColor = System.Drawing.Color.FromArgb(((int)(((byte)(151)))), ((int)(((byte)(72)))), ((int)(((byte)(6)))));
this.groupPanel3.Style.BorderLeft = DevComponents.DotNetBar.eStyleBorderType.Solid;
this.groupPanel3.Style.BorderLeftWidth = 1;
this.groupPanel3.Style.BorderRight = DevComponents.DotNetBar.eStyleBorderType.Solid;
this.groupPanel3.Style.BorderRightWidth = 1;
this.groupPanel3.Style.BorderTop = DevComponents.DotNetBar.eStyleBorderType.Solid;
this.groupPanel3.Style.BorderTopWidth = 1;
this.groupPanel3.Style.CornerDiameter = 4;
this.groupPanel3.Style.CornerType = DevComponents.DotNetBar.eCornerType.Rounded;
this.groupPanel3.Style.TextAlignment = DevComponents.DotNetBar.eStyleTextAlignment.Center;
this.groupPanel3.Style.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(127)))), ((int)(((byte)(61)))), ((int)(((byte)(6)))));
this.groupPanel3.Style.TextLineAlignment = DevComponents.DotNetBar.eStyleTextAlignment.Near;
//
//
//
this.groupPanel3.StyleMouseDown.CornerType = DevComponents.DotNetBar.eCornerType.Square;
//
//
//
this.groupPanel3.StyleMouseOver.CornerType = DevComponents.DotNetBar.eCornerType.Square;
this.groupPanel3.TabIndex = 2;
//
// buttonX_Exit
//
this.buttonX_Exit.AccessibleRole = System.Windows.Forms.AccessibleRole.PushButton;
this.buttonX_Exit.BackColor = System.Drawing.Color.Transparent;
this.buttonX_Exit.ColorTable = DevComponents.DotNetBar.eButtonColor.OrangeWithBackground;
this.buttonX_Exit.Location = new System.Drawing.Point(14, 12);
this.buttonX_Exit.Name = "buttonX_Exit";
this.buttonX_Exit.Shape = new DevComponents.DotNetBar.RoundRectangleShapeDescriptor(16, 5, 2, 5);
this.buttonX_Exit.Size = new System.Drawing.Size(117, 37);
this.buttonX_Exit.Style = DevComponents.DotNetBar.eDotNetBarStyle.StyleManagerControlled;
this.buttonX_Exit.TabIndex = 4;
this.buttonX_Exit.Text = "خروج از برنامه";
this.buttonX_Exit.Click += new System.EventHandler(this.buttonX_Exit_Click);
//
// buttonX_Search
//
this.buttonX_Search.AccessibleRole = System.Windows.Forms.AccessibleRole.PushButton;
this.buttonX_Search.BackColor = System.Drawing.Color.Transparent;
this.buttonX_Search.ColorTable = DevComponents.DotNetBar.eButtonColor.OrangeWithBackground;
this.buttonX_Search.Location = new System.Drawing.Point(137, 12);
this.buttonX_Search.Name = "buttonX_Search";
this.buttonX_Search.Shape = new DevComponents.DotNetBar.RoundRectangleShapeDescriptor(6, 0, 6, 3);
this.buttonX_Search.Size = new System.Drawing.Size(117, 37);
this.buttonX_Search.Style = DevComponents.DotNetBar.eDotNetBarStyle.StyleManagerControlled;
this.buttonX_Search.TabIndex = 3;
this.buttonX_Search.Text = "جستجوی اطلاعات";
this.buttonX_Search.Click += new System.EventHandler(this.buttonX_Search_Click);
//
// buttonX_Delete
//
this.buttonX_Delete.AccessibleRole = System.Windows.Forms.AccessibleRole.PushButton;
this.buttonX_Delete.BackColor = System.Drawing.Color.Transparent;
this.buttonX_Delete.ColorTable = DevComponents.DotNetBar.eButtonColor.OrangeWithBackground;
this.buttonX_Delete.Location = new System.Drawing.Point(260, 12);
this.buttonX_Delete.Name = "buttonX_Delete";
this.buttonX_Delete.Shape = new DevComponents.DotNetBar.RoundRectangleShapeDescriptor(0, 5, 12, 5);
this.buttonX_Delete.Size = new System.Drawing.Size(106, 37);
this.buttonX_Delete.Style = DevComponents.DotNetBar.eDotNetBarStyle.StyleManagerControlled;
this.buttonX_Delete.TabIndex = 2;
this.buttonX_Delete.Text = "حذف اطلاعات";
this.buttonX_Delete.Click += new System.EventHandler(this.buttonX_Delete_Click);
//
// buttonX_Edit
//
this.buttonX_Edit.AccessibleRole = System.Windows.Forms.AccessibleRole.PushButton;
this.buttonX_Edit.BackColor = System.Drawing.Color.Transparent;
this.buttonX_Edit.ColorTable = DevComponents.DotNetBar.eButtonColor.OrangeWithBackground;
this.buttonX_Edit.Location = new System.Drawing.Point(372, 12);
this.buttonX_Edit.Name = "buttonX_Edit";
this.buttonX_Edit.Shape = new DevComponents.DotNetBar.RoundRectangleShapeDescriptor(0, 5, 2, 5);
this.buttonX_Edit.Size = new System.Drawing.Size(106, 37);
this.buttonX_Edit.Style = DevComponents.DotNetBar.eDotNetBarStyle.StyleManagerControlled;
this.buttonX_Edit.TabIndex = 1;
this.buttonX_Edit.Text = "ویرایش اطلاعات";
this.buttonX_Edit.Click += new System.EventHandler(this.buttonX_Edit_Click);
//
// buttonX_Show_All_Records
//
this.buttonX_Show_All_Records.AccessibleRole = System.Windows.Forms.AccessibleRole.PushButton;
this.buttonX_Show_All_Records.BackColor = System.Drawing.Color.Transparent;
this.buttonX_Show_All_Records.ColorTable = DevComponents.DotNetBar.eButtonColor.OrangeWithBackground;
this.buttonX_Show_All_Records.Location = new System.Drawing.Point(596, 12);
this.buttonX_Show_All_Records.Name = "buttonX_Show_All_Records";
this.buttonX_Show_All_Records.Shape = new DevComponents.DotNetBar.RoundRectangleShapeDescriptor(13);
this.buttonX_Show_All_Records.Size = new System.Drawing.Size(139, 37);
this.buttonX_Show_All_Records.Style = DevComponents.DotNetBar.eDotNetBarStyle.StyleManagerControlled;
this.buttonX_Show_All_Records.TabIndex = 0;
this.buttonX_Show_All_Records.Text = "نمایش همه ی رکوردها";
this.buttonX_Show_All_Records.Click += new System.EventHandler(this.buttonX_Show_All_Records_Click);
//
// buttonX_Save
//
this.buttonX_Save.AccessibleRole = System.Windows.Forms.AccessibleRole.PushButton;
this.buttonX_Save.BackColor = System.Drawing.Color.Transparent;
this.buttonX_Save.ColorTable = DevComponents.DotNetBar.eButtonColor.OrangeWithBackground;
this.buttonX_Save.Location = new System.Drawing.Point(484, 12);
this.buttonX_Save.Name = "buttonX_Save";
this.buttonX_Save.Shape = new DevComponents.DotNetBar.RoundRectangleShapeDescriptor(0, 13, 2, 5);
this.buttonX_Save.Size = new System.Drawing.Size(106, 37);
this.buttonX_Save.Style = DevComponents.DotNetBar.eDotNetBarStyle.StyleManagerControlled;
this.buttonX_Save.TabIndex = 0;
this.buttonX_Save.Text = "ذخیره ی اطلاعات";
this.buttonX_Save.Click += new System.EventHandler(this.buttonX_Save_Click);
//
// groupPanel2
//
this.groupPanel2.BackColor = System.Drawing.Color.Transparent;
this.groupPanel2.CanvasColor = System.Drawing.SystemColors.Control;
this.groupPanel2.ColorSchemeStyle = DevComponents.DotNetBar.eDotNetBarStyle.Office2007;
this.groupPanel2.ColorTable = DevComponents.DotNetBar.Controls.ePanelColorTable.Green;
this.groupPanel2.Controls.Add(this.checkBox_Reshte);
this.groupPanel2.Controls.Add(this.checkBox_Maghta_);
this.groupPanel2.Controls.Add(this.checkBox_Student_Average);
this.groupPanel2.Controls.Add(this.checkBox_Student_LName);
this.groupPanel2.Controls.Add(this.checkBox_Student_FName);
this.groupPanel2.Controls.Add(this.checkBox_Student_Code);
this.groupPanel2.Controls.Add(this.buttonX_Empty_Fields);
this.groupPanel2.Controls.Add(this.comboBoxEx_Reshte);
this.groupPanel2.Controls.Add(this.comboBoxEx_Maghta_);
this.groupPanel2.Controls.Add(this.labelX4);
this.groupPanel2.Controls.Add(this.textBoxX_Student_Average);
this.groupPanel2.Controls.Add(this.labelX3);
this.groupPanel2.Controls.Add(this.textBoxX_Student_LName);
this.groupPanel2.Controls.Add(this.labelX2);
this.groupPanel2.Controls.Add(this.textBoxX_Student_FName);
this.groupPanel2.Controls.Add(this.labelX6);
this.groupPanel2.Controls.Add(this.labelX5);
this.groupPanel2.Controls.Add(this.labelX1);
this.groupPanel2.Controls.Add(this.textBoxX_Student_Code);
this.groupPanel2.DisabledBackColor = System.Drawing.Color.Empty;
this.groupPanel2.Location = new System.Drawing.Point(28, 74);
this.groupPanel2.Name = "groupPanel2";
this.groupPanel2.Size = new System.Drawing.Size(786, 110);
//
//
//
this.groupPanel2.Style.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(195)))), ((int)(((byte)(217)))), ((int)(((byte)(185)))));
this.groupPanel2.Style.BackColor2 = System.Drawing.Color.FromArgb(((int)(((byte)(156)))), ((int)(((byte)(191)))), ((int)(((byte)(139)))));
this.groupPanel2.Style.BackColorGradientAngle = 90;
this.groupPanel2.Style.BorderBottom = DevComponents.DotNetBar.eStyleBorderType.Solid;
this.groupPanel2.Style.BorderBottomWidth = 1;
this.groupPanel2.Style.BorderColor = System.Drawing.Color.FromArgb(((int)(((byte)(114)))), ((int)(((byte)(164)))), ((int)(((byte)(90)))));
this.groupPanel2.Style.BorderLeft = DevComponents.DotNetBar.eStyleBorderType.Solid;
this.groupPanel2.Style.BorderLeftWidth = 1;
this.groupPanel2.Style.BorderRight = DevComponents.DotNetBar.eStyleBorderType.Solid;
this.groupPanel2.Style.BorderRightWidth = 1;
this.groupPanel2.Style.BorderTop = DevComponents.DotNetBar.eStyleBorderType.Solid;
this.groupPanel2.Style.BorderTopWidth = 1;
this.groupPanel2.Style.CornerDiameter = 4;
this.groupPanel2.Style.CornerType = DevComponents.DotNetBar.eCornerType.Rounded;
this.groupPanel2.Style.TextAlignment = DevComponents.DotNetBar.eStyleTextAlignment.Center;
this.groupPanel2.Style.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(60)))), ((int)(((byte)(74)))), ((int)(((byte)(31)))));
this.groupPanel2.Style.TextLineAlignment = DevComponents.DotNetBar.eStyleTextAlignment.Near;
//
//
//
this.groupPanel2.StyleMouseDown.CornerType = DevComponents.DotNetBar.eCornerType.Square;
//
//
//
this.groupPanel2.StyleMouseOver.CornerType = DevComponents.DotNetBar.eCornerType.Square;
this.groupPanel2.TabIndex = 1;
//
// checkBox_Reshte
//
this.checkBox_Reshte.AutoSize = true;
this.checkBox_Reshte.Location = new System.Drawing.Point(372, 46);
this.checkBox_Reshte.Name = "checkBox_Reshte";
this.checkBox_Reshte.Size = new System.Drawing.Size(15, 14);
this.checkBox_Reshte.TabIndex = 13;
this.checkBox_Reshte.UseVisualStyleBackColor = true;
this.checkBox_Reshte.Visible = false;
this.checkBox_Reshte.CheckedChanged += new System.EventHandler(this.checkBox_Reshte_CheckedChanged);
//
// checkBox_Maghta_
//
this.checkBox_Maghta_.AutoSize = true;
this.checkBox_Maghta_.Location = new System.Drawing.Point(372, 16);
this.checkBox_Maghta_.Name = "checkBox_Maghta_";
this.checkBox_Maghta_.Size = new System.Drawing.Size(15, 14);
this.checkBox_Maghta_.TabIndex = 13;
this.checkBox_Maghta_.UseVisualStyleBackColor = true;
this.checkBox_Maghta_.Visible = false;
this.checkBox_Maghta_.CheckedChanged += new System.EventHandler(this.checkBox_Maghta__CheckedChanged);
//
// checkBox_Student_Average
//
this.checkBox_Student_Average.AutoSize = true;
this.checkBox_Student_Average.Location = new System.Drawing.Point(741, 82);
this.checkBox_Student_Average.Name = "checkBox_Student_Average";
this.checkBox_Student_Average.Size = new System.Drawing.Size(15, 14);
this.checkBox_Student_Average.TabIndex = 13;
this.checkBox_Student_Average.UseVisualStyleBackColor = true;
this.checkBox_Student_Average.Visible = false;
this.checkBox_Student_Average.CheckedChanged += new System.EventHandler(this.checkBox_Student_Average_CheckedChanged);
//
// checkBox_Student_LName
//
this.checkBox_Student_LName.AutoSize = true;
this.checkBox_Student_LName.Location = new System.Drawing.Point(741, 58);
this.checkBox_Student_LName.Name = "checkBox_Student_LName";
this.checkBox_Student_LName.Size = new System.Drawing.Size(15, 14);
this.checkBox_Student_LName.TabIndex = 13;
this.checkBox_Student_LName.UseVisualStyleBackColor = true;
this.checkBox_Student_LName.Visible = false;
this.checkBox_Student_LName.CheckedChanged += new System.EventHandler(this.checkBox_Student_LName_CheckedChanged);
//
// checkBox_Student_FName
//
this.checkBox_Student_FName.AutoSize = true;
this.checkBox_Student_FName.Location = new System.Drawing.Point(741, 34);
this.checkBox_Student_FName.Name = "checkBox_Student_FName";
this.checkBox_Student_FName.Size = new System.Drawing.Size(15, 14);
this.checkBox_Student_FName.TabIndex = 13;
this.checkBox_Student_FName.UseVisualStyleBackColor = true;
this.checkBox_Student_FName.Visible = false;
this.checkBox_Student_FName.CheckedChanged += new System.EventHandler(this.checkBox_Student_FName_CheckedChanged);
//
// checkBox_Student_Code
//
this.checkBox_Student_Code.AutoSize = true;
this.checkBox_Student_Code.Location = new System.Drawing.Point(741, 11);
this.checkBox_Student_Code.Name = "checkBox_Student_Code";
this.checkBox_Student_Code.Size = new System.Drawing.Size(15, 14);
this.checkBox_Student_Code.TabIndex = 13;
this.checkBox_Student_Code.UseVisualStyleBackColor = true;
this.checkBox_Student_Code.Visible = false;
this.checkBox_Student_Code.CheckedChanged += new System.EventHandler(this.checkBox_Student_Code_CheckedChanged);
//
// buttonX_Empty_Fields
//
this.buttonX_Empty_Fields.AccessibleRole = System.Windows.Forms.AccessibleRole.PushButton;
this.buttonX_Empty_Fields.BackColor = System.Drawing.Color.Transparent;
this.buttonX_Empty_Fields.ColorTable = DevComponents.DotNetBar.eButtonColor.OrangeWithBackground;
this.buttonX_Empty_Fields.Location = new System.Drawing.Point(68, 71);
this.buttonX_Empty_Fields.Name = "buttonX_Empty_Fields";
this.buttonX_Empty_Fields.Shape = new DevComponents.DotNetBar.RoundRectangleShapeDescriptor(13);
this.buttonX_Empty_Fields.Size = new System.Drawing.Size(180, 30);
this.buttonX_Empty_Fields.Style = DevComponents.DotNetBar.eDotNetBarStyle.StyleManagerControlled;
this.buttonX_Empty_Fields.TabIndex = 12;
this.buttonX_Empty_Fields.Text = "خالی کردن همه ی فیلدها";
this.buttonX_Empty_Fields.Click += new System.EventHandler(this.buttonX_Empty_Fields_Click);
//
// comboBoxEx_Reshte
//
this.comboBoxEx_Reshte.DisplayMember = "Text";
this.comboBoxEx_Reshte.DrawMode = System.Windows.Forms.DrawMode.OwnerDrawFixed;
this.comboBoxEx_Reshte.ForeColor = System.Drawing.Color.Black;
this.comboBoxEx_Reshte.FormattingEnabled = true;
this.comboBoxEx_Reshte.ItemHeight = 18;
this.comboBoxEx_Reshte.Items.AddRange(new object[] {
this.comboItem_Bargh_Ghodrat,
this.comboItem_Computer_Software,
this.comboItem_Mechanic_Manufacturing,
this.comboItem_M_Tabii});
this.comboBoxEx_Reshte.Location = new System.Drawing.Point(40, 41);
this.comboBoxEx_Reshte.Name = "comboBoxEx_Reshte";
this.comboBoxEx_Reshte.Size = new System.Drawing.Size(208, 24);
this.comboBoxEx_Reshte.Style = DevComponents.DotNetBar.eDotNetBarStyle.StyleManagerControlled;
this.comboBoxEx_Reshte.TabIndex = 5;
this.comboBoxEx_Reshte.SelectedIndexChanged += new System.EventHandler(this.comboBoxEx_Reshte_SelectedIndexChanged);
this.comboBoxEx_Reshte.TextChanged += new System.EventHandler(this.comboBoxEx_Reshte_TextChanged);
//
// comboItem_Bargh_Ghodrat
//
this.comboItem_Bargh_Ghodrat.Text = "برق - قدرت";
//
// comboItem_Computer_Software
//
this.comboItem_Computer_Software.Text = "کامپیوتر - نرم افزار";
//
// comboItem_Mechanic_Manufacturing
//
this.comboItem_Mechanic_Manufacturing.Text = "مکانیک - ساخت و تولید";
//
// comboItem_M_Tabii
//
this.comboItem_M_Tabii.Text = "منابع طبیعی";
//
// comboBoxEx_Maghta_
//
this.comboBoxEx_Maghta_.DisplayMember = "Text";
this.comboBoxEx_Maghta_.DrawMode = System.Windows.Forms.DrawMode.OwnerDrawFixed;
this.comboBoxEx_Maghta_.ForeColor = System.Drawing.Color.Black;
this.comboBoxEx_Maghta_.FormattingEnabled = true;
this.comboBoxEx_Maghta_.ItemHeight = 18;
this.comboBoxEx_Maghta_.Items.AddRange(new object[] {
this.comboItem_KaarDaani,
this.comboItem_KaarShenaasi,
this.comboItem_KaarShenaasiye_Arshad,
this.comboItem_Doktoraa});
this.comboBoxEx_Maghta_.Location = new System.Drawing.Point(40, 11);
this.comboBoxEx_Maghta_.Name = "comboBoxEx_Maghta_";
this.comboBoxEx_Maghta_.Size = new System.Drawing.Size(208, 24);
this.comboBoxEx_Maghta_.Style = DevComponents.DotNetBar.eDotNetBarStyle.StyleManagerControlled;
this.comboBoxEx_Maghta_.TabIndex = 4;
this.comboBoxEx_Maghta_.SelectedIndexChanged += new System.EventHandler(this.comboBoxEx_Maghta__SelectedIndexChanged);
this.comboBoxEx_Maghta_.TextChanged += new System.EventHandler(this.comboBoxEx_Maghta__TextChanged);
//
// comboItem_KaarDaani
//
this.comboItem_KaarDaani.Text = "کاردانی";
//
// comboItem_KaarShenaasi
//
this.comboItem_KaarShenaasi.Text = "کارشناسی";
//
// comboItem_KaarShenaasiye_Arshad
//
this.comboItem_KaarShenaasiye_Arshad.Text = "کارشناسی ارشد";
//
// comboItem_Doktoraa
//
this.comboItem_Doktoraa.Text = "دکترا";
//
// labelX4
//
this.labelX4.AutoSize = true;
//
//
//
this.labelX4.BackgroundStyle.CornerType = DevComponents.DotNetBar.eCornerType.Square;
this.labelX4.Location = new System.Drawing.Point(641, 79);
this.labelX4.Name = "labelX4";
this.labelX4.Size = new System.Drawing.Size(93, 18);
this.labelX4.TabIndex = 9;
this.labelX4.Text = "معدل دانشجو : ";
//
// textBoxX_Student_Average
//
this.textBoxX_Student_Average.BackColor = System.Drawing.Color.White;
//
//
//
this.textBoxX_Student_Average.Border.Class = "TextBoxBorder";
this.textBoxX_Student_Average.Border.CornerType = DevComponents.DotNetBar.eCornerType.Square;
this.textBoxX_Student_Average.DisabledBackColor = System.Drawing.Color.White;
this.textBoxX_Student_Average.ForeColor = System.Drawing.Color.Black;
this.textBoxX_Student_Average.Location = new System.Drawing.Point(417, 78);
this.textBoxX_Student_Average.Name = "textBoxX_Student_Average";
this.textBoxX_Student_Average.PreventEnterBeep = true;
this.textBoxX_Student_Average.Size = new System.Drawing.Size(183, 23);
this.textBoxX_Student_Average.TabIndex = 3;
this.textBoxX_Student_Average.Click += new System.EventHandler(this.textBoxX_Student_Average_Click);
this.textBoxX_Student_Average.TextChanged += new System.EventHandler(this.textBoxX_Student_Average_TextChanged);
//
// labelX3
//
this.labelX3.AutoSize = true;
//
//
//
this.labelX3.BackgroundStyle.CornerType = DevComponents.DotNetBar.eCornerType.Square;
this.labelX3.Location = new System.Drawing.Point(601, 55);
this.labelX3.Name = "labelX3";
this.labelX3.Size = new System.Drawing.Size(134, 18);
this.labelX3.TabIndex = 8;
this.labelX3.Text = "نام خانوادگی دانشجو : ";
//
// textBoxX_Student_LName
//
this.textBoxX_Student_LName.BackColor = System.Drawing.Color.White;
//
//
//
this.textBoxX_Student_LName.Border.Class = "TextBoxBorder";
this.textBoxX_Student_LName.Border.CornerType = DevComponents.DotNetBar.eCornerType.Square;
this.textBoxX_Student_LName.DisabledBackColor = System.Drawing.Color.White;
this.textBoxX_Student_LName.ForeColor = System.Drawing.Color.Black;
this.textBoxX_Student_LName.Location = new System.Drawing.Point(417, 54);
this.textBoxX_Student_LName.Name = "textBoxX_Student_LName";
this.textBoxX_Student_LName.PreventEnterBeep = true;
this.textBoxX_Student_LName.Size = new System.Drawing.Size(183, 23);
this.textBoxX_Student_LName.TabIndex = 2;
this.textBoxX_Student_LName.Click += new System.EventHandler(this.textBoxX_Student_LName_Click);
this.textBoxX_Student_LName.TextChanged += new System.EventHandler(this.textBoxX_Student_LName_TextChanged);
//
// labelX2
//
this.labelX2.AutoSize = true;
//
//
//
this.labelX2.BackgroundStyle.CornerType = DevComponents.DotNetBar.eCornerType.Square;
this.labelX2.Location = new System.Drawing.Point(655, 31);
this.labelX2.Name = "labelX2";
this.labelX2.Size = new System.Drawing.Size(80, 18);
this.labelX2.TabIndex = 7;
this.labelX2.Text = "نام دانشجو : ";
//
// textBoxX_Student_FName
//
this.textBoxX_Student_FName.BackColor = System.Drawing.Color.White;
//
//
//
this.textBoxX_Student_FName.Border.Class = "TextBoxBorder";
this.textBoxX_Student_FName.Border.CornerType = DevComponents.DotNetBar.eCornerType.Square;
this.textBoxX_Student_FName.DisabledBackColor = System.Drawing.Color.White;
this.textBoxX_Student_FName.ForeColor = System.Drawing.Color.Black;
this.textBoxX_Student_FName.Location = new System.Drawing.Point(417, 31);
this.textBoxX_Student_FName.Name = "textBoxX_Student_FName";
this.textBoxX_Student_FName.PreventEnterBeep = true;
this.textBoxX_Student_FName.Size = new System.Drawing.Size(183, 23);
this.textBoxX_Student_FName.TabIndex = 1;
this.textBoxX_Student_FName.TextChanged += new System.EventHandler(this.textBoxX_Student_FName_TextChanged);
//
// labelX6
//
this.labelX6.AutoSize = true;
//
//
//
this.labelX6.BackgroundStyle.CornerType = DevComponents.DotNetBar.eCornerType.Square;
this.labelX6.Location = new System.Drawing.Point(254, 42);
this.labelX6.Name = "labelX6";
this.labelX6.Size = new System.Drawing.Size(113, 18);
this.labelX6.TabIndex = 11;
this.labelX6.Text = "رشته ی تحصیلی : ";
//
// labelX5
//
this.labelX5.AutoSize = true;
//
//
//
this.labelX5.BackgroundStyle.CornerType = DevComponents.DotNetBar.eCornerType.Square;
this.labelX5.Location = new System.Drawing.Point(268, 12);
this.labelX5.Name = "labelX5";
this.labelX5.Size = new System.Drawing.Size(98, 18);
this.labelX5.TabIndex = 10;
this.labelX5.Text = "مقطع تحصیلی : ";
//
// labelX1
//
this.labelX1.AutoSize = true;
//
//
//
this.labelX1.BackgroundStyle.CornerType = DevComponents.DotNetBar.eCornerType.Square;
this.labelX1.Location = new System.Drawing.Point(641, 8);
this.labelX1.Name = "labelX1";
this.labelX1.Size = new System.Drawing.Size(94, 18);
this.labelX1.TabIndex = 6;
this.labelX1.Text = "کد دانشجویی : ";
//
// textBoxX_Student_Code
//
this.textBoxX_Student_Code.BackColor = System.Drawing.Color.White;
//
//
//
this.textBoxX_Student_Code.Border.Class = "TextBoxBorder";
this.textBoxX_Student_Code.Border.CornerType = DevComponents.DotNetBar.eCornerType.Square;
this.textBoxX_Student_Code.DisabledBackColor = System.Drawing.Color.White;
this.textBoxX_Student_Code.ForeColor = System.Drawing.Color.Black;
this.textBoxX_Student_Code.Location = new System.Drawing.Point(417, 7);
this.textBoxX_Student_Code.Name = "textBoxX_Student_Code";
this.textBoxX_Student_Code.PreventEnterBeep = true;
this.textBoxX_Student_Code.Size = new System.Drawing.Size(183, 23);
this.textBoxX_Student_Code.TabIndex = 0;
this.textBoxX_Student_Code.TextChanged += new System.EventHandler(this.textBoxX_Student_Code_TextChanged);
//
// button_Maximize_DGV
//
this.button_Maximize_DGV.Location = new System.Drawing.Point(128, 31);
this.button_Maximize_DGV.Margin = new System.Windows.Forms.Padding(3, 4, 3, 4);
this.button_Maximize_DGV.Name = "button_Maximize_DGV";
this.button_Maximize_DGV.Size = new System.Drawing.Size(118, 36);
this.button_Maximize_DGV.TabIndex = 3;
this.button_Maximize_DGV.Text = "Maximize DGV";
this.button_Maximize_DGV.UseVisualStyleBackColor = true;
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 16F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(823, 525);
this.Controls.Add(this.groupPanel1);
this.DoubleBuffered = true;
this.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(178)));
this.Margin = new System.Windows.Forms.Padding(3, 4, 3, 4);
this.Name = "Form1";
this.RightToLeft = System.Windows.Forms.RightToLeft.Yes;
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "ثبت اطلاعات دانشجویان";
this.Load += new System.EventHandler(this.Form1_Load);
this.groupPanel1.ResumeLayout(false);
this.groupPanel4.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataGridViewX_Students)).EndInit();
this.groupPanel3.ResumeLayout(false);
this.groupPanel2.ResumeLayout(false);
this.groupPanel2.PerformLayout();
this.ResumeLayout(false);
}
#endregion
private System.Windows.Forms.Button button_Go_To_Form2;
private DevComponents.DotNetBar.Controls.GroupPanel groupPanel1;
private DevComponents.DotNetBar.Controls.GroupPanel groupPanel2;
private DevComponents.DotNetBar.Controls.GroupPanel groupPanel4;
private DevComponents.DotNetBar.Controls.GroupPanel groupPanel3;
private DevComponents.DotNetBar.ButtonX buttonX_Save;
private DevComponents.DotNetBar.ButtonX buttonX_Delete;
private DevComponents.DotNetBar.ButtonX buttonX_Edit;
private DevComponents.DotNetBar.ButtonX buttonX_Search;
private DevComponents.DotNetBar.ButtonX buttonX_Exit;
private DevComponents.DotNetBar.LabelX labelX1;
private DevComponents.DotNetBar.Controls.TextBoxX textBoxX_Student_Code;
private DevComponents.DotNetBar.LabelX labelX2;
private DevComponents.DotNetBar.Controls.TextBoxX textBoxX_Student_FName;
private DevComponents.DotNetBar.LabelX labelX3;
private DevComponents.DotNetBar.Controls.TextBoxX textBoxX_Student_LName;
private DevComponents.DotNetBar.LabelX labelX4;
private DevComponents.DotNetBar.Controls.TextBoxX textBoxX_Student_Average;
private DevComponents.DotNetBar.LabelX labelX5;
private DevComponents.DotNetBar.LabelX labelX6;
private DevComponents.DotNetBar.Controls.ComboBoxEx comboBoxEx_Reshte;
private DevComponents.DotNetBar.Controls.ComboBoxEx comboBoxEx_Maghta_;
private DevComponents.DotNetBar.Controls.DataGridViewX dataGridViewX_Students;
private DevComponents.Editors.ComboItem comboItem_Bargh_Ghodrat;
private DevComponents.Editors.ComboItem comboItem_Computer_Software;
private DevComponents.Editors.ComboItem comboItem_Mechanic_Manufacturing;
private DevComponents.Editors.ComboItem comboItem_M_Tabii;
private DevComponents.Editors.ComboItem comboItem_KaarDaani;
private DevComponents.Editors.ComboItem comboItem_KaarShenaasi;
private DevComponents.Editors.ComboItem comboItem_KaarShenaasiye_Arshad;
private DevComponents.Editors.ComboItem comboItem_Doktoraa;
private DevComponents.DotNetBar.ButtonX buttonX_Show_All_Records;
private DevComponents.DotNetBar.ButtonX buttonX_Empty_Fields;
private System.Windows.Forms.CheckBox checkBox_Student_Code;
private System.Windows.Forms.CheckBox checkBox_Student_Average;
private System.Windows.Forms.CheckBox checkBox_Student_LName;
private System.Windows.Forms.CheckBox checkBox_Student_FName;
private System.Windows.Forms.CheckBox checkBox_Reshte;
private System.Windows.Forms.CheckBox checkBox_Maghta_;
private System.Windows.Forms.Button button_Maximize_DGV;
}
}
USE [Test_DB_14001122_b]
GO
/****** Object: Table [dbo].[Table_Students] Script Date: 2022-02-27 14:58:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table_Students](
[Student_Code] [int] NOT NULL,
[First Name] [nvarchar](50) NULL,
[Last Name] [nvarchar](50) NULL,
[Average] [float] NULL,
[Maghta_] [nvarchar](50) NULL,
[Reshte] [nvarchar](50) NULL,
CONSTRAINT [PK_Table_Students] PRIMARY KEY CLUSTERED
(
[Student_Code] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT [dbo].[Table_Students] ([Student_Code], [First Name], [Last Name], [Average], [Maghta_], [Reshte]) VALUES (126, N'احمد', N'شجاعی', 17.26, N'دکترا', N'برق - قدرت')
INSERT [dbo].[Table_Students] ([Student_Code], [First Name], [Last Name], [Average], [Maghta_], [Reshte]) VALUES (156, N'زهرا', N'احمدی', 12.9, N'دکترا', N'کامپیوتر - نرم افزار')
INSERT [dbo].[Table_Students] ([Student_Code], [First Name], [Last Name], [Average], [Maghta_], [Reshte]) VALUES (157, N'احمدعلی', N'مرادی', 20, N'هنرستان فنی-حرفه ای', N'اتومکانیک')
INSERT [dbo].[Table_Students] ([Student_Code], [First Name], [Last Name], [Average], [Maghta_], [Reshte]) VALUES (159, N'احمد', N'مرادی', 20, N'هنرستان فنی-حرفه ای', N'اتومکانیک')
INSERT [dbo].[Table_Students] ([Student_Code], [First Name], [Last Name], [Average], [Maghta_], [Reshte]) VALUES (987, N'mohammad', N'ahmadi', 19.6, N'دکترا', N'برق - قدرت')
INSERT [dbo].[Table_Students] ([Student_Code], [First Name], [Last Name], [Average], [Maghta_], [Reshte]) VALUES (7531, N'هود', N'شجاعی', 17.26, N'دکترا', N'برق - قدرت')
INSERT [dbo].[Table_Students] ([Student_Code], [First Name], [Last Name], [Average], [Maghta_], [Reshte]) VALUES (12357, N'محمد', N'احمدی', 15.99, N'کاردانی', N'مکانیک - ساخت و تولید')
INSERT [dbo].[Table_Students] ([Student_Code], [First Name], [Last Name], [Average], [Maghta_], [Reshte]) VALUES (654123, N'عرفان', N'احمدی', 17.26, N'کارشناسی ارشد', N'فیزیک اپتیک')
INSERT [dbo].[Table_Students] ([Student_Code], [First Name], [Last Name], [Average], [Maghta_], [Reshte]) VALUES (732654, N'محمود', N'mahdavi', 6.25, N'دبیرستان', N'تجربی')
INSERT [dbo].[Table_Students] ([Student_Code], [First Name], [Last Name], [Average], [Maghta_], [Reshte]) VALUES (684123954, N'فرهاد', N'مرادی', 16.89, N'کارشناسی', N'جامعه شناسی')
GO
USE [master]
GO
/****** Object: Database [Test_DB_14001122_b] Script Date: 2022-02-27 14:54:40 ******/
CREATE DATABASE [Test_DB_14001122_b] ON PRIMARY
( NAME = N'Test_DB_14001122_b', FILENAME = N'C:\SQL DBs\a\a\Test_DB_14001122_b.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'Test_DB_14001122_b_log', FILENAME = N'C:\SQL DBs\a\a\Test_DB_14001122_b_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [Test_DB_14001122_b] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Test_DB_14001122_b].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [Test_DB_14001122_b] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [Test_DB_14001122_b] SET ANSI_NULLS OFF
GO
ALTER DATABASE [Test_DB_14001122_b] SET ANSI_PADDING OFF
GO
ALTER DATABASE [Test_DB_14001122_b] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [Test_DB_14001122_b] SET ARITHABORT OFF
GO
ALTER DATABASE [Test_DB_14001122_b] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [Test_DB_14001122_b] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [Test_DB_14001122_b] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [Test_DB_14001122_b] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [Test_DB_14001122_b] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [Test_DB_14001122_b] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [Test_DB_14001122_b] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [Test_DB_14001122_b] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [Test_DB_14001122_b] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [Test_DB_14001122_b] SET DISABLE_BROKER
GO
ALTER DATABASE [Test_DB_14001122_b] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [Test_DB_14001122_b] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [Test_DB_14001122_b] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [Test_DB_14001122_b] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [Test_DB_14001122_b] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [Test_DB_14001122_b] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [Test_DB_14001122_b] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [Test_DB_14001122_b] SET RECOVERY SIMPLE
GO
ALTER DATABASE [Test_DB_14001122_b] SET MULTI_USER
GO
ALTER DATABASE [Test_DB_14001122_b] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [Test_DB_14001122_b] SET DB_CHAINING OFF
GO
USE [Test_DB_14001122_b]
GO
/****** Object: Table [dbo].[Table_Students] Script Date: 2022-02-27 14:54:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table_Students](
[Student_Code] [int] NOT NULL,
[First Name] [nvarchar](50) NULL,
[Last Name] [nvarchar](50) NULL,
[Average] [float] NULL,
[Maghta_] [nvarchar](50) NULL,
[Reshte] [nvarchar](50) NULL,
CONSTRAINT [PK_Table_Students] PRIMARY KEY CLUSTERED
(
[Student_Code] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
USE [master]
GO
ALTER DATABASE [Test_DB_14001122_b] SET READ_WRITE
GO