Click here to Skip to main content

Submit your article

Data

data

Great Reads

Understanding Merkle Trees - Why Use Them, Who Uses Them, and How to Use Them

by Marc Clifton

An interactive demo of how audit and consistency proofs work

Highstock + Data-Forge + Yahoo

by Ashley Davis

A demo of Highstock using Data-Forge with financial data loaded from Yahoo

Fast Fourier Transform Caterpillar Method

by Alexander Semjonov

Developing fastest FFT implementation based on precompile tool using data driven approach

Simple Way to Convert HTML Table Data into PHP Array

by Garbel Nervadof

Convert HTML table data from a website into PHP array

Latest Articles

SQL Table Dependency Diagram Generator (SSMS 18,19 & 20)

by Bert O Neill

This article provides an overview for developers, on how to quickly generate a dependency Entity Relationship Diagram for a table and its immediately related tables, within SQL Server.

How Much Can Sqlite Handle? Multiple Threads Concurrently Inserting Into Sqlite

by raddevus

An informal study of the Sqlite database and how many concurrent inserts it can handle. Will help you decide if you want to use Sqlite in your projects.

Fededim.Extensions.Configurati...

by Federico Di Marco

Fededim.Extensions.Configuration.Protected is an improved ConfigurationBuilder which allows partial or full encryption of configuration values stored inside any possible ConfigurationSource and fully integrated in the ASP.NET Core architecture using Data Protection API.

Templated Data container with Razor

by Pete O'Hanlon

Rather than littering a razor component with @if (a == b) logic to show items, use render fragments to make a declarative component

All Articles

Data

Dynamic Data Master Page Filtering

29 Mar 2011 by #realJSOP

Try this:ControlType control = (ControlType)Master.FindControl("controlID");And then you should be able to get the selected index.

Insert multiple rows to a DB using DAAB without multiple round trips

4 May 2011 by #realJSOP

Would it be possible to simply transfer the table as a binary file using FTP or TCP/IP, and then let the remote machine do all the database work itself?If you want to ensure some kind of recovery system (in the event the transfer is interrupted), you could send smaller files and alt least...

How to sum cell values of datagridview

30 Sep 2016 by #realJSOP

0) Create a model for your items1) Load the results of the database query into a list of model items2) Create a new model item that contains the desired summed fields (use LINQ to get your sums).3) And the new model item to the list4) Bind the list to the dataGridView control.

How can I update my dataset in WPF

21 Nov 2016 by #realJSOP

0) You need a public property to bind to. public Userss Users { get; set; }And you can set the DataContext in the constructor:this.DataContext=this;1) Why are you setting the ItemsSource in both the XAML and the code-behind?2) Compartmentalize your code. Put the database...

CSV/Excel File Parser - A Revisit

7 Apr 2018 by #realJSOP

An example of evolving code to fit new demands

Example for update delete record in WPF C# using data grid control update delete buttons in separate panel

2 Feb 2015 by /\jmot

Ref.http://www.dotnetwindow.com/2014/04/WPF-Insert-Update-Delete-Operation-on-Datagrid.html[^]http://www.dotnetcurry.com/showarticle.aspx?ID=566[^]http://www.dotnetcurry.com/showarticle.aspx?ID=563[^]https://gsselle.wordpress.com/2013/05/26/wpf-datagrid-update-insert-and-delete-operations...

binding datalist using procedure/dataset

28 Nov 2011 by 07navneet

error on runtime-Maximum stored procedure, function, trigger, or view nesting level exceededhtml:In DataList:- ...

Import Excell data to Create HTML Templates

30 Jul 2012 by 0aFzaL

Hi,I was looking for a kind of Software that would allow me to generate bulk HTML Files, according with the data. At The moment I am using Lotus Domino from IBM, but it is returning some errors, and I don't know what else to change. I was looking for an alternative software that could allow...

First website help AGAIN!

21 Jun 2011 by 2irfanshaikh

How do I change my Database server? Or How do I make a proper Database server? Install Sql server. Attach the App_Data database in Sql Server.Change the connection string in the IIS7 Website's web.config file.

Can we able create stored procedure in Ms-access

24 Nov 2011 by 3796068

Hi all,Can we create stored procedure in Ms-accessThanks

How to upload file and how to save it in database?

19 Nov 2012 by _Amy

Hi,Refer the links below for the similar solution:Uploading files to database in C#[^]Upload and Download File From Database Using GridView[^]MSDN : FileUpload Class[^]Hope it helps!--Amit

Data wrangling csv to .inst

8 May 2022 by A v Nov2021

Given a csv file of different instances, how do I convert each instance to a xml file? Given : Instantiation, var_a,var_b 1,state0,state1 2,state0,state0 3,state1,state1 4,state1,state0 Output : 4 xml files with different names, each should...

How to send email in PHP on button click

22 Aug 2017 by A_Griffin

There are tons of examples on how to do this on the web. Google it! But here's one[^] to get you started.

how to import execelsheet data into database

1 Feb 2014 by Abdullah Qudeer

If you are using sql server you can import excel sheet directly with out writing a Single line of code.Write click on data base -> Tasks-> Importdata.Click on next and select data source as Microsoft Excel .Give the file path and click next.Select sheet to Import and set table name you...

Reading/Writing Data From TextBox to SQL Server DB VB.NET

16 Mar 2011 by Abhinav S

This beginner's guide should help you get started[^].

Help in storing data of treeview using arraylist

5 Apr 2011 by Abhinav S

I would consider using a Dictionary object.

Not Enforce Foreign Key Constraints On Entity Data Model

28 Aug 2011 by Abhinav S

Read more about Referential Constraints[^] in the Entity Framework.

entity-framework

Server - Client Application?

2 Sep 2011 by Abhinav S

StepsStep 1) You need to host the database in central server / location and allow client programs to access it.Step 2) You will need to make sure all clients have network access to this location.Step 3) To do this, you will need to setup a database connection, say an ODBC setup, on every...

need to show the data in month wise and date wise in asp.net

29 Apr 2015 by Abhinav S

Use datetime[^]. You can then filter by month for e.g. datepart(mm, DateColumnName) = month.

Can anyone help me in Getting definations and Data from Google in C#

11 Jan 2016 by Abhinav S

You can filter and sort as required. Check the documentation - https://developers.google.com/custom-search/docs/structured_search?hl=en[^].

Can Business Logic Layer inherit Data Access Layer in n-tier architecture?

12 Feb 2012 by abi1988

Is that a better way to inherit the Data Access Layer(DAL) in Business Logic Layer(BLL) instead of creating an object of DAL in BLL in any Object oriented language? However the DAL uses only protected methods & properties so that it is not 'visible' to other layers. Is this breaking n-tier...

Retrive PDF Data in vb.net in a predefined columns

9 Dec 2015 by AD89

HiI m currently working on windows application that is loading electoral roll pdf file. What I m trying to do is to get the data as per Sr. No., Epic No., Name, Father's / Husbands Name, Age, Sex, House No. and pincode. Data is available in 3 columns and 10 rows i.e. 30 persons details per...

hex to dec with 1.15 fractional format in C++

22 Oct 2012 by ad_robot

Hi Everyone, I'm trying to interpret some data from an embedded sensor device into a C++ program. The device uses a numerical format called 1.15 fractional format. This means it transmits 2 hex bytes into a value rangle of ~1

Import table data from MySQL to SQL Server

30 Jul 2013 by Adarsh chauhan

Hi,visit the following linkhow to transfer the data from my sql to sql server[^]

Organizational Chart using C# asp.net

5 Oct 2013 by afshinkamal

you should use tree view in asp.net like below : Font-Size="8pt" ImageSet="BulletedList3"...

Installing and setting up R environment on Windows

19 Mar 2016 by Afzaal Ahmad Zeeshan

In this post I am going to walk you through installing and setting up the R environment on your Windows operating system; because Visual Studio is only available on Windows.

How do I call my data in js file to my react component?

10 Feb 2021 by aharris1012

I have a js file with some data with x and y-axis, for a chart. I need to display this data using react Plotly as hooks to my function. How can I accomplish this? What I have tried: Here is my code so far: data.js: export const ScatterData =...

How to insert bulk data from SQL to oracle using C# ?

4 Dec 2019 by Ahmedovic97

I m trying to insert data from table in SQL Database to other tables in oracle database column names are differents. i want to know if there is a methode to perform my code in c# , to insert into tables in oracle database. I am trying to insert 100000 records. my target is that this insert...

Expression Bindings in XAML

20 Jul 2018 by Ajcek84

Complex bindings in XAML made almost as simple as in JavaScript frameworks

Full-Featured Visual Scripting Environment for R & Data Science

6 Jun 2020 by Alaa Ben Fatma

A visual scripting environment for R & data science

machine-learning

hyperlink button click event code which is placed in datalist

8 Feb 2011 by Albin Abel

It is not clear why can't the record id also append in the query string as each record display a hyperlink.It may not be safe to pass the user id in the url string. Refer this article for further information how to securely pass the query string parameters.Preventive Method for URL...

Fast Fourier Transform Caterpillar Method

3 Jul 2017 by Alexander Semjonov

Developing fastest FFT implementation based on precompile tool using data driven approach

SQL Simple Utilities

22 Sep 2016 by Alexandros Pappas

This project provides utilities for SQL server, such as executing a list of SQL scripts, exporting data to an SQL script, and displaying relationships between records.

DataTable Merge Performance

1 Jul 2013 by Alexandros Pappas

This project measures performance of the DataTable.Merge method.

How to pass string in url using javascript ?

30 Dec 2016 by Ali Majed HA

HelloI want to pass a "Persian" string in url, but in another javascript file that I want to get that, I get a hashed string, what should I do ?What I have tried:To send data in url: location.href = "Second.html?ID=" + _MyID + "&Text=" + _MyText;and To Get Datafunction...

Editing date in Grid View with date timepicker

8 May 2012 by aliasad106

i am using DevExpress Grid Control in my desktop application Form. it has column From_Date. I made it editable and i enter the date via DateTimeEdit which is Grid's own. The problem is when i want to use keyboad Arrow Keys to change values of date time Picker in Grid Cell, It loses it focus to...

Convert XML File to Excel File

27 Nov 2017 by Altaf Ansari

Converting XML Data into DataTable and Exporting DataTable into Excel File

Fast by tens malloc() and free() at 25% memory cost

11 Nov 2013 by altomaltes

An insigth in the heap "C" memory system.

How to upload file and how to save it in database?

19 Nov 2012 by Am Gayathri

Hi, Am creating one asp.net application. In my application i need to upload different format files (jpeg,woc,pdf etc).How can i do that?Am using oracle as backend. Is it possible to store these items in their on format in database?please provide me the code..

how to change the password of database in plsql developer tool?

15 May 2018 by Am Gayathri

how to change the password of database in plsql developer tool?

how to change the password of database in plsql developer tool?

13 Dec 2012 by Am Gayathri

alter user test_pwd identified by new_pass replace old_pass;

How can i use plsql developer tool? what are the requirments?

15 Jan 2013 by Am Gayathri

I have installed the plsql developer tool.But while am trying to open it as usual its asking for password,user name,data base name. But i dont know which pass word and user name i should give.Can any one help me how can i use this tool?What are the software i have to install other than...

How can i arrange my grid view ?I need to show some values which i got from Database in my grid without duplicate.

10 Mar 2013 by Am Gayathri

I need to show some values which i got from Database in my grid as below,Name ScoreMaths ScorePhysicsA 1 5B 2 6C 3 7D 4 8So i added new...

How can i arrange my grid view ?I need to show some values which i got from Database in my grid without duplicate.

10 Mar 2013 by Am Gayathri

Use table.rows[][] while adding rows

Why am getting this error? ORA-06550 PLS-00306

13 May 2013 by Am Gayathri

In my code am getting following error.ORA-06550: line 1, column 7:PLS-00306: wrong number or types of arguments in call to 'SAVE_DATA'ORA-06550: line 1, column 7:PL/SQL: Statement ignoredWhat will be the reason for this?code am using is, List listparamters =...

SQL-Server-2005

Why am getting this error? ORA-06550 PLS-00306

13 May 2013 by Am Gayathri

The problem is with objDataAccessUtilities.ExecuteDataReader(command); instead of this we have to useobjDataAccessUtilities.ExecuteNonQuery(command);

SQL-Server-2005

ASP.NET Dynamic Data Web Application Table Help

18 Jun 2011 by ambarishtv

this will help you http://csharpdotnetfreak.blogspot.com/2011/04/gridview-examples-in-aspnet-20-35.html[^]

convert string to int

23 Feb 2013 by amir.nazarizadeh

HI...I have a databas e that has a col for alphabet and a col for numsfor example: a means 0b means 1 and so on...now I want to convert my string from a text box to intfor example: "ab" means: 01 and...can anyone help me that what should I do?!I want this:a=0b=1...z=25

ItemDataBound in Datagrid

31 May 2011 by amit28august

put ur code inside if condition If e.Item.DataItem ThenDim DRV As DataRowView = CType(e.Item.DataItem, DataRowView) Try If DRV.Row.Table.Columns.Contains("MyCustomColumn") Then Response.Write("data in column value") Else ...

Post pata to website using console test application.

13 Dec 2012 by AmitDutta_Bokaro

Hi All,I am trying to post data to a web page control but may be missing some important call.Exact requirement:1) Open an url2) sign in to the application3) Click a link to desired page or directly use the next page url to get the HTML webresponse.Till here everything is...

Tuples in C# 7.0

9 May 2017 by Ammar Shaukat

C# 7.0 has been introduced with many new useful features. One of them is new datatype "ValueTuple". In this article, I'll be writing about Tuples in C# 7 briefly.

Query on Table containing 10,000,000 records and size more than 4GB

21 May 2014 by Amol_B

Hello ,I use sql2008 R2. One my my table contains more than 10,000,000 records with data size around 4.2 GB.This table Contains data about inventories and its properties.A select * for table query takes 27 Minutes Retrieve data.I am using this table with inner joins with another table...

I need help to understand the dataset?

10 May 2021 by Amr Mahmoud 2021

-1 i need to know how can i calculate how much energy in kiloWatt hour (kWh) has Singapore saved per year by recycling, by using this data? waste_type: The type of waste recycled. waste_disposed_of_tonne: The amount of waste that could not be...

data-visualization

Find and GET data from SQL Server Database

8 Jul 2011 by Amul V V Wayangankar

You can retrieve data from database using connected or disconnected architecture.u need to modify ur select query.this link can be useful to...

What is the real life application of binomial heap?

10 May 2020 by An@mik@

Hii I am searching for the practice problems which can be solved by the concept of binomial heap. Can any one tell me the realmlife problem which implements the concept of binomial heap data structures in computer science. I know all basic...

string matching algorithm with linear time

11 Oct 2013 by Andreas Gieriet

Com'on: how about asking google, e.g. "kmp string compare".E.g. see http://en.wikipedia.org/wiki/Knuth%E2%80%93Morris%E2%80%93Pratt_algorithm[^].CheersAndi

Testing Discrete Fourier Transform Program

18 Oct 2015 by Andreas Gieriet

Each meaningful test consists of stimulus, expected result, actual result an a comparator that compares the expected and the actual result.If you compare the actual versus the expected result here, you see that you have a precision issue.The expected result seems to be on three figures only....

windows phone 7 resource file reader

28 Dec 2011 by Andrew Piotrowski

I don't know what kind of app nor is it c# , xaml(Silverlight) or XNA.Maybe this will help http://www.eugenedotnet.com/2011/07/passing-values-between-windows-phone-7-pages-current-context-of-application/

Preventing Duplicates in the Data

16 May 2011 by Andrew Zwicker

How to prevent duplicates in the data

MEAN Stack Development Technologies Supporting a Web Tool for Arcade Game Players Collaboration

10 Dec 2020 by André Marcos (Advisor), LaercioMBR

An overview of the development process of an online platform to facilitate community driven data cataloging and management.

What's the best way to temporarily persist results of a long running SP?

22 Nov 2012 by Ankur^\m/

Some suggestions:You may want to review the indexes on the tables used if the select is too slow. With proper indexes, even millions of records are returned in a few seconds.Secondly, you may want to reduce the amount of data that is returned if that is to be displayed to the user. As you...

stored-procedure

Is this good option to use data caching for 8MB data (1 lakhs records, 5000 record increase every month) in MVC application ?

12 Jan 2019 by AnkushK1

I would not suggest you to go for direct in-memory caching since with growing cache, the performance of application will degrade. However, you can consider using open source tools like Redis that allows you to cache data without causing any performance related issues and better management of...

hwo to sync data between store and main server

18 Sep 2013 by Anoop Brijmohun

Hi all,I am currently developing a solution for a chain store.the backend data storage is SQL Server 2012(main server) & SQL 2012 express(store).which is the best method to transfer data between the servers?taking into consideration the connection can drop in the middle of the bulk...

Is it possible importing data from excel and storing in SQL database where the template of excel sheet and database are different

16 May 2018 by ansonanso

I would like to build a project on the below idea. data engineer is making data on their template. I have a database containing all the columns but not in the same order as the data engineer has.So after uploading the excel file the coloum matching should done and then the date is stored in the...

InputSplit Indexing on Mapreduce

10 Sep 2019 by Antoine Amend

Create custom indexes for improving Mapreduce performance

practises for database creating

28 Nov 2011 by Anuj Banka

For Normaliztion you should create seprate table for this.In future it will help you.Whn you have to use these types in multiple table.But again its depends upon your requirement also !!!

Need help for ETL data warehouse

13 May 2016 by AnvilRanger

This is not a trivial process. If this is homework and you are lost I would suggest you return to your instructor and ask for help from them.And what exactly do you need help with? Do you need help connecting to a DB, help with extraction of meta data for the DB objects, etc?

Projects on Web mining + Artificial Intelligence

18 Jan 2012 by Aomsin

The C# and Java is OpenSource for this issue now in the Heaton Research.Good Luck Guy!

Change DSN from Ms.Access to SQL

11 Mar 2014 by Aravindba

Hi That software use backend as Access,so u cant use sql,if u develop that software and u have full coding ,then u can chnage DNS in ur project code and can use.Or in that software have any option for changing DNS to sql in tools or setting then change,can u tell which software need to...

How to retrieve and store text and image from pdf file using c#

4 Oct 2015 by Aravindh Aravindhan

Anybody help me to retrieve and store text and image from pdf file using c#.I m having one pdf file that contains both image and text in table format.Refer this https://drive.google.com/file/d/0B8h0NyF1SxcEWXZHdlp5TjRJXzA/view?usp=sharingI wanna to import that pdf content to my wpf...

How to grab without extension images from a website?

28 Nov 2012 by Ashish Khatavkar

Hi Friends, I am working in VB.Net. I want to get images from a web page. That page contains a image. when i copy link location / image url of that image it returns page url. that image dont have any extension. like jpg, bmp, gif, png, tif... etc.please help.

Highstock + Data-Forge + Yahoo

16 Feb 2017 by Ashley Davis

A demo of Highstock using Data-Forge with financial data loaded from Yahoo

Acquiring Stock Market Data from Alpha Vantage

7 Jan 2018 by Ashley Davis

How to download stock market data from Alpha Vantage

Data Access

11 Oct 2013 by ASP.NET Community

There's a lot of great information on the net about accessing data in common data access patterns with ASP.NET 2.0. VideosSQL Server Videos -

11 Oct 2013 by ASP.NET Community

At A large part of security in any web application is keeping your secrets secret. Cryptography makes that

Input and Data Validation

11 Oct 2013 by ASP.NET Community

Garbage in, garbage out. You can avoid data cleanup tasks on the backend by avoiding bad data coming in. ASP.NET validation controls and third party

Session

11 Oct 2013 by ASP.NET Community

ASP.NET Session state provides a place to store values that will persist across page requests. Values stored in Session are stored on the server

stored-procedure

ViewState

28 Feb 2014 by ASP.NET Community

ViewState is the mechanism that allows state values to be preserved across page postbacks.Because of the stateless nature of web pages, regular

11 Oct 2013 by ASP.NET Community

Nearly all the controls in ASP.NET have properties that can be databound to.ArticlesJesse Liberty has a fine article on Data Binding in ASP.NET

DataSource Controls

11 Oct 2013 by ASP.NET Community

From ScottGu: Scott Mitchell is also writing some great data articles on using the ASP.NET 2.0 DataSource controls for the excellent

ObjectDataSource

11 Oct 2013 by ASP.NET Community

Start with the ObjectDataSource Control Overview at MSDN then move on to Using Parameters with the ObjectDataSourceControl.ObjectDataSource

11 Oct 2013 by ASP.NET Community

There's quite a few data source controls in ASP.NET and one that folks are increasingly excited about is the LINQDataSource.BlogsLINQ to SQL

11 Oct 2013 by ASP.NET Community

There's a good overview of ths control on MSDN with examples like Binding a Tabular Control to the XmlDataSource Control and Filtering Data Using the

11 Oct 2013 by ASP.NET Community

SqlDataSource control enables you to use a Web control to access data located in a relational data base, including Microsoft SQL Server and Oracle

Data-centric UI Controls

11 Oct 2013 by ASP.NET Community

Both the GridView and ListView are important Data Controls in Visual Studio 2008.Scott Guthrie has a great introduction that uses the ListView

ListView

11 Oct 2013 by ASP.NET Community

Some people think that the ListVew is a better Repeater and is one the best new additions to Visual Studio 2008.Blogs/ArticlesUsing the

11 Oct 2013 by ASP.NET Community

Provider ModelThe provider model pattern was designed to provide a configurable component for data access which is defined from the web.config. The

Bind ListControl's DataValueField/TextField to multiple columns

11 Oct 2013 by ASP.NET Community

Concept A very common question asked on the ASP.NET Forums is how to bind a ListControl's DataTextField or DataValueField to multiple Columns. The

11 Oct 2013 by ASP.NET Community

The RangeValidator control tests whether an input value falls within a given range. RangeValidator uses three key properties to perform its

stored-procedure

accessdatasource

11 Oct 2013 by ASP.NET Community

The AccessDataSource class is a data source control that works with Microsoft Access databases. Like its base class, SqlDataSource, the

connectionstring

11 Oct 2013 by ASP.NET Community

The CheckBoxList control creates a multiselection checkbox group that can be dynamically generated using databinding. To specify items that you want

CreateUserWizard

11 Oct 2013 by ASP.NET Community

Overview The CreateUserWizard control provides the user interface for the MembershipProvider object that communicates with the user account data

ListBox

11 Oct 2013 by ASP.NET Community

The ListBox control is used to create a list control that allows single or multiple item selection. Use the Rows property to specify the height of

SiteMapDataSource

11 Oct 2013 by ASP.NET Community

The SiteMapDataSource control is a data source to the site map data that is stored by the site map providers that are configured for your site. The

ListView and DataPager in ASP.NET 3.5

11 Oct 2013 by ASP.NET Community

The ListView is a sort of hybrid between a DataGrid and Repeater thatcombines the free form templating of the Repeater with the editingfeatures

Export To CSV file

11 Oct 2013 by ASP.NET Community

First let’s see what the CSV file is:CSV file is a text based file in which data are separated by comma. It can be opened by excel so you can use

11 Oct 2013 by ASP.NET Community

Lazy Loading is an object relational pattern which is used to defer the inialization of an object until its needed. The object will not contain all

LINQ to DataSets

11 Oct 2013 by ASP.NET Community

IntroductionLINQ is one of the new entrants in C# 3.0, introduced as part of .NET 3.5. As you are already aware, LINQ is a unified querying

New "var" keyword

11 Oct 2013 by ASP.NET Community

The var keyword is a new keyword in Dot net Framework 3.5 that can infer its data type from the resulting set. Var keyword For instance, look at the