SQL / RM - Erros C#

-- Script para remoção dos erros do C# como por exemplo
-- Couldn't perform the edit because another user changed the record.

-- ATENÇÃO: ESTE NÃO DEVE SER EXECUTADO SE O BANCO FIZER BACKUP DE LOG

set nocount on
declare @comando varchar(255)
declare @comando1 varchar(255)
declare @comando2 varchar(255)
declare @comando3 varchar(255)
declare @comando4 varchar(255)
declare @database varchar(100)
declare @datab varchar(50)
set @datab = (select distinct table_catalog from information_schema.tables)
if (select count(*) from master.dbo.sysprocesses where dbid in ( select dbid from master.dbo.sysdatabases where name = @datab )) <= 1
begin
    print ' '
    print 'Acertando permissões do banco.'
    exec sp_dboption @datab, 'single', 'true'
    exec sp_dboption @datab, 'trunc. log on chkpt.', 'true'
    exec sp_dboption @datab, 'auto create statistics', 'false'
    exec sp_dboption @datab, 'auto update statistics', 'false'
    exec sp_dboption @datab, 'ansi null default', 'true'
    print ' '
    print 'Verificando base de dados.'
    set @comando1 ='dbcc checkdb ('+@datab+')'
    exec (@comando1)
    print ' '
    print 'Acertando fragmentação na base de dados.'
    set @comando3= 'dbcc newalloc ('+@datab+')'
    exec (@comando3)
    declare @tabela varchar (100)
    declare @comando5 varchar (255)
    declare tabela cursor for
        select name from sysobjects where type = 'u' order by name
    open tabela
    fetch next from tabela into @tabela
    while @@fetch_status = 0
    begin
        print ''
        print 'Verificando tabela '+@tabela
        print ''
        set @comando5 = 'dbcc checktable ('+@tabela +', repair_allow_data_loss)'
        exec (@comando5)
        set @comando = 'dbcc dbreindex ('+@tabela+')'
        exec (@comando5)
        set @comando5= 'dbcc checkconstraints ('+@tabela+')'
        exec (@comando5)
        fetch next from tabela into @tabela
    end
    close tabela
    deallocate tabela
    exec sp_dboption @datab, 'single', 'false'
    declare @tab_nome varchar(255)
    declare @tab_statistic varchar(255)
    declare @sql_str varchar(255)
    declare @db_nome varchar(255)
    select @db_nome=name from master..sysdatabases where dbid=(select dbid from master..sysprocesses where spid=@@spid)
    checkpoint
    declare cur cursor for
        select object_name(id),name from sysindexes where name like '_wa_sys%'
    set nocount on
    open cur
    fetch next from cur into @tab_nome,@tab_statistic
    while(@@fetch_status=0)
    begin
        set @sql_str='drop statistics ' + @tab_nome + '.' + @tab_statistic
        exec (@sql_str)
        fetch next from cur into @tab_nome,@tab_statistic
    end   
    close cur
    deallocate cur
    exec sp_updatestats
    print '*******************************************************************************************'
    print 'FINAL DA MANUNTENCAO'
    print '*******************************************************************************************'
end
else
    begin
    print '****** A T E N Ç Â O *******'
    print 'A BASE ESTÁ SENDO USADA. ESTE SCRIPT SÓ PODE SER EXECUTADO EM MONOUSUÁRIO !!!'
    print '***********************************************************************************************************************'
    print 'Seguintes estações/número de conexões estão acessado a base de dados:'
    declare @tab varchar(20)
    declare @num varchar(2)
    declare tabs cursor for select hostname,count(*) from master.dbo.sysprocesses where dbid in ( select dbid from master.dbo.sysdatabases where name = @datab ) group by hostname
    open tabs
    fetch next from tabs into @tab,@num
    while(@@fetch_status=0)
    begin
        print @tab +'/'+@num
        fetch next from tabs into @tab,@num
    end
    close tabs
    deallocate tabs
end

C# - Estrutura

NameSapce

Classe

Metodo1

Comando

Comando

Metodo 2

Comando

Comando

C# - Exemplo Conexão BD (Macoratti)

http://www.macoratti.net/08/08/c_pdgv1.htm

C# - Exemplo Conexão BD

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

using System.Data.OleDb;





namespace Prophix___Controle_de_Saldos_e_Log_de_Execução

{

public partial class frmPrincipal : Form

{

// Variáveis Globais

string StringConexao, Senha;

SqlConnection Conexao;



public frmPrincipal()

{

InitializeComponent();

}



private void ConexaoBD_Open()

{

StringConexao = "Provider=sqloledb;Server=;Database=;User ID=RM;Password=;Trusted_Connection=False";

// Conexao = new SqlConnection(StringConexao);

}



private void Atualizar()

{

//SqlDataReader DadosDataHoraUltExec = QueryDtHoraUltExec.ExecuteReader();

OleDbConnection Conexao = new OleDbConnection(StringConexao);



//------------------------------------------------------------------//

//------------------------------------------------------------------//

// -- Aba "Data\Hora ----------------------------------------------//

//------------------------------------------------------------------//

//------------------------------------------------------------------//

string datahorainicial,

datahorafinal,

QueryDtHoraUltExecIni = "SELECT CONVERT(CHAR(10), DATAINICIAL, 103) + ' - '+CONVERT(CHAR(15), DATAINICIAL, 108) AS DATAINICIAL FROM ZRMPROPHIXLOGPROCESSOS WHERE PROCESSO = 0 AND PASSO = 0";



OleDbCommand SqlQueryDtHoraIni = new OleDbCommand(QueryDtHoraUltExecIni, Conexao);



SqlQueryDtHoraIni.CommandType = CommandType.Text;



OleDbDataAdapter DBAdapterQueryDtHoraIni = new OleDbDataAdapter(SqlQueryDtHoraIni);



DataTable QueryDadosDtHoraIni = new DataTable();



DBAdapterQueryDtHoraIni.Fill(QueryDadosDtHoraIni);



datahorainicial = Convert.ToString(QueryDadosDtHoraIni);



txtbDataHoraInicial.Text = datahorainicial;



//------------------------------------------------------------------//

//------------------------------------------------------------------//

// -- Aba "Data\Hora - Processos" ---------------------------------//

//------------------------------------------------------------------//

//------------------------------------------------------------------//

string QueryDtHoraUltExecProcesso = "SELECT * FROM ZRMPROPHIXLOGPROCESSOS";



OleDbCommand SqlQueryProcessos = new OleDbCommand(QueryDtHoraUltExecProcesso, Conexao);



SqlQueryProcessos.CommandType = CommandType.Text;



OleDbDataAdapter DBAdapterQueryProcessos = new OleDbDataAdapter(SqlQueryProcessos);



DataTable QueryDadosProcessos = new DataTable();



DBAdapterQueryProcessos.Fill(QueryDadosProcessos);



dataGridView1.DataSource = QueryDadosProcessos;





//, CONVERT(CHAR(10), DATAFINAL, 103) + ' - '+CONVERT(CHAR(15), DATAFINAL, 108) AS DATAFINAL

/*

DadosDataHoraUltExec.Read();



datahorainicial = (string)DadosDataHoraUltExec["DATAINICIAL"];

datahorafinal = (string)DadosDataHoraUltExec["DATAFINAL"];



txtbDataHoraInicial.Text = datahorainicial;

txtbDataHoraFinal.Text = datahorafinal;



DadosDataHoraUltExec.Close();



*/

}



private void Form1_Load(object sender, EventArgs e)

{

ConexaoBD_Open();

Atualizar();

}



private void textBox1_TextChanged(object sender, EventArgs e)

{

}



private void panel1_Paint(object sender, PaintEventArgs e)

{

}



private void tbUltExecProcessos_Click(object sender, EventArgs e)

{

}



private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)

{

}



private void dataGridView1_CellContentClick_1(object sender, DataGridViewCellEventArgs e)

{

}

}

}

C# - Consulta SQL com Parâmetros

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;



namespace waAlteraCodigo

{

public partial class Form1 : Form

{

// Variáveis Globais

string StringConexao, Senha;

SqlConnection Conexao;

int ColigadaSelecionada;



public Form1()

{

InitializeComponent();

}



private void ConexaoBD_Open()

{

StringConexao = "Server=;Database=;User ID=;Password=;Trusted_Connection=False";



Conexao = new SqlConnection(StringConexao);



Conexao.Open();

}



private void ConexaoBD_Close()

{

Conexao.Close();

}



private void Form1_Load(object sender, EventArgs e)

{

ConexaoBD_Open();



// Popula Combobox da Coligada

SqlCommand QueryColigada = new SqlCommand("SELECT CODCOLIGADA, NOMEFANTASIA FROM GCOLIGADA ORDER BY CODCOLIGADA", Conexao);



SqlDataReader DadosColigada = QueryColigada.ExecuteReader();



while (DadosColigada.Read())

{

cbboxCol.Items.Add(DadosColigada["CODCOLIGADA"] + " - " + DadosColigada["NOMEFANTASIA"]);

}



ConexaoBD_Close();

}



private void cbboxCol_SelectedIndexChanged(object sender, EventArgs e)

{

ColigadaSelecionada = cbboxCol.SelectedIndex;

}



private void cbboxIdlan_SelectedIndexChanged(object sender, EventArgs e)

{

}



private void cbboxCol_Click(object sender, EventArgs e)

{

}



private void cbboxCol_MouseClick(object sender, MouseEventArgs e)

{

}



private void cbboxIdlan_Click(object sender, EventArgs e)

{

ConexaoBD_Open();



// Popula Combobox do Idlan

SqlCommand QueryIdlan = new SqlCommand("SELECT IDLAN FROM FLAN WHERE CODCOLIGADA = @CODCOLIGADA", Conexao);



QueryIdlan.Parameters.Add(new SqlParameter("@CODCOLIGADA", cbboxCol.SelectedIndex));



SqlDataReader DadosIdlan = QueryIdlan.ExecuteReader();



while (DadosIdlan.Read())

{

cbboxIdlan.Items.Add(DadosIdlan["IDLAN"]);

}



ConexaoBD_Close();



}

}

}

C# - .NET - Dicas de Desenvolvimento

http://www.israelaece.com/

Dicas de Desenvolvimento

C# - Conexão Simples com BD

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;

namespace Prophix___Periodo
{
public partial class frmProphixPeriodo : Form
{
// Variáveis Globais
string StringConexao, Senha;
SqlConnection Conexao;

public frmProphixPeriodo()
{
InitializeComponent();
}

private void ConexaoBD_Open()
{
StringConexao = "Server=XX\XX;Database=;User ID=RM;Password=XX;Trusted_Connection=False";

Conexao = new SqlConnection(StringConexao);

Conexao.Open();
}

private void ConexaoBD_Close()
{
Conexao.Close();
}

private void Form1_Load(object sender, EventArgs e)
{
Senha = "rmenella";
dtpInicial.Value = DateTime.Now.Date;
dtpFinal.Value = DateTime.Now.Date;

ConexaoBD_Open();

SqlCommand QueryColigada = new SqlCommand("SELECT CODCOLIGADA, NOMEFANTASIA FROM GCOLIGADA ORDER BY CODCOLIGADA", Conexao);

SqlDataReader DadosColigada = QueryColigada.ExecuteReader();

while (DadosColigada.Read())
{
cbBox.Items.Add(DadosColigada["CODCOLIGADA"] + " - " + DadosColigada["NOMEFANTASIA"]);
}

ConexaoBD_Close();
}

private void btnExecutar_Click(object sender, EventArgs e)
{
int ColigadaSelecionada;
DateTime DataInicial, DataFinal;

DataInicial = dtpInicial.Value;
DataFinal = dtpFinal.Value;
ColigadaSelecionada = cbBox.SelectedIndex;
//label1.Text = Convert.ToString(ColigadaSelecionada);
lblStatus.Text = "EM EXECUÇÃO";

try
{
ConexaoBD_Open();
SqlCommand StoredProc = new SqlCommand("SP_INTEGRACAO_RM_PROPHIX_PERIODO", Conexao);
StoredProc.CommandType = CommandType.StoredProcedure;
StoredProc.Parameters.AddWithValue("@CODCOLIGADA", ColigadaSelecionada);
StoredProc.Parameters.AddWithValue("@DATAINICIAL", DataInicial);
StoredProc.Parameters.AddWithValue("@DATAFINAL", DataFinal);
StoredProc.Parameters.AddWithValue("@CODHISTP", "");
StoredProc.CommandTimeout = 1000;
StoredProc.ExecuteNonQuery();
lblStatus.Text = "EXECUTADO COM SUCESSO!";
}
catch (SqlException ErroSQL)
{
lblStatus.Text = ErroSQL.Message;
}
finally
{
ConexaoBD_Close();
}
}

private void maskedTextBox1_MaskInputRejected(object sender, MaskInputRejectedEventArgs e)
{
}

private void textBox1_TextChanged(object sender, EventArgs e)
{
}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
//label1.Text = Convert.ToString(cbBox.SelectedIndex);
}

private void frmProphixPeriodo_FormClosed(object sender, FormClosedEventArgs e)
{
}

private void maskedTextBox1_MaskInputRejected_1(object sender, MaskInputRejectedEventArgs e)
{
}

private void maskedTextBox1_TextChanged(object sender, EventArgs e)
{
if (mtbSenha.Text == Convert.ToString(Senha))
{
btnExecutar.Enabled = true;
}
else
{
btnExecutar.Enabled = false;
}
}

}
}

Microsoft - Diversas Modelos e Orientações de Desenvolvimento

http://msdn.microsoft.com/en-us/default

C# - Exemplos

http://www.mygenerationsoftware.com/portal/default.aspx

http://www.linhadecodigo.com.br/videos_dotnet/Default.aspx

C# - Desenvolvendo uma aplicação Windows MDI com C#

Site:

http://blog.thiagoapadua.com.br/?p=8

C# - Tecla Enter (modelo/exemplo)

private void txtResultado_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == 13) //ENTER pressionado
{
Executa_Calculo();
}
}

Blog - Ohashi

http://blog.ohashi.com.br/