using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.Odbc; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { TextBox5.Attributes["onmouseover"] = "javascript:this.focus();"; TextBox5.Attributes["onfocus"] = "javascript:this.select();"; MultiView1.ActiveViewIndex = 0; } private const string ConnStr = "Driver={MySQL ODBC 3.51 Driver};" + "Server=dbmy0027.whservidor.com;Database=webboost_7;uid=webboost_7;pwd=montezuma;option=3"; //Definição da consulta a ser realizada protected override void OnInit(EventArgs e) { base.OnInit(e); using (OdbcConnection con = new OdbcConnection(ConnStr)) using (OdbcCommand cmd = new OdbcCommand("SELECT * FROM empregos", con)) { } } protected void Button1_Click(object sender, EventArgs e) { MultiView1.ActiveViewIndex = 1; } protected void Button2_Click(object sender, EventArgs e) { MultiView1.ActiveViewIndex = 0; } protected void Button3_Click(object sender, EventArgs e) { } protected void Button7_Click(object sender, EventArgs e) { } protected void Button6_Click(object sender, EventArgs e) { } protected void Button4_Click(object sender, EventArgs e) { } protected void Button8_Click(object sender, EventArgs e) { } protected void Button9_Click(object sender, EventArgs e) { } protected void Button10_Click(object sender, EventArgs e) { } protected void Button11_Click(object sender, EventArgs e) { } protected void Button12_Click(object sender, EventArgs e) { } protected void Button14_Click(object sender, EventArgs e) { } protected void Button13_Click(object sender, EventArgs e) { } protected void MultiView7_ActiveViewChanged(object sender, EventArgs e) { } protected void Button16_Click(object sender, EventArgs e) { } protected void Button15_Click(object sender, EventArgs e) { } protected void Button17_Click(object sender, EventArgs e) { } protected void Button18_Click(object sender, EventArgs e) { } protected void Button19_Click(object sender, EventArgs e) { } protected void Button20_Click(object sender, EventArgs e) { } protected void Button21_Click(object sender, EventArgs e) { } protected void Button22_Click(object sender, EventArgs e) { } protected void Button23_Click(object sender, EventArgs e) { } protected void Button24_Click(object sender, EventArgs e) { } protected void MultiView11_ActiveViewChanged(object sender, EventArgs e) { } protected void Button25_Click(object sender, EventArgs e) { } protected void Button28_Click(object sender, EventArgs e) { } protected void Button27_Click(object sender, EventArgs e) { } protected void Button30_Click(object sender, EventArgs e) { } protected void Button29_Click(object sender, EventArgs e) { } protected void Button32_Click(object sender, EventArgs e) { } protected void Button31_Click(object sender, EventArgs e) { } protected void Button34_Click(object sender, EventArgs e) { } protected void Button33_Click(object sender, EventArgs e) { } protected void Button35_Click(object sender, EventArgs e) { } protected void Button36_Click(object sender, EventArgs e) { } protected void Button37_Click(object sender, EventArgs e) { } protected void Button38_Click(object sender, EventArgs e) { } protected void Button39_Click(object sender, EventArgs e) { } protected void Button40_Click(object sender, EventArgs e) { } protected void Button41_Click(object sender, EventArgs e) { using (OdbcConnection con = new OdbcConnection(ConnStr)) using (OdbcCommand cmd = new OdbcCommand("INSERT INTO empregos" + "(empresa, email, website, local, vaga, descrição) VALUES (?, ?, ?, ?, ?, ?)", con)) { cmd.Parameters.Add("@address", OdbcType.VarChar, 255).Value = TextBox1.Text.Trim(); cmd.Parameters.Add("@address", OdbcType.VarChar, 255).Value = TextBox2.Text.Trim(); cmd.Parameters.Add("@address", OdbcType.VarChar, 255).Value = TextBox3.Text.Trim(); cmd.Parameters.Add("@address", OdbcType.VarChar, 255).Value = DropDownList1.Text.Trim(); cmd.Parameters.Add("@address", OdbcType.VarChar, 255).Value = TextBox4.Text.Trim(); cmd.Parameters.Add("@address", OdbcType.VarChar, 1600).Value = TextBox5.Text.Trim(); con.Open(); cmd.ExecuteNonQuery(); } } protected void Button42_Click(object sender, EventArgs e) { } protected void Button43_Click(object sender, EventArgs e) { } protected void Button45_Click(object sender, EventArgs e) { } protected void Button44_Click(object sender, EventArgs e) { } protected void TextBox5_TextChanged(object sender, EventArgs e) { } // private void TextBox5_Enter(object sender, EventArgs e) //{ // TextBox5.SelectAll(); // } protected void Button47_Click(object sender, EventArgs e) { } protected void Button46_Click(object sender, EventArgs e) { } protected void Button49_Click(object sender, EventArgs e) { } protected void Button48_Click(object sender, EventArgs e) { } protected void Button50_Click(object sender, EventArgs e) { } protected void Button51_Click(object sender, EventArgs e) { } protected void Button52_Click(object sender, EventArgs e) { } protected void Button53_Click(object sender, EventArgs e) { } protected void Button55_Click(object sender, EventArgs e) { } protected void Button54_Click(object sender, EventArgs e) { } protected void Button57_Click(object sender, EventArgs e) { } protected void Button56_Click(object sender, EventArgs e) { } protected void Button59_Click(object sender, EventArgs e) { } protected void Button58_Click(object sender, EventArgs e) { } protected void Button61_Click(object sender, EventArgs e) { } protected void Button60_Click(object sender, EventArgs e) { } protected void Button63_Click(object sender, EventArgs e) { } protected void Button62_Click(object sender, EventArgs e) { } protected void Button64_Click(object sender, EventArgs e) { } protected void Button65_Click(object sender, EventArgs e) { } protected void Button66_Click(object sender, EventArgs e) { } protected void Button67_Click(object sender, EventArgs e) { } protected void Button69_Click(object sender, EventArgs e) { } protected void Button68_Click(object sender, EventArgs e) { } protected void Button71_Click(object sender, EventArgs e) { } protected void Button70_Click(object sender, EventArgs e) { } protected void Button73_Click(object sender, EventArgs e) { } protected void Button72_Click(object sender, EventArgs e) { } protected void Button75_Click(object sender, EventArgs e) { } protected void Button74_Click(object sender, EventArgs e) { } protected void Button77_Click(object sender, EventArgs e) { } protected void Button76_Click(object sender, EventArgs e) { } }