protected void Btn_addNewEventAdd_Click(object sender, EventArgs e) { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "INSERT INTO[EVENT_CALENDAR]([SUBJECT], [DESCRIPTION], [START], [END], [CATEGORY], [STATUS], [CREATOR_ID], [CREATE_TIMESTAMP]) VALUES(N'" + Tb_addNewSubjectName.Text + "', N'" + Tb_eventDiscription.Text + "', '" + Tb_eventStart.Text + "', '" + Tb_eventEnd.Text + "', N'" + Ddl_category.Text + "', '" + Ddl_eventStatus.Text + "', '" + Tb_eventCreator_ID.Text + "', '" + DateTime.Now + "')"; cmd.ExecuteNonQuery(); con.Close(); Gv_calendar.DataBind(); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "addNewEventModalCenter", "$('#addNewEventModalCenter').modal('hide');", true); }
protected void Btn_carlendarSearch_Click(object sender, EventArgs e) { Thread.Sleep(1000); string SUBJECT = Tb_calendarFilter.Text; string Filter = ""; //Colum of data table if (SUBJECT != "") { Filter = Filter + "SUBJECT like '%" + SUBJECT + "%' and "; } //Add filter expression of datasource if (Filter.Length > 0) { string FinalFilter = Filter.Remove(Filter.Length - 4, 3); SqlDataSourceEVENT_CALENDAR.FilterExpression = FinalFilter; } else { Gv_calendar.DataBind(); } }