Questions tagged as 'sql-server'

Tagged questions
1
answer

Problem C # winforms LinQ

I am working CodeFirst and I have the following table in my DB and when I want to show it the query in a DataGridView brings all fields, but I want to show only 2, exactly the name and the price. What should I modify in the Linq query? var pro...
asked by 20.06.2018 / 18:30
2
answers

Sort records by defined quantity

I have the following Query. SELECT * FROM EMISORAS TE INNER JOIN SUCURSALES S ON S.NUM_ = TE.NUM_ WHERE ISR <= .16 AND HTP <= .03 AND TTB <=.06 ORDER BY ISR DESC, HTP DESC, TTBDESC But I need to show the other registers, that is to...
asked by 20.06.2018 / 16:46
1
answer

System.DataRowView Error loading ComboBox C #

I have the same problem friends, I understand how the DataTable works but when I'm trying to load a ComboBox through a query that contains 2 tables it shows me the System.DataRowView private void CargarComboCentrales() {...
asked by 20.06.2018 / 07:50
0
answers

Doubt about triggers in T-SQL

As far as I understand, when a trigger is executed for the insert event, the new records are added to a virtual table called inserted. When running for a delete event, the deleted records are added to a temporary table named deleted. But w...
asked by 18.06.2018 / 03:19
0
answers

Testing in ASP.NET project?

I have an application in ASP.Net, with web forms, but without any tests, and I would like to do them, now, unit tests would not be worth me since, it has many procedures that use up to 10 different tables with inner join and the paradigm is a mi...
asked by 18.05.2018 / 13:00
1
answer

Transpose columns in SQL with PIVOT?

Someone can easily explain me an example with PIVOT to transpose columns by rows in sql. I have several data represented as follows: FECHA ERROR1 ERROR2 2017-01-01 12 23 And I would like to transpose t...
asked by 17.08.2017 / 09:34
0
answers

connection to sql from c #

I have a problem, my new PC brings windows 10 home, for warranty issues I have not wanted to update it to windows 10 pro. I installed SQL SERVER 2017 correctly, but when starting the SQL MANAGMENT it shows an error of the connection, I activa...
asked by 05.05.2018 / 22:48
0
answers

Formula with grouping in Crystal Report

I have a problem that I could not solve to generate a report in crystal report with c# . Assuming I have the following table in sql server - A B C D - G 3 2 1 - G 5 6 7 - Y 2 5 6 - Y 3 2 3 Which I am interested in ge...
asked by 27.04.2018 / 18:50
1
answer

get the value of a query count SQL in a resultset of andorid studio

I hope you can help me, I'm making an android application that connects to sql server. I have a class that only helps me count the values of a column public void consulta( ){ ResultSet rs; PreparedStatement ps=conexion().prepareStatement("sele...
asked by 16.04.2018 / 23:47
0
answers

Inventory: update stock according to the amount that the user enters in an input in razor

I'm doing an inventory system, where I have to add or remove stocks of a product. I currently have a table producto where I keep the product data (as well as the amount that I have in stock), and a table movimientoEntrada , where I...
asked by 11.04.2018 / 19:10