Scribd
Upload
7 views6 pages

Old Code

The document is a C# code for a Windows Forms application that manages a book database. It includes functionalities for adding, editing, and deleting books, as well as displaying them in a grid format. The application connects to a SQL database to perform CRUD operations on the book records.

Uploaded by

Syed Sajid
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
7 views6 pages

Old Code

The document is a C# code for a Windows Forms application that manages a book database. It includes functionalities for adding, editing, and deleting books, as well as displaying them in a grid format. The application connects to a SQL database to perform CRUD operations on the book records.

Uploaded by

Syed Sajid
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

//using System;

//using [Link];
//using [Link];
//using [Link];
//using [Link];
//using [Link];
//using [Link];
//namespace WindowsFormsApp1
//{
// public partial class frmBookManager : Form
// {
// DataTable dataTable;
// int editRowIndex = -1;

// public frmBookManager()
// {
// InitializeComponent();
// //InitializeTable();
// CustomizeGridStyle();
// Reset();
// LoadBooksFromDatabase();

// }
// //private void LoadBooksFromDatabase()
// //{
// // [Link](); // Clear existing in-memory table

// // using (SqlConnection conn = new


SqlConnection([Link]["MyConn"].ConnectionString))
// // {
// // string query = "SELECT ID, BookTitle AS [Book Title],
AuthorName AS [Author Name], CASE WHEN Available = 1 THEN 'Yes' ELSE 'No' END AS
Available FROM BookManagings";
// // SqlDataAdapter adapter = new SqlDataAdapter(query, conn);
// // [Link](dataTable);
// // }

// // UpdateTotalBooksLabel();
// //}
// private void LoadBooksFromDatabase()
// {
// dataTable = [Link](); // ← updated
// [Link] = dataTable;

// UpdateTotalBooksLabel();
// }
// private void CustomizeGridStyle()
// {
// [Link] = new Font("Segoe UI",
10F, [Link]);
// [Link] =
[Link];

// [Link] = new Font("Segoe UI", 10F,


[Link]);

// [Link] = [Link];
// [Link] = 28;
// }

// //private void InitializeTable()


// //{
// // dataTable = new DataTable();
// // [Link]("ID");
// // [Link]("Sr#", typeof(int));
// // [Link]("Book Title");
// // [Link]("Author Name");
// // [Link]("Available");
// // [Link] = dataTable;
// // [Link]["ID"].Visible = false;
// //}

// private void Reset()


// {
// [Link] = "";
// [Link] = "";
// [Link] = false;
// [Link] = false;
// [Link] = false;
// [Link] = false;
// [Link] = false;
// [Link] = false;
// [Link] = false;
// [Link] = true;
// editRowIndex = -1;
// [Link] = false;
// }

// private void btnAddNew_Click(object sender, EventArgs e)


// {
// [Link] = true;
// [Link] = true;
// [Link] = true;
// [Link] = true;
// [Link] = true;
// [Link] = false;
// [Link]();
// }
// //private void btnSave_Click(object sender, EventArgs e)
// //{
// // if ([Link]([Link]))
// // {
// // [Link]("Please enter the Book Title.");
// // [Link]();
// // return;
// // }

// // if ([Link]([Link]))
// // {
// // [Link]("Please enter the Author Name.");
// // [Link]();
// // return;
// // }

// // if (editRowIndex == -1)
// // {
// // // INSERT
// // Guid id = [Link]();
// // using (SqlConnection conn = new
SqlConnection([Link]["MyConn"].ConnectionString))
// // {
// // string insertQuery = "INSERT INTO BookManagings (ID,
BookTitle, AuthorName, Available) VALUES (@ID, @Title, @Author, @Available)";
// // SqlCommand cmd = new SqlCommand(insertQuery, conn);
// // [Link]("@ID", id);
// // [Link]("@Title", [Link]);
// // [Link]("@Author", [Link]);
// // [Link]("@Available",
[Link]);
// // [Link]();
// // [Link]();
// // }

// // [Link]("Book added successfully.", "Info",


[Link], [Link]);
// // }
// // else
// // {
// // // UPDATE
// // DataGridViewRow gridRow = [Link][editRowIndex];
// // Guid bookId = [Link]([Link]["ID"].[Link]());

// // using (SqlConnection conn = new


SqlConnection([Link]["MyConn"].ConnectionString))
// // {
// // string updateQuery = "UPDATE BookManagings SET BookTitle =
@Title, AuthorName = @Author, Available = @Available WHERE ID = @ID";
// // SqlCommand cmd = new SqlCommand(updateQuery, conn);
// // [Link]("@ID", bookId);
// // [Link]("@Title", [Link]);
// // [Link]("@Author", [Link]);
// // [Link]("@Available",
[Link]);
// // [Link]();
// // [Link]();
// // }

// // [Link]("Book updated successfully.", "Info",


[Link], [Link]);
// // }

// // LoadBooksFromDatabase();

// // UpdateTotalBooksLabel();
// // Reset();
// //}
// private void btnSave_Click(object sender, EventArgs e)
// {
// if ([Link]([Link]))
// {
// [Link]("Please enter the Book Title.");
// [Link]();
// return;
// }
// if ([Link]([Link]))
// {
// [Link]("Please enter the Author Name.");
// [Link]();
// return;
// }

// string title = [Link]();


// string author = [Link]();
// bool available = [Link];

// if (editRowIndex == -1)
// {
// // INSERT
// DataTable result = [Link](title, author,
available);
// [Link]("Book added successfully.", "Info",
[Link], [Link]);
// }
// else
// {
// // UPDATE
// int id =
Convert.ToInt32([Link][editRowIndex].Cells["ID"].Value);
// DataTable result = [Link](title, author,
available, id);
// [Link]("Book updated successfully.", "Info",
[Link], [Link]);
// }

// LoadBooksFromDatabase();
// Reset();
// }

// private void UpdateTotalBooksLabel()


// {
// [Link] = "Total Books: " +
[Link]();
// }

// private void btnEdit_Click(object sender, EventArgs e)


// {
// if (editRowIndex >= 0)
// {
// [Link] = true;
// [Link] = true;
// [Link] = true;
// [Link] = true;
// [Link] = false;
// [Link] = true;
// [Link] = false;
// }
// }

// private void btnCancel_Click(object sender, EventArgs e)


// {
// Reset();
// }
// private void gridBooks_DoubleClick(object sender, EventArgs e)
// {
// if ([Link] != null && [Link] >= 0)
// {
// DataGridViewCellEventArgs args = new DataGridViewCellEventArgs(0,
[Link]);
// gridBook_CellClick(sender, args);
// }
// }

// private void gridBook_CellClick(object sender, DataGridViewCellEventArgs


e)
// {
// if ([Link] >= 0)
// {
// DataGridViewRow row = [Link][[Link]];
// [Link] = [Link]["Book Title"].[Link]();
// [Link] = [Link]["Author Name"].[Link]();
// [Link] = [Link]["Available"].[Link]() ==
"Yes";
// editRowIndex = [Link];

// [Link] = true;
// [Link] = false;
// [Link] = false;
// [Link] = true;
// [Link] = true;
// [Link] = false;
// [Link] = false;
// [Link] = false;
// }
// }

// private void GridBooks_CellContentClick(object sender,


DataGridViewCellEventArgs e)
// {

// }

// //private void BtnDelete_Click(object sender, EventArgs e)


// //{
// // if (editRowIndex >= 0 && editRowIndex < [Link])
// // {
// // var result = [Link]("Are you sure you want to delete
this book?", "Confirm Delete", [Link], [Link]);
// // if (result == [Link])
// // {
// // Guid bookId =
[Link]([Link][editRowIndex].Cells["ID"].[Link]());

// // using (SqlConnection conn = new


SqlConnection([Link]["MyConn"].ConnectionString))
// // {
// // string deleteQuery = "DELETE FROM BookManagings WHERE
ID = @ID";
// // SqlCommand cmd = new SqlCommand(deleteQuery, conn);
// // [Link]("@ID", bookId);
// // [Link]();
// // [Link]();
// // }

// // [Link]("Book deleted successfully.", "Deleted",


[Link], [Link]);
// // LoadBooksFromDatabase();
// // Reset();
// // }
// // }
// // else
// // {
// // [Link]("Please select a book to delete.", "No
Selection", [Link], [Link]);
// // }
// //}
// private void BtnDelete_Click(object sender, EventArgs e)
// {
// if (editRowIndex >= 0 && editRowIndex < [Link])
// {
// var result = [Link]("Are you sure you want to delete
this book?", "Confirm Delete", [Link], [Link]);
// if (result == [Link])
// {
// int bookId =
Convert.ToInt32([Link][editRowIndex].Cells["ID"].Value);
// [Link](bookId);
// [Link]("Book deleted successfully.", "Deleted",
[Link], [Link]);
// LoadBooksFromDatabase();
// Reset();
// }
// }
// else
// {
// [Link]("Please select a book to delete.", "No
Selection", [Link], [Link]);
// }
// }

// private void Label1_Click(object sender, EventArgs e)


// {

// }

// private void GridBooks_CellContentClick_1(object sender,


DataGridViewCellEventArgs e)
// {

// }

// private void LblTotalBooks_Click(object sender, EventArgs e)


// {

// }
// }
//}

You might also like