CRUD

editing

How to retreive id from table that auto creates id

8 Dec 2018 by Wendelius

Taken that the id is created using an identity definition[^] there are three system functions that return lastly inserted identity value: - @@IDENTITY (Transact-SQL) | Microsoft Docs[^] - IDENT_CURRENT (Transact-SQL) | Microsoft Docs[^] - SCOPE_IDENTITY (Transact-SQL) | Microsoft Docs[^] ...

Why cant we override methods from jparepository interface?

6 Aug 2019 by MadMyche

why cant we override methods of jparepository interface such as findById(),and many more. why we need to create new interface for performing crud operations. This really is not a question relative to fixing you with a code issue; as you already know the issue. The answer to why this repository...

Spring

SQLSTATE[HY093]: invalid parameter number: number of bound variables does not match number of tokens

17 Sep 2020 by Sandeep Mewara

Seems there is a mismatch of the variables that you have added in your query (54) compared to the count you have binded (52). A simple debugging should be able to tell you that. Given it's way too many variables, would leave this on you to...

PDO

Sending data using CRUL in PHP

2 Nov 2020 by Richard Deeming

Your array creation syntax looks nothing like the documentation: PHP: Arrays - Manual[^] The closest seems to be the new syntax from 5.4.0: PHP: New features - Manual[^] That would still need to be: $post = [ "no_pengajuan_full_day" =>...

Sending data using CRUL in PHP

2 Nov 2020 by Richard MacCutchan

Your syntax is incorrect for the declaration of $post. The correct way to specify arrays is detailed at PHP: Arrays - Manual[^]. Also take careful note of Richard Deeming's comment.

Oracle ADF Faces Cookbook

11 May 2014 by apis3445

This is another book about ADF

Oracle

How Do I Post My Model To An Odata Web Api Using Knockout.Js

15 Jun 2014 by wujapan

Hi i'm trying to post model to a web api where every time only one item in the model shown up at post method. like if i'm posting a model called Movie ,Id and Title are the properties of this model.so here my problem is when i'm trying to post it from client side using knockout.js,only Title...

Knockout.js

OData

CRUD operations on multiple tables in a single class

2 Jul 2014 by Pravuprasad

for this you should try "entity framework"...

SQL

After login page displaying users data

9 Sep 2015 by TheBigBearNow

Hello I created a small application and some forms for someone to be able to create a user account and then go to a login screen and the user can login with the account that they just created.Now my next step is I would like to bring up a new form which I created and I want to be able to use...

how to CRUD operations in single view in mvc4?

18 Dec 2015 by nilesh@07

insted of direct call from controller to db.you create one "insertmanager" and "insertinterface" with "generic repository".and call manager from controller.

Building ORM Objects and Store Procedures from an ERD Using Java and Eclipse

29 Mar 2016 by Giancarlo Rhodes

ORM objects and basic CRUD operation procedures are first phase tasks that come after establishing a first version of the database. This java-based code generation tool builds those classes and stored procedures.

How can I design and manage CRUD operations in a library management system without using database?

1 May 2016 by Naveen K M

We are required to design simple CRUD operations for library using Entity framework without using the database. Please let us know on how we can design this requirement (without using DB).What I have tried:I have no idea how to implement CRUD operations without using the database.Please...

How can I design and manage CRUD operations in a library management system without using database?

1 May 2016 by Kornfeld Eliyahu Peter

To work with data all you need is a data provider for the Entity Framework...It is not an easy task and you will have to learn a lot...You may stat here:Writing an Entity Framework Data Provider[^]EntityClient Provider for the Entity Framework[^]Fortunately there is a shortcut for all...

Getting Started with Cloudant

9 Jun 2016 by Mihail Mateev

Cloudant is a NoSQL database as a service (DBaaS) built from the ground up to scale globally, running non-stop, and handling a wide variety of data types.

IBM Cloudant HTTP API in a Nutshell

12 Jul 2016 by Mihail Mateev

This article explains the main parts of Cloudant HTTP API. This is an essential part that developers and architects need to know before to start work on solutions using IBM Cloudant.

Mybatis postgresql crud

17 May 2017 by Member 13208078

Hello everybody. I have a PostgreSQL database. The application is based on the Spring Framework. MyBatis is connected to the PostgreSQL. (MyBatis version 3. queries in xml format). Please tell me how to implement crud - standard operations (create read update delete)? Thanks! What I have tried:...

Spring

Asp.net MVC edit method not working

24 Aug 2017 by ddgjgj

This is the view : @model CMSFC.Models.ContentHtml @{ ViewBag.Title = "Edit"; } Edit @using (Html.BeginForm("Edit", "ContentHtml", null, FormMethod.Post, new { enctype = "multipart/form-data" })) { ...

Xcrud ajax autofill based on selected value

13 Aug 2020 by Member 13773036

Hi, I am trying to get an ajax function working but I don't know where to start. I am using xcrud framework. I believe there's an easy method to do this. I want few fields filled when a dropdown list is selected. pretty simple but I am still struggling. How do I send the field value to the...

CodeIgniter

How can I create folder and subfolder in sharepoint using rest

24 Apr 2018 by Dhaval_Nayi

Hi, Try updating rest call syntax. var serverRelativeUrlToFolder = "Document Library/"+"FolderName";//For Main folder FolderName would be blank var FolderName ="FolderName";//New Folder Name that to be created $.ajax({ url: _spPageContextInfo.webAbsoluteUrl +...

C# WPF login SQL bool method get the user

5 Nov 2018 by TheBigBearNow

Hello all, I have a login method to check if a user is a member in my DB. My login method is only a bool and I am wondering how can I grab that current users data so I can pass it to the next window. I am checking textboxes to see if the text is valid. One way I know I could solve this is to...

C# WPF login SQL bool method get the user

5 Nov 2018 by #realJSOP

Create a static class that contains the desired user data. When the user logs in, capture the desired user data into your static class, and you can still return a bool from your login method.

Confused about a cast error was working before..

7 Nov 2018 by TheBigBearNow

Hello all, I’m not sure why I’m getting a cast error. I can login as an Admin with no problem. I am using inheritance with customer class inheriting properties from user. A admin is just a normal user. Customer only has a few extra properties but before a lil earlier I was able to run my program...

Confused about a cast error was working before..

7 Nov 2018 by OriginalGriff

WE can't see the definitions of loginUser and user which are the only explicit casts in that code; we also can't see what type SQLuserAccess.UserLogin returns, or what is in user before you cast that. So run your code in the debugger, and look at exactly what the variables contain. At a guess,...

C# WPF object reference not set to an instance of an object

9 Nov 2018 by TheBigBearNow

current error: Object reference not set to an instance of an object I was getting invalid cast exception error but i changed (int) to Convert.toInt32 and that went away. I go to debug it and the on my button click and the code runs all the way through not stopping at any of my breakpoints. The...

C# WPF object reference not set to an instance of an object

9 Nov 2018 by OriginalGriff

The debugger is pretty much the only way you will find this: if you aren't hitting the breakpoints, then either they aren't in the right place, or you are not debugging the code you are executing. So: try it again. Go to the "Debug" menu and select the "Exceptions..." menu item. In the...

Object reference not set to an instance of an object

11 Nov 2018 by TheBigBearNow

Hello, I am getting the error object reference is not set to a instance I am creating a new customer in the combobox select method but in the button click I go to update the customer but I get an error where I am updating the customer object. The error is here in this btn click: this exact...

Object reference not set to an instance of an object

11 Nov 2018 by Aydin Homay

Hi I am more suspicious to the below line: ComboboxState.SelectedValue.ToString() Could you please do a favor and re-write your code in this way: var userId = currentUser.UserID; var firstName = TextboxFirstName.Text; var lastName = TextboxLastName.Text; var address = TextboxAddress.Text;...

Issue loading entity framework SQL C# WPF project

14 Nov 2018 by TheBigBearNow

Hello all I have a question, I am using entity framework with a C# WPF project. I am just doing CRUD with EF for a simple project but I am having issues just starting the project up. At first I was having an error saying “The underlying provider failed on open()”. I ended up getting past that...

C# WPF project entity framework will not add record in DB

16 Nov 2018 by TheBigBearNow

Hello all I have a C# WPF project and I added Entity Framework to it with a ADO.net data model. I have a .mdf database with a table in it and data. When I call the data.ToList() method I get the correct data from my db into my datagrid. So that is correct. The issue I am having is when I go to...

C# WPF project entity framework will not add record in DB

16 Nov 2018 by Richard Deeming

Your MainWindow constructor binds the grid to the current records in the database. Your BtnSave_Click method creates a new MainWindow instance before adding the new record to the database. Therefore, your main window can't show the new record, because it doesn't exist at the point the data was...

How to retreive id from table that auto creates id

8 Dec 2018 by TheBigBearNow

Hey all, I have my code to I can create a new receipt NEXT I am supposed to add my list of products to another table linked by my receiptId But my database automatically creates the receiptId and the only way to read the receipt from the database is if I have the receiptId So how would I get the...

Multithreadin backgroundworker async & await login to SQL C# WPF

11 Dec 2018 by TABiSH777

Hi, you are on right track, you could use Backgroundworker for this purpose with ease, just remember some thing while working with multithread is that, we cannot access UI elements directly from another thread. And as entire code that's executed in Backgroundworker is in another thread we cannot...

Php header does not load a new page just keeps refreshing but SQL executes

28 Jan 2019 by TheBigBearNow

Hello all, I have a working mysql database with my PHP code. I can create a new row and delete a row BUT when I click the btn delete the page just continually keeps loading and never goes to my header(). For my create btn the page does the same thing just keeps Is PDO one of the best phps to...

Php laravel object not creating in 5.8

3 Mar 2019 by TheBigBearNow

Hello everyone, I have a PHP Laravel CRUD application I made where I am using MVC style. I have controllers views and models. My database migration is made and my table in the database is made with php artisan migrate. I am using php 7.3 and laravel 5.8. On my create view I go to create a single...

bootstrap

I am getting this error.. System.data.sqlclient.sqlexception

9 Sep 2019 by Member 14566485

System.Data.SqlClient.SqlExcep...

MVC

I am getting this error.. System.data.sqlclient.sqlexception

9 Sep 2019 by OriginalGriff

Read the error message, it's very exact. The parameterized query '(@UserName nvarchar(4000),@Email nvarchar(4000))UPDATE AspNetUse' expects the parameter '@UserName', which was not supplied. So that means that this line: cmd.Parameters.AddWithValue("@UserName", getUserdata.UserName); is passing...

MVC

SQLSTATE[HY093]: invalid parameter number: number of bound variables does not match number of tokens

17 Sep 2020 by danalej veinte

Soy nuevo en php, estoy tratando de agregar datos através de un formulario en Modal en php cuando le guardo me aparece este error Google translate: I am new to php, I am trying to add data through a form in Modal in php when I save it I get this...

PDO

Php CRUD via CLI project

6 Jan 2021 by Demetri K.2

I've got a test task that requires to write a basic app with CRUD functionality (a list of visitors), but all the user input and app output has to go through the command-line interface. Everything has to be done in raw php. If anyone could...

CLI

Php CRUD via CLI project

6 Jan 2021 by Richard MacCutchan

You can learn about readline at PHP: readline - Manual[^]. Search from there for the print command to send your output to the console.

CLI

How do I make CRUD operations without unique key column?

29 Apr 2021 by GlennAshan

I'm developing a Node Backend(CRUD Application) which is connected with Microsoft SQL Server Database. But the table that I have to use does not have any unique key column. I'm not allowed to add a unique key column to the table as well. In this...

What do I learn after CRUD operations in nodejs

5 Dec 2021 by Chinedum Ike

Okay so I just finished a 10 hour nodejs and mongodb course but whenever I look at all the cool apps you can build with node I still feel like I dont know anything since all I learnt was CRUD operations. So my question is does anyone have like a...

What do I learn after CRUD operations in nodejs

5 Dec 2021 by Gerry Schmitz

How to build a real time chat application in Node.js using Express, Mongoose and Socket.io[^] How to Code a Video Streaming Server using NodeJS - DEV Community[^] ...

How to improve back end skils?

26 Dec 2021 by Member 15435322

Hi all.I started working as a junior java developer at my workplace. But I am facing some problems. The moment I worked was actually understanding what a back end developer was doing. But I couldn't understand. I finally realized something, that...

How to replace JPA repository in my project ? I want to write custom queries

13 Apr 2022 by osemdeveloper

I have started to learn spring-boot framework with JPA and CRUD repositories . Also, I have completed a project using JPA where it is so easy to do crud operations . But, This is making me to miss how to write custom queries and understand the...

How to replace JPA repository in my project ? I want to write custom queries

13 Apr 2022 by Richard MacCutchan

Take a look at Lesson: JDBC Introduction (The Java™ Tutorials > JDBC Database Access)[^].

CS0106 the modifier 'public' is not valid for this item gridviewdemo

4 Jun 2022 by Member 15662427

public static void main (Args _args) { TmpFrmVirtual tmpFrmVirtualVend; PurchFormLetter_Invoice purchFormLetter; VendPackingSlipJour vendPackingSlipJour; SysQueryRun ...

React simple crud how to learn

25 Aug 2022 by OriginalGriff

This is the fourth time you have posted random code without asking any actual question, or at least not in a form anyone but you can understand or answer. As with your other questions, there is nowhere near enough information here for us to...

React

First AngularJs Application using ASP.NET MVC, $http & $window Services, EF and CRUD Implementation

Fixing PDF Export Issues when Using a Scriptcase Grid Application

7 May 2023 by ToughDev

How to fix PDF Export Issues while using a Scriptcase Grid app

Fixing ‘Search fields undefined’ Error When Generating Source Code for a Scriptcase Gridview

7 May 2023 by ToughDev

How to fix ‘Search fields undefined’ error when generating source code for a Scriptcase gridview

DbSharpApplication (DAL Generator Tool on .NET6, and released new version on .NET8)

17 Feb 2024 by Higty

A DAL generator that generates StoredProcedure client class and creates Table and Record classes

Master Chef (Part 4) - ASP.NET Core and Angular 2 CRUD SPA

10 May 2017 by Fred Song (Melbourne)

Inthis article, I talk about how to use ASP.NET Core MVC, Entity Framework Coreand Angular 2 to implement a CRUD SPA (Single Page Application).

ASP.NET Core,Angular2 CRUD with Animation using Template Pack, WEB API and EF 1.0.1

8 Mar 2017 by syed shanu

In this article, let’s see how to create a ASP.NET Core CRUD web application with Angular2 Animation using Template Pack, WEB API and EF 1.0.1

Kerosene Dynamic Data Services

11 Mar 2014 by mbarbac

Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM

RESTful Day #4: Custom URL Re-Writing/Routes using Attribute Routing in MVC 4 Web APIs

1 Mar 2016 by Akhil Mittal

In this article I’ll explain how to write your own custom routes using Attribute Routing.

Introduction to Knockout.js and CRUD Operations in ASP.Net Web Forms Using Knockout.JS

26 Nov 2014 by Akhil Mittal

This article is an introduction to Knockout.js and CRUD Operations in ASP.NET Web Forms using Knockout.JS.

Creating Self Hosted ASP.NET WebAPI with CRUD operations in Visual Studio 2010

14 Apr 2016 by Akhil Mittal

In this article I’ll explain how we can host aWebAPI in another process independent of IIS.

CRUD Operations using LINQ Entities

11 Jul 2009 by Shivprasad koirala

CRUD operations using LINQ Entities

Complete CRUD Operations in MVC 4 using Entity Framework 5 Without Writing a Single Line of Code

26 Nov 2014 by Akhil Mittal

Complete CRUD Operations in MVC 4 using Entity Framework 5 without writing a single line of code.

DataGridView CRUD With Saving Image to SQL Server using C#

16 Dec 2015 by syed shanu

In this article, you will learn how to perform DataGridView CRUD with saving image to SQL Server using C#.

CRUD in ASP.NET MVC 5 using WebAPI 2 with AngularJS

22 Feb 2016 by Indresh_Prajapati

This tip will help beginners to implement CRUD operations in ASP.NET MVC 5 using WebAPI 2 with scripting language as AngularJS and Database as MS SQL 2008R2.

CRUD with oData V4 and ASP.NET Web API

10 Feb 2016 by Siddharth R Barman

Quick introduction to oData (v4) by understanding how to implement CRUD method using ASP.NET Web API

CRUD operation with Entity Framework 6 Database First using MVC 5

26 Jan 2015 by TalentTuner

In this article, I’ll describe how to perform basic CRUD operations in an MVC5 application.

CRUD operation with Entity Framework 6 Code First approach in MVC 5

27 Jan 2015 by TalentTuner

In this article, I’ll describe how to perform basic CRUD operations using code first in an MVC5 application.

Create OData endpoint for MongoDB on MEAN stack

28 Nov 2016 by Neal Pandey

This article is a tutorial on creating a basic OData (Open Data Protocol) endpoint for a MongoDB database using MEAN stack.

MEAN Stack Beginner Tutorial

9 Nov 2015 by nomi ali

In this article we learn MEAN Stack a combination of open source JavaScript framework. How they work and How can create a single page application using these technologies. We use these JavaScript technologies not only on front end but also on the back end.

5 May 2015 by Sreekanth Mothukuru

In this article, we are going to implement CRUD operations using popular AngularJs library, ASP.NET MVC, $http & $window services and Entity Framework using Linq

CRUD in ASP.NET MVC 4 with KnockOut.JS

20 Jan 2016 by Indresh_Prajapati

This tip will help beginners to implement CRUD operations in ASP.NET MVC 4 with scripting language as KnockOut and Database as MS SQL 2008R2.

Importance of Logging in MySQL

16 Dec 2017 by Biswal Tanmaya

This blog post discusses the importance of logging in MySQL

How can I create folder and subfolder in sharepoint using rest

9 Sep 2019 by SherryT6$

What i want to achieve is to create a folder(main folder) then create subfolders within the main folder. I have tried the code below but doesnt seem to work. It doesnt create the main folder at all. Please help. Any suggestion will be highly appreciated. Thanks What I have tried: function...

Mvc simple demo for member detail add delete edit update with controller and view simple demo required

16 Feb 2019 by Member 11882351

List Member Using Ajax $(document).ready(function () { bindMemberList(); }); function bindMemberList() { $.ajax({ type: "Get", ...

Please help me to solve my javascript ptoblem

23 Jan 2023 by shivay 2023

Books Table CRUD Application using JavaScript table { ...

CRUD operations on multiple tables in a single class

2 Jul 2014 by onur_t

I have problems. I'm working on AdventureWorks2012 database. from single class to multiple tables, insert-update-delete-list operations have to do. How could this be? multiple tables and within tables in different numbers and different from each other's variables. how is this possible?...

SQL

CRUD Hibernate Strut2 2 tablet join

28 Mar 2015 by Member 10419621

I 'm trying to make a crud in Strud2 with hibernate and I can not combine two tables. Can you help meTable 1 is Trama@Entity@Table(name="trama", catalog="bd_1")public class Trama implements java.io.Serializable { private int traNoca; //Int private int catNoca; ...

Hibernate

struts

CRUD operation with Entity Framework in MVC4 model first approach

31 Jul 2015 by GopiKumar7

I need a simple example for CRUD operation in MVC4 using Model First approach of Entity Framework. Please anybody Help me to understand the concept clearly.

MVC4

how to CRUD operations in single view in mvc4?

18 Dec 2015 by JigxP

web.config BAL.CSusing System;using System.Collections.Generic;using System.ComponentModel.DataAnnotations;using System.Linq;using System.Web;namespace Insertdemo.Models{ public class Bal { public int uid { get; set; } [Required] ...

Update master with sum record of details

8 Oct 2017 by David2509

hello how i can updating total of master when each one detail have been inserted /updated/deleted, and not all details of master? if i used repository for master and repository of details, and if these repositories implements IDisposable, how to use the tow repositories with each their save...

entity-framework

MVC4

Mvc simple demo for member detail add delete edit update with controller and view simple demo required

Multithreadin backgroundworker async & await login to SQL C# WPF

11 Dec 2018 by TheBigBearNow

Hello all, I have a C# WPF application with a database of users. I have it so a user with the correct info can login and depending if they are an Admin or a Customer it will take them to their appropriate menu. Now I want to have a loading .gif while the program is checking the database for the...

16 Feb 2019 by Member 14146669

MVC Simple Demo for Member Detail Add Delete Edit Update With Controller and View Simple demo required What I have tried: MVC Simple Demo for Member Detail Add Delete Edit Update With Controller and View Simple demo required

Why cant we override methods from jparepository interface?

6 Aug 2019 by Null_Byte

why cant we override methods of jparepository interface such as findById(),and many more . why we need to create new interface for performing crud operations. What I have tried: i have tried to implement jparepository and try to override findAll() method but it throws exception.

Spring

How can I create folder and subfolder in sharepoint using rest

9 Sep 2019 by Ayush____

function createFolder(){ var folder_path; var mainFolder ="FolderNmae"; //var mainFolder ="FolderName/Subfoldername"; //create folder in subfolder var subfolder = ["ITT Files", "Tender Checklist", "Working Files", "Pre-Clarification Files", "Technical Proposal", "Commercial Porposal","Post Bid...

Sending data using CRUL in PHP

2 Nov 2020 by Komang Putra

I need help to fix this problem.. i already sending data with curl, but it doesnt appears in database here is my code ... curl.php

CS0106 the modifier 'public' is not valid for this item gridviewdemo

4 Jun 2022 by Manojkumar-dll

why is this showing like this and what's the error What I have tried: public partial class Gridviewdemo : System.Web.UI.Page { private string strConnectionString =...