protected void ShowRecords2(object sender, EventArgs e) { SqlDataSource10.DataBind(); GridView1.DataBind(); UpdatePanel2.Update(); Button3.Visible = true; Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('UpdateGrade')", true); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["activeView"] != null) { int activeViewIndexVal = Convert.ToInt32(Request.QueryString["activeView"]); string activeViewIndex = (String)Request.QueryString["activeView"]; switch (activeViewIndex) { case "0": MultiView1.ActiveViewIndex = activeViewIndexVal; break; case "1": MultiView1.ActiveViewIndex = activeViewIndexVal; DetailsView2.Visible = false; break; case "2": MultiView1.ActiveViewIndex = activeViewIndexVal; break; } } else if (Request.QueryString["courseID"] != null) { Session["courseID"] = Request.QueryString["courseID"].ToString(); MultiView1.ActiveViewIndex = 0; // DropDownList1.SelectedValue = Session["courseID"].ToString(); DropDownList1.DataBind(); DropDownList1.SelectedIndex = DropDownList1.Items.IndexOf(DropDownList1.Items.FindByValue(Session["courseID"].ToString())); // sqldatasource11.selectparameters["courseid"].defaultvalue = session["courseid"].tostring(); //sqldatasource11.databind(); SqlDataSource10.DataBind(); DetailsView1.DataSource = SqlDataSource10; DetailsView1.DataBind(); //DetailsView1.DataSource = SqlDataSource11; //DetailsView1.DataBind(); loadGridviewSemester(); setBsicStudentInfo(); } else { DetailsView2.Visible = false; MultiView1.ActiveViewIndex = 0; } } else if (GridView1.SelectedIndex < 0) { DetailsView2.Visible = false; } }
protected void Button8_Click(object sender, EventArgs e) { try { if (TextBox8.Text != "") { SqlDataSource10.InsertParameters["SubCategoria"].DefaultValue = TextBox8.Text; SqlDataSource10.InsertParameters["ID_Categoria"].DefaultValue = DropDownList3.SelectedValue; SqlDataSource10.Insert(); SqlDataSource10.SelectCommand = "SELECT SubCategoria.ID_SubCategoria, SubCategoria.SubCategoria, Categoria.Categoria FROM Categoria INNER JOIN SubCategoria ON Categoria.ID_Categoria = SubCategoria.ID_Categoria WHERE(Categoria.Estado = 1)"; SqlDataSource10.DataBind(); borrar(); } else { Response.Write("<script>alert('Error, resive los datos')</script>"); } } catch { Response.Write("<script>alert('Error, resive los datos')</script>"); } }
protected void Button1_Click(object sender, EventArgs e)//insert { string constr = ""; constr = ConfigurationManager.ConnectionStrings["infoConnectionString"].ToString(); SqlConnection obj1 = new SqlConnection(constr); { try { obj1.Open(); SqlCommand cmd = new SqlCommand("RegisterInsertOrEdit", obj1); cmd.CommandType = CommandType.StoredProcedure; // cmd.Parameters.AddWithValue("@UserID", Convert.ToInt32(hfUserID.Value == "" ? "0" : hfUserID.Value)); cmd.Parameters.Add("@Fname", SqlDbType.VarChar).Value = TextBox1.Text; cmd.Parameters.Add("@Lname", SqlDbType.VarChar).Value = TextBox2.Text; cmd.Parameters.Add("@dob", SqlDbType.Date).Value = txtDob.Text; cmd.Parameters.Add("@MStatus", SqlDbType.VarChar).Value = DropDownList1.SelectedItem.Text; cmd.Parameters.Add("@Marital_ID", SqlDbType.Int).Value = DropDownList1.SelectedValue; cmd.Parameters.Add("@Gender", SqlDbType.VarChar).Value = DropDownList2.SelectedItem.Text; cmd.Parameters.Add("@Gender_ID", SqlDbType.Int).Value = DropDownList2.SelectedValue; cmd.Parameters.Add("@Country", SqlDbType.VarChar).Value = DropDownList3.SelectedItem.Text; cmd.Parameters.Add("@Country_ID", SqlDbType.Int).Value = DropDownList3.SelectedValue; cmd.Parameters.Add("@State", SqlDbType.VarChar).Value = DropDownList4.SelectedItem.Text; cmd.Parameters.Add("@State_ID", SqlDbType.Int).Value = DropDownList4.SelectedValue; cmd.Parameters.Add("@City", SqlDbType.VarChar).Value = DropDownList5.SelectedItem.Text; cmd.Parameters.Add("@City_ID", SqlDbType.Int).Value = DropDownList5.SelectedValue; cmd.Parameters.Add("@Pincode", SqlDbType.VarChar).Value = TextBox9.Text; cmd.Parameters.Add("@add", SqlDbType.VarChar).Value = TextBox8.Text; cmd.Parameters.Add("@PersonalEmail", SqlDbType.VarChar).Value = TextBox7.Text; cmd.Parameters.Add("@OfficialEmail", SqlDbType.VarChar).Value = TextBox5.Text; //cmd.Parameters.Add("@Password", SqlDbType.VarChar).Value = txtPassword.Text; cmd.Parameters.Add("@Contact1", SqlDbType.VarChar).Value = TextBox6.Text; cmd.Parameters.Add("@Contact2", SqlDbType.VarChar).Value = TextBox3.Text; cmd.Parameters.Add("@DOJ", SqlDbType.Date).Value = txtDoj.Text; cmd.Parameters.AddWithValue("@MotherName", TextBox10.Text); cmd.Parameters.Add("@FatherName", SqlDbType.VarChar).Value = TextBox11.Text; cmd.Parameters.Add("@BldGrp", SqlDbType.VarChar).Value = DropDownList9.SelectedItem.Text; cmd.Parameters.Add("@BloodGroup_ID", SqlDbType.Int).Value = DropDownList9.SelectedValue; cmd.Parameters.Add("@Dept", SqlDbType.VarChar).Value = DropDownList6.SelectedItem.Text; cmd.Parameters.Add("@Department_ID", SqlDbType.Int).Value = DropDownList6.SelectedValue; cmd.Parameters.Add("@Desig", SqlDbType.VarChar).Value = DropDownList7.SelectedItem.Text; cmd.Parameters.Add("@Designation_ID", SqlDbType.Int).Value = DropDownList7.SelectedValue; cmd.Parameters.Add("@Grade", SqlDbType.VarChar).Value = DropDownList8.SelectedItem.Text; cmd.Parameters.Add("@Grade_ID", SqlDbType.Int).Value = DropDownList8.SelectedValue; cmd.Parameters.Add("@CardNum", SqlDbType.VarChar).Value = TextBox4.Text; cmd.Parameters.Add("@ReportingManager", SqlDbType.VarChar).Value = DropDownList10.SelectedItem.Text; cmd.Parameters.Add("@Manager_ID", SqlDbType.Int).Value = DropDownList10.SelectedValue; cmd.ExecuteNonQuery(); SqlDataSource10.DataBind(); GridView1.DataSource = null; GridView1.DataSourceID = "SqlDataSource10"; //con.Close(); GridView1.SelectedIndex = -1; // Response.Redirect(Request.Url.AbsoluteUri); Clear(); Label2.Text = "Details inserted successfully"; // Label1.Text = "Total Regitrations"; // Label1.Text = counter.ToString(); // counter++; } catch (Exception ex) { Response.Write(ex.Message.ToString()); lblOutput.Text = ""; } finally { obj1.Close(); } } }