Click here to Skip to main content

Submit your article

CSV

CSV

Great Reads

Lightning-Fast Nested User Groups in C#

by Daniel Miller

This article describes the C# implementation for a high-performance user/role security principal hierarchy.

ANNT : Convolutional neural networks

by Andrew Kirillov

The article demonstrates usage of ANNT library for creating convolutional ANNs and applying them to image classification tasks.

Loading CSV and SQL Data into Pandas

by Glenn Prince

In this second part of the Data Cleaning with Python and Pandas series, now that we have a Jupyter Notebook set up and some basic libraries initialized, we need to load some data. To do this, we’ll load data from a CSV file, as well as from a local SQLite database.

Classification using Logistic Regression in Visual Basic

by chlohee

Machine Learning. What languages come to mind? R? Python? Matlab? Bet you didn't think Visual Basic.

Latest Articles

Cinchoo ETL - Deserializing JSON to Polymorphic Classes without Type Information

by Cinchoo

Tip to deserialize JSON to polymorphic classes without type information

Query Excel or CSV files with T-SQL

by Federico Di Marco

Query Excel or CSV files with T-SQL without importing them in a table first

Classification using Logistic Regression in Visual Basic

by chlohee

Machine Learning. What languages come to mind? R? Python? Matlab? Bet you didn't think Visual Basic.

Three Useful Programs with Open Storage

by Mirzakhmet Syzdykov

Develop programs with open storage using pre-defined format

All Articles

CSV

Lightning-Fast Nested User Groups in C#

5 Dec 2015 by Daniel Miller

This article describes the C# implementation for a high-performance user/role security principal hierarchy.

ANNT : Convolutional neural networks

28 Oct 2018 by Andrew Kirillov

The article demonstrates usage of ANNT library for creating convolutional ANNs and applying them to image classification tasks.

artificial-intelligence

Loading CSV and SQL Data into Pandas

29 May 2020 by Glenn Prince

In this second part of the Data Cleaning with Python and Pandas series, now that we have a Jupyter Notebook set up and some basic libraries initialized, we need to load some data. To do this, we’ll load data from a CSV file, as well as from a local SQLite database.

artificial-intelligence

Classification using Logistic Regression in Visual Basic

9 Sep 2023 by chlohee

Machine Learning. What languages come to mind? R? Python? Matlab? Bet you didn't think Visual Basic.

machine-learning

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

4 Feb 2012 by udhaya2code

While using Microsoft Text Driver to read CSV data to DataSet in C# in your 64 bit machine

CSV/Excel File Parser - A Revisit

7 Apr 2018 by #realJSOP

An example of evolving code to fit new demands

string manipulation

16 Nov 2010 by Fredrik Bornander

This should do the trick I think;string input = "Dogs Cats Birds"string pattern = "\\s+";string replacement = ",";Regex rgx = new Regex(pattern);string result = rgx.Replace(input, replacement)Hope this helps,Fredrik

Convert KML coordinates to CSV or XML

31 May 2012 by VJ Reddy

If the requirement is to break the set of coordinates into separate lines, then the Replace method of Regex class can be used to replace the spaces which are not preceded by or followed by a comma as shown below:string kmlInput = @"-86.36762, 37.31916 , 0 -86.43890,37.31916,0...

Least Squares: A Matrix Approach in Java

17 Apr 2023 by Mark H Bishop

Computational classes and a GUI interface to illustrate usage

Convert .csv to .txt [VB.NET]

26 Sep 2016 by Patrice T

easy Solution:Just replace the extension to .txt.Rename or copy MyFile.csv to MyFile.txt and you are done.Or do nothing and use the csv file as a text file directly.Nota: a csv file is a text file!

Getting Started with Machine Learning DotNet for Clustering Model

31 Oct 2018 by syed shanu

In this article, we will see how to work on Clustering model for predicting the Mobile used by model, Sex, before 2010 and After 2010 using the Clustering model with ML.NET.

machine-learning

How to read contents from an excel file into a text file using c#?

17 Dec 2013 by Maciej Los

This is quite often asked question. Please see my past answer: How to get sql tables columns in excel sheet after click button in c#[^]Have you read Code Project Quick Answers FAQ[^]? Probably NOT. Next time, please use SearchBox[^] at the right-top corner on this site.

ASP MVC Export/download Grid contents in different file formats csv,excel,pdf

12 Feb 2016 by lakhdarr

Different ways to export a grid contents to different file formats csv, excel, pdf using ASP MVC

Please check my code does that meet the requirements. It is a CRM.

15 Aug 2019 by OriginalGriff

When you posted this last time, I told you to read it again, and pay attention to the "Expected demonstrable skills" section. And you have totally ignored it, and written a monolithic procedural app with not a trace of the required skills. Is there any point in asking for comments if you ignore...

HTML to CSV using jQuery

21 Dec 2010 by Brij

Excel files support embedded images, CSV files do not. So the short answer is: You can't export images.And regarding the HTML table, you can the following jQuery plugin.Click here

Handling Single Quote Issue in ODBC

22 Jun 2011 by Prerak Patel

Easiest way,Line 7: strSQL = "SELECT * FROM data.csv WHERE column1 = '" + sDataValue.Replace("'", "''") + "'";Proper way, Use parameterised query.Line 7: strSQL = "SELECT * FROM data.csv WHERE column1 = ?";Line 8: OdbcCommand cmdSelect = new OdbcCommand(strSQL, CsvConn); ...

Get results to write to CSV using Perl

19 Jul 2011 by Uilleam

I believe your error is rooted in not really understanding the meaning of my. You are using it all over the place, but when you do that you are creating a new variable in the enclosing block. You should really go back and check every instance of my to see if that is what you really want to...

CSV header with period character C# datatable

6 Aug 2011 by Wonde Tadesse

Have a look at this [^]blog. This is other way converting CSV into datatable. It might solve your problem. In addition to this you can try the this[^] CSV parser.[EDITED]This because, if you want try to bind your DataTable with such column it might throw exception due to (.) period...

How to match items in listview and images in imagelist

27 Dec 2011 by Espen Harlinn

Have a look at ObjectListView[^]Here is an article A Much Easier to Use ListView[^].If you really want to use the standard listview, have a look at custom painting[^].Best regardsEspen Harlinn

Upload Excel Sheet into database vb.net, sql server

20 May 2012 by vangapally Naveen Kumar

first you have to store excel data in datatable,you can store data in datatable asstring constring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MySpreadsheet.XLS;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=2"""datatable dt=new datatable();Oledbconnection con=new...

How to validate the csv file in asp.net with C#

28 Aug 2014 by vangapally Naveen Kumar

1.If column names are fixed means you already know column names compare the column names with data base column names.To do this first fill the data table from excel then you compare with column names.ConnectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data...

Lower case for String "true" and "false" not working

21 Dec 2015 by CHill60

If you have text that you want to remain untransformed by Excel then you must save it in the CSV file surrounded by double-quotes e.g. if a file contains TRUE,True,true,"True","true"Then the last two columns are explicitly text columns. If you set the columns to "Text" format then when you...

CodeProject Statistics Calculator Using WebDriver

17 Jan 2017 by Anton Angelov

A tool for creating a report for author's articles for a specific year or from the beginning of time. Calculates the total number of views.

Phpexcel cannot fix error: you tried to set a sheet active by the out of bounds index

19 May 2017 by ZurdoDev

The error is very clear, isn't it? You are trying to activate a sheet that does not exist. Remember that indexes are 0 based so trying to access sheet with an index of 3 when there are only 3 sheets will not work. 3 sheets mean there are indexes 0, 1, and 2.

How to read multiple CSV file in a folder in

24 Mar 2018 by RickZeeland

Here is an interesting library for reading and writing CSV files: GitHub - JoshClose/CsvHelper: Library to help reading and writing CSV files[^] You can also use LINQ, here is an example to calculate the average age: // Read CSV using LINQ static void ReadFileLinq(string fileName) {...

How to read multiple CSV file in a folder in

24 Mar 2018 by OriginalGriff

Start by working out how you are going to read the CSV data: there are a whole load of ways including writing your own CSV processor, but A Fast CSV Reader[^] is a good way to start. When you have the data, processing the column to get the average, median, or mean is trivial!

How to read multiple CSV file in a folder in

25 Mar 2018 by Maciej Los

It's easy to calculate median[^], because it's a middle/central value* of ordered list. * - for even number of values - it's an average of two values from middle of ordered list Follow the above link for further details. //case #1 - even number of values //int[] ages =...

Using diff -e Option to Create a Baseline diff File

23 Jun 2018 by Alvin Bunk

How to use diff -e option to create a baseline diff file

Requirements overview we require you to write a “C# console application” for a basic customer relationship manager (CRM) application. Need to fetch data from CSV file

14 Aug 2019 by OriginalGriff

I would strongly suggest two things: 1) Read the requirements carefully. You appear to have missed quite a few of them. Pay particular attention to everything in the "Expected demonstrable skills" section, because as far as I can see you have demonstrated none of them at all in that code. To be...

Please check my code does that meet the requirements. It is a CRM.

15 Aug 2019 by Dave Kreskowiak

I wouldn't even accept the code you wrote as the answer to homework assignment. You've got nothing but report methods that all do pretty much the same thing. The method reads the file, parses it, does some manipulation and spits out a report. Just the fact that you're you are COPYING AND...

Word containing single quote breaks to next column after single quote while filling to oledb dataset in csv file import

3 Sep 2019 by OriginalGriff

Simple solution: Never concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Always use Parameterized queries instead. When you concatenate strings, you cause problems because SQL receives...

Parsing CSV Files Directly from VBA

8 Mar 2021 by W. García

VBA solution for CSV parsing problem

Cinchoo ETL - Converting CSV to JSON with Nested Objects and Arrays

7 Oct 2021 by Cinchoo

Tips to converting CSV to JSON with nested objects and arrays

How can I add a string to the start of each row in a CSV file?

10 Jan 2022 by k5054

You could do it with Notepad++ : Notepad++ add to every line - Stack Overflow[^] You might be able to use PowerShell's replace method to do the job, too. There's an article here[^] on that. If you can't make replace add text to the start of...

Pandas dataframe from txt

20 Apr 2022 by Richard MacCutchan

You first need to structure the data into a form that pandas can process. See pandas.DataFrame — pandas 1.4.2 documentation[^].

Quick, Simple and Elegant way to convert C# data model to CSV

18 Aug 2019 by rohitsies

CSV file generator using simplistic approach

Importing CSV data to a Dataset, then exporting to a SQL Server

26 Oct 2010 by RDBurmon

Yeah, Roger , there is one smarter way to do this.did you know about SSIS (Microsoft Business Intelligence Studio) ?IF you have a set up of SSIS ? Please let me know the version .I will give you whole step to do these task .

Converting data to csv format using C#. ?

15 Nov 2010 by Laurence1234

Hi there RudolfErasmum, The String class will have handy functions like 'String.Split', as to create a CSV you will need to delimit your original text by a predetermined character. After you have split down your text the StringBuilder class will be a handy to rebuild your strings...

string manipulation - 2

17 Nov 2010 by Fredrik Bornander

Try this;using System;using System.Text;using System.Text.RegularExpressions;namespace SomeNameSpace{ class Program { private static string input = "VMMAnalogs_Acquire.c 1.26 2001_105/02 2001_105/02\n" + ...

regular-expression

fetch datetime from a Excel sheet through OleDbDataAdapter

12 Mar 2011 by Robert Rohde

Try adding IMEX=1 to your connection string:string connString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=\"" + dir + "\\\";" + "Extended Properties=\"text;HDR=No;IMEX=1;FMT=Delimited\"";This should tell Excel to treat all columns as strings. You can than parse everything by yourself.

[Solved]C# setting dtable column names via csv

21 Apr 2011 by Nish Nishant

In your OLEDB connection string add HDR=YES.

Help Reading Comma Delimited file

5 Dec 2011 by JackDingler

One big problem you have is that you're treating the input as if it has fixed length fields. A comma delimited file is unlikely to be formatting this way.Rather than fix the code you have, I suggest a rewrite.Use the string::find(',') function to find the comma locations, and parse using...

How to match items in listview and images in imagelist

27 Dec 2011 by Sergey Alexandrovich Kryukov

You English is fine; I wish other members could post their question in such a clear language free from ugly spelling mistakes. However, your problem looks artificial. You put some unmatched data in controls in first place and later wants to match items. Why?You should do the following: you...

Stop CSV file writing

20 Sep 2012 by AmitGajjar

Hi,You can Create BackgroundWorker which can be used to work in background and you can handle events to perform your desired work.Check MSDN Article : Background Worker[^]Hope it will work for you.Thanks.

CSV to TXT Converter DLL in C#

20 Nov 2012 by R. Giskard Reventlov

One way is to read the file into a string and then parse the string to replace commas with a tab character except when the comma is inside a pair of single or double quotes.You will also have to handle when a comma is used as a decimal separator. So, there's a hint: now write some code and,...

Generating and Splitting a Delimited String Column

17 Jan 2013 by Tharaka MTR

This article describes the easiest way to create and process delimited row using SQL XQuery.

SQL-Server-2005

SQL-server-2000

C# CSV Streamreader converts \t to \\t

4 Sep 2013 by David Knechtges

Yes, simple. Just use this string.split overload instead:String.Split(String[], StringSplitOptions)[^]

How do you use a CSV as a Linq Database File in C# Console Application like Windows Forms Application?

8 Sep 2014 by kbrandwijk

Your first challenge would be to read the CSV into a format that you can easily use. You have a number of options, these two are the most common:1. Create a class that corresponds to your CSV record. Write code to read the CSV and fill the objects manually, like this:from line In...

How to terminate CSV based on comma in below condition

30 Apr 2015 by OriginalGriff

It's complicated, but there are a lot of ways to make it easier. I prefer this one: A Fast CSV Reader[^] - it does what it says!

Parse CSV with Headers in defined in XML

21 May 2015 by Mathi Mani

Hi,This solution will the parse the XML, CSV file and have the data in a datatable. You can change it to any form that suits your requirement. Here are the steps:Parsing XMLParse the XML and keep the column names in a List for selecting the required columns once CSV file is parsed. In...

How can I fix the invalid character display in CSV files?

19 Jun 2015 by Sergey Alexandrovich Kryukov

It simply means that the H₂O was stored in the database as Unicode, using one of the UTFs (the subscript code point U+2082, "subscript two") and you wrote the Unicode string in one of the non-Unicode encodings, such as ASCII. The question mark you got is the usual "fallback" character used when...

How to create XElements in XElement with adaptable array length?

14 Jul 2015 by Matt T Heffron

Do you need to treat one of the columns specially to be the XAttribute instead of XElement? If not, this can be simplified...using System;using System.Collections.Generic;using System.IO;using System.Linq;using System.Xml.Linq;namespace ConsoleApplication6{ class Program ...

Searching a csv file for an id [Solved]

16 Aug 2015 by Patrice T

You should try thisdef find_details(id2find): surfers_f=open("surfing_data.csv") for line in surfers_f: s={} (s['id'],s['name'],s['country'],s['average'],s['board'],s['age']) = line.split(";") if id2find==int(s['id']): surfers_f.close() ...

How to read from CSV file to two dimensional array

21 Aug 2015 by Garth J Lancaster

I'm not sure what your issue is ...You declare and instantiate a 4 x 4 array of the appropriate data type - double ?You declare and initialise an integer variable, for the rowYou open, then read the file containing the values, line by line, maybe into a string For each string holding a...

C# CSV Delimiter formatting Problem, how to format properly

27 Oct 2015 by User 59241

As it is a comma delimited file you cannot put in commas that are not meant as delimiters: https://en.wikipedia.org/wiki/Comma-separated_values[^]The easiest way (but not the only way) is to remove them as you are creating the csv:...

how to insert csv file into mysql database table using c# windows form

16 Aug 2021 by Member 12078840/divya

When i click Submit button .I need to get chosen csv file are upload in to mysql database table String MyCon = "SERVER=*****;" + "DATABASE=*****;" + "UID=root;" + "PASSWORD=******;" + "Convert Zero Datetime = True";private void...

how to insert csv file into mysql database table using c# windows form

20 Nov 2015 by Sarath kumar.N

There are lot of solutions on the internet. I found one solution for easy understanding. Please make sure your columns in the CSV file as same as MySql database columns.Method 1: Using SqlBulkCopy const string CSV_CONNECTIONSTRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data...

How would I average the values associated with a date from a csv file

22 Apr 2016 by Richard MacCutchan

Create a class that will hold the Date and a List of time values. Then create a List which will contain objects of that class. Each time you read a line you check to see if there is an object in the main list containing that date entry. If there is not, then create new object, and add it...

Export datatable to csv using csvhelper

8 Jun 2016 by Richard Deeming

Based on your code, it looks like you just need to remove the using (var DT = new DataTable()) line, and replace each reference to DT with CHAIN:public void EXPORT_CSV(){ using (var textWriter = File.CreateText(@"D:\Temp\NewCsv.csv")) using (var csv = new CsvWriter(textWriter)) ...

Import csv file to database SQL server in C# windows application without header

8 Jun 2016 by AFell2

When you create the DataTable, since your csv file does not have a header record, you need to supply the column names. Since you didn't do this, and then subsequently call the DataTable row fields by their column names, the value returned for each field is null since the DataTable doesn't...

Convert CSV data header and value to JSON format

24 Aug 2016 by Richard Deeming

If you haven't done so already, use NuGet to add a reference to Json.NET[^]:Install-Package Newtonsoft.JsonImport the LINQ to JSON namespace:Imports Newtonsoft.Json.LinqThen, use JArray[^], JObject[^] and JProperty[^] to build your objects:Dim fieldCount As Integer =...

How to read specific CSV cell?

25 Aug 2016 by Richard Deeming

Assuming you're always skipping the first three lines, and the CSV data is always separated from the extra data by a blank line, something like this should work:Private Function ReadCSVData(ByVal filepathname As String) As JObject Dim result As New JObject() Using sr As New...

How do I get country name of my IP address?

20 Sep 2016 by Garth J Lancaster

if you look at the api doc (for csv) IP Geolocation API - CSV [ip-api][^] you'll see that the return info is success,COUNTRY,COUNTRY CODE,REGION CODE,REGION NAME,CITY,ZIP CODE,LATITUDE,LONGITUDE,TIME ZONE,ISP NAME,ORGANIZATION NAME,AS NUMBER / NAME,IP ADDRESS USED FOR QUERYso, if you do...

Convert .csv to .txt [VB.NET]

26 Sep 2016 by Maciej Los

As an addition to the solution1 by ppolymorphe[^].How to: Move a File in Visual Basic[^]How to: Rename a File in Visual Basic[^]File.Move Method (String, String) (System.IO)[^]

How to pass specific portion of the csv file

29 Sep 2016 by #realJSOP

Well, the first thing you need to do is identify the pattern(s), and code for that. After a cursory glance, the pattern looks like this:ASSTROLLUPSTRT ACCTHDR [section name] ACCTHDR [column names] ACCTDTLS, Detail data... ACCTALLOHDR [subheader...

How to pass specific portion of the csv file

29 Sep 2016 by jinesh sam

Myself found solution. Please anyone suggest any simple or easy way class Program { static void Main(string[] args) { var lines = File.ReadAllLines(@"Mycsvfile.csv").Select(x => x.Split(',')).ToList(); List lstAccountDetails = new List(); ...

Import csv file containing large precision floating point C++

14 Dec 2016 by Jochen Arndt

The C standard library functions atof and strtod are not rounding off any decimal places that can be hold by a double. The rounding occurs probably when printing them out. To show all significant digits that can be hold by a double precision value use the [s]printf format "%.16G" (using the...

How do I filter csv lines by date range in C#

20 Jun 2017 by RickZeeland

I never used CsvHelper, but on visiting the Issues on the GitHub page I noticed an issue: Multiple date format support · Issue #603 · JoshClose/CsvHelper · GitHub[^] After reading that I think for dates might you need to use something like: TypeConverterOption("yyyyMMdd") Updated answer: ...

How to validate CSV file data C#

12 Sep 2017 by Graeme_Grant

I use this for importing CSVs: GitHub - kentcb/KBCsv: KBCsv is an efficient, easy to use .NET parsing and writing library for the CSV (comma-separated values) format.[^] And to validate email addresses, pick the best one that suits your needs: c# validate email address - Google Search[^] -...

Querying data from CSV file in C# running in the console

15 Mar 2018 by Member 12445973

I would recommend using CSV helper (add it via NuGet packet manager to your project GitHub - JoshClose/CsvHelper: Library to help reading and writing CSV files[^] to read data from file. Create collection (List for example) of queryable objects (define your type) and then use Linq to find,...

How to read multiple .csv which is present in a folder by C# console application.?

25 Mar 2018 by #realJSOP

First, replace this line: string csv_file_path = @"C:\Sample files\L.csv"; with these lines: string[] files = Directory.GetFiles(@"C:\Sample files", "*.csv", SearchOption.TopDirectoryOnly); foreach(string file in files) { DataTable csvData = GetDataTabletFromCSVFile(csv_file_path); ...

How to sort my values according to my date from a CSV file in Python?

9 Jun 2018 by User 7429338

Rather than creating separate arrays for openf, close, high, low and date, you could create a class that has these properties: class Row: def __init__(self, openf, close, high, low, date): self.openf = openf self.close = close self.high = high self.low = low self.date = date ...

How to give out data in a lable C#

22 Jul 2018 by OriginalGriff

Try this: connectinString = "Data Source = " + fileName + ";max database size=256"; using (conn = new SqlCeConnection(connectinString)) { using (md = new SqlCeCommand("SELECT COUNT(*) FROM Pigeons", conn)) { conn.Open(); label1.Text =...

How to give out data in a lable C#

22 Jul 2018 by F-ES Sitecore

label1.Text = cmd.ExecuteScalar().ToString();

CSV to XML - when the data.csv is outside from the folder the XML-import.xml save file is empty

2 Oct 2018 by Richard Deeming

PHP: POST method uploads - Manual[^] PHP 5 File Upload[^] You're trying to open the file given its path on the client. You need to open the file using the temporary path on the server where the uploaded file was saved. Replace: if(isset($_POST['fname'])){ $value = $_POST['fname']; } ...

XML-documentation

C# script formatting CSV into SQL insert statement

17 Dec 2018 by OriginalGriff

Use string.Split to break each line of the input in two: string[] parts = input.Split(','); Then use string.Format to "bolt them together" again: if (parts.Length == 2) { string output = string.Format("\"{0}\",\"{1}\"", parts[0], parts[1]); ... Or even like this: if (parts.Length == 2)...

I am creating csv file from reading a csv file but after reading the csv file its reporting some garbage value in csv file in VB.NET

18 Jan 2019 by OriginalGriff

We can't tell; we don't have access to your code, or - more importantly - the input CSV file. And you need both - preferably along with the output file - to even start fixing this. So we can't do it for you - it's going to be up to you. Start by remembering that compiling does not mean your...

How do delete a specific row from a csv file based on a user input?

23 May 2019 by darryl wong

I'm doing a school assignment and I created a delete function to remove a row from a csv file. But it doesn't match my user input and delete the specific row. It just clears the file once I have entered an ID. I'm not sure whats the right way to do it hope i could find some help here. This is...

Importing csv tom ysql database - how to read file with polish characters?

11 Jul 2019 by Maciej Los

Assuming that you properly set Character Sets and Collations[^]... Solution #1 - using StreamReader Constructor (System.IO) | Microsoft Docs[^] with utf-8 encoding using(StreamReader sr = new StreamReader(excel, System.Text.Encoding.GetEncoding("utf-8"))) { string headerline =...

Importing csv tom ysql database - how to read file with polish characters?

12 Jul 2019 by Member 10696161

I don't know but i found that solution: in my connection string wasn't added a "charset". If i look at "cmd.ExecuteNonQuery" is not sending Unicode to the MySQL database. So i added to this code line and it looks like this: string connection =...

How to speed up import a large csv file to mysql database?

15 Jul 2019 by Dave Kreskowiak

One of the reasons it's so slow and consumes so much memory is because you're reading the entire file into a DataTable object. That'll take forever to do and consume a ton of memory. Don't. Just process each record as it's read and save it to the database. You don't need the DataTable or the...

Requirements overview we require you to write a “C# console application” for a basic customer relationship manager (CRM) application. Need to fetch data from CSV file

14 Aug 2019 by Patrice T

Quote: We require you to write a “C# Console Application” for a basic Customer Relationship Manager (CRM) application. In CRM anything is about databases. The piece of code you show is not even remotely linked to database. Quote: This document will need to be imported into the application,...

Please check my code does that meet the requirements. It is a CRM.

15 Aug 2019 by MadMyche

From your comments on your question on this topic 1 day ago: Requirements overview we require you to write a “C# console application” for a basic customer relationship manager (CRM) application. Need to fetch data from CSV file[^] I think you are well beyond this point:Important Considerations...

Update a csv column value using input parameter as row and column value in java code

28 Oct 2019 by Richard MacCutchan

Use the CSVParser class to read the records and the CSVPrinter to write out the updated values. The documentation at org.apache.commons:commons-csv:1.7 api doc - javadoc.io[^] contains the class details and samples.

Can I read multiple CSV files (in a folder) using multithreading for fast processing in C#

8 Nov 2019 by Richard MacCutchan

Multithreading is not guaranteed to make a great difference, and will depend on what your code is doing. The first thing to look at is where the slow processing actually occurs. Is the delay due to the speed of getting the data off disk, or in processing it once it's in memory?

Excel to csv error after deployment 80070005 access is denied.

11 Apr 2020 by Dave Kreskowiak

What nobody has mentioned yet is that you cannot use Office Interop, in your case Excel, in a web application. It may work fine on your machine, but in a multi-user app and deployed to a web server, Office is not supported. On the "Access...

Python CSV 2D array itteration for specific entries

9 Jun 2020 by Richard MacCutchan

print(accounts.read()) # this reads all the lines from your file, but you don't save the result print(Username, "1") for row in accounts: # there is nothing to read now, since it has all been read above Remove the line print(accounts.read())...

multi-dimensional

A script in Python 3.7 that parses the price of EURUSD after a certain period of time and writes data to a csv file

8 Jul 2020 by OriginalGriff

Quote: I guess you need to dig towards regular expressions. I guess you need to dig towards regular expressions - it isn't my homework, and I can already use them. If you want to get started with Regexes, then get a copy of Expresso[^] - it's...

Empty values are written as empty string to database instead of NULL

29 Sep 2020 by Sandeep Mewara

You need to set the value as DBNull. Quote: If a database field has missing data, you can use the DBNull.Value property to explicitly assign a DBNull object value to the field. Refer: DBNull.Value Field (System) | Microsoft Docs[^] Example:...

Convert CSV to a single column in datagridview VB

23 Nov 2020 by OriginalGriff

First off, that's not CSV - it stands for "Comma Separated Values" and strictly, that isn't separated by commas, it uses hyphens instead. And the other problem is that CSV is organised into rows of columns, and you appear rto not be doing that at...

Memory leak after realloc call

23 Apr 2021 by OriginalGriff

We can't really help you - we have no access to your data file, and you kinda need that in order to work out what is going on. So, it's going to be up to you. Fortunately, you have a tool available to you which will help you find out what is...

Unable to print the file in a for loop and update the array contents

8 Jul 2021 by Richard MacCutchan

You could start by fixing the basic syntax and other errors: import os import glob import csv path=r"E:\Users\ConfocalUser\Documents\GitHub\qudi" files=glob.glob(os.path.join(path,'*.csv')) # add the second closing parenthesis here xData=[]...

How to see a number with more than 15 characters in datagridview

21 Aug 2021 by Afzaal Ahmad Zeeshan

Quote: In the csv file it looks 8940012004412026012 and after import in datagridview show 8.9400120044120259E + 18 That is just two ways of representing the same numeric value. Since the number is big, the output is being shown as an...

Save wordsearch generator to CSV file

19 Oct 2021 by Richard MacCutchan

See csv — CSV File Reading and Writing — Python 3.10.0 documentation[^]

Change default name of a downloaded CSV file.

13 Dec 2021 by Chris Copeland

Assuming you're using this jQuery plugin[^] (correct me if I'm wrong) you just need to look at the documentation on that page to work out what you need to provide. These options apply only when the 'download' action is used filename default:...

How can I add a string to the start of each row in a CSV file?

11 Jan 2022 by CHill60

Solution 1 gets my vote - I'm a fan of Notepad++ but if you do decide to go down the CSV suggestion in Solution 2 here is a far quicker alternative and this also fills in some of the gaps from Solution 2 * Insert a new column A either by...

How do I only show CSV files when I open file dialog

27 Jun 2022 by Richard MacCutchan

See FileDialog.Filter Property (System.Windows.Forms) | Microsoft Docs[^]. Also, if I remember correctly the filter index starts from one rather than zero.

How do I only show CSV files when I open file dialog

27 Jun 2022 by OriginalGriff

First off, correct your code so it compiles: C# is case sensitive, so OpenFileDialog_Import is not the same as openFileDialog_Import: OpenFileDialog OpenFileDialog_Import = new OpenFileDialog(); ^ | ... if...

How do I convert the scientific notation to it's original number?

11 Jul 2022 by Patrice T

Quote: How do I convert the scientific notation to it's original number? The scientific notation: 1.00004E+11 The original number: 100004438998 In this case, you can't. Because your initial conversion to scientific notation have lost a part of...

Filtring csv file datas and save them another csv file using Python

13 Oct 2022 by Sandeep Mewara

Did you try something like below. Filtering: df[df.name.str[-1].apply(lambda x: x in ['a', 'e', 'i', 'o', 'u'])] Refer: Lambda and filter in Python Examples[^] Saving to CSV: df.to_csv('new-location\\output_filtered_sample1.csv', index=False,...