Questions tagged as 'sql-server'

1
answer

Error while backing up in wpf c #

I'm having trouble backing up my system. I'm using WPF with SQLSERVER 2008 , in this system I need to back up the data on the local machine of the client, so to create the directory of the backup on Disk C:\ . But he is returning...
asked by 19.02.2018 / 20:04
0
answers

System.Data.SqlClient.SqlException Conversion failed when converting date and / or time from character string

Live Personal, I'm new to the .NET world, C #, EntityFramework (Microsoft world). I am working on a project with the mentioned technologies, initially I was programming in a VM (with Windows) because I use MAC but I had some performance probl...
asked by 21.02.2018 / 16:13
3
answers

Record registration in DB

Hello, I'm having a Sql Server write problem, I have two tables (cargo and user), when I try to write the C # record, the error appears: (System.NullReferenceException: 'Object reference not set to an instance of an object. ' ObjectTransfer.User....
asked by 08.02.2018 / 15:20
0
answers

Join querys using outer apply

I have these three querys , and I want to merge them using outer apply . How can I do this? SELECT SR1.COMPANY, SR1.FILIAL, SR1.DOC, SR1.SERIE, SR1.LOCAL, SR1.TIPONF, SR1.CLIFO...
asked by 15.02.2018 / 13:09
0
answers

Sum Hours and Minutes Report Builder

Well, I have a column in the hour and minute report and I want to make the sum of them, but it gives an error as shown below. I tried to use the expression below, but to no avail. = Sum (Fields! Time_P_Classify.Value) Weather 01:15 03:48 1...
asked by 15.02.2018 / 15:16
1
answer

Error "No column name was specified"

Could someone tell me why this error occurred?    "Msg 8155, Level 16, State 2, Line 26 No column name was specified for   column 1 of 'A'. Msg 8155, Level 16, State 2, Line 42 No column name   was specified for column 1 of 'B'. " Follow t...
asked by 07.02.2018 / 17:18
1
answer

Data Comparison Entity Framework asp.net mvc

I need to get the value and quantity in stock of a given product according to your Id. For debug the product id is arriving correctly, but when I assign the values to the table fields I am having a conversion error. / p> // POST: Pedido...
asked by 16.02.2018 / 22:33
0
answers

HRESULT error: 0x80020003 on sql server

I'm working with a Sql server database and it started to present a strange error, preventing me from accessing the design and creating new tables. I searched the internet and could not resolve this error.     
asked by 17.02.2018 / 04:13
2
answers

What does the ^ = operator mean in C #?

I have a function in C #, where I decrypt a string and need to convert to a function in SQL Server for technicians to be able to work with the decrypted value. There is a foreach , which I do not understand how it works: var calculoChave...
asked by 27.01.2015 / 13:32
0
answers

Eclipse does not find source code for sqljdbcJar

My code works fine, I can start the connection to the database and everything else without problems. But at the time of creating a statement: Statement stmt = conexao.createStatement(); I get the following error: Thisoccurswithinmy"Obje...
asked by 01.02.2018 / 19:44