Разработка системы взаимодействия студентов в открытых системах дистанционного образования
Курсовой проект - Компьютеры, программирование
Другие курсовые по предмету Компьютеры, программирование
orm3()
{
//
// Required for Windows Form Designer support
//();
//
// TODO: Add any constructor code after InitializeComponent call
//
}
///
/// Clean up any resources being used.
/// override void Dispose( bool disposing )
{( disposing )
{(components != null)
{.Dispose();
}
}.Dispose( disposing );
}
#region Windows Form Designer generated code
///
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// void InitializeComponent()
{.listBox1 = new System.Windows.Forms.ListBox();.textBox1 = new System.Windows.Forms.TextBox();.button1 = new System.Windows.Forms.Button();.button2 = new System.Windows.Forms.Button();.button3 = new System.Windows.Forms.Button();.button4 = new System.Windows.Forms.Button();.comboBox1 = new System.Windows.Forms.ComboBox();.label1 = new System.Windows.Forms.Label();.SuspendLayout();
//
// listBox1
// .listBox1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));.listBox1.Location = new System.Drawing.Point(8, 40);.listBox1.Name = "listBox1";.listBox1.ScrollAlwaysVisible = true;.listBox1.Size = new System.Drawing.Size(384, 95);.listBox1.TabIndex = 0;.listBox1.SelectedIndexChanged += new System.EventHandler(this.listBox1_SelectedIndexChanged);
//
// textBox1
// .textBox1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));.textBox1.Location = new System.Drawing.Point(8, 144);.textBox1.Multiline = true;.textBox1.Name = "textBox1";.textBox1.ScrollBars = System.Windows.Forms.ScrollBars.Both;.textBox1.Size = new System.Drawing.Size(280, 160);.textBox1.TabIndex = 1;.textBox1.Text = "";.textBox1.TextChanged += new System.EventHandler(this.textBox1_TextChanged);
//
// button1
// .button1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));.button1.Location = new System.Drawing.Point(296, 266);.button1.Name = "button1";.button1.Size = new System.Drawing.Size(96, 32);.button1.TabIndex = 2;.button1.Text = "Закрыть";.button1.Click += new System.EventHandler(this.button1_Click);
//
// button2
// .button2.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));.button2.Enabled = false;.button2.Location = new System.Drawing.Point(296, 146);.button2.Name = "button2";.button2.Size = new System.Drawing.Size(96, 32);.button2.TabIndex = 3;.button2.Text = "Редактировать";.button2.Click += new System.EventHandler(this.button2_Click);
//
// button3
// .button3.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));.button3.Enabled = false;.button3.Location = new System.Drawing.Point(296, 186);.button3.Name = "button3";.button3.Size = new System.Drawing.Size(96, 32);.button3.TabIndex = 3;.button3.Text = "Очистить";.button3.Click += new System.EventHandler(this.button3_Click);
//
// button4
// .button4.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));.button4.Enabled = false;.button4.Location = new System.Drawing.Point(296, 226);.button4.Name = "button4";.button4.Size = new System.Drawing.Size(96, 32);.button4.TabIndex = 3;.button4.Text = "Добавить";.button4.Click += new System.EventHandler(this.button4_Click);
//
// comboBox1
// .comboBox1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));.comboBox1.Location = new System.Drawing.Point(112, 8);.comboBox1.Name = "comboBox1";.comboBox1.Size = new System.Drawing.Size(280, 21);.comboBox1.TabIndex = 4;.comboBox1.Text = "Выберите...";.comboBox1.SelectedIndexChanged += new System.EventHandler(this.comboBox1_SelectedIndexChanged);
//
// label1
// .label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(204)));.label1.Location = new System.Drawing.Point(8, 8);.label1.Name = "label1";.label1.Size = new System.Drawing.Size(128, 24);.label1.TabIndex = 5;.label1.Text = "Дисциплина:";
//
// Form3
// .AutoScaleBaseSize = new System.Drawing.Size(5, 13);.ClientSize = new System.Drawing.Size(400, 310);.Controls.Add(this.comboBox1);.Controls.Add(this.label1);.Controls.Add(this.button2);.Controls.Add(this.button1);.Controls.Add(this.textBox1);.Controls.Add(this.listBox1);.Controls.Add(this.button3);.Controls.Add(this.button4);.Name = "Form3";.Text = "Администратор";.Load += new System.EventHandler(this.Form3_Load);.ResumeLayout(false);
}
#endregionusery;dis;[]cb=new string[32000];[]lb=new string[32000];void button1_Click(object sender, System.EventArgs e)
{.Close();
}void listBox1_SelectedIndexChanged(object sender, System.EventArgs e)
{(listBox1.SelectedIndex!=-1)
{.Enabled=true;
}
{.Enabled=false;
}
}void textBox1_TextChanged(object sender, System.EventArgs e)
{(textBox1.Text=="")
{.Enabled=false;.Enabled=false;
}
{.Enabled=true;.Enabled=true;
}
}void Form3_Load(object sender, System.EventArgs e)
{=new DataSet();DBConnectionString=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db1.mdb";.Data.OleDb.OleDbConnection aCon=new System.Data.OleDb.OleDbConnection(DBConnectionString);.Data.OleDb.OleDbCommand команда=new System.Data.OleDb.OleDbCommand("",aCon); .Data.OleDb.OleDbDataAdapter adapter=new System.Data.OleDb.OleDbDataAdapter(команда);.Open();
команда.CommandText="SELECT * FROM dis";.SelectCommand=команда;.Fill(dis,"dis");.Close();.Items.Clear();(int i=0;i<dis.Tables[0].Rows.Count;i++)
{.Items.Add(dis.Tables[0].Rows[i]["disciplina"].ToString());[i]=dis.Tables[0].Rows[i]["id"].ToString();
}
}void comboBox1_SelectedIndexChanged(object sender, System.EventArgs e)
{
{=new DataSet();DBConnectionString=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db1.mdb";.Data.OleDb.OleDbConnection aCon=new System.Data.OleDb.OleDbConnection(DBConnectionString);.Data.OleDb.OleDbCommand команда=new System.Data.OleDb.OleDbCommand("",aCon); .Data.OleDb.OleDbDataAdapter adapter=new System.Data.OleDb.OleDbDataAdapter(команда);.Open();
команда.CommandText="SELECT * FROM usery";.SelectCommand=команда;.Fill(usery,"usery");.Close();.Items.Clear();po=0;(int i=0;i<usery.Tables[0].Rows.Count;i++)
{(cb[comboBox1.SelectedIndex].ToString()==usery.Tables[0].Rows[i]["id_disciplina"].ToString())
{.Items.Add(usery.Tables[0].Rows[i]["textx"].ToString());[po]=usery.Tables[0].Rows[i]["id"].ToString();++;
}
}
}(Exception err)
{.Show(err.Message);
}
}void button2_Click(object sender, System.EventArgs e)
{
{.Text=listBox1.Items[listBox1.SelectedIndex].ToString();DBConnectionString=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db1.mdb";.Data.OleDb.OleDbConnection aCon=new System.Data.OleDb.OleDbConnection(DBConnectionString);.Data.OleDb.OleDbCommand команда=new System.Data.OleDb.OleDbCommand("",aCon); .Data.OleDb.OleDbDataAdapter adapter=new System.Data.OleDb.OleDbDataAdapter(команда);.Open();
команда.CommandText="DELETE FROM usery WHERE id="+lb[listBox1.SelectedIndex];
команда.ExecuteNonQuery(); .Close();.Open(); =new DataSet();
команда.CommandText="SELECT * FROM usery";.SelectCommand=команда;.Fill(usery,"usery");.Close();.Items.Clear();po=0;(int i=0;i<usery.Tables[0].Rows.Count;i++)
{(cb[comboBox1.SelectedIndex].ToString()==usery.Tables[0].Rows[i]["id_disciplina"].ToString())
{.Items.Add(usery.Tables[0].Rows[i]["textx"].ToString());[po]=usery.Tables[0].Rows[i]["id"].ToString();++;
}
}
}(Exception err)
{.Show(err.Message);
}
}void button3_Click(object sender, System.EventArgs e)
{.Text="";
}void button4_Click(object sender, System.EventArgs e)
{DBConnectionString=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db1.mdb";.Data.OleDb.OleDbConnection aCon=new System.Data.OleDb.OleDbConnection(DBConnectionString);.Data.OleDb.OleDbCommand команда=new System.Data.OleDb.OleDbCommand("",aCon); .Data.OleDb.OleDbDataAdapter adapter=new System.Data.OleDb.OleDbDataAdapter(команда);
команда.CommandText="INSERT