----(SQL)Structured Query Language----

Part-1
-----------------------------------------
SQL Data Type:

1- Char(n)
2-varchar2(n)
3-Number(t)
4-Number(t,d)
5-Long
6-Date
7-Null










----(SQL)Structured Query Language----

Part-2
-----------------------------------------
Data Sub Languages

1-DDL- (CREATE,ALTER, DROP, TRUNCATE, COMMENT etc.)
2-DML- (SELECT, INSERT, UPDATE, DELETE, CALL, EXPLAIN PLAN, LOCK TABLE etc)
3-DCL- (GRANT, REVOKE, COMMIT, SAVEPOINT, ROLLBACK, SET TRANSACTION etc)














----(SQL)Structured Query Language----

Part-3
-----------------------------------------
Data Definition Language (DDL)

1-Create:
2-Alter:
3-Drop:
4-Desc :
5-Delete:
6-Constraint:
7-Comment:
8-Create index:
9-Drop index:









----(SQL)Structured Query Language----

Part-4
-----------------------------------------
Examples of DDL : Create statement

CREATE TABLE EMP_DETAILS
(
E_ID CHAR(5),
E_NAME VARCHAR2(15),
E_ADDRESS VARCHAR2(20),
E_DESIG CHAR(10),
E_JOINDATE DATE,
E_SALARY NUMBER(5)
)










----(SQL)Structured Query Language----

Part-5
-----------------------------------------
Examples of DDL : Insert statement

Insert INTO EMP_DETAILS VALUES('E1','CODER','VARANASI','CLERK','08-JUL-2023',5500)
Insert INTO EMP_DETAILS VALUES('E2','BABA','KANPUR','HR','15-MAY-2022',6500)

🚀 Unlocking Success: 6 Essential Coding Habits for Developers 🚀

Hello coder's community! 👋 As a passionate coder and ASP.NET developer, I believe that success in our field isn’t just about writing lines of code—it’s about cultivating the right habits. Today, I want to share some essential coding habits that can elevate your skills and propel you toward success. Let’s dive in! 💡

💡Understanding What Your Code Does:
Don’t just write code; understand its purpose. Visualize the bigger picture—how will your work impact end-users? Knowing the “why” behind your code leads to precision and personal growth1.

💡Keep It Organized:
Whether you’re a solo coder or part of a team, organization matters. Plan your work, set goals, and maintain a structured approach. Chaos breeds bugs, and we’re here to squash them! 🐞.

💡Continuous Learning and Community Engagement:
Learning never stops. Engage with coding communities, attend meetups, and connect with fellow developers. Share knowledge, ask questions, and stay motivated. We’re all in this together! 🌐

💡Patience, Young Padawan:
Programming can be frustrating, especially when bugs seem to multiply like rabbits. Take a deep breath, sip your favorite beverage, and tackle problems with patience. Rome wasn’t debugged in a day! 🕊.

💡Version Control Is Your Best Friend:
Git, SVN, Mercurial—pick your poison! Version control saves you from code catastrophes. Commit early, commit often, and never lose sleep over lost changes. 📜.

💡Document Like Your Code Depends on It:
Clear documentation is like a treasure map for future you (or your teammates). Explain your code, assumptions, and intentions. Your future self will thank you! 🗺.


🔗 Action Time:

🚀Share this post with fellow coders who crave success.
🚀Follow me for more coding insights and tips.
🚀Subscribe to my channel #CoderBaba for upcoming tutorials and project walkthroughs.

Remember, #HabitsForCoders isn’t just a hashtag—it’s a mindset. Let’s build habits that shape our success! 🚀💻

Stay curious, stay coding! 🤓

[CoderBaba] ASP.NET Developer | Coding Enthusiast Connect with me: YouTube

How to write Save button code in aspdotnet C#
protected void btnAdd_Click(object sender, EventArgs e)
{
if (checkDuplicateBook())
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "swal('Error','Error! Book Already Exists ...try some other Book ID','error')", true);
return;
}

AddBooks();
BindGridData();
}

private bool checkDuplicateBook()
{
using (SqlCommand cmd = new SqlCommand("spgetBookBYID", dbcon.GetCon()))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@book_id", txtBookID.Text.Trim());
using (DataTable dt2 = dbcon.Load_Data(cmd))
{
return dt2.Rows.Count >= 1;
}
}
}

private void AddBooks()
{
string genres = string.Join(",", ListBoxGenre.Items.Cast<ListItem>().Where(li => li.Selected).Select(li => li.Text));

string filename = Path.GetFileName(FileUpload1.PostedFile.FileName);
string filepath = "~/book_img/" + filename;
FileUpload1.SaveAs(Server.MapPath(filepath));

using (SqlCommand cmd = new SqlCommand("sp_Insert_Up_Del_BookInventory", dbcon.GetCon()))
{
cmd.CommandType = CommandType.StoredProcedure;
AddParameter(cmd);
cmd.Parameters.AddWithValue("@StatementType", "Insert");
cmd.Parameters.AddWithValue("@genre", genres);
cmd.Parameters.AddWithValue("@book_img_link", filepath);
string alertScript = dbcon.InsertUpdateData(cmd)
? "swal('Success','Books Addedd Successfully','success')"
: "swal('Error','Error! record not Inserted ...try again','error')";
ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", alertScript, true);
}

ClearControl();
Autogenrate();
}

private void AddParameter(SqlCommand cmd)
{
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@book_id", txtBookID.Text.Trim());
// Add other parameters here...
}

Google GenAI Hackathon APAC edition Registration Now
Last Date Fri, 08 March 2024
https://hack2skill.com/genai_hackathon_apac_edition

asp.net C# project with sql server database source code how to create login and Home page👇👇👇👇👇

Complete 6-month front-end roadmap to crack product-based companies in 2024.

𝗠𝗼𝗻𝘁𝗵 𝟭: 𝗙𝗼𝘂𝗻𝗱𝗮𝘁𝗶𝗼𝗻𝘀 𝗼𝗳 𝗪𝗲𝗯 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁

Basic HTML
- Form
- Import
- Elements
- Attributes
- Semantics
- Multimedia
- Block element

𝗕𝗮𝘀𝗶𝗰 𝗝𝗮𝘃𝗮𝗦𝗰𝗿𝗶𝗽𝘁 𝗖𝗼𝗻𝗰𝗲𝗽𝘁𝘀
- Scope
- Closure
- Functions
- Data types
- Event loop

𝗕𝗮𝘀𝗶𝗰 𝗖𝗦𝗦 𝗖𝗼𝗻𝗰𝗲𝗽𝘁𝘀
- Box Model
- Pseudo Classes
- Class and other selectors
- CSS type - Flex, Grid, normal

𝗠𝗼𝗻𝘁𝗵 𝟮: 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗝𝗮𝘃𝗮𝗦𝗰𝗿𝗶𝗽𝘁 𝗖𝗼𝗻𝗰𝗲𝗽𝘁𝘀

- How to center
- Media queries
- Bind/call/apply
- Design and CSS
- Pseudo Elements
- Class and inheritance
- Prototype and prototype chain
- All element states - active, hover

𝗠𝗼𝗻𝘁𝗵 𝟯: 𝗜𝗻𝘁𝗲𝗿𝗮𝗰𝘁𝗶𝘃𝗶𝘁𝘆 & 𝗦𝘁𝘆𝗹𝗶𝗻𝗴

- Grid
- DOM
- Mixins
- Flexbox
- CSS constants
- Page Styling Concepts
- Event loop continuation
- Pre-processors - SCSS or LESS

𝗠𝗼𝗻𝘁𝗵 𝟰: 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗝𝗮𝘃𝗮𝗦𝗰𝗿𝗶𝗽𝘁 𝗮𝗻𝗱 𝗔𝗣𝗜𝘀

- JWT
- XHR
- Cookie
- WebAPI
- Call stack
- Generators
- Task queue
- Async/await
- Working with Data
- APIs and Communication
- Local storage/Session storage
- REST/GraphQL/Socket connection

𝗠𝗼𝗻𝘁𝗵 𝟱: 𝗖𝗼𝗺𝗽𝗹𝗲𝘅 𝗪𝗲𝗯 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁 𝗦𝗸𝗶𝗹𝗹𝘀

- CORS
- OOPs concept
- Debugging Application
- Chrome Dev Tool Features
- Understanding V8 in depth
- Front-End Engineering Practices
- Design Patterns (Singleton, Observer, Module, etc.)

𝗠𝗼𝗻𝘁𝗵 6: 𝗥𝗲𝗮𝗰𝘁 𝗮𝗻𝗱 𝗠𝗼𝗱𝗲𝗿𝗻 𝗝𝗮𝘃𝗮𝗦𝗰𝗿𝗶𝗽𝘁 𝗙𝗿𝗮𝗺𝗲𝘄𝗼𝗿𝗸

- Routing
- Context API
- Virtual DOM
- React Hooks
- Custom Hooks
- State and Props
- Advanced React
- Introduction JSX
- React Ecosystem
- React Component
- Unit Testing with Jest
- Server-Side Rendering
- Redux/Flux for State Management

Apart from these, I would continuously focus on:

- Typescript
- Mocking Data
- Design Patterns in depth
- Understanding Webpack
- Advanced React patterns
- Babel, env, prettier, linter
- Tooling and Optimization
- Basic to advanced concepts for type-safety in JavaScript projects.

Follow @coder_baba

Dive into the world of Data Structures with our comprehensive lab practice guide, curated by @coder_baba . This PDF includes a range of exercises designed to enhance your understanding and proficiency in data structure algorithms. Each exercise is accompanied by detailed solutions to help you grasp the concepts effectively. Whether you are a beginner or looking to brush up on your skills, this resource offers invaluable hands-on practice to sharpen your programming abilities in data structures.

👆👆👆PDF Notes👆👆👆
Data Structure Lab Practice: Exercises and Solutions by @coder_Baba
Reaction bhi kar do ab uper