Posts by Harry • 3,805 points
339 posts
-
3
votes1
answer1210
viewsQ: Query using the Entity framework
Within my repositorioEF I have the methods, in the method ExcluirRegistro I’m passing a StatusRegistro for the bank indicating that this record is being deleted, then in my methods ListarPorId and…
-
5
votes1
answer773
viewsQ: Write include date using Entity framework
I believe there was a misinterpretation, I’m posting the code to be better understood. I am using a project for my EF Repository is inside it I have: Note the doubt in //companySalvar.DATA_IND =…
-
2
votes2
answers7137
viewsQ: Error in registering a Firebird 2.0 bank in Ibexpert
I’m having a hard time registering a Firebird 2.0 database on Ibexpert. I appreciate the help! The following mistakes are happening: Attempt 01 Attempting to connect to:…
-
2
votes3
answers7027
viewsQ: Is Sql Server Agent (SQLEXPRESS) on Local Computer started stopped?
Hello, I have a machine with windows 10 I did the installation of SQL Server normally, it was working, only now SQL Server does not start, I went to the service manager and when trying to boot I…
sql-serverasked Harry 3,805 -
0
votes0
answers607
viewsQ: Sql Server 2008 - Error: Undefined object reference for an object instance?
I was using sql server 2005, after doing the update, all databases does not allow the display of tables in Design mode, and does not let create new tables. I tried to make the creation of a table in…
-
1
votes1
answer1927
viewsQ: Display the return of a query with 2 tables in the same View in ASP.NET MVC
Controller: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using HelloMobile.Models; namespace HelloMobile.Controllers { public class…
-
1
votes1
answer94
viewsQ: How to format mvc helpers according to my Bootstrap layout?
I am trying in various ways to adjust the layout according to the Helpers <!-- rightpanel3 --> <div data-role="panel" id="opcoesusuario" data-position="right" data-display="overlay"…
-
1
votes1
answer36
viewsQ: Doubt with time recording data in master-detail tables?
After entering a record, I use the select max(IDControle) to recover table id to record items. When the time is only 1 second, I noticed that the items were all recorded in the first record. Does…
-
2
votes1
answer120
viewsQ: Question with Table Update Trigger
I have two tables, questions and answers, and would like to update the same according to what is selected: Sql Server Database 2005 Problem: --usuário excluindo a pergunta (não está gravando a data…
-
0
votes1
answer171
viewsQ: What’s the best way to do these triggers?
I wonder if there is a better way to write these Rigger. thank you --gatilho para gravar os dados do usuário CREATE TRIGGER TGR_TB_USUARIO_INSERT ON TB_USUARIO FOR INSERT AS BEGIN DECLARE @IDUSUARIO…
-
0
votes1
answer91
viewsA: How to Perform a Procedure at Every Insert?
The solution would be the creation of a triggers Creation would look like this: Insert into tb_pergunta values ('1','1','','title question','Description','','','') USE [BANCOTESTE] GO /******…
-
1
votes1
answer91
viewsQ: How to Perform a Procedure at Every Insert?
When I go to register I want according to the selected category to record a moderator id, in the question table. select idcategoria from tb_pergunta select idmoderador,idcategoria from tb_moderador…
-
5
votes2
answers543
viewsQ: How to organize the return of data in a List<T>?
I have a wcf that returns me some information, I would like to bring them organized, how could I do it? I’d like to return data like this: At the moment it’s like this: I’m doing like this: public…
-
0
votes1
answer329
viewsQ: Use include with Jquery Mobile?
I would like to make a page as it is done with Razor MVC (_Layout) with header, and footer, and make inclusion of it in the other pages, as I could do this? I want to do the AJAX Load Content Look…
-
1
votes1
answer136
viewsQ: WCF service hosting with endpoint creation?
I noticed that when running a Rest type project when opening the interface, opens the internet browser is lists all the contents of the folder, being necessary to select the ".svc" when running the…
-
2
votes1
answer45
viewsQ: System.Invalidoperationexception Database Opening Error?
I am using webMatrix, to develop an example in Jquerymobile, I am having the following error @{ Layout="~/shared/_Layout.cshtml"; Page.Title = "Home"; Page.Header = "Categorias"; var db =…
-
2
votes1
answer1180
viewsQ: Doubt with backup postgres?
I have on the same machine a Postgresql 9.0 server and also a Postgresql 9.4, I have a database in this latest version, when I try to make a backup I have the following error, as it could solve this…
postgresqlasked Harry 3,805 -
6
votes3
answers130
viewsQ: How to implement methods in Json using Serializable?
I’m making a webservice where I want to return the data in JSON, how I could implement the methods, which is the best way? GET PUT DELETE POST I did a GET method, it went like this: using System;…
-
0
votes0
answers73
viewsQ: Return columns according to sql server criteria?
How could I return the column names of a table according to search criteria? I want to return the columns that are with option’S', all fields is a char of 1 that takes "s" or "n" select b.livros,…
-
3
votes1
answer513
viewsQ: What’s the best way to get information to View?
I have the following code: public ActionResult AtualizaCliente(int id) { ViewBag.idFoto = new SelectList(dao.fotos, "idFoto", "Foto"); ViewBag.idInformacao = new SelectList(dao.informacoes,…
-
4
votes3
answers685
viewsQ: Doubt with Getdate()?
I have an SQL query that should bring me only records whose date is longer than the date of the day, but records with the current date are coming. Thanks! --não deveria mostrar a data de hoje select…
-
0
votes1
answer773
viewsQ: Show only positive delay days in SQL query?
I am making a query where I intend to calculate the amount of days of delay in a salary, I would like to show only if there are days of delay, at the moment I am showing days remaining for the…
-
1
votes1
answer553
viewsQ: How to call the same Actionresult more than 1 time to refresh the page?
I need to call Actionresult each time I select a new record in the Dropdownlist calling only 1 time when loading the page. No Controller private string PegarCaminhoImagem(Int16 controle) {…
-
2
votes1
answer907
viewsQ: How to create a new img tag with jQuery?
I would like to change the c:\imagem.jpg according to what was selected in the <option id="selecao" value="01">c:\imagem.jpg</option>. Follows the code: <DOCTYPE html> <html>…
-
2
votes1
answer118
viewsQ: How to work with @Html.Dropdownlist?
Friends After following the example I made the adjustment in the code, I am not able to send the information to Actionresult @model ProjetoDelphiMobile.Models.cliente @{ ViewBag.Title = ""; }…
-
1
votes1
answer1029
viewsQ: Doubt Insert Image with Jquery?
Friends, Following the posted examples, I made the adjustments: public ActionResult ThumbNail(int largura, int altura, string caminhofoto) { if (caminhofoto != "caminho" ) { WebImage webImagem = new…
-
2
votes1
answer65
viewsQ: Can the Entity Framework not map a table in the MVC occur?
I added a new table in Model.edmx, but it was not created in Model.Context.Cs the public DbSet<informacoes> informacoes { get; set; } is also not created in Model.tt the class of this table.…
-
0
votes1
answer398
viewsQ: How to work with Database Views on ASP.NET MVC?
Views doesn’t have a primary key so it causes me to make a mistake: Error: The number of Primary key values passed must match number of Primary key values defined on the Entity. How could I avoid…
-
2
votes3
answers10463
viewsQ: How to use @Html.Radiobutton, how to send the selected option to the controller?
I’m trying to send the selected option of Radiobutton to the controller, I’ve tried to do several ways, I’ve searched several places and I don’t have a solution. Thanks Index @model…
-
0
votes2
answers386
viewsQ: LINQ to Entities does not recognize the 'Boolean Like' method?
I am having this error when trying to make one with query using LINQ to SQL after making the suggested changes: {SELECT `Extent1`.`idcliente`, `Extent1`.`nome`, `Extent1`.`pai`, `Extent1`.`mae`,…
-
1
votes1
answer481
viewsQ: Query using Linq to sql in Asp.net MVC
I have a question about how to return the records according to the query. I don’t know what could be wrong, but the query is not returning according to what was past. I have my controller: public…
-
2
votes2
answers138
viewsQ: Doubt with _viewStart on MVC4
I have 2 layouts (LayoutPrincipal.cshtml and LayoutInterno.cshtml) to home page is another to the internal page. The internal page will repeat so I did the creation of the _ViewStart which points to…
asp.net-mvcasked Harry 3,805 -
4
votes1
answer322
viewsQ: How to update the result field based on criteria?
I have the following table: CREATE TABLE ALUNO ( RA NUMBER(9), DISCIPLINA VARCHAR2(30), MEDIA NUMBER(3,1), CARGA_HORA NUMBER(2), FALTAS NUMBER(2), RESULTADO VARCHAR2(10) ); And the following data:…
-
0
votes1
answer985
viewsQ: How to return data from a Webservice in XML format?
I am using an example of webservice, but it is generating me an error stating that "Response' does not exist in the context Current", someone knows what could be wrong? NOTE: Error runs at build…
-
1
votes1
answer32
viewsQ: Error using Rsaprotectedconfigurationprovider
I am making an example using Rsaprotectedconfigurationprovider and I generated an error, I am unable to solve the problem. NOTE: correction, the error was solved, I had forgotten a detail, now if…
-
-1
votes1
answer127
viewsQ: Interface implementation error in WCF
I’m making an example using WCF is generated me an error and I’m not able to figure out what could be wrong. Error message: Wcfservice.Service1 does not implement interface Member…
-
1
votes1
answer44
viewsQ: Difficulty with MVC Code Debugging
One of the problems I have had in the studies is the way the code debugging is done in mvc, I can’t find a logic to solve this. OBS: The sample code option is not formatting the code properly. The…
-
0
votes1
answer562
viewsQ: Doubt with View Tipada?
I got the following: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using PostGetModel.Models; namespace PostGetModel.Controllers { public…
-
4
votes3
answers152
viewsQ: Viewdata error in controller
What could be wrong in this example? I can’t do it: var pessoa = new Pessoa ( PessoaId = 1, Nome = "teste teste", twitter = "@teste" ); Error message: 'Name' does not exist in the Current context…