Posts by dil_oliveira • 478 points
16 posts
-
3
votes2
answers2092
viewsQ: Fill all fields of an Object iteratively
I have a Class public class Objeto { public int _numero { get; set; } public DateTime _data { get; set; } public string _palavra { get; set; } public decimal _decimal { get; set; } } Is it possible…
-
1
votes4
answers6317
viewsA: Empty field and zero value check
Try it like this: int zero = 0; int.TryParse(TB_Peso.Text, out zero); if(String.IsNullOrWhiteSpace(TB_Peso.Text) || zero == 0) LBL_Peso.Visible = true; else LBL_Peso.Visible = false;…
-
5
votes1
answer309
viewsQ: Retrieve information about which Tables/Procedures/Views are most accessed in SQL SERVER
select db_name(database_id) as banco, object_name(object_id) as objeto, stats.user_seeks, stats.user_scans, stats.user_lookups, stats.user_updates from sys.dm_db_index_usage_stats as stats I have…
-
1
votes1
answer1468
viewsA: How to mount a Select to join columns
You have not specified the database and this code works in Mysql, for other Sgdbs search correspondents for the LENGTH and TRIM functions; select cod_cliente, (case when LENGTH(TRIM(Nome)) > 0…
-
3
votes1
answer1433
viewsQ: Problems with NOLOCK, READ COMMITTED SNAPSHOT
I always see sqls mounted with WITH NOLOCK that say improve performance, but I’ve also heard that NOLOCK is obsolete and what should be used now is READ COMMITTED SNAPSHOT, in this scenario my…
-
0
votes2
answers931
viewsA: Select returns nothing at all
try like this: public DataTable ObterDataTable(string conexao, string sql, string nomeTabela) { DataTable dt = new DataTable(nomeTabela); using (SqlCommand cmd = new SqlCommand(sql, conexao)) {…
-
1
votes1
answer498
viewsA: Take 2 select value and display the data of each
I would do with ajax, passing the Ids of the products selected in the lists; function buscaProduto(callback, id) { $.ajax({ type: "POST", contentType: "application/json; charset=utf-8", url:…
-
1
votes1
answer1160
viewsA: How to view a BD Access form directly on a website?
From what I understand you would like to display the access form directly on a web page in correct ASP? If that is what I say is not possible, what you can do is convert the data either from an…
-
0
votes1
answer1666
viewsA: I cannot create table in SQL SERVER
"When you search too hard you don’t see what’s right in front of you". It was using Microsoft SQL Server Management Studio Express version 9.**. ****. **, which is suitable for use with instances of…
-
0
votes1
answer1666
viewsQ: I cannot create table in SQL SERVER
I have an instance of SQL SERVER installed locally where I am administrator, I can create Databases but I can’t create tables. Here is a photo of the error that SQL displays. More Some Details:…
-
4
votes4
answers395
viewsQ: How to Debug only one project in Visual Studio?
I have six C# web projects inside a Solution in Visual Studio 2010, when running debug, Visual Studio launches the six projects at once, each of them in a different process. I wonder if there’s like…
-
2
votes1
answer8726
viewsQ: How to get the value of a list of ckeckboxes with jquery?
I’ve tried the following: <input name="chklista" id="chk01" value="01" type="checkbox" />01<br /> <input name="chklista" id="chk02" value="02" type="checkbox" />02<br />…
-
1
votes2
answers10106
viewsQ: Change SQL SERVER SA Password with Windows Admin Account
I received a machine with an instance of SQL Server 2008 installed, I can access this instance through SQL Server Management Studio Express with my Windows administrator account but I can’t perform…
-
0
votes1
answer557
viewsQ: How to prevent browser from displaying previous alert and resend information?
Work in a WEB application . aspx that saves data in the database. The problem is that after recording this data and displaying a successful information to the user, if I do a Reload on the page the…
-
6
votes3
answers4136
viewsA: Program does not read scanf
give a space between the quotation mark " and the % symbol in: scanf("%s",&nome); scanf("%d",&aposta); scanf("%c",&op); being like this: scanf(" %s",&nome); scanf(" %d",&aposta);…
canswered dil_oliveira 478 -
2
votes2
answers2499
viewsA: How to take position of the Object (Indice)
do so: function procurar(objeto_, procurado_) { var encontrou = false; var retorno = []; function recursiva(objeto) { if(typeof objeto === 'object') { for(var i in objeto) { retorno.push(i);…