public static void AddToDb(SqlConnection connectionStr, Zaposlenik zaposlenik) { string name = zaposlenik.Name; int age = zaposlenik.Age; int id = 0; using (connectionStr) { SqlCommand command = new SqlCommand( "SELECT id FROM users;", connectionStr); connectionStr.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { id = reader.GetInt32(0); } } id = id + 1; reader.Close(); string queryString = $"Insert into users values ({id},'{name}',{age});"; SqlDataAdapter adapter = new SqlDataAdapter(queryString, connectionStr); DataSet newZaposlenik = new DataSet(); adapter.Fill(newZaposlenik, "users"); } connectionStr.Close(); return; }
public List <Zaposlenik> HasRows(SqlConnection connectionStr) { string name = ""; int age = 0; Zaposlenik zaposlenik; using (connectionStr) { SqlCommand command = new SqlCommand( "SELECT username, age FROM users;", connectionStr); connectionStr.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { name = reader.GetString(0); age = reader.GetInt32(1); zaposlenik = new Zaposlenik(name, age); popis.Add(zaposlenik); } } reader.Close(); connectionStr.Close(); } return(popis); }