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
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()...
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...