ado.net

Hello Everyone , I'm trying to get multiple rows from the database and my problem is the last rows is returned for all private static List<Messages> GetMessages(string LastID) { SqlCommand sqlCommand; SqlConnection con; con = new SqlConnection("data source = ")...

We are making a form where a user can log in and in turn upload listings for cars to sell, however, the data grid view for the listings isn't showing every entry even though it is in the database when it is being first loaded. I also notice too that updating the data grid view and refreshing it...

I am using .Net 6 and Framework 4.8 to build an app with Visual Studio but I can't seem to create the Ado .Net Entity Model it is not listed when I try to create a new class. Is there a simple way to create it on mac?

I need your help PLEASE . I developed a desktop application ( c# ; .NETFramework 4.7.2 ) with Visual studio2019 & SqlServer2017 ; and I tried to deploy it but it doesn't work in another laptop . I get the error message : ************* Débogage JIT ************** Pour activer le débogage...

I have a SSIS package that is trying to load the information from a csv file into a SQL Server table. The DB Connection is defined as an ADO.NET connection and I have parameterized the connection string. See the screenshots below. Below is the code snippet that I am using to establish...

I want to create a connection to the server. The base is called NORTHWND. I wanted to create a connection using a configuration file. I created a configuration file. I want to get information about the version of the server I am using through the console application. However when I run the code...

I'm new to winform. I built a webapp using ASP IDENTITY for USER registration. But now i have to use Credentials created by ASP IDENTITY to login in already existing window app(ADO.NET is used). How can i login in winform ???

I work on c# app I need to make function make insert data or update or delete dynamically so that I do function below for insert or update or delete but I don't know what must added or remove from function below to make function work as best practice . public static async Task<int>...

I working on c# 5 app create more than excel files xlsx but I face Issue I cannot compress these files to one file as zip archive . meaning if result of code below of three files as abc.xlsx and autod.xlsx and mog.xlsx as examples then create all theses file to one file as zip archive with...

I work on c# desktop app I cannot export data to excel sheet with multiple tab meaning multi sheet based on data exist on data table module field I use open XML library Data table data as below : Divide Output Excel File To Multi Tab based On Module PartId Company Files Tab Module 1222...

Problem Error display in linq query "specific cast is not valid" at System.Data.DataRowExtensions.UnboxT`1.ValueField(Object value) at System.Data.DataRowExtensions.Field[T](DataRow row, String columnName) LinqQuery give error var query1 = (from x in table1.AsEnumerable()...

Hi ALL, I have two databases(SQlserver and MS Access) with same schemas (same tables). SQL server database has data but Access has no data (blank database). My goal : when user enters a ClientId and click insert button then I need to retrive that single record from all tables in sql server...