Questions tagged as 'sql-server'

Tagged questions
1
answer

execute query TOP 1, JDBC

I have an application on android that connects to a database through JDBC, and when making a query with top 1, I get the following error:    java.sql, SQLEXCEPTION: use of the execute query (String) method is not supported on this type of sta...
asked by 13.12.2016 / 03:03
3
answers

How can I see the contents of a database in the browser?

I have a database that was created with a version of SQL Server old and I'm trying to open it in a new version. I get a message that says:    "The database can not be opened because it is version 852. This server   supports version 782...
asked by 21.11.2016 / 00:18
1
answer

I can not update the data source in VS

 I have a project in visual studio professional 2012 where I use the linq when I add a field to the database (in SQLServer) in the linq the new field appears in the image that I added I have the field cuenta_sobrante but it does not up...
asked by 01.11.2016 / 23:45
0
answers

Graph daily and weekly? [closed]

Good day, I find this situation and I would like some idea of how to solve it please, this coupled with the fact that I am new by programming in c #. I need to make a graph that shows me the production of 4 lines (1,2,3,4) and the days of the we...
asked by 04.11.2016 / 16:49
1
answer

Connection to SQL Server

I'm trying to make a connection from my local project to a SQL database that I made and uploaded to a server, the server gives me the string connection to use, but when I use the open it throws me error SqlConnection cn = new SqlC...
asked by 01.09.2016 / 22:27
1
answer

Data Model Inventory TypeOperations Movements

I have a doubt in my data model in the Movements table, in that table I have an AffectedId field, which is going to relate to Sales, Purchases, Promotions, Prizes, Donations, Warehousing, etc. In the Table TypeOperacion is where these operations...
asked by 26.08.2016 / 18:52
0
answers

In a SQL report in local way to execute the SQL that I have in the dataset instead of having to pass the data

I am investigating the different possibilities of SQL Server Report . I have seen that on the server, when you execute a report , it connects against the string that you connect in the DataSource1 and then executes the stateme...
asked by 12.09.2016 / 16:19
1
answer

How to upload data to the network from a desktop program developed in visual studio 2013 [closed]

I have a program developed in visual studio (windows form) with database in sql-server 2012 and I want to know if I can upload this data to a web page or website.     
asked by 01.09.2016 / 04:51
2
answers

Error Timeout ASP.NET SP

I have a detail when loading the StoredProcedure and fill in a datatable , I mark the error:    "Timeout expired The timeout period elapsed prior to completion of the operation or the server is not responding The statement has be...
asked by 16.08.2016 / 19:31
1
answer

query from transact sql to linq

I have a query in Transact SQL , and I need to modify it to LinQ for a migration of a program I'm doing, but I've had problems specifically with a function of SQL Server , the datediff , with which It has been difficult...
asked by 03.08.2016 / 21:14