动态时间表条目 [英] dynamic time table entry

问题描述

大家好我正在尝试开发时间表的应用程序。当您通过表单输入特定数据时，它将插入数据库中，并将以网格视图显示。任何人都可以建议怎么做。我已经将班次，班级（或年级），讲座，日间时间，老师，科目作为表格的字段。所以请建议我如何开发它。

Hello everyone I am trying to develop a application of time table.When you enter the particular data through the form it will get inserted in database, and it will be shown in grid-view. can anyone suggest how to do it.I have taken shift, class(or grade), lecture, day time, teacher, subject as fields for the form.So pls suggest me how to develop it.

protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
            string str;
            if (ddl_shift.SelectedValue == "Morning")
            {
                str = "8:00 AM to 9:00 AM," + "Teacher:" + ddl_teacher.SelectedValue + ",Subject:" + ddl_subject.SelectedValue;
            }
            
            con.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["atharva-classesConnectionString"].ConnectionString;
            con.Open();
            cmd.Connection = con;
            cmd.CommandText = "ins_timetable";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@shift", ddl_shift.SelectedValue);
            cmd.Parameters.AddWithValue("@class", ddl_class.SelectedValue);
            cmd.Parameters.AddWithValue("@lecture", ddl_lecture.SelectedValue);
            cmd.Parameters.AddWithValue("@lectype",ddl_lecture.SelectedValue);
            cmd.Parameters.AddWithValue("@teacher", ddl_teacher.SelectedValue);
            cmd.Parameters.AddWithValue("@subject", ddl_subject.SelectedValue);
            cmd.Parameters.AddWithValue("@day", ddl_day.SelectedValue);
            cmd.ExecuteNonQuery();
            ddl_class.SelectedValue = "0";
            ddl_day.SelectedValue = "0";
            ddl_lecture.SelectedValue = "0";
            ddl_shift.SelectedValue = "0";
            ddl_subject.SelectedValue = "0";
            ddl_teacher.SelectedValue = "0";
        }
        catch(Exception ex)
        {
            lbl_error.Visible = true;
            lbl_error.Text = ex.ToString();
        }
        finally
        {
            con.Close();
        }
    }
}

推荐答案

首先在一篇论文中写下你的想法并完成一篇论文一个。



另外，我不建议采用StoredProcedure。

升级不方便。

first write your thoughts in a paper and complete one by one.

additional,i don't advise that adopt StoredProcedure.
It's not convenient to upgrade.

这篇关于动态时间表条目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！