fork(1) download
copy 
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Web;
  5. using System.Web.UI;
  6. using System.Web.UI.WebControls;
  7. using System.Data;
  8. using System.Data.SqlClient;
  9.  
  10. namespace ASPSQLFinal
  11. {
  12.     public partial class WebForm1 : System.Web.UI.Page
  13.     {
  14.  
  15.         SqlConnection con = new SqlConnection("Data Source=***");
  16.         protected void Page_Load(object sender, EventArgs e)
  17.         {
  18.             if(con.State == ConnectionState.Open)
  19.             {
  20.                 con.Close();
  21.             }
  22.             con.Open();
  23.  
  24.  
  25.             disp_data();
  26.         }
  27.  
  28.         protected void btnInsert_Click(object sender, EventArgs e)
  29.         {
  30.             SqlConnection con = new SqlConnection("Data Source=***");
  31.             con.Open();
  32.  
  33.             SqlCommand cmd = con.CreateCommand();
  34.             cmd.CommandType = CommandType.Text;
  35.             cmd.CommandText = "Insert into Courses values(@CourseID, @ContactHours, @CourseTitle)";
  36.             cmd.Parameters.AddWithValue("@CourseID", CourseID.Text);
  37.             cmd.Parameters.AddWithValue("@ContactHours", ContactHours.Text);
  38.             cmd.Parameters.AddWithValue("@CourseTitle", CourseTitle.Text);
  39.             cmd.Connection = con;
  40.             cmd.ExecuteNonQuery();
  41.             cmd.Parameters.Clear();
  42.             cmd.CommandText = "Insert into TermTable values(@TermID, @Year, @Semester)";
  43.             cmd.Parameters.AddWithValue("@TermID", TermID.Text);
  44.             cmd.Parameters.AddWithValue("@Year", Year.Text);
  45.             cmd.Parameters.AddWithValue("@Semester", Semester.Text);
  46.             cmd.ExecuteNonQuery();
  47.             cmd.Parameters.Clear();
  48.             cmd.CommandText = "Insert into Instructors values(@InstructorID, @FirstName, @LastName)";
  49.             cmd.Parameters.AddWithValue("@InstructorID", InstructorID.Text);
  50.             cmd.Parameters.AddWithValue("@FirstName", FirstName.Text);
  51.             cmd.Parameters.AddWithValue("@LastName", LastName.Text);
  52.             cmd.ExecuteNonQuery();
  53.             disp_data();
  54.         }
  55.  
  56.         public void disp_data()
  57.         {
  58.             SqlCommand cmd = con.CreateCommand();
  59.             cmd.CommandType = CommandType.Text;
  60.             cmd.CommandText =
  61.                 "select * from Courses, TermTable, Instructors";
  62.             cmd.ExecuteNonQuery();
  63.             DataTable dt = new DataTable();
  64.             SqlDataAdapter da = new SqlDataAdapter(cmd);
  65.             da.Fill(dt);
  66.             GridView1.DataSource = dt;
  67.             GridView1.DataBind();
  68.         }
  69.  
  70.         protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
  71.         {
  72.  
  73.         }
  74.  
  75.         protected void btnDelete_Click(object sender, EventArgs e)
  76.         {
  77.             SqlConnection con = new SqlConnection("Data Source=***");
  78.             con.Open();
  79.  
  80.             SqlCommand cmd = con.CreateCommand();
  81.             cmd.CommandType = CommandType.Text;
  82.             cmd.CommandText = "DELETE FROM Courses where CourseID = '" + CourseID.Text + "'";
  83.             cmd.ExecuteNonQuery();
  84.             cmd.Parameters.Clear();
  85.             cmd.CommandText = "DELETE FROM TermTable where TermID = '" + TermID.Text + "'";
  86.             cmd.ExecuteNonQuery();
  87.             cmd.Parameters.Clear();
  88.             cmd.CommandText = "DELETE FROM Instructors where InstructorID = '" + InstructorID.Text + "'";
  89.             cmd.ExecuteNonQuery();
  90.             cmd.Parameters.Clear();
  91.  
  92.             disp_data();
  93.  
  94.  
  95.         }
  96.  
  97.         protected void btnInsert1_Click(object sender, EventArgs e)
  98.         {
  99.             SqlConnection con = new SqlConnection("Data Source=***");
  100.             con.Open();
  101.  
  102.             SqlCommand cmd = con.CreateCommand();
  103.             cmd.CommandType = CommandType.Text;
  104.             cmd.CommandText = "Insert into Enrollments values(@EnrollmentID, @CourseID, @TermID, @InstructorID, @Responses, @Enrolled)";
  105.             cmd.Parameters.AddWithValue("@EnrollmentID", @EnrollmentID.Text);
  106.             cmd.Parameters.AddWithValue("@CourseID", @CourseID.Text);
  107.             cmd.Parameters.AddWithValue("@TermID", @TermID.Text);
  108.             cmd.Parameters.AddWithValue("@InstructorID", @InstructorID.Text);
  109.             cmd.Parameters.AddWithValue("@Responses", @Responses.Text);
  110.             cmd.Parameters.AddWithValue("@Enrolled", @Enrolled.Text);
  111.             cmd.Connection = con;
  112.             cmd.ExecuteNonQuery();
  113.             cmd.Parameters.Clear();
  114.             disp_data1();
  115.  
  116.             double EnrolledNumber = Convert.ToDouble(Enrolled.Text);
  117.             double ResponsesNumber = Convert.ToDouble(Responses.Text);
  118.             double Result = ResponsesNumber / EnrolledNumber;
  119.             Label1.Text = Result.ToString();
  120.  
  121.         }
  122.  
  123.         public void disp_data1()
  124.         {
  125.             SqlCommand cmd = con.CreateCommand();
  126.             cmd.CommandType = CommandType.Text;
  127.             cmd.CommandText =
  128.                 "select * from Enrollments, Courses, TermTable, Instructors";
  129.             cmd.ExecuteNonQuery();
  130.             DataTable dt = new DataTable();
  131.             SqlDataAdapter da = new SqlDataAdapter(cmd);
  132.             da.Fill(dt);
  133.             GridView2.DataSource = dt;
  134.             GridView2.DataBind();
  135.         }
  136.  
  137.         protected void btnDelete1_Click(object sender, EventArgs e)
  138.         {
  139.             SqlConnection con = new SqlConnection("Data Source=***");
  140.             con.Open();
  141.  
  142.             SqlCommand cmd = con.CreateCommand();
  143.             cmd.CommandType = CommandType.Text;
  144.             cmd.CommandText = "DELETE FROM Enrollments where EnrollmentID = '" + EnrollmentID.Text + "'";
  145.             cmd.ExecuteNonQuery();
  146.             cmd.Parameters.Clear();
  147.  
  148.             disp_data1();
  149.         }
  150.         public void disp_data2()
  151.         {
  152.             SqlCommand cmd = con.CreateCommand();
  153.             cmd.CommandType = CommandType.Text;
  154.             cmd.CommandText =
  155.                 "select * from VerySatisfied";
  156.             cmd.ExecuteNonQuery();
  157.             DataTable dt = new DataTable();
  158.             SqlDataAdapter da = new SqlDataAdapter(cmd);
  159.             da.Fill(dt);
  160.             GridView3.DataSource = dt;
  161.             GridView3.DataBind();
  162.         }
  163.  
  164.         protected void btnInsert2_Click(object sender, EventArgs e)
  165.         {
  166.             SqlConnection con = new SqlConnection("Data Source=***");
  167.             con.Open();
  168.  
  169.             SqlCommand cmd = con.CreateCommand();
  170.             cmd.CommandType = CommandType.Text;
  171.             cmd.CommandText = "Insert into VerySatisfied values(@QuestionNum, @Question, @VerySatisfiedID)";
  172.             cmd.Parameters.AddWithValue("@QuestionNum", @QuestionNum.Text);
  173.             cmd.Parameters.AddWithValue("@Question", @Question.Text);
  174.             cmd.Parameters.AddWithValue("@VerySatisfiedID", @VerySatisfiedID.Text);
  175.             cmd.Connection = con;
  176.             cmd.ExecuteNonQuery();
  177.             cmd.Parameters.Clear();
  178.             disp_data2();
  179.  
  180.             Label2.Text = "0";
  181.  
  182.         }
  183.  
  184.         protected void btnDelete2_Click(object sender, EventArgs e)
  185.         {
  186.             SqlConnection con = new SqlConnection("Data Source=***");
  187.             con.Open();
  188.  
  189.             SqlCommand cmd = con.CreateCommand();
  190.             cmd.CommandType = CommandType.Text;
  191.             cmd.CommandText = "DELETE FROM VerySatisfied where QuestionNum = '" + QuestionNum.Text + "'";
  192.             cmd.ExecuteNonQuery();
  193.             cmd.Parameters.Clear();
  194.  
  195.             disp_data2();
  196.         }
  197.  
  198.         protected void GridView3_SelectedIndexChanged(object sender, EventArgs e)
  199.         {
  200.  
  201.         }
  202.     }
  203. }
Compilation error #stdin compilation error #stdout 0s 0KB
comments (?)
stdin
copy 
Standard input is empty
compilation info 
prog.cs(5,18): error CS0234: The type or namespace name `UI' does not exist in the namespace `System.Web'. Are you missing an assembly reference?
prog.cs(6,18): error CS0234: The type or namespace name `UI' does not exist in the namespace `System.Web'. Are you missing an assembly reference?
prog.cs(7,14): error CS0234: The type or namespace name `Data' does not exist in the namespace `System'. Are you missing `System.Data' assembly reference?
prog.cs(8,14): error CS0234: The type or namespace name `Data' does not exist in the namespace `System'. Are you missing `System.Data' assembly reference?
prog.cs(12,48): error CS0234: The type or namespace name `UI' does not exist in the namespace `System.Web'. Are you missing an assembly reference?
prog.cs(15,9): error CS0246: The type or namespace name `SqlConnection' could not be found. Are you missing an assembly reference?
Compilation failed: 6 error(s), 0 warnings
stdout
copy 
Standard output is empty
https://ideone.com/vHhzwR
language:
C# (gmcs 5.20.1)
created:
2 years ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!