DBMS Mini Project - Part 12 | Add and view data in local databse using Stored procedures in c#

Dbms mini project tutorial: Library management System, with C# and Local Database. Created exclusively for beginners, includes detailed explanation.

This is the part of the DBMS mini project series
In this video, we have discussed how you can add data and view data in the front end from a local database in visual studio, all using stored procedures

If you have not checked out the previous video I strongly recomend you to ckeck it out (Links below!!).

Links:
Part 13:(Search and delete data in local databse using Stored procedures in c#)

Part 11: (User controls in c#)

PART 10: (creating a sliding pannel in c#)

PART 14:(Updating data in the database, and Transactions logic)

PART 9:(Customized titlebar in c# )

PART 8:(Transition between two forms with fade effect)

PART 7:(Fetching Data from Local Database)

PART 6:(Adding Local database to your project in Visual Studio 2017)

PART 5:(Database and Tables)

PART 4:(Coding the log in button)

PART 3:(Adding detail to your log in form)

IF YOU FIND THE VIDEO USEFUL, PLEASE LIKE AND SHARE IT.
SUBSCRIBE TO MY CHANNEL TO GET REGULAR UPDATES.

Comment below your Doubts and suggestions,
Thanks!!

-~-~~-~~~-~~-~-
Please watch: "DBMS Mini Project - Part 15 | Triggers in Visual studio local database"
-~-~~-~~~-~~-~-

[EldhosePA]

Please read this before you comment.

1.
Before posting a doubt here first check it up on the internet. 90% of the problems you face would have been already faced by someone, and most likely someone else would have already found a solution to your problem. If you don’t find it in the internet, then check the comments below if someone has already posted the same problem. Only if your problem is unique, and you could not find a solution after through search on the internet, you should post it here.

2.
You need to keep in mind that I made this series more than two years ago. Ever since this series was released, Microsoft visual studio has undergone Several Updates. Also, from the time I made this series until today, I worked on several other projects, on totally different domains and technologies. So, it is obvious that I don’t remember most of this project today. Despite this, I still try to help people in the best way I can. I’m sorry if I can’t help you fix your problem today.

3.
Please be polite while you post your comments. I’m not an expert in C#. I did this project while I was studying my Bachelors of Engineering, and at that time there was no such series that explained me the basics I needed to know. So I thought uploading this series on YouTube will help students like you in your projects. This series is offered FREELY on YouTube. If you find this series is not up to your expectations, you can always BUY a course from an “EXPERT” on e-learning platforms like Udemy, edx etc.. . Peace.

4.
Towards the end of this project (about part 15), I lost the entire source code to this project due to a hard disk failure in my computer, and hence this series is not fully complete. However, if you have thoroughly understood all videos from part 1 to 15, you can easily complete it yourself. I have covered all the tough and confusing parts about this project. Also towards the end I have explained to you how to go ahead and finish it. If you have been just trying to copy my code and not understand the concepts, you will not be able to complete this project.

5.

Thank you for your time and understanding.

Eldhose P A :)

[souravnghorpade]

During connecting the database when you are creating the connection string i.e copy pasting it you can skip the @ symbol and this will solve the error with respect to the / in the path
It worked for me in the 2022 version of visual studio

[ashrutsharma]

couldn't add new data ERROR :INSERT statement conflicted with FOREIGN key constraint "FK_books_ToTable".The conflict occurred in database: dbo.department, column :"depId".

[shitalkadam]

I am getting error 'A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Specified LocalDB instance name is invalid."
Please can anyone help????

[sindhurajr]

whenever i added new value it is not stored in the database, can u please help me to resolve this problem

[babithanaginibn]

Identify_insert in set to off problem while adding an item

[jjabrams]

) DataGrid is working fine but when I'm trying to add a new book it's throwing exception because it's expecting data for the Borrower ID parameter which I'm not supplying. Please show us how to do that

[roshikdahal]

Values given from gui is not storing in database only in Stored procedures.. please help

[subharanjanghoshal]

I have the following doubts:
1) You haven't said anything about the combo box, I mean, how to make it fetch data from the Department Table.
2) The text of the combo box is a string but the Dep_Id column in the table is an int. How is it possible to add the string type data into an int type field without any datatype conversion?
3) DataGrid is working fine but when I'm trying to add a new book it's throwing exception because it's expecting data for the Borrower ID parameter which I'm not supplying. Please show us how to do that.
4) Please show us how to create those text boxes having single border at the bottom.
Thanks again :-)

[umeshk]

Sir add the values in front end cannot storede in datagrideview and back end please help me sir

[ramanujamramaswamy]

Hi. Thanks for the well made tutorial!
Would you be able to help with importing (adding) data to this local database through excel?

[asiffity]

Really hope your still answering question but im doing a project for my couse similler to this had to make small changes but im getting this
"Error CS1503 Argument 2: cannot convert from to
Any idea why?

[supreethnshekar]

I did everything in this video and when I click start, the program runs and when I click on "books" in app body, it terminates and I get an error "System.Argument.Exception: Invalid value for key 'attachdbfilename'

Please help

[kayvee]

Throw an exception as violation of primary key. error code 2627, even if I am inputting unique value in primary field accNo during add new record to Books Table. Please solve my problem.

[saurabhloya]

Error CS0029 Cannot implicitly convert type 'string' to 'System.Windows.Forms.Label' LMS 274 Active

[ujwal_mahindrakar]

Sir when I click on update Visual studio restarts, and again I retype all the SQL query and once again when I click on update it restarts .. Any solution sir?

[charmimeswani]

Hey your vedios are amazing!
Doing this step.. When I click on stored procedures there is no response. Like nothing happens when I click on stored procedureres.. Can u please help me.
Thankyou

[shivaniagarwal]

sir while adding values to the tables I cannot enter after one row and it shows a error message i.e "no row was updated.
the​ data in row 1 was not commited.
error source : .net sqlclient data provider.
error message: the Insert statement conflicted with the foreign key constraint "fk books to table".

[kaushikkotian]

hey i wanted to add button called buy to each datagridview row . how can i implement it?

[nishitshah]

Hi, I'm not insert data in database so i need your help can you help me?