2,634 Topics

Member Avatar for
Member Avatar for Yacine Si Tayeb

# Introduction # As we move into 2022, businesses will continue to look for ways to become more data-driven. This means that knowing how to use Structured Query Language, commonly called SQL or 'Sequel', will remain an essential skill for data scientists, analysts, and developers. In this post, we'll provide …

1
119
Member Avatar for dimitrilc

## Introduction ## In this tutorial, we will learn how to load data asynchronously into a **ListAdapter** (*a subclass of **RecyclerView.Adapter***). ## Goals ## At the end of the tutorial, you would have learned: 1. How to serve asynchronous data to a **ListAdapter**. ## Tools Required ## 1. Android Studio. …

1
337
Member Avatar for dimitrilc

## Introduction ## In this tutorial, we will learn how to use **ConcatAdapter**. It is a great choice for displaying header or footer at the beginning or at the end of a **RecyclerView**. ## Goals ## At the end of the tutorial, you would have learned: 1. How to use …

2
397
Member Avatar for dimitrilc

## Introduction ## Finding a View in Espresso tests can be quite confusing because there are so many matchers available. In this tutorial, we will learn how to find a View based on its sibling contents. ## Goals ## At the end of the tutorial, you would have learned: 1. …

1
345
Member Avatar for dimitrilc

## Introduction ## In this tutorial, we will learn how to add swipe-to-remove and drag-to-reorder functionalities into RecyclerView. ## Goals ## At the end of the tutorial, you would have learned: 1. How to add swipe-to-remove and drag-to-reorder functionality to a RecyclerView. ## Tools Required ## 1. Android Studio. The …

2
228
Member Avatar for chandkrishneel

Im trying to display/show the Total Average in the heading (beside it) and not in the dataset table. I tried different methods but it wont show. (The last method I tried to work with is what in including in the codes. <!DOCTYPE html> <html xmlns='http://www.w3.org/1999/xhtml' xml:lang='en' lang='en'> <head> <meta charset='UTF-8' …

0
62
Member Avatar for 1427_Sharupya

help me asp..... In this assignment you have to write functions (in python) that applies various preprocessing techniques which are popular in Natural Language Processing (NLP). For this purpose, you are supplied with a Text Dataset (“corona_data\test_small.tsv”) and you have to process that dataset using the following techniques: 1. Tokenization …

Member Avatar for Reverend Jim
0
120
Member Avatar for caboh59237
Member Avatar for rproffitt
0
34
Member Avatar for sanjay2012

Error 1 'AdvoDiary.DataSet' is a 'namespace' but is used like a 'type' D:\AdvoDiary\AdvoDiary\ReportViewer\rptBilling.cs 25 9 AdvoDiary namespace AdvoDiary.ReportViewer public partial class rptBilling : Form Common sCom; DBHelper myDB; string sOLE; clsGlobalVar objGlob; OleDbConnection cn; OleDbDataAdapter sDA; DataSet sDS; OleDbCommand cmd;

Member Avatar for tinstaafl
0
374
Member Avatar for nantha_2

Please help me.. When i code in my PC for this programming it is running without any error, but when i release it to server i Encountered error Compiler Error Message: CS1061: 'ASP. registration_aspx' does not contain a definition for 'btnDeactivate_Onclick' and no extension method 'btnDeactivate_Onclick' accepting a first argument …

Member Avatar for nantha_2
0
175
Member Avatar for jeffmylife

# What Are Voronoi Diagrams? # Voronoi Diagrams are an essential visualization to have in your toolbox. The diagram’s structure is a data-driven [tessellation](https://en.wikipedia.org/wiki/Tessellation) of a plane and may be colored by random or to add additional information. ## Learn the Lingo ## The set of points that generate the …

Member Avatar for Smartfitness33
5
24K
Member Avatar for sandySuper

When I access an api. it returns data in below format **n2035014,25 N2035014,25 B2035014,2944.40,250,3787.30,2400** o24,22971.20 h24,23064.15 l24,22641.40 c24,22945.05 i24,22744.40 I am clueless how to map these data and store in mysql table. First set of data highlited in bold is dataset 1, followed by second set of data which has …

Member Avatar for JeanMilburn
0
68
Member Avatar for wesley_overton

Hi all, I've been having a problem adding a record to an Access database using datasets and da.update etc. I'm trying to create a simple program that displays the records of a database table in a series of text boxes. I've managed to get my next and previous buttons working …

Member Avatar for EricAJB
0
2K
Member Avatar for SoftBa

Hi, I have one Win Form app to load Excel data into DataGridView. I want to store DataGridView data into MS Access database. Everithing works great, but in some cases inside ExcelFile I have single quote mark, which breaks SQL Syntax. My question is, How to find & replace "'" …

Member Avatar for AndreRet
0
91
Member Avatar for Aijaz_2

this is code snippet of sentiment analysis using sentiwordnet in (python using Pandas). i am trying to extract sentiment score of each review using sentiwordnet. here are few steps i did upto now, 1.stopwords removal. 2.tokenisation. 3.pos tagging. can anyone help me to correct this code. results of this code …

Member Avatar for nad_1
0
8K
Member Avatar for chris_58

can someone help me take a look i face (oledbexception was unhandled (too many fields defined)) below is my code . Private Sub btnBrowse_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnBrowse.Click Properties='Excel 12.0;HDR=NO;'" Dim Chosen_File As String = "" If openFileDialog1.ShowDialog() = DialogResult.OK Then Chosen_File = openFileDialog1.FileName End …

Member Avatar for pritaeas
0
319
Member Avatar for cthornval

In my html page, I have an external javascript code, that causes a modal to pop up when a project in my html class is clicked. the projects are specified through the li class attribute. I now wish to chance this, so the modal instead pops up when a span …

0
175
Member Avatar for bhavya_7

I have daily scatsat level4 data for wind for year 2017 in a single folder I need to calculate the windspeed of the data and average of windspeed for 8 days for the whole year and need to plot it in a image using quiver plot **I am able to …

0
399
Member Avatar for JerryShaw

Well I guess it is my turn to ask a question, since most of the time I spend answering questions on DaniWeb. The Problem: DataViewGrid throws a "System.ArgumentException parameter is not valid..." when the dataset contains an SQL 2005 TimeStamp type column. The error occurs in System.Drawing.FromStream... da da da …

Member Avatar for work.caglar
0
1K
Member Avatar for (MeoW)

hello, im going to create POS project, can you help me how to retrieve all image from mysql db to listview, so that i can view all image that i save to my db, i already save image and use sreach button on retrieve image from db to picturebox. thank …

Member Avatar for (MeoW)
0
1K
Member Avatar for Satyam_1

Hi, I hv vb.net applivcation. I have following CODE1 to save data & to prevent duplicate data entry into table. The following code I put in button save event. However I want to put this CODE2 in perticluar textbox e.g. here SpecimenNoTextBox. so that when the user enter duplicate SpecimenNo.it …

Member Avatar for kamal_22
0
5K
Member Avatar for faizan_7

Hey everyone. I received this sql server error and I can't figure out where the trouble is: Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: …

Member Avatar for Yrth
0
2K
Member Avatar for bckelley

For this particular sub I type the customer id in a text box and then click the button, then I'm trying to get the relative information pertaining to that id. Not sure what I am doing wrong. Comes back with an error message of system.data.sqlclient.sqlexception Recursive common table expression '[customers]' …

Member Avatar for bckelley
0
4K
Member Avatar for prochotap

In mysql database i created "leave" table: CREATE TABLE `leave` ( `ID_LEAVE` int(11) NOT NULL, `ID_WORKER` int(11) NOT NULL, `BEGIN_DATE` datetime DEFAULT NULL, `END_DATE` datetime DEFAULT NULL ); INSERT INTO `leave` (`ID_LEAVE`, `ID_WORKER`, `BEGIN_DATE`, `END_DATE`) VALUES (1, 26, '2019-03-19 07:00:00', '2019-03-19 15:00:00'), (6, 26, '2019-03-22 07:00:00', '2019-03-25 15:00:00'); "Sickness" table: …

Member Avatar for Qzmo
0
416
Member Avatar for prochotap

In desktop application used in technologies like C#, .Net and MySQL I import data from large file (which is about 37 MB) to datagridview. The table from Excel file is in below: ![B8UMq.png](/attachments/large/4/9bbe3c17922dd6159fbe781fae200a4e.png) After loading data from Excel to datagridview I'm inserting that data to MySQL database. Later when I …

Member Avatar for rproffitt
0
639
Member Avatar for sanjay.vaniya

DataSet ds = new DataSet(); string pattern = @"(</?)(\w+:)"; //[XMLText] is a string variable containing XML downloaded from a WebServices API. StringReader sr = new StringReader(Regex.Replace(XMLText, pattern, "$1")); ds.ReadXml(sr); return ds;

-1
300
Member Avatar for jeffmylife

## Intro ## Receiver Operating Characteristic (ROC) plots are useful for visualizing a predictive model’s effectiveness. This tutorial explains how to code ROC plots in Python from scratch. ## Data Preparation & Motivation ## We’re going to use the breast cancer dataset from sklearn’s sample datasets. It is an accessible, …

3
10K
Member Avatar for Duo

Hi Im having an error with my app, Im still learning to code. It gives me error at line rs = cmdOLEDB.ExecuteReader Here's my full code Imports System.Data Imports System.Data.OleDb Imports System.IO Public Class Form11 Dim cnnOLEDB As New OleDbConnection Dim cmdOLEDB As New OleDbCommand Dim cmdInsert As New OleDbCommand …

Member Avatar for Santanu.Das
0
503
Member Avatar for Papa_Don

Hi group, I'm attempting to populate a listview with data from my test database created via Visual Studio 2019. I'm getting a syntax error that says, "Incorrect syntax near the keyword 'FROM'." It's not clear to me what the error is. The code I've written is as follows: Dim strQ …

Member Avatar for RuhiAngel
0
3K
Member Avatar for Papa_Don

Group, I've written some code to populate a listview using 3 fields from a database. When creating the listview, I named the individual columns for appearance purposes, (Account No, Company Name and Name). Those columns are being populated appropriately as expected. However data column names are being shown in column …

Member Avatar for xrjf
0
3K
Member Avatar for savedlema

Hi everyone! I'm making an application which requires users with different permissions/previleges to login and use the application.For example, if the user is "admin", all menu items in the menu bar are shown and enabled. If the user is say "user_group1", some of the menu items are to be hidden. …

Member Avatar for Reverend Jim
0
6K
Member Avatar for omi4u

Hi All Brothers I am working on ERP system and i need one help I wrote code for Datagrid auto complete. this code is working perfect but it only showing one Column record from database what i need is i want first column is to autocomplete as i did and …

Member Avatar for rproffitt
0
593
Member Avatar for catastrophe2

I have a table that contains some cubes with servers and active status (see attached image): note: CUBE1 is repeated intentionally. The idea is the same cube is getting synced from the same server 1 as a data source (process_server) onto different target servers (query_server; say server2 is in region …

Member Avatar for pinel
0
1K
Member Avatar for JosephMooryes

Guys this question is continual. however i found the answer virtually however still cant compass. i dont shrewdness to resolve it. thats why i announce it as new question iam operating with a project. iam exploitation native-validations-master downloaded it from internet. this is the link for that: https://www.cssscript.com/custom-html5-form-validator-native-validations/ It conjointly …

0
271
Member Avatar for ngonix

Hello good people, I am having an issue with including subreports, lists and table datasets in the main report using jasper reports since i want to include two separate sql queries in my report. I am using the same connection to my database for both the main report and the …

Member Avatar for Partner_1
3
1K
Member Avatar for 404notfound

In my access database, I have a table for the master list of items discussed in a training meeting. If a certain item was discussed in a meeting, then the value in the database is 1, if it was not discussed, then the item is 0. I'm trying to get …

Member Avatar for tinstaafl
0
466
Member Avatar for Hashik

I have a Database named "Store" and tables are orders and firm. The firm table fields are firmname, firmcode. The fields orderno, orderdate orderqty, qtyrcvd and balqty are stroed in another table. When selecting three ComboBox values (fetched from another(invoice) table) ie firm name, orderno and orderdate respectively when clicking …

Member Avatar for aldeene
0
402
Member Avatar for JModak

Sir. I create a project in vb.net 2010 sql server 2008r2 and crystal report 13. i use this code for showing the report. Public Sub PrintSaleRInvoice() Dim PrintSale As New DataSet objsale.saleinvid = txtSaleInvid.Text PrintSale = objsale.PrintSaleInvoice() ' Procedure name PrintSale.Tables(0).TableName = "DataTable1" Dim rpt As New SaleInv rpt.PrintOptions.PaperOrientation = …

Member Avatar for rproffitt
0
586
Member Avatar for JModak

Vshost.exe has stopped working... Posted A minute ago vshost.exe has stopped working this error showing after using the Crystal Report. The error show when I closed the application. If I not use the crystal report then the error not showing. I am creating a program in vb with visual studio …

Member Avatar for rproffitt
0
674
Member Avatar for ela_1

Requirements: Create a PHP application to allow a user to register for the website and enter profile information to be stored in cookies. Part I: Registration page Create a page called register.php that displays a user registration form with the following fields from the customer table: Email address - required, …

Member Avatar for JamesCherrill
-1
333
Member Avatar for ela_1

Requirements: Create a PHP application to allow a user to register for the website and enter profile information to be stored in cookies. Part I: Registration page Create a page called register.php that displays a user registration form with the following fields from the customer table: Email address - required, …

-1
154
Member Avatar for davy_yg

Hello, I am following this tutorial: https://valor-software.com/ng2-charts/ I try to set up the barchart. I copy exactly from the demo script: new.html <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.6.9/angular.min.js"></script> <script src="node_modules/chart.js/src/chart.js"></script> <script src="bar.js"></script> </head> <body> <div> <div style="display: block"> <canvas baseChart [datasets]="barChartData" [labels]="barChartLabels" [options]="barChartOptions" [legend]="barChartLegend" [chartType]="barChartType" (chartHover)="chartHovered($event)" (chartClick)="chartClicked($event)"></canvas> </div> <button (click)="randomize()">Update</button> </div> </body> …

0
282
Member Avatar for SimonIoa

Hello i want to pass the user id (uid) from the home page to a user Details Page. Because i display multiple users on my home page i don’t wan to pass the user session id (as given by the `JSON.parse(localStorage.getItem("userData"));` ), i want to click on the name of …

0
588
Member Avatar for SimonIoa

Hello i have a problem with my Ionic App. I am using typescript files. I am getting console log `No Access` that means there is a problem with `resposeData`. Any hint? I am really stuck home.ts file import { Component, ViewChild } from "@angular/core"; import { NavController, App, AlertController } …

0
415
Member Avatar for Ahmed_99

i want to update row after union conection code conect Dim cmd As OleDbCommand = New OleDbCommand("SELECT tb1_type ,tb1_price FROM tb1 UNION SELECT tb2_supp,tb2_debt FROM tb2 UNION SELECT tb3_name,tb3_price FROM tb3", con) con.Open() DataAdapter1 = New OleDbDataAdapter(cmd) Dim builder As OleDbCommandBuilder = New OleDbCommandBuilder(DataAdapter1) DataSet1 = New DataSet() DataAdapter1.Fill(DataSet1, "tb1,tb2,tb3") …

Member Avatar for adam_k
0
298
Member Avatar for SimonIoa

Hello i have a problem working with Camera on Ionic and i need some advice. I have installed both ionic camera and media capture plugins. I am using two scripts one to capture Video (Start Reocording) and one to capture a Photo (Take Photo) I am getting the errors displayed …

Member Avatar for SimonIoa
0
2K
Member Avatar for Catherine_5

At the beginning welcome all. I have a big problem and I can not deal with it. I would like to refresh dategridview after adding and editing data. I try to add ShowData() function on closing Form2 and that didn't work. Thanks for any help or advises :) and link …

Member Avatar for xrjf
0
381
Member Avatar for Ahmed_99

1- I want to edit the search code where I search all the fields with no repetition of the data 2- And modify the deletion code where it deletes and saves the data all code Imports System.Data.OleDb Public Class Form1 Public con As New OleDb.OleDbConnection("provider=microsoft.ace.oledb.12.0;data source=" & Application.StartupPath & "\web_database.accdb;Jet …

Member Avatar for rproffitt
0
324
Member Avatar for SHEKINA

python code implementation of firefly algorithm for feature selecting the hepatitis dataset

Member Avatar for happygeek
0
191
Member Avatar for JModak

Procedure or function P_UpdatePurchaseInv_test has too many arguments specified. ALTER PROC [dbo].[P_DeleteForUpdatePurInvDet] --Purchase Invoice Details 12 pic(13pic active) --@purid int , --@purinvid varchar(255), @purinvdt date, @invno varchar(255), @invdt date, @nrr varchar(200), @partyIDpur int, @invtypidpur int, @tottaxblamt decimal(18, 2), @nettaxamt decimal(18, 2), @invamt decimal(18, 2), @totalcgst decimal(18, 2), @totalsgst decimal(18, 2), …

Member Avatar for hericles
0
370

The End.