Questions tagged as 'ado.net'

Tagged questions
1
answer

Problem when saving row in DataSet using ADO.net

I bring you another little problem that came up during my project (which is almost finished already). What this code is supposed to do is create a new "Artist" row, add it to the dataset (in its datatable) and update the database. Well, it's cle...
asked by 16.11.2018 / 17:53
1
answer

Problems connecting Mysql with VB.NET

I'm trying to connect a Mysql database with .NET and download the connector for this page Link where you download the connector and this is the code that I use in .NET Imports MySql.Data.MySqlClient Public Class conexion Private MysqlComm...
asked by 04.10.2018 / 22:28
2
answers

How to make queries prepared with VB.NET and SQL Server?

I have experience programming in Java and I have taken as a personal project to learn .NET languages (VB.NET and C #). In JAVA, the following is used to create MySQL prepared queries to avoid SQL injection: public void consultaPreparada()...
asked by 21.10.2017 / 22:53
0
answers

Go from BL to Web layer

I am doing a CRUD in ASP.NET with a database in Azure using ADO.NET, for the layers I have BL, DAL, Entities and finally the UI, I have passed from DAL to BL the update code but I do not know how pass it from BL to Vista and the previous pass it...
asked by 09.11.2018 / 21:19
0
answers

Format of date VB.net EF

Function TraeConta(ByVal DAT_CODIGO As Integer, ByVal DAT_NRO_ORDEN As Integer, ByVal DAT_RUTPAC As Integer) As MIN_CONT_CONTACTADOS Dim cont As New MIN_CONT_CONTACTADOS Try...
asked by 11.06.2018 / 17:24
0
answers

Change the CommandTimeout to a WebMatrix Database query

Someone knows how to increase the CommandTimeout in a query by using the class Database from WebMatrix, internally creates a sqlCommand object with a default time of 30 seconds. My code is similar to the following: var db = Database.Open(...
asked by 13.06.2018 / 19:22
1
answer

Fail to add ADO.NET element

I just downloaded the Visual Studio 2017 , I have XAMPP also in the latest version, and so does the Workbench 6.3 . Also lower the Connector/Net 8.0.11 to make the connection. But at the time I try to add an ADO.NET entity data mo...
asked by 04.05.2018 / 21:36
0
answers

Problem to load Store Procedure with ADO.NET

I am developing an ASP MCV web application with C #, to link my application to a SQL Server 2012 database I have used ADO.NET and I have created a Model.edmx as shown in the image: The problem that occurs to me is that I do not see all the...
asked by 19.04.2018 / 22:05
0
answers

Nested parameters in VB.Net and SQL Server

Greetings to all, I am making an application in VB.NET and SQL Server. I have a stored procedure that retrieves all the columns of a table, passing as a parameter the password, the detail is that I need to save the recovered data to send it as a...
asked by 02.01.2018 / 23:01
1
answer

Asp.net mvc 4 ado.net or lambda?

Dear, I am just starting on asp.net mvc 4 programming and the truth is that I feel somewhat lost. I come from working on Windows Forms and ASP.Net N layers, which used ADO.Net and it made it easier for me to create my Stored Procedures in S...
asked by 13.10.2017 / 23:45