Questions tagged as 'sql-server'

Tagged questions
0
answers

Fill Spinner with SQL

I am trying to fill a spinner through a query of SQLServer, I put you in situation. I am making a form from which I bring data from my database and I put them in EditText or TextView, until then everything is fine. I find now that fill a spin...
asked by 16.05.2018 / 10:12
0
answers

how to delete a record from a table using linq and sqlserver and c #

someone some example code how to delete a record from a table using linq and sqlserver and c # I want the record to be deleted when I press the red line what is stored in a sql server table but do so by calling a store procedure    ...
asked by 18.05.2018 / 08:39
0
answers

Load dynamic excel using Integration Service

What I need help is to be able to file with dynamic names using integration service, for example I have 5 files in a folder using a loop for each achievement to upload the 5 to a target table in SQL, my problems is that I would like the next loa...
asked by 18.05.2018 / 18:31
1
answer

Error converting DBNull object datagridview

I have the following code: This is declared the variable at the beginning of all my code: int editado = 0; This method I use in a button. public void Insertar { try { for (int i = 0; i < dgvFor...
asked by 21.05.2018 / 23:17
2
answers

How do I query two tables with a column called equal?

What I want is that with these two tables see if in the column (which is equal in both) is equal to a request.form For now I have this but this error marks me Ambiguous column name 'Punto_Tactico'. set rs_pTactico = server.CreateObject("ADO...
asked by 14.05.2018 / 22:30
0
answers

Structure of the sepomex table

I am downloading the SEPOMEX database to use it in one of my applications, the question is that they ask me to break down the structure of that database. In my first image I show the fields that I am going to take from the database (highlighte...
asked by 09.05.2018 / 17:28
0
answers

INSERT in SQLSERVER with DELPHI XE4

I am new to Delphi XE4 and can not find where my error is in the query: INSERT into CUENTAS (codigocu,nombre,apellido,idcondiva,email) values ( :icodigocu, :inombre, :iapellido, :iidcondiva, :iemail); The error that shows me is this: dbex...
asked by 05.05.2018 / 20:58
0
answers

Send Image To Later Show it

as they are ... My problem is that I have an image, the application takes the photo, shows it in a Web service. Through this code: private void tomarFoto() { Intent takePictureIntent = new Intent(MediaStore.ACTION_IMAGE_CAPTURE); if (t...
asked by 30.04.2018 / 17:51
2
answers

Pass data from one query to another activity, listview

I asked a question about how to pass data between activities, and they answered me well, but my problem now is that I do not need to pass a simple string or an integer, I need to pass a query SQLserver, put it in the intent and then pass it to t...
asked by 02.05.2018 / 10:50
0
answers

XML query help in sql server 2016

I have the following problem, I am receiving the following XML and I need to get the values <s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"> <s:Body> <TipoTerceroResponse xmlns="http://tempuri.org/">...
asked by 11.05.2018 / 18:15