Разработка системы взаимодействия студентов в открытых системах дистанционного образования
Курсовой проект - Компьютеры, программирование
Другие курсовые по предмету Компьютеры, программирование
///
/// The main entry point for the application.
///
[STAThread]void Main()
{.Run(new Form1());
}dis,,;nom=-1;ntb=0;[]s=new string[32000];void textBox1_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
{.ReadOnly=true;
}void textBox1_KeyUp(object sender, System.Windows.Forms.KeyEventArgs e)
{.ReadOnly=false;
}void menuItem1_Click(object sender, System.EventArgs e)
{f2=new Form2();.ShowDialog();.Dispose();.Text="";.Text="";.Text="Выберите...";.Focus();
}void Form1_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());
}
}void comboBox1_SelectedIndexChanged(object sender, System.EventArgs e)
{=0;=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();(int i=0;i<dis.Tables[0].Rows.Count;i++)
{(comboBox1.Items[comboBox1.SelectedIndex].ToString()==dis.Tables[0].Rows[i]["disciplina"].ToString())
{=Convert.ToInt32(dis.Tables[0].Rows[i]["id"].ToString());
}
}=new DataSet();.Open();
команда.CommandText="SELECT * FROM forum";.SelectCommand=команда;.Fill(forum,"forum");.Close();=new DataSet();.Open();
команда.CommandText="SELECT * FROM usery";.SelectCommand=команда;.Fill(usery,"usery");.Close();=new string[32000];(int i=0;i<forum.Tables[0].Rows.Count;i++)
{(nom==Convert.ToInt32(forum.Tables[0].Rows[i]["id_disciplina"].ToString()))
{[ntb]=forum.Tables[0].Rows[i]["textx"].ToString();++;
}
}(int i=0;i<usery.Tables[0].Rows.Count;i++)
{(nom==Convert.ToInt32(usery.Tables[0].Rows[i]["id_disciplina"].ToString()))
{[ntb]=usery.Tables[0].Rows[i]["textx"].ToString();++;
}
}[]ss=new string[ntb];(int i=0;i<ntb;i++)
{[i]=s[i];
}.Lines=ss;.Text="";.Select(textBox1.Text.Length-1, 0);.ScrollToCaret();
}void button1_Click(object sender, System.EventArgs e)
{
{(textBox2.Text!="" & nom!=-1)
{=0;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 INTO usery (id_disciplina, textx) VALUES ("+""+nom.ToString()+", "+textBox2.Text+")";.Open();
команда.ExecuteNonQuery();.Close();=new DataSet();.Open();
команда.CommandText="SELECT * FROM forum";.SelectCommand=команда;.Fill(forum,"forum");.Close();=new DataSet();.Open();
команда.CommandText="SELECT * FROM usery";.SelectCommand=команда;.Fill(usery,"usery");.Close();=new string[32000];(int i=0;i<forum.Tables[0].Rows.Count;i++)
{(nom==Convert.ToInt32(forum.Tables[0].Rows[i]["id_disciplina"].ToString()))
{[ntb]=forum.Tables[0].Rows[i]["textx"].ToString();++;
}
}(int i=0;i<usery.Tables[0].Rows.Count;i++)
{(nom==Convert.ToInt32(usery.Tables[0].Rows[i]["id_disciplina"].ToString()))
{[ntb]=usery.Tables[0].Rows[i]["textx"].ToString();++;
}
}[]ss=new string[ntb];(int i=0;i<ntb;i++)
{[i]=s[i];
}.Lines=ss;.Text="";.Select(textBox1.Text.Length-1, 0);.ScrollToCaret();.Focus();
}
}(Exception err)
{.Show(err.Message);
}
}
}
}
Форма2System;System.Drawing;System.Collections;System.ComponentModel;System.Windows.Forms;System.Data;Форум
{
///
/// Summary description for Form2.
class Form2 : System.Windows.Forms.Form">/// class Form2 : System.Windows.Forms.Form
{System.Windows.Forms.Label label1;System.Windows.Forms.TextBox textBox1;System.Windows.Forms.Button button1;
///
/// Required designer variable.
System.ComponentModel.Container components = null;Form2()">/// System.ComponentModel.Container components = null;Form2()
{
//
// 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()
{.label1 = new System.Windows.Forms.Label();.textBox1 = new System.Windows.Forms.TextBox();.button1 = new System.Windows.Forms.Button();.SuspendLayout();
//
// label1
// .label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(204)));.label1.Location = new System.Drawing.Point(16, 16);.label1.Name = "label1";.label1.Size = new System.Drawing.Size(224, 24);.label1.TabIndex = 0;.label1.Text = "Введите пароль Администратора:";
//
// textBox1
// .textBox1.Location = new System.Drawing.Point(16, 40);.textBox1.Name = "textBox1";.textBox1.PasswordChar = @;.textBox1.Size = new System.Drawing.Size(224, 20);.textBox1.TabIndex = 1;.textBox1.Text = "";
//
// button1
// .button1.Location = new System.Drawing.Point(80, 80);.button1.Name = "button1";.button1.Size = new System.Drawing.Size(88, 32);.button1.TabIndex = 2;.button1.Text = "Ок";.button1.Click += new System.EventHandler(this.button1_Click);
//
// Form2
// .AutoScaleBaseSize = new System.Drawing.Size(5, 13);.ClientSize = new System.Drawing.Size(256, 126);.Controls.Add(this.button1);.Controls.Add(this.textBox1);.Controls.Add(this.label1);.FormBorderStyle = System.Windows.Forms.FormBorderStyle.Fixed3D;.MaximizeBox = false;.MinimizeBox = false;.Name = "Form2";.Text = "Введите парь";.ResumeLayout(false);
}
#endregionvoid button1_Click(object sender, System.EventArgs e)
{pas=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 pas";.SelectCommand=команда;.Fill(pas,"pas");.Close();(int i=0;i<pas.Tables[0].Rows.Count;i++)
{(textBox1.Text.ToString()==pas.Tables[0].Rows[i]["pas"].ToString())
{.Visible=false;f3=new Form3();.ShowDialog();.Focus();.Dispose();();
}
{.Text="";.Show("Вы не угадали пароль!","Ошибка");
}
}
}
}
}
Форма 3System;System.Drawing;System.Collections;System.ComponentModel;System.Windows.Forms;System.Data;Форум
{
///
/// Summary description for Form3.
class Form3 : System.Windows.Forms.Form">/// class Form3 : System.Windows.Forms.Form
{System.Windows.Forms.ListBox listBox1;System.Windows.Forms.TextBox textBox1;System.Windows.Forms.Button button1;System.Windows.Forms.Button button2;System.Windows.Forms.Button button3;System.Windows.Forms.Button button4;System.Windows.Forms.ComboBox comboBox1;System.Windows.Forms.Label label1;
///
/// Required designer variable.
System.ComponentModel.Container components = null;Form3()">/// System.ComponentModel.Container components = null;F