tag:blogger.com,1999:blog-157956722023-03-18T08:30:05.745-03:00Fabio's BlogTecnologia - C#, ASP.net, SQL ...Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.comBlogger24125tag:blogger.com,1999:blog-15795672.post-22109066059835313712011-05-23T16:55:00.001-03:002011-05-23T16:55:24.014-03:00Excel retorna valores como NULL Usando OpenRecordset DAO<b>Ao se conectar a uma planilha do Excel usando o método DAO OpenRecordset, alguns valores em uma coluna do Excel podem ser retornados como nulo quando o valor subjacente não é um nulo. Isso normalmente ocorre quando tipos de dados numéricos e de texto são misturados dentro da mesma coluna do Excel.<br><br> Esse problema é causado por uma limitação do driver ISAM do Excel que, uma vez que determina o tipo de dados de uma coluna do Excel, ele irá retornar um valor nulo para qualquer valor que não é do tipo de dados do driver ISAM. O driver do Excel ISAM determina o tipo de dados de uma coluna do Excel, examinando os valores reais nos primeiros registros e, em seguida, escolhe um tipo de dados que representa a maioria dos valores em sua amostragem.<br><br> Você pode adicionar a opção IMEX = 1; Por exemplo:<br><br></b><pre class="csharp" name="code"> Set db = OpenDatabase ("C: \ Temp \ Book1.xls", _ False, True, "Excel 8.0; HDR = NO; IMEX = 1;")<br /></pre><b><br><br> Ambiente IMEX = 1 indica o driver para usar o modo de importação. Neste estado, a configuração do Registro ImportMixedTypes = texto vai ser notado. Este dado força a conversão dos dados em texto. Para que isso funcione de forma confiável, você também pode ter de alterar a configuração do registro, TypeGuessRows = 8. O driver ISAM por padrão olha para as primeiras oito linhas e de que a amostragem determina o tipo de dados. Se esta linha de amostragem é tudo numérico, em seguida, definindo IMEX = 1 não irá converter o tipo de dados padrão para texto, ele permanecerá numérico.<br><br> Você deve ter cuidado para que IMEX = 1 não ser usado indiscriminadamente. Este é o modo de importação, portanto, os resultados podem ser imprevisíveis se você tentar inserir ou atualizar de dados nesse modo.<br><br></b>Espero que tenha sido útil.<br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-25085246771742441202011-05-23T13:28:00.001-03:002011-05-23T13:28:21.478-03:00Session State timeout C#<b>Existem alguns sistemas que precisam de um timeout maior do estado da sessão, por exemplo alguns sistemas que os usuário deixam a janela aberta para efetuar outras rotinas e somente depois terminarem a tarefa no sistema, algumas vezes precisamos modificar o timeout de sessão dos nossos sistemas, o timeout padrão é de 20 minutos. Para configurarmos o timeout de sessão é só inserir a linha abaixo no web.config do nosso sistema dentro da tag <system.web>.<br><br></b><pre class="html" name="code"> <br /> ...<br /> < system.web ><br /> < sessionState timeout="60" ><br /> ...<br /></pre><b><br><br> No exemplo acima configurei minha aplicação com um timeout de sessão de 60 minutos.<br><br></b>Espero que tenha sido útil.<br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-7020480319714171152011-03-04T10:49:00.001-03:002011-03-04T10:50:07.080-03:00Erro de divisão por zero (Error divide by zero) C#<b>Erro de divisão por zero é muito comum na nossa área, ainda mais quando temos que fazer importações, ou efetuar cálculo através de dados digitados pelo usuários, abaixo a rotina para não haver esse incoveniente para o usuário ao preencher uma tela do sistema.<br><br><br></b><pre class="c#" name="code">int a = 0;<br>int b = 10;<br>int c = 0;<br><br>try <br>{<br> a = b / c;<br>}<br>catch (Exception e)<br>{<br> Console.WriteLine("A run-time error occurred.");<br>}<br>finally <br>{<br> Console.ReadLine();<br>}<br><br></pre><br><br>Espero que tenha sido útil.<br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-79466566219231145272011-03-03T12:55:00.001-03:002011-03-03T12:57:04.725-03:00Inserir espaços em branco ou zeros para códigos<b>Muitas vezes precisamos estabelecer em nosso códigos um certo número de casas para um campo, principalmente quando trabalhamos com geração de arquivo texto, muito utilizado para fazer importação de dados entre sistemas, abaixo coloco um código que gera esse tipo de resultado, segue:<br><br></b><pre class="c#" name="code">// Insere espaços em branco<br>public string Space(int nx)<br>{<br> string strret = "";<br> for (int i = 1; i <= nx; i++)<br> strret = strret + " ";<br><br> return strret;<br>}<br><br>// Insere Zeros em uma string<br>public string Zero(int nx)<br>{<br> string strret = "";<br> for (int i = 1; i <= nx; i++)<br> strret = strret + "0";<br><br> return strret;<br>}<br><br></pre><b>E a chamada para concatenar ou simplesmente preencher o campo:<br><br></b><pre class="c#" name="code">string v_cd_prod = Zero(9 - v_cd_prod.Length);<br><br></pre><b><br> No exemplo acima a variável v_cd_prod será carregada com 9 zeros.<br><br> Espero que tenha sido útil.<br></b><br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-84638153984719953962011-02-24T09:02:00.001-03:002011-02-24T09:02:42.947-03:00VERIFICA PERIODO ENTRE DATAS - JAVASCRIPTEsta função verifica um prazo entre datas na linguagem Javascript:<br><br><br><pre class="javascript" name="code"> // Declara as variáveis<br>var dtMin, dtMax<br>var strData, strPrzMin, strPrzMax<br>var aryData<br><br>// captura a data inicial<br>strDataIni = '<%= mid(now,1,2) & "/" & mid(now,4,2) & "/" & mid(now, 7,4)%>';<br>// captura a data final - No exemplo utilizaei um TextBox para digitar esta data<br>strDataFim = document.Form1.txtDataVencimento.value;<br>// Estipulo aqui um prazo mínimo<br>strPrzMin = 30;<br>// Estipulo aqui um prazo máximo<br>strPrzMax = 180;<br><br>// Efetua aqui o cálculo da diferença entre as datas inicial e final<br>var fim = new Date(strDataFim.split('/')[2], strDataFim.split('/')[1], strDataFim.split('/')[0]);<br>var inicial= new Date(strDataIni.split('/')[2], strDataIni.split('/')[1], strDataIni.split('/')[0]);<br>diferenca = ((Date.UTC((fim.getYear()),fim.getMonth(),fim.getDate(),0,0,0)-Date.UTC((inicial.getYear()),inicial.getMonth(),inicial.getDate(),0,0,0)) / 1000 / 60 / 60/ 24) -1;<br><br>// Verifico a diferença entre o prazo mínimo e máximo<br>if (diferenca < strPrzMin)<br>{<br> alert('O prazo mínimo para a Data de Vencimento é de 30 Dias');<br> document.Form1.txtDataVencimento.focus();<br> return;<br>}<br><br>if (diferenca > strPrzMax)<br>{<br> alert('O prazo máximo para a Data de Vencimento é de 180 Dias');<br> document.Form1.txtDataVencimento.focus();<br> return;<br>}<br></pre><br> Espero que tenha sido útil.<br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com1tag:blogger.com,1999:blog-15795672.post-66734561034480890772011-02-18T15:24:00.001-02:002011-02-18T15:24:34.052-02:00SQL Server. Habilitando SQL Authentication e o usuário 'sa'<span id="h4v3" style="font-style:normal;vertical-align:baseline"><font face="arial"><font color="#000000"><font size="3"><b>Um problema comum quando se utiliza o SQL Server é quando não é possível entrar com usuários SQL Server, exemplo o super usuário “sa”, pois durante a instalação foi configurado para Windows Authentication.</b></font></font></font></span><br><span style="font-style:normal;vertical-align:baseline"><font face="arial"><font color="#000000"><font size="3">Como mencionado em um post no Fórum do MSDN: “Criei a instância, criei senha para meu login, mais quando vou entrar pela autenticação do SQL SERVER, ele dá erro, já pela da autenticação do Windows ele dá certo…”</font></font></font></span><br><span style="font-style:normal;vertical-align:baseline"><font face="arial"><font color="#000000"><font size="3">Visto que não é possível ficar reinstalando o SQL Server, somente para trocar a autenticação de Windows Authentication para “Mixed” Authentication, segue neste post a solução para este problema.</font></font></font></span><br><span style="font-style:normal;vertical-align:baseline"><font face="arial"><font color="#000000"><font size="3">Primeiramente é necessário entrar no SQL Server utilizando o SQL Server Management Studio. Conforme a figura abaixo, estou conectando em uma instância do SQL Server 2008 Express utilizando a autenticação Windows Authentication, mas este exemplo funciona perfeitamente no SQL Server 2005 e nas edições superiores.<br></font></font></font></span><img height="270px;" src="https://lh3.googleusercontent.com/L7D4UpgLquhtwWV7HugF9suOIyAvqblW5oXSC3n5DBEIWprRz79mNH-cKFGzRE-KlQFwim7gq53E4KfeMa_dlm3qCk-ad6HLQLBVwvOL9EVIwfA2wA" width="364px;"><br><br><span style="font-style:normal;vertical-align:baseline"><font face="arial"><font color="#000000"><font size="3">Após conectar, clicando com o botão direito do mouse sobre a instância do SQL Server na janela Object Explorer (Atalho F8 ou Menu “View\Object Explorer”), item Properties.</font></font></font></span><img height="465px;" src="https://lh3.googleusercontent.com/zGhqfFzdlFhHM9VFD6Xi8JlfUasJb339fCMnuOkgRIC7T3w0xy00C9kVVEkfG4HXRhas38QSmJ3k2T8mR8Au49EDxU5o26eU3QML5NbSaKxyJxEe7Q" width="416px;"><br><br><span style="font-style:normal;vertical-align:baseline"><font face="arial"><font color="#000000"><font size="3">Nesta nova janela, na aba (“página”) Security, altere “Server authentication” para “SQL Server and Windows Authentication mode”.</font></font></font></span><img height="527" src="https://lh6.googleusercontent.com/IOqlosyZqCs9Ogyjy_crMlp4FXEfHq6hnn4xbePY255y0XvSfpmh0cnlWZBxlBMBCvX-1GPPtD_7K8KPV5a8uedcHhT2WeSgfhP25PCR3saWQUXodw" width="538"><br><br><span style="font-style:normal;vertical-align:baseline"><font face="arial"><font color="#000000"><font size="3">Feito isso, uma janelinha informará que para esta alteração ter efeito, será necessário que o serviço do SQL Server deve ser reiniciado. Mas isso pode ser feito depois, quando for terminada a configuração dos usuários do SQL Server, então deixe para depois.<br></font></font></font></span><img height="106px;" src="https://lh5.googleusercontent.com/b1sODCMOF4zipRGRIdBH_vh-2uVYyw681XMdrWK22OAzD62Y6f5srxwjbTsneLa3TQzSrhroUc7CimuEZqouIunRZiYI9i3_31eX4OGxdu_udna9GA" width="511px;"><br><br><span style="font-style:normal;vertical-align:baseline"><font face="arial"><font color="#000000"><font size="3">Continuando na janela Object Explorer, expandindo a instância, “folder” Security\Logins, pode ser criado novos usuários do SQL Server ou seguindo o objetivo inicial deste tópico, habilitar o usuário “sa”. <br>Conforme a figura abaixo, botão direito sobre o login “sa”, menu Properties.<br></font></font></font></span><img height="520px;" src="https://lh6.googleusercontent.com/U3RnS2GfpZ0R3rlUg7EV5UMjoHbWjVJNxONMHneDZHNFZBTvaqbH_5OsoklEdFf1r1-q2A8rp-7EKSp8giD6fJt6K25vdpIDm9X-QMBaIgiy1YRP8Q" width="369px;"><br><br><span style="font-style:normal;vertical-align:baseline"><font face="arial"><font color="#000000"><font size="3">Na nova janela, altere o password do usuário, também é possível alterar o “idioma” e o banco de dados padrão deste usuário nesta janela, entre outras funcionalidades.<br><br></font></font></font></span><img height="550" src="https://lh4.googleusercontent.com/rnmJ3omoBycu_M3X-6qNQlmxiQ4ULYBqtan_JOLyYu2maOd0n7pERZkGK9jR-vEwpDoshDJwKv0IVH4QixBf9VvxahAkPpoJs_0YvN1LX5H0Ey6kDQ" width="561"><br><br><span style="font-style:normal;vertical-align:baseline"><font face="arial"><font color="#000000"><font size="3">Na aba (“página”) Status, clique na opção “Grant” em “Permission to connect to database engine” e “Enable” em “Login”.<br><br></font></font></font></span><img height="563" src="https://lh6.googleusercontent.com/A1m5R8OuVBWUxu16C3ijKzZw1RhPcU7dMkrdjxf9VZQl1WJb2z_ERFaHZRnP0Ipr7UWHbYDsSKmhFPBjdZj5q5nskrmDuU_JfNoBbPCfZtjUsMQujQ" width="574"><br><br><span style="font-style:normal;vertical-align:baseline"><font face="arial"><font color="#000000"><font size="3">Outra maneira pratica de habilitar o usuário “sa” é por meio de script, exemplo:</font></font></font></span><br><p style="margin:0pt 5pt"><span style="font-style:normal;vertical-align:baseline"><font face="arial"><font color="#ffffff"><font style="background-color:#000000"><font size="3"><b>ALTER LOGIN sa ENABLE;</b></font></font></font></font></span></p><p style="margin:0pt 5pt"><span style="font-style:normal;vertical-align:baseline"><font face="arial"><font color="#ffffff"><font style="background-color:#000000"><font size="3"><b>GO</b></font></font></font></font></span></p><p style="margin:0pt 5pt"><span style="font-style:normal;vertical-align:baseline"><font face="arial"><font color="#ffffff"><font style="background-color:#000000"><font size="3"><b>ALTER LOGIN sa WITH PASSWORD = 'P@ssw0rdM0del0';</b></font></font></font></font></span></p><p style="margin:0pt 5pt"><span style="font-style:normal;vertical-align:baseline"><font face="arial"><font color="#ffffff"><font style="background-color:#000000"><font size="3"><b>GO </b></font></font></font></font></span></p><span style="font-style:normal;vertical-align:baseline"><font face="arial"><font color="#000000"><font size="3"><b>Então, agora resta reiniciar o SQL Server. Para não ter que entrar nos Serviços do Windows ou SQL Server Configuration Manager ou qualquer variante como arquivos .bat ou SQL Server Surface Area.<br><br></b></font></font></font></span><span style="font-style:normal;vertical-align:baseline"><font face="arial"><font color="#000000"><font size="3">Uma dica é clicar com o botão direito na instância do SQL Server na janela Object Explorer e “Restart”.<br></font></font></font></span><img height="430px;" src="https://lh3.googleusercontent.com/0eY2LDr83SigVq444f1FYaHxHpPxAdPi21C0SdPrQv_2o8EdJ3xr9-eN6kZ-bLqymVyjenfixY-9wj9G-tTUU01iXqAuAExdo_3zceiAXNZrxzmMgw" width="333px;"><br><br><span style="font-style:normal;vertical-align:baseline"><font face="arial"><font color="#000000"><font size="3">Clique em Yes nesta próxima janelinha, para dizer que você TEM CERTEZA QUE QUER REINICIAR O SERVIÇO…<br></font></font></font></span><img height="106px;" src="https://lh5.googleusercontent.com/S-YSeQhxO0AGfWwxGLv5f7uSXHTO_8hcvBy62ZqsKLHgfGFz9DOVDUzSV_ThEhc6J9jpleQAyzcfF2joU-xuADIFZOiV6T8LfbRPHdqejXNrH9zCmg" width="508px;"><br><br><br><span style="font-style:normal;vertical-align:baseline"><font face="arial"><font color="#000000"><font size="3">Agora é só conectar com o usuário “sa” para testar.<br><br></font></font></font></span><img height="279px;" src="https://lh4.googleusercontent.com/xc4leSH3oYu_gl8O90bCOvj7KG9R-rRUBBUWOFbFr6Hf9T17mouPwr-tzExHA8LiPVb62c8FP7ifO65Jj24JJv2en1I53y_fNdH3F0IBt1-uuwfiRA" width="376px;"><br><br><br><br><br><br>Espero que tenha sido útil.<br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-89496028751615328362011-02-17T14:36:00.001-02:002011-02-17T14:39:31.905-02:00Waitfor Delay, waitfor time SQL ServerQuando temos problemas de performance com algumas aplicações a maior dificuldade é fazermos acontecer o erro em nosso ambiente.<br> <br> O comando waitfor do SQL Server é muito útil para este tipo de teste, pois utilizamos o <b>waitfor delay</b> ou o<b> waitfor time </b>na procedure e efetuamos o teste de timeout, etc.<br><br> Abaixo o comando:<br><br><br><pre class="sql" name="code">-- Utilizado para esperar pelo tempo passado como parâmetro<br>-- No exemplo abaixo ele passa pelo waitfor depois de 5 segundos<br>waitfor delay '00:00:05'<br><br>-- Utilizado para esperar até que a hora seja alcançada<br>-- No exemplo abaixo ele passa pelo waitfor as quatorze horas e trinta e oito minutos<br>waitfor time '14:38'<br></pre><br> Espero que tenha sido útil.<br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-91589251599698789912011-01-12T09:23:00.001-02:002011-01-12T10:17:10.806-02:00Métodos IndexOf e IndexOfAny de uma string<b>Esses métodos são muito úteis quando precisamos procurar um ou vários caracteres dentro de uma string, por exemplo, em uma string você têm que saber se existe o número 1, você usa o IndexOf para fazer esta verificação, e o retorno será a posição do primeiro caracter que o método encontrar.<br><br> Segue o exemplo do IndexOf.<br><br></b><pre class="c#" name="code">string v_str = "www.fabiorente.blogspot.com";<br />if (v_str.IndexOf('.') > -1)<br />{<br /> // Caracter '.' encontrado<br />}<br />else<br />{<br /> // Caracter '.' não encontrado<br />}<br /></pre><b><br> Segue o exemplo do IndexOfAny.<br><br></b><pre class="c#" name="code">string v_str = "www.fabiorente.blogspot.com";<br />char[] chars = { '0', '1' , '2' , '3' , '4' , '5' , '6' , '7' , '8' , '9' };<br />if (v_str.IndexOfAny(chars) > -1)<br />{<br /> // Existe Número<br />}<br />else<br />{<br /> // Não Existe Número<br />}<br /></pre><br>Espero que tenha sido útil.<br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-87595431234781112422010-12-22T12:44:00.001-02:002011-01-08T00:10:50.868-02:00Abrindo uma aplicação e passando parâmetros cm C# - Windows FormsDica para quando existe a necessidade de abrir uma aplicação pelo c# e passar os parâmetros necessários para esta aplicação.<br><br> Utilização das Classes <font color="#45818e">Process </font>e <font color="#45818e">ProcessStartInfo</font>.<b><br><br> <br></b><p></p><pre class="c#" name="code">Process p = new Process();<br>p.EnableRaisingEvents = false;<br>p.StartInfo.WorkingDirectory = @"C:\Program Files\";<br>p.StartInfo.CreateNoWindow = false;<br>p.StartInfo.WindowStyle = ProcessWindowStyle.Minimized;<br>ProcessStartInfo startInfo = new ProcessStartInfo(@"C:\Program Files\Calc.exe", @"C:\Program Files\ww.txt");<br>System.Diagnostics.Process.Start(startInfo);<br></pre><br>Espero que tenha sido útil.<br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com2tag:blogger.com,1999:blog-15795672.post-61528096249222850082010-12-02T08:37:00.001-02:002011-01-08T00:21:48.990-02:00Data Inicial e Final de uma semana a partir da data atualDica de SQL para calcular a Data Inicial e Final de uma semana a partir da data atual.<br><br><pre class="sql" name="code">--inicial<br />select convert(varchar,year(convert(varchar,getdate()-(datepart(dw,getdate())-1),20))) + '-' + right('00'+convert(varchar,month(convert(varchar,getdate()-(datepart(dw,getdate())-1),20))),2) + '-' + right('00'+convert(varchar,day(convert(varchar,getdate()-(datepart(dw,getdate())-1),20))),2) + '-' + ' 00:00'<br /> --final<br />select convert(varchar,year( convert(varchar,getdate()+7-atepart(dw,getdate())),20))) + '-' +right('00'+convert(varchar,month( convert(varchar,getdate()+(7-datepart(dw,getdate())),20))),2) + '-' + right('00'+convert(varchar,day( convert(varchar,getdate()+(7-datepart(dw,getdate())),20))),2) + '-' + ' 23:59'<br /></pre><br>Espero que tenha sido útil.<br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-6129136350267680682010-11-12T10:17:00.001-02:002011-01-08T07:42:36.185-02:00Definindo valores para uma coluna Identity<p class="Sub" style="margin:0cm 0cm 12pt"></p><p class="Corpo" style="margin:0cm 0cm 0pt"><font color="black"><font face="Verdana" size="2">Frequentemente tenho que fazer carregamento de dados para fazer testes ou alguma alteração no sistema, e carregamos dados próximos os dados de produção, ai encontramos tabelas com coluna de IDENTITY e nos deparamos com o erro abaixo:</font></font></p><p class="Corpo" style="margin:0cm 0cm 0pt"><br></p><p class="Corpo" style="margin:0cm 0cm 0pt"><font size="2"><font color="#ff0000">Msg 544, Level 16, State 1, Line 1</font><br style="color:#ff0000"><font color="#ff0000">Cannot insert explicit value for identity column in table 'TB_AGRI_CART_CLIE_STAT' when IDENTITY_INSERT is set to OFF.</font><br><br> Este erro ocorre por causa da coluna identity, não podemos especificar um valor para esta coluna, quem especifica é o próprio SQL, mas, para este caso podemos utilizar o comando <font color="#0000ff">IDENTITY_INSERT <font color="#000000">que "libera</font></font>" a inclusão de dados para esta coluna. Segue abaixo:</font></p><p class="Corpo" style="margin:0cm 0cm 0pt"><font size="2"><br></font></p><p class="Interttulo" style="margin:8.5pt 0cm"><b><font color="black"><font face="Verdana" size="2">O comando Identity_Insert</font></font></b></p><p class="Corpo" style="margin:0cm 0cm 0pt"><font color="black"><font face="Verdana" size="2">A solução é bem simples. Quando você precisar inserir alguma linha e forçar o valor da coluna Identity, utilize os comandos:</font></font></p><p class="Corpo" style="margin:0cm 0cm 0pt"><font color="black"><font face="Verdana" size="2">Antes de inserir, execute o comando:</font></font></p><p class="Cdigo" style="margin:0cm 0cm 0pt"><b><font color="#000080" face="Courier New" size="2">SET IDENTITY_INSERT nome_da_tabela ON</font></b></p><p class="Corpo" style="margin:0cm 0cm 0pt"><b> </b></p><p class="Corpo" style="margin:0cm 0cm 0pt"><font color="black"><font face="Verdana" size="2">Depois de inserido, retorne o autoidentity novamente:</font></font></p><p class="Cdigo" style="margin:0cm 0cm 0pt"><b><font color="#000080" face="Courier New" size="2">SET IDENTITY_INSERT nome_da_tabela OFF</font></b></p><p class="Interttulo" style="margin:8.5pt 0cm"><b><font color="black"><font face="Verdana" size="2">Um exemplo prático</font></font></b></p><p class="Corpo" style="margin:0cm 0cm 0pt"><font color="black"><font face="Verdana" size="2">Copie todo o conteúdo do código abaixo, no Query Analyzer e execute instrução por instrução para entender o funcionamento. Para evitar a necessidade de criar uma nova tabela em algum banco de dados, note que fiz uso de uma tabela temporária para o exemplo.</font> </font></p><p class="Interttulo" style="margin:8.5pt 0cm"><b><font color="black"><font face="Verdana" size="2">Exemplo</font></font></b></p><p class="Interttulo" style="margin:8.5pt 0cm"></p><pre class="sql" name="code">-- O simbolo # antes do nome da tabela, indica que ela é uma Tabela Temporária<br><br>create table #testing<br>(<br> ID int not null IDENTITY, -- Coluna do tipo Identity<br> nome varchar(20) null<br>)<br><br>-- Insira algumas linhas apenas para teste:<br>-- Note que a coluna ID não são informadas, mesmo que Not Null.<br><br>-- Isso porque a diretiva IDENTITY se encarrega de preencher o valor<br>Insert #testing values ('Fábio')<br>Insert #testing values ('Luiz')<br><br>-- Veja os valores na tabela:<br>Select * from #testing<br><br>-- Tente inserir um valor de Identity:<br>Insert #testing (ID, nome) values (10, 'Moroni') -- Retorna Erro...<br><br>-- Execute o comando IDENTITY_INSERT ON:<br>Set IDENTITY_INSERT #testing ON<br><br>-- Agora tente inserir novamente:<br>Insert #testing (ID, nome) values (10, 'Moroni') -- Sem Erro...<br><br>-- Veja agora os valores na tabela (inclusive o último item):<br>Select * from #testing<br><br>-- Execute o comando IDENTITY_INSERT OFF:<br>Set IDENTITY_INSERT #testing OFF<br><br>-- Agora tente inserir novamente um valor na coluna ID:<br>Insert #testing (ID, nome) values (20, 'Moroni') -- Retorna Erro...<br><br>-- Vamos excluir a tabela criada<br>drop table #testing<br></pre><br><p class="BoxTitulo" style="margin:0cm 0cm 0pt"></p><p class="Interttulo" style="margin:8.5pt 0cm"><b><font color="black"><font face="Verdana" size="2">Conclusão</font></font></b></p><p class="Corpo" style="margin:0cm 0cm 0pt"><font color="black"><font face="Verdana" size="2">Este recurso é muito útil em determinadas situações (normalmente quando dados precisam ser corrigidos no banco de dados), porém não deve de maneira nenhuma ser utilizado em um processo de produção. Faça uso deste recurso como uma ferramenta de desenvolvimento.</font></font></p><br> Espero que tenha sido útil.<br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-86466865656891523862010-11-05T14:45:00.001-02:002011-01-08T07:45:11.143-02:00Formatação de Datas em SQL ServerFormatação de Datas em SQL Server.<br><br> Segue abaixo:<br><br><pre class="sql" name="code">SELECT CONVERT(VARCHAR(12),GETDATE(),101) AS '101',<br />CONVERT(VARCHAR(12),GETDATE(),102) AS '102',<br />CONVERT(VARCHAR(12),GETDATE(),103) AS '103',<br />CONVERT(VARCHAR(12),GETDATE(),104) AS '104',<br />CONVERT(VARCHAR(12),GETDATE(),105) AS '105',<br />CONVERT(VARCHAR(12),GETDATE(),106) AS '106',<br />CONVERT(VARCHAR(12),GETDATE(),107) AS '107',<br />CONVERT(VARCHAR(12),GETDATE(),108) AS '108',<br />CONVERT(VARCHAR(12),GETDATE(),109) AS '109',<br />CONVERT(VARCHAR(12),GETDATE(),110) AS '110',<br />CONVERT(VARCHAR(12),GETDATE(),111) AS '111',<br />CONVERT(VARCHAR(12),GETDATE(),112) AS '112',<br />CONVERT(VARCHAR(12),GETDATE(),113) AS '113',<br />CONVERT(VARCHAR(12),GETDATE(),114) AS '114',<br />CONVERT(VARCHAR(12),GETDATE(),120) AS '120',<br />CONVERT(VARCHAR(12),GETDATE(),121) AS '121'<br /></pre><br> Espero que tenha sido útil.<br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-18069710749608899582010-10-29T08:50:00.001-02:002011-01-08T07:47:22.769-02:00Usando javascript para percorrer Repeater<a id="344919968025606385" name="344919968025606385"></a>Precisava de uma função em javascript para percorrer um repeater, neste repeater têm caixas de texto, precisava verificar todas e mostrar uma mensagem ao usuário, segue abaixo a função, chamei-a no botão da seguinte maneira.<br><br> btn.<font color="#660000">OnClientClick </font>= <font color="#660000">"return GetAllTextBox();"</font>;<br><br> E a função:<br><br><pre class="javascript" name="code">function GetAllCheckBox()<br />{<br />var count = 0;<br />var inputs = document.getElementsByTagName('input');<br />for(var i = 0; i < inputs.length; i++)<br />{<br /> if(inputs[i].type == 'text' && inputs[i].name.indexOf('tbx_id') != -1)<br /> {<br /> if(inputs[i].checked == true)<br /> {<br /> count++;<br /> break;<br /> }<br /> }<br />}<br /><br />if(count == 0)<br /> return false;<br />return true;<br />}<br /><br /></pre><br> Desta maneira se não retornar true ao nosso botão, não é chamado o código do code-behind, e não efetuará o postback.<br><br> Espero que tenha sido útil.<br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-31327708481895233282010-09-11T20:06:00.001-03:002010-09-22T10:20:08.869-03:00ComboBox - C#<div><font size="2">Controles que utilizaremos:</font> <font size="2"><b style="color:#45818e">DropDownList</b>, <b style="color:#45818e">RequiredFieldValidator</b>, <b style="color:#45818e">Button</b></font><font color="#000000" size="2">,</font><font size="2"> <b style="color:#45818e">Label</b> e <b style="color:#45818e">ValidationSummary</b>.</font><br><br><font size="2">Estarei neste post mostrando como criar um combobox em C#, para o meu projeto darei o nome de ComboBox e a página ASPX de Default.aspx.<br>Vamos utilizar as principais propriedades </font><font color="#000000" size="2">destes </font><font size="2">controles para fazer as validações necessárias.<br><b><br></b>Primeiro vamos criar o combo na nossa página ASPX, utilizaremos muito código HTML, por isso você têm que ter um bom nível de conhecimento nessa linguagem.<br><br>Segue abaixo o código da página ASPX.</font><br><b><br></b><table border="1" bordercolor="#000000" cellpadding="3" cellspacing="0" id="hdx1" width="100%"><tbody><tr><td valign="top" width="1%"><br></td><td valign="top" width="99%"><p><font size="2"><span style="background:none repeat scroll 0% 0% yellow"><font face=""courier new""><%</font></span></font><font face=""courier new"" size="2"><font color="#0000ff">@</font></font><font face=""courier new"" size="2"> <font color="#a31515">Page</font> <font color="#ff0000">Language</font><font color="#0000ff">="C#"</font> <font color="#ff0000">AutoEventWireup</font><font color="#0000ff">="true"</font> <font color="#ff0000">CodeBehind</font><font color="#0000ff">="Default.aspx.cs"</font> <font color="#ff0000">Inherits</font><font color="#0000ff">="ComboBox._Default"</font> <span style="background:none repeat scroll 0% 0% yellow">%></span></font></p><p><font face=""courier new"" size="2"><font color="#0000ff"><!</font></font><font face=""courier new"" size="2"><font color="#a31515">DOCTYPE</font></font><font face=""courier new"" size="2"> <font color="#ff0000">html</font> <font color="#ff0000">PUBLIC</font> <font color="#0000ff">"-//W3C//DTD XHTML 1.0 Transitional//EN"</font> <font color="#0000ff">"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"></font></font></p><p><font face=""courier new"" size="2"><font color="#0000ff"><</font></font><font face=""courier new"" size="2"><font color="#a31515">html</font></font><font face=""courier new"" size="2"> <font color="#ff0000">xmlns</font><font color="#0000ff">="http://www.w3.org/1999/xhtml"</font> <font color="#0000ff">></font></font></p><p><font face=""courier new"" size="2"><font color="#0000ff"><</font></font><font face=""courier new"" size="2"><font color="#a31515">head</font></font><font face=""courier new"" size="2"> <font color="#ff0000">runat</font><font color="#0000ff">="server"></font></font></p><p style="margin-left:40px"><font face=""courier new"" size="2"><font color="#0000ff"><</font><font color="#a31515">title</font><font color="#0000ff">></font>ComboBox<font color="#0000ff"></</font><font color="#a31515">title</font><font color="#0000ff">></font></font></p><p><font face=""courier new"" size="2"><font color="#0000ff"></</font></font><font face=""courier new"" size="2"><font color="#a31515">head</font></font><font face=""courier new"" size="2"><font color="#0000ff">></font></font></p><font face=""courier new"" size="2"><font color="#0000ff"><</font></font><font face=""courier new"" size="2"><font color="#a31515">body</font></font><font face=""courier new"" size="2"><font color="#0000ff">></font></font><font size="2"><br></font><div style="margin-left:40px"><font face=""courier new"" size="2"><font color="#0000ff"><</font></font><font face=""courier new"" size="2"><font color="#a31515">form</font></font><font face=""courier new"" size="2"> <font color="#ff0000">id</font><font color="#0000ff">="form1"</font> <font color="#ff0000">runat</font><font color="#0000ff">="server"></font></font><font size="2"><br></font></div><div style="margin-left:80px"><font face=""courier new"" size="2"><font color="#0000ff"><</font></font><font face=""courier new"" size="2"><font color="#a31515">asp</font></font><font face=""courier new"" size="2"><font color="#0000ff">:</font></font><font face=""courier new"" size="2"><font color="#a31515"> ScriptManager</font></font><font face=""courier new"" size="2"> <font color="#ff0000">ID</font><font color="#0000ff">="ScriptManager1"</font> <font color="#ff0000">runat</font><font color="#0000ff">="server"</font> <font color="#0000ff">/></font></font><font size="2"><br></font></div><div style="margin-left:40px"><div style="margin-left:40px"><font face=""courier new"" size="2"><font color="#0000ff"><</font></font><font face=""courier new"" size="2"><font color="#a31515">div</font></font><font face=""courier new"" size="2"><font color="#0000ff">></font></font><font size="2"><br></font></div><p style="margin-left:80px"><font face=""courier new"" size="2"><font color="#0000ff"><</font></font><font face=""courier new"" size="2"><font color="#a31515">asp</font></font><font face=""courier new"" size="2"><font color="#0000ff">:</font></font><font face=""courier new"" size="2"><font color="#a31515">DropDownList</font></font><font face=""courier new"" size="2"> <font color="#ff0000">id</font><font color="#0000ff">="cbo_mes"</font> <font color="#ff0000">runat</font><font color="#0000ff">="server"</font> <font color="#ff0000">Width</font><font color="#0000ff">="150"></</font><font color="#a31515">asp</font><font color="#0000ff">:</font><font color="#a31515">DropDownList</font><font color="#0000ff">></font></font></p><div style="margin-left:40px"><div style="margin-left:40px"><font face=""courier new"" size="2"><font color="#0000ff"><</font></font><font face=""courier new"" size="2"><font color="#a31515">asp</font></font><font face=""courier new"" size="2"><font color="#0000ff">:</font></font><font face=""courier new"" size="2"><font color="#a31515">RequiredFieldValidator</font></font><font face=""courier new"" size="2"> <font color="#ff0000">id</font><font color="#0000ff">="vld_rqd_cbo_mes"</font> <font color="#ff0000">runat</font><font color="#0000ff">="server"</font> <font color="#ff0000">Display</font><font color="#0000ff">="Dynamic"</font> <font color="#ff0000">ControlToValidate</font><font color="#0000ff">="cbo_mes"</font> <font color="#ff0000">SetFocusOnError</font><font color="#0000ff">="true"></font></font><font size="2"><br></font></div><p style="margin-left:80px"><font face=""courier new"" size="2"><font color="#0000ff"><</font></font><font face=""courier new"" size="2"><font color="#a31515">IMG</font></font><font face=""courier new"" size="2"> <font color="#ff0000">id</font><font color="#0000ff">="img_cbo_mes"</font> <font color="#ff0000">src</font><font color="#0000ff">="../_imagens/validator.gif"</font> <font color="#ff0000">style</font><font color="#0000ff">="cursor: help;"</font> <font color="#ff0000">runat</font><font color="#0000ff">="server"</font> <font color="#0000ff">/></font></font></p><p style="margin-left:40px"><font face=""courier new"" size="2"><font color="#0000ff"></</font></font><font face=""courier new"" size="2"><font color="#a31515">asp</font></font><font face=""courier new"" size="2"><font color="#0000ff">:</font></font><font face=""courier new"" size="2"><font color="#a31515">RequiredFieldValidator</font></font><font face=""courier new"" size="2"><font color="#0000ff">></font></font></p><div style="margin-left:40px"><font face=""courier new"" size="2"><font color="#0000ff"><</font></font><font face=""courier new"" size="2"><font color="#a31515">asp</font></font><font face=""courier new"" size="2"><font color="#0000ff">:</font></font><font face=""courier new"" size="2"><font color="#a31515">Button</font></font><font face=""courier new"" size="2"> <font color="#ff0000">ID</font><font color="#0000ff">="btn_sele"</font> <font color="#ff0000">runat</font><font color="#0000ff">="server"</font> <font color="#ff0000">Text</font><font color="#0000ff">="Selecionar"</font> <font color="#ff0000">CausesValidation</font><font color="#0000ff">="true"</font> <font color="#0000ff">/></font></font><font size="2"><br></font></div><div style="margin-left:40px"><font face=""courier new"" size="2"><font color="#0000ff"><</font></font><font face=""courier new"" size="2"><font color="#a31515">asp</font></font><font face=""courier new"" size="2"><font color="#0000ff">:</font></font><font face=""courier new"" size="2"><font color="#a31515">Label</font></font><font face=""courier new"" size="2"> <font color="#ff0000">ID</font><font color="#0000ff">="lbl_mes"</font> <font color="#ff0000">runat</font><font color="#0000ff">="server"></</font><font color="#a31515">asp</font><font color="#0000ff">:</font><font color="#a31515">Label</font><font color="#0000ff">></font></font><font size="2"><br></font></div></div><p style="margin-left:40px"><font face=""courier new"" size="2"><font color="#0000ff"></</font></font><font face=""courier new"" size="2"><font color="#a31515">div</font></font><font face=""courier new"" size="2"><font color="#0000ff">></font></font></p><p style="margin-left:40px"><font size="2"><font face=""courier new""><font color="#0000ff"><font size="2"><</font></font></font><font face=""courier new""><font color="#a31515"><font size="2">asp</font></font></font><font face=""courier new""><font color="#0000ff"><font size="2">:</font></font></font><font face=""courier new""><font color="#a31515"><font size="2">ValidationSummary</font></font></font><font face=""courier new""><font size="2"> <font color="#ff0000">ID</font><font color="#0000ff">="vld_sum"</font> <font color="#ff0000">runat</font><font color="#0000ff">="server"</font> <font color="#ff0000">EnableViewState</font><font color="#0000ff">="False"</font> <font color="#ff0000">HeaderText</font><font color="#0000ff">="Atenção:"</font> <font color="#ff0000">ShowMessageBox</font><font color="#0000ff">="True"</font> <font color="#ff0000">ShowSummary</font><font color="#0000ff">="False"</font> <font color="#0000ff">/></font></font></font><br></font></p></div><div style="margin-left:40px"><font size="2"><font face=""courier new""><font color="#0000ff"></</font></font><font face=""courier new""><font color="#a31515">form</font></font><font face=""courier new""><font color="#0000ff">></font></font><br></font></div><p><font face=""courier new"" size="2"><font color="#0000ff"></</font></font><font face=""courier new"" size="2"><font color="#a31515">body</font></font><font face=""courier new"" size="2"><font color="#0000ff">></font></font></p><p><font face=""courier new"" size="2"><font color="#0000ff"></</font></font><font face=""courier new"" size="2"><font color="#a31515">html</font></font><font face=""courier new"" size="2"><font color="#0000ff">></font></font></p></td></tr></tbody></table><br><font size="2">Vamos as explicações das principais propriedades:</font><br><br> As propriedade <font size="2"><font color="#ff0000">id</font> </font>e <font size="2"><font color="#ff0000">runat</font> </font>serão utilizadas em todos os controles de nossa aplicação<br> <font size="2">Propriedade </font><font size="2"><font color="#ff0000">id</font> - Especifica o nome do controle.</font><br></div><font size="2"> Propriedade </font><font size="2"><font color="#ff0000">runat</font> - Especifica que este controle deve ser tratado do lado servidor.</font><br><font size="2"><br> Controle<font color="#a31515"> asp</font></font><font size="2"><font color="#0000ff">:</font></font><font size="2"><font color="#a31515">DropDownList</font> - Este é o controle combo box, com ele podemos oferecer ao usuário uma lista de dados, para o usuário fazer o selecionamento de apenas um.</font><font size="2"> <br></font><div style="margin-left:40px"><font size="2">Propriedade </font><font size="2"><font color="#ff0000">Width</font> - Especifica o tamanho do controle no navegador.</font><br></div><font size="2"><br></font><div><font size="2"> Controle </font><font size="2"><font color="#a31515">asp</font></font><font size="2"><font color="#0000ff">:</font></font><font size="2"><font color="#a31515">RequiredFieldValidator</font> - Controle de validação, como ele podemos validar um controle sem ser necessário a inclusão de uma função javascript.</font></div><div style="margin-left:40px"><font size="2">Propriedade </font><font size="2"><font color="#ff0000">Display <font color="#000000">- Especifica o modo como será tratado o erro.</font></font>Statico, Dinâmico ou nenhum.<br>Propriedade <font size="2"><font color="#ff0000">ControlToValidate</font></font> - Especifica o controle que será validado.<br>Propriedade <font size="2"><font color="#ff0000">SetFocusOnError<font color="#000000"> - Propriedade se setada true, depois do erro é setado o foco no controle que está sendo validado.<br><br></font></font></font></font></div><font size="2"><font color="#000000"> Controle <font size="2"><font color="#a31515">IMG</font></font> - Este controle HTML está dentro da tag do controle <font size="2"><font color="#a31515">asp</font></font><font size="2"><font color="#0000ff">:</font></font><font size="2"><font color="#a31515">RequiredFieldValidator</font></font>, toda vez que ocorre o erro da validação é mostrado esta imagem.</font></font><br><div style="margin-left:40px"><font size="2"><font size="2"><font color="#000000">Propriedade <font size="2"><font color="#ff0000">src<font color="#000000"> - Especifica a imagem que será mostrada.<br>Propriedade <font size="2"><font color="#ff0000">style</font></font> - Estilo que mostra a imagem de interrogação quando passar o mouse.<br></font></font></font></font></font><br></font></div><font size="2"> Controle <font size="2"><font color="#a31515">asp</font></font><font size="2"><font color="#0000ff">:</font></font><font size="2"><font color="#a31515">Button</font></font> - Controle que fará a ação para ser processado a validação do nosso combo.</font><br><div style="margin-left:40px"><font size="2">Propriedade <font size="2"><font color="#ff0000">Text</font></font> - Especifica o texto que aparecerá no botão<br>Propriedade <font size="2"><font color="#ff0000">CausesValidation</font></font> - Especifica se o botão fará a validação dos controle na tela. Se estiver com o valor <font color="#0000ff">false <font color="#000000">não será feito nenhuma validação na tela.<br><br></font></font></font></div><font size="2"> <font color="#000000">Controle </font><font size="2"><font color="#a31515">asp</font></font><font size="2"><font color="#0000ff">:</font></font><font size="2"><font color="#a31515">Label <font color="#000000">- Controle que será mostrado o valor selecionado no combo quando precionarmos o botão.</font></font></font></font><br><br><br> Controle <font color="#a31515"><font size="2">asp</font></font><font color="#0000ff"><font size="2">:</font></font><font color="#a31515"><font size="2">ValidationSummary<font color="#000000"> - Controle que faz a validação e mostra no erro a janela em javascript.</font></font></font><br><div style="margin-left:40px"><font size="2">Propriedade <font size="2"><font color="#ff0000">EnableViewState</font></font> - Habilita o ViewState do controle na página ou não.<br>Propriedade <font size="2"><font color="#ff0000">HeaderText</font></font> - Especifica o título da janela para os campos requeridos.<br>Propriedade <font size="2"><font color="#ff0000">ShowMessageBox</font></font> - Especifica se o controle mostrará a janela ao ocorrer o erro ou não.<br>Propriedade <font size="2"><font color="#ff0000">ShowSummary</font></font> - Especifica se o erro será mostrado como sumário ao usuário.<br></font></div><br> Aqui é o final da criação da nossa página aspx, o próximo passo será feito em nosso code behind.<br><br> Abaixo como deverá ficar o código.<br><br> <table border="1" cellpadding="3" cellspacing="0" id="v1el" width="100%"><tbody><tr><td valign="top" width="1%"><br></td><td valign="top" width="99%"><p><font face=""courier new""><font color="#0000ff"><font size="2">using</font></font></font><font face=""courier new""><font size="2"> System;</font></font></p><p><font face=""courier new""><font color="#0000ff"><font size="2">using</font></font></font><font face=""courier new""><font size="2"> System.Data;</font></font></p><p><font face=""courier new""><font color="#0000ff"><font size="2">using</font></font></font><font face=""courier new""><font size="2"> System.Configuration;</font></font></p><p><font face=""courier new""><font color="#0000ff"><font size="2">using</font></font></font><font face=""courier new""><font size="2"> System.Collections;</font></font></p><p><font face=""courier new""><font color="#0000ff"><font size="2">using</font></font></font><font face=""courier new""><font size="2"> System.Web;</font></font></p><p><font face=""courier new""><font color="#0000ff"><font size="2">using</font></font></font><font face=""courier new""><font size="2"> System.Web.Security;</font></font></p><p><font face=""courier new""><font color="#0000ff"><font size="2">using</font></font></font><font face=""courier new""><font size="2"> System.Web.UI;</font></font></p><p><font face=""courier new""><font color="#0000ff"><font size="2">using</font></font></font><font face=""courier new""><font size="2"> System.Web.UI.WebControls;</font></font></p><p><font face=""courier new""><font color="#0000ff"><font size="2">using</font></font></font><font face=""courier new""><font size="2"> System.Web.UI.WebControls.WebParts;</font></font></p><p><font face=""courier new""><font color="#0000ff"><font size="2">using</font></font></font><font face=""courier new""><font size="2"> System.Web.UI.HtmlControls;</font></font></p><p> </p><p><font face=""courier new""><font color="#0000ff"><font size="2">namespace</font></font></font><font face=""courier new""><font size="2"> ComboBox</font></font></p><p><font face=""courier new""><font size="2">{</font></font></p><p><font face=""courier new""><font size="2"> <font color="#0000ff">public</font> <font color="#0000ff">partial</font> <font color="#0000ff">class</font> <font color="#2b91af">_Default</font> : System.Web.UI.<font color="#2b91af">Page</font></font></font></p><p> <font face=""courier new""><font size="2">{</font></font></p><p> </p><p><font face=""courier new""><font color="#0000ff"><font size="2"> #region</font></font></font><font face=""courier new""><font size="2"> Métodos da página</font></font></p><p> </p><p><font face=""courier new""><font size="2"> <font color="#808080">///</font> <font color="#808080"><summary></font></font></font></p><p><font face=""courier new""><font size="2"> <font color="#808080">///</font><font color="#008000"> Page load da página</font></font></font></p><p><font face=""courier new""><font size="2"> <font color="#808080">///</font> <font color="#808080"></summary></font></font></font></p><p> <font face=""courier new""><font color="#0000ff"><font size="2">protected</font></font></font><font face=""courier new""><font size="2"> <font color="#0000ff">void</font> Page_Load(<font color="#0000ff">object</font> sender, <font color="#2b91af">EventArgs</font> e)</font></font></p><p> <font face=""courier new""><font size="2">{</font></font></p><p><font face=""courier new""><font size="2"> <font color="#0000ff">if</font> (!IsPostBack)</font></font></p><p><font face=""courier new""><font size="2"> {</font></font></p><p><font face=""courier new""><font size="2"> <font color="#0000ff">this</font>.CarregarCombo();</font></font></p><p><font face=""courier new""><font size="2"> }</font></font></p><p> </p><p><font face=""courier new""><font size="2"> <font color="#0000ff">this</font>.btn_sele.Click += <font color="#0000ff">new</font> <font color="#2b91af">EventHandler</font>(btn_sele_Click);</font></font></p><p> </p><p> <font face=""courier new""><font size="2">}</font></font></p><p> </p><p><font face=""courier new""><font color="#0000ff"><font size="2"> #endregion</font></font></font><font face=""courier new""><font size="2"> Métodos da página</font></font></p><p> </p><p><font face=""courier new""><font color="#0000ff"><font size="2"> #region</font></font></font><font face=""courier new""><font size="2"> Métodos dos controles</font></font></p><p> </p><p><font face=""courier new""><font size="2"> <font color="#808080">///</font> <font color="#808080"><summary></font></font></font></p><p><font face=""courier new""><font size="2"> <font color="#808080">///</font><font color="#008000"> Método do clique do botão</font></font></font></p><p> <font face=""courier new""><font color="#808080"><font size="2">///</font></font></font> <font face=""courier new""><font color="#808080"><font size="2"></summary></font></font></font></p><p><font face=""courier new""><font size="2"> <font color="#0000ff">void</font> btn_sele_Click(<font color="#0000ff">object</font> sender, <font color="#2b91af">EventArgs</font> e)</font></font></p><p><font face=""courier new""><font size="2"> {</font></font></p><p><font face=""courier new""><font size="2"> <font color="#0000ff">this</font>.lbl_mes.Text = <font color="#0000ff">this</font>.cbo_mes.SelectedItem.Text;</font></font></p><p> <font face=""courier new""><font size="2">}</font></font></p><p> </p><p><font face=""courier new""><font color="#0000ff"><font size="2"> #endregion</font></font></font><font face=""courier new""><font size="2"> Métodos dos controles</font></font></p><p> </p><p><font face=""courier new""><font color="#0000ff"><font size="2"> #region</font></font></font><font face=""courier new""><font size="2"> Métodos</font></font></p><p> </p><p><font face=""courier new""><font size="2"> <font color="#808080">///</font> <font color="#808080"><summary></font></font></font></p><p><font face=""courier new""><font size="2"> <font color="#808080">///</font><font color="#008000"> Função para carregar o combo</font></font></font></p><p><font face=""courier new""><font size="2"> <font color="#808080">///</font> <font color="#808080"></summary></font></font></font></p><p><font face=""courier new""><font size="2"> <font color="#0000ff">private</font> <font color="#0000ff">void</font> CarregarCombo()</font></font></p><p><font face=""courier new""><font size="2"> {</font></font></p><p><font face=""courier new""><font size="2"> <font color="#008000">// Limpa todos os itens do combo</font></font></font></p><p> <font face=""courier new""><font color="#0000ff"><font size="2">this</font></font></font><font face=""courier new""><font size="2">.cbo_mes.Items.Clear();</font></font></p><p> <font face=""courier new""><font color="#008000"><font size="2">// Insere os dados no combo box</font></font></font></p><p> <font face=""courier new""><font color="#0000ff"><font size="2">this</font></font></font><font face=""courier new""><font size="2">.cbo_mes.Items.Add(<font color="#0000ff">new</font> <font color="#2b91af">ListItem</font>(<font color="#a31515">"-- Selecione --"</font>, <font color="#a31515">""</font>));</font></font></p><p><font face=""courier new""><font size="2"> <font color="#0000ff">this</font>.cbo_mes.Items.Add(<font color="#0000ff">new</font> <font color="#2b91af">ListItem</font>(<font color="#a31515">"Janeiro"</font>, <font color="#a31515">"1"</font>));</font></font></p><p><font face=""courier new""><font size="2"> <font color="#0000ff">this</font>.cbo_mes.Items.Add(<font color="#0000ff">new</font> <font color="#2b91af">ListItem</font>(<font color="#a31515">"Fevereiro"</font>, <font color="#a31515">"2"</font>));</font></font></p><p><font face=""courier new""><font size="2"> <font color="#0000ff">this</font>.cbo_mes.Items.Add(<font color="#0000ff">new</font> <font color="#2b91af">ListItem</font>(<font color="#a31515">"Março"</font>, <font color="#a31515">"3"</font>));</font></font></p><p><font face=""courier new""><font size="2"> <font color="#0000ff">this</font>.cbo_mes.Items.Add(<font color="#0000ff">new</font> <font color="#2b91af">ListItem</font>(<font color="#a31515">"Abril"</font>, <font color="#a31515">"4"</font>));</font></font></p><p><font face=""courier new""><font size="2"> <font color="#0000ff">this</font>.cbo_mes.Items.Add(<font color="#0000ff">new</font> <font color="#2b91af">ListItem</font>(<font color="#a31515">"Maio"</font>, <font color="#a31515">"5"</font>));</font></font></p><p><font face=""courier new""><font size="2"> <font color="#0000ff">this</font>.cbo_mes.Items.Add(<font color="#0000ff">new</font> <font color="#2b91af">ListItem</font>(<font color="#a31515">"Junho"</font>, <font color="#a31515">"6"</font>));</font></font></p><p><font face=""courier new""><font size="2"> <font color="#0000ff">this</font>.cbo_mes.Items.Add(<font color="#0000ff">new</font> <font color="#2b91af">ListItem</font>(<font color="#a31515">"Julho"</font>, <font color="#a31515">"7"</font>));</font></font></p><p><font face=""courier new""><font size="2"> <font color="#0000ff">this</font>.cbo_mes.Items.Add(<font color="#0000ff">new</font> <font color="#2b91af">ListItem</font>(<font color="#a31515">"Agosto"</font>, <font color="#a31515">"8"</font>));</font></font></p><p><font face=""courier new""><font size="2"> <font color="#0000ff">this</font>.cbo_mes.Items.Add(<font color="#0000ff">new</font> <font color="#2b91af">ListItem</font>(<font color="#a31515">"Setembro"</font>, <font color="#a31515">"9"</font>));</font></font></p><p><font face=""courier new""><font size="2"> <font color="#0000ff">this</font>.cbo_mes.Items.Add(<font color="#0000ff">new</font> <font color="#2b91af">ListItem</font>(<font color="#a31515">"Outubro"</font>, <font color="#a31515">"10"</font>));</font></font></p><p><font face=""courier new""><font size="2"> <font color="#0000ff">this</font>.cbo_mes.Items.Add(<font color="#0000ff">new</font> <font color="#2b91af">ListItem</font>(<font color="#a31515">"Novembro"</font>, <font color="#a31515">"11"</font>));</font></font></p><p><font face=""courier new""><font size="2"> <font color="#0000ff">this</font>.cbo_mes.Items.Add(<font color="#0000ff">new</font> <font color="#2b91af">ListItem</font>(<font color="#a31515">"Dezembro"</font>, <font color="#a31515">"12"</font>));</font></font></p><p><font face=""courier new""><font size="2"> <font color="#0000ff">this</font>.cbo_mes.SelectedIndex = 0;</font></font></p><p><font face=""courier new""><font size="2"> }</font></font></p><p> </p><p><font face=""courier new""><font color="#0000ff"><font size="2"> #endregion</font></font></font><font face=""courier new""><font size="2"> Métodos</font></font></p><p> </p><p> <font face=""courier new""><font size="2">}</font></font></p><p><font face=""courier new""><font size="2">}</font></font></p><br></td></tr></tbody></table><br> Abaixo uma imagem de como ficará a tela ao emitir o erro da validação.<br><br><div id="td9p" style="text-align:left"><img src="http://docs.google.com/File?id=ddbks2c3_145c7rkhrsj_b" style="height:575.719px;width:1024px"><br><br> Abaixo um exemplo de como ficará ao passar a validação e carregar o item selecionado no nosso label.<br><br><div id="yd1x" style="text-align:left"><img src="http://docs.google.com/File?id=ddbks2c3_146dbv94zfr_b" style="height:575.719px;width:1024px"></div><br></div><div style="text-align:left"> O código fonte deste exemplo você baixa <a href="http://docs.google.com/leaf?id=0B5L0VkXAP0n1NGI2N2Q2ZjEtNjBlMC00YjNiLWFjNWEtYzMyYmExYzM5NWVh&sort=name&layout=list&num=50" id="a3y4" title="aqui">aqui</a> <b><font size="1">(Você deve estar logado ao Google)</font></b>.<br></div><br><hr size="2">Espero que tenha sido útil.<br><br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-593179111504385932010-09-09T08:19:00.001-03:002010-09-09T08:57:21.373-03:00SQL Server - Efetua a pesquisa dentro das proceduresSelect que percorre todas as procs e procurando no text da proc o que você passar como parâmetro.<br><br><font face="courier new"><font color="#0000ff">select </font></font><br style="font-family:Courier New"><font face="courier new"> t2.* </font><br style="font-family:Courier New"><font face="courier new"><font color="#0000ff">from </font></font><br style="font-family:Courier New"> <font face="courier new"><font color="#6aa84f"> syscomments </font></font><font face="courier new">t1</font><br style="font-family:Courier New"> <font face="courier new"><font color="#0000ff">inner </font></font><font face="courier new"><font color="#666666">join</font></font><br style="font-family:Courier New"> <font face="courier new"><font color="#6aa84f"> sysobjects </font></font><font face="courier new">t2</font><br style="font-family:Courier New"> <font face="courier new"><font color="#0000ff"> on </font></font><font face="courier new"><br> t2.</font><font face="courier new"><font color="#0000ff">id</font></font><font face="courier new"> = t1.</font><font face="courier new"><font color="#0000ff">id</font></font><br style="font-family:Courier New"><font face="courier new"><font color="#0000ff">where </font></font><br style="font-family:Courier New"><font face="courier new"> t1.</font><font face="courier new"><font color="#0000ff">text </font></font><font face="courier new"><font color="#666666"> like</font></font><font face="courier new"><font color="#ff0000"> '%String a ser procurada nas procs%' </font></font><br><br><br> Espero que seja útil para alguém.<br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-3647822044698081962010-09-08T09:45:00.004-03:002010-09-08T09:51:25.104-03:00Função SQL - FU_FRMT_VALR - Formata valores decimais<p>Função SQL para formatar valores decimais e não ser preciso formatar na aplicação.<br></p><p><font size="2"><br></font></p><p><font size="2"><br></font></p><p><b><font face=""courier new""><font color="#0000ff"><font size="2">CREATE</font></font></font><font face=""courier new""><font color="#0000ff"> <font color="#0000ff">FUNCTION</font> dbo<font color="#808080">.</font>FU_FRMT_VALR<font color="#808080">(</font>@valor <font color="#0000ff">decimal</font><font color="#808080">(</font>20<font color="#808080">,</font>2<font size="2">))</font></font></font></b></p><p><b><font face=""courier new""><font color="#0000ff"><font size="2">returns</font></font></font><font face=""courier new""><font color="#0000ff"> <font color="#0000ff">varchar</font><font color="#808080">(</font>30<font size="2">)</font></font></font></b></p><p><b><font face=""courier new""><font color="#0000ff"><font size="2">as</font></font></font></b></p><p><b><font face=""courier new""><font color="#0000ff"><font size="2">begin</font></font></font></b></p><p><b><font face=""courier new""><font size="2"><font color="#0000ff" size="2">declare</font><br></font></font></b></p><p><b><font face=""courier new""><font color="#808080"><font color="#000000">@valor_char</font> <font color="#0000ff">varchar</font><font color="#808080">(</font><font color="#000000">30</font><font size="2">)</font></font></font></b></p><p><b><font color="#000000" face=""courier new""><font size="2">,</font></font><font face=""courier new""><font color="#808080"><font color="#000000">@valor_decm</font> <font color="#0000ff">varchar</font><font color="#808080">(</font><font color="#000000">30</font><font size="2">)</font></font></font></b></p><p><b><font color="#000000" face=""courier new""><font size="2">,</font></font><font face=""courier new""><font color="#808080"><font color="#000000">@valor_work</font> <font color="#0000ff">varchar</font><font color="#808080">(</font><font color="#000000">30</font><font size="2">)</font></font></font></b></p><p><b><font color="#000000" face=""courier new""><font size="2">,</font></font><font face=""courier new""><font size="2">@valor_retn <font color="#0000ff">varchar</font><font color="#808080">(</font>30<font color="#808080">)</font></font></font></b></p><p></p><p></p><p><br></p><p></p><p><b><font face=""courier new""><font size="2"> <font color="#0000ff">select</font> @valor_char <font color="#808080">=</font> <font color="#ff00ff">replace</font><font color="#808080">(</font><font color="#ff00ff">convert</font><font color="#808080">(</font><font color="#0000ff">varchar</font><font color="#808080">,</font>@valor<font color="#808080">),</font><font color="#ff0000">'.'</font><font color="#808080">,</font><font color="#ff0000">','</font><font color="#808080">)</font></font></font></b></p><p></p><p><b><font face=""courier new""><font size="2"> <font color="#0000ff">select</font> @valor_decm <font color="#808080">=</font> <font color="#ff00ff">substring</font><font color="#808080">(</font>@valor_char<font color="#808080">,</font><font color="#ff00ff">charindex</font><font color="#808080">(</font><font color="#ff0000">','</font><font color="#808080">,</font>@valor_char<font color="#808080">),</font>3<font color="#808080">)</font></font></font></b></p><p><b><font face=""courier new""><font size="2"> <font color="#0000ff">select</font> @valor_char <font color="#808080">=</font> <font color="#ff00ff">substring</font><font color="#808080">(</font>@valor_char<font color="#808080">,</font>1<font color="#808080">,</font><font color="#ff00ff">charindex</font><font color="#808080">(</font><font color="#ff0000">','</font><font color="#808080">,</font>@valor_char<font color="#808080">)-</font>1<font color="#808080">)</font></font></font></b></p><p><b> </b></p><p><b><font face=""courier new""><font size="2"> <font color="#0000ff">select</font> @valor_work <font color="#808080">=</font> <font color="#ff0000">''</font></font></font></b></p><p><b><font face=""courier new""><font size="2"> <font color="#0000ff">select</font> @valor_retn <font color="#808080">=</font> <font color="#ff0000">''</font></font></font></b></p><p><b><font face=""courier new""><font size="2"> <font color="#0000ff">while</font> <font color="#ff00ff">len</font><font color="#808080">(</font>@valor_char<font color="#808080">)</font> <font color="#808080">></font> 3</font></font></b></p><p><b><font face=""courier new""><font size="2"> <font color="#0000ff">begin</font></font></font></b></p><p><b><font face=""courier new""><font size="2"> <font color="#0000ff">select</font> @valor_work <font color="#808080">=</font> <font color="#ff0000">'.'</font> <font color="#808080">+</font> <font color="#808080">right(</font>@valor_char<font color="#808080">,</font>3<font color="#808080">)</font></font></font></b></p><p><b><font face=""courier new""><font size="2"> <font color="#0000ff">select</font> @valor_char <font color="#808080">=</font> <font color="#ff00ff">substring</font><font color="#808080">(</font>@valor_char<font color="#808080">,</font>1<font color="#808080">,</font><font color="#ff00ff">len</font><font color="#808080">(</font>@valor_char<font color="#808080">)-</font>3<font color="#808080">)</font></font></font></b></p><p><b><font face=""courier new""><font size="2"> <font color="#0000ff">select</font> @valor_retn <font color="#808080">=</font> @valor_work <font color="#808080">+</font> @valor_retn</font></font></b></p><p><b><font face=""courier new""><font size="2"> <font color="#0000ff">end</font> </font></font></b></p><p><b> </b></p><p><b><font face=""courier new""><font size="2"> <font color="#0000ff">select</font> @valor_retn <font color="#808080">=</font> @valor_char <font color="#808080">+</font> @valor_retn <font color="#808080">+</font> @valor_decm</font></font></b></p><p><b> <font face=""courier new""><font size="2"> <font color="#0000ff">return</font> @valor_retn</font></font></b></p><p><b><font face=""courier new""><font color="#0000ff"><font size="2">end</font></font></font></b></p><p><b><font face=""courier new""><font color="#0000ff"><font size="2">GO</font></font></font></b></p><p><b><font face=""courier new""><font color="#0000ff"><font size="2">SET</font></font></font><font face=""courier new""><font color="#0000ff"> <font color="#0000ff">QUOTED_IDENTIFIER</font> <font size="2">OFF</font></font></font></b></p><p><b><font face=""courier new""><font color="#0000ff"><font size="2">GO</font></font></font></b></p><p><b><font face=""courier new""><font color="#0000ff"><font size="2">SET</font></font></font><font face=""courier new""><font size="2"> <font color="#0000ff">ANSI_NULLS</font> <font color="#0000ff">ON</font> </font></font></b></p><p><b><font face=""courier new""><font color="#0000ff"><font size="2">GO</font></font></font></b></p><b><br></b>Espero que tenha sido útil.<br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-91077559057023135022010-09-07T21:16:00.003-03:002010-09-07T21:17:22.676-03:00Exemplo de DataReaderAbaixo um exemplo do uso do DataReader, para carregarmos os campos com os valores na nossa base de dados estou postando este exemplo. Os cometários estão explicando linha a linha.<b><br><br>Exemplo de DataReader<br id="v3bm1"><br id="v3bm2"></b><font color="#38761d" id="v3bm3">//Conexão com Banco de dados</font><br id="v3bm4"><p id="v3bm6"><font id="v3bm7" size="2">OleDbConnection conn = new OleDbConnection(stringdeconexao);</font></p><p id="v3bm8"><font id="v3bm9" size="2">conn.Open();</font></p><p id="v3bm10"><br id="v3bm11"></p><p id="v3bm12"><font id="v3bm13" size="2"><font color="#38761d" id="v3bm14">//Comando de SELECT</font><br id="v3bm15"></font></p><p id="v3bm16"><font id="v3bm17" size="2">OleDbCommand cmd = new OleDbCommand("Select * from tb_fornecedor", conn);</font></p><p id="v3bm18"><font id="v3bm19" size="2"><br id="v3bm20"></font></p><p id="v3bm21"><font id="v3bm22" size="2"><font color="#38761d" id="v3bm23">//Execução</font><br id="v3bm24"></font></p><p id="v3bm25"><font id="v3bm26" size="2">OleDbDataReader dr = cmd.ExecuteReader();</font></p><p id="v3bm27"> </p><p id="v3bm28"><font color="#38761d" id="v3bm29" size="2">// Aqui é o loop do DataReader</font></p><p id="v3bm30"><font id="v3bm31" size="2">while (dr.Read())</font></p><p id="v3bm32"><font id="v3bm33" size="2">{</font></p><p id="v3bm34"><font id="v3bm35" size="2"> <font color="#38761d">// dr[" é o DataReader com o nome do campo no select</font></font></p><p id="v3bm36"><font id="v3bm37" size="2"> mnuFornecedor.Items[0].ChildItems.Add(<font color="#0000ff" id="v3bm38" size="2">new</font> <font color="#2b91af" id="v3bm40" size="2">MenuItem</font><font id="v3bm41" size="2">(dr[</font><font color="#a31515" id="v3bm42" size="2">"nome"</font><font id="v3bm43" size="2">].ToString(), dr[</font><font color="#a31515" id="v3bm44" size="2">"valor"</font><font id="v3bm45" size="2">].ToString(), </font><font color="#0000ff" id="v3bm46" size="2">null</font><font id="v3bm47" size="2">, dr[</font><font color="#a31515" id="v3bm48" size="2">"navigateurl"</font><font id="v3bm49" size="2">].ToString()));</font></font></p><p id="v3bm50"><font id="v3bm51" size="2">}</font></p><br id="v3bm52">Espero que seja útil para alguém.<br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-15981900768427834872010-09-06T15:05:00.001-03:002010-09-06T15:05:41.404-03:00Função SQL - FN_FRMT_INTE - Formata valores inteiros<span id="internal-source-marker_0.9914531062098008" style="font-style:normal;vertical-align:baseline"><font face="verdana"><font color="#000000"><font size="2">Função SQL utilizada para formatar valores inteiros, muito utilizado para mostrar em um campo ou em um grid para o usuário trazendo no SELECT o valor já formatado, sem ser preciso fazer isso na aplicação.</font></font></font></span><br><br><span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#0000ff"><font size="2">CREATE</font></font></font></span> <span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#0000ff"><font size="2">FUNCTION</font></font><font color="#000000"><font size="2"> dbo</font></font><font color="#808080"><font size="2">.</font></font><font color="#000000"><font size="2">FN_FRMT_INTE</font></font><font color="#808080"><font size="2">(</font></font><font color="#000000"><font size="2">@valor </font></font><font color="#0000ff"><font size="2">decimal</font></font><font color="#808080"><font size="2">(</font></font><font color="#000000"><font size="2">20</font></font><font color="#808080"><font size="2">,</font></font><font color="#000000"><font size="2">0</font></font><font color="#808080"><font size="2">))</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#0000ff"><font size="2">returns</font></font></font></span> <span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#0000ff"><font size="2">varchar</font></font><font color="#808080"><font size="2">(</font></font><font color="#000000"><font size="2">30</font></font><font color="#808080"><font size="2">)</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#0000ff"><font size="2">as</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#0000ff"><font size="2">begin</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#0000ff"><font size="2">declare</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#000000"><font size="2"> @valor_char </font></font><font color="#0000ff"><font size="2">varchar</font></font><font color="#808080"><font size="2">(</font></font><font color="#000000"><font size="2">30</font></font><font color="#808080"><font size="2">)</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#808080"><font size="2">,</font></font><font color="#000000"><font size="2">@valor_decm </font></font><font color="#0000ff"><font size="2">varchar</font></font><font color="#808080"><font size="2">(</font></font><font color="#000000"><font size="2">30</font></font><font color="#808080"><font size="2">)</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#808080"><font size="2">,</font></font><font color="#000000"><font size="2">@valor_work </font></font><font color="#0000ff"><font size="2">varchar</font></font><font color="#808080"><font size="2">(</font></font><font color="#000000"><font size="2">30</font></font><font color="#808080"><font size="2">)</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#808080"><font size="2">,</font></font><font color="#000000"><font size="2">@valor_retn </font></font><font color="#0000ff"><font size="2">varchar</font></font><font color="#808080"><font size="2">(</font></font><font color="#000000"><font size="2">30</font></font><font color="#808080"><font size="2">)</font></font></font></span><br style="font-family:Courier New"><br style="font-family:Courier New"><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"> <font color="#0000ff"><font size="2">select</font></font><font color="#000000"><font size="2"> @valor_char </font></font><font color="#808080"><font size="2">=</font></font></font></span> <span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#ff00ff"><font size="2">replace</font></font><font color="#808080"><font size="2">(</font></font><font color="#ff00ff"><font size="2">convert</font></font><font color="#808080"><font size="2">(</font></font><font color="#0000ff"><font size="2">varchar</font></font><font color="#808080"><font size="2">,</font></font><font color="#000000"><font size="2">@valor</font></font><font color="#808080"><font size="2">),</font></font><font color="#ff0000"><font size="2">'.'</font></font><font color="#808080"><font size="2">,</font></font><font color="#ff0000"><font size="2">','</font></font><font color="#808080"><font size="2">)</font></font></font></span><br style="font-family:Courier New"><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"> <font color="#0000ff"><font size="2">select</font></font><font color="#000000"><font size="2"> @valor_work </font></font><font color="#808080"><font size="2">=</font></font></font></span> <span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#ff0000"><font size="2">''</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"> <font color="#0000ff"><font size="2">select</font></font><font color="#000000"><font size="2"> @valor_retn </font></font><font color="#808080"><font size="2">=</font></font></font></span> <span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#ff0000"><font size="2">''</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"> <font color="#0000ff"><font size="2">while</font></font></font></span> <span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#ff00ff"><font size="2">len</font></font><font color="#808080"><font size="2">(</font></font><font color="#000000"><font size="2">@valor_char</font></font><font color="#808080"><font size="2">)</font></font></font></span> <span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#808080"><font size="2">></font></font><font color="#000000"><font size="2"> 3</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"> <font color="#0000ff"><font size="2">begin</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"> <font color="#0000ff"><font size="2">select</font></font><font color="#000000"><font size="2"> @valor_work </font></font><font color="#808080"><font size="2">=</font></font></font></span> <span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#ff0000"><font size="2">'.'</font></font></font></span> <span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#808080"><font size="2">+</font></font></font></span> <span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#808080"><font size="2">right(</font></font><font color="#000000"><font size="2">@valor_char</font></font><font color="#808080"><font size="2">,</font></font><font color="#000000"><font size="2">3</font></font><font color="#808080"><font size="2">)</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"> <font color="#0000ff"><font size="2">select</font></font><font color="#000000"><font size="2"> @valor_char </font></font><font color="#808080"><font size="2">=</font></font></font></span> <span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#ff00ff"><font size="2">substring</font></font><font color="#808080"><font size="2">(</font></font><font color="#000000"><font size="2">@valor_char</font></font><font color="#808080"><font size="2">,</font></font><font color="#000000"><font size="2">1</font></font><font color="#808080"><font size="2">,</font></font><font color="#ff00ff"><font size="2">len</font></font><font color="#808080"><font size="2">(</font></font><font color="#000000"><font size="2">@valor_char</font></font><font color="#808080"><font size="2">)-</font></font><font color="#000000"><font size="2">3</font></font><font color="#808080"><font size="2">)</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"> <font color="#0000ff"><font size="2">select</font></font><font color="#000000"><font size="2"> @valor_retn </font></font><font color="#808080"><font size="2">=</font></font><font color="#000000"><font size="2"> @valor_work </font></font><font color="#808080"><font size="2">+</font></font><font color="#000000"><font size="2"> @valor_retn</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"> <font color="#0000ff"><font size="2">end</font></font></font></span> <span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#008000"><font size="2">-- while</font></font></font></span><br style="font-family:Courier New"><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"> <font color="#0000ff"><font size="2">select</font></font><font color="#000000"><font size="2"> @valor_retn </font></font><font color="#808080"><font size="2">=</font></font><font color="#000000"><font size="2"> @valor_char </font></font><font color="#808080"><font size="2">+</font></font><font color="#000000"><font size="2"> @valor_retn</font></font></font></span><br style="font-family:Courier New"><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"> <font color="#0000ff"><font size="2">return</font></font><font color="#000000"><font size="2"> @valor_retn</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#0000ff"><font size="2">end</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#0000ff"><font size="2">GO</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#0000ff"><font size="2">SET</font></font></font></span> <span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#0000ff"><font size="2">QUOTED_IDENTIFIER</font></font></font></span> <span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#0000ff"><font size="2">OFF</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#0000ff"><font size="2">GO</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#0000ff"><font size="2">SET</font></font></font></span> <span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#0000ff"><font size="2">ANSI_NULLS</font></font></font></span> <span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#0000ff"><font size="2">ON</font></font></font></span><br style="font-family:Courier New"><span style="font-style:normal;vertical-align:baseline"><font face="courier new"><font color="#0000ff"><font size="2">GO</font></font></font></span><br><br><span style="font-style:normal;vertical-align:baseline"><font face="verdana"><font color="#000000"><font size="2"> Espero mesmo que seja útil para alguém.</font></font></font></span><br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-21493729133608164862010-09-06T11:11:00.001-03:002010-09-06T14:02:02.549-03:00Error Divide by ZeroErro SQL - Error Divide by Zero<br><br>Algumas vezes nos deparamos com alguns erros "chatos" no nosso dia-a-dia, esse erro ocorre quando em nossos SELECTs ou em nossos cursores tentamos dividir um número por 0.<br><br>Podemos utilizar um case para cada divisão e assim quando vier o valor 0 alteramos para 1, mas isso consome nossa produtividade, um dos jeitos de não nos deparamos mais com esse erro é como mostrarei abaixo:<br><br>Coloque esse código no inicio da procedure<br><br><span class="postbody"><font color="#0000ff">SET ANSI_WARNINGS OFF</font><br style="color:#0000ff"><font color="#0000ff"> SET ARITHABORT OFF</font><br style="color:#0000ff"><font color="#0000ff"> SET ARITHIGNORE ON </font><br></span><br>E voltar a configuração do SQL no final da procedure<br><br><span class="postbody"><font color="#0000ff">SET ANSI_WARNINGS ON </font><br style="color:#0000ff"><font color="#0000ff"> SET ARITHABORT ON </font><br style="color:#0000ff"><font color="#0000ff"> SET ARITHIGNORE OFF </font><br></span><br>Esses comandos farão o SQL ignorar tal fato.<br><br><br>Espero que seja útil para alguém.<br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-63990608336431681532010-09-06T00:11:00.001-03:002010-09-06T00:11:05.865-03:00Função SQL - fn_Split<p style="background-color:#ffffff;margin:0px"><span class="Article_FullDescription"><span class="Article_FullDescription"><span style="background-image:none;background-repeat:repeat">Função muito utilizada para você criar uma tabela de uma string e inserir dados em massa na base de dados consumindo assim mais o banco do que a aplicação.</span></span></span></p><p style="background-color:#ffffff;margin:0px"><br></p><p style="background-color:#ffffff;margin:0px"><span class="Article_FullDescription"><span class="Article_FullDescription"><span style="background-image:none;background-repeat:repeat">Exemplo:</span></span></span></p><p style="background-color:#ffffff;margin:0px"><span class="Article_FullDescription"><span class="Article_FullDescription"><span style="background-image:none;background-repeat:repeat"> Tenho uma string "fabio|rente|blog|" e mando para o banco para inserir em uma tabela esses valores.</span></span></span></p><p style="background-color:#ffffff;margin:0px"><span class="Article_FullDescription"><span class="Article_FullDescription"><span style="background-image:none;background-repeat:repeat"> Esta função criará uma tabela como abaixo:</span></span></span></p><p style="background-color:#ffffff;margin:0px"><br></p><p style="background-color:#ffffff;margin:0px"><span class="Article_FullDescription"><span class="Article_FullDescription"><span style="background-image:none;background-repeat:repeat"> Valor | Texto</span></span></span></p><p style="background-color:#ffffff;margin:0px"><span class="Article_FullDescription"><span class="Article_FullDescription"><span style="background-image:none;background-repeat:repeat"> -----------------<br></span></span></span></p><p style="background-color:#ffffff;margin:0px"> 1 | fabio<br></p><p style="background-color:#ffffff;margin:0px"> 2 | rente</p><p style="background-color:#ffffff;margin:0px"> 3 | blog</p><p style="background-color:#ffffff;margin:0px"><br></p><p style="background-color:#ffffff;margin:0px"> Próximo passo é só fazer a inclusão na tabela.</p><p style="background-color:#ffffff;margin:0px"><br></p><p style="margin:0px"><font style="background-color:#ffffff"> Segue abaixo a função para o SQL Server.</font><br></p><p style="margin:0px"><br></p><p style="margin:0px"><br></p><p style="margin:0px"><b><span class="Article_FullDescription"><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc">DROP FUNCTION fn_Splitco do que<br></span></span></span></b></p><p style="margin:0px"><br></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc">SET QUOTED_IDENTIFIER OFF </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc">GO</span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc">SET ANSI_NULLS OFF </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc">GO</span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"> </span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc">CREATE FUNCTION fn_Split(@text varchar(8000), @delimiter varchar</span><span style="background:none repeat scroll 0% 0% #ffffcc">(20) = ' ')</span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc">RETURNS @Strings TABLE</span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc">( </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc"> position int </span><span style="background:none repeat scroll 0% 0% #ffffcc">IDENTITY PRIMARY KEY,</span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc"> value </span><span style="background:none repeat scroll 0% 0% #ffffcc">varchar(8000) </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc">)</span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc">AS</span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc">BEGIN</span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"> </span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc">DECLARE @index int </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc">SET @index = -1 </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"> </span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc">WHILE (LEN(@text) > 0) </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc"> BEGIN </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc"> SET @index = CHARINDEX(@delimiter , @text) </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc"> IF (@index = 0) AND (LEN(@text) > 0) </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc"> BEGIN </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc"> INSERT INTO @Strings VALUES (@text)</span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc"> BREAK </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc"> END </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc"> IF (@index > 1) </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc"> BEGIN </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc"> INSERT INTO @Strings VALUES (LEFT(@text, @index - 1)) </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc"> SET @text = RIGHT(@text, (LEN(@text) - @index)) </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc"> END </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc"> ELSE </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc"> SET @text = RIGHT(@text, (LEN(@text) - @index)) </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc"> END</span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc"> RETURN</span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc">END</span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"> </span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc">GO</span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"> </span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc">SET QUOTED_IDENTIFIER OFF </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc">GO</span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"> </span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc">SET ANSI_NULLS ON </span></span></b></p><p style="margin:0px"><b><span class="Article_FullDescription"><span style="background:none repeat scroll 0% 0% #ffffcc">GO</span></span></b></p><br><br>Espero que tenham gostado.<br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-62122730623846259192010-09-05T16:57:00.001-03:002010-09-05T16:58:39.584-03:00DataList - Visão Geral<p id="d14f" style="margin:0cm 0cm 0pt"><font color="#000000"><font face="Verdana" id="d14f1"><b>DataList - Visão Geral</b></font></font></p><p id="d14f3" style="margin:0cm 0cm 0pt"> </p><p id="d14f6" style="margin:0cm 0cm 0pt"><font color="#000000"><font id="d14f8" size="2"><font face="Verdana" id="d14f9">O controle de DataList é fortemente usado para a exibição de dados em uma lista repetida, como por exemplo uma tabela com a lista de produtos mais vendidos ou ainda com os produtos em destaque. Este controle suporta ainda selecionar e editar seus registros. O conteúdo e a disposição dos registros na lista em um controle DataList são definidos usando Templates. No mínimo, cada DataList deve definir um ItemTemplate, entretanto, diversos Templates opcionais podem ser usados customizando ainda mais a aparência da lista. </font></font></font></p><p id="d14f11" style="margin:0cm 0cm 0pt"><font color="#000000"><font id="d14f13" size="2"><font face="Verdana" id="d14f14">A <b>tabela 1</b> descreve os Templates existentes para este controle. </font></font></font></p><p id="d14f18" style="margin:0cm 0cm 0pt"> </p><table border="0" cellpadding="0" class="zeroBorder" id="d14f22" style="width:100%" width="100%"><tbody id="d14f23"><tr id="d14f24"><td id="d14f25" style="background:#dadada none repeat scroll 0% 50%;border:medium none #d4d0c8;width:150pt" width="200"><p id="d14f26" style="margin:0cm 0cm 0pt"><b><font id="d14f29" size="2"><font face="Verdana" id="d14f30">Template Name</font></font></b></p></td><td id="d14f32" style="background:#dadada none repeat scroll 0% 50%;border:medium none #d4d0c8"><p id="d14f33" style="margin:0cm 0cm 0pt"><b><font id="d14f36" size="2"><font face="Verdana" id="d14f37">Descrição</font></font></b></p></td></tr><tr id="d14f39"><td id="d14f40" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8" valign="top"><p id="d14f41" style="margin:0cm 0cm 0pt"><font id="d14f42" size="2"><font face="Verdana" id="d14f43"><b>ItemTemplate</b></font></font></p></td><td id="d14f48" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8" valign="top"><p id="d14f49" style="margin:0cm 0cm 0pt"><font id="d14f51" size="2"><font face="Verdana" id="d14f52">Define o conteúdo e o layout dos itens dentro da lista. Requerido.</font></font></p></td></tr><tr id="d14f54"><td id="d14f55" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8" valign="top"><p id="d14f56" style="margin:0cm 0cm 0pt"><font id="d14f57" size="2"><font face="Verdana" id="d14f58"><b>AlternatingItemTemplate</b></font></font></p></td><td id="d14f63" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8" valign="top"><p id="d14f64" style="margin:0cm 0cm 0pt"><font id="d14f66" size="2"><font face="Verdana" id="d14f67">Se usado, determina o conteúdo e o layout dos itens alternados. Se não for definido, os valores de ItemTemplate são mantidos em toda a lista.</font></font></p></td></tr><tr id="d14f69"><td id="d14f70" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8" valign="top"><p id="d14f71" style="margin:0cm 0cm 0pt"><font id="d14f72" size="2"><font face="Verdana" id="d14f73"><b>SeparatorTemplate</b></font></font></p></td><td id="d14f78" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8" valign="top"><p id="d14f79" style="margin:0cm 0cm 0pt"><font id="d14f81" size="2"><font face="Verdana" id="d14f82">Se definido, é renderizado entre os itens e os itens alternados. Se não for definido, o separador não será renderizado.</font></font></p></td></tr><tr id="d14f84"><td id="d14f85" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8" valign="top"><p id="d14f86" style="margin:0cm 0cm 0pt"><font id="d14f87" size="2"><font face="Verdana" id="d14f88"><b>SelectedItemTemplate</b></font></font></p></td><td id="d14f93" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8" valign="top"><p id="d14f94" style="margin:0cm 0cm 0pt"><font id="d14f96" size="2"><font face="Verdana" id="d14f97">Determina o conteúdo e o layout do item selecionado.</font></font></p></td></tr><tr id="d14f99"><td id="d14f100" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8" valign="top"><p id="d14f101" style="margin:0cm 0cm 0pt"><font id="d14f102" size="2"><font face="Verdana" id="d14f103"><b>EditItemTemplate</b></font></font></p></td><td id="d14f108" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8" valign="top"><p id="d14f109" style="margin:0cm 0cm 0pt"><font id="d14f111" size="2"><font face="Verdana" id="d14f112">Determina o conteúdo e o layout do conteúdo em Edição.</font></font></p></td></tr><tr id="d14f114"><td id="d14f115" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8" valign="top"><p id="d14f116" style="margin:0cm 0cm 0pt"><font id="d14f117" size="2"><font face="Verdana" id="d14f118"><b>HeaderTemplate</b></font></font></p></td><td id="d14f123" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8" valign="top"><p id="d14f124" style="margin:0cm 0cm 0pt"><font id="d14f126" size="2"><font face="Verdana" id="d14f127">Determina o conteúdo e o layout do cabeçalho da lista.</font></font></p></td></tr><tr id="d14f129"><td id="d14f130" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8" valign="top"><p id="d14f131" style="margin:0cm 0cm 0pt"><font id="d14f132" size="2"><font face="Verdana" id="d14f133"><b>FooterTemplate</b></font></font></p></td><td id="d14f138" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8" valign="top"><p id="d14f139" style="margin:0cm 0cm 0pt"><font id="d14f141" size="2"><font face="Verdana" id="d14f142">Determina o conteúdo e o layout do rodapé (Footer) da lista</font></font></p></td></tr></tbody></table><p id="d14f144" style="margin:0cm 0cm 0pt"><font id="d14f145" size="2"><font face="Verdana" id="d14f146"><b><font color="#000000">Tabela 1</font></b><font color="#000000"> – Templates do controle DataList</font></font></font></p><p id="d14f151" style="margin:0cm 0cm 0pt"> </p><p id="d14f155" style="margin:0cm 0cm 0pt"> </p><p id="d14f157" style="margin:0cm 0cm 0pt"><font color="#000000"><font id="d14f159" size="2"><font face="Verdana" id="d14f160">Os Templates definem os elementos e os controles HTML que devem ser exibidos para um registro. As formatações de cores, fontes etc. podem ser ajustadas através estilos. Cada Template tem suas próprias propriedades de estilo. Por exemplo, os estilos para o EditItemTemplate são ajustados através da propriedade de EditItemStyle. </font></font></font></p><p id="d14f162" style="margin:0cm 0cm 0pt"> </p><p id="d14f166" style="margin:0cm 0cm 0pt"><font color="#000000"><font id="d14f168" size="2"><font face="Verdana" id="d14f169">Uma outra propriedade que devemos salientar é a <i>RepeatLayout</i>. Esta propriedade muda completamente a renderização do controle DataList. Um controle DataList exibe por default uma tabela com uma coluna simples na vertical. Mudar a propriedade <i>RepeatLayout</i> para <i>Flow</i> vai remover toda a estrutura <i>Table</i> para o HTML gerado ao renderizar a página.</font></font></font></p><p id="d14f175" style="margin:0cm 0cm 0pt"> </p><p id="d14f179" style="margin:0cm 0cm 0pt"><font id="d14f180" size="2"><font face="Verdana" id="d14f181">DataList suporta render direcional através da propriedade <i>RepeatDirection</i>, modifica-la permitirá renderizar seus registros horizontalmente ou verticalmente. O controle DataList permite ao desenvolvedor controlar o número das “colunas” que são renderizadas pela propriedade <i>RepeatColumns</i>, não importando se os registros estão renderizados horizontalmente ou verticalmente.</font></font></p><p id="d14f187" style="margin:0cm 0cm 0pt"> </p><p id="d14f191" style="margin:0cm 0cm 0pt"><font id="d14f192" size="2"><font face="Verdana" id="d14f193">Se <i>RepeatDirection</i> for horizontal e <i>RepeatColumns</i> for definido em 5 (cinco), os itens serão renderizados em cinco colunas, cada coluna igual no comprimento e também no total de itens dispostos na horizontal, quando possível. <b>Tabela 2</b>.</font></font></p><p id="d14f201" style="margin:0cm 0cm 0pt"> </p><table border="0" cellpadding="0" class="zeroBorder" id="d14f205" style="width:53.88%" width="53%"><tbody id="d14f206"><tr id="d14f207"><td id="d14f208" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:15.24%" valign="top" width="15%"><p id="d14f209" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f211">1</font></font></p></td><td id="d14f213" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:18.72%" valign="top" width="18%"><p id="d14f214" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f216">2</font></font></p></td><td id="d14f218" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:21.1%" valign="top" width="21%"><p id="d14f219" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f221">3</font></font></p></td><td id="d14f223" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:21.1%" valign="top" width="21%"><p id="d14f224" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f226">4</font></font></p></td><td id="d14f228" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:20.8%" valign="top" width="20%"><p id="d14f229" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f231">5</font></font></p></td></tr><tr id="d14f233"><td id="d14f234" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:15.24%" valign="top" width="15%"><p id="d14f235" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f237">6</font></font></p></td><td id="d14f239" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:18.72%" valign="top" width="18%"><p id="d14f240" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f242">7</font></font></p></td><td id="d14f244" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:21.1%" valign="top" width="21%"><p id="d14f245" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f247">8</font></font></p></td><td id="d14f249" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:21.1%" valign="top" width="21%"><p id="d14f250" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f252">9</font></font></p></td><td id="d14f254" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:20.8%" valign="top" width="20%"><p id="d14f255" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f257">10</font></font></p></td></tr><tr id="d14f259"><td id="d14f260" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:15.24%" valign="top" width="15%"><p id="d14f261" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f263">11</font></font></p></td><td id="d14f265" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:18.72%" valign="top" width="18%"><p id="d14f266" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f268">12</font></font></p></td><td id="d14f270" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:21.1%" valign="top" width="21%"><p id="d14f271" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f273">13</font></font></p></td><td id="d14f275" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:21.1%" valign="top" width="21%"><p id="d14f276" style="margin:0cm 0cm 0pt"> </p></td><td id="d14f280" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:20.8%" valign="top" width="20%"><p id="d14f281" style="margin:0cm 0cm 0pt"> </p></td></tr></tbody></table><p id="d14f285" style="margin:0cm 0cm 0pt"><font id="d14f286" size="2"><font face="Verdana" id="d14f287"><b>Tabela 2</b> – RepeatDirection=Horizontal / RepeatColumns=5</font></font></p><p id="d14f292" style="margin:0cm 0cm 0pt"> </p><p id="d14f296" style="margin:0cm 0cm 0pt"> </p><p id="d14f300" style="margin:0cm 0cm 0pt"><font id="d14f301" size="2"><font face="Verdana" id="d14f302">Se <i>RepeatDirection</i> for vertical e <i>RepeatColumns</i> for definido em 5 (cinco), os itens serão renderizados em cinco colunas, cada coluna igual no comprimento e o total de itens será dividido por cinco e organizados na vertical. <b>Tabela 3</b>.</font></font></p><p id="d14f310" style="margin:0cm 0cm 0pt"> </p><table border="0" cellpadding="0" class="zeroBorder" id="d14f314" style="width:53.88%" width="53%"><tbody id="d14f315"><tr id="d14f316"><td id="d14f317" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:15.26%" valign="top" width="15%"><p id="d14f318" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f320">1</font></font></p></td><td id="d14f322" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:18.7%" valign="top" width="18%"><p id="d14f323" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f325">4</font></font></p></td><td id="d14f327" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:21.1%" valign="top" width="21%"><p id="d14f328" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f330">7</font></font></p></td><td id="d14f332" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:21.1%" valign="top" width="21%"><p id="d14f333" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f335">10</font></font></p></td><td id="d14f337" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:20.8%" valign="top" width="20%"><p id="d14f338" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f340">12</font></font></p></td></tr><tr id="d14f342"><td id="d14f343" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:15.26%" valign="top" width="15%"><p id="d14f344" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f346">2</font></font></p></td><td id="d14f348" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:18.7%" valign="top" width="18%"><p id="d14f349" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f351">5</font></font></p></td><td id="d14f353" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:21.1%" valign="top" width="21%"><p id="d14f354" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f356">8</font></font></p></td><td id="d14f358" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:21.1%" valign="top" width="21%"><p id="d14f359" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f361">11</font></font></p></td><td id="d14f363" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:20.8%" valign="top" width="20%"><p id="d14f364" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f366">13</font></font></p></td></tr><tr id="d14f368"><td id="d14f369" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:15.26%" valign="top" width="15%"><p id="d14f370" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f372">3</font></font></p></td><td id="d14f374" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:18.7%" valign="top" width="18%"><p id="d14f375" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f377">6</font></font></p></td><td id="d14f379" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:21.1%" valign="top" width="21%"><p id="d14f380" style="margin:0cm 0cm 0pt"><font size="2"><font face="Verdana" id="d14f382">9</font></font></p></td><td id="d14f384" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:21.1%" valign="top" width="21%"><p id="d14f385" style="margin:0cm 0cm 0pt"> </p></td><td id="d14f389" style="background:#f1f1f1 none repeat scroll 0% 50%;border:medium none #d4d0c8;width:20.8%" valign="top" width="20%"><p id="d14f390" style="margin:0cm 0cm 0pt"> </p></td></tr></tbody></table><p id="d14f394" style="margin:0cm 0cm 0pt"><font id="d14f395" size="2"><font face="Verdana" id="d14f396"><b>Tabela 2</b> – RepeatDirection=Vertical / RepeatColumns=5</font></font></p><p id="d14f401" style="margin:0cm 0cm 0pt"> </p><p id="d14f405"><font size="2"><font face="verdana,sans-serif">O Código abaixo ilustra um exemplo simples que exibe um DataList com suas propriedades RepeatDirection, RepeatLayout e RepeatColumns, sendo possível alterá-las dinamicamente.</font></font></p><p id="d14f407"> </p><p id="d14f410" style="margin:0cm 0cm 0pt"><font size="2"><span id="d14f411" style="background:yellow none repeat scroll 0% 50%"><font face="courier new"><font id="y:e7" size="2"><%</font></font></span><font face="courier new"><font color="#0000ff"><font id="y:e70" size="2">@</font></font></font> <font face="courier new"><font color="#800000">Page</font> <font color="#ff0000">Language</font><font color="#0000ff">="C#"</font> <span id="d14f417" style="background:yellow none repeat scroll 0% 50%">%></span></font></font></p><p id="d14f419" style="margin:0cm 0cm 0pt"><font size="2"><span id="d14f420" style="background:yellow none repeat scroll 0% 50%"><font face="courier new"><font id="y:e71" size="2"><%</font></font></span><font face="courier new"><font color="#0000ff"><font id="y:e72" size="2">@</font></font></font> <font face="courier new"><font color="#800000">Import</font> <font color="#ff0000">Namespace</font><font color="#0000ff">="System.Data"</font> <span id="d14f426" style="background:yellow none repeat scroll 0% 50%">%></span></font></font></p><p id="d14f428" style="margin:0cm 0cm 0pt"><span id="d14f429" style="background:yellow none repeat scroll 0% 50%"> </span></p><p id="d14f431" style="margin:0cm 0cm 0pt"><font face="courier new"><font color="#0000ff"><font id="y:e74" size="2"><</font></font></font><font face="courier new"><font color="#800000"><font id="y:e75" size="2">html</font></font></font><font face="courier new"><font color="#0000ff"><font id="y:e76" size="2">></font></font></font></p><p id="d14f436" style="margin:0cm 0cm 0pt"> </p><p id="d14f439" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"><font color="#0000ff"><font id="y:e78" size="2"><</font></font></font><font face="courier new"><font color="#800000"><font id="y:e79" size="2">script</font></font></font> <font face="courier new"><font color="#ff0000">language</font> <font color="#0000ff">=</font> <font color="#0000ff">"C#"</font> <font color="#ff0000">runat</font><font color="#0000ff">="server"></font></font></font></p><p id="d14f449" style="margin:0cm 0cm 0pt"> </p><p id="d14f452" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#008080">ICollection</font><font id="y:e711" size="2"> CreateDataSource() {</font></font></font></p><p id="d14f457" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#008080">DataTable</font><font id="y:e712" size="2"> dt = </font><font color="#0000ff">new</font> <font color="#008080">DataTable</font><font id="y:e713" size="2">();</font></font></font></p><p id="d14f464" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#008080">DataRow</font><font id="y:e714" size="2"> dr;</font></font></font></p><p id="d14f469" style="margin:0cm 0cm 0pt"> </p><p id="d14f472" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font id="y:e716" size="2">dt.Columns.Add(</font><font color="#0000ff">new</font> <font color="#008080">DataColumn</font><font id="y:e717" size="2">(</font><font color="#800000">"ValorString"</font><font id="y:e718" size="2">, </font><font color="#0000ff">typeof</font><font id="y:e719" size="2">(</font><font color="#0000ff">string</font><font id="y:e720" size="2">)));</font></font></font></p><p id="d14f481" style="margin:0cm 0cm 0pt"> </p><p id="d14f484" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff">for</font><font id="y:e722" size="2"> (</font><font color="#0000ff">int</font><font id="y:e723" size="2"> i = 0; i < 10; i++) {</font></font></font></p><p id="d14f490" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e724" size="2">dr = dt.NewRow();</font></font></p><p id="d14f494" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font id="y:e725" size="2">dr[0] = </font><font color="#800000">"Item "</font><font id="y:e726" size="2"> + i.ToString();</font></font></font></p><p id="d14f499" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e727" size="2">dt.Rows.Add(dr);</font></font></p><p id="d14f503" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e728" size="2">}</font></font></p><p id="d14f507" style="margin:0cm 0cm 0pt"> </p><p id="d14f510" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#008080">DataView</font><font id="y:e730" size="2"> dv = </font><font color="#0000ff">new</font> <font color="#008080">DataView</font><font id="y:e731" size="2">(dt);</font></font></font></p><p id="d14f517" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff">return</font><font id="y:e732" size="2"> dv;</font></font></font></p><p id="d14f522" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e733" size="2">}</font></font></p><p id="d14f526" style="margin:0cm 0cm 0pt"> </p><p id="d14f529" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff">void</font><font id="y:e735" size="2"> Page_Load(</font><font color="#008080">Object</font><font id="y:e736" size="2"> Sender, </font><font color="#008080">EventArgs</font><font id="y:e737" size="2"> E) {</font></font></font></p><p id="d14f536" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff">if</font><font id="y:e738" size="2"> (!IsPostBack) {</font></font></font></p><p id="d14f541" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e739" size="2">DataList1.DataSource = CreateDataSource();</font></font></p><p id="d14f545" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e740" size="2">DataList1.DataBind();</font></font></p><p id="d14f549" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e741" size="2">}</font></font></p><p id="d14f553" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e742" size="2">}</font></font></p><p id="d14f557" style="margin:0cm 0cm 0pt"> </p><p id="d14f560" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff">void</font><font id="y:e744" size="2"> Button1_Click(</font><font color="#008080">Object</font><font id="y:e745" size="2"> Sender, </font><font color="#008080">EventArgs</font><font id="y:e746" size="2"> E) {</font></font></font></p><p id="d14f567" style="margin:0cm 0cm 0pt"> </p><p id="d14f570" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff">if</font><font id="y:e748" size="2"> (DropDown1.SelectedIndex == 0)</font></font></font></p><p id="d14f575" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font id="y:e749" size="2">DataList1.RepeatDirection = </font><font color="#008080">RepeatDirection</font><font id="y:e750" size="2">.Horizontal;</font></font></font></p><p id="d14f580" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff">else</font></font></font></p><p id="d14f585" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font id="y:e751" size="2">DataList1.RepeatDirection = </font><font color="#008080">RepeatDirection</font><font id="y:e752" size="2">.Vertical;</font></font></font></p><p id="d14f590" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff">if</font><font id="y:e753" size="2"> (DropDown2.SelectedIndex == 0)</font></font></font></p><p id="d14f595" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font id="y:e754" size="2">DataList1.RepeatLayout = </font><font color="#008080">RepeatLayout</font><font id="y:e755" size="2">.Table;</font></font></font></p><p id="d14f600" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff">else</font></font></font></p><p id="d14f605" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font id="y:e756" size="2">DataList1.RepeatLayout = </font><font color="#008080">RepeatLayout</font><font id="y:e757" size="2">.Flow;</font></font></font></p><p id="d14f610" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e758" size="2">DataList1.RepeatColumns=DropDown3.SelectedIndex+1;</font></font></p><p id="d14f614" style="margin:0cm 0cm 0pt"> </p><p id="d14f617" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff">if</font><font id="y:e760" size="2"> ((Check1.Checked ==</font><font color="#0000ff">true</font><font id="y:e761" size="2">) && (DataList1.RepeatLayout == </font><font color="#008080">RepeatLayout</font><font id="y:e762" size="2">.Table)) {</font></font></font></p><p id="d14f624" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font id="y:e763" size="2">DataList1.BorderWidth = </font><font color="#008080">Unit</font><font id="y:e764" size="2">.Pixel(1);</font></font></font></p><p id="d14f629" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font id="y:e765" size="2">DataList1.GridLines = </font><font color="#008080">GridLines</font><font id="y:e766" size="2">.Both;</font></font></font></p><p id="d14f634" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e767" size="2">}</font></font></p><p id="d14f638" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff">else</font> <font id="y:e768" size="2">{</font></font></font></p><p id="d14f644" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font id="y:e769" size="2">DataList1.BorderWidth = </font><font color="#008080">Unit</font><font id="y:e770" size="2">.Pixel(0);</font></font></font></p><p id="d14f649" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font id="y:e771" size="2">DataList1.GridLines = </font><font color="#008080">GridLines</font><font id="y:e772" size="2">.None;</font></font></font></p><p id="d14f654" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e773" size="2">}</font></font></p><p id="d14f658" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e774" size="2">}</font></font></p><p id="d14f662" style="margin:0cm 0cm 0pt"> </p><p id="d14f665" style="margin:0cm 0cm 0pt"><font face="courier new"><font color="#0000ff"><font id="y:e776" size="2"></</font></font></font><font face="courier new"><font color="#800000"><font id="y:e777" size="2">script</font></font></font><font face="courier new"><font color="#0000ff"><font id="y:e778" size="2">></font></font></font> </p><p id="d14f671"><font size="2"><font face="courier new"><font color="#0000ff"><font id="y:e780" size="2"><</font></font></font><font face="courier new"><font color="#800000"><font id="y:e781" size="2">body</font></font></font><font face="courier new"><font color="#0000ff"><font id="y:e782" size="2">><br id="d14f675"></font></font></font><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">h3</font><font color="#0000ff">><</font><font color="#800000">font</font> <font color="#ff0000">face</font><font color="#0000ff">="Verdana"></font><font id="y:e783" size="2">Exemplo de DataList Simples</font><font color="#0000ff"></</font><font color="#800000">font</font><font color="#0000ff">></</font><font color="#800000">h3</font><font color="#0000ff">><br id="d14f689"></font></font> <font face="courier new"> <font color="#0000ff"><</font><font color="#800000">form</font> <font color="#ff0000">id</font><font color="#0000ff">="Form1"</font> <font color="#ff0000">runat</font><font color="#0000ff">="server"><br id="d14f700"></font></font><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">font</font> <font color="#ff0000">face</font><font color="#0000ff">="Verdana"</font> <font color="#ff0000">size</font><font color="#0000ff">="-1"><br id="d14f709"></font></font><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">DataList</font> <font color="#ff0000">id</font><font color="#0000ff">="DataList1"</font> <font color="#ff0000">runat</font><font color="#0000ff">="server"<br id="d14f720"></font></font><font face="courier new"> <font color="#ff0000">BorderColor</font><font color="#0000ff">="black"<br id="d14f725"></font></font><font face="courier new"> <font color="#ff0000">CellPadding</font><font color="#0000ff">="3"<br id="d14f730"></font></font><font face="courier new"> <font color="#ff0000">Font-Names</font><font color="#0000ff">="Verdana"<br id="d14f735"></font></font><font face="courier new"> <font color="#ff0000">Font-Size</font><font color="#0000ff">="8pt"<br id="d14f740"></font></font><font face="courier new"> <font color="#ff0000">HeaderStyle-BackColor</font><font color="#0000ff">="#aaaadd"<br id="d14f745"></font></font><font face="courier new"> <font color="#ff0000">AlternatingItemStyle-BackColor</font><font color="#0000ff">="Gainsboro"<br id="d14f750"></font></font><font face="courier new"> <font color="#0000ff">></font></font></font></p><p id="d14f755" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">HeaderTemplate</font><font color="#0000ff">></font></font></font></p><p id="d14f762" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e785" size="2">ITENS...</font></font></p><p id="d14f766" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"></</font><font color="#800000">HeaderTemplate</font><font color="#0000ff">></font></font></font></p><p id="d14f773" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">ItemTemplate</font><font color="#0000ff">></font></font></font></p><p id="d14f780" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <span id="d14f783" style="background:yellow none repeat scroll 0% 50%"><%</span><font color="#0000ff">#</font> <font color="#008080">DataBinder</font><font id="y:e786" size="2">.Eval(Container.DataItem, </font><font color="#800000">"ValorString"</font><font id="y:e787" size="2">) </font><span id="d14f787" style="background:yellow none repeat scroll 0% 50%">%></span></font></font></p><p id="d14f789" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"></</font><font color="#800000">ItemTemplate</font><font color="#0000ff">></font></font></font></p><p id="d14f796" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"></</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">DataList</font><font color="#0000ff">></font></font></font></p><p id="d14f805" style="margin:0cm 0cm 0pt"> </p><p id="d14f808" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">br</font> <font color="#0000ff">/><</font><font color="#800000">br</font> <font color="#0000ff">/></font></font></font></p><p id="d14f817" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">hr</font> <font color="#ff0000">noshade</font> <font color="#ff0000">align</font><font color="#0000ff">="left"</font> <font color="#ff0000">width</font><font color="#0000ff">="300px"></font></font></font></p><p id="d14f828" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e789" size="2">RepeatDirection:</font></font></p><p id="d14f832" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">DropDownList</font> <font color="#ff0000">id</font><font color="#0000ff">=DropDown1</font> <font color="#ff0000">runat</font><font color="#0000ff">="server"></font></font></font></p><p id="d14f844" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">ListItem</font><font color="#0000ff">></font><font id="y:e790" size="2">Horizontal</font><font color="#0000ff"></</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">ListItem</font><font color="#0000ff">></font></font></font></p><p id="d14f858" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">ListItem</font><font color="#0000ff">></font><font id="y:e791" size="2">Vertical</font><font color="#0000ff"></</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">ListItem</font><font color="#0000ff">></font></font></font></p><p id="d14f872" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"></</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">DropDownList</font><font color="#0000ff">><</font><font color="#800000">br</font><font color="#0000ff">></font></font></font></p><p id="d14f883" style="margin:0cm 0cm 0pt"> </p><p id="d14f886" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e793" size="2">RepeatLayout:</font></font></p><p id="d14f890" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">DropDownList</font> <font color="#ff0000">id</font><font color="#0000ff">=DropDown2</font> <font color="#ff0000">runat</font><font color="#0000ff">="server"></font></font></font></p><p id="d14f902" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">ListItem</font><font color="#0000ff">></font><font id="y:e794" size="2">Table</font><font color="#0000ff"></</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">ListItem</font><font color="#0000ff">></font></font></font></p><p id="d14f916" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">ListItem</font><font color="#0000ff">></font><font id="y:e795" size="2">Flow</font><font color="#0000ff"></</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">ListItem</font><font color="#0000ff">></font></font></font></p><p id="d14f930" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"></</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">DropDownList</font><font color="#0000ff">><</font><font color="#800000">br</font><font color="#0000ff">></font></font></font></p><p id="d14f941" style="margin:0cm 0cm 0pt"> </p><p id="d14f944" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e797" size="2">RepeatColumns:</font></font></p><p id="d14f948" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">DropDownList</font> <font color="#ff0000">id</font><font color="#0000ff">=DropDown3</font> <font color="#ff0000">runat</font><font color="#0000ff">="server"></font></font></font></p><p id="d14f960" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">ListItem</font><font color="#0000ff">></font><font id="y:e798" size="2">1</font><font color="#0000ff"></</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">ListItem</font><font color="#0000ff">></font></font></font></p><p id="d14f974" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">ListItem</font><font color="#0000ff">></font><font id="y:e799" size="2">2</font><font color="#0000ff"></</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">ListItem</font><font color="#0000ff">></font></font></font></p><p id="d14f988" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">ListItem</font><font color="#0000ff">></font><font id="y:e7100" size="2">3</font><font color="#0000ff"></</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">ListItem</font><font color="#0000ff">></font></font></font></p><p id="d14f1002" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">ListItem</font><font color="#0000ff">></font><font id="y:e7101" size="2">4</font><font color="#0000ff"></</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">ListItem</font><font color="#0000ff">></font></font></font></p><p id="d14f1016" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">ListItem</font><font color="#0000ff">></font><font id="y:e7102" size="2">5</font><font color="#0000ff"></</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">ListItem</font><font color="#0000ff">></font></font></font></p><p id="d14f1030" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"></</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">DropDownList</font><font color="#0000ff">><</font><font color="#800000">br</font><font color="#0000ff">></font></font></font></p><p id="d14f1041" style="margin:0cm 0cm 0pt"> </p><p id="d14f1044" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e7104" size="2">Exibir Bordas:</font></font></p><p id="d14f1048" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">CheckBox</font> <font color="#ff0000">id</font><font color="#0000ff">=Check1</font> <font color="#ff0000">runat</font><font color="#0000ff">="server"</font> <font color="#0000ff">/><</font><font color="#800000">p</font><font color="#0000ff">></font></font></font></p><p id="d14f1063" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">LinkButton</font> <font color="#ff0000">id</font><font color="#0000ff">=Button1</font> <font color="#ff0000">Text</font><font color="#0000ff">="Atualiza DataList"</font> <font color="#ff0000">OnClick</font><font color="#0000ff">="Button1_Click"</font> <font color="#ff0000">runat</font><font color="#0000ff">="server"/></font></font></font></p><p id="d14f1079" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"></</font><font color="#800000">font</font><font color="#0000ff">></font></font></font></p><p id="d14f1086" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"></</font><font color="#800000">form</font><font color="#0000ff">></font></font></font></p><p id="d14f1093" style="margin:0cm 0cm 0pt"> </p><p id="d14f1096" style="margin:0cm 0cm 0pt"><font face="courier new"><font color="#0000ff"><font id="y:e7106" size="2"></</font></font></font><font face="courier new"><font color="#800000"><font id="y:e7107" size="2">body</font></font></font><font face="courier new"><font color="#0000ff"><font id="y:e7108" size="2">></font></font></font></p><p id="d14f1101" style="margin:0cm 0cm 0pt"><font face="courier new"><font color="#0000ff"><font id="y:e7109" size="2"></</font></font></font><font face="courier new"><font color="#800000"><font id="y:e7110" size="2">html</font></font></font><font face="courier new"><font color="#0000ff"><font id="y:e7111" size="2">></font></font></font></p> <p id="d14f1107" style="margin:0cm 0cm 0pt"><font face="verdana,sans-serif"><b><font id="y:e7112" size="3">Selecionando Itens em um DataLis (SelectItemTemplate)</font></b></font></p><p id="d14f1111" style="margin:0cm 0cm 0pt"> </p><p id="d14f1114" style="margin:0cm 0cm 0pt"><font size="2"><font face="verdana,sans-serif"><font color="#000000">Você pode customizar o conteúdo e a aparência do item selecionado através da propriedade <i>SelectedItemTemplate</i>. O SelectedItemTemplate é controlado pela propriedade <i>SelectedIndex</i>. Por padrão o valor de SelectedIndex é -1, significando que nenhum dos itens na lista está selecionado. Quando SelectedIndex é ajustado a um conteúdo em particular, esse conteúdo pode ser destacado usando o <i>SelectedItemTemplate</i>. </font></font></font></p><p id="d14f1120" style="margin:0cm 0cm 0pt"> </p><p id="d14f1123" style="margin:0cm 0cm 0pt"><font size="2"><font face="verdana,sans-serif">O exemplo abaixo ilustra o uso de <b>SelectItemTemplate</b> em um controle DataList.</font></font></p><p id="d14f1127" style="margin:0cm 0cm 0pt"> </p><p id="d14f1130" style="margin:0cm 0cm 0pt"> </p><p id="d14f1133" style="margin:0cm 0cm 0pt"><font size="2"><span id="d14f1134" style="background:yellow none repeat scroll 0% 50%"><font face="courier new"><font id="y:e7113" size="2"><%</font></font></span><font face="courier new"><font color="#0000ff"><font id="y:e7114" size="2">@</font></font></font> <font face="courier new"><font color="#800000">Page</font> <font color="#ff0000">Language</font><font color="#0000ff">="C#"</font> <span id="d14f1140" style="background:yellow none repeat scroll 0% 50%">%></span></font></font></p><p id="d14f1142" style="margin:0cm 0cm 0pt"><font size="2"><span id="d14f1143" style="background:yellow none repeat scroll 0% 50%"><font face="courier new"><font id="y:e7115" size="2"><%</font></font></span><font face="courier new"><font color="#0000ff"><font id="y:e7116" size="2">@</font></font></font> <font face="courier new"><font color="#800000">Import</font> <font color="#ff0000">Namespace</font><font color="#0000ff">="System.Data"</font> <span id="d14f1149" style="background:yellow none repeat scroll 0% 50%">%></span></font></font></p><p id="d14f1151" style="margin:0cm 0cm 0pt"><span id="d14f1152" style="background:yellow none repeat scroll 0% 50%"> </span></p><p id="d14f1154" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"><font color="#0000ff"><font id="y:e7118" size="2"><</font></font></font><font face="courier new"><font color="#800000"><font id="y:e7119" size="2">script</font></font></font> <font face="courier new"><font color="#ff0000">runat</font><font color="#0000ff">="server"></font> </font></font></p><p id="d14f1162" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#008080">ICollection</font><font id="y:e7120" size="2"> CreateDataSource() {</font></font></font></p><p id="d14f1167" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#008080">DataTable</font><font id="y:e7121" size="2"> dt = </font><font color="#0000ff">new</font> <font color="#008080">DataTable</font><font id="y:e7122" size="2">();</font></font></font></p><p id="d14f1174" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#008080">DataRow</font><font id="y:e7123" size="2"> dr;</font></font></font></p><p id="d14f1179" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font id="y:e7124" size="2">dt.Columns.Add(</font><font color="#0000ff">new</font> <font color="#008080">DataColumn</font><font id="y:e7125" size="2">(</font><font color="#800000">"ValorInteiro"</font><font id="y:e7126" size="2">, </font><font color="#0000ff">typeof</font><font id="y:e7127" size="2">(</font><font color="#008080">Int32</font><font id="y:e7128" size="2">)));</font></font></font></p><p id="d14f1188" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font id="y:e7129" size="2">dt.Columns.Add(</font><font color="#0000ff">new</font> <font color="#008080">DataColumn</font><font id="y:e7130" size="2">(</font><font color="#800000">"ValorString"</font><font id="y:e7131" size="2">, </font><font color="#0000ff">typeof</font><font id="y:e7132" size="2">(</font><font color="#0000ff">string</font><font id="y:e7133" size="2">)));</font></font></font></p><p id="d14f1197" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font id="y:e7134" size="2">dt.Columns.Add(</font><font color="#0000ff">new</font> <font color="#008080">DataColumn</font><font id="y:e7135" size="2">(</font><font color="#800000">"ValorData"</font><font id="y:e7136" size="2">, </font><font color="#0000ff">typeof</font><font id="y:e7137" size="2">(</font><font color="#008080">DateTime</font><font id="y:e7138" size="2">)));</font></font></font></p><p id="d14f1206" style="margin:0cm 0cm 0pt"> </p><p id="d14f1209" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff">for</font><font id="y:e7140" size="2"> (</font><font color="#0000ff">int</font><font id="y:e7141" size="2"> i = 0; i < 9; i++) {</font></font></font></p><p id="d14f1215" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e7142" size="2">dr = dt.NewRow();</font></font></p><p id="d14f1219" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e7143" size="2">dr[0] = i;</font></font></p><p id="d14f1223" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font id="y:e7144" size="2">dr[1] = </font><font color="#800000">"Item "</font><font id="y:e7145" size="2"> + i.ToString();</font></font></font></p><p id="d14f1228" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font id="y:e7146" size="2">dr[2] = </font><font color="#008080">DateTime</font><font id="y:e7147" size="2">.Now;</font></font></font></p><p id="d14f1233" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e7148" size="2">dt.Rows.Add(dr);</font></font></p><p id="d14f1237" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e7149" size="2">}</font></font></p><p id="d14f1241" style="margin:0cm 0cm 0pt"> </p><p id="d14f1244" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#008080">DataView</font><font id="y:e7151" size="2"> dv = </font><font color="#0000ff">new</font> <font color="#008080">DataView</font><font id="y:e7152" size="2">(dt);</font></font></font></p><p id="d14f1251" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff">return</font><font id="y:e7153" size="2"> dv;</font></font></font></p><p id="d14f1256" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e7154" size="2">}</font></font></p><p id="d14f1260" style="margin:0cm 0cm 0pt"> </p><p id="d14f1263" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff">void</font><font id="y:e7156" size="2"> Page_Load(</font><font color="#008080">Object</font><font id="y:e7157" size="2"> Sender, </font><font color="#008080">EventArgs</font><font id="y:e7158" size="2"> e) {</font></font></font></p><p id="d14f1270" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff">if</font><font id="y:e7159" size="2"> (!IsPostBack)</font></font></font></p><p id="d14f1275" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e7160" size="2">CarregaLista();</font></font></p><p id="d14f1279" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e7161" size="2">}</font></font></p><p id="d14f1283" style="margin:0cm 0cm 0pt"> </p><p id="d14f1286" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff">void</font><font id="y:e7163" size="2"> CarregaLista() {</font></font></font></p><p id="d14f1291" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e7164" size="2">DataList1.DataSource= CreateDataSource();</font></font></p><p id="d14f1295" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e7165" size="2">DataList1.DataBind();</font></font></p><p id="d14f1299" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e7166" size="2">}</font></font></p><p id="d14f1303" style="margin:0cm 0cm 0pt"> </p><p id="d14f1306" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff">void</font><font id="y:e7168" size="2"> DataList_ItemCommand(</font><font color="#0000ff">object</font><font id="y:e7169" size="2"> Sender, </font><font color="#008080">DataListCommandEventArgs</font><font id="y:e7170" size="2"> e) {</font></font></font></p><p id="d14f1313" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff">string</font><font id="y:e7171" size="2"> cmd = ((</font><font color="#008080">LinkButton</font><font id="y:e7172" size="2">)e.CommandSource).CommandName;</font></font></font></p><p id="d14f1319" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff">if</font><font id="y:e7173" size="2"> (cmd == </font><font color="#800000">"select"</font><font id="y:e7174" size="2">)</font></font></font></p><p id="d14f1325" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e7175" size="2">DataList1.SelectedIndex = e.Item.ItemIndex;</font></font></p><p id="d14f1329" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e7176" size="2">CarregaLista();</font></font></p><p id="d14f1333" style="margin:0cm 0cm 0pt"><font face="courier new"> <font id="y:e7177" size="2">}</font></font></p><p id="d14f1337" style="margin:0cm 0cm 0pt"><font face="courier new"><font color="#0000ff"><font id="y:e7178" size="2"></</font></font></font><font face="courier new"><font color="#800000"><font id="y:e7179" size="2">script</font></font></font><font face="courier new"><font color="#0000ff"><font id="y:e7180" size="2">></font></font></font></p><p id="d14f1341" style="margin:0cm 0cm 0pt"> </p><p id="d14f1344" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"><font color="#0000ff"><</font></font><font face="courier new"><font color="#800000">html</font></font><font face="courier new"><font color="#0000ff">></font></font></font></p><p id="d14f1349" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"><font color="#0000ff"><</font></font><font face="courier new"><font color="#800000">head</font></font><font face="courier new"> <font color="#ff0000">runat</font><font color="#0000ff">="server"></font></font></font></p><p id="d14f1356" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">title</font><font color="#0000ff">></font>Exemplo do Controle DataList<font color="#0000ff"></</font><font color="#800000">title</font><font color="#0000ff">></font></font></font></p><p id="d14f1366" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"><font color="#0000ff"></</font></font><font face="courier new"><font color="#800000">head</font></font><font face="courier new"><font color="#0000ff">></font></font></font></p><p id="d14f1371" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"><font color="#0000ff"><</font></font><font face="courier new"><font color="#800000">body</font></font><font face="courier new"><font color="#0000ff">></font></font></font></p><p id="d14f1376" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">h3</font><font color="#0000ff">></font>Usando o SelectItemTemplate com o DataList<font color="#0000ff"></</font><font color="#800000">h3</font><font color="#0000ff">></font></font></font></p><p id="d14f1386" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">form</font> <font color="#ff0000">id</font><font color="#0000ff">="Form1"</font> <font color="#ff0000">runat</font><font color="#0000ff">="server"></font></font></font></p><p id="d14f1396" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">DataList</font> <font color="#ff0000">id</font><font color="#0000ff">="DataList1"</font> <font color="#ff0000">runat</font><font color="#0000ff">="server"</font></font></font></p><p id="d14f1408" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#ff0000">BorderColor</font><font color="#0000ff">="black"</font></font></font></p><p id="d14f1414" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#ff0000">BorderWidth</font><font color="#0000ff">="1"</font></font></font></p><p id="d14f1420" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#ff0000">GridLines</font><font color="#0000ff">="Both"</font></font></font></p><p id="d14f1426" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#ff0000">CellPadding</font><font color="#0000ff">="3"</font></font></font></p><p id="d14f1432" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#ff0000">Font-Names</font><font color="#0000ff">="Verdana"</font></font></font></p><p id="d14f1438" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#ff0000">Font-Size</font><font color="#0000ff">="8pt"</font></font></font></p><p id="d14f1444" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#ff0000">Width</font><font color="#0000ff">="150px"</font></font></font></p><p id="d14f1450" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#ff0000">HeaderStyle-BackColor</font><font color="#0000ff">="#aaaadd"</font></font></font></p><p id="d14f1456" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#ff0000">AlternatingItemStyle-BackColor</font><font color="#0000ff">="Gainsboro"</font></font></font></p><p id="d14f1462" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#ff0000">SelectedItemStyle-BackColor</font><font color="#0000ff">="yellow"</font></font></font></p><p id="d14f1468" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#ff0000">OnItemCommand</font><font color="#0000ff">="DataList_ItemCommand"</font></font></font></p><p id="d14f1474" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff">></font></font></font></p><p id="d14f1479" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">HeaderTemplate</font><font color="#0000ff">></font></font></font></p><p id="d14f1486" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> INTENS</font></font></p><p id="d14f1490" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"></</font><font color="#800000">HeaderTemplate</font><font color="#0000ff">></font></font></font></p><p id="d14f1497" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">ItemTemplate</font><font color="#0000ff">></font></font></font></p><p id="d14f1504" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">LinkButton</font> </font></font></p><p id="d14f1512" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#ff0000">id</font><font color="#0000ff">="button1"</font> </font></font></p><p id="d14f1518" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#ff0000">runat</font><font color="#0000ff">="server"</font> </font></font></p><p id="d14f1524" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#ff0000">Text</font><font color="#0000ff">="Detalhes..."</font> </font></font></p><p id="d14f1530" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#ff0000">CommandName</font><font color="#0000ff">="select"</font> <font color="#0000ff">/></font></font></font></p><p id="d14f1538" style="margin:0cm 0cm 0pt"> </p><p id="d14f1541" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <span id="d14f1544" style="background:yellow none repeat scroll 0% 50%"><%</span><font color="#0000ff">#</font> <font color="#008080">DataBinder</font>.Eval(Container.DataItem, <font color="#800000">"ValorString"</font>) <span id="d14f1548" style="background:yellow none repeat scroll 0% 50%">%></span></font></font></p><p id="d14f1550" style="margin:0cm 0cm 0pt"> </p><p id="d14f1553" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"></</font><font color="#800000">ItemTemplate</font><font color="#0000ff">></font></font></font></p><p id="d14f1560" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">SelectedItemTemplate</font><font color="#0000ff">></font></font></font></p><p id="d14f1567" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> Item:</font></font></p><p id="d14f1571" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <span id="d14f1574" style="background:yellow none repeat scroll 0% 50%"><%</span><font color="#0000ff">#</font> <font color="#008080">DataBinder</font>.Eval(Container.DataItem, <font color="#800000">"ValorString"</font>)<span id="d14f1578" style="background:yellow none repeat scroll 0% 50%">%></span></font></font></p><p id="d14f1580" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">br</font><font color="#0000ff">></font></font></font></p><p id="d14f1587" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> Data do Pedido:</font></font></p><p id="d14f1591" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <span id="d14f1594" style="background:yellow none repeat scroll 0% 50%"><%</span><font color="#0000ff">#</font> <font color="#008080">DataBinder</font>.Eval(Container.DataItem, <font color="#800000">"ValorData"</font>, <font color="#800000">"{0:d}"</font>) <span id="d14f1599" style="background:yellow none repeat scroll 0% 50%">%></span></font></font></p><p id="d14f1601" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">br</font><font color="#0000ff">></font></font></font></p><p id="d14f1608" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> Quantidade:</font></font></p><p id="d14f1612" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <span id="d14f1615" style="background:yellow none repeat scroll 0% 50%"><%</span><font color="#0000ff">#</font> <font color="#008080">DataBinder</font>.Eval(Container.DataItem, <font color="#800000">"ValorInteiro"</font>, <font color="#800000">"{0:N1}"</font>) <span id="d14f1620" style="background:yellow none repeat scroll 0% 50%">%></span></font></font></p><p id="d14f1622" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"><</font><font color="#800000">br</font><font color="#0000ff">></font></font></font></p><p id="d14f1629" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"></</font><font color="#800000">SelectedItemTemplate</font><font color="#0000ff">></font></font></font></p><p id="d14f1636" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"></</font><font color="#800000">asp</font><font color="#0000ff">:</font><font color="#800000">DataList</font><font color="#0000ff">></font> </font></font></p><p id="d14f1646" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"> <font color="#0000ff"></</font><font color="#800000">form</font><font color="#0000ff">></font></font></font></p><p id="d14f1653" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"><font color="#0000ff"></</font></font><font face="courier new"><font color="#800000">body</font></font><font face="courier new"><font color="#0000ff">></font></font></font></p><p id="d14f1658" style="margin:0cm 0cm 0pt"><font size="2"><font face="courier new"><font color="#0000ff"></</font></font><font face="courier new"><font color="#800000">html</font></font><font face="courier new"><font color="#0000ff">></font></font></font></p><p id="d14f1664" style="margin:0cm 0cm 0pt"> </p><p id="d14f1667" style="margin:0cm 0cm 0pt"><font size="2"><font face="verdana,sans-serif"> Espero que seja útil para alguém.</font></font></p><p id="d14f1670" style="margin:0cm 0cm 0pt"> </p><p id="d14f1673" style="margin:0cm 0cm 0pt"> </p><br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-84988946967885916462010-09-04T21:39:00.001-03:002010-09-04T21:39:21.785-03:00function retiraAcento(obj)Esta função em Javascript serve para retirar o acento ao digitar no textbox, assim fica mais limpo na base de dados as informações.<br><br>Segue abaixo:<br><br>function retiraAcento(obj)<br id="vj7:"> {<br id="vj7:0"> var palavra = event.keyCode<br id="vj7:1"> <br id="vj7:2"> var caracteresInvalidos = [192, 193, 194, 195, 196, 197, 224, 225, 226, 227, 228, 229, 199, 231, 200, 201, 202, 203, 232, 233, 234, 235, 204, 205, 206, 207, 236, 237, 238, 239, 210, 211, 212, 213, 214, 242, 243, 244, 245, 246, 217, 218, 219, 220, 249, 250, 251, 252 ];<br id="vj7:3"><br id="vj7:4"> var caracteresValidos = [65, 65 , 65 , 65 , 65 , 65 , 97 , 97 , 97 , 97 , 97 , 97 , 67 , 99 , 69 , 69 , 69 , 69 , 101, 101, 101, 101, 73 , 73 , 73 , 73 , 105, 105, 105, 105, 79 , 79 , 79 , 79 , 79 , 111, 111, 111, 111, 111, 85 , 85 , 85 , 85 , 117, 117, 117, 117 ];<br id="vj7:5"><br id="vj7:6"> var acento = [168, 39 , 94 , 96 , 126, 180 ];<br id="vj7:7"> <br id="vj7:8"> <br id="vj7:9"> // Verificando Acentos<br id="vj7:10"> for(a=0; a < acento.length; a++)<br id="vj7:11"> {<br id="vj7:12"> if(acento[a] == palavra)<br id="vj7:13"> {<br id="vj7:14"> window.event.keyCode = 0;<br id="vj7:15"> return;<br id="vj7:16"> }<br id="vj7:17"> }<br id="vj7:18"> <br id="vj7:19"> // Verificando os caracteres inválidos, se existir, trocar pelo caracter válido<br id="vj7:20"> for(a=0; a < caracteresInvalidos.length; a++)<br id="vj7:21"> {<br id="vj7:22"> if(caracteresInvalidos[a] == palavra)<br id="vj7:23"> {<br id="vj7:24"> window.event.keyCode = 0;<br id="vj7:25"> nova = caracteresValidos[a];<br id="vj7:26"> obj.value = obj.value + String.fromCharCode(nova);<br id="vj7:27"> obj.value = obj.value.toUpperCase();<br id="vj7:28"> return;<br id="vj7:29"> }<br id="vj7:30"> }<br id="vj7:31"> window.event.keyCode = 0;<br id="vj7:32"> obj.value = obj.value + String.fromCharCode(palavra);<br id="vj7:33"> obj.value = obj.value.toUpperCase();<br id="vj7:34"> <br id="vj7:35"> }<br id="vj7:36"><br id="aito35">// Deve ser incluido atributo no code behind como mostra abaixo<br id="aito36"><br id="aito37">this.tbx_Nome.Attributes.Add("onKeyPress", "javascript:retiraAcento(this);");<br id="aito38"><br id="aito39"><br id="aito40"> Espero que sirva para alguma coisa<br><br>Um abraço<br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-41464183762727244682010-09-04T20:09:00.001-03:002010-09-04T20:10:51.592-03:00ASP.NET C# executar função depois do enter no textBoxEu estava fazendo um cadastro e precisava deste complemento para a tela, ao digitar o codigo de um fornecedor ele ja busca na base os dados do produto e carrega os outros campos do produto para visualização.<br><br>Utilizei o doPostBack para efetuar este procedimento.<br><br>Só para vocês entenderem melhor o controle <b><font face="courier new">tbx_cd_cnpj_fili</font></b> é onde coloco o código do fornecedor, na minha função javascript precisei dos campos <b><font face="courier new">tbx_cd_trns</font></b> e <b><font face="courier new">tbx_cd_trns_1 </font></b><font face="courier new">somente para verificação de regra de negócio. Quando o DoPostBack é executado ele chama a função </font><b><font face="courier new"><font color="#0000ff">this</font>.CarregarTransportadora() </font></b><font face="courier new">que </font>é onde no Code Behind faço o acesso a base de dados e carrego os campos necessários.<br><br>Abaixo o código para o DoPostBack.<br><br><b>Exemplo do DoPostBack</b><br><br> Código colocado no Page_Load da página.<br><br><hr size="2"><font face="courier new"> <font color="#274e13">// Chamada do DoPostBack</font></font><br style="font-family:Courier New"><font face="courier new"> <font color="#0000ff">if </font>(!<font color="#0b5394">String</font>.IsNullOrEmpty(Request[<font color="#660000">"__EVENTARGUMENT"</font>]) &&</font><br style="font-family:Courier New"><font face="courier new"> Request[<font color="#660000">"__EVENTARGUMENT"</font>] == <font color="#660000">"1"</font>)</font><br style="font-family:Courier New"><font face="courier new"> {</font><br style="font-family:Courier New"><font face="courier new"> <font color="#0000ff">this</font>.CarregarTransportadora();</font><br style="font-family:Courier New"><font face="courier new"> }</font><br><br><font face="courier new"> <font color="#274e13">// Inclusão do Atributo de onkeypress no textbox que deseja executar a função<br> // No exemplo estou passando os textbox necessários para a função através da lógica que tinha que fazer<br></font> <font color="#0000ff">this</font>.tbx_cd_cnpj_fili.Attributes.Add(<font color="#660000">"onkeypress"</font>, "<u><font color="#660000">javascript:return verificarTecla(event, '1','"</font></u> + <font color="#0000ff">this</font>.tbx_cd_trns.ClientID + <font color="#660000">"','"</font> + <font color="#0000ff">this</font>.tbx_cd_trns_1.ClientID + <font color="#660000">"');"</font>);</font><br style="font-family:Courier New"><hr size="2" style="font-family:Courier New"><br><font face="verdana"> Código javascript que chama o postback passando o parâmetro para o code-behind.</font><br><br><hr size="2"><font face="courier new"> <font color="#274e13">// Função Javascript</font></font><br style="font-family:Courier New"><font face="courier new"> <font color="#0000ff">function</font> verificarTecla(e, eventArgument, tbx_1, tbx_2)</font><br style="font-family:Courier New"><font face="courier new"> { </font><br style="font-family:Courier New"><font face="courier new"> <font color="#0000ff">var </font>code = (window.<font color="#0000ff">event</font>) ? <font color="#0000ff">event</font>.keyCode : e.keyCode;</font><br style="font-family:Courier New"><font face="courier new"> <font color="#0000ff">var </font>tbx1 = document.getElementById(tbx_1);</font><br style="font-family:Courier New"><font face="courier new"> <font color="#0000ff">var </font>tbx2 = document.getElementById(tbx_2);</font><br style="font-family:Courier New"> <br style="font-family:Courier New"><font face="courier new"> tbx1.value = <font color="#660000">""</font>;</font><br style="font-family:Courier New"><font face="courier new"> tbx2.value = <font color="#660000">""</font>;</font><br style="font-family:Courier New"><br style="font-family:Courier New"><font face="courier new"> <font color="#0000ff">if</font>( code == 13 )</font><br style="font-family:Courier New"><font face="courier new"> {</font><br style="font-family:Courier New"><font face="courier new"> <font color="#0000ff">var </font>pageID = <font color="#660000">'<%= Page.ClientID %>'</font>;</font><br style="font-family:Courier New"><font face="courier new"> __doPostBack(pageID, eventArgument);</font><br style="font-family:Courier New"><font face="courier new"> <font color="#0000ff">return false</font>;</font><br style="font-family:Courier New"><font face="courier new"> }</font><br style="font-family:Courier New"><font face="courier new"> }</font><br><hr size="2"><br>Espero que tenha sido útil.<br><br>Um abraço<br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0tag:blogger.com,1999:blog-15795672.post-87644580162127589972010-09-04T19:51:00.001-03:002010-09-04T19:51:19.430-03:00DataSet Desconectado----------------------------------------------------------<b><br>UTILIZADO PARA CARREGAR O DATASET DESCONECTADO<br></b>----------------------------------------------------------<br><br> <span style="color: rgb(56, 118, 29);">// carrega os dados da tabela TB_TERR_MARC no dataset desconectado</span><br> <span style="color: rgb(0, 0, 255);">DataSet </span>v_obj_ds_marc = new <span style="color: rgb(0, 0, 255);">DataSet</span>();<br> POGWEB.WSConsulta.<span style="color: rgb(61, 133, 198);">Consulta </span>WSConsulta_marc = WSInvoke.CarregarWebServiceConsulta();<br> v_obj_ds_marc = WSConsulta_marc.SP_DIST_TB_TERR_MARC_S("S"<br> , <span style="color: rgb(0, 0, 255);">this</span>.id_terr<br> , null<br> , null<br> , null<br> , Context.User.Identity.Name.ToString().Trim()<br> , "S"<br> , null<br> , null);<br><br> Session.Remove(<span style="color: rgb(153, 0, 0);">"TB_TERR_MARC"</span>);<br><br> <span style="color: rgb(0, 0, 255);">this</span>.uct_cbo_dist.SelectedIndex = -1;<br> <span style="color: rgb(0, 0, 255);">this</span>.uct_cbo_marc.SelectedIndex = -1;<br><br> <span style="color: rgb(0, 0, 255);">if </span>(v_obj_ds_marc.Tables[0].Rows.Count > 0)<br> {<br> <span style="color: rgb(0, 0, 255);">foreach </span>(<span style="color: rgb(61, 133, 198);">DataRow </span>row in v_obj_ds_marc.Tables[0].Rows)<br> {<br> <span style="color: rgb(0, 0, 255);">this</span>.GravarTabelaTemporaria(row[<span style="color: rgb(153, 0, 0);">"id_dist"</span>].ToString()<br> , row[<span style="color: rgb(153, 0, 0);">"id_marc"</span>].ToString()<br> , row[<span style="color: rgb(153, 0, 0);">"nm_dist"</span>].ToString()<br> , row[<span style="color: rgb(153, 0, 0);">"ds_marc"</span>].ToString());<br> }<br> }<br><br> v_obj_ds_marc.Dispose();<br> <span style="color: rgb(0, 0, 255);">this</span>.CarregarGridDistrito();<br><br>---------------------------------------------------------------<br><b>FUNÇÕES PARA CRIAR O DATASET DESCONECTADO E GRAVAR</b><br>---------------------------------------------------------------<br><br><span style="color: rgb(0, 0, 255);">#region</span> Tabela Temporária<br><br> <span style="color: rgb(56, 118, 29);"> /// <summary></span><br style="color: rgb(56, 118, 29);"><span style="color: rgb(56, 118, 29);"> /// Cria DataSet que contera os dados</span><br style="color: rgb(56, 118, 29);"><span style="color: rgb(56, 118, 29);"> /// </summary></span><br style="color: rgb(56, 118, 29);"><span style="color: rgb(56, 118, 29);"> /// <returns>DataSet Formatado</returns></span><br> <span style="color: rgb(0, 0, 255);">private </span><span style="color: rgb(61, 133, 198);">DataSet </span>CriarTabela()<br> {<br> <span style="color: rgb(61, 133, 198);">DataSet </span>v_ds_tabl = new <span style="color: rgb(61, 133, 198);">DataSet</span>();<br> <span style="color: rgb(0, 0, 255);">if </span>(Session[<span style="color: rgb(153, 0, 0);">"TB_TERR_MARC"</span>] == null)<br> {<br> <span style="color: rgb(61, 133, 198);">DataTable </span>v_dt_tabl = new <span style="color: rgb(61, 133, 198);">DataTable</span>(<span style="color: rgb(153, 0, 0);">"TB_TERR_MARC"</span>);<br><br> v_dt_tabl.Columns.Add(<span style="color: rgb(153, 0, 0);">"id_dist"</span>, typeof(<span style="color: rgb(0, 0, 255);">string</span>));<br> v_dt_tabl.Columns.Add(<span style="color: rgb(153, 0, 0);">"id_marc"</span>, typeof(<span style="color: rgb(0, 0, 255);">string</span>));<br> v_dt_tabl.Columns.Add(<span style="color: rgb(153, 0, 0);">"nm_dist"</span>, typeof(<span style="color: rgb(0, 0, 255);">string</span>));<br> v_dt_tabl.Columns.Add(<span style="color: rgb(153, 0, 0);">"nm_marc"</span>, typeof(<span style="color: rgb(0, 0, 255);">string</span>));<br> v_ds_tabl.Tables.Add(v_dt_tabl);<br> }<br> <span style="color: rgb(0, 0, 255);">else</span><br> {<br> v_ds_tabl = (<span style="color: rgb(61, 133, 198);">DataSet</span>)Session[<span style="color: rgb(153, 0, 0);">"TB_TERR_MARC"</span>];<br> }<br><br> <span style="color: rgb(0, 0, 255);">return </span>v_ds_tabl;<br> }<br><br> <span style="color: rgb(56, 118, 29);">/// <summary></span><br style="color: rgb(56, 118, 29);"><span style="color: rgb(56, 118, 29);"> /// Grava Tabela Temporária</span><br style="color: rgb(56, 118, 29);"><span style="color: rgb(56, 118, 29);"> /// </summary></span><br style="color: rgb(56, 118, 29);"><span style="color: rgb(56, 118, 29);"> /// <returns></returns></span><br> <span style="color: rgb(0, 0, 255);">private bool </span>GravarTabelaTemporaria(string pa_id_dist<br> , string pa_id_marc<br> , string pa_nm_dist<br> , string pa_nm_marc)<br> {<br> <span style="color: rgb(0, 0, 255);">try</span><br> {<br> <span style="color: rgb(61, 133, 198);">DataSet </span>v_ds_tabl = new <span style="color: rgb(61, 133, 198);">DataSet</span>();<br><br> v_ds_tabl = CriarTabela();<br><br> // Verifica se já existe no grid<br> <span style="color: rgb(61, 133, 198);">DataRow</span>[] rows = v_ds_tabl.Tables[0].Select("id_dist = '" + pa_id_dist.Trim() + "' and id_marc = '" + pa_id_marc.Trim() + "'");<br> if (rows.Length != 0)<br> {<br> <span style="color: rgb(0, 0, 255);">this</span>.uct_lbl_msg.MessageType = LabelMessageType.Alerta;<br> <span style="color: rgb(0, 0, 255);">this</span>.uct_lbl_msg.Text =<span style="color: rgb(153, 0, 0);"> "Marca e Distrito já cadastrado."</span>;<br> <span style="color: rgb(0, 0, 255);">return </span>false;<br> }<br><br><br> <span style="color: rgb(61, 133, 198);">DataRow </span>v_ds_row = v_ds_tabl.Tables[0].NewRow();<br> v_ds_row[<span style="color: rgb(153, 0, 0);">"id_dist"</span>] = pa_id_dist.ToString();<br> v_ds_row[<span style="color: rgb(153, 0, 0);">"id_marc"</span>] = pa_id_marc.ToString();<br> v_ds_row[<span style="color: rgb(153, 0, 0);">"nm_dist"</span>] = pa_nm_dist.ToString();<br> v_ds_row[<span style="color: rgb(153, 0, 0);">"nm_marc"</span>] = pa_nm_marc.ToString();<br><br> v_ds_tabl.Tables[0].Rows.Add(v_ds_row);<br> v_ds_tabl.AcceptChanges();<br><br> Session.Add(v_ds_tabl.Tables[0].TableName.ToString(), v_ds_tabl);<br><br> <span style="color: rgb(0, 0, 255);">return </span>true;<br> }<br> <span style="color: rgb(0, 0, 255);">catch </span>(<span style="color: rgb(61, 133, 198);">Exception </span>ex)<br> {<br> <span style="color: rgb(0, 0, 255);">this</span>.uct_lbl_msg.MessageType = LabelMessageType.Error;<br> <span style="color: rgb(0, 0, 255);">this</span>.uct_lbl_msg.Text = String.Format(Mensagem.ObterMensagem(16), ex.Message);<br> <span style="color: rgb(0, 0, 255);">return </span>false;<br> }<br><br> }<br><br> <span style="color: rgb(0, 0, 255);">#endregion</span> Tabela Temporária<br><br>--------------------------------------------------------------------------------------------------------------<br><b>CAPTURANDO OS DADOS DO DATASET DESCONECTADO E PASSANDO PARA GRAVAÇÃO NO BANCO DE DADOS<br></b>--------------------------------------------------------------------------------------------------------------<br><br> System.Text.<span style="color: rgb(61, 133, 198);">StringBuilder </span>sb_id_dist = new System.Text.<span style="color: rgb(61, 133, 198);">StringBuilder</span>();<br> System.Text.<span style="color: rgb(61, 133, 198);">StringBuilder </span>sb_id_marc = new System.Text.<span style="color: rgb(61, 133, 198);">StringBuilder</span>();<br><br> <span style="color: rgb(0, 0, 255);">if </span>(Session[<span style="color: rgb(153, 0, 0);">"TB_TERR_MARC"</span>] != null)<br> {<br> <span style="color: rgb(61, 133, 198);">DataSet </span>v_obj_ds = new <span style="color: rgb(61, 133, 198);">DataSet</span>();<br> v_obj_ds = CriarTabela();<br><br> <span style="color: rgb(0, 0, 255);">if </span>(v_obj_ds.Tables[0].Rows.Count > 0)<br> {<br> <span style="color: rgb(0, 0, 255);">foreach </span>(<span style="color: rgb(61, 133, 198);">DataRow </span>row in v_obj_ds.Tables[0].Rows)<br> {<br> sb_id_dist.Append(row[<span style="color: rgb(153, 0, 0);">"id_dist"</span>].ToString().Trim() + <span style="color: rgb(153, 0, 0);">"|"</span>);<br> sb_id_marc.Append(row[<span style="color: rgb(153, 0, 0);">"id_marc"</span>].ToString().Trim() + <span style="color: rgb(153, 0, 0);">"|"</span>);<br> }<br> }<br> }<br><br> <span style="color: rgb(0, 0, 255);">if </span>(sb_id_dist.ToString().Equals(<span style="color: rgb(153, 0, 0);">""</span>))<br> {<br> <span style="color: rgb(0, 0, 255);">this</span>.uct_lbl_msg.MessageType = LabelMessageType.Alerta;<br> <span style="color: rgb(0, 0, 255);">this</span>.uct_lbl_msg.Text = Mensagem.ObterMensagem(263);<br> <span style="color: rgb(0, 0, 255);">return</span>;<br> }<br>Fabio's Bloghttp://www.blogger.com/profile/16581765287131122551noreply@blogger.com0