public void Inserir(Frase obj) { //cria um objeto de conexão SqlConnection con = new SqlConnection(); con.ConnectionString = connString.ToString(); SqlCommand cmd = new SqlCommand(); try { cmd.Connection = con; cmd.CommandText = "Insert into frases (frase, autor, categoria) values (@frase, @autor, @categoria);select @@IDENTITY;"; cmd.Parameters.AddWithValue("frase", obj.Text); cmd.Parameters.AddWithValue("autor", obj.Autor); cmd.Parameters.AddWithValue("categoria", obj.Categoria); con.Open(); obj.Id = Convert.ToInt32(cmd.ExecuteScalar()); } catch (Exception e) { throw new Exception(e.Message); } finally { con.Close(); } }
public void Inserir(Autor obj) { //cria um objeto de conexão SqlConnection con = new SqlConnection(); con.ConnectionString = connString.ToString(); SqlCommand cmd = new SqlCommand(); try { cmd.Connection = con; cmd.CommandText = "Insert into autores (nome, foto) values (@nome, @foto);select @@IDENTITY;"; cmd.Parameters.AddWithValue("nome", obj.Nome); cmd.Parameters.AddWithValue("foto", obj.Foto); con.Open(); obj.Id = Convert.ToInt32(cmd.ExecuteScalar()); } catch (Exception e) { throw new Exception(e.Message); } finally { con.Close(); } }
public void Inserir(Usuario obj) { //cria um objeto de conexão SqlConnection con = new SqlConnection(); con.ConnectionString = connString.ToString(); SqlCommand cmd = new SqlCommand(); try { cmd.Connection = con; cmd.CommandText = "Insert into usuarios (nome, email, senha) values (@nome, @email, @senha);select @@IDENTITY;"; cmd.Parameters.AddWithValue("nome", obj.Nome); cmd.Parameters.AddWithValue("email", obj.Email); cmd.Parameters.AddWithValue("senha", obj.Senha); con.Open(); obj.Id = Convert.ToInt32(cmd.ExecuteScalar()); } catch (Exception e) { throw new Exception(e.Message); } finally { con.Close(); } }
public ConexionBD() { System.Configuration.Configuration webConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/HousingU"); System.Configuration.ConnectionStringSettings conString = webConfig.ConnectionStrings.ConnectionStrings["BDHousingU"]; con = new OdbcConnection(conString.ToString()); con.Open(); }
public cDataBase() { System.Configuration.Configuration rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/MyWebSiteRoot"); if (rootWebConfig.ConnectionStrings.ConnectionStrings.Count > 0) { System.Configuration.ConnectionStringSettings connString = rootWebConfig.ConnectionStrings.ConnectionStrings["DBConnectionString"]; oleDbCnn = new OleDbConnection(connString.ToString().ToString()); System.Configuration.ConnectionStringSettings SqlconnStr = rootWebConfig.ConnectionStrings.ConnectionStrings["SQLConnectionString"]; sqlCnn = new SqlConnection(SqlconnStr.ToString()); } }