Posts by Tafarel Chicotti • 2,715 points
83 posts
-
2
votes2
answers241
viewsA: Popular programmatically x data manually
Laerte, when you populate your Dropdown via code, you win in the matter of abstraction, because you can decouple the business rule coming from the bank through Datasource. For example, if you have…
-
7
votes1
answer18738
viewsA: How to make a webservice in php?
@garssail I’ll point you to some study links that I’m sure will help you Building Web Service with php Creating a web service with php in a few minutes Introduction JSON and PHP(Web Services) Manual…
-
-2
votes4
answers599
viewsA: Is there a problem omitting the semicolon in a php tag with only one expression
It is not good practice to omit, although it works as <?php echo "Assim funciona" ?> In this case, the compiler will check what is right after the text, and he sees that he has reached the end…
phpanswered Tafarel Chicotti 2,715 -
3
votes3
answers1948
viewsA: Set value of a null or Empty ROW on a gridview
Solution 1 You can make when creating the Datatable the fields that can be empty are of the type Nullable as the case of double? to allow null Edit: Solution 2 You make this change in RowDataBound…
-
3
votes1
answer244
viewsA: Multi-bank Login Control
Without informing in a specific programming language, I will indicate ideas. 1st - MASTER logins table One idea was to have a LOGIN table that is not part of any database, after validating whether…
-
2
votes2
answers443
viewsA: Paging results in SQL Server 2000
First of all I would recommend a nice upgrade, however there is a way to induce to do something similar ;WITH Results_CTE AS ( SELECT Col1, Col2, ..., ROW_NUMBER() OVER (ORDER BY SortCol1, SortCol2,…
-
1
votes1
answer150
viewsA: Interface to build relationships between tables
To php + MySQL there is the Workbench It is an application for visually/designer database modeling, very useful and that allowed you to see/build in the form of diagram and schemas the relations and…
-
1
votes1
answer502
viewsA: How to add an amount sent from an onclick to Ajax date?
In the javascript ajax, do so $.ajax({ type: 'POST', url: "@Url.Action("_ListaHistorico", "Solicitacoes")", data: { IdSolicitacao: $("#IdSolicitacao").val(), IdEmpresa: $("#IdEmpresa").val() },…
-
3
votes1
answer1338
viewsA: Animation library c#
Silvio, the Windows Presentation Foundation - WPF quoted by @Renan is the evolution of Winforms applications. XAML It is based on a pattern XAML(Pronounced as Zammel (sound of ZÊMEL)). XAML…
-
1
votes3
answers2078
viewsA: Questions about relationship and mapping with Fluent API for EF 6
@James has not to do with the answer itself of the question, but in another ready that you should pay attention to it, it is the way will work the load of these dependencies... For example, if you…
-
4
votes3
answers2078
viewsA: Questions about relationship and mapping with Fluent API for EF 6
The co-relation between the properties should be something like this //Revenda public ICollection<ClienteRevenda> { get; set; } //Navigation para os ClientesRevendas que possui…
-
3
votes2
answers2690
viewsA: EF 6, Fluent Api mapping in inheritance classes
James, probably your class must be something like this: public Pessoa { public int Id { get; set; } public int EmpresaId {get; set;} [ForeignKey("EmpresaId")] public Empresa Empresa {get; set;} }…
-
5
votes4
answers1585
viewsQ: How to make a "Generic Trigger" in SQL Server?
Hello I have in my database in all tables the following fields Datetime Criadoem | Datetime Modificadoem I wonder if you have a way to make a generic Rigger to control these fields, because when…
-
1
votes1
answer474
viewsA: Grab Javascript/jQuery from a button
To validate only the visible ones you can use the ignore of validateOptions var validateOptions = { ignore: ":not(:visible)", //Aqui está o que precisa fazer para validar somente os campos visíveis…
jqueryanswered Tafarel Chicotti 2,715 -
1
votes3
answers2192
viewsA: Incompatible date format when importing data from Excel to Mysql (00-00-0000 VS 0000-00-00)
I believe by your say in the question, that you are importing a file directly without opening it correctly? A tip for you, would be to create a Trigger in the database before inserting (before…
-
8
votes2
answers181
viewsA: Confusing encapsulation in c#
Vinicius is something simple what is happening... It’s not all wrong with your logic, but what happens in your case is that you made the property only with the get There are some ways to work like…
-
1
votes1
answer341
viewsA: Portable Database for WPF + C#
You can install an SQL Express, or use a . mdf file of SQL, Access, Mysql, Firebird whatever, in . NET you are free to be happy :) For study I recommend SQL Express, even for small…
-
4
votes2
answers650
viewsA: Creating custom Annotations in ASP.NET
One solution to this would be to create your CustomAuthorizeAttribute inheriting from AuthorizeAttribute Imagine for example something like AuthorizeByMe would look like this: public class…
-
8
votes3
answers32219
viewsA: Fetch last 7 days data from current date
Add this clause WHERE will take the current date and subtract 7 days, remembering that your date field, has q be of type date msm $query = mysql_query("SELECT * FROM tbl_registos WHERE data BETWEEN…
-
2
votes2
answers592
viewsA: How to build friendly Urls, such as Facebook and Twitter.
In your HTACCESS you should set something like RewriteEngine on RewriteRule ^([a-z]+)$ profiles.php?name=$1 There in your file php profiles. you recover the parameter $name and searches the…
-
1
votes2
answers485
viewsA: Two parameters with String.Format in an Asp:Hyperlink
Try something like that: <asp:HyperLink ID="HyperLink4" runat="server" onclick="<%# String.Format("AbreModal({0},\"{1}\"",val1,val2) %>"> <asp:Image ID="img_Historico" runat="server"…
-
32
votes2
answers1436
viewsQ: What it means '~' in front of the constructor of a C#class
Working on a project here at the company, I came across some commands that are now being used more (yield, ??, anonymous type) but until I understood, but one who called my attention by not knowing…
-
4
votes4
answers3455
viewsA: Is it possible to communicate Client-Server in real time via HTTP?
Real-time communication with the server is possible. You quoted something that already allows me to bring you a practical example (.NET) In the . NET technology was created a real-time service…
-
4
votes4
answers10727
viewsA: What is the Mysql CREATE VIEW command for?
A quote taken from the Imaster post (Working with VIEWS in MYSQL) A View is an object that belongs to a database, defined based on SELECT statements, returning a given data visualization of one or…
mysqlanswered Tafarel Chicotti 2,715 -
1
votes4
answers16962
viewsA: What do you call a "Stored Procedure"?
If you are using the Entity Framework, I recommend taking a look at these links here. EF with Entity Framework | Stackoverflow - EF with SP Already with the EF6:…
-
1
votes2
answers60
viewsA: Can I override already existing anottation on . net?
With a plugin called . NET Reflector you can access the code of the Annotation and see how it is worked. .NET Reflector…
-
1
votes2
answers1632
viewsA: Regex to pick numbers between the second and third "/"
If you want to remove any text, just use the following expression "[^0-9]" ou "[^\\d]" If it is /product/976935/ he will return 976935, but if it is /product/976935/1 he will return tbm the number 1…
-
5
votes4
answers7742
viewsA: How does grid system work?
Although I consider the documentation to be quite complete, let’s go. Official Grid Bootstrap System (English) The bootstrap works by dividing the screen into 12 columns. Regardless of which device…
-
2
votes3
answers5558
viewsA: Master-detail in MVC C# with Razor
I recommend you use the MVVM standard, especially Knockoutjs, it is a great package where brings your model to the view and based on it you can have this implementation of the list. The coolest…
-
2
votes2
answers1323
viewsA: Create and Edit Onetomany with Viewmodel
Try to do the following, create another attribute in your Viewmodel to receive the category that is selected, for example public class NoticiaCategoriaVM { public Noticia Noticia { get; set; }…
-
2
votes3
answers1601
viewsA: Breadcrumb algorithm in ASP.NET MVC
Searching some time ago about the same doubt, I found the following link that helped me. Breadcrumbs on Asp.NET MVC4 I’m sure you can help yourself too, even if not 100% of the way he did, but just…
-
0
votes6
answers11946
viewsA: Converting a string to int?
There are at least three types of conversions (Parse, Tryparse and Convert), ideally, you would understand how they work and use them according to your need. You can understand more about them in…
-
1
votes1
answer210
viewsA: SQL CE Insert Error in Database
Hello... the problem is in your query. it has in the end an extra parentheses SqlCeCommand comando = new SqlCeCommand(@"INSERT INTO Pedido([IDLayout], [Vim], [Data],…