public void Search_by_book(string namee)
{
int counter = 0;
SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-VKVAVA1\SQLEXPRESS;Initial Catalog=project_is;Integrated Security=True");
con.Open();
SqlCommand com = new SqlCommand(@"show1_books ", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add(new SqlParameter("@name", namee));
SqlDataReader re1 = com.ExecuteReader();
while (re1.Read())
{
counter++;
small_user obj = new small_user();
obj.obj_small_user((string)re1["Book_name"]
, (string)re1["Auther_name"]
, (string)re1["Auther_birth"]
, (string)re1["Book_category"]
, (string)re1["Auther_nationality"]
, (string)re1["Book_price"]);
flowLayoutPanel1.Controls.Add(obj);
}
re1.Close();
con.Close();
if (counter == 0)
{
MessageBox.Show("Book is not found");
}
}
public void show_all_books()
{
SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-VKVAVA1\SQLEXPRESS;Initial Catalog=project_is;Integrated Security=True");
con.Open();
SqlCommand com = new SqlCommand(@"show_all_books ", con);
com.CommandType = CommandType.StoredProcedure;
SqlDataReader re1 = com.ExecuteReader();
while (re1.Read())
{
small_user obj = new small_user();
obj.obj_small_user((string)re1["Book_name"]
, (string)re1["Auther_name"]
, (string)re1["Auther_birth"]
, (string)re1["Book_category"]
, (string)re1["Auther_nationality"]
, (string)re1["Book_price"]);
flowLayoutPanel1.Controls.Add(obj);
}
re1.Close();
con.Close();
}
public void User(string namee)
{
int counter = 0;
SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-VKVAVA1\SQLEXPRESS;Initial Catalog=project_is;Integrated Security=True");
con.Open();
SqlCommand com = new SqlCommand(@"search1_auther ", con);
com.CommandType = CommandType.StoredProcedure;
SqlParameter mypar = com.Parameters.Add("@name", namee);
SqlDataReader re1 = com.ExecuteReader();
while (re1.Read())
{
counter++;
small_user obj = new small_user();
obj.obj_small_user((string)re1["Book_name"]
, (string)re1["Auther_name"]
, (string)re1["Auther_birth"]
, (string)re1["Book_category"]
, (string)re1["Auther_nationality"]
, (string)re1["Book_price"]);
flowLayoutPanel1.Controls.Add(obj);
}
re1.Close();
con.Close();
//GroupBox user = new GroupBox();
//user.Name = "user1";
//user.BackColor = Color.Red;
//Button menna = new Button();
//user.Controls.Add(menna);
//this.Controls.Add(user);
if (counter == 0)
{
MessageBox.Show("Auther is not found");
}
}