Skip to content

Instantly share code, notes, and snippets.

@alexferreira
Created September 21, 2010 16:50
Show Gist options
  • Save alexferreira/590023 to your computer and use it in GitHub Desktop.
Save alexferreira/590023 to your computer and use it in GitHub Desktop.
if (int.Parse(ihid.Value.ToString()) == 0)
{
SqlConnection Cn = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["exportaminasConnectionString"].ConnectionString);
Cn.Open();
SqlCommand Cmd = new SqlCommand("insert into TBEXM_ServicosComerciais (pais, endereco, fone, fax, email, website, chefe) " +
"values (@pais, @endereco, @fone, @fax, @email, @website, @chefe) ", Cn);
Cmd.CommandType = CommandType.Text;
Cmd.Parameters.Add("@pais", SqlDbType.VarChar).Value = txPais.Value;
Cmd.Parameters.Add("@endereco", SqlDbType.VarChar).Value = txEndereco.Value;
Cmd.Parameters.Add("@fone", SqlDbType.Text).Value = txFone.Value;
Cmd.Parameters.Add("@fax", SqlDbType.VarChar).Value = txFax.Value;
Cmd.Parameters.Add("@email", SqlDbType.VarChar).Value = txEmail.Value;
Cmd.Parameters.Add("@website", SqlDbType.VarChar).Value = txWebsite.Value;
Cmd.Parameters.Add("@chefe", SqlDbType.VarChar).Value = txChefe.Value;
Cmd.ExecuteNonQuery();
Cn.Close();
}
else
{
SqlConnection Cn = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["exportaminasConnectionString"].ConnectionString);
Cn.Open();
SqlCommand Cmd = new SqlCommand("update TBEXM_ServicosComerciais set pais = @pais, endereco = @endereco, " +
"fone = @fone, fax = @fax, email = @email, website = @website, chefe = @chefe where id = @id", Cn);
Cmd.CommandType = CommandType.Text;
Cmd.Parameters.Add("@id", SqlDbType.Int).Value = int.Parse(ihid.Value.ToString());
Cmd.Parameters.Add("@pais", SqlDbType.VarChar).Value = txPais.Value;
Cmd.Parameters.Add("@endereco", SqlDbType.VarChar).Value = txEndereco.Value;
Cmd.Parameters.Add("@fone", SqlDbType.Text).Value = txFone.Value;
Cmd.Parameters.Add("@fax", SqlDbType.VarChar).Value = txFax.Value;
Cmd.Parameters.Add("@email", SqlDbType.VarChar).Value = txEmail.Value;
Cmd.Parameters.Add("@website", SqlDbType.VarChar).Value = txWebsite.Value;
Cmd.Parameters.Add("@chefe", SqlDbType.VarChar).Value = txChefe.Value;
Cmd.ExecuteNonQuery();
Cn.Close();
}
Response.Redirect("servicos_comerciais_home.aspx");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment