public static void LoadPublicher(SqlDataReader reader) { while (reader.Read()) { Publichers publicher = new Publichers(); publicher.PublicherID = (int)reader["PublicherID"]; publicher.Title = reader["Title"].ToString(); publichers.Add(publicher); } }
public static Publichers GetPublicher(int id) { Publichers publicher = new Publichers(); SearchConnect(); //if (!DataBase.GetStateConnection()) //{ // if (DataBase.GetSqlConnection().State == ConnectionState.Open) // { // string query = string.Format("select * from Publichers where PublicherID = {0}", id.ToString()); // SqlCommand command = new SqlCommand(query, DataBase.Sql); // SqlDataReader reader = command.ExecuteReader(); // reader.Read(); // publicher.PublicherID = (int)reader["PublicherID"]; // publicher.Title = reader["Title"].ToString(); // reader.Close(); // } //} //else //{ // string query = string.Format("select * from Publichers where PublicherID = {0}", id.ToString()); // SqlCommand command = new SqlCommand(query, DataBase.Sql); // SqlDataReader reader = command.ExecuteReader(); // reader.Read(); // publicher.PublicherID = (int)reader["PublicherID"]; // publicher.Title = reader["Title"].ToString(); // reader.Close(); //} foreach (Publichers pbl in PublichersManager.Publichers) { if (pbl.PublicherID == id) { publicher = pbl; } } return(publicher); }
public static Publichers GetPublicher(int id) { Publichers publicher = new Publichers(); SearchConnect(); //if (!DataBase.GetStateConnection()) //{ // if (DataBase.GetSqlConnection().State == ConnectionState.Open) // { // string query = string.Format("select * from Publichers where PublicherID = {0}", id.ToString()); // SqlCommand command = new SqlCommand(query, DataBase.Sql); // SqlDataReader reader = command.ExecuteReader(); // reader.Read(); // publicher.PublicherID = (int)reader["PublicherID"]; // publicher.Title = reader["Title"].ToString(); // reader.Close(); // } //} //else //{ // string query = string.Format("select * from Publichers where PublicherID = {0}", id.ToString()); // SqlCommand command = new SqlCommand(query, DataBase.Sql); // SqlDataReader reader = command.ExecuteReader(); // reader.Read(); // publicher.PublicherID = (int)reader["PublicherID"]; // publicher.Title = reader["Title"].ToString(); // reader.Close(); //} foreach (Publichers pbl in PublichersManager.Publichers) { if (pbl.PublicherID == id) publicher = pbl; } return publicher; }
public Publicher(Publichers pbl, string tl) { publicherFromList = pbl; title = tl; }
public Form3(Publichers pbl) { pblcrs = pbl; type = 3; InitializeComponent(); for (int i = 0; i < 2; i++) { Label lb = new Label(); lb.Location = new System.Drawing.Point(5, i * 20 + i * 2 + 5); lb.AutoSize = true; switch (i) { case 0: lb.Text = "PublicherID :"; break; case 1: lb.Text = "Title :"; break; default: break; } TextBox tB = new TextBox(); tB.Location = new System.Drawing.Point(90, i * 20 + i * 2 + 5); tB.Size = new System.Drawing.Size(222, 20); switch (i) { case 0: tB.Text = pbl.PublicherID.ToString(); tB.ReadOnly = true; break; case 1: tB.Text = pbl.Title.ToString(); break; default: break; } this.Controls.Add(lb); this.Controls.Add(tB); //Console.WriteLine("{0}: {1}", reader.GetName(i), reader[i]); } }